From 84dfbdd2f6a62d697d8195417d6dcbec05311dd0 Mon Sep 17 00:00:00 2001 From: gustav_delius Date: Tue, 16 Oct 2007 08:42:23 +0000 Subject: [PATCH] Fixed error in the SQL in get_users_by_capability() that made many things not work properly on the course front page. --- lib/accesslib.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/accesslib.php b/lib/accesslib.php index 18a3f7a8c9..dfa3ac4880 100755 --- a/lib/accesslib.php +++ b/lib/accesslib.php @@ -4159,7 +4159,7 @@ function get_users_by_capability($context, $capability, $fields='', $sort='', if (!empty($CFG->defaultfrontpageroleid) && ($context->id == $frontpagectx->id || strstr($context->path, '/'.$frontpagectx->id.'/'))) { $roles = get_roles_with_capability($capability, CAP_ALLOW, $context); if (in_array($CFG->defaultfrontpageroleid, array_keys($roles))) { - return get_records_sql("SELECT $fields FROM {$CFG->prefix}user ORDER BY $sort, $limitfrom, $limitnum"); + return get_records_sql("SELECT $fields FROM {$CFG->prefix}user u ORDER BY $sort", $limitfrom, $limitnum); } } -- 2.39.5