Universal AJAX Live Search + VM3 - [VM2&3] Модификации и хаки

		switch ($phrase) {
			case 'exact':
				$wheres2 = array();
				// product_sku should be exact match
				$text = $db->quote("%$text%", TRUE);
				$wheres2[] = "p.product_sku LIKE $text";
				$wheres2[] = "a.product_name LIKE $text";
				$wheres2[] = "b.$category_field LIKE $text";
				if ($search_product_s_description)
					$wheres2[] = "a.product_s_desc LIKE $text";
				if ($search_product_description)
					$wheres2[] = "a.product_desc LIKE $text";
				if ($search_customfields)
					$wheres2[] = "(cf.customfield_value LIKE $text $customfield_ids_condition)";
				$where = '(' . implode (') OR (', $wheres2). ')';
				break;
			case 'all':
			case 'any':
			default:
				$words = explode (' ', $text);
				$wheres = array();
				foreach ($words as $word) {
					$wheres2 = array();
					// product_sku should be exact match
          $word = $db->quote("%$word%", TRUE);
					$wheres2[] = "p.product_sku LIKE $word";					
					$wheres2[] = "a.product_name LIKE $word";
					$wheres2[] = "b.$category_field LIKE $word";
					if ($search_product_s_description)
						$wheres2[] = "a.product_s_desc LIKE $word";
					if ($search_product_description)
						$wheres2[] = "a.product_desc LIKE $word";
					if ($search_customfields)
						$wheres2[] = "(cf.customfield_value LIKE $word $customfield_ids_condition)";

					$wheres[] = implode (' OR ', $wheres2);
				}
				$where = '(' . implode (($phrase == 'all' ? ') AND (' : ') OR ('), $wheres). ')';
				break;
		}
		switch($ordering) {
			case 'alpha':
				$order = 'a.product_name ASC';
				break;
			case 'category':
				$order = 'b.category_name ASC, a.product_name ASC';
				break;
			case 'popular':
				$order = 'a.product_name ASC';
				break;
			case 'newest':
				$order = 'p.created_on DESC';
				break;
			case 'oldest':
				$order = 'p.created_on ASC';
				break;
			default:
				$order = 'a.product_name ASC';
		}