public static function Get($channelId, $lastId = 0)
{
global $DB;
$newLastId = $lastId;
$arMessage = Array();
$strSql = "
SELECT ps.ID, ps.MESSAGE
FROM b_pull_stack ps ".($lastId > 0? '': 'LEFT JOIN b_pull_channel pc ON pc.CHANNEL_ID = ps.CHANNEL_ID')."
WHERE ps.CHANNEL_ID = '".$DB->ForSQL($channelId)."'".($lastId > 0? " AND ps.ID > ".intval($lastId): " AND ps.ID > pc.LAST_ID" );
$dbRes = $DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__);
while ($arRes = $dbRes->Fetch())
{
if ($newLastId < $arRes['ID'])
$newLastId = $arRes['ID'];
$data = unserialize($arRes['MESSAGE']);
$data['id'] = $arRes['ID'];
$arMessage[] = $data;
}
if ($lastId < $newLastId)
CPullChannel::UpdateLastId($channelId, $newLastId);
return $arMessage;
}
public static function Get($channelId, $lastId = 0)
{
global $DB;
$newLastId = $lastId;
$arMessage = Array();
$strSql = "
SELECT ID, MESSAGE
FROM b_pull_stack
WHERE CHANNEL_ID = '".$DB->ForSQL($channelId)."' AND ID > ".intval($lastId);
$dbRes = $DB->Query($strSql, false, "File: ".__FILE__."<br>Line: ".__LINE__);
while ($arRes = $dbRes->Fetch())
{
if ($newLastId < $arRes['ID'])
$newLastId = $arRes['ID'];
$data = unserialize($arRes['MESSAGE']);
$data['id'] = $arRes['ID'];
$arMessage[] = $data;
}
if ($lastId < $newLastId)
CPullChannel::UpdateLastId($channelId, $newLastId);
return $arMessage;
}
