Helpful Information
 
 
Category: Read An Article
Display number of posts in last 24 hours by forum

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;

Thanks for sharing. Feel free to place [sql] tags around your queries :)

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

How exactly do you input these into a php page?

How exactly do you input these into a php page?

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

its not a php code i think
its order to mysql
i think you may use it in phpmyadmin










privacy (GDPR)