Gecko [ contributie.vriendennsm.nl ]

Name	Size	Permission	Date
help	[ DIR ]	drwxr-xr-x	2026-07-25 20:55
images	[ DIR ]	drwxr-xr-x	2026-07-25 20:55
lang	[ DIR ]	drwxr-xr-x	2026-07-25 20:55
ulang	[ DIR ]	drwxr-xr-x	2026-07-25 20:55
CHANGELOG	1.42 KB	-rw-r--r--	2026-07-19 16:26
backup_db.cgi	8.07 KB	-rwxr-xr-x	2026-07-19 16:28
backup_form.cgi	6.84 KB	-rwxr-xr-x	2026-07-19 16:28
config	522 B	-rw-r--r--	2026-07-19 16:26
config-AlmaLinux-7.0-ALL	418 B	-rw-r--r--	2026-07-19 16:26
config-Amazon-Linux-2-ALL	403 B	-rw-r--r--	2026-07-19 16:26
config-CentOS-Linux-7.0-ALL	418 B	-rw-r--r--	2026-07-19 16:26
config-CentOS-Stream-Linux-8.0-ALL	418 B	-rw-r--r--	2026-07-19 16:26
config-CloudLinux-8.0-ALL	418 B	-rw-r--r--	2026-07-19 16:26
config-Oracle-Linux-8.0-ALL	418 B	-rw-r--r--	2026-07-19 16:26
config-Redhat-Enterprise-Linux-7.0-ALL	418 B	-rw-r--r--	2026-07-19 16:26
config-Rocky-Linux-7.0-ALL	418 B	-rw-r--r--	2026-07-19 16:26
config-Scientific-Linux-7.0-ALL	403 B	-rw-r--r--	2026-07-19 16:26
config-Ubuntu-Linux-16.04-17.99	453 B	-rw-r--r--	2026-07-19 16:26
config-aix	479 B	-rw-r--r--	2026-07-19 16:26
config-cobalt-linux	417 B	-rw-r--r--	2026-07-19 16:26
config-coherent-linux	419 B	-rw-r--r--	2026-07-19 16:26
config-debian-linux	416 B	-rw-r--r--	2026-07-19 16:26
config-debian-linux-10.0-12.0	420 B	-rw-r--r--	2026-07-19 16:26
config-debian-linux-13.0-ALL	437 B	-rw-r--r--	2026-07-19 16:26
config-debian-linux-2.2-9.0	436 B	-rw-r--r--	2026-07-19 16:26
config-freebsd	479 B	-rw-r--r--	2026-07-19 16:26
config-freebsd-8-ALL	516 B	-rw-r--r--	2026-07-19 16:26
config-gentoo-linux	413 B	-rw-r--r--	2026-07-19 16:26
config-mandrake-linux	399 B	-rw-r--r--	2026-07-19 16:26
config-mandrake-linux-10.1-ALL	401 B	-rw-r--r--	2026-07-19 16:26
config-msc-linux	421 B	-rw-r--r--	2026-07-19 16:26
config-netbsd	431 B	-rw-r--r--	2026-07-19 16:26
config-open-linux	417 B	-rw-r--r--	2026-07-19 16:26
config-openSUSE-Linux-15.0-ALL	403 B	-rw-r--r--	2026-07-19 16:26
config-pardus-linux	346 B	-rw-r--r--	2026-07-19 16:26
config-qnx	333 B	-rw-r--r--	2026-07-19 16:26
config-redhat-linux	417 B	-rw-r--r--	2026-07-19 16:26
config-redhat-linux-24.0	421 B	-rw-r--r--	2026-07-19 16:26
config-redhat-linux-25.0-ALL	418 B	-rw-r--r--	2026-07-19 16:26
config-redhat-linux-7.0-23.0	419 B	-rw-r--r--	2026-07-19 16:26
config-slackware-linux-8.0-ALL	449 B	-rw-r--r--	2026-07-19 16:26
config-sol-linux	455 B	-rw-r--r--	2026-07-19 16:26
config-solaris-10	440 B	-rw-r--r--	2026-07-19 16:26
config-solaris-11-ALL	490 B	-rw-r--r--	2026-07-19 16:26
config-solaris-9	498 B	-rw-r--r--	2026-07-19 16:26
config-suse-linux	409 B	-rw-r--r--	2026-07-19 16:26
config-suse-linux-7.1-ALL	407 B	-rw-r--r--	2026-07-19 16:26
config-syno-linux	528 B	-rwxr-xr-x	2026-07-19 16:26
config-trustix-linux	407 B	-rw-r--r--	2026-07-19 16:26
config-turbo-linux	417 B	-rw-r--r--	2026-07-19 16:26
config-united-linux	407 B	-rw-r--r--	2026-07-19 16:26
config.info	589 B	-rw-r--r--	2026-07-19 16:26
config.info.ca	714 B	-rwxr-xr-x	2026-07-19 16:26
config.info.nl	664 B	-rwxr-xr-x	2026-07-19 16:26
config.info.no	635 B	-rw-r--r--	2026-07-19 16:26
create_table.cgi	1.02 KB	-rwxr-xr-x	2026-07-19 16:28
csv.cgi	2.26 KB	-rwxr-xr-x	2026-07-19 16:28
csv_form.cgi	1.67 KB	-rwxr-xr-x	2026-07-19 16:28
defaultuconfig	53 B	-rw-r--r--	2026-07-19 16:26
delete_fields.cgi	665 B	-rwxr-xr-x	2026-07-19 16:28
download.cgi	1.07 KB	-rwxr-xr-x	2026-07-19 16:28
drop_table.cgi	1.27 KB	-rwxr-xr-x	2026-07-19 16:28
drop_tables.cgi	1.75 KB	-rwxr-xr-x	2026-07-19 16:28
edit_dbase.cgi	6.91 KB	-rwxr-xr-x	2026-07-19 16:28
edit_field.cgi	4.99 KB	-rwxr-xr-x	2026-07-19 16:28
edit_index.cgi	1.83 KB	-rwxr-xr-x	2026-07-19 16:28
edit_table.cgi	2.85 KB	-rwxr-xr-x	2026-07-19 16:28
edit_view.cgi	2.17 KB	-rwxr-xr-x	2026-07-19 16:28
exec.cgi	7.59 KB	-rwxr-xr-x	2026-07-19 16:28
exec_file.cgi	3.01 KB	-rwxr-xr-x	2026-07-19 16:28
exec_form.cgi	3.88 KB	-rwxr-xr-x	2026-07-19 16:28
import.cgi	2.25 KB	-rwxr-xr-x	2026-07-19 16:28
index.cgi	2.85 KB	-rwxr-xr-x	2026-07-19 16:28
login.cgi	514 B	-rwxr-xr-x	2026-07-19 16:28
module.info	192 B	-rw-r--r--	2026-07-19 16:26
module.info.ar	0 B	-rw-r--r--	2026-07-19 16:26
module.info.ar.auto	234 B	-rw-r--r--	2026-07-19 16:26
module.info.bg	0 B	-rw-r--r--	2026-07-19 16:26
module.info.bg.auto	222 B	-rw-r--r--	2026-07-19 16:26
module.info.ca	28 B	-rw-r--r--	2026-07-19 16:26
module.info.ca.auto	147 B	-rw-r--r--	2026-07-19 16:26
module.info.cs	24 B	-rw-r--r--	2026-07-19 16:26
module.info.cs.auto	129 B	-rw-r--r--	2026-07-19 16:26
module.info.da	0 B	-rw-r--r--	2026-07-19 16:26
module.info.da.auto	157 B	-rw-r--r--	2026-07-19 16:26
module.info.de	127 B	-rw-r--r--	2026-07-19 16:26
module.info.el	0 B	-rw-r--r--	2026-07-19 16:26
module.info.el.auto	277 B	-rw-r--r--	2026-07-19 16:26
module.info.es	0 B	-rw-r--r--	2026-07-19 16:26
module.info.es.auto	172 B	-rw-r--r--	2026-07-19 16:26
module.info.eu	0 B	-rw-r--r--	2026-07-19 16:26
module.info.eu.auto	160 B	-rw-r--r--	2026-07-19 16:26
module.info.fa	0 B	-rw-r--r--	2026-07-19 16:26
module.info.fa.auto	200 B	-rw-r--r--	2026-07-19 16:26
module.info.fi	0 B	-rw-r--r--	2026-07-19 16:26
module.info.fi.auto	170 B	-rw-r--r--	2026-07-19 16:26
module.info.fr	43 B	-rw-r--r--	2026-07-19 16:26
module.info.hr	0 B	-rw-r--r--	2026-07-19 16:26
module.info.hr.auto	158 B	-rw-r--r--	2026-07-19 16:26
module.info.hu	35 B	-rw-r--r--	2026-07-19 16:26
module.info.hu.auto	153 B	-rw-r--r--	2026-07-19 16:26
module.info.it	0 B	-rw-r--r--	2026-07-19 16:26
module.info.it.auto	149 B	-rw-r--r--	2026-07-19 16:26
module.info.ja	0 B	-rw-r--r--	2026-07-19 16:26
module.info.ja.auto	210 B	-rw-r--r--	2026-07-19 16:26
module.info.ko	0 B	-rw-r--r--	2026-07-19 16:26
module.info.ko.auto	192 B	-rw-r--r--	2026-07-19 16:26
module.info.ms	0 B	-rw-r--r--	2026-07-19 16:26
module.info.ms.auto	158 B	-rw-r--r--	2026-07-19 16:26
module.info.nl	30 B	-rw-r--r--	2026-07-19 16:26
module.info.no	23 B	-rw-r--r--	2026-07-19 16:26
module.info.no.auto	134 B	-rw-r--r--	2026-07-19 16:26
module.info.pl	0 B	-rw-r--r--	2026-07-19 16:26
module.info.pl.auto	160 B	-rw-r--r--	2026-07-19 16:26
module.info.pt	0 B	-rw-r--r--	2026-07-19 16:26
module.info.pt.auto	166 B	-rw-r--r--	2026-07-19 16:26
module.info.pt_BR	0 B	-rw-r--r--	2026-07-19 16:26
module.info.pt_BR.auto	175 B	-rw-r--r--	2026-07-19 16:26
module.info.ru	0 B	-rw-r--r--	2026-07-19 16:26
module.info.ru.auto	224 B	-rw-r--r--	2026-07-19 16:26
module.info.sk	0 B	-rw-r--r--	2026-07-19 16:26
module.info.sk.auto	155 B	-rw-r--r--	2026-07-19 16:26
module.info.sv	0 B	-rw-r--r--	2026-07-19 16:26
module.info.sv.auto	153 B	-rw-r--r--	2026-07-19 16:26
module.info.tr	0 B	-rw-r--r--	2026-07-19 16:26
module.info.tr.auto	170 B	-rw-r--r--	2026-07-19 16:26
module.info.uk	0 B	-rw-r--r--	2026-07-19 16:26
module.info.uk.auto	228 B	-rw-r--r--	2026-07-19 16:26
module.info.zh	0 B	-rw-r--r--	2026-07-19 16:26
module.info.zh.auto	135 B	-rw-r--r--	2026-07-19 16:26
module.info.zh_TW	0 B	-rw-r--r--	2026-07-19 16:26
module.info.zh_TW.auto	144 B	-rw-r--r--	2026-07-19 16:26
mysql-lib.pl	62.1 KB	-rwxr-xr-x	2026-07-19 16:26
save_field.cgi	4.72 KB	-rwxr-xr-x	2026-07-19 16:28
save_index.cgi	1.39 KB	-rwxr-xr-x	2026-07-19 16:28
save_view.cgi	1.84 KB	-rwxr-xr-x	2026-07-19 16:28
search_form.cgi	1.38 KB	-rwxr-xr-x	2026-07-19 16:28
table_form.cgi	1.95 KB	-rwxr-xr-x	2026-07-19 16:28
uconfig.info	373 B	-rw-r--r--	2026-07-19 16:26
uconfig.info.ca	114 B	-rwxr-xr-x	2026-07-19 16:26
uconfig.info.cs	432 B	-rw-r--r--	2026-07-19 16:26
uconfig.info.de	432 B	-rw-r--r--	2026-07-19 16:26
uconfig.info.nl	413 B	-rw-r--r--	2026-07-19 16:26
uconfig.info.no	388 B	-rw-r--r--	2026-07-19 16:26
view-lib.pl	3.56 KB	-rwxr-xr-x	2026-07-19 16:26
view_table.cgi	15.16 KB	-rwxr-xr-x	2026-07-19 16:28

