function Calc_SQL_Details()
{
global $wpdb, $wpdbtmp;
//
// Calculate stats from query array
//
$this->nQueries = $wpdb->num_queries;
if (WPTUNER_NOQUERIES || !$this->nQueries) {
return '';
}
//
// ALWAYS summarize query errors
//
$this->badCount = 0;
$this->okCount = 0;
if (!isset($wpdb->queries)) {
wpTuneLog(__('WP Tuner Report: (please report) I could find no queries at all!!??', 'wptuner'));
$this->nQueries = 0;
return;
}
foreach ($wpdb->queries as $idx => $cQuery) {
$parsedQuery = $this->Parse_Query($cQuery, TRUE);
$this->qList[$idx] = $parsedQuery;
if ($parsedQuery['ok']) {
$this->okCount++;
} else {
$this->badCount++;
}
}
}
/**
* Get the name of the function that called wpdb.
* @return string: file, linenumber and name of the calling function
*
* This version actually provides helpful info. The original simply says things like 'require_once'
*/
function get_caller()
{
global $wptunershow;
$lastDBidx = 0;
$bChargedToPlugin = FALSE;
// requires PHP 4.3+
if (!is_callable('debug_backtrace')) {
return '';
}
$bt = debug_backtrace();
$caller = '';
//
// Scan for the first non-wpdb location on the stack
//
foreach ($bt as $idx => $trace) {
if (isset($wptunershow) && $wptunershow->iDebugLevel & 256) {
wpTuneLog($idx . ': ' . $trace['file'] . "({$trace['line']}): {$trace['class']}{$trace['type']}{$trace['function']}()");
}
$parse = substr($trace['file'], strlen(ABSPATH), 11);
if (isset($trace['class'])) {
switch ($trace['class']) {
case __CLASS__:
case 'wpdb':
$lastDBidx = $idx;
// Find the outermost call into WPDB
if ($idx && substr($parse, 0, 10) == 'wp-content') {
break 2;
}
// If not the first (get_caller) item, break out of the search -- we found a plugin or theme
continue 2;
// continue the foreach
}
}
if (substr($parse, 0, 10) == 'wp-content') {
break;
// we found a plugin or theme, so stop here
}
if (isset($wptunershow) && $wptunershow->bChargePlugins && $parse == 'wp-includes') {
$bChargedToPlugin = TRUE;
continue;
// all include-functions get charged to the calling plugin!
}
break;
}
if ($idx && !strlen($bt[$idx]['file'])) {
if (isset($wptunershow) && $wptunershow->iDebugLevel & 512) {
wpTuneLog($idx . ': backing off from ' . $trace['file'] . "({$trace['line']}): {$trace['class']}{$trace['type']}{$trace['function']}()");
}
$idx--;
// somehow we're in a black hole. Charge to whatever this one called
}
if (isset($wptunershow) && !$wptunershow->bChargePlugins) {
$idx = $lastDBidx;
// resets both if we're not charging plugins, AND during first few queries during startup
}
$trace = $bt[$idx];
// If not charging to the plugin, we want the final item from the foreach rather than the item after that
$trace['file'] = substr($trace['file'], strlen(ABSPATH));
if (strlen($trace['class'])) {
if (substr($trace['class'], 0, 4) == 'wpdb') {
$trace['class'] = 'wpdb';
}
$trace['class'] .= '->';
}
$caller = $trace['file'] . "({$trace['line']}): {$trace['class']}{$trace['function']}()";
return $caller;
}
