Version: 1.0.5, by TECK
Developer Last Online: Nov 2023
Version: 3.5.4
Rating:
Released: 05-18-2006
Last Update: 05-21-2006
Installs: 92
Uses Plugins Template Edits
Code Changes
No support by the author.
Finally, the vBMicroStats product for vBulletin 3.5.4 is here.
The previous versions of my mod were very solicited by vBulletin administrators...
I hope you will enjoy this new version as much you did the other ones.
This mod with 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:
? Server memory usage per page (in Kb)
? DEBUG mode status
? Browser GZIP library compression status
? Server average loads
? Uncached templates (useful to troubleshoot the code)
The code modifications listed below were tested into a clean installed vBulletin board. They work 100%.
If you encounter any problems, feel free to post your questions here.
Step by step install instructions are posted into vbmicrostats.html file.
In order to perform an efficient modification of your files, I recommend you to use Dreamweaver (Coder Mode) or Textpad.
Both editors will allow you to complete all steps without any coding errors.
I tried to use the plugin system as much as I could, in order to avoid any unnecessary code modifications.
In order to set the right query execution time, you will need to perform 2 small code changes to each of the following files:
? class_core.php (folder /includes)
? init.php (folder /includes)
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-plugin_vbmicrostats.xml file.
Once the product installed, don't forget to enable it.
Go to your vBulletin Options, click on BB MicroStats setting group and set all your options.
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
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:
Code:
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;
}
}
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:
Code:
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;
}
}
Not sure I follow, replace all instances of execute_query with the above code? Thanx
vBMicrostats Details »»
About Developer
Visit Web Site
Uses Plugins 
No support by the author.
01-09-2007, 10:40 PM
