From 5c135dd4fde51578e66898e8741efb7f3fb9d3bb Mon Sep 17 00:00:00 2001 From: sam_marshall Date: Wed, 27 Sep 2006 11:21:59 +0000 Subject: [PATCH] Wiki: correct behaviour in Postgres with pages that have ' in name --- mod/wiki/ewikimoodlelib.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/mod/wiki/ewikimoodlelib.php b/mod/wiki/ewikimoodlelib.php index 1ab26bfa93..b2cb2d2e58 100644 --- a/mod/wiki/ewikimoodlelib.php +++ b/mod/wiki/ewikimoodlelib.php @@ -240,7 +240,7 @@ function ewiki_database_moodle($action, &$args, $sw1, $sw2) { $sql= "SELECT pagename AS id, version, flags" . (EWIKI_DBQUERY_BUFFER && ($field!="pagename") ? ", $field" : "") . " FROM " . $CFG->prefix.EWIKI_DB_TABLE_NAME . - " WHERE $field ILIKE '%".$content."%' and wiki=".$wiki_entry->id . + " WHERE $field ILIKE '%".anydb_escape_string($content)."%' and wiki=".$wiki_entry->id . " GROUP BY id, pagename, version, flags ". (EWIKI_DBQUERY_BUFFER && ($field!="pagename") ? ", $field" : "") ; break; -- 2.39.5