if (Query_Type($myrow[2]) == "UPDATE") {
UpdateQueryInfo(str_replace("UPDATE", '', $myrow[2]));
$RowColour = '#feff90';
}
if (Query_Type($myrow[2]) == "DELETE") {
DeleteQueryInfo(str_replace("DELETE FROM", '', $myrow[2]));
$RowColour = '#fe90bf';
}
if (trim($_SESSION['SQLString']['table']) == $_POST['SelectedTable'] || $_POST['SelectedTable'] == 'ALL') {
if (!isset($_SESSION['SQLString']['values'])) {
$_SESSION['SQLString']['values'][0] = '';
}
echo '<tr style="background-color: ' . $RowColour . '">
<td>' . $myrow[0] . '</td>
<td>' . $myrow[1] . '</td>
<td>' . Query_Type($myrow[2]) . '</td>
<td>' . $_SESSION['SQLString']['table'] . '</td>
<td>' . $_SESSION['SQLString']['fields'][0] . '</td>
<td>' . trim(str_replace("'", "", $_SESSION['SQLString']['values'][0])) . '</td></tr>';
for ($i = 1; $i < sizeof($_SESSION['SQLString']['fields']); $i++) {
if (isset($_SESSION['SQLString']['values'][$i]) and trim(str_replace("'", "", $_SESSION['SQLString']['values'][$i])) != "" & trim($_SESSION['SQLString']['fields'][$i]) != 'password' & trim($_SESSION['SQLString']['fields'][$i]) != 'www_users.password') {
echo '<tr style="background-color:' . $RowColour . '">';
echo '<td></td>
<td></td>
<td></td>
<td></td>';
echo '<td>' . $_SESSION['SQLString']['fields'][$i] . '</td>
<td>' . trim(str_replace("'", "", $_SESSION['SQLString']['values'][$i])) . '</td>';
echo '</tr>';
}
}
if (Query_Type($myrow[2]) == 'UPDATE') {
UpdateQueryInfo(str_replace('UPDATE', '', $myrow[2]));
$RowColour = '#feff90';
}
if (Query_Type($myrow[2]) == 'DELETE') {
DeleteQueryInfo(str_replace('DELETE FROM', '', $myrow[2]));
$RowColour = '#fe90bf';
}
if (trim($_SESSION['SQLString']['table']) == $_POST['SelectedTable'] || $_POST['SelectedTable'] == 'ALL') {
if (!isset($_SESSION['SQLString']['values'])) {
$_SESSION['SQLString']['values'][0] = '';
}
echo '<TR style="background-color: ' . $RowColour . '">
<TD>' . $myrow[0] . '</TD>
<TD>' . $myrow[1] . '</TD>
<TD>' . Query_Type($myrow[2]) . '</TD>
<TD>' . $_SESSION['SQLString']['table'] . '</TD>
<TD>' . $_SESSION['SQLString']['fields'][0] . '</TD>
<TD>' . htmlentities(trim(str_replace("'", "", $_SESSION['SQLString']['values'][0]))) . '</TD></TR>';
for ($i = 1; $i < sizeof($_SESSION['SQLString']['fields']); $i++) {
if (isset($_SESSION['SQLString']['values'][$i]) and trim(str_replace("'", "", $_SESSION['SQLString']['values'][$i])) != "" & trim($_SESSION['SQLString']['fields'][$i]) != 'password' & trim($_SESSION['SQLString']['fields'][$i]) != "www_users.password") {
echo '<TR bgcolor=' . $RowColour . '>';
echo '<TD></TD>
<TD></TD>
<TD></TD>
<TD></TD>';
echo '<TD>' . $_SESSION['SQLString']['fields'][$i] . '</TD>
<TD>' . htmlentities(trim(str_replace("'", "", $_SESSION['SQLString']['values'][$i])), ENT_QUOTES, _('ISO-8859-1')) . '</TD>';
echo '</TR>';
}
}
