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:

[hypedave]

Originally posted by nakkid
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...

heheh what you talking bout willis, im my own host hehehe\
but how would i keep queries under 40

[TECK]

reduce the number of queries by removing any unnecessary hacks.
vbPortals is known for adding a huge amount of queries to your main page. the optimal no. of queries for a board is max. 40. after that you start to get your server on the red side. immagine that you have 1000 users and they proccess 60queries at the same time. that's 60,000 queries in the same fraction of time. that can double easy if they do a mix between the frontpage (average 90 queries for vbPortal) and vBulletin.
wajones did an excellent job with the portal, but in my personal oppinion i think it puts alot of stress on the server.

try this, place {getmicrostats} in your homepage. let me know the results.

also keep in mind that an unhacked board have only 17queries.

[NTLDR]

I'm getting no where with this hack

Would it be posible for someone to send me the changed files so I could compare them with what I've got?

I know I'm doing something wrong, I just can see what! I've followed all the instructions and tried 20+ times to get this hack working on a non-hacked board.

Thanks In Advance,
Lee

[hypedave]

Originally posted by nakkid
reduce the number of queries by removing any unnecessary hacks.
vbPortals is known for adding a huge amount of queries to your main page. the optimal no. of queries for a board is max. 40. after that you start to get your server on the red side. immagine that you have 1000 users and they proccess 60queries at the same time. that's 60,000 queries in the same fraction of time. that can double easy if they do a mix between the frontpage (average 90 queries for vbPortal) and vBulletin.
wajones did an excellent job with the portal, but in my personal oppinion i think it puts alot of stress on the server.

try this, place {getmicrostats} in your homepage. let me know the results.

also keep in mind that an unhacked board have only 17queries.

that was my forums homepage

[hypedave]

well this is what I got on the acutal main page ( vbportals )

Page generated in 0.5270550 seconds (92.09% PHP - 7.91% MySQL) with 9 queries.
PHP version 4.0.6 (Debug mode) with GZIP library compression enabled (level 1). [details]

[TECK]

wow.. that's great, wajones changed the code structure?? i used to see people here posting that they got 120queries... i never installed vbPortals.

NTLDR, add me to your messenger. i will help you.

[hypedave]

yeah vbportals has been nothing but succes for my site

[hypedave]

ok I will add you to my buddy list

[NTLDR]

Originally posted by nakkid
NTLDR, add me to your messenger. i will help you.

Sorry its taken me so long to get back to you nakkid, I ended up falling asleep before I read your reply last night

If the offer of help still stands I've added you to my Messenger contact list.

Thank You
Lee

[TECK]

np lee. just contact me. i will help you install this hack. is my pleasure to give you a hand on this issue.

[NTLDR]

Thank you nakkid,

Its peope like you that make this such a great community to be part of

[NTLDR]

I've just had a thought, I tried to run repair.php, I can't use that as it requires MySQL 3.23 or higher, I have MySQL 3.22.23 and PHP 4.1.2, could this be the problem, that this hack won't work with those versions?

[Ian]

According to vBulletin.com vBulletin shouldn't even run on that low of a version... I'd upgrade ASAP.

[NTLDR]

I've got vBulletin working fine, I haven't had any problems with it, I've got to change host as my current one has provided me v.bad service lately.

Anyway, thanks to nakkid, I have got this hack working on my forums

He's a real creadit to the vb.org community, great hack and even better support, thank you nakkid.

[TECK]

credit? no. but thanks for the nice words. as for the help, i try to do as much as i can. i'm glad we got it working.