From 4be6bced7f42b2b4d07e6e2d394c60b422bd1687 Mon Sep 17 00:00:00 2001 From: vyshane Date: Mon, 25 Sep 2006 02:04:11 +0000 Subject: [PATCH] Fixed sql query in assignment_get_unmailed_submissions() - we can't rely on user_students anymore. --- mod/assignment/lib.php | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/mod/assignment/lib.php b/mod/assignment/lib.php index 962546e0da..cbb8eb603d 100644 --- a/mod/assignment/lib.php +++ b/mod/assignment/lib.php @@ -2132,12 +2132,11 @@ function assignment_get_unmailed_submissions($starttime, $endtime) { return get_records_sql("SELECT s.*, a.course, a.name FROM {$CFG->prefix}assignment_submissions s, - {$CFG->prefix}assignment a, + {$CFG->prefix}assignment a WHERE s.mailed = 0 AND s.timemarked <= $endtime AND s.timemarked >= $starttime - AND s.assignment = a.id - AND s.userid = us.userid"); + AND s.assignment = a.id"); /* return get_records_sql("SELECT s.*, a.course, a.name FROM {$CFG->prefix}assignment_submissions s, -- 2.39.5