From ac57f7612258e8467b9357c5550bf2a504dd0361 Mon Sep 17 00:00:00 2001 From: toyomoyo Date: Fri, 20 Oct 2006 02:44:22 +0000 Subject: [PATCH] merged fox for MDL-7113, removing DISTINCT on TEXT field --- lib/accesslib.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/lib/accesslib.php b/lib/accesslib.php index 132cda8af2..6d823e658b 100755 --- a/lib/accesslib.php +++ b/lib/accesslib.php @@ -2911,7 +2911,7 @@ function get_roles_on_exact_context($context) { global $CFG; - return get_records_sql("SELECT DISTINCT r.* + return get_records_sql("SELECT r.* FROM {$CFG->prefix}role_assignments ra, {$CFG->prefix}role r WHERE ra.roleid = r.id @@ -2980,7 +2980,7 @@ function get_roles_with_override_on_context($context) { global $CFG; - return get_records_sql("SELECT DISTINCT r.* + return get_records_sql("SELECT r.* FROM {$CFG->prefix}role_capabilities rc, {$CFG->prefix}role r WHERE rc.roleid = r.id @@ -3003,7 +3003,7 @@ function get_roles_with_assignment_on_context($context) { global $CFG; - return get_records_sql("SELECT DISTINCT r.* + return get_records_sql("SELECT r.* FROM {$CFG->prefix}role_assignments ra, {$CFG->prefix}role r WHERE ra.roleid = r.id -- 2.39.5