From 07e6860901d5534ac9dae189c6d94d6d4c1fb1f1 Mon Sep 17 00:00:00 2001
From: skodak <skodak>
Date: Sun, 15 Jun 2008 10:43:20 +0000
Subject: [PATCH] MDL-15094 added some overlook conversions - thanks to Eloy's
 script ;-)

---
 mod/quiz/report/statistics/statistics_table.php | 9 +++++----
 1 file changed, 5 insertions(+), 4 deletions(-)

diff --git a/mod/quiz/report/statistics/statistics_table.php b/mod/quiz/report/statistics/statistics_table.php
index 29150effc3..38941bb398 100644
--- a/mod/quiz/report/statistics/statistics_table.php
+++ b/mod/quiz/report/statistics/statistics_table.php
@@ -15,7 +15,8 @@ class quiz_report_statistics_table extends table_sql {
         $this->reporturl = $reporturl;
     }
     function build_table(){
-        global $CFG;
+        global $CFG, $DB;
+
         if ($this->rawdata) {
             // Define some things we need later to process raw data from db.
             $this->strtimeformat = get_string('strftimedatetime');
@@ -23,7 +24,7 @@ class quiz_report_statistics_table extends table_sql {
             //end of adding data from attempts data to table / download
             //now add averages at bottom of table :
             $averagesql = "SELECT AVG(qg.grade) AS grade " .
-                    "FROM {$CFG->prefix}quiz_grades qg " .
+                    "FROM {quiz_grades} qg " .
                     "WHERE quiz=".$this->quiz->id;
                     
             $this->add_separator();
@@ -34,7 +35,7 @@ class quiz_report_statistics_table extends table_sql {
             }
             if ($this->groupstudents){
                 $groupaveragesql = $averagesql." AND qg.userid IN ($this->groupstudents)";
-                $groupaverage = get_record_sql($groupaveragesql);
+                $groupaverage = $DB->get_record_sql($groupaveragesql);
                 $groupaveragerow = array($namekey => get_string('groupavg', 'grades'),
                         'sumgrades' => round($groupaverage->grade, $this->quiz->decimalpoints),
                         'feedbacktext'=> strip_tags(quiz_report_feedback_for_grade($groupaverage->grade, $this->quiz->id)));
@@ -44,7 +45,7 @@ class quiz_report_statistics_table extends table_sql {
                 }
                 $this->add_data_keyed($groupaveragerow);
             }
-            $overallaverage = get_record_sql($averagesql." AND qg.userid IN ($this->students)");
+            $overallaverage = $DB->get_record_sql($averagesql." AND qg.userid IN ($this->students)");
             $overallaveragerow = array($namekey => get_string('overallaverage', 'grades'),
                         'sumgrades' => round($overallaverage->grade, $this->quiz->decimalpoints),
                         'feedbacktext'=> strip_tags(quiz_report_feedback_for_grade($overallaverage->grade, $this->quiz->id)));
-- 
2.39.5