webmaster@1: title)); webmaster@1: $feed_source = theme('aggregator_feed_source', $feed); webmaster@1: webmaster@1: // It is safe to include the fid in the query because it's loaded from the webmaster@1: // database by aggregator_feed_load. webmaster@1: $items = aggregator_feed_items_load('SELECT * FROM {aggregator_item} WHERE fid = '. $feed->fid .' ORDER BY timestamp DESC, iid DESC'); webmaster@1: webmaster@1: return _aggregator_page_list($items, arg(3), $feed_source); webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Menu callback; displays all the items aggregated in a particular category. webmaster@1: * webmaster@1: * If there are two arguments then this function is called as a form. webmaster@1: * webmaster@1: * @param $arg1 webmaster@1: * If there are two arguments then $arg1 is $form_state. Otherwise, $arg1 is $category. webmaster@1: * @param $arg2 webmaster@1: * If there are two arguments then $arg2 is $category. webmaster@1: * @return webmaster@1: * The items HTML. webmaster@1: */ webmaster@1: function aggregator_page_category($arg1, $arg2 = NULL) { webmaster@1: drupal_set_breadcrumb(array_merge(drupal_get_breadcrumb(), array(l(t('Categories'), 'aggregator/categories')))); webmaster@1: // If there are two arguments then we are called as a form, $arg1 is webmaster@1: // $form_state and $arg2 is $category. Otherwise, $arg1 is $category. webmaster@1: $category = is_array($arg2) ? $arg2 : $arg1; webmaster@1: webmaster@1: drupal_add_feed(url('aggregator/rss/'. $category['cid']), variable_get('site_name', 'Drupal') .' '. t('aggregator - @title', array('@title' => $category['title']))); webmaster@1: webmaster@1: // It is safe to include the cid in the query because it's loaded from the webmaster@1: // database by aggregator_category_load. webmaster@1: $items = aggregator_feed_items_load('SELECT i.*, f.title AS ftitle, f.link AS flink FROM {aggregator_category_item} c LEFT JOIN {aggregator_item} i ON c.iid = i.iid LEFT JOIN {aggregator_feed} f ON i.fid = f.fid WHERE cid = '. $category['cid'] .' ORDER BY timestamp DESC, i.iid DESC'); webmaster@1: webmaster@1: return _aggregator_page_list($items, arg(3)); webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Load feed items by passing a SQL query. webmaster@1: * webmaster@1: * @param $sql webmaster@1: * The query to be executed. webmaster@1: * @return webmaster@1: * An array of the feed items. webmaster@1: */ webmaster@1: function aggregator_feed_items_load($sql) { webmaster@1: $items = array(); webmaster@1: if (isset($sql)) { webmaster@1: $result = pager_query($sql, 20); webmaster@1: while ($item = db_fetch_object($result)) { webmaster@1: $result_category = db_query('SELECT c.title, c.cid FROM {aggregator_category_item} ci LEFT JOIN {aggregator_category} c ON ci.cid = c.cid WHERE ci.iid = %d ORDER BY c.title', $item->iid); webmaster@1: $item->categories = array(); webmaster@1: while ($item_categories = db_fetch_object($result_category)) { webmaster@1: $item->categories[] = $item_categories; webmaster@1: } webmaster@1: $items[$item->iid] = $item; webmaster@1: } webmaster@1: } webmaster@1: return $items; webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Prints an aggregator page listing a number of feed items. webmaster@1: * webmaster@1: * Various menu callbacks use this function to print their feeds. webmaster@1: * webmaster@1: * @param $items webmaster@1: * The items to be listed. webmaster@1: * @param $op webmaster@1: * Which form should be added to the items. Only 'categorize' is now recognized. webmaster@1: * @param $feed_source webmaster@1: * The feed source URL. webmaster@1: * @return webmaster@1: * The items HTML. webmaster@1: */ webmaster@1: function _aggregator_page_list($items, $op, $feed_source = '') { webmaster@1: if (user_access('administer news feeds') && ($op == 'categorize')) { webmaster@1: // Get form data. webmaster@1: $output = aggregator_categorize_items($items, $feed_source); webmaster@1: } webmaster@1: else { webmaster@1: // Assemble themed output. webmaster@1: $output = $feed_source; webmaster@1: foreach ($items as $item) { webmaster@1: $output .= theme('aggregator_item', $item); webmaster@1: } webmaster@1: $output = theme('aggregator_wrapper', $output); webmaster@1: } webmaster@1: return $output; webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Form builder; build the page list form. webmaster@1: * webmaster@1: * @param $items webmaster@1: * An array of the feed items. webmaster@1: * @param $feed_source webmaster@1: * The feed source URL. webmaster@1: * @return webmaster@1: * The form structure. webmaster@1: * @ingroup forms webmaster@1: * @see aggregator_categorize_items_validate() webmaster@1: * @see aggregator_categorize_items_submit() webmaster@1: */ webmaster@1: function aggregator_categorize_items($items, $feed_source = '') { webmaster@1: $form['#submit'][] = 'aggregator_categorize_items_submit'; webmaster@1: $form['#validate'][] = 'aggregator_categorize_items_validate'; webmaster@1: $form['#theme'] = 'aggregator_categorize_items'; webmaster@1: $form['feed_source'] = array('#value' => $feed_source); webmaster@1: $categories = array(); webmaster@1: $done = FALSE; webmaster@1: $form['items'] = array(); webmaster@1: $form['categories'] = array('#tree' => TRUE); webmaster@1: foreach ($items as $item) { webmaster@1: $form['items'][$item->iid] = array('#value' => theme('aggregator_item', $item)); webmaster@1: $form['categories'][$item->iid] = array(); webmaster@1: $categories_result = db_query('SELECT c.cid, c.title, ci.iid FROM {aggregator_category} c LEFT JOIN {aggregator_category_item} ci ON c.cid = ci.cid AND ci.iid = %d', $item->iid); webmaster@1: $selected = array(); webmaster@1: while ($category = db_fetch_object($categories_result)) { webmaster@1: if (!$done) { webmaster@1: $categories[$category->cid] = check_plain($category->title); webmaster@1: } webmaster@1: if ($category->iid) { webmaster@1: $selected[] = $category->cid; webmaster@1: } webmaster@1: } webmaster@1: $done = TRUE; webmaster@1: $form['categories'][$item->iid] = array( webmaster@1: '#type' => variable_get('aggregator_category_selector', 'checkboxes'), webmaster@1: '#default_value' => $selected, webmaster@1: '#options' => $categories, webmaster@1: '#size' => 10, webmaster@1: '#multiple' => TRUE webmaster@1: ); webmaster@1: } webmaster@1: $form['submit'] = array('#type' => 'submit', '#value' => t('Save categories')); webmaster@1: webmaster@1: return $form; webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Validate aggregator_categorize_items form submissions. webmaster@1: */ webmaster@1: function aggregator_categorize_items_validate($form, &$form_state) { webmaster@1: if (!user_access('administer news feeds')) { webmaster@1: form_error($form, t('You are not allowed to categorize this feed item.')); webmaster@1: } webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Process aggregator_categorize_items form submissions. webmaster@1: */ webmaster@1: function aggregator_categorize_items_submit($form, &$form_state) { webmaster@1: if (!empty($form_state['values']['categories'])) { webmaster@1: foreach ($form_state['values']['categories'] as $iid => $selection) { webmaster@1: db_query('DELETE FROM {aggregator_category_item} WHERE iid = %d', $iid); webmaster@1: foreach ($selection as $cid) { webmaster@1: if ($cid) { webmaster@1: db_query('INSERT INTO {aggregator_category_item} (cid, iid) VALUES (%d, %d)', $cid, $iid); webmaster@1: } webmaster@1: } webmaster@1: } webmaster@1: } webmaster@1: drupal_set_message(t('The categories have been saved.')); webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Theme the page list form for assigning categories. webmaster@1: * webmaster@1: * @param $form webmaster@1: * An associative array containing the structure of the form. webmaster@1: * @return webmaster@1: * The output HTML. webmaster@1: * @ingroup themeable webmaster@1: */ webmaster@1: function theme_aggregator_categorize_items($form) { webmaster@1: $output = drupal_render($form['feed_source']); webmaster@1: $rows = array(); webmaster@1: if ($form['items']) { webmaster@1: foreach (element_children($form['items']) as $key) { webmaster@1: if (is_array($form['items'][$key])) { webmaster@1: $rows[] = array( webmaster@1: drupal_render($form['items'][$key]), webmaster@1: array('data' => drupal_render($form['categories'][$key]), 'class' => 'categorize-item'), webmaster@1: ); webmaster@1: } webmaster@1: } webmaster@1: } webmaster@1: $output .= theme('table', array('', t('Categorize')), $rows); webmaster@1: $output .= drupal_render($form['submit']); webmaster@1: $output .= drupal_render($form); webmaster@1: return theme('aggregator_wrapper', $output); webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Process variables for aggregator-wrapper.tpl.php. webmaster@1: * webmaster@1: * @see aggregator-wrapper.tpl.php webmaster@1: */ webmaster@1: function template_preprocess_aggregator_wrapper(&$variables) { webmaster@1: $variables['pager'] = theme('pager', NULL, 20, 0); webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Process variables for aggregator-item.tpl.php. webmaster@1: * webmaster@1: * @see aggregator-item.tpl.php webmaster@1: */ webmaster@1: function template_preprocess_aggregator_item(&$variables) { webmaster@1: $item = $variables['item']; webmaster@1: webmaster@1: $variables['feed_url'] = check_url($item->link); webmaster@1: $variables['feed_title'] = check_plain($item->title); webmaster@1: $variables['content'] = aggregator_filter_xss($item->description); webmaster@1: webmaster@1: $variables['source_url'] = ''; webmaster@1: $variables['source_title'] = ''; webmaster@1: if (isset($item->ftitle) && isset($item->fid)) { webmaster@1: $variables['source_url'] = url("aggregator/sources/$item->fid"); webmaster@1: $variables['source_title'] = check_plain($item->ftitle); webmaster@1: } webmaster@1: if (date('Ymd', $item->timestamp) == date('Ymd')) { webmaster@1: $variables['source_date'] = t('%ago ago', array('%ago' => format_interval(time() - $item->timestamp))); webmaster@1: } webmaster@1: else { webmaster@1: $variables['source_date'] = format_date($item->timestamp, 'custom', variable_get('date_format_medium', 'D, m/d/Y - H:i')); webmaster@1: } webmaster@1: webmaster@1: $variables['categories'] = array(); webmaster@1: foreach ($item->categories as $category) { webmaster@1: $variables['categories'][$category->cid] = l($category->title, 'aggregator/categories/'. $category->cid); webmaster@1: } webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Menu callback; displays all the feeds used by the aggregator. webmaster@1: */ webmaster@1: function aggregator_page_sources() { webmaster@1: $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'); webmaster@1: webmaster@1: $output = ''; webmaster@1: while ($feed = db_fetch_object($result)) { webmaster@1: // Most recent items: webmaster@1: $summary_items = array(); webmaster@1: if (variable_get('aggregator_summary_items', 3)) { webmaster@1: $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)); webmaster@1: while ($item = db_fetch_object($items)) { webmaster@1: $summary_items[] = theme('aggregator_summary_item', $item); webmaster@1: } webmaster@1: } webmaster@1: $feed->url = url('aggregator/sources/'. $feed->fid); webmaster@1: $output .= theme('aggregator_summary_items', $summary_items, $feed); webmaster@1: } webmaster@1: $output .= theme('feed_icon', url('aggregator/opml'), t('OPML feed')); webmaster@1: webmaster@1: return theme('aggregator_wrapper', $output); webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Menu callback; displays all the categories used by the aggregator. webmaster@1: */ webmaster@1: function aggregator_page_categories() { webmaster@1: $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'); webmaster@1: webmaster@1: $output = ''; webmaster@1: while ($category = db_fetch_object($result)) { webmaster@1: if (variable_get('aggregator_summary_items', 3)) { webmaster@1: $summary_items = array(); webmaster@1: $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 = %d ORDER BY i.timestamp DESC', $category->cid, 0, variable_get('aggregator_summary_items', 3)); webmaster@1: while ($item = db_fetch_object($items)) { webmaster@1: $summary_items[] = theme('aggregator_summary_item', $item); webmaster@1: } webmaster@1: } webmaster@1: $category->url = url('aggregator/categories/'. $category->cid); webmaster@1: $output .= theme('aggregator_summary_items', $summary_items, $category); webmaster@1: } webmaster@1: webmaster@1: return theme('aggregator_wrapper', $output); webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Menu callback; generate an RSS 0.92 feed of aggregator items or categories. webmaster@1: */ webmaster@1: function aggregator_page_rss() { webmaster@1: $result = NULL; webmaster@1: // arg(2) is the passed cid, only select for that category webmaster@1: if (arg(2)) { webmaster@1: $category = db_fetch_object(db_query('SELECT cid, title FROM {aggregator_category} WHERE cid = %d', arg(2))); webmaster@1: $sql = 'SELECT i.*, f.title AS ftitle, f.link AS flink FROM {aggregator_category_item} c LEFT JOIN {aggregator_item} i ON c.iid = i.iid LEFT JOIN {aggregator_feed} f ON i.fid = f.fid WHERE cid = %d ORDER BY timestamp DESC, i.iid DESC'; webmaster@1: $result = db_query_range($sql, $category->cid, 0, variable_get('feed_default_items', 10)); webmaster@1: } webmaster@1: // or, get the default aggregator items webmaster@1: else { webmaster@1: $category = NULL; webmaster@1: $sql = 'SELECT i.*, f.title AS ftitle, f.link AS flink FROM {aggregator_item} i INNER JOIN {aggregator_feed} f ON i.fid = f.fid ORDER BY i.timestamp DESC, i.iid DESC'; webmaster@1: $result = db_query_range($sql, 0, variable_get('feed_default_items', 10)); webmaster@1: } webmaster@1: webmaster@1: $feeds = array(); webmaster@1: while ($item = db_fetch_object($result)) { webmaster@1: $feeds[] = $item; webmaster@1: } webmaster@1: return theme('aggregator_page_rss', $feeds, $category); webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Theme the RSS output. webmaster@1: * webmaster@1: * @param $feeds webmaster@1: * An array of the feeds to theme. webmaster@1: * @param $category webmaster@1: * A common category, if any, for all the feeds. webmaster@1: * @ingroup themeable webmaster@1: */ webmaster@1: function theme_aggregator_page_rss($feeds, $category = NULL) { webmaster@1: drupal_set_header('Content-Type: application/rss+xml; charset=utf-8'); webmaster@1: webmaster@1: $items = ''; webmaster@1: $feed_length = variable_get('feed_item_length', 'teaser'); webmaster@1: foreach ($feeds as $feed) { webmaster@1: switch ($feed_length) { webmaster@1: case 'teaser': webmaster@1: $teaser = node_teaser($feed->description); webmaster@1: if ($teaser != $feed->description) { webmaster@1: $teaser .= '

