function aggregator_page_categories
7.x aggregator.pages.inc | aggregator_page_categories() |
6.x aggregator.pages.inc | aggregator_page_categories() |
Page callback: Displays all the categories used by the Aggregator module.
Return value
string An HTML formatted string.
See also
1 string reference to 'aggregator_page_categories'
- aggregator_menu in drupal-7.x/
modules/ aggregator/ aggregator.module - Implements hook_menu().
File
- drupal-7.x/
modules/ aggregator/ aggregator.pages.inc, line 379 - User page callbacks for the Aggregator module.
Code
function aggregator_page_categories() {
$result = db_query('SELECT c.cid, c.title, c.description FROM {aggregator_category} c LEFT JOIN {aggregator_category_item} ci ON c.cid = ci.cid LEFT JOIN {aggregator_item} i ON ci.iid = i.iid GROUP BY c.cid, c.title, c.description');
$output = '';
foreach ($result as $category) {
if (variable_get('aggregator_summary_items', 3)) {
$summary_items = array();
$items = db_query_range('SELECT i.title, i.timestamp, i.link, f.title as feed_title, f.link as feed_link FROM {aggregator_category_item} ci LEFT JOIN {aggregator_item} i ON i.iid = ci.iid LEFT JOIN {aggregator_feed} f ON i.fid = f.fid WHERE ci.cid = :cid ORDER BY i.timestamp DESC', 0, variable_get('aggregator_summary_items', 3), array(':cid' => $category->cid));
foreach ($items as $item) {
$summary_items[] = theme('aggregator_summary_item', array('item' => $item));
}
}
$category->url = url('aggregator/categories/' . $category->cid);
$output .= theme('aggregator_summary_items', array('summary_items' => $summary_items, 'source' => $category));
}
return theme('aggregator_wrapper', array('content' => $output));
}