Changeset 6664 for trunk/include
- Timestamp:
- Jul 5, 2010, 11:18:14 PM (14 years ago)
- Location:
- trunk/include
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/include/functions_category.inc.php
r6654 r6664 407 407 { 408 408 if ( !empty($in) ) $in.=', '; 409 $in .= ' "'.$permalink.'"';409 $in .= '\''.$permalink.'\''; 410 410 } 411 411 $query =' -
trunk/include/functions_search.inc.php
r6518 r6664 394 394 if ( strlen($tokens[$i])==0) 395 395 continue; 396 $clauses[] = $field.' LIKE "'.$before.addslashes($tokens[$i]).$after.'"';396 $clauses[] = $field.' LIKE \''.$before.addslashes($tokens[$i]).$after.'\''; 397 397 } 398 398 … … 435 435 436 436 // Step 1 - first we find matches in #images table =========================== 437 $where_clauses='MATCH(i.name, i.comment) AGAINST( "'.$q.'"IN BOOLEAN MODE)';437 $where_clauses='MATCH(i.name, i.comment) AGAINST( \''.$q.'\' IN BOOLEAN MODE)'; 438 438 if (!empty($q_like_clause)) 439 439 { … … 453 453 $query = ' 454 454 SELECT i.id, 455 MATCH(i.name, i.comment) AGAINST( "'.$q.'"IN BOOLEAN MODE) AS weight455 MATCH(i.name, i.comment) AGAINST( \''.$q.'\' IN BOOLEAN MODE) AS weight 456 456 FROM '.IMAGES_TABLE.' i 457 457 WHERE '.implode("\n AND ", $where_clauses); … … 506 506 INNER JOIN '.USER_CACHE_CATEGORIES_TABLE.' ON id=cat_id 507 507 WHERE user_id='.$user['id'].' 508 AND MATCH(name, comment) AGAINST( "'.$q.'"IN BOOLEAN MODE)'.508 AND MATCH(name, comment) AGAINST( \''.$q.'\' IN BOOLEAN MODE)'. 509 509 get_sql_condition_FandF ( 510 510 array( 'visible_categories' => 'cat_id' ), "\n AND" -
trunk/include/section_init.inc.php
r6615 r6664 260 260 FROM '.CATEGORIES_TABLE.' 261 261 WHERE 262 uppercats LIKE "'.$page['category']['uppercats'].',%"'262 uppercats LIKE \''.$page['category']['uppercats'].',%\' ' 263 263 .get_sql_condition_FandF( 264 264 array
Note: See TracChangeset
for help on using the changeset viewer.