#!/usr/local/bin/perl # exec.cgi # Execute some SQL command and display output require './postgresql-lib.pl'; &ReadParseMime(); &can_edit_db($in{'db'}) || &error($text{'dbase_ecannot'}); &error_setup($text{'exec_err'}); if ($in{'clear'}) { # Delete the history file &unlink_file($commands_file.".".$in{'db'}); &redirect("exec_form.cgi?db=$in{'db'}"); } else { # Run some SQL $in{'cmd'} = join(" ", split(/[\r\n]+/, $in{'cmd'})); $cmd = $in{'cmd'} ? $in{'cmd'} : $in{'old'}; $d = &execute_sql_logged($in{'db'}, $cmd); &ui_print_header(undef, $text{'exec_title'}, ""); print &text('exec_out', "".&html_escape($cmd).""),"
\n"; @data = @{$d->{'data'}}; if (@data) { print &ui_columns_start($d->{'titles'}); foreach $r (@data) { @prow = map { ref($_) eq 'ARRAY' ? join(", ", @$_) : $_ } @$r; print &ui_columns_row(\@prow); } print &ui_columns_end(); } else { print "$text{'exec_none'}
\n";
}
# Add to the old commands file
open(OLD, "$commands_file.$in{'db'}");
while(