<?php

/************************************************************************/
/* PHP-NUKE: Web Portal System                                          */
/* ===========================                                          */
/*                                                                      */
/* Copyright (c) 2005 by Francisco Burzi                                */
/* http://phpnuke.org                                                   */
/*                                                                      */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License.       */
/************************************************************************/

include("mainfile.php");
include("includes/ipban.php");
global $prefix, $db, $nukeurl;
header("Content-Type: text/xml");
$cat = intval($cat);
if ($cat != "") { 
    $result = sql_query("SELECT catid from ".$prefix."_stories_cat where title LIKE '%$cat%' and topic='10' limit 1", $dbi); 
    list ($catid) = sql_fetch_row($result, $dbi); 
    if ($catid == "") { 
        $result = sql_query("SELECT sid, title FROM ".$prefix."_stories  where topic='10' ORDER BY sid DESC limit 10", $dbi); 
    } else { 
        $result = sql_query("SELECT sid, title FROM ".$prefix."_stories WHERE catid='$catid'  and topic='10' ORDER BY sid DESC limit 10", $dbi); 
    } 
} else { 
    $result = sql_query("SELECT sid, title FROM ".$prefix."_stories where topic='10' ORDER BY sid DESC limit 10", $dbi); 
} 

echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n\n";
echo "<!DOCTYPE rss PUBLIC \"-//Netscape Communications//DTD RSS 0.91//EN\"\n";
echo " \"http://my.netscape.com/publish/formats/rss-0.91.dtd\">\n\n";
echo "<rss version=\"0.91\">\n\n";
echo "<channel>\n";
echo "<title>".htmlspecialchars($sitename)."</title>\n";
echo "<link>$nukeurl</link>\n";
echo "<description>".htmlspecialchars($backend_title)."</description>\n";
echo "<language>$backend_language</language>\n\n";

while ($row = $db->sql_fetchrow($result)) {
	$rsid = intval($row['sid']);
	$rtitle = $row['title'];
	$rtext = $row['hometext'];
	echo "<item>\n";
	echo "<title>".htmlspecialchars($rtitle)."</title>\n";
	echo "<link>$nukeurl/modules.php?name=News&amp;file=article&amp;sid=$rsid</link>\n";
	echo "<description>".htmlspecialchars($rtext)."</description>\n";
	echo "</item>\n\n";
}
echo "</channel>\n";
echo "</rss>";

?>