function spdb_show_result($sql, $inspect) { spdebug_styles(true); echo '<div class="spdebug">'; echo sp_text('Inspect Query') . ': <strong>' . $inspect . '</strong><br><hr>'; echo '<pre><code>'; $k = array("\t", "\n", 'SELECT ', ' DISTINCT ', 'FROM ', 'LEFT JOIN ', 'RIGHT JOIN ', ' JOIN ', 'WHERE ', 'ORDER BY ', 'LIMIT ', ' ON ', ' IN ', ' DESC ', ' ASC ', ' DESC, ', ' ASC, ', ' AS ', ' OR ', ' AND ', ' LIKE '); $r = array('', '', "\n<b>SELECT</b> ", ' <b>DISTINCT</b> ', "\n<b>FROM</b> ", "\n<b>LEFT JOIN</b> ", "\n<b>RIGHT JOIN</b> ", " \n<b>JOIN</b> ", "\n<b>WHERE</b> ", "\n<b>ORDER BY</b> ", "\n<b>LIMIT</b> ", ' <b>ON</b> ', ' <b>IN</b> ', ' <b>DESC</b> ', ' <b>ASC</b> ', ' <b>DESC</b>, ', ' <b>ASC</b>, ', ' <b>AS</b> ', ' <b>OR</b> ', ' <b>AND</b> ', ' <b>LIKE</b> '); $sql = str_replace($k, $r, $sql); echo $sql; echo '</code></pre>'; echo '</div>'; }
function ashow($what, $user = -1, $title = '') { global $spThisUser; if ($user == -1 || $user == $spThisUser->ID) { spdebug_styles(true); echo '<div class="spdebug">'; if ($title) { echo sp_text('Inspect') . ': <strong>' . $title . '</strong><hr>'; } echo '<pre><code>'; if (is_string($what)) { $what = htmlentities($what); } print_r($what); echo '</code></pre>'; echo '</div>'; } }