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.

[PitchouneN64ngc]

Thanks for this great hack, it's useful

But when you have the quick style chooser enabled, your hack deforms a little bit the footer.

For repair this, you must to do these modifications into ./includes/functions.php:

$ms .= ' <td class="tcat"><div class="smallfont">';

$ms .= ' <td class="tcat" colspan="2"><div class="smallfont">';

And:

$ms .= ' <td class="alt1"><div class="smallfont">';

$ms .= ' <td class="alt1" colspan="2"><div class="smallfont">';

And all is correct

[TECK]

Thanks for mentioning, PitchouneN64ngc. I uploaded a new file with the fix.
Now is done automatically, so if you ever disable that option, you don't have to edit the code...

[TheComputerGuy]

awesome hack. Installing in a bout 5 minutes

[djohn]

I get a parse error when i go to the Template manager:

Parse error: parse error in /home/site/public_html/board/includes/functions.php on line 2463

Fatal error: Call to undefined function: exec_nocache_headers() in /home/site/public_html/board/admincp/global.php on line 37

[Boofo]

I don't see the server load with this installed. It isn't in your screenshot either.

[Red Blaze]

<a href="https://vborg.vbsupport.ru/showthread.php?t=59700" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=59700</a>

Doesn't that do pretty much the same thing? Only admins can see Erwin's version though. But I think that can be changed.

[PitchouneN64ngc]

Originally Posted by djohn

I get a parse error when i go to the Template manager:

Have you edited your functions.php file with Dreamweaver?

[TECK]

Originally Posted by Sonikku

https://vborg.vbsupport.ru/showthread.php?t=59700

Doesn't that do pretty much the same thing? Only admins can see Erwin's version though. But I think that can be changed.

Unfortunatelly, it does not do the same thing.
Erwin knows the difference:

Originally Posted by Erwin

Okay, the original was by TECK. This is NOT based on his code - it is based on vB3's native code. If TECK wants me to remove this, I will do so. This is just my version that I use for my private forums.

Originally Posted by Boofo

I don't see the server load with this installed. It isn't in your screenshot either.

You need to have enabled the exec('uptime') in your server, in order to see the average server loads.
Contact your host for more details.
I know that Windows has no uptime binary, that could be executed with exec functions. Only Unix does this.

[Boofo]

I got it working.

I had to change this:

PHP Code:

if (preg_match("/averages?: ([0-9\.]+), [\s]+([0-9\.]+), [\s]+([0-9\.]+)/", $stats, $regs)) 


to this:

PHP Code:

preg_match("/averages?: ([0-9\.]+), [\s]+([0-9\.]+), [\s]+([0-9\.]+)/", $stats, $regs); 


For some reason there was an if in that line. I know I have exec('uptime') enabled on the server because it was working fine before. And after taking the if out, it works fine now again. Thank you, Teck, for converting this to vB3. I added a couple of things to mine, in case anyone wants to see it.

[TECK]

The IF should not change anything, except avoid proccesing any not needed functions, while increasing performance.
Do you run a UNIX box? Also, something is wrong there with your server. You cannot have 0 for all average loads, or make it work on Windows, from what I know (if anyone knows a way, please let me know, since I'm not good at server configuration ).

Leave the code as it is (that's why you get zero's)... and check with your host.
Let us all know the results.

Cheers.