vb.org Archive - Display the average number of new registrations per day

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- General Articles (https://vborg.vbsupport.ru/forumdisplay.php?f=189)

- - Display the average number of new registrations per day (https://vborg.vbsupport.ru/showthread.php?t=69385)

Spinball

09-12-2004 10:00 PM

Display the average number of new registrations per day

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));

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.

Lee Wilde

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 ;-)

Spinball

11-29-2004 09:16 AM

This turned into a full-on hack
https://vborg.vbsupport.ru/showthread.php?t=69392

All times are GMT. The time now is 10:51 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00985 seconds Memory Usage 1,708KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: