This hack is not a good idea to install on your boards, especially busy ones, because any sql query that uses select count(*) degrades mysql performance by counting a large number of rows from the user table.

I like the idea, i just don't like to install this because I am sure it will kill performance.

I regularly prune my member database every month for inactive members who 1.) have never made a post + 2.) have not visited the site in 3 months ... so I probably won't need this hack ... good idea tho, congrats ;)

Did you even look at the code? There are no added queries in this hack. Specifically, it uses a query already needed by forumhome (the one that generates the newuserid) and simply formats that number using an in-the-box routine.

Our forum has hundreds of simultaneous users, and we have experienced no increase in server load.

Kaelon

Hehe, I did this in my 4th hack I think, it's really amazing that no one did do it separately. In my hack I did the same for threads and posts (shows posts posted total and threads posted total) and I've done the same for vB3.

Nice work Kaelon, hopefully people will use it, because it should technically be standard vBulletin, to show members total, registered, but that's just my opinion.

I'm still a little confused as to what this does *confused*? :)

- miSt

i wasl also confused but then i noticed if you put a comma right after (active) it will all make sence


ok if your forum has had a total of 1,287 members since you opend total.

and you prune 500 off because of inactivity

this hac will say

Current Active # of Members: 787
Total To date reg. members 1,287

S.Shady is correct; it essentially takes the $newuserid variable and runs it through the format_number routine, and displays it. This gives users an idea of how many accounts have ever been created on a forum (since $newuserid is sequential).

This, of course, means different things for different forums. For my forum, it represents the number of total members registered, but not pruned due to inactivity (since we regularly prune thousands of inactive accounts).

Kaelon

I don't want to spoil your fun, but ... why does this require source code hacking ?

The 'welcome to our latest member' .. his userid is the last one in the database, and therefor also the total amount you want to get right ? Just display that.

Total registrations, ever: $newuserid
Total active members: $numbermembers

You have a point: xiphoid, but I guess you still could call this a hack as it does involve file editing.

Then I will rephrase my point: It is an obsolete hack!

vBulletin's forumhome already lets you have this number, why stress the server to re-calculate it ?

Just modify the template and you are done. This way upgrading doesn't have to bother you. The variable is currently the same in vb3 too.