vBMicrostats
 

Finally, the vBMicroStats product for vBulletin 3.5.4 is here. :)
The previous versions of my mod were very solicited by vBulletin administrators...
I hope you will enjoy this new version as much you did the other ones.

Looking for VB 3.6.x version? It is here.

This mod with 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:
? Server memory usage per page (in Kb)
? DEBUG mode status
? Browser GZIP library compression status
? Server average loads
? Uncached templates (useful to troubleshoot the code)

The code modifications listed below were tested into a clean installed vBulletin board. They work 100%.
If you encounter any problems, feel free to post your questions here.

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

I tried to use the plugin system as much as I could, in order to avoid any unnecessary code modifications.
In order to set the right query execution time, you will need to perform 2 small code changes to each of the following files:
? class_core.php (folder /includes)
? init.php (folder /includes)

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-plugin_vbmicrostats.xml file.

Once the product installed, don't forget to enable it.
Go to your vBulletin Options, click on BB MicroStats setting group and set all your options.

Division by Zero? View the fix.
Negative results? View the fix. I'm waiting a response from vBulletin Team, for a better fix.
Stats not showing in PhotoPost? View the fix.
Stats only for Administrators? View the fix.

Also, if you get results like:
Page generated in 3.35731196 seconds (9.05% PHP - [high]90.95%[/high] MySQL) with 30 queries
every time you refresh your php page, you probably use a bad piece of code.
vBulletin will never generate those extreme results.
Imagine this: the code uses only 10% the resources to read the actual PHP code and the rest of 90% is used only to scan the tables... WOW!
That means the code forces to read into the database for each user who visits the site at this percentage... if you have 1000 users viewing the page in the same time.. you can get a picture of it...
If you compare this with vBulletin, the software does the opposite, 90% PHP and 10% MySQL... the right way.

awesome, I'll check it out :)

Excellent work, sir. Been waiting for this. And welcome back! ;)

awesome :)

Thank you Boofo (and all my vBFriends)! Good to be back in the house.
BTW, the VB3.5.4 code made me pull my hair few times, trickier then I thought... since it's so different from VB2.
Now, back to my vBlog product... :)

The new code and ways of doing things will do that at first but once you get used to it, it is better than you thought it could ever be. ;)

I will suggest downloading and installing mtha's Advanced Product Manger though. It is the only thing to use for putting hacks together. Everything all in one place to work with. You won't regret it. ;)

ok question mine dont center and it makes a table... check the screen shot out.. also is there anyway to make it display like this mod does https://vborg.vbsupport.ru/showthread.php?t=82900 at the bottom of the footer without the table?

hmmm. all code mods installed, double checked, template modified, enabled, shows up on page, but no value for time displayed

i was just getting ready to say the same thing lol