UseBB Community

Hi All,
I love the software! I'm not sure how to use the RSS. I used Topics Anywhere with the phpBB2 software. I want to place active topics on our home page. Can someone please help?
Thanks,
Dennis

Thanks, but how can I get the RSS feed to work?
Dennis

No problem. You can active RSS by the following:

ACP -> General Configuration -> Additional Features -> Enable RSS feed

Just enable the RSS feed, you will then have to process it using an XML parser.

Although it would be a far better idea to fetch them directly from the database instead of having to do a request for the RSS feed.

I got it work with this script. Awesome!
What would I need to change to get the "active topics" to be displayed?

<?php
mysql_connect('localhost', 'user', 'pass');mysql_select_db('database');$result = mysql_query("SELECT t.id, t.topic_title, t.count_replies, t.count_views, t.status_locked, p.content, p.post_time, p.poster_id, u.displayed_name FROM usebb_topics t, usebb_posts p, usebb_members u WHERE t.forum_id = 2 AND t.status_sticky = 0 AND p.id = t.first_post_id AND u.id = p.poster_id ORDER BY p.post_time DESC LIMIT 5");echo '<ul>';while ($news = mysql_fetch_array($result)) { echo '<li><a href="forum/topic.php?id='.$news['id'].'">'; echo htmlspecialchars($news['topic_title']).'</a></li>'; }echo '</ul>'; ?>

Dennis