Register Members List Search Today's Posts Mark Forums Read

Article Options
Display the average number of new registrations per day
Join Date: Feb 2002
Posts: 705

Telford, England
by Spinball Spinball is offline 13 Sep 2004

Another SQL script I thought would be interesting and a good one to quote to potential advertisers.
The total number of confirmed new registrations in the last 30 days and the average per day.

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

Of course you can change the timespan from 30 days to 60 or whatever by changing the 2 occurences of '30' to however many days you want.
And by checking that the users are in usergroup 2, we are only looking at those members who activated their registration.

Hope this is useful to the non-SQL oriented folks out there.
Views: 2429
Reply With Quote
Old 29 Nov 2004, 08:51
Lee Wilde's Avatar
Lee Wilde Lee Wilde is offline
Join Date: Apr 2004
Real name: Lee Wilde
That's cool. Which file would I include it in, and where in the file? And how would I call the code to display the result? You can tell I am a real coding brainiac. Not. But I get by ;-)
Reply With Quote
Old 29 Nov 2004, 10:16
Spinball's Avatar
Spinball Spinball is offline
Join Date: Feb 2002
This turned into a full-on hack
__________________ 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.
Reply With Quote

Similar Article
Article Author Type Replies Last Post
Statistics Modifications Average registrations per day statistics Adult SEO vBulletin 3.6 Add-ons 8 17 Sep 2007 12:58

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 17:55.

Layout Options | Width: Wide Color: