From 727c4060a590d12595a0378e5d83b57423d920f5 Mon Sep 17 00:00:00 2001 From: Zach Copley Date: Thu, 20 Nov 2008 02:19:30 -0500 Subject: New public tabs - Public, Recent tags, Featured, and Favorited darcs-hash:20081120071930-7b5ce-a15d7308bde085f03aa335c98ecd0aaa3833bc35.gz --- actions/favorited.php | 108 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 108 insertions(+) create mode 100644 actions/favorited.php (limited to 'actions/favorited.php') diff --git a/actions/favorited.php b/actions/favorited.php new file mode 100644 index 000000000..ba41cbc3d --- /dev/null +++ b/actions/favorited.php @@ -0,0 +1,108 @@ +. + */ + +if (!defined('LACONICA')) { exit(1); } + +require_once(INSTALLDIR.'/lib/stream.php'); + +class FavoritedAction extends StreamAction { + + function handle($args) { + parent::handle($args); + + $page = ($this->arg('page')) ? ($this->arg('page')+0) : 1; + + common_show_header(_('Favorited timeline'), + array($this, 'show_header'), NULL, + array($this, 'show_top')); + + $this->show_notices($page); + + common_show_footer(); + } + + function show_top() { + if (common_logged_in()) { + common_notice_form('public'); + } + + $this->public_views_menu(); + } + + // XXX Need to make RSS stream + + function show_header() { + common_element('link', array('rel' => 'alternate', + 'href' => common_local_url('favoritedrss'), + 'type' => 'application/rss+xml', + 'title' => _('Favorited Stream Feed'))); + } + + function show_notices($page) { + + // XXX: Make dropoff configurable like tags? + + $qry = + 'SELECT notice_id, sum(exp(-(now() - modified)/864000)) as weight ' . + 'FROM fave GROUP BY notice_id ' . + 'ORDER BY weight DESC'; + + $offset = ($page - 1) * NOTICES_PER_PAGE; + $limit = NOTICES_PER_PAGE + 1; + + if (common_config('db','type') == 'pgsql') { + $qry .= ' LIMIT ' . $limit . ' OFFSET ' . $offset; + } else { + $qry .= ' LIMIT ' . $offset . ', ' . $limit; + } + + // XXX: Figure out how to cache these queries. + + $fave = new Fave; + $fave->query($qry); + + $notice_list = array(); + + while ($fave->fetch()) { + array_push($notice_list, $fave->notice_id); + } + + $notice = new Notice(); + + $notice->query(sprintf('SELECT * FROM notice WHERE id in (%s)', + implode($notice_list, ','))); + + $cnt = 0; + + if ($notice) { + common_element_start('ul', array('id' => 'notices')); + while ($notice->fetch()) { + $cnt++; + if ($cnt > NOTICES_PER_PAGE) { + break; + } + $this->show_notice($notice); + } + common_element_end('ul'); + } + + common_pagination($page > 1, $cnt > NOTICES_PER_PAGE, + $page, 'favorited'); + } +} \ No newline at end of file -- cgit v1.2.3-54-g00ecf