• Модуль: im
  • Путь к файлу: ~/bitrix/modules/im/classes/general/im_chat.php
  • Класс: CIMChat
  • Вызов: CIMChat::GetPrivateRelation
static function GetPrivateRelation($fromUserId, $toUserId)
{
	global $DB;

	$fromUserId = intval($fromUserId);
	$toUserId = intval($toUserId);

	$arResult = Array();
	$strSql = "
		SELECT
			RF.*
		FROM
			b_im_relation RF
			INNER JOIN b_im_relation RT on RF.CHAT_ID = RT.CHAT_ID
		WHERE
			RF.USER_ID = ".$fromUserId."
		and RT.USER_ID = ".$toUserId."
		and RF.MESSAGE_TYPE = '".IM_MESSAGE_PRIVATE."'
	";
	$dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); if ($arRes = $dbRes->Fetch()) $arResult = $arRes; return $arResult; }