[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.

cool - is beta 4 gonna have this in it ?

where does the max users retrieve the figure from ? and will upgrading to beta 4 etc be okay ?

The hack creates a new table with a single entry that is queried when you load index.php. It compared the value in the table with the $totalonline variable, and if $totalonline is larger than the value in the table, the table is updated.

[edit] - the above info is now incorrect - [/edit]

To upgrade your board, you must modify the upgrade script as shown above, and modify the new index.php

Originally posted by eva2000
cool - is beta 4 gonna have this in it ?

No..

sweet mod, thank you.

Originally posted by Kier
The hack creates a new table with a single entry that is queried when you load index.php. It compared the value in the table with the $totalonline variable, and if $totalonline is larger than the value in the table, the table is updated.

Upgrading to beta 4 will be fine, just modify index.php again after the upgrade.

thanks

nice, took about 30 seconds to install ! your hacks rule

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.

Kier i have been wondering how hard an average would be. Ok i am going to write my thoughts on how to do this as it is a stat i would love.

First, it is only going to work on a site relativly busy, ie with a hit on forumhome every few minutes or so.

So:

i) person hits forumhome (after installing hack).

it records:
i) number of users online
ii) that this is the 1st reporting
iii) the time reported
iv) the average online.

now it needs a couple of times for this to work so lets say we have this:

users: 10, 15, 23, 23, 8
id: 1, 2, 3, 4, 5
minutes (clearly the difference in times): 5, 2, 5, 2 (obviously we can't count the last one)
so to do average we do:

(10x5 + 2x15 + 5x23 + 2x23) / 4

which gives the average.

So any ideas on how this could be done. I would think what you want is a running total that an average can still be generated from but it is too late for me to think of a way to do that.

thinking...

say you kept a running count of total minutes and also the average so at any point you can say:

43,343 minutes of statstics with the current average online as 8.4 users.

Now, if you have the next stat of 3 minutes at 20 users then you can do:

((43,343 x 8.4) + (3 x 20) )/ 43,346

and that should give you back the new average and new total, so the process just continues. Make any sense? server intensive? would require two queries me thinks for every loading of forumhome, once to get the stat and second to update it. Wondering if it would perhaps be better to have a cron script run every 5 minutes say that does the updating and then just pull the results (which you might be able to do without another query if you can on your first bit) and that does it?