X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=lib%2Finboxnoticestream.php;h=b5a8877d99d426a9a425c4952ea6ef1d9d3a0c61;hb=e8d1bb25469fe1ef0cbcb32c3022010997aca4b0;hp=57c5e0c80e029e565a381e109286220e7a9d51e2;hpb=5842c59ba7e738724f026429590e29eb89af92b4;p=quix0rs-gnu-social.git diff --git a/lib/inboxnoticestream.php b/lib/inboxnoticestream.php index 57c5e0c80e..b5a8877d99 100644 --- a/lib/inboxnoticestream.php +++ b/lib/inboxnoticestream.php @@ -112,8 +112,21 @@ class RawInboxNoticeStream extends NoticeStream 'OR notice.id IN (SELECT notice_id FROM attention WHERE profile_id=%1$d)', $this->target->id) ); + if (!empty($since_id)) { + $notice->whereAdd(sprintf('notice.id > %d', $since_id)); + } + if (!empty($max_id)) { + $notice->whereAdd(sprintf('notice.id <= %d', $max_id)); + } + if (!empty($this->selectVerbs)) { + $notice->whereAddIn('verb', $this->selectVerbs, $notice->columnType('verb')); + } $notice->limit($offset, $limit); - $notice->orderBy('notice.created DESC'); + // notice.id will give us even really old posts, which were + // recently imported. For example if a remote instance had + // problems and just managed to post here. Another solution + // would be to have a 'notice.imported' field and order by it. + $notice->orderBy('notice.id DESC'); if (!$notice->find()) { return array(); @@ -123,30 +136,4 @@ class RawInboxNoticeStream extends NoticeStream return $ids; } - - function getNotices($offset, $limit, $sinceId, $maxId) - { - $all = array(); - - do { - - $ids = $this->getNoticeIds($offset, $limit, $sinceId, $maxId); - - $notices = Notice::pivotGet('id', $ids); - - // By default, takes out false values - - $notices = array_filter($notices); - - $all = array_merge($all, $notices); - - if (count($notices < count($ids))) { - $offset += $limit; - $limit -= count($notices); - } - - } while (count($notices) < count($ids) && count($ids) > 0); - - return new ArrayWrapper($all); - } }