aggregator_page_sources
Definition
aggregator_page_sources()
modules/aggregator/aggregator.pages.inc, line 300
Description
Menu callback; displays all the feeds used by the aggregator.
Code
<?php
function aggregator_page_sources() {
$result = db_query('SELECT f.fid, f.title, f.description, f.image, MAX(i.timestamp) AS last FROM {aggregator_feed} f LEFT JOIN {aggregator_item} i ON f.fid = i.fid GROUP BY f.fid, f.title, f.description, f.image ORDER BY last DESC, f.title');
$output = '';
foreach ($result as $feed) {
// Most recent items:
$summary_items = array();
if (variable_get('aggregator_summary_items', 3)) {
$items = db_query_range('SELECT i.title, i.timestamp, i.link FROM {aggregator_item} i WHERE i.fid = :fid ORDER BY i.timestamp DESC', array(':fid' => $feed->fid), 0, variable_get('aggregator_summary_items', 3));
foreach ($items as $item) {
$summary_items[] = theme('aggregator_summary_item', $item);
}
}
$feed->url = url('aggregator/sources/' . $feed->fid);
$output .= theme('aggregator_summary_items', $summary_items, $feed);
}
$output .= theme('feed_icon', url('aggregator/opml'), t('OPML feed'));
return theme('aggregator_wrapper', $output);
}
?> 