• Модуль: 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();"; }