<?php
include('config.php');
header("content-type: application/rss+xml");
echo '<?xml version="1.0" encoding="koi8-r"?>
<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/">
<channel>
<title>recovered.info</title>
<link>http://recovered.info/</link>
<description>recovered.info forum</description>
<language>ru-ru</language>';
if (!($mysql = mysql_connect($dbhost, $dbuser, $dbpasswd)))
return 0;
if (!($db = mysql_select_db($dbname)))
return 0;
$result = mysql_query('select phpbb_posts.topic_id, max(phpbb_posts.post_id),
phpbb_topics.topic_title, phpbb_forums.forum_name,
max(phpbb_posts.post_time) as last_post_time,
phpbb_forums.forum_id
from phpbb_topics, phpbb_posts, phpbb_forums
where ( phpbb_topics.topic_id = phpbb_posts.topic_id ) and
( phpbb_topics.forum_id = phpbb_forums.forum_id )
group by phpbb_posts.topic_id
order by last_post_time desc
limit 15');
while (list($topic_id, $post_id, $topic_title,
$forum_name, $last_post_time, $forum_id) = mysql_fetch_row($result)) {
echo '
<item>
<title>'.htmlspecialchars($topic_title).'</title>
<link>http://recovered.info/viewtopic.php?p='.$post_id.'#'.$post_id.'</link>
<description>
topic:
<a href="http://recovered.info/viewtopic.php?t='.$topic_id.'">'.
htmlspecialchars($topic_title).
'</a>
<br />
forum:
<a href="http://recovered.info/viewforum.php?f='.$forum_id.'">'.
htmlspecialchars($forum_name).
'</a>
</description>
<category>'.
htmlspecialchars($forum_name).
'</category>
<dc:date>'.
strftime('%y-%m-%dt%h:%m:%s+02:00', $last_post_time).
'</dc:date>
</item>';
} // while - fetch rows
mysql_free_result($result);
echo '
</channel>
</rss>';
mysql_close($mysql);
?>