Rename

#!/usr/bin/perl
# exec.cgi
# Execute some SQL command and display output

require './mysql-lib.pl';
&ReadParseMime();
&can_edit_db($in{'db'}) || &error($text{'dbase_ecannot'});
$access{'edonly'} && &error($text{'dbase_ecannot'});
&error_setup($text{'exec_err'});
$sql_charset = $in{'charset'};

# normalize_sql_for_history(command)
# Collapse textarea SQL into a single history line.
sub normalize_sql_for_history
{
my ($cmd) = @_;
$cmd =~ s/\r//g;
return join(" ", split(/\n+/, $cmd));
}

# count_sql_terminators(sql)
# Count semicolons in SQL text, skipping those inside single/double/backtick
# quotes, line comments (# and --), and block comments (/* ... */). Used to
# detect multi-statement input. Miscounts should not happen in practice but are
# safe either way: on undercount, multi-statement SQL goes through the
# single-statement path and fails visibly; on overcount, a single statement goes
# through the file executor which handles it fine.
sub count_sql_terminators
{
my ($sql) = @_;
my $count = 0;
my ($sq, $dq, $bq, $line_comment, $block_comment, $escaped);
for (my $i = 0; $i < length($sql); $i++) {
	my $c = substr($sql, $i, 1);
	my $n = $i+1 < length($sql) ? substr($sql, $i+1, 1) : '';
	if ($line_comment) {
		$line_comment = 0 if ($c eq "\n");
		next;
		}
	if ($block_comment) {
		if ($c eq '*' && $n eq '/') {
			$block_comment = 0;
			$i++;
			}
		next;
		}
	if ($sq) {
		if ($c eq "\\" && !$escaped) {
			$escaped = 1;
			next;
			}
		$sq = 0 if ($c eq "'" && !$escaped);
		$escaped = 0;
		next;
		}
	if ($dq) {
		if ($c eq "\\" && !$escaped) {
			$escaped = 1;
			next;
			}
		$dq = 0 if ($c eq '"' && !$escaped);
		$escaped = 0;
		next;
		}
	if ($bq) {
		$bq = 0 if ($c eq '`');
		next;
		}
	if ($c eq '#' ) {
		$line_comment = 1;
		next;
		}
	if ($c eq '-' && $n eq '-') {
		my $p = $i ? substr($sql, $i-1, 1) : '';
		my $a = $i+2 < length($sql) ? substr($sql, $i+2, 1) : '';
		if (($i == 0 || $p =~ /\s/) && ($a eq '' || $a =~ /\s/)) {
			$line_comment = 1;
			$i++;
			next;
			}
		}
	if ($c eq '/' && $n eq '*') {
		$block_comment = 1;
		$i++;
		next;
		}
	if ($c eq "'") {
		$sq = 1;
		$escaped = 0;
		next;
		}
	if ($c eq '"') {
		$dq = 1;
		$escaped = 0;
		next;
		}
	if ($c eq '`') {
		$bq = 1;
		next;
		}
	if ($c eq ';') {
		$count++;
		}
	}
return $count;
}

