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]

a standard forumhome index.php page gets 17queries. that means you have inserted certain hack code that added 12 extra queries. that will affect your board performance and also it will flame down your server if you have a busy board.
i know that the new vb3 will have 12queries on forumhome. less queries you have, better it is.

the easiest way is to eliminate the double queries you might have. for example if you have a query in global.php that checks the new pm's is useless to add that query also in index.php since you perform it globaly.

check for guides like that and try to reduce it to a decent number. i personally think from talking to firefly that a decent number of queries should be 25. i will keep on my board the no. of queries under 20 always.

[-Sidekick-]

I'm receiving extremely high numbers for the time the page loads. Stuff like 1,025,995,166.26833999 seconds. Though everything else works correctly. Any suggestions?

[TECK]

check your hacked code. you edited the wrong global.php file.

[-Sidekick-]

I followed the instructions.

[trilOByte]

I had this error, like Nakkid says, you hacked the wrong global.php file. There are two of them in different directories, you either hacked the wrong one, or uploaded to the wrong directory or something like that.

Check it out.

[Spekkie]

Nice Hack Dude!

[TECK]

Spekkie, thanks.
-Sidekick-, did you get it working?

[Schorsch]

thanks for the hack

I got these values:

Site generated in 1.14954901 seconds (17.90% PHP - 82.10% MySQL) with 25 queries.
[Debug Mode OFF] [PHP v4.0.6] [GZIP enabled - level 1]

are that normal values ??

and why don't I see the server load ?

thanks,
Schorsch

[TECK]

they look good to me, the values. for details related to your server load, please read the first post of this thread and contact your host.
let me know if you solve it.

[X-Fan]

Just installed this, and now my vbPortals front page stops loading halfway through the last block on the left-hand side.

Help!!!

EDIT: Never mind, got it!