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:

[Keith]

Also hoping someone might be able to explain the numbers in serverload.

i.e., [Server Load: 0.70 » 0.64 : 0.58]

[jassim]

yes , Nakkid
the URL is http://arabna.com

[jassim]

I dont know How :surprised:
i only replay one time :cheeky:

[jassim]

Keith
there is a problem i only see 27 pages when i replay and after replay i see 36 pages and i dont see ypure replay
i thing there is probelm

[TECK]

Originally posted by Keith
Nakkid, great hack man. I've read all 36 pages, just about twice now but still having 1 problem. By the way, THANK YOU for putting the links to special probs like the db_mysql and a couple others on the first page, really was a big help.

I've been through the db_mysql file several times now, and still getting some wierd issues like 1,027,731,445.53708601 seconds (100.00% PHP - 0.00% MySQL) with 40 queries.

I have 2.2.5, and using the the db_mysql patch until I can upgrade to 2.2.6. That's the file I've edited. So what am I missing?


P.S. This is the link to the patch for 2.2.5 forums

keith, the prob you have there is editing the wrong global.php file and also editing incorrect the db_mysql.php. edit the db_mysql.php 225 version, the changes are the same as in 226. let me know what is wrong.

Originally posted by jassim
yes , Nakkid
the URL is http://arabna.com

ok from what i see jassim is that you switch from UBB to VB. however in your localhost, you cannot have only 6 queries because the lowest number of queries on a vb page is 9. make sure you install properly first VB in your localhost. if you have probs, follow this tutorial i made:
https://vborg.vbsupport.ru/showthrea...threadid=39482

[proxyMX]

uhm quadrizaiple posting is totally not legal

[TECK]

is probably from the auto email answer. dont worry he will delete them.
keith, when you view the thread, simply click on Edit and delete those double posts.
it will save a mod's time.

[Keith]

First, my apologies to the mod's and Nakkid, and any others subscribing to the thread. I recently changed my email address in the profile to one that has an auto responder. The subscription option and auto email response wound up in a loop, resulting in umteensome identical posts for about 3 pages. I've now deleted them, and changed email address back.

Second, if you're getting unusually high stat numbers like others listed here (me included) or 100% PHP stats and 0% MySQL, and no matter HOW SURE you are that you've edited the right files, before you post anything, start over again!! You've hacked the wrong global.php file (there are 2 found in the directories), or the wrong db_mysql.php file. Reload the originals, try it again.

Or you've copied and pasted additional characters from the instructions file that do not belong in the php file.

Third, backup and rename your original files (db_mysql.php, functions.php and global.php) so you'll be able to start over again. As I read this forum thread, I saw how many members had hacked the wrong files. I was CERTAIN I had not made that mistake. Yes, hacking at 1AM is not a good idea. Start over before posting the same stupid situation/question like I did, it was silly and should have known better.

Sorry for having asked the same question that's been answered over and over and over. I'd rather Nakkid be heads down, butt in seat, fingers on keyboard, coming up with more great hacks.

[TECK]

Originally posted by Keith
Also hoping someone might be able to explain the numbers in serverload.
i.e., [Server Load: 0.70 ? 0.64 : 0.58]

read more here. hope that helps.
about the wrong editing, dont worry. as i said before, i do similar errors me to, as everyone else on this board.

[FrankR310]

thanks for the hack; just what i needed.

a couple of questions:

1) i get 8 queries in my calendar; did i do something wrong? i see that minimum is 9 for vb pages.

2) why does vb have higher query numbers than some of the other boards i have seen?

thanks