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 $n = Notice::cacheGet("sitemap:notice:$y:$m:$d:$i");
91 $notice = new Notice();
93 $begindt = sprintf('%04d-%02d-%02d 00:00:00', $y, $m, $d);
95 // XXX: estimates 1d == 24h, which screws up days
96 // with leap seconds (1d == 24h + 1s). Thankfully they're
97 // few and far between.
99 $theend = strtotime($begindt) + (24 * 60 * 60);
100 $enddt = common_sql_date($theend);
102 $notice->selectAdd();
103 $notice->selectAdd('id, created');
105 $notice->whereAdd("created >= '$begindt'");
106 $notice->whereAdd("created < '$enddt'");
108 $notice->whereAdd('is_local != 0');
110 $notice->orderBy('created');
112 $offset = ($i-1) * SitemapPlugin::NOTICES_PER_MAP;
113 $limit = SitemapPlugin::NOTICES_PER_MAP;
115 $notice->limit($offset, $limit);
121 while ($notice->fetch()) {
122 $n[] = array($notice->id, $notice->created);
125 $c = Cache::instance();
128 $c->set(Cache::key("sitemap:notice:$y:$m:$d:$i"),
131 ((time() > $theend) ? (time() + 90 * 24 * 60 * 60) : (time() + 5 * 60)));