- Модуль: 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;
}