• Registered: 2009-07-21
  • Posts: 1

Topic: Help: RSS post order after replies - stop the bump!

Hi,
I have a small issue with RSS which is making problems for my site. With this solved i could bypass the need for Wordpress or Portal and keep the website a lot more simple by just using punbb forums and their RSS outputs on external PHP pages for 'latest news' and 'latest blogs' etc. 
Please help!

The Problem: RSS post order after comments

RSS doesn't use the forums 'sort by' order. When someone makes a reply post, it bumps the topic to the top of the
RSS list - even when the forum is set to 'sort topics by: topic post'. Having posts 'sticky' still doesn't hold their position in the RSS output either, replies always bump topics in RSS output.

I have a 'Latest News' forum feeding a custom 'Latest News' php file on my website using RSS Reader which displays the RSS info with CSS.
It all works well and using CSS i can make it display how i want - BUT when a topic gets a reply in the forum, it bumps the topic to the top of the RSS output, making old news bump to the top of the 'latest news' Php page.

Q: is it possible to edit extern.php to keep the RSS topics sorted by 'topic post' rather than bumping topics after a new reply?
I guess extern is where it needs some edits but i have no clue how to do it!

Please help, it would save a LOT of headaches.
Thanks.

  • Registered: 2007-09-27
  • Posts: 32

Re: Help: RSS post order after replies - stop the bump!

As far as I remember, two files are used when generating RSS: the first one is used for output, the second one generates the initial RSS page. DB connection is established during generation of the second file.

If I understand you correctly, you want newly added topics to be displayed at the top, right?
If so, then try sorting by column:

$sql_query = ' . . . ORDER BY last_post DESC';

In the 'topics' table, when you are picking topic information, there is that 'last_post' field, which stores the last post's time