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.25 KB	-rw-r--r--	2026-07-19 16:26
acl_security.pl	2.82 KB	-rwxr-xr-x	2026-07-19 16:26
backup.cgi	5.2 KB	-rwxr-xr-x	2026-07-19 16:28
backup_form.cgi	4.74 KB	-rwxr-xr-x	2026-07-19 16:28
config	501 B	-rw-r--r--	2026-07-19 16:26
config-AlmaLinux-7.0-ALL	530 B	-rw-r--r--	2026-07-19 16:26
config-Amazon-Linux-2-ALL	484 B	-rw-r--r--	2026-07-19 16:26
config-CentOS-Linux-7.0-ALL	530 B	-rw-r--r--	2026-07-19 16:26
config-CentOS-Stream-Linux-8.0-ALL	530 B	-rw-r--r--	2026-07-19 16:26
config-CloudLinux-8.0-ALL	530 B	-rw-r--r--	2026-07-19 16:26
config-Oracle-Linux-8.0-ALL	530 B	-rw-r--r--	2026-07-19 16:26
config-Redhat-Enterprise-Linux-7.0-ALL	484 B	-rw-r--r--	2026-07-19 16:26
config-Rocky-Linux-7.0-ALL	530 B	-rw-r--r--	2026-07-19 16:26
config-Scientific-Linux-7.0-ALL	484 B	-rw-r--r--	2026-07-19 16:26
config-cobalt-linux	435 B	-rw-r--r--	2026-07-19 16:26
config-coherent-linux	507 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-ALL	417 B	-rw-r--r--	2026-07-19 16:26
config-debian-linux-4.0-9.0	425 B	-rw-r--r--	2026-07-19 16:26
config-freebsd	588 B	-rw-r--r--	2026-07-19 16:26
config-freebsd-8-ALL	580 B	-rw-r--r--	2026-07-19 16:26
config-gentoo-linux	429 B	-rw-r--r--	2026-07-19 16:26
config-mandrake-linux	435 B	-rw-r--r--	2026-07-19 16:26
config-msc-linux	441 B	-rw-r--r--	2026-07-19 16:26
config-netbsd	454 B	-rw-r--r--	2026-07-19 16:26
config-openSUSE-Linux-15.0-ALL	453 B	-rw-r--r--	2026-07-19 16:26
config-pardus-linux	431 B	-rw-r--r--	2026-07-19 16:26
config-redhat-linux	444 B	-rw-r--r--	2026-07-19 16:26
config-redhat-linux-10.0-23.0	772 B	-rw-r--r--	2026-07-19 16:26
config-redhat-linux-24.0-ALL	500 B	-rw-r--r--	2026-07-19 16:26
config-redhat-linux-7.0-7.2	493 B	-rw-r--r--	2026-07-19 16:26
config-redhat-linux-7.3	507 B	-rw-r--r--	2026-07-19 16:26
config-redhat-linux-7.4-9.0	507 B	-rw-r--r--	2026-07-19 16:26
config-sol-linux	462 B	-rw-r--r--	2026-07-19 16:26
config-suse-linux	448 B	-rw-r--r--	2026-07-19 16:26
config-suse-linux-7.0	457 B	-rw-r--r--	2026-07-19 16:26
config-suse-linux-7.1-9.0	459 B	-rw-r--r--	2026-07-19 16:26
config-suse-linux-9.1-ALL	459 B	-rw-r--r--	2026-07-19 16:26
config-syno-linux	454 B	-rw-r--r--	2026-07-19 16:26
config-trustix-linux	619 B	-rw-r--r--	2026-07-19 16:26
config-united-linux	459 B	-rw-r--r--	2026-07-19 16:26
config.info	518 B	-rw-r--r--	2026-07-19 16:26
config.info.ca	1.68 KB	-rw-r--r--	2026-07-19 16:26
config.info.de	391 B	-rw-r--r--	2026-07-19 16:26
config.info.es	559 B	-rw-r--r--	2026-07-19 16:26
config.info.ja	1.68 KB	-rw-r--r--	2026-07-19 16:26
config.info.nl	604 B	-rwxr-xr-x	2026-07-19 16:26
config.info.no	562 B	-rw-r--r--	2026-07-19 16:26
config.info.pl	521 B	-rw-r--r--	2026-07-19 16:26
config.info.ru	950 B	-rw-r--r--	2026-07-19 16:26
config.info.sv	459 B	-rw-r--r--	2026-07-19 16:26
config.info.zh	328 B	-rw-r--r--	2026-07-19 16:26
config.info.zh_TW	426 B	-rw-r--r--	2026-07-19 16:26
create_table.cgi	1.18 KB	-rwxr-xr-x	2026-07-19 16:28
csv.cgi	2 KB	-rwxr-xr-x	2026-07-19 16:28
csv_form.cgi	1.68 KB	-rwxr-xr-x	2026-07-19 16:28
defaultacl	99 B	-rw-r--r--	2026-07-19 16:26
defaultuconfig	53 B	-rw-r--r--	2026-07-19 16:26
delete_fields.cgi	629 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.1 KB	-rwxr-xr-x	2026-07-19 16:28
drop_tables.cgi	1.72 KB	-rwxr-xr-x	2026-07-19 16:28
edit_dbase.cgi	7.63 KB	-rwxr-xr-x	2026-07-19 16:28
edit_field.cgi	2.42 KB	-rwxr-xr-x	2026-07-19 16:28
edit_table.cgi	2.71 KB	-rwxr-xr-x	2026-07-19 16:28
exec.cgi	1.51 KB	-rwxr-xr-x	2026-07-19 16:28
exec_file.cgi	2.05 KB	-rwxr-xr-x	2026-07-19 16:28
exec_form.cgi	3.15 KB	-rwxr-xr-x	2026-07-19 16:28
index.cgi	3.06 KB	-rwxr-xr-x	2026-07-19 16:28
log_parser.pl	2.41 KB	-rwxr-xr-x	2026-07-19 16:26
login.cgi	454 B	-rwxr-xr-x	2026-07-19 16:28
module.info	212 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	246 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	242 B	-rw-r--r--	2026-07-19 16:26
module.info.ca	33 B	-rw-r--r--	2026-07-19 16:26
module.info.ca.auto	162 B	-rw-r--r--	2026-07-19 16:26
module.info.cs	0 B	-rw-r--r--	2026-07-19 16:26
module.info.cs.auto	175 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	177 B	-rw-r--r--	2026-07-19 16:26
module.info.de	131 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	297 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	192 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	180 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	220 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	199 B	-rw-r--r--	2026-07-19 16:26
module.info.fr	48 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	178 B	-rw-r--r--	2026-07-19 16:26
module.info.hu	41 B	-rw-r--r--	2026-07-19 16:26
module.info.hu.auto	168 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	169 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	230 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	212 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	178 B	-rw-r--r--	2026-07-19 16:26
module.info.nl	35 B	-rw-r--r--	2026-07-19 16:26
module.info.no	28 B	-rw-r--r--	2026-07-19 16:26
module.info.no.auto	149 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	180 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	186 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	195 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	244 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	171 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	173 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	190 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	248 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	155 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	164 B	-rw-r--r--	2026-07-19 16:26
postgresql-lib.pl	35.88 KB	-rwxr-xr-x	2026-07-19 16:26
restore.cgi	1.99 KB	-rwxr-xr-x	2026-07-19 16:28
restore_form.cgi	1.42 KB	-rwxr-xr-x	2026-07-19 16:28
save_field.cgi	1.05 KB	-rwxr-xr-x	2026-07-19 16:28
table_form.cgi	1.9 KB	-rwxr-xr-x	2026-07-19 16:28
uconfig.info	344 B	-rw-r--r--	2026-07-19 16:26
uconfig.info.ca	124 B	-rw-r--r--	2026-07-19 16:26
uconfig.info.de	401 B	-rw-r--r--	2026-07-19 16:26
uconfig.info.nl	346 B	-rw-r--r--	2026-07-19 16:26
uconfig.info.no	357 B	-rw-r--r--	2026-07-19 16:26
useradmin_update.pl	2.1 KB	-rwxr-xr-x	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
# edit_dbase.cgi
# Show database tables

