From 405f64c7fde7c67786484ac1bdea9b0ec86a56bd Mon Sep 17 00:00:00 2001 From: moodler Date: Fri, 15 Sep 2006 13:42:40 +0000 Subject: [PATCH] Fixed some SQL error --- lib/accesslib.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/lib/accesslib.php b/lib/accesslib.php index cf42c8142c..0986592dfa 100755 --- a/lib/accesslib.php +++ b/lib/accesslib.php @@ -2312,12 +2312,14 @@ function get_users_by_capability($context, $capability, $fields='u.*, ul.timeacc /// sorting out exceptions if ($exceptions) { $exceptionsql = "AND u.id NOT IN ($exceptions)"; + } else { + $exceptionsql = ''; } - /// if context is a course, then constrct sql for ul + /// if context is a course, then construct sql for ul if ($context->aggregatelevel == CONTEXT_COURSE) { $courseid = $context->instanceid; - $coursesql = "AND (ul.courseid = $courseid OR ISNULL(ul.courseid)"; + $coursesql = "AND (ul.courseid = $courseid OR ISNULL(ul.courseid))"; } /// sorting out roles with this capability set -- 2.39.5