vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Number of new members statistic on forum home (https://vborg.vbsupport.ru/showthread.php?t=69392)

Johnny 09-13-2004 08:19 PM

o ok, so basicly a percentage... i see now, thx. and nice hack

Spinball 09-13-2004 10:17 PM

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.

kall 09-13-2004 10:30 PM

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

Spinball 09-13-2004 10:40 PM

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.

kall 09-13-2004 10:43 PM

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...

Spinball 09-13-2004 10:49 PM

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.

Bryan Ex 09-14-2004 07:06 AM

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?

Spinball 09-14-2004 04:36 PM

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

Bryan Ex 09-14-2004 04:46 PM

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?

Spinball 09-14-2004 05:45 PM

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?


All times are GMT. The time now is 11:14 AM.

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.02566 seconds
  • Memory Usage 1,741KB
  • 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_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete