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