- Модуль: statistic
- Путь к файлу: ~/bitrix/modules/statistic/classes/mysql/statistic.php
- Класс: CStatistics
- Вызов: CStatistics::CleanUpRefererList
static function CleanUpRefererList()
{
set_time_limit(0);
ignore_user_abort(true);
$err_mess = "File: ".__FILE__."
Line: ";
$DB = CDatabase::GetModuleConnection('statistic');
$DAYS = intval(COption::GetOptionString("statistic", "REFERER_LIST_DAYS"));
if($DAYS>=0)
{
$strSql = "
DELETE FROM b_stat_referer_list
WHERE DATE_HIT <= DATE_SUB(CURDATE(),INTERVAL $DAYS DAY)
OR DATE_HIT is null
";
$DB->Query($strSql, false, $err_mess.__LINE__);
if(COption::GetOptionString("statistic", "USE_AUTO_OPTIMIZE")=="Y")
{
$DB->Query("OPTIMIZE TABLE b_stat_referer_list", false, $err_mess.__LINE__);
}
}
}