• Модуль: socialnetwork
  • Путь к файлу: ~/bitrix/modules/socialnetwork/classes/general/user_relations.php
  • Класс: CAllSocNetUserRelations
  • Вызов: CAllSocNetUserRelations::GetByUserID
static function GetByUserID($user1ID, $user2ID)
{
	global $DB;

	$user1ID = intval($user1ID);
	if ($user1ID <= 0)
		return false;
	$user2ID = intval($user2ID);
	if ($user2ID <= 0)
		return false;

	$strSql =
		"SELECT ID, FIRST_USER_ID, SECOND_USER_ID, RELATION, DATE_CREATE, DATE_UPDATE, MESSAGE, INITIATED_BY ".
		"FROM b_sonet_user_relations ".
		"WHERE FIRST_USER_ID = ".$user1ID." AND SECOND_USER_ID = ".$user2ID." ".
		"	OR FIRST_USER_ID = ".$user2ID." AND SECOND_USER_ID = ".$user1ID." ";

	$dbResult = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); if ($arResult = $dbResult->Fetch()) return $arResult; return False; }