From a05708ad612168a3f2edd5c13a45206ff036c1ff Mon Sep 17 00:00:00 2001 From: skodak Date: Sat, 16 Sep 2006 05:56:51 +0000 Subject: [PATCH] fixed $groupidsql in get_users_by_capability() --- lib/accesslib.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lib/accesslib.php b/lib/accesslib.php index 1110a8411d..4fcce4c180 100755 --- a/lib/accesslib.php +++ b/lib/accesslib.php @@ -2300,9 +2300,9 @@ function get_users_by_capability($context, $capability, $fields='u.*, ul.timeacc $groupjoin = 'INNER JOIN '.$CFG->prefix.'groups_members gm ON gm.userid = ra.userid'; if (is_array($groups)) { - $groupsql = 'AND gm.id IN ('.implode(',', $groups).')'; + $groupsql = 'AND gm.groupid IN ('.implode(',', $groups).')'; } else { - $groupsql = 'AND gm.id = '.$groups; + $groupsql = 'AND gm.groupid = '.$groups; } } else { $groupjoin = ''; -- 2.39.5