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