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]

ok.. i added the code above.

[b-b00gie]

This hack is giving me so much trouble installing it... :-\


i'm getting the following error:

Parse error: parse error in /home2/public_html/forum/admin/functions.php on line 496

Fatal error: Call to undefined function: iif() in /home2/public_html/forum/admin/functions.php on line 351

I've gone over the install 20+ times. I verified that I made the correct changes and to the correct files.


If I undo the changes to functions.php (copy the text to replace from the install file) everything goes back to normal. When I replace the text I get the error again. :depressed:


I'm using 2.2.5 btw.

[b-b00gie]

additionally...


this is my line 351 in functions.php

PHP Code:

$usercache["$userid"]['showvbcode'] = iif(($usercache["$userid"]['options'])&SHOWVBCODE,1,0); 


this is my line 496 in functions.php

PHP Code:

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

  global $pagestarttime,$query_count,$showqueries,$querytime,$DB_site,$gzipoutput,$gziplevel,$bbuserinfo,$debug,$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]+$endtime[1]-$starttime[1];
  $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";
    }
    if ($debug==1) {
      $debugmode="(Debug mode)";
    } else {
      $debugmode="";
    $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 {
    $microstats = "Page generated in $trimmedtime seconds ($percentphp - $percentsql) with $query_count queries.<br> 
                   $adminstats";
  } 


Line 494: } else {
Line 495: $adminstats="";
Line 496: }

[TECK]

remove $debug from the global.
then remove:

    if ($debug==1) {
      $debugmode="(Debug mode)";
    } else {
      $debugmode="";

also remove $debugmode variable from $adminstats line... is useless information. i will mod the hack right now. this debug thing gave me only problems.

[b-b00gie]

Originally posted by nakkid
remove $debug from the global.
then remove:

    if ($debug==1) {
      $debugmode="(Debug mode)";
    } else {
      $debugmode="";

also remove $debugmode variable from $adminstats line... is useless information. i will mod the hack right now. this debug thing gave me only problems.

That did it! No more error. :classic: It works great now.

[TECK]

i'm glad. congrats... and sorry, it was my mistake that code. it will work only if you have $debug enabled in config.php

[b-b00gie]

Just a question... is there a way to limit the decimal places of the load time?

For example, I get something like: Page generated in .2973462 seconds...

Can I limit it to 2 or 3 decimal places somehow? not sure :\

[TECK]

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

change it to what value you want. if you want to show the last 4 digits, it should be $digits=4;
so it will look like: Page generated in 0.2973 seconds...

[b-b00gie]

Silly mistake! I didnt see the variable... Thanks again for all your help.

[TECK]

firefly, i noticed something related to your code addon for this hack. in your site, the PHP % is always smaller then the MySQL %.
the normal way is: your PHP value should always be bigger then the MySQL one (like it's supposed to be in EXPLAIN=1). everyone's page does that, except here at vB.org. just letting you know. if i'm wrong, correct me please.