In-Portal Issue Tracker

Index: search_helper.php
===================================================================
--- search_helper.php	(revision 12883)
+++ search_helper.php	(working copy)
@@ -71,37 +71,36 @@
 
 				switch ($sign) {
 					case '+':
-						$plus_conditions[] = implode(' LIKE "%'.$keyword.'%" OR ', $fields).' LIKE "%'.$keyword.'%"';
+						$plus_conditions[] = implode(" LIKE '%" . $keyword . "%' OR ", $fields) . " LIKE '%" . $keyword . "%'";
 						break;
 
 					case '-':
 						foreach ($fields as $field) {
-							$condition[] = $field.' NOT LIKE "%'.$keyword.'%" OR '.$field.' IS NULL';
+							$condition[] = $field . " NOT LIKE '%" . $keyword . "%' OR " . $field . ' IS NULL';
 						}
-						$minus_conditions[] = '('.implode(') AND (', $condition).')';
+						$minus_conditions[] = '(' . implode(') AND (', $condition) . ')';
 						break;
 
 					case '':
-						$keyword = str_replace('"', '\"', $keyword);
-						$normal_conditions[] = implode(' LIKE "%'.$keyword.'%" OR ', $fields).' LIKE "%'.$keyword.'%"';
+						$normal_conditions[] = implode(" LIKE '%" . $keyword . "%' OR ", $fields) . " LIKE '%" . $keyword . "%'";
 						break;
 				}
 			}
 
 			// building where clause
 			if ($normal_conditions) {
-				$where_clause = '('.implode(') OR (', $normal_conditions).')';
+				$where_clause = '(' . implode(') OR (', $normal_conditions) . ')';
 			}
 			else {
 				$where_clause = '1';
 			}
 
 			if ($plus_conditions) {
-				$where_clause = '('.$where_clause.') AND ('.implode(') AND (', $plus_conditions).')';
+				$where_clause = '(' . $where_clause . ') AND (' . implode(') AND (', $plus_conditions) . ')';
 			}
 
 			if ($minus_conditions) {
-				$where_clause = '('.$where_clause.') AND ('.implode(') AND (', $minus_conditions).')';
+				$where_clause = '(' . $where_clause . ') AND (' . implode(') AND (', $minus_conditions) . ')';
 			}
 
 			return $where_clause;