Page 1 of 1

Recent Posts

Posted: Mon Jul 19, 2004 7:26 am
by kettle_drum
Can we get a recent posts section that just lists like the 200 most recent posts like it does on the main page.

Posted: Mon Jul 19, 2004 3:57 pm
by d3ad1ysp0rk
SELECT * FROM posts WHERE last_post > $cutoff ORDER BY DESC LIMIT 200

Posted: Mon Jul 19, 2004 6:03 pm
by John Cartwright
LiLpunkSkateR wrote:SELECT * FROM posts WHERE last_post > $cutoff ORDER BY DESC LIMIT 200
har har..

Re: Recent Posts

Posted: Tue Jul 20, 2004 1:16 am
by JAM
kettle_drum wrote:Can we get a recent posts section that just lists like the 200 most recent posts like it does on the main page.
Can, yes, there shouldn't be any problem with actually coding it.
But you should provide abit more info on why you think this would be a good idea. Is it something that would benefit you alone, or is it something you know will help others in one way or the other?

Posted: Tue Jul 20, 2004 6:17 am
by kettle_drum
Well i would say that about 99% of my posts are replies helping other people out. So when i come on the site i just want a list of new posts that i can look through and then answer - now this works with the "posts since your last visit" thing, but i find that you lose track of them too easily.

I may come on the site and then leave again before checking out the latest posts and then all the new posts are gone and i cant get a list of the most recent posts without trawling through each forum which takes ages. Another thing is that questions seem to come in pairs, there will be the same question posted twice in a day and simply showing the last 200 or so posts would allow one to easily scroll through the list to find the previous post that would answer the new one.

The page to show the posts could also be customizable so that you select what you want to see at the top, such as:

Show:
-all posts
-unanswered
-new
-active (ones with replies in last few hours)

Number:
10
20
50
100
200

Order BY:
time
author
etc

And then we would only need one page to show all everything that we could possibly want to see.