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:

[neocorteqz]

Today at 02:04 PM TECK said this in Post #840
If you look for something more complex:
https://vborg.vbsupport.ru/showthrea...threadid=43232

There is a fix for the attachments as files listed in the first post.

One of my favorite hacks.

anyways

if the server doesn't support the @exec('uptime'), how could one get the info that doesn't display to display?

[TECK]

You cannot unfortunatelly.

[neocorteqz]

Today at 09:24 PM TECK said this in Post #842
You cannot unfortunatelly.

Damn, ohh well. thanks for the quick answer.

[Robink]

Works great on 2.3.0, ( I just had to do the renaming of home_microstats to microstats )

Only, I dont get the Server load, so I'll ask my host about @exec("uptime")

[S.Shady]

Page generated in 0.08969903 seconds (89.53% PHP - 10.47% MySQL) with 24 queries.
[Debug Mode OFF] [PHP v4.3.2] [GZIP disabled] [Server Load: 1.18 » 2.07 : 1.55]

Im about to check the install to see if i can get it to display the mysql version if there isnt away in there. is there away to add it ?

[Glitch]

06-05-03 at 02:24 AM TECK said this in Post #842
You cannot unfortunatelly.

Other than turning on magic_quotes_runtime in PHP.INI on a IIS/W2K box, how does one configure the server to support $serverload variable or exec('uptime') to calculate it? Isn't there another way to calculate uptime without using exec('uptime')? I believe that phpmyadmin aquires this information in a different way...

I noticed that the problem of vbPortal has returned with additional text in the admin-box sections so I stripped out;

if ( $stats = @exec( 'uptime' ) )
    {
      preg_match( '/averages?: ([0-9\.]+),[\s]+([0-9\.]+),[\s]+([0-9\.]+)/' , $stats , $regs );
      $serverload = ' [Server Load: <font color="{ hovercolor}"><b>' . $regs[1] . '</b></font> ? ' . $regs[2] . ' : ' . $regs[3] . ']';
    }

And the $serverload entry the next line defining $adminstats, and the problem with the extra text in the vbPortal boxes went away...

Just playing around with phpmyadmin, I found this worked with 1 inclusion (page buffer) and extra information you may want to play around with ...

<?php
//**
// * Get core libraries
// */
//if (!defined('PMA_GRAB_GLOBALS_INCLUDED')) {
//    include('./libraries/grab_globals.lib.php');
//}
if (!defined('PMA_COMMON_LIB_INCLUDED')) {
    include('./libraries/common.lib.php');
}

/**
 * Handles some variables that may have been sent by the code below
 */
if (isset($db)) {
    unset($db);
}
if (isset($table)) {
    unset($table);
}

/**
 * InnoDB status
 */
if (!empty($innodbstatus)) {
    echo '<h2>' . "\n"
       . '    ' . $strInnodbStat . "\n"
       . '</h2>' . "\n";
    $sql_query = 'SHOW INNODB STATUS;';
    $res = PMA_mysql_query($sql_query, $userlink) or PMA_mysqlDie(PMA_mysql_error($userlink), $sql_query);
    $row = PMA_mysql_fetch_row($res);
    echo '<pre>' . "\n"
       . htmlspecialchars($row[0]) . "\n"
       . '</pre>' . "\n";
    mysql_free_result($res);
    include('./footer.inc.php');
    exit;
}


/**
 * Sends the query and buffers the result
 */
$res = @PMA_mysql_query('SHOW STATUS;', $userlink) or PMA_mysqlDie(PMA_mysql_error($userlink), 'SHOW STATUS;');
while ($row = PMA_mysql_fetch_row($res)) {
    $serverStatus[$row[0]] = $row[1];
}
@mysql_free_result($res);
unset($res);
unset($row);



/**
 * Displays the page
 */
//Uptime calculation
$res = @PMA_mysql_query('SELECT UNIX_TIMESTAMP() - ' . $serverStatus['Uptime'] . ';');
$row = PMA_mysql_fetch_row($res);
echo sprintf($strServerStatusUptime, PMA_timespanFormat($serverStatus['Uptime']), PMA_localisedDate($row[0])) . "\n";
mysql_free_result($res);
unset($res);
unset($row);
?>