# looks_like_sql_script(command)
# Detect pasted SQL that should use the file-style script executor.
sub looks_like_sql_script
{
my ($cmd) = @_;
return 1 if ($cmd =~ /^\s*(?:delimiter|source|\\\.)\b/im);
return 1 if ($cmd =~ /^\s*(?:--(?:\s|$)|#)/m);
return &count_sql_terminators($cmd) > 1;
}

# execute_textarea_script(database, command)
# Run pasted SQL through the same path used for uploaded script files.
sub execute_textarea_script
{
my ($db, $cmd) = @_;
my $file = &transname();
&open_tempfile(TEMP, ">$file");
&print_tempfile(TEMP, $cmd);
&print_tempfile(TEMP, "\n") if ($cmd !~ /\n\z/);
&close_tempfile(TEMP);
my @rv = &execute_sql_file($db, $file, undef, undef, $access{'buser'});
&unlink_file($file);
return @rv;
}

# summarize_sql_script(sql)
# Count common DDL and DML actions for friendly success messages.
sub summarize_sql_script
{
my ($sql) = @_;
my %rv = ( 'create_count' => 0,
	   'insert_count' => 0 );
foreach my $line (split(/\n/, $sql)) {
	if ($line =~ /^\s*insert\s+into\s+`(\S+)`/i ||
	    $line =~ /^\s*insert\s+into\s+(\S+)/i) {
		$rv{'insert_count'}++;
		}
	if ($line =~ /^\s*create\s+table\s+`(\S+)`/i ||
	    $line =~ /^\s*create\s+table\s+(\S+)/i) {
		$rv{'create_count'}++;
		}
	}
return \%rv;
}

# extract_execute_error_text(error)
# Strip Webmin's wrapper text down to the database error itself.
sub extract_execute_error_text
{
my ($err) = @_;
$err =~ s/\s+at\s+\S+\s+line\s+\d+.*$//s;
if ($err =~ /failed\s*:\s*<tt>(.*?)<\/tt>\s*$/s) {
	$err = $1;
	}
elsif ($err =~ /failed\s*:\s*"([^"]+)"\s*$/s) {
	$err = $1;
	}
elsif ($err =~ /failed\s*:\s*(.*?)\s*$/s) {
	$err = $1;
	}
$err =~ s/<[^>]+>//g;
# Normalize to plain text: undo any HTML escaping from shared helpers
# so the caller can re-escape once at final display time.
$err = &html_unescape($err);
return $err;
}

