Logged in users optimization (1.0.1)

Note to users who have installed Xenon's Optimizing Forumhome v2.0 located here need not install this hack. Furthermore, should you wish to install that hack later on after installing this one, you will need to either uninstall it, or forego the section instructing you to modify the logged in users code.

-------------

This simple hack modifies the Logged in users list on the forumhome, reducing queries by one. This is done by knocking off the extra query for guest counting and instead changing the way the while loop that is used for the logged in users list works.

In other words, less queries = win.

Versions of vBulletin: 2.2.x
Tested on: 2.2.9
Modifications: File only (no database or template modifications)

Example: http://www.otcentral.com/forum/index.php
Except for the showing of one less query on the query count, you can see that the result is truly unnoticeable. Logged in users operates the same exact way as it does before the hack is made.

Although there's not much that can go wrong with this hack, support will be provided in this thread and by email. Preferrably thread in case someone else runs across the same problem.

Update: 12/29/2002 - 0:11

Version 1.0.1 released - Counter was still counting duplicate sessions but not displaying them.

[fury]

LOL. I implemented the fix locally and fixed the text file here, but forgot to upload the damn thing to my site!

[Lanigironu]

So is this working fine?

[fury]

As far as I can tell, it's good now, really does function like the old currently active users list on the outside like it said originally

But still, to be on the safe side, keep a backup of your current index.php so you can revert in case something goes wrong. But I don't see why anything would, there are no template or DB modifications to do.

[Lanigironu]

Ok, I'll try it out.

[fury]

I'll be watching this thread Post if you notice any problems.

[Lanigironu]

I don't think my queries dropped.

[fury]

Do you have microstats installed, or $debug=1; in your config file to confirm this?

Try refreshing (when your session times out, a query is used to create another one, and then it goes back down one query)

[Kars10]

Thanks Fury!!
It saves me one query!!
Works like a charm.

[fury]

fury

No problem, glad it works for you

[Lanigironu]

I have Microstats installed, and my queries jumped from 35 to 38. I think I might've used the wrong file though. I think I used an index.php that didn't have the caching in it, so the queries rose because of it.