• Модуль: socialservices
  • Путь к файлу: ~/bitrix/modules/socialservices/lib/userlink.php
  • Класс: BitrixSocialservicesUserLinkTable
  • Вызов: UserLinkTable::checkUserLinks
static function checkUserLinks($socservUserId)
{
	$dbRes = UserTable::getByPrimary($socservUserId);
	$socservUserInfo = $dbRes->fetch();
	if($socservUserInfo)
	{
		$connection = BitrixMainApplication::getConnection();
		$sqlHelper = $connection->getSqlHelper();

		$sql = "
SELECT sul.ID, su_link.USER_ID
FROM ".static::getTableName()." sul
LEFT JOIN ".SocservUserTable::getTableName()." su_link ON sul.LINK_UID=su_link.XML_ID
WHERE (1=1)
AND sul.SOCSERV_USER_ID='".intval($socservUserInfo['ID'])."'
AND su_link.EXTERNAL_AUTH_ID='".$sqlHelper->forSql($socservUserInfo['EXTERNAL_AUTH_ID'])."'
AND sul.LINK_USER_ID IS NULL
";

		return $connection->query($sql);
	}
	else
	{
		return false;
	}
}