public static function checkUserLinks($socservUserId)
{
$dbRes = UserTable::getByPrimary($socservUserId);
$arUser = $dbRes->fetch();
if ($arUser) {
$sql = "\nSELECT sul.ID, su_link.USER_ID\nFROM " . self::getTableName() . " sul\nLEFT JOIN " . SocservUserTable::getTableName() . " su_link ON sul.LINK_UID=su_link.XML_ID\nWHERE (1=1)\nAND sul.SOCSERV_USER_ID='" . $arUser['ID'] . "'\nAND su_link.EXTERNAL_AUTH_ID='" . $arUser['EXTERNAL_AUTH_ID'] . "'\nAND sul.LINK_USER_ID IS NULL\n";
$connection = \Bitrix\Main\Application::getConnection();
return $connection->query($sql);
} else {
return false;
}
}
