Thread: [phpwiki-checkins] CVS: phpwiki/lib mysql.php,1.10.2.1,1.10.2.2

Update of /cvsroot/phpwiki/phpwiki/lib
In directory usw-pr-cvs1:/tmp/cvs-serv10849/lib
Modified Files:
 Tag: release-1_2-branch
	mysql.php 
Log Message:
Fixed SF Bug #233898. (MySQL backend insensitive to case in page names.)
Note that this involves a change to the MySQL schema. A convenient
mysql script, schemas/update.mysql.1.2.0-1.2.1, is provided which can
be used to update your schema in-place.
Index: mysql.php
===================================================================
RCS file: /cvsroot/phpwiki/phpwiki/lib/mysql.php,v
retrieving revision 1.10.2.1
retrieving revision 1.10.2.2
diff -C2 -r1.10.2.1 -r1.10.2.2
*** mysql.php	2001年08月18日 00:35:10	1.10.2.1
--- mysql.php	2001年08月18日 03:57:27	1.10.2.2
***************
*** 214,226 ****
 $clause = '';
 while($term) {
! $word = "$term";
 	 if ($word[0] == '-') {
 	 $word = substr($word, 1);
! 	 $clause .= "not ($column like '%$word%') ";
 	 } else {
! 	 $clause .= "($column like '%$word%') ";
 	 }
 	 if ($term = strtok(' '))
! 	 $clause .= 'and ';
 }
 return $clause;
--- 214,226 ----
 $clause = '';
 while($term) {
! $word = strtolower("$term");
 	 if ($word[0] == '-') {
 	 $word = substr($word, 1);
! 	 $clause .= "not (LCASE($column) like '%$word%') ";
 	 } else {
! 	 $clause .= "(LCASE($column) like '%$word%') ";
 	 }
 	 if ($term = strtok(' '))
! 	 $clause .= 'AND ';
 }
 return $clause;