Glitch

[Xelation]

Hey teck, I've got a problem with a step.. its interfering with another hack.. heres the problem on this step

Find:

PHP Code:

// ###################### Start dovars #######################
function dovars($newtext,$sendheader=1) {
  // parses replacement vars

  global $DB_site,$replacementsetid,$gzipoutput,$gziplevel,$newpmmsg;
  static $vars;

  if (connection_status()) {
    exit;
  }

  if (!isset($vars)) {
    $vars=$DB_site->query("SELECT findword,replaceword FROM replacement WHERE replacementsetid IN(-1,'$replacementsetid') ORDER BY replacementsetid DESC,replacementid DESC");
  } else {
    $DB_site->data_seek(0,$vars);
  }

  while ($var=$DB_site->fetch_array($vars)) {
    if ($var['findword']!="") {
      $newtext=str_replace($var['findword'],$var['replaceword'],$newtext);
    }
  } 


Replace it with:

PHP Code:

// ###################### Start dovars #######################
function dovars($newtext,$sendheader=1) {
  // parses replacement vars

  global $DB_site,$replacementsetid,$gzipoutput,$gziplevel,$newpmmsg,$microstats;
  static $vars;

  if (connection_status()) {
    exit;
  }

  if (!isset($vars)) {
    $vars=$DB_site->query("SELECT findword,replaceword FROM replacement WHERE replacementsetid IN(-1,'$replacementsetid') ORDER BY replacementsetid DESC,replacementid DESC");
  } else {
    $DB_site->data_seek(0,$vars);
  }

  $findwords=array(0 => '{getmicrostats}');
  $replacewords=array(0 => $microstats);
  $i=1;

  while ($var=$DB_site->fetch_array($vars) and $i++) {
    if ($var['findword']!="") {
      $findwords[$i]=$var['findword'];
      $replacewords[$i]=$var['replaceword'];
    }
  }

  $newtext=str_replace($findwords,$replacewords,$newtext); 


I have this code instead:

PHP Code:

// ###################### Start dovars #######################
function dovars($newtext, $sendheader = 1)
{
    // parses replacement vars

    global $PHP_SELF, $DB_site, $replacementsetid, $gzipoutput, $gziplevel, $newpmmsg;
    static $vars;

    if (connection_status())
    {
        exit;
    }

    if (!is_array($vars))
    {
        // build an array of $vars containing find/replace values
        $vars = array();
        $replacements = $DB_site->query("
            SELECT findword, replaceword, replacementsetid
            FROM replacement
            WHERE replacementsetid IN(-1, '" . intval($replacementsetid) . "')
            ORDER BY replacementsetid, replacementid DESC
        ");
        while ($replacement = $DB_site->fetch_array($replacements))
        {
            if ($replacement['findword'] != '')
            {
                $vars["$replacement[findword]"] = $replacement['replaceword'];
            }
        }
        unset($replacement);
        $DB_site->free_result($replacements);
    }

    if (PHPVERSION < '4.0.5' or 1)
    {
        // do each replacement in turn for PHP < 4.0.5
        reset($vars);
        while(list($find, $replace) = each($vars))
        {
            $newtext = str_replace($find, $replace, $newtext);
        }
    } 


how can I fix this problem? Ive tried many different ways to fix it myself but now your my resort. Hope you can help

[neocorteqz]

has anyone even tried this on vB3?? just curious.

[DPoole]

/me click installs as i forgot to do a while back when i installed it

this should be part of vbull - not an addon as its a lifesaver at times.

[S.Shady]

04-09-03 at 06:22 PM TECK said this in Post #784
If you clear your browser temp files, you don't even have to rename that template... the typo was corrected my myself about 285 years ago...

sorry to say but not in the 2.3.0 fix. the template typo is still there. in the instructions taking out the home_ is still required for it to work. and i know my temp files arnt the same because i just reformatted my computer and cleared everything when i read that.


sorry for brining that old post up. but just lettin you know.


very good hack.