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/favoritedrss.php | 83 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 83 insertions(+) create mode 100644 actions/favoritedrss.php (limited to 'actions/favoritedrss.php') diff --git a/actions/favoritedrss.php b/actions/favoritedrss.php new file mode 100644 index 000000000..4661f4821 --- /dev/null +++ b/actions/favoritedrss.php @@ -0,0 +1,83 @@ +. + */ + +if (!defined('LACONICA')) { exit(1); } + +require_once(INSTALLDIR.'/lib/rssaction.php'); + +// Formatting of RSS handled by Rss10Action + +class FavoritedrssAction extends Rss10Action { + + function init() { + return true; + } + + function get_notices($limit=0) { + + $qry = + 'SELECT notice_id, sum(exp(-(now() - modified)/864000)) as weight ' . + 'FROM fave GROUP BY notice_id ' . + 'ORDER BY weight DESC'; + + $offset = 0; + $total = ($limit == 0) ? 48 : $limit; + + if (common_config('db','type') == 'pgsql') { + $qry .= ' LIMIT ' . $total . ' OFFSET ' . $offset; + } else { + $qry .= ' LIMIT ' . $offset . ', ' . $limit; + } + + $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, ','))); + + $notices = array(); + + while ($notice->fetch()) { + $notices[] = clone($notice); + } + + return $notices; + } + + function get_channel() { + global $config; + $c = array('url' => common_local_url('favoritedrss'), + 'title' => sprintf(_('%s Most Favorited Stream'), $config['site']['name']), + 'link' => common_local_url('favorited'), + 'description' => sprintf(_('Most favorited updates for %s'), $config['site']['name'])); + return $c; + } + + function get_image() { + return NULL; + } +} \ No newline at end of file -- cgit v1.2.3-54-g00ecf