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:

[Gutspiller]

My forum front page shows this:

Page generated in 0.0918310 seconds (-669.55% PHP - 769.55% MySQL) with 92 queries.

I think it's fawkered.

[TECK]

this is extremly high.. :alien: :dead: check your hacks..

[Bane]

Page generated in 0.6798900 seconds (100.00% PHP - 0.00% MySQL) with 29 queries.

That seem odd to you? ;p

[cerebro]

i install but i deleted
if ($bbuserinfo['usergroupid']==6) {
if ($gzipoutput==1) {
$gziptext="GZIP library compression enabled (level $gziplevel)";
} else {
$gziptext="GZIP library compression disabled";
}
$debugmode=(DEBUG)?" (Debug mode)":"";
$versionphp=phpversion();
$adminstats="PHP version $versionphp $debugmode with $gziptext. [<a href=\"$PHP_SELF?explain=1\" target=\"_blank\">details</a>]";
} else {
$adminstats="";
}
becauso i dont what to use that...thanks

[David Bott]

nakkid...

Just so you know, the negative numbers seems to have something to do with the server time somehow and has nothing to do with the web browser that I can see. I say this for here is a reading from my main site page...

Page generated in 0.3543150 seconds (86.99% PHP - 13.01% MySQL) with 19 queries.


And here is a reading again from the same site after using SEARCH...

Page generated in 0.4924000 seconds (-6,852.20% PHP - 6,952.20% MySQL) with 13 queries.

Notice the speed is still all good and even less queries...But...the time it takes the server to do things it needs seems to mess things up.

Not sure why...for it does not happen on this site with the serach. But it does on my server and always seems to give a negitive when the server is taking it's time even though the page is generated quickly.

Note...my site is not small by any means...

http://www.avsforum.com/avs-vb

Hope this helps. Not sure how...But hope it does.

David Bott
AVS Forum

[dxb]

I'm getting the exact same problem that David Bott

==============================

Page generated in 0.7519780 seconds (-1,907.81% PHP - 2,007.81% MySQL) with 26 queries.
PHP version 4.0.5 (Debug mode) with GZIP library compression enabled (level 3).

===================================

[scotty]

hm weired - the first few seconds 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...

[Ghard296]

Works perfect for me! Thanks.

[TECK]

Originally posted by David Bott
nakkid...

Page generated in 0.4924000 seconds (-6,852.20% PHP - 6,952.20% MySQL) with 13 queries.

Notice the speed is still all good and even less queries...But...the time it takes the server to do things it needs seems to mess things up.
Hope this helps. Not sure how...But hope it does.

David Bott
AVS Forum

hmm that's odd. it should be the same no matter what.. and you are right, it's related directly to the server performance, the hack reads the speed your server operate the page creation.

[Jawelin]

Hi. As said, finally installed the 1.6 version... and worked fine...
Just recently I noticed my server changed configuration: now I see Debug Mode on and GZip disabled after a long time I used it without problem (level 1 for minimum cpu load...)
Verified even with phpinfo ... now HTTP_ACCEPT_ENCODING variable isn't present any more...

I'm on a shared server.
Could I change any way this configuration ? How could I verify it in php.ini ?

Thanks a lot.
Bye