- Модуль: pull
- Путь к файлу: ~/bitrix/modules/pull/classes/general/pull_channel.php
- Класс: CPullChannel
- Вызов: CPullChannel::CheckExpireAgent
static function CheckExpireAgent()
{
global $DB;
$sqlDateFunction = null;
if ($DB->type == "MYSQL")
$sqlDateFunction = "DATE_SUB(NOW(), INTERVAL 13 HOUR)";
elseif ($DB->type == "MSSQL")
$sqlDateFunction = "dateadd(HOUR, -13, getdate())";
elseif ($DB->type == "ORACLE")
$sqlDateFunction = "SYSDATE-1/13";
if (!is_null($sqlDateFunction))
{
$strSql = "
SELECT USER_ID, CHANNEL_ID, CHANNEL_TYPE
FROM b_pull_channel
WHERE DATE_CREATE < ".$sqlDateFunction;
$dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
while ($arRes = $dbRes->Fetch())
{
self::DeleteByUser($arRes['USER_ID'], $arRes['CHANNEL_ID'], $arRes['CHANNEL_TYPE']);
}
}
return "CPullChannel::CheckExpireAgent();";
}