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