From f93fdcef8662734f10f58c92da509b86e148d44c Mon Sep 17 00:00:00 2001 From: Damyon Wiese Date: Wed, 16 Jan 2013 13:40:23 +0800 Subject: [PATCH] MDL-37546 Assignment fix assign_get_recent_mod_activity code cleanup regression. --- mod/assign/lib.php | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) diff --git a/mod/assign/lib.php b/mod/assign/lib.php index e2d7e01b872..b933f0ad4a2 100644 --- a/mod/assign/lib.php +++ b/mod/assign/lib.php @@ -616,13 +616,13 @@ function assign_get_recent_mod_activity(&$activities, $userfields = user_picture::fields('u', null, 'userid'); - if (!$submissions = $DB->get_records_sql('SELECT asb.id, asb.timemodified, - $userfields - FROM {assign_submission} asb - JOIN {assign} a ON a.id = asb.assignment - JOIN {user} u ON u.id = asb.userid - $groupjoin - WHERE asb.timemodified > :timestart AND + if (!$submissions = $DB->get_records_sql('SELECT asb.id, asb.timemodified, ' . + $userfields . + ' FROM {assign_submission} asb + JOIN {assign} a ON a.id = asb.assignment + JOIN {user} u ON u.id = asb.userid ' . + $groupjoin . + ' WHERE asb.timemodified > :timestart AND a.id = :cminstance ' . $userselect . ' ' . $groupselect . ' ORDER BY asb.timemodified ASC', $params)) { -- 2.43.0