<?php
$db_user = ""; // db username
$db_pass = ""; // db password
$db_host = "localhost"; // db host
$db = ""; // db
$adminmail = "miro@it-bg.eu"; // administrator e-mail
$websitetitle = "Заглавие"; // title of your website
$website = "адрес";
$rssdescr = "Описание";
$year = "2007";
?>
<?php
header ("Content-type: text/xml");
echo ("<?xml version=\"1.0\" encoding=\"windows-1251\"?>\n");
?>
<rss version="1.0">
<channel>
<title>Заглавие</title>
<link><?php echo "$website";?></link>
<description><?php echo "$rssdescr";?></description>
<copyright>(c) <?php echo "$year"; ?> The IT portal</copyright>
<ttl>60</ttl>
<language>bg-BG</language>
<webMaster><?php echo "$adminmail";?></webMaster>
<?php
mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db("$db") or die("Unable to select database");
$result = mysql_query("SELECT c.topic_time , c.topic_title,c.forum_id,c.topic_id, c.topic_replies,c.topic_type FROM phpbb_topics c , phpbb_forums f WHERE c.forum_id=f.forum_id and f.auth_view like '0' ORDER BY c.topic_time LIMIT 25") or die(mysql_error());
while ($row = mysql_fetch_array($result)){
echo "<item><title>";
echo "$row[topic_title]";
echo "</title>";
echo "<link>";
echo "http://it-bg.eu/forum/viewtopic.php?t=$row[topic_id]";
echo "</link>";
echo "<description><![CDATA[ ";
echo "$row[topic_title]";
echo "] ]> </description>";
echo "</item>";
}
mysql_free_result ($result);
?>
</channel>
</rss>
