DrupalAPI.de

1. drupal
   1. drupal6
   2. drupal7

Load feed items by passing a SQL query.

Übergabeparameter

$sql The query to be executed.

Rückgabewert

An array of the feed items.

Code

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

<?php
function aggregator_feed_items_load($sql) {
  $items = array();
  if (isset($sql)) {
    $result = pager_query($sql, 20);
    while ($item = db_fetch_object($result)) {
      $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);
      $item->categories = array();
      while ($item_categories = db_fetch_object($result_category)) {
        $item->categories[] = $item_categories;
      }
      $items[$item->iid] = $item;
    }
  }
  return $items;
}
?>