CStatistics::CleanUpPathDynamic

static function CleanUpPathDynamic()
{
	set_time_limit(0);
	ignore_user_abort(true);
	$err_mess = "File: ".__FILE__."
Line: ";
	$DB = CDatabase::GetModuleConnection('statistic');
	$DAYS = intval(COption::GetOptionString("statistic", "PATH_DAYS"));
	//$STEPS = intval(COption::GetOptionString("statistic", "MAX_PATH_STEPS"));
	if ($DAYS>=0)
	{
		$strSql = "
			DELETE FROM b_stat_path
			WHERE DATE_STAT <= DATE_SUB(CURDATE(),INTERVAL $DAYS DAY)
			OR DATE_STAT is null
		";//STEPS removed due to insert check
		$DB->Query($strSql, false, $err_mess.__LINE__);
		$strSql = "
			DELETE FROM b_stat_path_adv
			WHERE DATE_STAT <= DATE_SUB(CURDATE(),INTERVAL $DAYS DAY)
			OR DATE_STAT is null
		";//STEPS removed due to insert check
		$DB->Query($strSql, false, $err_mess.__LINE__);
		if(COption::GetOptionString("statistic", "USE_AUTO_OPTIMIZE")=="Y")
		{
			$DB->Query("OPTIMIZE TABLE b_stat_path", false, $err_mess.__LINE__);
			$DB->Query("OPTIMIZE TABLE b_stat_path_adv", false, $err_mess.__LINE__);
		}
	}
}