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.

[Xenon]

fury, unfortunately you're wrong here.

version 2 of my forumhome optimization hack also incorparates this feature, because i rewrote the online users because of another problem i had.

that way it will be redundant, or even not possible, because the original query isn't there anymore..

[fury]

OK, thanks for the correction.

Makes this thread kinda useless huh?

[Xenon]

hmm, if anyone just wants to install that and no more optimizations, then he can use this (ok, i don't know why )

but as your thread was before the new version of mine, i'll let it up to you.

if you want to let it be here, it will.
if you want it removed, just tell me, i'll do for ya

[fury]

I think I'll edit the original post with the explanation and a link to the forumhome optimization hack, in case people who have already installed that happen upon this thread.

[Xenon]

okidokie

[Alien]

Thanks for the help you two!

-Jason