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]

Originally posted by Raptor
worked perfect first time using vb 2.2.9

Page generated in 0.33490300 seconds (43.71% PHP - 56.29% MySQL) with 21 queries.
[Debug Mode OFF] [PHP v4.2.3] [GZIP enabled - level 1] [Server Load: 1.05 ? 1.10 : 1.08]

is it possible for the admin only stuff to be view by anyone ?

Please read the first post. Thank you.

[TECK]

Originally posted by Boofo
This is why it won Hack of the Month.

It did? I wish since is a useful hack for VB coders, but it didn't...

[Boofo]

I guess I should have said "you won"? I forgot it was your other program. Oops! Sorry.

[Boofo]

Originally posted by TECK
1. There is a link I posted in the first thread that will explain the diff between, is done by Eva2000 at VB.com site.
2. For seconds, use this:

$sec = floor( $sys_ticks - ( $days * 60 * 24 ) - ( $hours * 60 ) - ( $min * 60 ) );

Then:

        if ( $sec != 1 ) {
          $value .= $sec . ' seconds';
        } else {
          $value .= $sec . ' second';
        }

Just play with the "and" word...

This doesn't work quite right. I ended up with:

[Server UpTime: 9 days, 3 hours and 40 minutes and 775307 seconds]

[TECK]

Hmmm, I can't test it in a live envionment because my server doesn't support the uptime, or passthru (PHP in save mode)...
But technically this is what it does:
$sys_ticks - shows the no. of seconds since the system is up
( $days * 60 * 24 ) - the days
( $hours * 60 ) - the hours
( $min * 60 ) - the minutes
Removing all those values should give you the seconds only... maybe one of the php gurus can explain what we do wrong? In theory it should work...

You could also do this... replace the function with this line:

$serveruptime = passthru( '/usr/bin/uptime' );

[Boofo]

I just tried the passthru code you gave me and nothing shows up with that.

[Admin]

passthru() returns nothing. You need to use exec('whatever', $output) and then $output will be an array containing the output from the program. If you only need the last line of output, simply do $line = exec('whatever').

[Boofo]

You got me on this one, Chen. (By the way, "hello and it's good to hear from you. ) You're explanation went way over my head. All I am trying to do is get the seconds to show out of the code Teck gave me. Can you help me on that, please?

[Bison]

Originally posted by TECK

    function serveruptime() {
      $fd = fopen( '/proc/uptime' , 'r' );
      $ar_buf = split( ' ' , fgets( $fd , 4096 ) );
      fclose( $fd );
      $sys_ticks = trim( $ar_buf[0] );
      $min = $sys_ticks / 60;
      $hours = $min / 60;
      $days = floor( $hours / 24 );
      $hours = floor( $hours - ( $days * 24 ) );
      $min = floor( $min - ( $days * 60 * 24 ) - ( $hours * 60 ) );

      if ( $days != 1 ) {
        $value = $days . ' days, ';
      } else {
        $value = $days . ' day, ';
      }
      if ( $hours != 1 ) {
        $value .= $hours . ' hours and ';
      } else {
        $value .= $hours . ' hour and ';
      }
      if ( $min != 1 ) {
        $value .= $min . ' minutes';
      } else {
        $value .= $min . ' minute';
      }

      return $value;
    }

    if ( $stats = @exec( 'uptime' ) ) {
      preg_match( '/averages?: ([0-9\.]+),[\s]+([0-9\.]+) , [\s]+([0-9\.]+)/' , $stats , $regs );
      $serveruptime = serveruptime();
      $serverload = ' [Server Load: '.$regs[1].' : '.$regs[2].' : '.$regs[3].'][Server Uptime: ' . $serveruptime . ']';
    } else {
      $serverload = '';
    }

TECK,

Why would it be a security risk for someone to read from the "/proc" in a *nix box? This is what my isp is telling me why they disabled this feature?

And if this is disabled, is it possible to get your hack to work with the other statistics (ex: MySQL - PHP - G-ZIP)?

Thanks in advance!

[TECK]

You are running PHP in safe mode. My host does it also. That's life... you can't do nothing about it.