require './postgresql-lib.pl';
&ReadParse();
&can_edit_db($in{'db'}) || &error($text{'dbase_ecannot'});
@titles = grep { &can_edit_db($_) } &list_databases();
$desc = "<tt>$in{'db'}</tt>";
if (@titles == 1 && $module_info{'usermin'}) {
	# Single-database mode
	&ui_print_header($desc, $text{'dbase_title'}, "", "edit_dbase", 1, 1);
	$single = 1;
	}
else {
	&ui_print_header($desc, $text{'dbase_title'}, "", "edit_dbase");
	}

# Is this database accepting connections?
if (!&accepting_connections($in{'db'})) {
	print "$text{'dbase_noconn'}\n";
	&ui_print_footer("", $text{'index_return'});
	exit;
	}

@titles = &list_tables($in{'db'});
if (&supports_indexes() && $access{'indexes'}) {
	@indexes = &list_indexes($in{'db'});
	}
if (&supports_views() && $access{'views'}) {
	@views = &list_views($in{'db'});
	}
if (&supports_sequences() && $access{'seqs'}) {
	@seqs = &list_sequences($in{'db'});
	}

if ($in{'search'}) {
	# Limit to those matching search
	@titles = grep { /\Q$in{'search'}\E/i } @titles;
	@indexes = grep { /\Q$in{'search'}\E/i } @indexes;
	@views = grep { /\Q$in{'search'}\E/i } @views;
	@seqs = grep { /\Q$in{'search'}\E/i } @seqs;
	print "<table width=100%><tr>\n";
	print "<td> ",&text('dbase_showing',
		"<tt>$in{'search'}</tt>"),"</td>\n";
	print "<td align=right><a href='edit_dbase.cgi?db=$in{'db'}'>",
		"$text{'view_searchreset'}</a></td>\n";
	print "</tr></table>\n";
	}

