[phpwiki-checkins] CVS: phpwiki/lib/WikiDB/backend PearDB.php,1.7,1.8

[Geoffrey T. D. <da...@us...>]

Update of /cvsroot/phpwiki/phpwiki/lib/WikiDB/backend
In directory usw-pr-cvs1:/tmp/cvs-serv7137/lib/WikiDB/backend

Modified Files:
	PearDB.php 
Log Message:
Fix quoting of search expressions.  (Searches for words containing
'%', '\', or '_' were broken prior to this fix.)



Index: PearDB.php
===================================================================
RCS file: /cvsroot/phpwiki/phpwiki/lib/WikiDB/backend/PearDB.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -r1.7 -r1.8
*** PearDB.php	2001/10/29 17:57:24	1.7
--- PearDB.php	2001/11/07 21:12:47	1.8
***************
*** 458,461 ****
--- 458,462 ----
  
      function _sql_match_clause($word) {
+         $word = preg_replace('/(?=[%_\\\\])/', "\\", $word);
          $word = $this->_dbh->quoteString($word);
          return "LOWER(pagename) LIKE '%$word%'";
***************
*** 463,466 ****
--- 464,468 ----
  
      function _fullsearch_sql_match_clause($word) {
+         $word = preg_replace('/(?=[%_\\\\])/', "\\", $word);
          $word = $this->_dbh->quoteString($word);
          return "LOWER(pagename) LIKE '%$word%' OR content LIKE '%$word%'";