Register Members List Search Today's Posts Mark Forums Read

Reply
 
Article Options
Display number of posts in last 24 hours by forum
Spinball
Join Date: Feb 2002
Posts: 704

Telford, England
by Spinball Spinball is offline 09 Sep 2004

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.


Last edited by Spinball; 09 Sep 2004 at 10:06..
Views: 8696
Reply With Quote
Comments
  #2  
Old 09 Sep 2004, 09:59
Dean C's Avatar
Dean C Dean C is offline
 
Join Date: Jan 2002
Real name: Dean Clatworthy
Thanks for sharing. Feel free to place [sql] tags around your queries
__________________
Dean Clatworthy - Web Developer/Designer
Reply With Quote
  #3  
Old 09 Sep 2004, 10:05
Spinball's Avatar
Spinball Spinball is offline
 
Join Date: Feb 2002
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
__________________
AVForums.com the UK's largest audio visual home consumer electronics forums. Now using Xenforo because vB5 is not suitable for large forums and vB3 and vB4 are no longer being developed.

Last edited by Spinball; 09 Sep 2004 at 10:07.
Reply With Quote
  #4  
Old 13 Jan 2008, 22:25
DrussRob DrussRob is offline
 
Join Date: Nov 2005
How exactly do you input these into a php page?
Reply With Quote
  #5  
Old 28 Jan 2008, 12:47
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Real name: Brandon
Originally Posted by DrussRob View Post
How exactly do you input these into a php page?
ya, it would be nice if a bit more was posted here
__________________

Email me for website help: brandon[at]sheley[dot]org
Reply With Quote
  #6  
Old 24 Mar 2013, 18:05
matrex722's Avatar
matrex722 matrex722 is offline
 
Join Date: Jan 2007
its not a php code i think
its order to mysql
i think you may use it in phpmyadmin
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Article Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 14:11.

Layout Options | Width: Wide Color: