From 0441764040ea7ceb2ae20edb1357cc80616b42a2 Mon Sep 17 00:00:00 2001 From: stronk7 Date: Tue, 5 Sep 2006 18:55:16 +0000 Subject: [PATCH] Changed the get_users_by_capability() function to work with 1.7 DB compatible limit sentences. --- lib/accesslib.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/lib/accesslib.php b/lib/accesslib.php index 71a88dcfb2..fb533b37d3 100755 --- a/lib/accesslib.php +++ b/lib/accesslib.php @@ -2000,8 +2000,10 @@ function get_overridable_roles ($context) { * @param $capability - string capability * @param $fields - fields to be pulled * @param $sort - the sort order + * @param $limitfrom - number of records to skip (offset) + * @param $limitnum - number of records to fetch */ -function get_users_by_capability($context, $capability, $fields='distinct u.*', $sort='', $limit='') { +function get_users_by_capability($context, $capability, $fields='distinct u.*', $sort='', $limitfrom='', $limitnum='') { global $CFG; @@ -2028,7 +2030,7 @@ function get_users_by_capability($context, $capability, $fields='distinct u.*', $from = ' FROM '.$CFG->prefix.'user u LEFT JOIN '.$CFG->prefix.'role_assignments ra ON ra.userid = u.id '; $where = ' WHERE (ra.contextid = '.$context->id.' OR ra.contextid in '.$listofcontexts.') AND u.deleted = 0 AND ra.roleid in '.$roleids.' '; - return get_records_sql($select.$from.$where.$sort.$limit); + return get_records_sql($select.$from.$where.$sort, $limitfrom, $limitnum); } -- 2.39.5