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]

ok, i moved it, hope it's ok so

[nuno]

thumbs up for Xenon

[fury]

Thanks a bunch, Xenon

[Xenon]

you're welcome

[BlackDeath]

i think i will install this regardless but let me tell u the main reason why i think i like this hack. i have some users that like to piss me off when they don't agree w/ what is been done on the site. they use this script that creates multiple duplicate sessions from the same IP and it lags the server to a point that the site becomes inaccessible. will this prevent that from happening or just prevent it from displaying it??? my question is, does this hack block out multiple sessions from someone w/ the same IP?

[fury]

No, it doesn't, it just doesn't count or show the duplicate sessions in the registered user list. Someone who has some experience hacking sessions.php could probably do something like that fairly easily though. The only way I know how adds an extra query to every page.

[BlackDeath]

Originally posted by fury
No, it doesn't, it just doesn't count or show the duplicate sessions in the registered user list. Someone who has some experience hacking sessions.php could probably do something like that fairly easily though. The only way I know how adds an extra query to every page.

well i'd sure appreciate it if someone would make that hack for me. these people can cause the board to be inaccessible on a whim.

[Aaron1]

It worked great with my 2.2.7 VB, aswell in combination with the Optimize Forumhome hack! 20 queries!

[Alien]

So if I install this, and the optimize forumhome hacks both, neither do the exact same thing and become redundant eh?

-Jason

[fury]

Unless I'm mistaken, the forumhome hack does not incorporate this feature; thus it will not be redundant to install them both.