Show last 24 hours ...

[Lee Herron]

Anyone want to knock out a couple of quick links?

Show Posts from last 24 hours

Show 25 newest Hot Topics

I know we have a view new posts, but this is based on when we last visted (I think) which is nice, but sometimes you just want a quick list of the last day's worth of posts.

Same kind of thing with the hot topics.

I can look into this Sunday, but thought I'd toss it out there for anyone that happens to be fast with VB2 queries..

[eva2000]

i use this link to see posts for the last 24 hrs

http://vbulletin.com/forum/search.php?s=&action=getdaily :)

[Lee Herron]

That's odd that that routine already existed -- is it already being used somewhere in vBB?

Also, no one interested in writing the SQL query for the 25 most recent hot topics? If you include the body, I might even write a summery ... I'm probably going to write this in perl so it can be a crontab event and create a text for ssi inclusion.

Thanks for the link.

[Lee Herron]

I'm working on a script to return a short summery of hot topics within active within the last 24 hours -- anyone improve on this query?

SELECT thread.*,post.* FROM thread,post WHERE thread.threadid=post.threadid AND thread.replycount > 25 AND lastpost > (unix_timestamp(curdate())-86400)