We have a server just for SQL. Do you mean a secondary 'slave' server to that? I don't know how that works. Or how MySQL would use it.
Wouldn't doing a SELECT COUNT() be quicker than a SELECT USER. And ordering it by the user name would definitely put extra load on the SQL server since it would have to create a temporary table, wouldn't it?

Ok, it's now 5pm and we have nearly 7,000 members having visted today. It's too many to put on the home page.
A separate page would be very useful, though.

I need to add a legend to the beginning of the list of usernames.
Supporter • Member • New Member • Unconfirmed • Banned

The places I used put it in the wrong place.
Were would I add this?

PS. Supporter is supposed to be red, member blue. But vB is showing them as Green???

thank you so much:)

It was either this hack or the guests one on the update.
It took off the errors when the page was finished loading
Now the page runs smooth

After i add the Who visted today [hack] ..... i see this

http://img505.imageshack.us/img505/6572/errorrw4.jpg

and i want to see who vist my forum today like this one


http://img226.imageshack.us/img226/2329/fixedne4.jpg

so can anyone tell me what the best solution ???

There is something wrong with your usergroup markup html.

so what should i do ??
if u know any steps please tell me

iam still new at vBulletin Board

I am unable to get the display to load collapsed or even be toggleable after updating.

Have you customised the template, you will need to revert it if you have.

thank you!