From 5fd4e46dbd3c98d72caa51ffd8a6ff9c287b7ae3 Mon Sep 17 00:00:00 2001 From: stronk7 Date: Tue, 24 Oct 2006 18:29:34 +0000 Subject: [PATCH] Dropping some hardocded "mdl" prefixes. MDL-7202 Merged from MOODLE_17_STABLE --- lib/statslib.php | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/lib/statslib.php b/lib/statslib.php index 1f08cd8f78..e9c29c3ef7 100644 --- a/lib/statslib.php +++ b/lib/statslib.php @@ -791,17 +791,17 @@ function stats_get_course_users($course,$timesql) { $sql = "SELECT userid, primaryrole FROM ( SELECT active_course_users.userid, - (SELECT roleid FROM mdl_role_assignments outer_r_a INNER JOIN mdl_role outer_r ON outer_r_a.roleid=outer_r.id - INNER JOIN mdl_context c ON outer_r_a.contextid = c.id + (SELECT roleid FROM {$CFG->prefix}role_assignments outer_r_a INNER JOIN {$CFG->prefix}role outer_r ON outer_r_a.roleid=outer_r.id + INNER JOIN {$CFG->prefix}context c ON outer_r_a.contextid = c.id WHERE c.instanceid=".$course->id." AND c.contextlevel = ".CONTEXT_COURSE." AND outer_r_a.userid=active_course_users.userid - AND NOT EXISTS (SELECT 1 FROM mdl_role_assignments inner_r_a - INNER JOIN mdl_role inner_r ON inner_r_a.roleid = inner_r.id + AND NOT EXISTS (SELECT 1 FROM {$CFG->prefix}role_assignments inner_r_a + INNER JOIN {$CFG->prefix}role inner_r ON inner_r_a.roleid = inner_r.id WHERE inner_r.sortorder < outer_r.sortorder AND inner_r_a.userid = outer_r_a.userid AND inner_r_a.contextid = outer_r_a.contextid ) ) AS primaryrole - FROM (SELECT DISTINCT userid FROM mdl_log l WHERE course=".$course->id." AND ".$timesql." ) + FROM (SELECT DISTINCT userid FROM {$CFG->prefix}log l WHERE course=".$course->id." AND ".$timesql." ) active_course_users ) foo WHERE primaryrole IS NOT NULL"; if (!$users = get_records_sql($sql)) { -- 2.39.5