- Модуль: controller
- Путь к файлу: ~/bitrix/modules/controller/classes/mysql/controllermember.php
- Класс: CControllerMember
- Вызов: CControllerMember::_CheckCommandId
static function _CheckCommandId($member_guid, $command_id)
{
global $DB;
$strSql = "
SELECT C.ID, C.COMMAND, M.SECRET_ID, C.ADD_PARAMS
FROM
b_controller_command C
INNER JOIN b_controller_member M ON C.MEMBER_ID = M.MEMBER_ID
WHERE
C.MEMBER_ID = '".$DB->ForSQL($member_guid, 32)."'
AND C.COMMAND_ID = '".$DB->ForSQL($command_id, 32)."'
AND C.DATE_EXEC IS NULL
AND C.DATE_INSERT > DATE_ADD(now(), INTERVAL -1 MINUTE)
";
$dbr = $DB->Query($strSql);
$ar = $dbr->Fetch();
if (!$ar)
return false;
$strSql = "UPDATE b_controller_command SET DATE_EXEC=".$DB->CurrentTimeFunction()." WHERE ID=".$ar["ID"];
$DB->Query($strSql);
return $ar;
}