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:

[Jawelin]

I still obtain negative values (i.e. ending times smaller than starting times in db_mysql ... :surprised: :surprised: ) !!!!

For example, on DETAILS against my forumhome page, I got something like:

Page generated in -0.484897 seconds with 36 queries,
spending 0.47043216228485 doing MySQL queries and -0.95532916228485 doing PHP things.

The same page gave these percentages:

Page generated in 0.20868 seconds (-118.92% PHP v4.1.2 - 218.92% MySQL) with 35 queries.

:dead:

Pragmatically, how could I correct in functions.php out-of-scale values of mySql times ? I though something like val % 100, but... :laugh:

Thanks

[JDD]

for me it's the same, installed the latest version (on vB 2.2.4), and from time to time I get negative values:

this is an result for my forum home page:

Page generated in 0.5797920 seconds (-8.82% PHP - 108.82% MySQL) with 23 queries.
PHP version 4.0.6 (Debug mode) with GZIP library compression disabled. [details]

I am sure that I hacked the files correctly (checked it several times)

Strange is that the timedisplay is positive but the percentage values are negative

I put {getmicrostats} into the footer template

Greets
JDD

[wooolF[RM]]

same here...

[cihangir]

same here:

Page generated in 0.0731950 seconds (-1,558.43% PHP - 1,658.43% MySQL) with 24 queries.
PHP version 4.0.6 (Debug mode) with GZIP library compression enabled (level 1). [details]

but i get negative values only on the frontpage. (installed on v2.2.4 and 'no template' Mod )

[forumuser]

do you guys ever have a problem editing files, like some files just wont accept anymore text or something? WHat is up with that? I cant install this hack cause the file wont take anymore text

[NetherChris]

Why does it always show Debug Mode as on? It's spefically disabled in PHP... but on all other notes this hack is WONDERFUL!

[scotty]

please help!
----
the first few seconds after installing everything worked fine with that hack, but round about a minute after installing it all users became this error:

Invalid SQL: INSERT INTO session (sessionhash,userid,host,useragent,lastactivity,lo cation) VALUES ('84359734a0c822c487019565d2c15f','1','80.133.*.*' ,'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;','1016380059','/board/index.php?s=')
mysql error: Duplicate entry '84359734a0c822c487019565d2c15f' for key 1

mysql error number: 1062

the error showed up in den "admin" too, when I want to shut off the board...

...what could it be?

bevor this error the microstats where correctly displayed in my footer...

any suggestions?

THX!

[TECK]

Originally posted by JDD
for me it's the same, installed the latest version (on vB 2.2.4), and from time to time I get negative values:

Strange is that the timedisplay is positive but the percentage values are negative

it must be related to your server? i never get a negative value. the best example is vB.org site. firefly can back me up on this, because he had checked my code.

[Kyomu]

Originally posted by JDD
for me it's the same, installed the latest version (on vB 2.2.4), and from time to time I get negative values:

this is an result for my forum home page:


I am sure that I hacked the files correctly (checked it several times)

Strange is that the timedisplay is positive but the percentage values are negative

I put {getmicrostats} into the footer template

Greets
JDD

I get the same thing. I think it has to do with being in a shared environment.

[TECK]

Originally posted by Jawelin
I still obtain negative values (i.e. ending times smaller than starting times in db_mysql ... :surprised: :surprised: ) !!!!

For example, on DETAILS against my forumhome page...

i'm convinced is a server issue Jawelin. as you see, even in unhacked (details) mode you get negativs. i wish i could do something but i cant. you should contact your host. let me know what they said.. it might help others who have the same prob.