The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Number of new members statistic on forum home Details »» | |||||||||||||||||||||||||||
Number of new members statistic on forum home
Developer Last Online: Oct 2023
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
|
Comments |
#12
|
||||
|
||||
o ok, so basicly a percentage... i see now, thx. and nice hack
|
#13
|
||||
|
||||
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. |
#14
|
||||
|
||||
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:
|
#15
|
||||
|
||||
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.
|
#16
|
||||
|
||||
Quote:
Although, the banned ones are still new members... |
#17
|
||||
|
||||
Quote:
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. |
#18
|
||||
|
||||
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?
|
#19
|
||||
|
||||
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 |
#20
|
||||
|
||||
Quote:
|
#21
|
||||
|
||||
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? |
Thread Tools | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|