From abfc0304e1cb538421dc8ad792ca475ffcda5980 Mon Sep 17 00:00:00 2001 From: tjhunt Date: Mon, 24 Nov 2008 04:55:57 +0000 Subject: [PATCH] role assign: Don't get duplicate records in potential_assignees_below_course user selector --- admin/roles/lib.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/admin/roles/lib.php b/admin/roles/lib.php index 647c508d25..517de9886a 100644 --- a/admin/roles/lib.php +++ b/admin/roles/lib.php @@ -1006,8 +1006,8 @@ class potential_assignees_below_course extends role_assign_user_selector_base { } $roleids = '('.implode(',', $validroleids).')'; - $fields = 'SELECT ' . $this->required_fields_sql('u'); - $countfields = 'SELECT COUNT(1)'; + $fields = 'SELECT DISTINCT ' . $this->required_fields_sql('u'); + $countfields = 'SELECT COUNT(DISTINCT u.id)'; $sql = " FROM {user} u JOIN {role_assignments} ra ON ra.userid = u.id -- 2.39.5