123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119 |
- <?php
- if (!defined('STATUSNET')) {
-
-
- exit(1);
- }
- class RepeatsOfMeNoticeStream extends ScopingNoticeStream
- {
- function __construct($user, $profile=-1)
- {
- if (is_int($profile) && $profile == -1) {
- $profile = Profile::current();
- }
- parent::__construct(new CachingNoticeStream(new RawRepeatsOfMeNoticeStream($user),
- 'user:repeats_of_me:'.$user->id),
- $profile);
- }
- }
- class RawRepeatsOfMeNoticeStream extends NoticeStream
- {
- protected $user;
- function __construct($user)
- {
- $this->user = $user;
- }
- function getNoticeIds($offset, $limit, $since_id, $max_id)
- {
- $qry =
- 'SELECT DISTINCT original.id AS id ' .
- 'FROM notice original JOIN notice rept ON original.id = rept.repeat_of ' .
- 'WHERE original.profile_id = ' . $this->user->id . ' ';
- $since = Notice::whereSinceId($since_id, 'original.id', 'original.created');
- if ($since) {
- $qry .= "AND ($since) ";
- }
- $max = Notice::whereMaxId($max_id, 'original.id', 'original.created');
- if ($max) {
- $qry .= "AND ($max) ";
- }
- $qry .= 'ORDER BY original.created, original.id DESC ';
- if (!is_null($offset)) {
- $qry .= "LIMIT $limit OFFSET $offset";
- }
- $ids = array();
- $notice = new Notice();
- $notice->query($qry);
- while ($notice->fetch()) {
- $ids[] = $notice->id;
- }
- $notice->free();
- $notice = NULL;
- return $ids;
- }
- }
|