if (@titles+@indexes+@views+@seqs > $max_dbs && !$in{'search'}) {
	# Too many tables to show .. display search and jump forms
	print &ui_form_start("edit_dbase.cgi");
	print &ui_hidden("db", $in{'db'}),"\n";
	print $text{'dbase_toomany'},"\n";
	print &ui_textbox("search", undef, 20),"\n";
	print &ui_submit($text{'index_search'})," \n";
	print &ui_form_end();

# Table selector
	print &ui_form_start("edit_table.cgi");
	print $text{'dbase_jump'},"\n";
	print &ui_hidden("db", $in{'db'}),"\n";
	print &ui_select("table", undef, [ map { [ $_ ] } @titles ],
			 1, 0, 0, 0, "onChange='form.submit()'"),"\n";
	print &ui_submit($text{'index_jumpok'})," \n";
	print &ui_form_end();

# View selector (if any)
	if (@views) {
		print &ui_form_start("edit_view.cgi");
		print $text{'dbase_vjump'},"\n";
		print &ui_hidden("db", $in{'db'}),"\n";
		print &ui_select("view", undef, [ map { [ $_ ] } @views ],
				 1, 0, 0, 0, "onChange='form.submit()'"),"\n";
		print &ui_submit($text{'index_jumpok'})," \n";
		print &ui_form_end();
		}

# Index selector (if any)
	if (@indexes) {
		print &ui_form_start("edit_index.cgi");
		print $text{'dbase_ijump'},"\n";
		print &ui_hidden("db", $in{'db'}),"\n";
		print &ui_select("index", undef, [ map { [ $_ ] } @indexes ],
				 1, 0, 0, 0, "onChange='form.submit()'"),"\n";
		print &ui_submit($text{'index_jumpok'})," \n";
		print &ui_form_end();
		}

# Sequence selector (if any)
	if (@seqs) {
		print &ui_form_start("edit_seq.cgi");
		print $text{'dbase_sjump'},"\n";
		print &ui_hidden("db", $in{'db'}),"\n";
		print &ui_select("seq", undef, [ map { [ $_ ] } @seqs ],
				 1, 0, 0, 0, "onChange='form.submit()'"),"\n";
		print &ui_submit($text{'index_jumpok'})," \n";
		print &ui_form_end();
		}
	print "\n";
	}