'. t('read more') ."

\n"; webmaster@1: } webmaster@1: $feed->description = $teaser; webmaster@1: break; webmaster@1: case 'title': webmaster@1: $feed->description = ''; webmaster@1: break; webmaster@1: } webmaster@1: $items .= format_rss_item($feed->ftitle .': '. $feed->title, $feed->link, $feed->description, array('pubDate' => date('r', $feed->timestamp))); webmaster@1: } webmaster@1: webmaster@1: $site_name = variable_get('site_name', 'Drupal'); webmaster@1: $url = url((isset($category) ? 'aggregator/categories/'. $category->cid : 'aggregator'), array('absolute' => TRUE)); webmaster@1: $description = isset($category) ? t('@site_name - aggregated feeds in category @title', array('@site_name' => $site_name, '@title' => $category->title)) : t('@site_name - aggregated feeds', array('@site_name' => $site_name)); webmaster@1: webmaster@1: $output = "\n"; webmaster@1: $output .= "\n"; webmaster@1: $output .= format_rss_channel(t('@site_name aggregator', array('@site_name' => $site_name)), $url, $description, $items); webmaster@1: $output .= "\n"; webmaster@1: webmaster@1: print $output; webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Menu callback; generates an OPML representation of all feeds. webmaster@1: * webmaster@1: * @param $cid webmaster@1: * If set, feeds are exported only from a category with this ID. Otherwise, all feeds are exported. webmaster@1: * @return webmaster@1: * The output XML. webmaster@1: */ webmaster@1: function aggregator_page_opml($cid = NULL) { webmaster@1: if ($cid) { webmaster@1: $result = db_query('SELECT f.title, f.url FROM {aggregator_feed} f LEFT JOIN {aggregator_category_feed} c on f.fid = c.fid WHERE c.cid = %d ORDER BY title', $cid); webmaster@1: } webmaster@1: else { webmaster@1: $result = db_query('SELECT * FROM {aggregator_feed} ORDER BY title'); webmaster@1: } webmaster@1: webmaster@1: $feeds = array(); webmaster@1: while ($item = db_fetch_object($result)) { webmaster@1: $feeds[] = $item; webmaster@1: } webmaster@1: webmaster@1: return theme('aggregator_page_opml', $feeds); webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Theme the OPML feed output. webmaster@1: * webmaster@1: * @param $feeds webmaster@1: * An array of the feeds to theme. webmaster@1: * @ingroup themeable webmaster@1: */ webmaster@1: function theme_aggregator_page_opml($feeds) { webmaster@1: webmaster@1: drupal_set_header('Content-Type: text/xml; charset=utf-8'); webmaster@1: webmaster@1: $output = "\n"; webmaster@1: $output .= "\n"; webmaster@1: $output .= "\n"; webmaster@1: $output .= ''. check_plain(variable_get('site_name', 'Drupal')) ."\n"; webmaster@1: $output .= ''. gmdate('r') ."\n"; webmaster@1: $output .= "\n"; webmaster@1: $output .= "\n"; webmaster@1: foreach ($feeds as $feed) { webmaster@1: $output .= '\n"; webmaster@1: } webmaster@1: $output .= "\n"; webmaster@1: $output .= "\n"; webmaster@1: webmaster@1: print $output; webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Process variables for aggregator-summary-items.tpl.php. webmaster@1: * webmaster@1: * @see aggregator-summary-item.tpl.php webmaster@1: */ webmaster@1: function template_preprocess_aggregator_summary_items(&$variables) { webmaster@1: $variables['title'] = check_plain($variables['source']->title); webmaster@1: $variables['summary_list'] = theme('item_list', $variables['summary_items']); webmaster@1: $variables['source_url'] = $variables['source']->url; webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Process variables for aggregator-summary-item.tpl.php. webmaster@1: * webmaster@1: * @see aggregator-summary-item.tpl.php webmaster@1: */ webmaster@1: function template_preprocess_aggregator_summary_item(&$variables) { webmaster@1: $item = $variables['item']; webmaster@1: webmaster@1: $variables['feed_url'] = check_url($item->link); webmaster@1: $variables['feed_title'] = check_plain($item->title); webmaster@1: $variables['feed_age'] = t('%age old', array('%age' => format_interval(time() - $item->timestamp))); webmaster@1: webmaster@1: $variables['source_url'] = ''; webmaster@1: $variables['source_title'] = ''; webmaster@1: if (!empty($item->feed_link)) { webmaster@1: $variables['source_url'] = check_url($item->feed_link); webmaster@1: $variables['source_title'] = check_plain($item->feed_title); webmaster@1: } webmaster@1: } webmaster@1: webmaster@1: /** webmaster@1: * Process variables for aggregator-feed-source.tpl.php. webmaster@1: * webmaster@1: * @see aggregator-feed-source.tpl.php webmaster@1: */ webmaster@1: function template_preprocess_aggregator_feed_source(&$variables) { webmaster@1: $feed = $variables['feed']; webmaster@1: webmaster@1: $variables['source_icon'] = theme('feed_icon', $feed->url, t('!title feed', array('!title' => $feed->title))); webmaster@1: $variables['source_image'] = $feed->image; webmaster@1: $variables['source_description'] = aggregator_filter_xss($feed->description); webmaster@1: $variables['source_url'] = check_url(url($feed->link, array('absolute' => TRUE))); webmaster@1: webmaster@1: if ($feed->checked) { webmaster@1: $variables['last_checked'] = t('@time ago', array('@time' => format_interval(time() - $feed->checked))); webmaster@1: } webmaster@1: else { webmaster@1: $variables['last_checked'] = t('never'); webmaster@1: } webmaster@1: webmaster@1: if (user_access('administer news feeds')) { webmaster@1: $variables['last_checked'] = l($variables['last_checked'], 'admin/content/aggregator'); webmaster@1: } webmaster@1: }