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:

[Deep Blue]

OK, this is a weird one

I'm including a html file to use as a header using : require("http://www.invasionworks.com/includes/header.htm");

From the vB CP templates bit.

Now when i link directly to http://forums.invasionworks.com i get this error
Warning: Cannot add header information - headers already sent by (output started at /home/invasion/public_html/forums/global.php:2) in /home/invasion/public_html/forums/admin/functions.php on line 1610

but if i link to : http://forums.invasionworks.com/index.php?

it works without a hitch,

I'm using a fresh copy of vB, installed hacks, and then re uploaded modified files.

Any ideas?

[Bro_Joey_Gowdy]

Nice hack...

Below are my stats -

Page generated in 4.45685601 seconds (100.00% PHP - 0.00% MySQL) with 22 queries.
[Debug Mode OFF] [PHP v4.1.2] [GZIP disabled]

are these good or bad ??

[Deep Blue]

Ok, i know why that happens, if you go back a couple of pages in this thread that problem is explained, my forum looks awefull atm tho, with the header errors that im getting, any clues folks?

[TECK]

Originally posted by Bro_Joey_Gowdy
Nice hack...

Below are my stats - are these good or bad ??

you didnt hack the db_mysql.php file corectly.

Originally posted by Deep Blue
Ok, i know why that happens, if you go back a couple of pages in this thread that problem is explained, my forum looks awefull atm tho, with the header errors that im getting, any clues folks?

is it a problem like wierd colors? what php version you use? or you get parse errors?

[Boofo]

Nakkid,

My server load stats show now. Now will you give me the code for putting the load stats in the Admin Quik Stats?

[Xelation]

how could I combine these two together?

PHP Code:

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

  global $DB_site,$replacementsetid,$gzipoutput,$gziplevel,$newpmmsg,$bbuserinfo;
  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 => '{bbusername}');
  $replacewords=array(0 => "$bbuserinfo[username]<!-- auto name hack -->");
  $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); 


and

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); 


???

[TECK]

Originally posted by Boofo
Nakkid,
My server load stats show now. Now will you give me the code for putting the load stats in the Admin Quik Stats?

is best to ask in that thread this question, is not related to vbMicroStats. i will post there.

[TECK]

Originally posted by Xelation
how could I combine these two together?

find:

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

replace it with:

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

[Bro_Joey_Gowdy]

Originally posted by Nakkid
you didnt hack the db_mysql.php file corectly.

Thanks for the help - I somehow skipped over that step



heres my stats now:

Page generated in 0.13275900 seconds (32.71% PHP - 67.29% MySQL) with 22 queries.
[Debug Mode OFF] [PHP v4.1.2] [GZIP disabled]

So are these good or bad ?

[TECK]

22queries is very good.