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]

my bad. i'm sorry. i never had the calendar enabled.

[FrankR310]

cool thanks!

[Thunderpuck]

God I am so embarrassed to be asking this question, you can't be more of a newbie than I am. This is my very first time installing a hack.

I followed the instructions but I am stuck at the part where it says "To call your vbMicroStats, simply place the string {getmicrostats} anywhere you want in your templates"... I copy and pasted {getmicrostats} on my footer template and now my forum displays the word: "{getmicrostats}" instead of actually getting microstats. LOL. Obviously I am not calling MicroStats properly, can anyone shed some light on a newbie?

Thanks in advance...

[Keith]

It's got to be something very simple, but it's going to be a pain to find. You have to start from square one, go through the instructions again, retracing each and every step, one by one. That's what I would do in this case.

I used the template version. Created a template called home_microstats. It's in the default style because I don't have more than one. This template has the following in it:

<center>Page generated in $trimmedtime seconds ($percentphp - $percentsql) with $query_count queries.
$adminstats </center>

Then place a variable

{getmicrostats}

in your footer template. This is what the end of my footer template looks like, with the variable call near the end

<!-- Do not remove this copyright notice -->
  Powered by: vBulletin Version $templateversion<br>
  Copyright &copy;2000, 2001, Jelsoft Enterprises Limited.<br>
<!-- Do not remove this copyright notice -->
$copyrighttext
</smallfont></p>
$themefooter

<smallfont>{getmicrostats}</smallfont>

<!-- End -->

hope this helps.

[Thunderpuck]

Yes, that did it, you helped a lot Keith! Thanks for taking the time to help a newbie start down the road to hacking this cool forum.

[Keith]

Originally posted by Thunderpuck
Yes, that did it, you helped a lot Keith!

That's the first time I think I've actually been of help to someone. Glad it worked out, thanks for letting me know. I'm still learning as well, but hacking away like crazy, usually getting into trouble and looking for help myself.

Take my advice from another post I made above, use the "Lessons Learned". Backup, rename, backup and rename again if you have to. I have a CD with the original code, and a copy on my harddrive for safekeeping. Always have an original to FTP onto the server in case you goof up.

[TECK]

Originally posted by Keith
That's the first time I think I've actually been of help to someone. Glad it worked out, thanks for letting me know.

great job Keith. glad eveyone got the hack up and running without any hikkies...

[FlyingDutchman]

:bunny:

[BlueVoltage]

I just installed this and i get this error:

Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in /home/xelerix/public_html/forums/admin/db_mysql.php on line 240

Fatal error: Cannot instantiate non-existent class: db_sql_vb in /home/xelerix/public_html/forums/admin/global.php on line 108

[BlueVoltage]

I am also getting this error:

Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in /home/xelerix/public_html/forums/admin/db_mysql.php on line 240

Fatal error: Cannot instantiate non-existent class: db_sql_vb in /home/xelerix/public_html/forums/global.php on line 128