Advertisement
stronk7

Untitled

May 5th, 2021
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. index b68e9513e7d..013a4b3f129 100644
  2. --- a/admin/tool/brickfield/classes/manager.php
  3. +++ b/admin/tool/brickfield/classes/manager.php
  4. @@ -635,7 +635,7 @@ class manager {
  5. $extrasql = !$courseid ? "" : "WHERE courseid = ?";
  6. // Count of activities per course.
  7. $countsql = "SELECT courseid, COUNT(DISTINCT (".$DB->sql_concat('areas.contextid', 'areas.component').")) AS activities
  8. - FROM {" . self::DB_AREAS . "} areas ". $extrasql ."GROUP BY areas.courseid";
  9. + FROM {" . self::DB_AREAS . "} areas ". $extrasql ." GROUP BY areas.courseid";
  10.  
  11. $recordscount = $DB->get_records_sql($countsql, $coursesqlval);
  12.  
  13. @@ -831,7 +831,7 @@ class manager {
  14. JOIN {" . self::DB_RESULTS . "} res ON res.contentid = ch.id
  15. JOIN {course_sections} sec ON area.itemid = sec.id
  16. WHERE area.tablename = :tablename AND area.courseid = :courseid
  17. - GROUP BY sec.id";
  18. + GROUP BY sec.section";
  19.  
  20. $params = [
  21. 'courseid' => $courseid,
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement