function aggregator_page_sources in Drupal 6

Same name and namespace in other branches

1. 4 modules/aggregator.module \aggregator_page_sources()
2. 5 modules/aggregator/aggregator.module \aggregator_page_sources()
3. 7 modules/aggregator/aggregator.pages.inc \aggregator_page_sources()

Menu callback; displays all the feeds used by the aggregator.

1 string reference to 'aggregator_page_sources'

aggregator_menu in modules/aggregator/aggregator.module

Implementation of hook_menu().

File

modules/aggregator/aggregator.pages.inc, line 275

User page callbacks for the aggregator module.

Code

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 = '';
  while ($feed = db_fetch_object($result)) {

    // 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 = %d ORDER BY i.timestamp DESC', $feed->fid, 0, variable_get('aggregator_summary_items', 3));
      while ($item = db_fetch_object($items)) {
        $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);
}