MDL-24080 fixed debug warning and converted NOT LIKE

diff --git a/admin/report/customlang/locallib.php b/admin/report/customlang/locallib.php
index 42baf20..91d09b7 100644 (file)
--- 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)) {
         }
 
         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 {
         } 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";
         }
 
         $osql = " ORDER BY c.name, s.stringid";