[pogo]

I worked a little with you code Marshalus.
What had to be changed was the query to grab the latest active threads. My query shows only threads from non-private forums.
Then I added a replacement for german umlauts because Trillian doesn't show them correct.
You can tweak a lot to customize it further and for example insert some text from the latest post. But then you have to change the query.

PHP Code:

<?php
require("global.php");

//##############################################
// Variables used:
$description = "The latest active threads";
$replyword = "Replies";
$showthreadnumber = "15"; // show this many threads in the newsfeed
//##############################################

$search = array ("?","?","?","?","?","?","?");
$replace = array ("ue","oe","ae","Ue","Oe","Ae","ss");

header("Content-Type: text/xml");
echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n";
echo "<rdf:RDF xmlns:rdf=\"http://www.w3.org/1999/02/22-rdf-syntax-ns#\" xmlns=\"http://my.netscape.com/rdf/simple/0.9/\">";
echo "<channel>\n";
echo "<title>".$bbtitle."</title>\n";
echo "<link>".$bburl."</link>\n";
echo "<description>".$description."</description>";
echo "</channel>\n";

$threads=$DB_site->query("SELECT threadid,title,lastpost,replycount,postusername,thread.forumid
                          FROM thread
                          LEFT JOIN forumpermission USING(forumid)
                          WHERE visible=1
                          AND forumpermission.forumid IS NULL
                          ORDER BY lastpost DESC LIMIT ".$showthreadnumber);
while ($thread=$DB_site->fetch_array($threads)) {
  
  $title = str_replace($search, $replace, $thread[title]);
  $threadid=$thread[threadid];
  $replies=$thread[replycount];
  $firstposter=htmlspecialchars($thread[postusername]);
  $lastreplydate=date($dateformat,$thread[lastpost]+($timeoffset*3600));
  $lastreplytime=date($timeformat,$thread[lastpost]+($timeoffset*3600));

  echo "<item>\n";
  echo "<title>".htmlspecialchars($title)."</title>\n";
  echo "<link>$bburl/showthread.php?threadid=$threadid</link>\n";
  echo "<description> $firstposter - $replies $replyword - $lastreplydate $lastreplytime </description>\n";
  echo "</item>\n";
}

echo "</rdf:RDF>";

?>