3 * StatusNet, the distributed open-source microblogging tool
5 * Show list of user pages
9 * LICENCE: This program is free software: you can redistribute it and/or modify
10 * it under the terms of the GNU Affero General Public License as published by
11 * the Free Software Foundation, either version 3 of the License, or
12 * (at your option) any later version.
14 * This program is distributed in the hope that it will be useful,
15 * but WITHOUT ANY WARRANTY; without even the implied warranty of
16 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17 * GNU Affero General Public License for more details.
19 * You should have received a copy of the GNU Affero General Public License
20 * along with this program. If not, see <http://www.gnu.org/licenses/>.
24 * @author Evan Prodromou <evan@status.net>
25 * @copyright 2010 StatusNet, Inc.
26 * @license http://www.fsf.org/licensing/licenses/agpl-3.0.html GNU Affero General Public License version 3.0
27 * @link http://status.net/
30 if (!defined('STATUSNET')) {
39 * @author Evan Prodromou <evan@status.net>
40 * @license http://www.fsf.org/licensing/licenses/agpl-3.0.html GNU Affero General Public License version 3.0
41 * @link http://status.net/
44 class NoticesitemapAction extends SitemapAction
49 function prepare($args)
51 parent::prepare($args);
53 $y = $this->trimmed('year');
55 $m = $this->trimmed('month');
56 $d = $this->trimmed('day');
58 $i = $this->trimmed('index');
65 $this->notices = $this->getNotices($y, $m, $d, $i);
73 if ($this->j < count($this->notices)) {
74 $n = $this->notices[$this->j];
76 return array(common_local_url('shownotice', array('notice' => $n[0])),
77 common_date_w3dtf($n[1]),
85 function getNotices($y, $m, $d, $i)
87 $offset = ($i-1) * SitemapPlugin::NOTICES_PER_MAP;
88 $limit = SitemapPlugin::NOTICES_PER_MAP;
90 $notice = new Notice();
92 $begindt = sprintf('%04d-%02d-%02d 00:00:00', $y, $m, $d);
94 // XXX: estimates 1d == 24h, which screws up days
95 // with leap seconds (1d == 24h + 1s). Thankfully they're
96 // few and far between.
98 $enddt = common_sql_date(strtotime($begindt) + (24 * 60 * 60));
100 $notice->selectAdd();
101 $notice->selectAdd('id, created');
103 $notice->whereAdd("created >= '$begindt'");
104 $notice->whereAdd("created < '$enddt'");
106 $notice->whereAdd('is_local != 0');
108 $notice->orderBy('created');
110 $notice->limit($offset, $limit);
116 while ($notice->fetch()) {
117 $n[] = array($notice->id, $notice->created);