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]

just download the [high]vbmicrostats.txt[/high] attachment. make sure you clear your history and cookies if you cannot download the latest version. i put it [high]FREAKY YELLOW[/high] what you have to do in order to get the latest file, so you cannot miss it.

also, please do not quote full code, it make your post almost unreadable.

regards,
nakkid.

[Jadelit]

woot woot.. hehe

Page generated in 0.6007300 seconds (90.65% PHP - 9.35% MySQL) with 93 queries.
PHP version 4.1.2 (Debug mode) with GZIP library compression disabled.

[TECK]

Originally posted by Jadelit
woot woot.. hehe

your forums look great. congrats. however, there is only one thing:
YOU REMOVED THE Jelsoft COPYRIGHT NOTICE.
please re-add it asap, as you infringe vBulletin's copyright and proper usage.

i forgot one detail (thanks Recon_Boy): 93 queries?
this is extremly high, you could crash your host's server if you have over 100 users simultaneously on your board.
check your code hacks. you have a bug there. vB.org who is loaded up to the sky with hacks, have 33 queries max.

regards,
nakkid.

[Recon_Boy]

Originally posted by Jadelit
woot woot.. hehe

Page generated in 0.6007300 seconds (90.65% PHP - 9.35% MySQL) with 93 queries.
PHP version 4.1.2 (Debug mode) with GZIP library compression disabled.

93 queries is awful high...lol...

yeah, do what Nakkid says.

[TECK]

Well I realised that many of us don't want to let users see to many technical details. So in v1.6, the PHP version, Debug mode and GZIP compresion status will be visible only to admins.
A neat feature that i added was the Detailed View. Basically, it's a link that will output in details, what is happening on that page, related to PHP and MySQL. I will post a screenshoot below, so you can understand better.

1. forum/admin/functions.php
In [high]function dooutput()[/high], replace the previous edited code with:

PHP Code:

// ###################### Start dooutput #######################
function dooutput($vartext,$sendheader=1) {

  global $pagestarttime,$query_count,$showqueries,$querytime,$DB_site,$gzipoutput,$gziplevel,$bbuserinfo,$microstats;

  $pageendtime=microtime();

  $starttime=explode(" ",$pagestarttime);
  $endtime=explode(" ",$pageendtime);

  // time format (how many digits you want to show)
  $digits=7;

  $totaltime=$endtime[0]-$starttime[0];
  $trimmedtime=number_format($totaltime,$digits);
  $percentphp=number_format(((($totaltime-$querytime)/$totaltime)*100), 2)."% PHP";
  $percentsql=number_format((($querytime/$totaltime)*100), 2)."% MySQL";

  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="";
  }

  if ($showqueries) {
    $vartext .= "<!-- Page generated in $totaltime seconds with $query_count queries -->";
  } else {
    eval("\$microstats = \"".gettemplate('home_microstats')."\";");
  } 


2. home_microstats template
replace your vbMicroStats template contents with:

Page generated in $trimmedtime seconds ($percentphp - $percentsql) with $query_count queries.<br>
$adminstats

if you used the $microstats variable, replace the old code with:

PHP Code:

$microstats = "Page generated in $trimmedtime seconds ($percentphp - $percentsql) with $query_count queries.<br>
               $adminstats"; 


[TECK]

vbMicroStats detailed view (generated by vBulletin):

[Jadelit]

Originally posted by nakkid
your forums look great. congrats. however, there is only one thing:
YOU REMOVED THE Jelsoft COPYRIGHT NOTICE.
please re-add it asap, as you infringe vBulletin's copyright and proper usage.

Ok done.

[TECK]

thank you for being professional.
all the best with your work. you deserve it, you did an amasing job there..

[Jadelit]

thanks again =]

[Jawelin]

Originally posted by nakkid
thank you for being professional.

Nakkid! Are you leaving or not !?!? :squareeyed:

Are the others so 'professional' ????