Take items from the news Aggregator

Hum.. This is not possible by itself, since news aggregator items are not nodes. But you could try to use it along with leech module, and it might work.

If there's someone else interested in this.

I also wanted to have a ticker for aggregator news, and didn't want to grab it all as leech does, so I created this workaround. I haven't really gone back to see how to do it better, but it works.

In a PHP block, I added the following:

<?php
// Last update: May 7 2006

drupal_add_js(drupal_get_path('module', 'taxonomy_ticker') . '/taxonomy_ticker.js');

//$result = db_query("SELECT a.title, a.url, a.fid, a.link FROM {aggregator_feed} a ORDER BY a.title");
$result = db_query("SELECT * FROM {aggregator_item} ORDER BY timestamp DESC, iid DESC");

$output = '<div id="scrollerClipper" style="z-index:8" onmouseover="pauseScroll();" onmouseout="reStartScroll();"><div id="outerscrollPane"><div id="scrollPane" style="position:relative; top:0px ; left:0px;">';
//$output .= '<ul>';

while ($feed = db_fetch_object($result)) {
      $output .= '<div class="scrollerContentItem"><p>' . l($feed->title, $feed->link, array('target' => '_blank')) . '</p></div>';
//    $output .= '<li>' . l($feed->title, $feed->link) . '</li>';
}
// $output .= '</ul>';

$output .= '</div></div></div>';

$output .= '<p><a href="/aggregator/sources">more</a></p>';
return $output;
?>

You can see all I wanted was a listing of linked titles not separated by anything (category, author, etc.). I left another query that I started with (I think I got it from the aggregator block listing or something), and the code to bullet them if you want.

BTW, I've been having the same problem as another poster of the ticker's heavy CPU use as it's running (processing goes down if the mouse is over the block and it stops scrolling). I get it in IE and Firefox. If anyone has a solution to this it would be appreciated.