From 47545d41611f4cb028097cc26a5c33f1f4e7edeb Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Fri, 6 Oct 2006 06:42:33 +0000
Subject: [PATCH] Removed some references to user_teachers that will probably
 cause a bug

---
 mod/exercise/locallib.php | 11 +++++++----
 1 file changed, 7 insertions(+), 4 deletions(-)

diff --git a/mod/exercise/locallib.php b/mod/exercise/locallib.php
index 6212aaef12..036547d71e 100644
--- a/mod/exercise/locallib.php
+++ b/mod/exercise/locallib.php
@@ -964,18 +964,21 @@ function exercise_list_submissions_for_admin($exercise) {
             $table->size = array ("*", "*", "*", "*", "*");
             $table->cellpadding = 2;
             $table->cellspacing = 0;
+
+            /// NOTE:  user_teachers was ripped from the following SQL without a proper fix - XXX TO DO
+
             if ($groupid) {
                 $stats = get_record_sql("SELECT COUNT(*) as count, AVG(grade) AS mean, 
                         STDDEV(grade) AS stddev, MIN(grade) AS min, MAX(grade) AS max 
                         FROM {$CFG->prefix}groups_members g, {$CFG->prefix}exercise_assessments a, 
-                        {$CFG->prefix}exercise_submissions s, {$CFG->prefix}user_teachers t  
+                        {$CFG->prefix}exercise_submissions s
                         WHERE g.groupid = $groupid AND s.userid = g.userid AND a.submissionid = s.id 
-                        AND a.userid = t.userid AND a.exerciseid = $exercise->id");
+                        AND a.exerciseid = $exercise->id");
             } else { // no group/all participants
                 $stats = get_record_sql("SELECT COUNT(*) as count, AVG(grade) AS mean, 
                         STDDEV(grade) AS stddev, MIN(grade) AS min, MAX(grade) AS max 
-                        FROM {$CFG->prefix}exercise_assessments a, {$CFG->prefix}user_teachers t 
-                        WHERE a.userid = t.userid AND a.exerciseid = $exercise->id");
+                        FROM {$CFG->prefix}exercise_assessments a
+                        WHERE a.exerciseid = $exercise->id");
             }   
             $table->data[] = array($stats->count, number_format($stats->mean * $exercise->grade / 100.0, 1), 
                     number_format($stats->stddev * $exercise->grade / 100.0, 1), 
-- 
2.39.5