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.

[TECK]

Still waiting on the options you want implemented...

[thincom2000]

If Jelsoft were to combine the functions contained in the files class_database_slave.php and class_database_explain.php, and put the $vbulletin->debug checks inside each function, although it would increase load times a millisecond or so, we could then set $vbulletin->debug in the AdminCP without damaging the EXPLAIN feature.

Unless TECK gets to it first, maybe I'll release it as a hack.

[Xplorer4x4]

Originally Posted by thincom2000

If Jelsoft were to combine the functions contained in the files class_database_slave.php and class_database_explain.php, and put the $vbulletin->debug checks inside each function, although it would increase load times a millisecond or so, we could then set $vbulletin->debug in the AdminCP without damaging the EXPLAIN feature.

Unless TECK gets to it first, maybe I'll release it as a hack.

So would it be able to combine the variables needed from the 2 files into a new php script to enable debug mode rather then a file edit?

@TECK I say keep it, and make not that it is a cut down version of debug mode.

[thincom2000]

It is possible to do this without a file edit, yes. That would require replacing both files I mentioned with "combination" files of the same names (class_database_slave.php and class_database_explain.php). Otherwise, if you do not want to overwrite both files, it is possible to upload a new file, and make a file edit to include the new file instead.

[TECK]

Originally Posted by thincom2000

If Jelsoft were to combine the functions contained in the files class_database_slave.php and class_database_explain.php, and put the $vbulletin->debug checks inside each function, although it would increase load times a millisecond or so, we could then set $vbulletin->debug in the AdminCP without damaging the EXPLAIN feature.

Unless TECK gets to it first, maybe I'll release it as a hack.

Not sure it is a good idea, although your logic is very good.
If would be only a milisecond, Jelsoft would have it enabled in Admin CP long time ago... I'm always worried about performance on large boards.
Anyways, I have to look into it, since vBulletin 3.6.5 was released and this hack needs to be modified, in order to be installed properly.
I sure like to have DEBUG at my finger tips, without uploading config.php back and forward.

[Phooey]

Nice to see this ported to 3.6.X! I'll be installing it when I get home from work. :up:

[TECK]

Version 1.1.0 released.
New administrative feature: Active users browsing the forum (members and guests)
Also, now vBMicrostats uses vBulletin language phrases, so you can edit them the way you like.
This is useful if you run your forum in several languages.

Current vBMicrostats phrases:
debug_mode_on
gzip_off
gzip_on_level_x
page_generated_in_x_seconds_y_php_z_mysql_n_querie s
server_load_x_y_z
uncached_templates_x
x_kb_used
x_users_y_members_z_guests

How to upgrade to Version 1.1.0:
1. Uninstall your current vBMicroStats product. Leave the PHP files the way they are edited now, they are not needed to be re-modified in order to work with the new version.
2. Install the new product, included in the vbmicrostats_110.zip file.

[ManagerJosh]

Very nice Release Teck. Minor problem though when it's a non-admin viewing. It's not stretched out. It's compressed and aligned left.

Tested it against a stock style, so it's definitely a bug.

[cashpath]

How would I change how this is displayed? I can't find a template so I'm assuming in a file?

[Skavenger]

Originally Posted by cashpath

How would I change how this is displayed? I can't find a template so I'm assuming in a file?

AdminCP > Plugins & Products > Plugin Manager > Product : vBMicroStats > Global: Complete [Edit]

Look at the end of the template: // regular users template