Board Optimization - vBMicroStats

This hack will add at the bottom of each vBulletin (powered) page, the statistics listed below.
Also, it will help you troubleshoot and optimize your vBulletin board by viewing or comparing PHP/MySQL options and other statistics that are normally hidden in your forum pages.

Regular Users:
? Load time of specified page in microseconds
? Number of queries executed
? PHP percent page usage
? MySQL percent page usage

Administrators Only:
? Active users browsing the forum (members and guests) new in 1.1.0
? Server memory usage per page (in Kb)
? Display DEBUG mode status
? Browser GZIP library compression status
? Server average loads
? Uncached templates (useful to troubleshoot the code)

The code modifications were tested into a clean installed vBulletin board. They work 100%.
The hack was tested in vBulletin 3.6.4 and 3.6.5.
If you want to test it into a lower version (3.6.x), let me know.
Also, if you encounter any problems, feel free to post your questions here.

Step by step install instructions are posted into readme.html file.
In order to perform an efficient modification of your files, I recommend you to use Komodo Edit or Textpad.
Both editors will allow you to complete all steps without any coding errors.

The code changes are very safe and designed not to interfere in any way with the vBulletin performance/functionality.
Make sure you modify, save and upload one file at the time to your server.
Then, simply run the product-vbmicrostats.xml file.

[high]The PLUGIN itself is DISABLED by default.[/high]
This was done in order to make sure you properly edit your code first and to avoid surprises.
You will need to enable it, once your code modifications are completed:
Plugins and Products > Manage Products > vB Microstats > Enable (dropdown)
Then, go to your vBulletin Options, click on BB MicroStats setting group and set all your options.

Upgrade to version 1.0.2.
Upgrade to version 1.0.3.
Upgrade to version 1.1.0.

Want to be a guinea pig and try this hack into a higher vBulletin version?
Post your results, so others can read your feedback.

[Smoothie]

Mr. F, welcome back.

[TECK]

Originally Posted by Smoothie

Mr. F, welcome back.

Thanks.

Originally Posted by ncweb

Any Ideas on this; it happens on both my winXP and CentOS 4.4 dev box. Has anyone else seen results like this? I'd provide some details of my LAMP setup but don't know what would be helpful. I was getting normal results before and this has me scratching my head

Yes, you need to replace ONLY the very last one.
Will update the readme file.

About the negative values, is all related to server time clock, microtime(). It's a confirmed bug.
Freddie (vB dev) managed to reproduce the bug but did not released a fix.
Since I use the vB core functions, this error is reflected into your time, if you are not lucky.

Read more here:
http://www.vbulletin.com/forum/bugs3...iew&bugid=2481

[TECK]

Thinking out loud, what PHP version you have? I have 5.2.1, working perfectly here:
http://67.68.90.79/forum/

[Reeve of shinra]

Originally Posted by TECK

Reeve of shinra is checking my thread, as I type.
Good to see you, old school friend.

Sup man! Its been ages since we last chatted so im gonna hijack your thread! how you been?


The stats are awesome, this has always been one of my favorite mods.

Things are working like a charm but I forgot that I had an older version (1.0.5) installed. I didn't choose to over write and I have two options in the admincp for the mod. No biggie, I disabled it for now and will probably uninstall later when I do a backup. Just thought I'd point that out if anyone else runs across it.

[ncweb]

Originally Posted by TECK

About the negative values, is all related to server time clock, microtime(). It's a confirmed bug.
Freddie (vB dev) managed to reproduce the bug but did not released a fix.
Since I use the vB core functions, this error is reflected into your time, if you are not lucky.

Read more here:
http://www.vbulletin.com/forum/bugs3...iew&bugid=2481

Looks like the bug referenced at http://www.vbulletin.com/forum/bugs3...iew&bugid=2481
never got fixed in 3.6.x.

Originally Posted by TECK

Thinking out loud, what PHP version you have? I have 5.2.1, working perfectly here:
http://67.68.90.79/forum/

I'm running PHP 4.4.4; I saw on http://67.68.90.79/forum/ that the mysql % was higher than that of php. If that basically a default install then I guess that?s normal. Thanks for your time and the replies TECK

[TECK]

Originally Posted by ncweb

I'm running PHP 4.4.4; I saw on http://67.68.90.79/forum/ that the mysql % was higher than that of php. If that basically a default install then I guess that’s normal. Thanks for your time and the replies TECK

Ya, is normal. The easiest way to see if you have the stats right is to enable the debug mode, the do an explain. Look at the time spent to do PHP and MySQl things, they are pretty balanced.
Those times reflect the percentage. You will also see there negative results, so that should answer your questions related to the vB bug.

Let's take an example shall we?
http://67.68.90.79/forum/showthread.php?t=1
Page generated in 0.13296827 seconds (61.87% PHP - 38.13% MySQL) with 9 queries
And the Explain:
Page generated in 0.13317393951416 seconds with 9 queries, spending 0.011376857757568 doing MySQL queries and 0.12249708175659 doing PHP things.

Glad I could help.

Originally Posted by Reeve of shinra

Sup man! Its been ages since we last chatted so im gonna hijack your thread! how you been?

Good to see you to Reeve. Trying to make people happy, since many wanted the microstats for 3.6.4.
I remember when people used to queue on your board for your hacks... good times.
If you feel like talking on MSN, drop me a PM, I'll send you the ID.

[COBRAws]

Thanks for updating this m8

[Lizard King]

Thanks for updating this after my request Floren

It is also nice to see you back alive at vb.org

[Atakan KOC]

Nice. Thanks.

[Xplorer4x4]

0KB Used | DEBUG Mode OFF | GZIP ON (level 1) | 0.54 : 0.59 : 0.55 | NO Uncached Template

I have turned debug on in ACP options but it does not show on the forum.