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.

[gmarik]

Nice one!

[TECK]

Originally Posted by Boofo

This is wierd. I re-downloaded your file and put the if code in like you have it in your file and for some reason, it is showing the server load now (with the IF statement). I swear to you that it wasn't working before. I don't know what happened. You have any ideas?

My secret . Heh.
I made a little mistake, added a space in the wrong space.

[Boofo]

So it wasn't me messing up? Come on, you have to tell me. PM if you don't want to spill it here. I have to know now, especially after all we went through together on this, BUDDY! .

[TECK]

Originally Posted by Boofo

So it wasn't me messing up? Come on, you have to tell me. PM if you don't want to spill it here. I have to know now, especially after all we went through together on this, BUDDY! .

No, it was REALLY me.
I added a space in the wrong place into preg_match() function.
Sorry guys, error fixed, thanks to Bob. The file is uploaded with the right code.

[Boofo]

What a team! What a team!

I guess the file I downloaded had the fixed code in it already? Or do I need to re-download it?

It's working like a charm, by the way. Great work, Floren!

[TECK]

Ya, the file you downloaded is the most recent one.

[Boofo]

Thank you, sir.

[ChuanSE]

I don't know what to do with the footer template :/

I had this

{ms}
$ms = '<tr align="right">' . "\n";
$ms .= '<td class="tcat"><div class="smallfont">';
$ms .= 'Page generated in ' . $totaltime . ' seconds (' . $msphp . ' - ' . $mssql . ') with ';
$ms .= $query_count . ' queries</div></td>' . "\n";
$ms .= '</tr>' . "\n";
$ms .= '<tr align="right">' . "\n";
$ms .= '		<td class="alt1"><div class="smallfont">';
$ms .= $mstemplates . $msdebug . $msgzip . $msserver . '</div></td>' . "\n";
$ms .= '</tr>' . "\n";

and it gave me this : (see attachment)

= ' ' . "\n"; .= ' '; .= 'Page generated in ' . . ' seconds (' . . ' - ' . . ') with '; .= 8 . ' queries ' . "\n"; .= '
' . "\n"; .= ' ' . "\n"; .= ' '; .= . . . . '

any idea's? :ermm:

[Boofo]

This is all you add to your footer template:

 {ms}

The rest stays in the functions.php

[ChuanSE]

then it does nothin'

but where do i remove the "if" from the pragma thingie?