CAllStatistics::GetAdvGuestHost

static function GetAdvGuestHost($ADV_ID, $GUEST_ID, $IP_NUMBER, $BACK="")
{
	$err_mess = "File: ".__FILE__."
Line: ";
	$DB = CDatabase::GetModuleConnection('statistic');
	$ADV_ID = intval($ADV_ID);
	$GID = intval($GUEST_ID);

	$strSql = "
		SELECT
			count(1) ADV_HOSTS,
			".$DB->DateToCharFunction("max(DATE_HOST_HIT)","SHORT")." MAX_DATE_HOST_HIT
		FROM	b_stat_adv_guest
		WHERE	ADV_ID=$ADV_ID and IP_NUMBER='".$DB->ForSQL($IP_NUMBER)."'
		$BACK
	";
	$rsResult=$DB->Query($strSql, false, $err_mess.__LINE__);
	if(!($arHost = $rsResult->Fetch()))
		$arHost = array("ADV_HOSTS"=>0,"MAX_DATE_HOST_HIT"=>false);

	$strSql = "
		SELECT
			count(1) ADV_GUESTS,
			".$DB->DateToCharFunction("max(DATE_GUEST_HIT)","SHORT")." MAX_DATE_GUEST_HIT
		FROM	b_stat_adv_guest
		WHERE	ADV_ID=$ADV_ID and GUEST_ID=$GID
		$BACK
	";
	$rsResult=$DB->Query($strSql, false, $err_mess.__LINE__);
	if(!($arGuest = $rsResult->Fetch()))
		$arGuest = array("ADV_GUESTS"=>0,"MAX_DATE_GUEST_HIT"=>false);

	$rsResult = new CDBResult;
	$rsResult->InitFromArray(array(array_merge($arGuest,$arHost)));
	return $rsResult;
}