Ah, well...no there it isn't... I looked at that part of the code earlier today, and the problem here is that the topics and replies get sorted on T_LAST_POST_DATE of the topic. And that means that the following thing could happen:
say 1 month ago you posted to 15 different topics 2 days ago you posted to another topic today someone else replied to all 15 topics from that one month ago. then you won't see the topic you posted 2 days ago to, because sorted on T_LAST_POST_DATE that topic would be nr 16.
I know that that means that what is shown isn't totally correct if you expect to see a listing of the last 10 posts, with the newst ranked 1 and the 10th oldest ranked 10, but I can't think of a query that would do that (at least not at the moment after 4 days of bugchecking with about 4 hours sleep per night).
Anyone want to have a hand at this? It does sound a bit difficult. Would it be worth it to adjust the way the recent topics are shown or leave it as it is? I don't think many users use the recent topics section that it would be something really urgent to adjust. I use it sometimes just to see what other topics a member has been posting in. But rarely I do.
Topic Locked
Posted - 23 July 2001 : 23:34:14
