VB3 MicroStats

You asked for... but it was available for VB2 only? There you go, you have it now.

Looking for 3.5.4 version? Get it here.

VERSION 1.2 RELEASED
Basically the only difference you will notice is a dropdown menu that will display the unchached templates.
In this way, you can add it to the cache and save one or more queries.

[high]THIS HACK WAS TESTED IN A DEFAULT, CODE UNMODIFIED BOARD.[/high]

This hack will add at the bottom of each vBulletin(powered) page the following stats:
REGULAR USERS STATS
- load time of specified page in microseconds (with custom no. of digits to show)
- percentages of PHP/MySQL usage
- number of queries executed

ADMINISTRATOR STATS
- number/name of uncached templates (name highlighted in blue, for uncached template)
- vBulletin DEBUG mode status
- server GZIP library compression status
- average Server Loads

[high]This is not only estethic, it will also help you troubleshoot any wierd queries that you have in your scripts.[/high]

IMPORTANT
If you get results like:
Page generated in 3.35731196 seconds (9.05% PHP - [high]90.95%[/high] MySQL) with 17 queries
You probably use a bad piece of code, because 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.

DIVISION BY ZERO ERROR? Read this.
INVALID STATS IF MYSQL COMPILED IN A NON-ENGLISH LANGUAGE? Read this.

NOTE: The blue highlighting is not working in Opera 7.23 version. (Thanks Christine)

Have fun.

[TECK]

It might be easier then we think... there is a hook placed at the right place...
So we will not need to edit anything in the php files... at least from the first look.

I will get back to you guys soon with the plugin.
It should be based on a custom template that you need to create (copy/paste), plus the plugin .xml file.

[derekivey]

Why not just use the product system so you don't have to have everyone add a custom template? The product system would add it automatically as well was the plugin.

Derek

[TECK]

Good idea. I'm working on it as we speak... it should published this evening.
I really have to get used to the new VB3.5 features.

Please give me more details about the product system...
Used to the old school way, editing the php code. Thanks.

[derekivey]

Just create a new product in the product system. Then turn on debug mode and in the style manager, go to the MASTER STYLE, and click Add Template in the drop down menu. When you add the template there, select the product you added in the drop down menu on the page it takes you to. When you export the product it will automatically include the template with the xml file and any plugins, settings, or phrases. When the user installs the product it automatically adds all of those.

Keep up the nice work .

Derek

[TECK]

Thanks for the info Derek. One question: How do you generate the product ID's? If I enter an ID, what will hapen if someone have already this ID in use? It should be generated automatically...

About Microstats, I will not use a template... after all, since it will use the ones built in VB aready, simplier this way.
I'm having trouble with the $querytime... the rest is working perfectly.
I started a thread here:
https://vborg.vbsupport.ru/showthread.php?t=115523

I try to avoid creating a bunch of functions to emulate the debug mode...
Any solutions are apreciated.

[derekivey]

Not sure, sorry .

[TECK]

Mod released for vBulletin 3.5.4.
https://vborg.vbsupport.ru/showthread.php?t=116027

Enjoy.

[derekivey]

Thanks TECK, will install when I get home from school .