elsif (@titles || @indexes || @views || @seqs) {
	@icons = ( ( map { "images/table.gif" } @titles ),
		 ( map { "images/index.gif" } @indexes ),
		 ( map { "images/view.gif" } @views ),
		 ( map { "images/seq.gif" } @seqs ),
		 );
	@links = ( ( map { "edit_table.cgi?db=$in{'db'}&table=".&urlize($_) }
		 	 @titles ),
		 ( map { "edit_index.cgi?db=$in{'db'}&index=".&urlize($_) }
 @indexes ),
		 ( map { "edit_view.cgi?db=$in{'db'}&view=".&urlize($_) }
 @views ),
		 ( map { "edit_seq.cgi?db=$in{'db'}&seq=".&urlize($_) }
 @seqs ),
		 );
 @descs = ( ( map { "" } @titles ),
 ( map { " ($text{'dbase_index'})" } @indexes),
 ( map { " ($text{'dbase_view'})" } @views),
 ( map { " ($text{'dbase_seq'})" } @seqs),
 );
	#&show_buttons();
	@rowlinks = ( );
	if ($access{'tables'}) {
		print &ui_form_start("drop_tables.cgi");
		print &ui_hidden("db", $in{'db'});
		push(@rowlinks, &select_all_link("d", $form),
				&select_invert_link("d", $form) );
		@checks = ( ( @titles ),
			 ( map { "!".$_ } @indexes ),
			 ( map { "*".$_ } @views ),
			 ( map { "/".$_ } @seqs ),
			 );
		}
	print &ui_links_row(\@rowlinks);
	@dtitles = map { &html_escape($_) } ( @titles, @indexes, @views,@seqs );
	if ($displayconfig{'style'} == 1) {
		# Show as table
		foreach $t (@titles) {
			local $c;
			eval {
				local $main::error_must_die = 1;
				$c = &execute_sql($in{'db'},
				 "select count(*) from ".quote_table($t));
				};
			$c ||= { 'data' => [ [ "-" ] ] };
			push(@rows, $c->{'data'}->[0]->[0]);
			local @str = &table_structure($in{'db'}, $t);
			push(@fields, scalar(@str));
			}
		foreach $t (@indexes) {
			$str = &index_structure($in{'db'}, $t);
			push(@rows, "$text{'dbase_index'}");
			push(@fields, scalar(@{$str->{'cols'}}));
			}
		foreach $t (@views) {
			push(@rows, "$text{'dbase_view'}");
			push(@fields, undef);
			}
		foreach $t (@seqs) {
			$str = &sequence_structure($in{'db'}, $t);
			push(@rows, "$text{'dbase_seq'}");
			push(@fields, $str->{'last_value'});
			}
		&split_table([ "", $text{'dbase_table'}, $text{'dbase_rows'},
			 $text{'dbase_cols'} ],
			 \@checks, \@links, \@dtitles,
			 \@rows, \@fields) if (@titles);
		}
 elsif ($displayconfig{'style'} == 2) {
 # Just show table names
 @grid = ( );
 @all = ( @titles, @indexes, @views, @seqs );
 for(my $i=0; $i<@links; $i++) {
 push(@grid, &ui_checkbox("d", $checks[$i]).
 " <a href='$links[$i]'>".
 &html_escape($all[$i])." ".$descs[$i]."</a>");
 }
 print &ui_grid_table(\@grid, 4, 100, undef, undef,
				 $text{'dbase_header'});
 }
	else {
		# Show as icons
		@checks = map { &ui_checkbox("d", $_) } @checks;
		&icons_table(\@links, \@dtitles, \@icons, 5, undef, undef,undef,
			 @checks ? \@checks : undef);
		}
	print &ui_links_row(\@rowlinks);
	if ($access{'tables'}) {
		print &ui_form_end([ [ "delete", $text{'dbase_delete'} ] ]);
		}
	}
else {
	print "$text{'dbase_none'} \n";
	}
&show_buttons();

if ($single) {
	&ui_print_footer("/", $text{'index'});
	}
else {
	&ui_print_footer(&get_databases_return_link($in{'db'}), $text{'index_return'});
	}

# Display buttons for adding tables, views and so on
sub show_buttons
{
print &ui_form_start("table_form.cgi");
print &ui_hidden("db", $in{'db'});

if ($access{'tables'}) {
	# Add a new table
	print &ui_submit($text{'dbase_add'})." ".$text{'dbase_fields'}.
		         " ".&ui_textbox("fields", 4, 4);
	print "&nbsp;\n";

# Add a new view
	if (&supports_views() && $access{'views'}) {
		print &ui_submit($text{'dbase_vadd'}, 'addview');
		print "&nbsp;\n";
		}

# Add a new sequence
	if (&supports_sequences() && $access{'seqs'}) {
		print &ui_submit($text{'dbase_sadd'}, 'addseq');
		print "&nbsp;\n";
		}
	}

# Drop database button
if ($access{'delete'}) {
	print &ui_submit($text{'dbase_drop'}, 'dropdb');
	print "&nbsp;\n";
	}

# Backup and restore buttons
if (&get_postgresql_version() >= 7.2) {
	if ($access{'backup'}) {
		print &ui_submit($text{'dbase_bkup'}, 'backupdb');
		print "&nbsp;\n";
		}
	if ($access{'restore'}) {
		print &ui_submit($text{'dbase_rstr'}, 'restoredb');
		print "&nbsp;\n";
		}
	}

# Execute SQL form
print &ui_submit($text{'dbase_exec'}, 'exec');
print "&nbsp;\n";

print &ui_form_end();
$form++;
}