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.

[DementedMindz]

ok thank you working on it now

[Kaleem]

Installed Thank You

[TECK]

Let me know how is the new version.

[TECK]

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

[DementedMindz]

seems like its working alot better then the last one. my stats use to stay the same alot on the 3.5.4 one but this one is reading the stats pretty well Page generated in 0.32 seconds (70.22% PHP - 29.78% MySQL) with 21 queries and the php and mysql change with each refresh where as the last one was reading it wrong it seemed.

[TECK]

Thanks for the feedback. That's the reason why I told to ncweb not to use the old code.
The new one is pretty elegant.

You can see if it's working well this way: 70.22% PHP + 29.78% MySQL = 100% code ops.

[DementedMindz]

yeah the last version on 3.5.4 wouldn't do that this is much nicer and works 100% every time only thing I have left to do now is enable-memory-limit in php. thanks again.

[ncweb]

I find two instances of this in File: init.php (folder /includes)

if (!empty($db->explain))
{
	$db->timer_stop(false);
}

One is at line: 213 and the other near the end at line: 432. I should be replacing the one at the end right?

Either way I am getting some very wierd numbers (-28 php - 128% mysql); please see screenshot. It always says more mysql than php, shouldn't that be the other way around? Thanks...

[DementedMindz]

Originally Posted by ncweb

I find two instances of this in File: init.php (folder /includes)

if (!empty($db->explain))
{
	$db->timer_stop(false);
}

One is at line: 213 and the other near the end at line: 432. I should be replacing the one at the end right?

Either way I am getting some very wierd numbers (-28 php - 128% mysql); please see screenshot. It always says more mysql than php, shouldn't that be the other way around? Thanks...

how can you find that one when it says to search for this..

if ($vbulletin->session->vars['styleid'] != 0)
{
	$vbulletin->userinfo['styleid'] = $vbulletin->session->vars['styleid'];
}

if (!empty($db->explain))
{
	$db->timer_stop(false);
}

[ncweb]

Originally Posted by ncweb

Either way I am getting some very wierd numbers (-28 php - 128% mysql); please see screenshot. It always says more mysql than php, shouldn't that be the other way around? Thanks...

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