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]

Little esthetic change, to display the number of unchached templates...
Change this code part:

		if ($_TEMPLATEQUERIES)
		{
			$mstemplates = '<b>' . sizeof($_TEMPLATEQUERIES) . '</b> Uncached ';
			$mstemplates .= iif(sizeof($_TEMPLATEQUERIES) != '1', 'Templates', 'Template') . ' | ';
		}

New file uploaded...

[ChuanSE]

Hey Teck,

I don't really understand what i should change? the code to change is the code that i allready have changed 3 days ago.... Unless i'm not seeing the difference ofcourse

this is what i have:

$mstemplates = 'NO Uncached Templates | ';
		if ($_TEMPLATEQUERIES)
		{
			$mstemplates = '<b>' . sizeof($_TEMPLATEQUERIES) . '</b> Uncached ';
			$mstemplates .= iif(sizeof($_TEMPLATEQUERIES) != '1', 'Templates', 'Template') . ' | ';
		}

[TECK]

If you have this already in your functions.php, you are set to go.
No need to change anything...

About your site:
1 Uncached Templates | DEBUG Mode OFF | GZIP ON (level 5) | 0.09 : 0.08 : 0.20

You have one template, not cached, that means you perform one query extra because the template name is not part of the cache array.
Also, I would switch the GZIP to level 1, 5 will slow down your server, IMO.
Server load averages gives me the hint you are on a dedicated server, that means you are rich...

[ChuanSE]

Ah Teck,

thx for this tip mate... I'm gonna try to find which template isn't in the cache aray allright.
ABout the gzip level. It seems logic indeed that 5 would slow down the server a little, but i was wondering.... it speeds up the page for the users then?
I always wondered what the best setting would be, so i took the middle
Gonna try it with level one now and will see if it improves the speed...

And yeah, it is a dedicated server allright
I have the forums / gallery / pphlogger / webmail / irc eggdrop and some other small things running there... But me rich? Naaah
Good sponsors, yes

[TECK]

Originally Posted by ChuanSE

I'm gonna try to find which template isn't in the cache aray allright.

Look at the new hacked code you added, there is your template name. Add it at the top of the file, in the templates array list.

[ChuanSE]

Problem is: i added like 20 hacks in the last week
Which one would it be then :?

[Boofo]

Turn on DEBEG and it will show you which template isn't cached.

[TECK]

Originally Posted by ChuanSE

Problem is: i added like 20 hacks in the last week
Which one would it be then :?

Review the index.php file, since only there you get one uncached template, right?

[sabret00the]

sorry to be a pain, but i'm encountering an error on line 1843

	$ms .= '		<td class="tcat"' . iif($vboptions['allowchangestyles'], ' colspan="2"') . '><div class="smallfont">';

the error is

Parse error: parse error, unexpected T_STRING in K:\Network\xampp\htdocs\forums\includes\functions.php on line 1843

Fatal error: Call to undefined function: exec_nocache_headers() in K:\Network\xampp\htdocs\forums\admincp\global.php on line 37

[Detomah]

Excellent.

I've been looking for something like this for ages and missed this somehow, found it now though and installed perfectly first time.