CSearchTitle::searchTitle

function searchTitle($phrase = "", $nTopCount = 5, $arParams = array(), $bNotFilter = false, $order = "")
{
	$DB = CDatabase::GetModuleConnection('search');
	$bOrderByRank = ($order == "rank");

	$sqlHaving = array();
	$sqlWords = array();
	if (!empty($this->_arPhrase))
	{
		$last = true;
		foreach (array_reverse($this->_arPhrase, true) as $word => $pos)
		{
			if ($last && !preg_match("/[\n\r \t]$/", $phrase))
			{
				$last = false;
				if (mb_strlen($word) >= $this->minLength)
					$s = $sqlWords[] = "ct.WORD like '".$DB->ForSQL($word)."%'";
				else
					$s = "";
			}
			else
			{
				$s = $sqlWords[] = "ct.WORD = '".$DB->ForSQL($word)."'";
			}

			if ($s)
				$sqlHaving[] = "(sum(".$s.") > 0)";
		}
	}

	if (!empty($sqlWords))
	{
		$bIncSites = false;
		$strSqlWhere = CSearch::__PrepareFilter($arParams, $bIncSites);
		if ($bNotFilter)
		{
			if (!empty($strSqlWhere))
				$strSqlWhere = "NOT (".$strSqlWhere.")";
			else
				$strSqlWhere = "1=0";
		}

		$strSql = "
			SELECT
				sc.ID
				,sc.MODULE_ID
				,sc.ITEM_ID
				,sc.TITLE
				,sc.PARAM1
				,sc.PARAM2
				,sc.DATE_CHANGE
				,sc.URL as URL
				,scsite.URL as SITE_URL
				,scsite.SITE_ID
				,if(locate('".$DB->ForSQL(ToUpper($phrase))."', upper(sc.TITLE)) > 0, 1, 0) RANK1
				,count(1) RANK2
				,min(ct.POS) RANK3
			FROM
				b_search_content_title ct
				inner join b_search_content sc on sc.ID = ct.SEARCH_CONTENT_ID
				INNER JOIN b_search_content_site scsite ON sc.ID = scsite.SEARCH_CONTENT_ID and ct.SITE_ID = scsite.SITE_ID
			WHERE
				".CSearch::CheckPermissions("sc.ID")."
				AND ct.SITE_ID = '".SITE_ID."'
				AND (".implode(" OR ", $sqlWords).")
				".(!empty($strSqlWhere)? "AND ".$strSqlWhere: "")."
			GROUP BY
				ID, MODULE_ID, ITEM_ID, TITLE, PARAM1, PARAM2, DATE_CHANGE, URL, SITE_URL, SITE_ID
			".(count($sqlHaving) > 1? "HAVING ".implode(" AND ", $sqlHaving): "")."
			ORDER BY ".(
			$bOrderByRank?
				"RANK1 DESC, RANK2 DESC, RANK3 ASC, TITLE":
				"DATE_CHANGE DESC, RANK1 DESC, RANK2 DESC, RANK3 ASC, TITLE"
			)."
			LIMIT 0, ".($nTopCount + 1)."
		";

		$r = $DB->Query($strSql);
		parent::__construct($r);
		return true;
	}
	else
	{
		return false;
	}
}