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:

pipsy · #**302** 05-05-2002, 01:38 AM

nothing happens when i put {getmicrostats} in my footer template

all i see it '' {getmicrostats} '' on my page

i'm obviously doing something wrong. and i have no idea what.

pipsily yours.

TECK · #**303** 05-05-2002, 02:38 AM

i'm sorry but i can't do nothing about it. please check you code. there are alot of changes so one little mistake can ruin it all. good luck.

FWC · #**304** 05-05-2002, 04:39 AM

Quote:

Originally posted by nakkid
i will change the file when VB226 will be oficially released. (today)

I modified and applied the hack to the new db_mysql.php that was released and it's working fine.

TECK · #**305** 05-05-2002, 04:47 AM

thanks..

however the details link will not work anymore in 226. is ok, i will add the code separately. i will need the ok from some of the gurus here, to make sure the code is secure. as soon as 226 is released i will look into it.

until then, FWC, can you post more details about the change? i didnt have a chance to look into it. thanks.

FWC · #**306** 05-05-2002, 05:01 AM

I used Beyond Compare to compare my old hacked file and the new one. I just copied over the parts I thought were necessary for your hack to work. Explain and showqueries are gone now so I left all of that stuff out. I'll take a look at it and post what I added.

FWC · #**307** 05-05-2002, 05:14 AM

OK, it looks like I changed this:

PHP Code:


			
  function query($query_string) {

    global $query_count;

    // do query



    $this->query_id = mysql_query($query_string,$this->link_id);

    if (!$this->query_id) {

      $this->halt("Invalid SQL: ".$query_string);

    }



    $query_count++;

To this:

PHP Code:


			
  function query($query_string) {

    global $query_count,$querytime;

    // do query



      global $pagestarttime;

      $pageendtime=microtime();

      $starttime=explode(" ",$pagestarttime);

      $endtime=explode(" ",$pageendtime);



      $beforetime=$endtime[0]-$starttime[0]+$endtime[1]-$starttime[1];



    $this->query_id = mysql_query($query_string,$this->link_id);

    if (!$this->query_id) {

      $this->halt("Invalid SQL: ".$query_string);

    }



    $query_count++;

      $pageendtime=microtime();

      $starttime=explode(" ",$pagestarttime);

      $endtime=explode(" ",$pageendtime);



      $aftertime=$endtime[0]-$starttime[0]+$endtime[1]-$starttime[1];

      $querytime+=$aftertime-$beforetime;

Now that I'm looking at it again, I don't think $showqueries and $explain are necessary in the global statement anymore.

TECK · #**308** 05-05-2002, 05:20 AM

they are unset? i didnt downloaded the new file. i wanted to wait for the 226 release. busy working on my website...

FWC · #**309** 05-05-2002, 05:32 AM

Yes, they are unset. I just took them out and everything seems to work fine.

TECK · #**310** 05-05-2002, 05:34 AM

can you edit the code above and remove them from global?
thanks.

NTLDR · #**311** 05-05-2002, 06:18 PM

The update in Post 306 (above) also worked fine for me with the updated 2.2.6 db_mysql.php on vB 2.2.4

Thanks for the update

FWC · #**312** 05-05-2002, 06:29 PM

Quote:

Originally posted by NTLDR
The update in Post 306 (above) also worked fine for me with the updated 2.2.6 db_mysql.php on vB 2.2.4

Thanks for the update

I'm glad it's working for two of us. Beyond Compare came to the rescue.

freakyshiat · #**313** 05-05-2002, 08:14 PM

The update in 306 is working for me also

KuraFire · #**314** 05-06-2002, 08:50 AM

The update for the new db_mysql is working for me, too.

However, the hack itself wasn't properly working before that, nor is it now. My percentages are completely odd:

Page generated in 0.4714550 seconds (163.74% PHP / -63.74% MySQL) with 20 queries

Page generated in 1.6309210 seconds (-6.54% PHP / 106.54% MySQL) with 20 queries

Page generated in -0.6399480 seconds (36.72% PHP / 63.28% MySQL) with 20 queries
(percentages good, generation time negative... wow)

I even had 5K~ and -5K~ percentages, a few times.

WHAT AM I DOING WRONG?! :'(

I am using php version 4.0.4pl1 on my own computer, might this be the cause of the problem?

TECK · #**315** 05-06-2002, 05:39 PM

hmm kurafire. wierd, it looks like a previous version bug.. this is how i updated the new db_mysql.php:

find:

Code:

  function query($query_string) {
    global $query_count;
    // do query

    $this->query_id = mysql_query($query_string,$this->link_id);
    if (!$this->query_id) {
      $this->halt("Invalid SQL: ".$query_string);
    }

    $query_count++;

    return $this->query_id;
  }

replace it with:

Code:

  function query($query_string) {
    global $query_count,$querytime,$pagestarttime;
    // do query

    $pageendtime=microtime();
    $starttime=explode(" ",$pagestarttime);
    $endtime=explode(" ",$pageendtime);

    $beforetime=$endtime[0]-$starttime[0]+$endtime[1]-$starttime[1];

    $this->query_id = mysql_query($query_string,$this->link_id);
    if (!$this->query_id) {
      $this->halt("Invalid SQL: ".$query_string);
    }

    $query_count++;

    $pageendtime=microtime();
    $starttime=explode(" ",$pagestarttime);
    $endtime=explode(" ",$pageendtime);

    $aftertime=$endtime[0]-$starttime[0]+$endtime[1]-$starttime[1];
    $querytime+=$aftertime-$beforetime;

    return $this->query_id;
  }

and it's working perfectly. make sure you download the latest version and follow the steps in there, you probably have 1.6 installed. also get the latest php binaries. let me know please.

KuraFire · #**316** 05-06-2002, 07:52 PM

I used your new code there, but it's still giving me freakish results.

I *did* 'adopt' a small change by FireFly because without it, my forum looked like a weird rainbow-thing. He said it was something to do with my low PHP version (4.0.4pl1) - might it be that this also caused the mess-up, or is it more logical that my php-version is the problem?

I tried installing new binaries of PHP but for some strange reason, the version never changed. I uninstalled and re-installed like 4 times, didn't work.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05599 seconds Memory Usage 2,388KB 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 (2)bbcode_php (2)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!