• Модуль: socialnetwork
  • Путь к файлу: ~/bitrix/modules/socialnetwork/classes/general/log_counter.php
  • Класс: CAllSocNetLogCounter
  • Вызов: CAllSocNetLogCounter::GetLastDateByUserAndCode
static function GetLastDateByUserAndCode($user_id, $site_id = SITE_ID, $code = "**")
{
	global $DB;
	$result = 0;
	$user_id = (int)$user_id;

	if($user_id > 0)
	{
		$strSQL = "
			SELECT ".$DB->DateToCharFunction("LAST_DATE", "FULL")." LAST_DATE
			FROM b_sonet_log_counter
			WHERE USER_ID = ".$user_id."
			AND (SITE_ID = '".$DB->ForSql($site_id)."' OR SITE_ID = '**')
			AND CODE = '".$DB->ForSql($code)."'
		";

		$dbRes = $DB->Query($strSQL, false, "File: ".__FILE__."
Line: ".__LINE__); if ($arRes = $dbRes->Fetch()) { $result = MakeTimeStamp($arRes["LAST_DATE"]); } } return $result; }