function SQLError($sql, $error)
{
global $lang, $mysql_errorhelp_ref, $config;
echo '<div align="center"><table border="1" bordercolor="#ff0000" cellspacing="0">
<tr bgcolor="#ff0000"><td style="color:white;font-size:16px;"><strong>MySQL-ERROR</strong> <a href="' . $mysql_errorhelp_ref . '" target="_blank">
<img src="' . $config['files']['iconpath'] . 'help16.gif" alt="' . $lang['MySQLErrorDoc'] . '" title="' . $lang['MySQLErrorDoc'] . '" width="16" height="16" border="0"></a></td></tr>
<tr><td style="width:80%;overflow: auto;">' . $lang['sql_error1'] . '<br><br>' . Highlight_SQL($sql) . '</td></tr>
<tr><td width="600">' . $lang['sql_error2'] . '<br><br><span style="color:red;">' . $error . '</span></td></tr>
</table>
</div>';
}
function SQLError($sql, $error, $return_output = false)
{
// v(debug_backtrace());
global $lang;
$ret = '<div align="center"><table style="border:1px solid #ff0000" cellspacing="0">
<tr bgcolor="#ff0000"><td style="color:white;font-size:16px;"><strong>MySQL-ERROR</strong></td></tr>
<tr><td style="width:80%;overflow: auto;">' . $lang['L_SQL_ERROR2'] . '<br><span style="color:red;">' . $error . '</span></td></tr>
<tr><td width="600"><br>' . $lang['L_SQL_ERROR1'] . '<br>' . Highlight_SQL($sql) . '</td></tr>
</table></div>';
if ($return_output) {
return $ret;
} else {
echo $ret;
}
}
function SQLOutput($sqlcommand, $meldung = "")
{
global $sql, $lang;
$s = '<h6 align="center">' . $lang['sql_output'] . '</h6><strong><div id="sqloutbox">';
if ($meldung != "") {
$s .= '<p class="success">' . $meldung . '</p>';
}
if (isset($sql['parser']['sql_commands'])) {
$s .= '' . $sql['parser']['sql_commands'] . '</strong>' . $lang['sql_commands_in'] . round($sql['parser']['time_used'], 4) . $lang['sql_commands_in2'] . '<br><br>';
$s .= $lang['sql_out1'] . '<strong>' . $sql['parser']['drop'] . '</strong> <span style="color:#990099;font-weight:bold;">DROP</span>-, ';
$s .= '<strong>' . $sql['parser']['create'] . '</strong> <span style="color:#990099;font-weight:bold;">CREATE</span>-, ';
$s .= '<strong>' . $sql['parser']['insert'] . '</strong> <span style="color:#990099;font-weight:bold;">INSERT</span>-, ';
$s .= '<strong>' . $sql['parser']['update'] . '</strong> <span style="color:#990099;font-weight:bold;">UPDATE</span>-' . $lang['sql_out2'] . '<br>';
$s .= $lang['sql_out3'] . '<strong>' . $sql['parser']['comment'] . '</strong> ' . $lang['sql_out4'] . '<br>';
if ($sql['parser']['sql_commands'] < 5000) {
$s .= '<pre>' . Highlight_SQL($sqlcommand) . '</pre></div>';
} else {
$s .= $lang['sql_out5'] . "</div>";
}
} elseif ($sqlcommand != "") {
$s .= '<h5 align="center">' . $lang['sql_output'] . '</h5><pre>' . Highlight_SQL($sqlcommand) . '</pre>';
}
return $s . '</div>';
}
function SQLOutput($sqlcommand, $meldung = '')
{
global $sql, $lang;
$s = '<h6 align="center">' . $lang['L_SQL_OUTPUT'] . '</h6><div id="sqloutbox"><strong>';
if ($meldung != '') {
$s .= $meldung;
}
if (isset($sql['parser']['sql_commands'])) {
$s .= '' . $sql['parser']['sql_commands'] . '</strong>' . $lang['L_SQL_COMMANDS_IN'] . round($sql['parser']['time_used'], 4) . $lang['L_SQL_COMMANDS_IN2'] . '<br><br>';
$s .= $lang['L_SQL_OUT1'] . '<strong>' . $sql['parser']['drop'] . '</strong> <span style="color:#990099;font-weight:bold;">DROP</span>-, ';
$s .= '<strong>' . $sql['parser']['create'] . '</strong> <span style="color:#990099;font-weight:bold;">CREATE</span>-, ';
$s .= '<strong>' . $sql['parser']['insert'] . '</strong> <span style="color:#990099;font-weight:bold;">INSERT</span>-, ';
$s .= '<strong>' . $sql['parser']['update'] . '</strong> <span style="color:#990099;font-weight:bold;">UPDATE</span>-' . $lang['L_SQL_OUT2'] . '<br>';
$s .= $lang['L_SQL_OUT3'] . '<strong>' . $sql['parser']['comment'] . '</strong> ' . $lang['L_SQL_OUT4'] . '<br>';
if ($sql['parser']['sql_commands'] < 50) {
$s .= '<pre>' . Highlight_SQL($sqlcommand) . '</pre>';
} else {
$s .= $lang['L_SQL_OUT5'];
}
} elseif ($sqlcommand != '') {
$s .= '<h5 align="center">' . $lang['L_SQL_OUTPUT'] . '</h5><pre>' . Highlight_SQL($sqlcommand) . '</pre>';
}
return $s . '</div>';
}
