vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=69248

Display number of posts in last 24 hours by forum
by Spinball
09 Sep 2004 09:34

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


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Dean C 09 Sep 2004 09:59

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

Spinball 09 Sep 2004 10:05

I have put CODE tags in because the 'greater than or equal to'
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

characters don't come out right in the SQL tags. Thanks for your guidance, chaps

DrussRob 13 Jan 2008 22:25

How exactly do you input these into a php page?

Brandon Sheley 28 Jan 2008 12:47

Quote:

Originally Posted by DrussRob (Post 1420872)
How exactly do you input these into a php page?

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

matrex722 24 Mar 2013 18:05

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


All times are GMT. The time now is 21:37.

Powered by vBulletin® Version 3.8.12
Copyright © 2019, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.