Well, I was sort of bored… and wrote a RSS generator for the forums. So, seeing as I used to check the site on a daily-ish basis to see if there were any new posts on the forums, you can now just subscribe to http://forums.ssnt.org/rss/ with your preferred RSS client. It should be noted that I might change things around a bit in the feed in the coming days. Also, the SQL statement is just mean - peek it after the break.

(If you weren’t aware, we’ve been offering a news feed for ages at http://www.ssnt.org/feed, and the wiki Recent Changes feed is at http://wiki.ssnt.org/index.php?title=Special:Recentchanges&feed=rss - I haven’t really tested that one tho, seeing as I’m ignoring the wiki.)

So I’m just a couple clicks away from never having to visit the site again! And so are you, dear reader!
(Uh, and I’ll be less likely to notice things going wrong. Be sure to post in the forums if stuff breaks, and if the forums are broken, good luck.)

Update: I’ve figured out the comments feed too, so you might want to subscribe to http://www.ssnt.org/comments/feed/ too.

-CCTSM

SQL statement to grab the stuff included in the feed: (might include pointless stuff too, I don’t care)

SELECT phpbb_topics.topic_id, phpbb_topics.topic_title, phpbb_posts_text.post_subject,
phpbb_posts_text.post_text, phpbb_posts_text.bbcode_uid, phpbb_topics.topic_last_post_id,
phpbb_topics.topic_first_post_id, phpbb_users.username, phpbb_posts.post_time, phpbb_forums.forum_name
FROM phpbb_topics, phpbb_posts, phpbb_users, phpbb_posts_text, phpbb_forums
WHERE phpbb_topics.forum_id
AND phpbb_topics.topic_last_post_id = phpbb_posts.post_id
AND phpbb_users.user_id = phpbb_posts.poster_id
AND phpbb_posts_text.post_id = phpbb_posts.post_id
AND phpbb_forums.forum_id = phpbb_topics.forum_id
GROUP BY phpbb_topics.topic_id
ORDER BY phpbb_topics.topic_last_post_id DESC
LIMIT 10;

This entry was posted on Friday, August 8th, 2008 at 1:28 pm, by CCTSM. It is filed under General.