Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Full Releases

Reply
 
Thread Tools
Number of new members statistic on forum home Details »»
Number of new members statistic on forum home
Version: 1.00, by Spinball Spinball is offline
Developer Last Online: Oct 2023 Show Printable Version Email this Page

Version: 3.0.3 Rating:
Released: 09-12-2004 Last Update: Never Installs: 12
 
No support by the author.

I wanted to show potential advertisers as well as potential forum members how many people are registering to use our forums every day.
So I wrote this hack to display a 30 day average in the stats box of the forum home. It counts the number of people in user group 2 - registered members, ignoring those people who haven't activated their accounts, yet.
It's very easy, takes just a few minutes and requires 1 additional query.
You can see it working at www.avforums.com.
Please click Install if you use it.
Thanks to Bryan Ex for doing a bit of bug fixing help

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #12  
Old 09-13-2004, 08:19 PM
Johnny's Avatar
Johnny Johnny is offline
 
Join Date: Jun 2002
Posts: 290
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

o ok, so basicly a percentage... i see now, thx. and nice hack
Reply With Quote
  #13  
Old 09-13-2004, 10:17 PM
Spinball's Avatar
Spinball Spinball is offline
 
Join Date: Feb 2002
Location: Telford, England
Posts: 705
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Not a percentage, no. An average.

Yeah how do you show how many people are registering?
Just showing the number of people in the last day doesn't represent what is really going on since it could be a particularly busy or quiet day.
So it seems fair to show the number of users in the last month or so. Well 30 days.
I think it sounds impressive if you quote the number of new users per day as an average with decimal points. It makes you look 'on the ball' with what's happening on your forum.
Reply With Quote
  #14  
Old 09-13-2004, 10:30 PM
kall's Avatar
kall kall is offline
 
Join Date: Apr 2004
Location: New Zealand
Posts: 2,608
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Of course, all this assumes that none of your Registered members move into other Usergroups in this time, through Promotions or what have you.

I would probably use something more like
PHP Code:
user WHERE usergroupid NOT IN 3 
(assuming I didn't want to count the unconfirmed email ones).
Reply With Quote
  #15  
Old 09-13-2004, 10:40 PM
Spinball's Avatar
Spinball Spinball is offline
 
Join Date: Feb 2002
Location: Telford, England
Posts: 705
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I thought about this. For reasonably 'vanilla' boards like ours, there aren't any other user groups. However if I were excluding user groups rather than including them I would exclude banned and awaiting coppa users, too.
Reply With Quote
  #16  
Old 09-13-2004, 10:43 PM
kall's Avatar
kall kall is offline
 
Join Date: Apr 2004
Location: New Zealand
Posts: 2,608
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Spinball
I thought about this. For reasonably 'vanilla' boards like ours, there aren't any other user groups. However if I were exclusing user groups rather than including them I would exclude banned and awaiting coppa users, too.
Indeed. The query for that would be a bit more complicated than my just-woke-up brain can pull out of the ether at the moment tho.

Although, the banned ones are still new members...
Reply With Quote
  #17  
Old 09-13-2004, 10:49 PM
Spinball's Avatar
Spinball Spinball is offline
 
Join Date: Feb 2002
Location: Telford, England
Posts: 705
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by kall
Indeed. The query for that would be a bit more complicated than my just-woke-up brain can pull out of the ether at the moment tho.

Although, the banned ones are still new members...
I'm somewhat experienced in SQL so I can do that later.
Yes banned members can also be considered new members. But if you are being true to yourself and your advertisers, you don't count members who aren't going to contribute.
Reply With Quote
  #18  
Old 09-14-2004, 07:06 AM
Bryan Ex's Avatar
Bryan Ex Bryan Ex is offline
 
Join Date: Feb 2004
Location: Canada
Posts: 233
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hmmm... something isn't right here. My stats have been at 0.00 all day with over 100 joins. Two lines of code and I've spent an hour trying to figure it out (feeling like a dork the whole time). Has anyone else actually done an install on this one?
Reply With Quote
  #19  
Old 09-14-2004, 04:36 PM
Spinball's Avatar
Spinball Spinball is offline
 
Join Date: Feb 2002
Location: Telford, England
Posts: 705
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Is user group 2 registered members, Bryan?

To see it in a manual way, go to your admin CP / Statistics & Logs / Statistics / Registration Statistics and highlight and copy (CTRL+C) the contents of the table (all 3 columns - date, graphic bar and number) into memory.
Then open word and paste in there.
Highlight and delete the first two columns leaving the table of numbers.
Then in Word do a convert table to text. Doesn't matter what seperator is specified.
Then copy the lot and paste into an Excel spreadsheet.
Sum the numbers (highlight from the top number all the way down to the empty cell below the bottom number and click the sum button).
Then in calculator, enter the total and divide by the number of rows (it'll be 30 or 31).
And that's your average number of new registrations in total over the last 30 or 31 days.
The manual method is long winded and doesn't excluded non-activated registrations, but it's a way to get the numbers wthout hacking.

The hack is a lot easier in the long run
Reply With Quote
  #20  
Old 09-14-2004, 04:46 PM
Bryan Ex's Avatar
Bryan Ex Bryan Ex is offline
 
Join Date: Feb 2004
Location: Canada
Posts: 233
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Spinball
Is user group 2 registered members, Bryan?
Yep... usergroup 2. I'm not getting any type of error and everything seems to run properly. I'm just not getting any data output on Forum Home. I am using 3.0.1 but that shouldn't matter for this... or would it?
Reply With Quote
  #21  
Old 09-14-2004, 05:45 PM
Spinball's Avatar
Spinball Spinball is offline
 
Join Date: Feb 2002
Location: Telford, England
Posts: 705
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

My honest answer is that I don't know - but I wouldn't have thought so.
It being 0.00 would indicate that the numeric value is either not being returned properly from the SQL query or passed from that query though to the data array.
Can you run the query on your database to see if that bit works?
Reply With Quote
Reply

Thread Tools

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

Forum Jump


All times are GMT. The time now is 07:06 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04481 seconds
  • Memory Usage 2,303KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_php
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete