CAllSocNetUserRelations::IsFriends2

static function IsFriends2($firstUserID, $secondUserID)
{
	global $DB;
	static $arSocNetUser2RelationsCache = array();

	$firstUserID = intval($firstUserID);
	if ($firstUserID <= 0)
	{
		return false;
	}

	$secondUserID = intval($secondUserID);
	if ($secondUserID <= 0)
	{
		return false;
	}

	if (!array_key_exists($firstUserID."_".$secondUserID, $arSocNetUser2RelationsCache))
	{
		$strSql =
			"SELECT 'x' ".
			"FROM b_sonet_user_relations UR, b_sonet_user_relations UR1 ".
			"WHERE UR.FIRST_USER_ID = ".$firstUserID." ".
			"	AND UR.SECOND_USER_ID = UR1.FIRST_USER_ID ".
			"	AND UR.RELATION = '".$DB->ForSql(SONET_RELATIONS_FRIEND, 1)."' ".
			"	AND UR1.SECOND_USER_ID = ".$secondUserID." ".
			"	AND UR1.RELATION = '".$DB->ForSql(SONET_RELATIONS_FRIEND, 1)."' ".
			"UNION ".
			"SELECT 'x' ".
			"FROM b_sonet_user_relations UR, b_sonet_user_relations UR1 ".
			"WHERE UR.FIRST_USER_ID = ".$firstUserID." ".
			"	AND UR.SECOND_USER_ID = UR1.SECOND_USER_ID ".
			"	AND UR.RELATION = '".$DB->ForSql(SONET_RELATIONS_FRIEND, 1)."' ".
			"	AND UR1.FIRST_USER_ID = ".$secondUserID." ".
			"	AND UR1.RELATION = '".$DB->ForSql(SONET_RELATIONS_FRIEND, 1)."' ".
			"UNION ".
			"SELECT 'x' ".
			"FROM b_sonet_user_relations UR, b_sonet_user_relations UR1 ".
			"WHERE UR.SECOND_USER_ID = ".$firstUserID." ".
			"	AND UR.FIRST_USER_ID = UR1.FIRST_USER_ID ".
			"	AND UR.RELATION = '".$DB->ForSql(SONET_RELATIONS_FRIEND, 1)."' ".
			"	AND UR1.SECOND_USER_ID = ".$secondUserID." ".
			"	AND UR1.RELATION = '".$DB->ForSql(SONET_RELATIONS_FRIEND, 1)."' ".
			"UNION ".
			"SELECT 'x' ".
			"FROM b_sonet_user_relations UR, b_sonet_user_relations UR1 ".
			"WHERE UR.SECOND_USER_ID = ".$firstUserID." ".
			"	AND UR.FIRST_USER_ID = UR1.SECOND_USER_ID ".
			"	AND UR.RELATION = '".$DB->ForSql(SONET_RELATIONS_FRIEND, 1)."' ".
			"	AND UR1.FIRST_USER_ID = ".$secondUserID." ".
			"	AND UR1.RELATION = '".$DB->ForSql(SONET_RELATIONS_FRIEND, 1)."' ";

		$dbResult = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
		if ($dbResult->Fetch())
		{
			$arSocNetUser2RelationsCache[$firstUserID."_".$secondUserID] = true;
		}
		else
		{
			$arSocNetUser2RelationsCache[$firstUserID."_".$secondUserID] = false;
		}
	}

	return $arSocNetUser2RelationsCache[$firstUserID."_".$secondUserID];
}