CStatistics::CleanUpSearcherHits

static function CleanUpSearcherHits()
{
	set_time_limit(0);
	ignore_user_abort(true);
	$err_mess = "File: ".__FILE__."
Line: ";
	$DB = CDatabase::GetModuleConnection('statistic');
	$DAYS = intval(COption::GetOptionString("statistic", "SEARCHER_HIT_DAYS"));

	$strSql = "
		DELETE FROM b_stat_searcher_hit
		WHERE HIT_KEEP_DAYS IS NULL
		AND DATE_HIT <= DATE_SUB(CURDATE(), INTERVAL $DAYS DAY)
	";
	$DB->Query($strSql, false, $err_mess.__LINE__);

	$strSql = "
		DELETE sh.* FROM
		b_stat_searcher s
		STRAIGHT_JOIN b_stat_searcher_hit sh
		WHERE s.ID = sh.SEARCHER_ID
		AND s.HIT_KEEP_DAYS is not null
		AND sh.DATE_HIT <= DATE_SUB(CURDATE(), INTERVAL s.HIT_KEEP_DAYS DAY)
	";
	$DB->Query($strSql, false, $err_mess.__LINE__);

	if(COption::GetOptionString("statistic", "USE_AUTO_OPTIMIZE")=="Y")
	{
		$DB->Query("OPTIMIZE TABLE b_stat_searcher_hit", false, $err_mess.__LINE__);
	}
}