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:

[Erwin]

Look, it even works for posts... look at the bottom of my post...

[TECK]

lol

[2 X Viverridae]

Installed in mere minutes, works great.

Thanks!

[TECK]

glad you like it...

[Okiewan]

Well... I thought it was odd that I'd see 93 queries... noticed the "93" showing up a lot in this thread <---

Also MySQL shows 0% and PHP=100%

Removed a couple of hacks from forumhome (total users online today, welcome panel) ... still showing 93 queries.

[TECK]

the 0-100% is the db_mysql.php issue discussed several times here... please check your file properly and let me know if it's working.
about 93 queries, nobody had 93 queries on forumhome. please let me know exacly what hacks you installed. on the main page (not forumhome) i think you have installed vbIndex, the champion of busting servers with it's extremly high number of queries. a normal unhacked forumhome have 17queries.

[DWZ]

Has this been tested with 2.2.7? I'm in the middle of adding all my hacks to the 2.2.7 code, just wondering if it will work or not

[TLfuRy]

Originally posted by DWZ
Has this been tested with 2.2.7? I'm in the middle of adding all my hacks to the 2.2.7 code, just wondering if it will work or not

You just have to re-apply the hack after you upgrade. I upgraded today and re-applied the hack and it's working fine.

[N9ne]

There shouldn't be any reason why this shouldn't work.

[TECK]

it should work in VB227 without any probs.

[N9ne]

lol @ your sig Nakkid

[jediguy]

Thanks for the beaut hack! Took me a while to go through the thread and find out what I did wrong, but in the end it works like a charm.

Powered by: vBulletin Version 2.2.6
Copyright ?2000, 2001, Jelsoft Enterprises Limited.
Page generated in 0.36839294 seconds (31.64% PHP - 68.36% MySQL) with 28 queries.
[Debug Mode OFF] [PHP v4.2.2] [GZIP enabled - level 1] [Server Load: 0.62 ? 0.86 : 0.96]

Thanks a lot!

[Gohan]

Great hack and fine working on 2.2.7

[Boogle]

I have a problem with the db_mysql.php file. Locally everything works, but if I upload to me webserver I get an error, like so:

Database error in vBulletin 2.2.7:

Invalid SQL: INSERT INTO session (sessionhash,userid,host,useragent,lastactivity,al thash,location) VALUES ('32a41a8546984be8115d0e92b1a55701','1','62.60.41. 40','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;','1030973130','','/')
mysql error: Duplicate entry '32a41a8546984be8115d0e92b1a55701' for key 1

mysql error number: 1062

Any advice?

[TECK]

check your code.