From: Petr Skoda <skodak@moodle.org>
Date: Sat, 4 Sep 2010 14:43:11 +0000 (+0000)
Subject: MDL-24080 fixed debug warning and converted NOT LIKE
X-Git-Tag: v2.0.0-rc1~649
X-Git-Url: http://git.moodle.org/gw?p=moodle.git;a=commitdiff_plain;h=2225fb4809a11c716579bc62d9113674d73c9c3d;hp=16114b9db86e00bbf9b709cf287b5ec3ff4a3752

MDL-24080 fixed debug warning and converted NOT LIKE
---

diff --git a/admin/report/customlang/locallib.php b/admin/report/customlang/locallib.php
index 42baf2066f3..91d09b72e85 100644
--- a/admin/report/customlang/locallib.php
+++ b/admin/report/customlang/locallib.php
@@ -502,9 +502,11 @@ class report_customlang_translator implements renderable {
         }
 
         if (!empty($filter->helps)) {
-            $sql .= "   AND ".$DB->sql_like('s.stringid', '%\\\\_help', false);
+            $sql .= "   AND ".$DB->sql_like('s.stringid', ':help', false); //ILIKE
+            $params['help'] = '%\\\\_help';
         } else {
-            $sql .= "   AND s.stringid NOT LIKE '%\\\\_link'"; //TODO: MDL-24080
+            $sql .= "   AND ".$DB->sql_like('s.stringid', ':link', false, true, true); //NOT ILIKE
+            $params['link'] = '%\\\\_link';
         }
 
         $osql = " ORDER BY c.name, s.stringid";