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:

[glo]

im using 2.3.4

[glo]

im using 2.3.0 but the coding should be the same

[Kaelon]

The upgraded differences between functions.php in 2.3.2 and 2.3.5 were significant enough, I believe, to break functionality - specifically, a couple of new procedures that measure memory usage, which I believe has broken the way that vBulletin does calculations. I'm not sure, though; honestly, I haven't spent much time trying to get the percentages right, and the quick fix I posted on page 62 worked for me.

[Jonah Weiland]

I just installed this hack on my forums and got the oddest result:

Page generated in 1,080,612,708.69590306 seconds (100.00% PHP - 0.00% MySQL) with 26 queries.
[Debug Mode OFF][PHP v4.3.2] [GZIP enabled - level 1] [Server Load: 1.11 ? 1.59 : 1.64]

1 Million seconds? Did I install the hack wrong, or is this a sign that there's something serious wrong with my forums?

[ArchMage]

I suppose most people are off with VB3 now. But if anyone does still read this, I was wondering if there are any common problems (common hacks?) with huge MySQL % on the main forum page. I haven't added that many features to forumhome but it has 90% SQL. :surprised: Obviously it would be nice to get that down. Every other page generally has about 80% PHP. There must be some hack that is really digging into the database. (Off the top of my head, I have: a Welcome panel, a style drop-down bar, a shoutbox and a PM gauge. Maybe the shoutbox?)

I'm fairly noobish when it comes to this sort of thing, so even if you think I might be aware of simple ways to troubleshoot, feel free to mention them anyway. I'll be very grateful if I don't have to go through every edited file.

[Aaron Freed]

Originally Posted by glo

Hi Gary W,
im getting this error right now above the forums index page.

Warning: Cannot modify header information - headers already sent by (output started at /home/glo/public_html/forums/admin/db_mysql.php:255) in /home/glo/public_html/forums/admin/functions.php on line 1684

I went back and double checked the functions.php, db_mysql.php code and global.php code and that is fine.

and it wont let me into the admin area to add the template! it momentarily gives an error screen saying


Warning: Cannot modify header information - headers already sent by (output started at /home/glo/public_html/forums/admin/db_mysql.php:255) in /home/glo/public_html/forums/admin/functions.php on line 1684
Warning: Cannot modify header information - headers already sent by (output started at /home/glo/public_html/forums/admin/db_mysql.php:255) in /home/glo/public_html/forums/admin/functions.php on line 1684
Warning: Cannot modify header information - headers already sent by (output started at /home/glo/public_html/forums/admin/db_mysql.php:255) in /home/glo/public_html/forums/admin/functions.php on line 1684
Warning: Cannot modify header information - headers already sent by (output started at /home/glo/public_html/forums/admin/db_mysql.php:255) in /home/glo/public_html/forums/admin/global.php on line 227

So I cant even add the template! HELP!!! How can you get into the admin if it bounces you out straight away!

You're best off finding the offending templates in phpMyAdmin and deleting them, but that alone would be heavily difficult. I still haven't even figured out to get rid of those damned warnings at the top of each page my board generates, which is really upsetting me

Edit: Here's the most annoying message

Warning: Cannot modify header information - headers already sent by (output started at blahblah/forum/admin/db_mysql.php:275) in blahblah/forum/showthread.php on line 209

[mashby]

So what's the verdict? Does this awesome hack work with 2.3.5?

[mashby]

bump...

[pdatoon]

Hi,

I installed the vb 2.3.0 version. I added {getmicrostats} in my footer but nothing is displayed. Does the template name is getmicrostats or home_microstats ?

Any ideas?

[pdatoon]

Nevermind i rename the template "microstats" and it works now

Here are my results :

Page generated in 0.20717907 seconds (76.03% PHP - 23.97% MySQL) with 22 queries.
[Debug Mode OFF] [PHP v4.3.4] [GZIP disabled] [Server Load: 2.53 ? 2.40 : 3.05] . PHP percent page usage: 76.03% PHP MySQL percent page usage: 23.97% MySQL GZIP compression library:GZIP disabled GZIP compression level:1 your average server load: [Server Load: 2.53 ? 2.40 : 3.05]