The Arcive of Official vBulletin Modifications Site.

vbMicroStats: page load time, queries, GZIP and PHP version · **Released**: 03-06-2002

[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:

Xelation · #**227** 04-10-2002, 11:12 PM

um nakkid, when I go to put the {getmicrostats} in the footer... this is what comes up...

Powered by: vBulletin Version 2.2.5
Copyright ©2000, 2001, Jelsoft Enterprises Limited.
{getmicrostats}

you know whats wrong?

Xanthine · #**228** 04-10-2002, 11:18 PM

Sounds like you forgot to add something to your replacements?

*edit* Maybe not, I dont see a step to add them in the install file. Not sure now.

NTLDR · #**229** 04-10-2002, 11:52 PM

Quote:

Originally posted by Xelation
um nakkid, when I go to put the {getmicrostats} in the footer... this is what comes up...

Powered by: vBulletin Version 2.2.5
Copyright ?2000, 2001, Jelsoft Enterprises Limited.
{getmicrostats}

you know whats wrong?

Thats the same as what I get (see the screen shot on the last page), but my templates don't work properly either though

I don't think this hack likes me

TECK · #**230** 04-10-2002, 11:57 PM

i just installed the hack in v225, following at letter the instructions included in the text file. it works perfectly. please check your steps carefully, especially the files you have to edit (forum/global.php and NOT [high]forum/admin/global.php[/high])

NTLDR · #**231** 04-11-2002, 01:06 PM

Hi nakkid,

I've tried installing it again, and I know I've edited the correct files, the part that is causing the error for me is replacing the follwoing in admin/fuctions.php:

This:

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

    }

  }

With This:

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

Which causes my templates not to work and my forums look like this https://vborg.vbsupport.ru/attachmen...&postid=239359 (Screen Shot From Earlier Post).

I know I must be doing something stupid for it not to work!

TECK · #**232** 04-11-2002, 01:47 PM

it should not give you any trouble. there are several people who installed this hack and they didnt encountered any problem. check the install steps. i would compare the files and follow slowly the code to identify the problem. let me know if you found the bug.

hypedave · #**233** 04-11-2002, 04:44 PM

okay I just installed this hack and I am stumped at this point

what does no templete mode mean ???
then where exactly do I place {getmicrostats}
forgive me, I have been up for quite some time, I think it time for me go to bed, lol. as a normal day I would have this figured out

+-----------------------------------------------+
| 'no template' Mod |
+-----------------------------------------------+
| Find this code:
+--------------------------------------------------------------------------+
eval("\$microstats = \"".gettemplate('home_microstats')."\";");
+--------------------------------------------------------------------------+
|
+-----------------------------------------------+
| Replace it with:
+--------------------------------------------------------------------------+
$microstats = "Page generated in $trimmedtime seconds ($percentphp - $percentsql) with $query_count queries.<br>
$adminstats";
+--------------------------------------------------------------------------+
|
|
+-----------------------------------------------+
| FINAL STEPS |
+-----------------------------------------------+
| To call your vbMicroStats, simply place the string {getmicrostats}
| anywhere you want in your templates (for example in footer).
|
| NOTE: The higher you place the string in your templates,
| the more inacurate your data will be.
|
| The variables you can use are:
|
| $digits - number of digits for microtime
| $trimmedtime - the time your page is loaded
| $query_count - number of queries executed
| $versionphp - PHP version
| $percentphp - PHP percent page usage
| $percentsql - MySQL percent page usage
| $gziptext - GZIP compression library
| $gziplevel - GZIP compression level
| $debugmode - script Debug mode
|
| NOTE: If you want to have more(less) then 7 digits in your microtime,
| change the value '7' to what ever suits better your forum.
|
|
| Upload the modified files. You are done.
+--------------------------------------------------------------------------+

NTLDR · #**234** 04-11-2002, 04:49 PM

Well I've narrowed it down to being a problem with replacing

This Code:

PHP Code:


			
while ($var=$DB_site->fetch_array($vars)) {

    if ($var['findword']!="") {

      $newtext=str_replace($var['findword'],$var['replaceword'],$newtext);

    }

  }

With This Code:

PHP Code:


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

In particualr, removing this line:

PHP Code:


			
$newtext=str_replace($var['findword'],$var['replaceword'],$newtext);

Which stops all my replacements working and I get what was in that screen shot.

The worst thing is I know this hack works as many other people use it!!

TECK · #**235** 04-11-2002, 07:53 PM

please install vbMicroStats in a unhacked test board. you will see it works. i always test my hacks on a unhacked board. let me know please how it went.

NTLDR · #**236** 04-11-2002, 09:20 PM

Quote:

Originally posted by nakkid
please install vbMicroStats in a unhacked test board. you will see it works. i always test my hacks on a unhacked board. let me know please how it went.

Hi nakkid,

Not sure if you were saything this to me or not, but that was what I got on a unhacked 2.2.5 board and the problem above was what I got

Thanks for your help,

Regards,
Lee

hypedave · #**237** 04-11-2002, 09:27 PM

Quote:

Originally posted by nakkid
please install vbMicroStats in a unhacked test board. you will see it works. i always test my hacks on a unhacked board. let me know please how it went.

okay I tryed this on my unhacked board
and my hacked board

is you instructions when it gets to this part here

| 'no template' Mod

thats where I am lost

from

| 'no template' Mod
on down

NTLDR · #**238** 04-11-2002, 10:35 PM

Quote:

Originally posted by hypedave

okay I tryed this on my unhacked board
and my hacked board

is you instructions when it gets to this part here

| 'no template' Mod

thats where I am lost

from

| 'no template' Mod
on down

You ahve 2 choices, either hard code the display into the fuctions.php file or add a template, if you have followed the instructions to that point, just create a template in your admin cp called home_microstats and put the following in it:

Code:

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

Then hopefully it will work for you! Unlike mine, lol

TECK · #**239** 04-11-2002, 10:40 PM

correct. is up to you to chose the one you want. any of them will work.

be aware please, you posted the information in the wrong way. if you do this and post the code you mentioned above:

Code:

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

your template will not be displayed properly. the code segment you listed is for the option that you have to hardcode into the forum/global.php file.

hypedave · #**240** 04-11-2002, 11:02 PM

thankyou, thankyou

Page generated in 0.7612060 seconds (82.86% PHP - 17.14% MySQL) with 37 queries.
PHP version 4.0.6 (Debug mode) with GZIP library compression enabled (level 1). [details]

TECK · #**241** 04-11-2002, 11:04 PM

i'm glad you got it working. good luck with your site.

although, try to keep your queries under 40, if you dont want to see your host knocking at your door...

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05706 seconds Memory Usage 2,411KB Queries Executed 30 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (5)bbcode_php (4)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (16)post_thanks_box (16)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (16)post_thanks_postbit_info (15)postbit (16)postbit_onlinestatus (16)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!