vbMicroStats: page load time, queries, GZIP and PHP version

[high]Looking for VB3 version? Is here.[/high]

This hack will add at the bottom of each vBulletin(powered) page the following stats:
- load time of specified page in microseconds (with custom no. of digits to show)
- number of queries executed
- server GZIP library compression status
- vBulletin DEBUG mode
- PHP version
- PHP percent page usage
- MySQL percent page usage
- Server Load
[high]This is not only estethic, it will also help you troubleshoot any wierd queries that you have in your scripts.
The hack is template based so you can edit it the way you want in few seconds.[/high]
NOTE: From users experiences, this hack will work only with PHP 4.0.6 or higher. Let me know if it works with a lower PHP version.

THE FIX FOR VB2.3.0 IS HERE.

HACK UPDATES
Version 2.1
------------------------------------
Changes:
- added Server Load

NOTE: I spoked with Kevin 'tubedogg' from vBulletin Support team and he explained to me that not all the servers are configured to support the [high]@exec("uptime")[/high].
Contact your host for more details and ask them about this issue.
For a full explanation of your 3 server load values, read more here.

*If you want to have the stats viewable only by admins, read this post.

Version 2.0
------------------------------------
Changes:
- added vBulletin DEBUG Mode
- removed the Details link
- cleaned a little the code to match VB2.2.6
- better explanations into the install file.

Version 1.7
------------------------------------
[high]VB2.2.5:[/high]
Minor change in admin/db_mysql.php. Read more here on how to update your hack.
Minor change in forum/global.php. Read more here on how to update your hack.

Changes:
- corrected negative values on certain servers.

Version 1.6
------------------------------------
Changes:
- PHP version and GZIP library status viewable only to admin.
- added a link to Detailed Stats View (generated by vBulletin), for that specific page. Only admins can view that link.

To see how it looks a Detailed View, click here.

Version 1.5
------------------------------------
Added:
- GZIP library status is now related to your vBulletion options.
- GZIP library compression level.

Version 1.4
------------------------------------
Bugs corrected:
- GZIP library status not displayed properly on certain servers.

Version 1.3
------------------------------------
Bugs corrected:
- vbPortal display code in modules

The hack is template based now.
All you have to do is call it with the {getmicrostats} string, anywhere you want (for example in footer).
You also have the choice to install it as template based or coded directly into your functions.php file.

Version 1.2
------------------------------------
Added the PHP and MySQL page percentage.
(Addon by Chen 'FireFly' Avinadav)

Version 1.1
------------------------------------
vB.org decided to add this hack to their board.

Bugs corrected:
- incorrect time load
- incorrect query count

You like this hack? Please click on the [high]Install[/high] button.
To download the latest version of this hack, click below:

[TECK]

the latest. soon it will be out 4.2
this hack was tested on PHP 4.1.2 (wich most providers have it installed).
actually, VB is not working properly on such low version of PHP.

[KuraFire]

I'm using 4.0.4pl1 on my own system and vB is working fine on it...

it's this hack that isn't, but that's cos of the low version, but vB itself works. (I have 4 boards running on my comp, all for work-in-progress to produce 1 single board, online... )

[TECK]

i think there was an fervent discussion related to this at vb.com
tubedogg was telling people that VB will not work properly. honestly, i dont remember the version he mentioned, but it was something with 4.0.x

maybe one of the people here can let me know what is the lowest PHP version vB can run properly on it? thanks.

[KuraFire]

4.0.4pl1 allows my vB to run perfectly fine.

So it has to be lower than that before vB _won't_ work, cos I have proof running in 4-fold () that it works in 4.0.4pl1

(though, I really have to upgrade to 4.1.2 ASAP...)

[DWZ]

err... this hack had been working fine for the last few weeks or so, but I just noticed it says this these days:

Page generated in 0.2891870 seconds (100.00% PHP - 0.00% MySQL) with 24 queries.

0% MySQL?

[Admin]

Originally posted by nakkid
i think there was an fervent discussion related to this at vb.com
tubedogg was telling people that VB will not work properly. honestly, i dont remember the version he mentioned, but it was something with 4.0.x

maybe one of the people here can let me know what is the lowest PHP version vB can run properly on it? thanks.

I don't know where you heard that, but vBulletin will run properly on 3.0.7 or even lower. Of course it won't have PCRE support but it will still run.

[Admin]

Originally posted by DWZ
err... this hack had been working fine for the last few weeks or so, but I just noticed it says this these days:0% MySQL?

Hahaha you wish.

[KuraFire]

You are using the new db_mysql.php file, look up in the past 20~ posts to see how to re-modify it. If you haven't added the new hack for the new db_mysql.php file, it'll show 100% php and 0% mysql constantly.

[DWZ]

Originally posted by KuraFire
You are using the new db_mysql.php file, look up in the past 20~ posts to see how to re-modify it. If you haven't added the new hack for the new db_mysql.php file, it'll show 100% php and 0% mysql constantly.

worked great, thanks

[high]* DWZ should read thread next time
[/high]

on that note, I never got an email to say this hack was updated

[TECK]

hi DWZ.. i didnt send an email, because 226 was not released..