From 675ea3231cf1593bb07168cbeb8085b43966df1b Mon Sep 17 00:00:00 2001 From: Dan Poltawski Date: Tue, 13 Nov 2012 15:09:14 +0800 Subject: [PATCH] MDL-30545 - messagelib: use $DB->sql_concat() --- lib/messagelib.php | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/lib/messagelib.php b/lib/messagelib.php index ac09d975dea..f3e09f87e31 100644 --- a/lib/messagelib.php +++ b/lib/messagelib.php @@ -447,7 +447,8 @@ function message_get_providers_for_user($userid) { WHERE ra.userid = :userid AND rc.capability $capcondition AND rc.permission > 0 - AND (CONCAT(actx.path, '/') LIKE CONCAT(cctx.path, '/%') OR CONCAT(cctx.path, '/') LIKE CONCAT(actx.path, '/%'))"; + AND (".$DB->sql_concat('actx.path', "'/'")." LIKE ".$DB->sql_concat('cctx.path', "'/%'"). + " OR ".$DB->sql_concat('cctx.path', "'/'")." LIKE ".$DB->sql_concat('actx.path', "'/%'").")"; if (!empty($CFG->defaultfrontpageroleid)) { $frontpagecontext = context_course::instance(SITEID); @@ -469,7 +470,7 @@ function message_get_providers_for_user($userid) { WHERE rc.roleid = :frontpageroleid AND rc.capability $capcondition2 AND rc.permission > 0 - AND CONCAT(cctx.path, '/') LIKE :frontpagepathpattern"; + AND ".$DB->sql_concat('cctx.path', "'/'")." LIKE :frontpagepathpattern"; } $relevantcapabilities = $DB->get_records_sql_menu($sql, $params); -- 2.36.1