rendered paste body<?php
require_once("config.php");
header('Content-type: text/xml; charset=ISO-8859-1');
echo '<?xml version="1.0" encoding="ISO-8859-1"?>';
mysql_connect($dbhost, $dbuser, $dbpasswd);
mysql_select_db($dbname);
?>
<rss version="2.0">
<channel>
<title>Dein Titel</title>
<link>http://graveguard.ath.cx</link>
<description>Beschreibung</description>
<language>de-de</language>
<?
$sql = "SELECT * FROM ".$table_prefix."posts ORDER BY `post_id` DESC LIMIT 15";
$query = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_assoc($query))
{
echo "<item>\n";
echo "<title>".$row["post_subject"]."</title>\n";
echo "<description>".substr($row["post_text"], 0, 100)."...</description>\n";
echo "<link>http://graveguard.ath.cx/phpBB3/viewtopic.php?f=".$row["forum_id"]."&t=".$row["topic_id"]."#p".$row["post_id"]."</link>\n";
echo "<guid>".$row["post_id"]."</guid>";
echo "</item>\n";
}
?>
<copyright>Dein Copyright</copyright>
</channel>
</rss>