- Модуль: forum
- Путь к файлу: ~/bitrix/modules/forum/classes/general/user.php
- Класс: CAllForumUser
- Вызов: CAllForumUser::GetUserTopicVisits
static function GetUserTopicVisits($forumID, $arTopic, $userID=null)
{
global $DB, $USER;
$arResult = array();
$forumID = intval($forumID);
if ($userID == null)
$userID = $USER->GetID();
else
$userID = intval($userID);
if (($forumID <= 0) || ($userID <= 0))
{
return $arResult;
}
$arSelectTopic = array();
foreach ($arTopic as $topicID)
$arSelectTopic[] = intval($topicID);
$arSelectTopic = array_unique(array_filter($arSelectTopic));
if (sizeof($arSelectTopic) < 1)
{
return $arResult;
}
$sTopicIDs = implode(",", $arSelectTopic);
$strSql = "SELECT FUT.TOPIC_ID,
".$DB->DateToCharFunction("FUT.LAST_VISIT", "FULL")." as LAST_VISIT
FROM b_forum_user_topic FUT
WHERE (FORUM_ID=".$forumID." AND USER_ID=".$userID." AND TOPIC_ID IN (".$sTopicIDs."))";
$rVisit = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
if ($rVisit)
{
while ($arVisit = $rVisit->Fetch())
{
$arResult[$arVisit['TOPIC_ID']] = $arVisit['LAST_VISIT'];
}
}
return $arResult;
}