PDA

View Full Version : Display number of posts in last 24 hours by forum


Spinball
09-08-2004, 10:00 PM
Don't know where to post these or even if they are welcome but hopefully someone will find them useful or tell me where to re-post them.

Got a couple of MySQL scripts to report the number of posts in the last 24 hours:

Total number of posts in the last 24 hours

SELECT COUNT(postid) from post WHERE post.dateline >= UNIX_TIMESTAMP(DATE_SUB(NOW(),INTERVAL 24 HOUR));

Total number of posts for each active, visible forum. Doesn't include password protected forums unless you edit to specify passwords.

SELECT forum.title,COUNT(postid) from post,thread,forum WHERE post.threadid = thread.threadid AND thread.forumid = forum.forumid AND forum.displayorder > 0 AND forum.parentid > -1 AND (forum.password='' or forum.password in ('password1','password2')) AND post.dateline >= UNIX_TIMESTAMP(DATE_SUB(NOW(),INTERVAL 24 HOUR)) GROUP BY forum.forumid ORDER BY forum.title LIMIT 1000;

Dean C
09-09-2004, 08:59 AM
Thanks for sharing. Feel free to place [sql] tags around your queries :)

Spinball
09-09-2004, 09:05 AM
I have put CODE tags in because the 'greater than or equal to' '>=' characters don't come out right in the SQL tags. Thanks for your guidance, chaps

DrussRob
01-13-2008, 09:25 PM
How exactly do you input these into a php page?

Brandon Sheley
01-28-2008, 11:47 AM
How exactly do you input these into a php page?

ya, it would be nice if a bit more was posted here :(

matrex722
03-24-2013, 06:05 PM
its not a php code i think
its order to mysql
i think you may use it in phpmyadmin