Re: Les requetes du debug | Titre du sujet : Re: Les requetes du debug par BDC sur 15/03/2010 22:28:07
Bonsoir voici la première modif à savoir avoir les préfix dans les requêtes.
Dans \class\logger\render.php remplacer les lignes
if (empty($mode) || $mode == 'queries') { $class = 'even'; $ret .= '<table id="xo-logger-queries" class="outer"><tr><th>' . _LOGGER_QUERIES . '</th></tr>'; $xoopsDB =& XoopsDatabaseFactory::getDatabaseConnection(); $pattern = '/b' . preg_quote($xoopsDB->prefix()) . '_/i'; foreach ($this->queries as $q) { $sql = preg_replace($pattern, '', $q['sql']); $query_time = isset($q['query_time']) ? sprintf ('%0.6f - ', $q['query_time']) : ''; if (isset($q['error'])) { $ret .= '<tr class="' . $class . '"><td><span style="color:#ff0000;">' . $query_time . htmlentities($sql) . '<br /><strong>Error number:</strong> ' . $q['errno'] . '<br /><strong>Error message:</strong> ' . $q['error'] . '</span></td></tr>'; } else { $ret .= '<tr class="' . $class . '"><td>' . $query_time. htmlentities($sql) . '</td></tr>'; } $class = ($class == 'odd') ? 'even' : 'odd'; } $ret .= '<tr class="foot"><td>' . _LOGGER_TOTAL . ': <span style="color:#ff0000;">' . count($this->queries) . '</span></td></tr></table>'; }
Par
if ( empty($mode) || $mode == 'queries' ) { $class = 'even'; $ret .= '<table id="xo-logger-queries" class="outer"><tr><th>Queries</th></tr>'; foreach ($this->queries as $q) { $query_time = isset($q['query_time']) ? sprintf ('%0.6f - ', $q['query_time']) : ''; if (isset($q['error'])) { $ret .= '<tr class="'.$class.'"><td><span style="color:#ff0000;">'.htmlentities($q['sql']).'<br /><b>Error number:</b> '.$q['errno'].'<br /><b>Error message:</b> '.$q['error'].'</span></td></tr>'; } else { $ret .= '<tr class="'.$class.'"><td>'.$query_time. htmlentities($sql).htmlentities($q['sql']).'</td></tr>'; } $class = ($class == 'odd') ? 'even' : 'odd'; } $ret .= '<tr class="foot"><td>Total: <span style="color:#ff0000;">'.count($this->queries).'</span> queries</td></tr></table>'; }
La suite plus tard ++
|
|