Exemplo n.º 1
0
    }
    $result = DB_query($sql, $db);
    echo '<table border="0" width="98%" class="selection">';
    echo '<tr><th>' . _('Date/Time') . '</th>
				<th>' . _('User') . '</th>
				<th>' . _('Type') . '</th>
				<th>' . _('Table') . '</th>
				<th>' . _('Field Name') . '</th>
				<th>' . _('Value') . '</th></tr>';
    while ($myrow = DB_fetch_row($result)) {
        if (Query_Type($myrow[2]) == "INSERT") {
            InsertQueryInfo(str_replace("INSERT INTO", '', $myrow[2]));
            $RowColour = '#a8ff90';
        }
        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>
Exemplo n.º 2
0
    }
    $result = DB_query($sql, $db);
    echo '<TABLE BORDER=0 width="100%">';
    echo '<TR><TH>' . _('Date/Time') . '</TH>
				<TH>' . _('User') . '</TH>
				<TH>' . _('Type') . '</TH>
				<TH>' . _('Table') . '</TH>
				<TH>' . _('Field Name') . '</TH>
				<TH>' . _('Value') . '</TH></TR>';
    while ($myrow = DB_fetch_row($result)) {
        if (Query_Type($myrow[2]) == 'INSERT') {
            InsertQueryInfo(str_replace("INSERT INTO", '', $myrow[2]));
            $RowColour = '#a8ff90';
        }
        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>