 |
|
|
Article Options |
|
Display the average number of new registrations per day
by
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.
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. No members have liked this post.
|
||||
|
Views: 2426
|
||||
| Comments |
|
#2
29 Nov 2004, 08:51
|
||||
|
||||
|
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 ;-)
No members have liked this post.
|
|
#3
29 Nov 2004, 10:16
|
||||
|
||||
|
This turned into a full-on hack
http://www.vbulletin.org/forum/showthread.php?t=69392
__________________
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. No members have liked this post.
|
|
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 |
«
Previous Article
|
Next Article
»
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Article Options | |
|
|
| New To Site? | Need Help? |
All times are GMT. The time now is 03:53.
Powered by vBulletin® Version 3.8.14
Copyright © 2022, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright © 2022, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Design by Princeton
Copyright ©2001 - , vbulletin.org. All rights reserved.
vBulletin® is a registered trademark. 