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>'; } }