Forum RSS feeds

[Tobi]

I just added RSS feed mod to forum, see the little RSS icon to the right of your address bar in Firefox.

I don't know where it is in other browsers but I bet you can find it if you look hard enough.

News feed includes the News and the Community News forums.

[AF]

I would reccomend adding an rss icon to the menu bar at the top for the news feeds

[yuritch]

Opera has RSS icon in the right of address bar as well, IE7 has it above the current tab, not sure about IE8.

[lurker]

I would reccomend adding an rss icon to the menu bar at the top for the news feeds

A bright orange RSS icon on that background?

[AF]

Why not? Could be blue even

[lurker]

I still don't like icons in that bar all that much. I'm looking at you, Home icon.

[Neddie]

Gracias, Tobi.

[Forboding Angel]

thanks tobi, daddy lieks

hmm hey now I can do a latest forum threads on springinfo dealie, nice! ;p

[Tobi]

RSS feed turned off for the moment, it contains epically unoptimized SQL queries that bring down mysql.

EDIT: also that probably means lobby shouldn't do this epic timeouts anymore. (or should occur way less often at least.)

[Forboding Angel]

Tobi, the rss has been down for quite a while now... Any chance of getting it back up any times soon?

*I QQ for server ftp access so that I could actually fix stuff myself without having to ask - But on the other hand, it would end up being mroe time consuming on my end, so I guess it's a blessing in disguise *

[lurker]

Fix... what?

[Tobi]

*I QQ for server ftp access so that I could actually fix stuff myself without having to ask - But on the other hand, it would end up being mroe time consuming on my end, so I guess it's a blessing in disguise *

I used this phpbb mod. Fixing it would amount to optimizing it's SQL queries so they don't examine total number of posts * number of forums included in feed (or whatever exact count is... it examined over 900k rows for Spring forum every request of the RSS feed.)

I see however it is a slightly newer version already (I used 1.09, 1.21 seems available now), I'll try to check sometime if this one has optimized queries already. (Would suprise me though, that would be too easy )

[Forboding Angel]

Hehe yeah I know the feeling

It's not THAT important really. It just helps me because I suck at keeping track of stuff.

[Tobi]

Thanks to tizbac there are two simple custom made feeds in place now; they should hopefully be faster then the MSSTI phpBB mod.

Links:

http://springrts.com/phpbb/newposts.php
http://springrts.com/phpbb/newsrss.php

[Forboding Angel]

AWESOME!!! Thx tobi!

[AF]

Can we have a version with the contents of the post and date? Preferably as part of the feed and not inserted in the title!

[Forboding Angel]

If you add what AF asks, could the simple listing still be left intact? The simple listing makes it ridiculously easy to put on springinfo without me having to do much work.

[Tobi]

I've no plans yet to do more work on the RSS feeds currently, but who knows what phpBB 3.0.6 brings. (I know it has some feed functionality added.)

EDIT: haha it brings the same feed I had disabled here for performance reasons. Well hopefully they have added some SQL indices / rewritten the queries so the official phpBB 3.0.6 version actually performs properly.

[Tobi]

Okay, as experiment I enabled the feed functionality of phpBB 3.0.6.