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.

[neocorteqz]

Originally Posted by TECK

I don't have the 303 update, sorry.
I need to pay the VB update fee, soon next week.

If anyone have the step by step for the new code, post it here so I can update the txt file. Thanks guys.

hmmm. as far as i remember, i used your current available instrutions to install it.

when i get the chance, I'll either give the updated instructions, or maybe if it's allowed (seeing as it's only two files afaik) i can send my files to you and you can see for yourself?

I'm about to try and install gentoo, so I'll be unavailable for a bit.

[venomx]

I installed this with the instructions in the current file... worked fine here...

[SVTOA]

I guess I'm doing ok...

Page generated in 0.16333103 seconds (93.02% PHP - 6.98% MySQL) with 12 queries

[TECK]

Originally Posted by venomx

I installed this with the instructions in the current file... worked fine here...

Good to know no update is needed. I was surprised, since the VB3 code should not change...

[Guy G]

will this by any chance work on 3.0.6

[|Jordan|]

Works for me in 3.0.6

[nso]

After applying the hack (correctly, I might add) my forum became nothing more than a blank page. No errors, no nothing. Not even a mention of the event in the mysql logs.

Have anyone experienced anything similar to this?

[dfdems]

Dumb Question, how do I cache the 3 I have uncached?

Forumhome_stats_Member
Forumhome_stats_Poster
Forumhome_stats_Thread

Page generated in 0.21421003 seconds (90.33% PHP - 9.67% MySQL) with 16 queries

[MickDoneDee]

There are two Microstats hacks: Teck's and Erwin's. Sites with hacks will usually show uncached templates after installing the Microstats hack. Your question is, therefore, common and the answer can be found by reading through the thread. References I found on Erwins thread are here, here, here, and here.

The last reference is:

You need to add those templates at the beginning of the php page that you saw the message on. It will speed up the page and reduce the number of queries to the database which will be good for all of your vb installation.

If you look in the URL for the page you are displaying when those uncached templates appear you'll see the php file within the address. Index.php usually deals with forumhome templates. Open the index.php file and find:

// pre-cache templates used by all actions
$globaltemplates = array(
	'FORUMHOME',
	'forumhome_event',
	'forumhome_forumbit_level1_nopost',
	'forumhome_forumbit_level1_post',
	'forumhome_forumbit_level2_nopost',
	'forumhome_forumbit_level2_post',
	'forumhome_lastpostby',
	'forumhome_loggedinuser',
	'forumhome_moderator',
	'forumhome_pmloggedin',
	'forumhome_subforumbit_nopost',
	'forumhome_subforumbit_post',
	'forumhome_subforumseparator_nopost',
	'forumhome_subforumseparator_post'

Add your templates to this list. Alternatively, I use the global.php file which is used for every page loaded. There, you'll find:

// templates to be included in every single page...
$globaltemplates = array_merge($globaltemplates, array(
	// the really important ones
	'header',
	'footer',
	'headinclude',
	'phpinclude_start',
	'phpinclude_end',
	// new private message script
	'pm_popup_script',
	// navbar construction
	'navbar',
	'navbar_link',
	// forumjump and go button
	'forumjump',
	'gobutton',
	'option',
	// multi-page navigation
	'pagenav',
	'pagenav_curpage',
	'pagenav_pagelink',
	'threadbit_pagelink',
	// misc useful
	'spacer_open',
	'spacer_close',
	'username_loggedout',
	'username_loggedin',
	'timezone',
	'STANDARD_ERROR',
	'STANDARD_REDIRECT'
	//'board_inactive_warning'
));

Add your templates to that list and it should also cache them. No need to add your templates to both files. Choose one or the other.

[kall]

Originally Posted by ChuanSE

Yes, perfectly possible

i want to point out that the txt file with instructions is not up to date...

Search for and replace with... can't replace what can't be searched. the code was ok in previous versions of vB, where I installed the hack myself without problems.

But now mysql_db.php seems to be changed in this version, and i want to be sure to have an updated instruction file, before i start replacing

thx if ya wanna update it Teck

Well, upgrade to 3.0.7.

The instructions for installing this hack match the code in the stock files to the very last character.