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