• Модуль: statistic
  • Путь к файлу: ~/bitrix/modules/statistic/classes/mysql/guest.php
  • Класс: CGuest
  • Вызов: CGuest::GetLastByID
static function GetLastByID($ID)
{
	$DB = CDatabase::GetModuleConnection('statistic');
	$ID = intval($ID);
	if($ID>0)
	{
		$strSql = "
			SELECT
				G.ID,
				G.FAVORITES,
				G.LAST_USER_ID,
				A.ID as LAST_ADV_ID,
				if(to_days(curdate())=to_days(G.LAST_DATE), 'Y', 'N') LAST
			FROM b_stat_guest G
			LEFT JOIN b_stat_adv A ON A.ID = G.LAST_ADV_ID
			WHERE G.ID='$ID'
			";
		$res = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); } else { $res = new CDBResult; $res->InitFromArray(array()); } return $res; }