CSupportSearch::GetSQLfilter

static function GetSQLfilter($s, $idName, $titleName, $messageName)
{
	global $DB;
	$res = "";
	$and = "";
	$arrQ = explode("^", $s);
	foreach($arrQ as $k => $v)
	{
		if(substr_count($v, "%") > 0)
		{
			$res .= self::StrInEXISTS($and, $idName, "LIKE", $v);
		}
		else
		{
			$resArr = stemming($v, LANGUAGE_ID);
			if(count($resArr) > 0)
			{
				foreach($resArr as $k2 => $v2)
				{
					$res .= self::StrInEXISTS($and, $idName, "=", $k2);
					$and = " AND";
				}
			}
			else
			{
				$res .= "n" . $and . " ($titleName = '" . $DB->ForSql($v) . "' OR $messageName = '" . $DB->ForSql($v) . "')";
			}
		}
		$and = " AND";
	}
	if($res != "") $res = "n(" . $res . "n)n";
	return $res;
}