The Arcive of vBulletin Modifications Site. |
|
|
|||||||
|
Display the average number of new registrations per day
 Spinball
Join Date: Feb 2002
Posts: 705
Telford, England
09-12-2004, 09:00 PM
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. Code:
SELECT COUNT(userid) as Total_registered_users, COUNT(userid)/30 as Average_per_day from user WHERE user.usergroupid = 2 AND user.joindate >= UNIX_TIMESTAMP(DATE_SUB(NOW(),INTERVAL 30 DAY)); 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. 
|
|
#2
11-29-2004, 07:51 AM
|
||||
|
||||
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 ;-)
|
|
#3
11-29-2004, 09:16 AM
|
||||
|
||||
|
This turned into a full-on hack
https://vborg.vbsupport.ru/showthread.php?t=69392
|
 |
«
Previous Thread
|
Next Thread
»
|
|
All times are GMT. The time now is 04:25 PM.