From cdce12554276174f16012a2a1a46c37455e7c1f4 Mon Sep 17 00:00:00 2001 From: Petr Skoda Date: Sat, 4 Sep 2010 11:50:18 +0000 Subject: [PATCH] MDL-24079 custom lang report now using new sql_like() --- admin/report/customlang/locallib.php | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/admin/report/customlang/locallib.php b/admin/report/customlang/locallib.php index 7660675dd5d..42baf2066f3 100644 --- a/admin/report/customlang/locallib.php +++ b/admin/report/customlang/locallib.php @@ -493,18 +493,18 @@ class report_customlang_translator implements renderable { } if (!empty($filter->substring)) { - $sql .= " AND (s.original ".$DB->sql_ilike()." :substringoriginal OR - s.master ".$DB->sql_ilike()." :substringmaster OR - s.local ".$DB->sql_ilike()." :substringlocal)"; + $sql .= " AND (".$DB->sql_like('s.original', ':substringoriginal', false)." OR + ".$DB->sql_like('s.master', ':substringmaster', false)." OR + ".$DB->sql_like('s.local', ':substringlocal', false).")"; $params['substringoriginal'] = '%'.$filter->substring.'%'; $params['substringmaster'] = '%'.$filter->substring.'%'; $params['substringlocal'] = '%'.$filter->substring.'%'; } if (!empty($filter->helps)) { - $sql .= " AND s.stringid ".$DB->sql_ilike()." '%\\\\_help'"; + $sql .= " AND ".$DB->sql_like('s.stringid', '%\\\\_help', false); } else { - $sql .= " AND s.stringid NOT ".$DB->sql_ilike()." '%\\\\_link'"; + $sql .= " AND s.stringid NOT LIKE '%\\\\_link'"; //TODO: MDL-24080 } $osql = " ORDER BY c.name, s.stringid"; -- 2.36.1