[RELEASE vB2.0] Max Users History

v2 - Updated to use no extra queries

Okay, seeing as people asked for this, here it is. It's very, very simple in its operation.

It just keeps a record of the most number of visitors at any one time, and displays it on the main forums page. The time/date format will obey the system you specified in the control panel, including timezone offsets.



Installation is very simple. Simply download the attachment to this message, unzip it and upload install_maxonline.php to your forums/admin folder, then open that page in a web browser and carefully follow the instructions it will give you.

The script will only call an extra query if the number of online users is greater than that the previous record. The records are stored in a new template called 'MAXONLINERECORDS', which is automatically installed for you with the supplied script.

The install script has an upgrade option that will clean up the mess left by the original version...

You can see it working online at snyx' forum here

Extraordinarily Important Info
When you upgrade your board to a new version of vBulletin, you must modify the install script that you run like this:

Find

PHP Code:

$DB_site->query("DELETE FROM template WHERE templatesetid=-1 AND title<>'options'"); 


and replace it with

PHP Code:

$DB_site->query("DELETE FROM template WHERE templatesetid=-1 AND title<>'options' AND title<>'MAXONLINERECORDS'"); 


If you do not do this, your records will be destroyed when you upgrade.

Originally posted by Kier
Stop downloading this one for a little while.

I've devised a way to do this without an extra query on index.php... give me 20 mins and i'll post the new version.

Cool - let us know when you are ready! This is pretty sweet

New version available

Interesting way of doing it..

Originally posted by freddie
Interesting way of doing it..

Well a boring way just wouldn't be fun would it?

Great hack..... and I like the way you cache the value inside of a template in the new version, that's a great way to avoid the overhead of another query

thanks

the instructions of the upgrade said to change this code

"$checkmax = $DB_site->query_first("...etc"

for this one

"$maxrecords = explode(" ", $templatecache...etc"

in forumhome_loggedinusers template. thats index.php... detail. thanks again.

Oops, you're right

I've altered the file with the new instructions.

installed the new version and it was painless to do

i really have to put my head in my php/mysql books so i can start to contribute

Really you don't even need the books...

I found that even after I bought a PHP book I still use the online manuals more often then the book.

Originally posted by leadZERO
I found that even after I bought a PHP book I still use the online manuals more often then the book.

Very true. In fact, I taught myself the basics of PHP by hacking the nuts off a copy of vBLite.