get_username($userId) . " updated the `{$table}` table: {$changeString} where {$wherePart} on {$timestamp}."; } // Parse INSERT if (preg_match('/INSERT\s+INTO\s+`?(\w+)`?\s*\((.*?)\)\s*VALUES\s*\((.*?)\)/i', $sql, $matches)) { $table = $matches[1]; $columns = array_map('trim', explode(',', $matches[2])); $values = array_map('trim', explode(',', $matches[3])); $pairs = []; foreach ($columns as $i => $col) { $pairs[] = "{$col} = {$values[$i]}"; } $pairString = implode('; ', $pairs); return "User " . $call->get_username($userId) . " inserted into `{$table}`: {$pairString} on {$timestamp}."; } // Parse DELETE if (preg_match('/DELETE\s+FROM\s+`?(\w+)`?\s+WHERE\s+(.*)/i', $sql, $matches)) { $table = $matches[1]; $where = $matches[2]; return "User " . $call->get_username($userId) . " deleted from `{$table}` where {$where} on {$timestamp}."; } return "User " . $call->get_username($userId) . " ran an unrecognized query on {$timestamp}."; } $res = $db->query("logs", "SELECT * FROM `logs` ORDER BY record_id DESC"); echo ' '; echo ''; while ($row = $res->fetch_assoc()) { echo ''; echo ''; echo ''; } echo '

Query Interpretation
' . htmlspecialchars(interpret_sql_log($row['query'], $row['user_id'], $row['date_time'])) . '

';