# print_exec_status_lines(first, rest...)
# Print one or more status lines with predictable wrapper spans.
sub print_exec_status_lines
{
my ($first, @rest) = @_;
print &ui_tag('span', $first, { 'data-first-print' => undef });
if (@rest) {
	print &ui_tag('br');
	for (my $i = 0; $i < @rest; $i++) {
		print &ui_tag('span', $rest[$i],
			      { 'data-second-print' => undef });
		print &ui_tag('br') if ($i+1 < @rest);
		}
	}
}

# print_exec_error_block(first, second, detail)
# Print a wrapped error block with a preformatted message body.
sub print_exec_error_block
{
my ($first, $second, $detail) = @_;
$detail = defined($detail) && $detail =~ /\S/ ? $detail : $text{'exec_noout'};
&print_exec_status_lines($first, $second);
print &ui_tag('br');
print &ui_tag('pre', &html_escape($detail),
	      { 'style' => 'white-space: pre-wrap; margin-left: 10px;' });
}

if ($in{'clear'}) {
	# Delete the history file
	&unlink_file($commands_file.".".$in{'db'});
	&redirect("exec_form.cgi?db=$in{'db'}");
	}
else {
	# Run some SQL
	$rawcmd = defined($in{'cmd'}) ? $in{'cmd'} : undef;
	defined($rawcmd) && $rawcmd =~ /\S/ || &error($text{'exec_ecmd'});
	$rawcmd =~ s/\r//g;
	$cmd = &normalize_sql_for_history($rawcmd);
	# Multi-statement input uses the same executor as uploaded SQL files.
	$script = &looks_like_sql_script($rawcmd);

if ($script) {
		($ex, $out) = &execute_textarea_script($in{'db'}, $rawcmd);
		$summary = &summarize_sql_script($rawcmd);

&ui_print_header(undef, $text{'exec_title'}, "");
		if ($ex) {
			&print_exec_error_block($text{'exec_scriptout'},
						$text{'exec_scriptfailed'},
						$out);
			}
		else {
			@lines = ( );
			if ($summary->{'create_count'}) {
				push(@lines, &text('exec_scriptcreated',
						   $summary->{'create_count'}));
				}
			if ($summary->{'insert_count'}) {
				push(@lines, &text('exec_scriptinserted',
						   $summary->{'insert_count'}));
				}
			if (!@lines) {
				push(@lines, $text{'exec_scriptok'});
				}
			&print_exec_status_lines($text{'exec_scriptout'},
						 @lines);
			print "<p>\n";
			}
		}
	else {
		eval {
			local $main::error_must_die = 1;
			# Capture DBI/mysql errors so we can render them consistently.
			$d = &execute_sql_logged($in{'db'}, $cmd);
			};
		if ($@) {
			$failed = 1;
			$err = &extract_execute_error_text($@);
			&ui_print_header(undef, $text{'exec_title'}, "");
			&print_exec_error_block($text{'exec_cmdout'},
						$text{'exec_cmdfailed'}, $err);
			}
		else {
			@data = @{$d->{'data'}};

&ui_print_header(undef, $text{'exec_title'}, "");
			if (@data) {
				print &text('exec_out',
				    "<tt>".&html_escape($cmd)."</tt>"),"<p>\n";
				print &ui_columns_start($d->{'titles'});
				foreach $r (@data) {
					print &ui_columns_row([
						map { &html_escape($_) } @$r ]);
					}
				print &ui_columns_end();
				}
			else {
				&print_exec_status_lines($text{'exec_cmdout'},
							 $text{'exec_cmdok'});
				print "<p>\n";
				}
			}
		}

&open_readfile(OLD, "$commands_file.$in{'db'}");
	while(<OLD>) {
		s/\r|\n//g;
		$already++ if ($_ eq $cmd);
		}
	close(OLD);
	# Only store successful single commands in history. Script runs are
	# intentionally left out to avoid flattening multi-line SQL for re-use.
	if (!$script && !$failed && !$already && $cmd =~ /\S/) {
		&open_lock_tempfile(OLD, ">>$commands_file.$in{'db'}");
		&print_tempfile(OLD, "$cmd\n");
		&close_tempfile(OLD);
		chmod(0700, "$commands_file.$in{'db'}");
		}
	&webmin_log("exec", undef, $in{'db'}, \%in);

&ui_print_footer("exec_form.cgi?db=$in{'db'}", $text{'exec_return'},
		"edit_dbase.cgi?db=$in{'db'}", $text{'dbase_return'},
		&get_databases_return_link($in{'db'}), $text{'index_return'});
	}