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