Board Optimization - vBMicroStats

This hack will add at the bottom of each vBulletin (powered) page, the statistics listed below.
Also, it will help you troubleshoot and optimize your vBulletin board by viewing or comparing PHP/MySQL options and other statistics that are normally hidden in your forum pages.

Regular Users:
? Load time of specified page in microseconds
? Number of queries executed
? PHP percent page usage
? MySQL percent page usage

Administrators Only:
? Active users browsing the forum (members and guests) new in 1.1.0
? Server memory usage per page (in Kb)
? Display DEBUG mode status
? Browser GZIP library compression status
? Server average loads
? Uncached templates (useful to troubleshoot the code)

The code modifications were tested into a clean installed vBulletin board. They work 100%.
The hack was tested in vBulletin 3.6.4 and 3.6.5.
If you want to test it into a lower version (3.6.x), let me know.
Also, if you encounter any problems, feel free to post your questions here.

Step by step install instructions are posted into readme.html file.
In order to perform an efficient modification of your files, I recommend you to use Komodo Edit or Textpad.
Both editors will allow you to complete all steps without any coding errors.

The code changes are very safe and designed not to interfere in any way with the vBulletin performance/functionality.
Make sure you modify, save and upload one file at the time to your server.
Then, simply run the product-vbmicrostats.xml file.

[high]The PLUGIN itself is DISABLED by default.[/high]
This was done in order to make sure you properly edit your code first and to avoid surprises.
You will need to enable it, once your code modifications are completed:
Plugins and Products > Manage Products > vB Microstats > Enable (dropdown)
Then, go to your vBulletin Options, click on BB MicroStats setting group and set all your options.

Upgrade to version 1.0.2.
Upgrade to version 1.0.3.
Upgrade to version 1.1.0.

Want to be a guinea pig and try this hack into a higher vBulletin version?
Post your results, so others can read your feedback.

[ncweb]

I installed version 1.0.5 for 3.5.4 and made it work with 3.6.4 by using the code below.

Maybe a dumb question, but is there any reason I should use this version instead? It seems like there are more code changes and 2 new files.

Also, before I could get this post out the version changed from 1.0 to 1.0.1; what changes were made to the /plugins files? Great mod TECK, Thank you...

Originally Posted by LunaTech

Till TECK gets to this, all you have to do to get this working in 3.6.4 is change what you edit in class_core.php. Instead of the instructions given, replace execute_query in class_core.php with:

	function &execute_query($buffered = true, &$link)
	{
		$this->connection_recent =& $link;
		$this->querycount++;

		// start microstats timer
		$this->mstimer_start();
		$queryresult = $this->functions[$buffered ? 'query' : 'query_unbuffered']($this->sql, $link);
		$this->mstimer_stop();

		if ($queryresult)
		{
			// unset $sql to lower memory .. this isn't an error, so it's not needed
			$this->sql = '';

			return $queryresult;
		}
		else
		{
			$this->halt();

			// unset $sql to lower memory .. error will have already been thrown
			$this->sql = '';
		}
	}

	/**
	* vBMicroStats: Query execution time
	*
	* @return	string
	*/
	var $mstime_total = 0;
	var $mstime_before = array();
	function mstimer_start()
	{
		$this->mstime_before[] = microtime();
	}
	function mstimer_stop($qtime_total = true)
	{
		$mstime_after  = microtime();
		$mspage_start  = explode(' ', TIMESTART);
		$mspage_start  = $mspage_start[0] + $mspage_start[1];
		$mstime_before = explode(' ', array_pop($this->mstime_before));
		$mstime_before = $mstime_before[0] + $mstime_before[1] - $mspage_start;
		$mstime_after  = explode(' ', $mstime_after);
		$mstime_after  = $mstime_after[0] + $mstime_after[1] - $mspage_start;
		$mstime_taken  = $mstime_after - $mstime_before;
		if ($qtime_total)
		{
			$this->mstime_total += $mstime_taken;
		}
	}

[TECK]

One, the code edit in the above function is not accurate, the execution time will not be reflected properly.
Two, there are 2 execute_query() functions in VB, totally different. You DO NOT paste the same code in both places.

Hmm, I think I found a bug. Guys do this, logout and tell me if you still see the admin microstats.
You should only see the regular microstats, the second line should be hidden.

[thincom2000]

Never thought I would say this, but now I wish I could turn on enable-memory-limit.

[TECK]

Guys, make me a favor, logout and tell me if you still see the admin microstats.
Thanks.

[thincom2000]

Originally Posted by TECK

Guys, make me a favor, logout and tell me if you still see the admin microstats.
Thanks.

In plugins/hook_global_complete.php, find:

PHP Code:

    $show['adminoptions'] = $vbulletin->options['vb36_mstats_adminactive'] AND $vbulletin->userinfo['permissions']['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['cancontrolpanel']; 


Replace with:

PHP Code:

    $show['adminoptions'] = ($vbulletin->options['vb36_mstats_adminactive'] AND $vbulletin->userinfo['permissions']['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['cancontrolpanel']) ? true : false; 


[TECK]

Thanks. So, does it show the admin stats when logged out?
The code should be:

$show['adminoptions'] = (bool)($vbulletin->options['vb36_mstats_adminactive'] AND $vbulletin->userinfo['permissions']['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['cancontrolpanel']);

Still, those are both boolean values, is like saying twice true or false.

For some servers, the data needs to be loaded directly into memory.
Can you guys post and tell me if with the actual unchanged code from version 1.0.1 you see the admin stats while logged out.

The fix is easy, but I need to make sure.

[ncweb]

In 1.0.1 yes, I do see the admin stats as guest, registered and admin user.

/installed

[TECK]

Perfect, thanks.
Fixing this bug is very easy. I also decided to load into memory all data, it should improve performance.

To upgrade to version 1.0.2, all you have to do is:
1. Uninstall the vBMicrostats product but leave class_core.php and init.php code modifications in place.
They are good.

2. Delete folder /plugins.

3. Download the new 1.0.2 .zip file.

4. Run the product-vbmicrostats.xml installer.

5. Enable all BB MicroStats options, like before.

You are done.

[DementedMindz]

teck will this code mod still work from this post? https://vborg.vbsupport.ru/showpost....1&postcount=34

[TECK]

Yes.
Use the new conditionals, compare the code.