--- C:/Users/Pratt/workspace/ou-moodle-31/mod/quiz/report/statistics/Copy of qstats.php Tue Sep 23 17:50:59 2008 +++ C:/Users/Pratt/workspace/ou-moodle-31/mod/quiz/report/statistics/qstats.php Tue Sep 23 17:51:24 2008 @@ -39,6 +39,7 @@ } function get_records($quizid, $currentgroup, $groupstudents, $allattempts){ global $CFG; + $questionlist = join(array_keys($this->questions), ','); list($fromqa, $whereqa) = quiz_report_attempts_sql($quizid, $currentgroup, $groupstudents, $allattempts); $sql = 'SELECT qs.id, ' . 'qs.question, ' . @@ -51,6 +52,7 @@ "{$CFG->prefix}question_states qs, ". $fromqa.' '. 'WHERE ' .$whereqa. + 'AND qs.question IN ('.$questionlist.') '. 'AND qns.attemptid = qa.uniqueid '. 'AND qns.newgraded = qs.id'; $this->states = get_records_sql($sql);