Neuradni T-2 forum

Koda: Izberi vse

header("Content-Type: text/xml; charset=windows-1250");

// povezava na bazo foruma
   $host     = "localhost";
   $dbname   = "";
   $dbpasswd = "";
   $db       = "";
// koda ki je ni potrebno urejati ;)

mysql_connect("$host", "$dbname", "$dbpasswd") or die ("Could not connect to database");
mysql_select_db("$db") or die ("Could not select database");

$query = "SELECT * FROM phpbb_topics WHERE topic_approved='1' ORDER BY id DESC LIMIT 0,10;";

$result = mysql_query($query);
$num = mysql_numrows($result);

print "<?xml version=\"1.0\" encoding=\"windows-1250\"?>
<rss version=\"2.0\">
<channel>
<title>T-2 Forum RSS</title>
<link>http://t-2.rula.net</link>
<description>Neuradni T-2 forum RSS</description>
<language>sl</language>";

for ($i = 0; $i < $num; $i++) {

$title = mysql_result($result,$i,"topic_title");
$topicid = mysql_result($result,$i,"topic_id");
$forumid = mysql_result($result,$i,"forum_id");

$link = "http://t-2.rula.net/viewtopic.php?f={$forumid}&t={$topicid}";

print"<item>
<title>".$title"</title>
<link>".$link."</link>
<description>T-2</description>
</item>\n";
}
print "</channel></rss>";