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

# Functions used by view_table.cgi and siblings, and shared between the
# MySQL and PostgreSQL modules

# get_search_args(&in)
# Returns the search SQL, search URL arguments and search hidden fields
sub get_search_args
{
local %in = %{$_[0]};
local ($search, $searchhids, $searchargs, @adv);
if ($in{'field'}) {
	# A simple search
	$search = "where ".&quotestr($in{'field'})." ".
		   &make_like($in{'match'}, $in{'for'});
	$searchargs = "&field=".&urlize($in{'field'}).
		      "&for=".&urlize($in{'for'}).
		      "&match=".&urlize($in{'match'});
	$searchhids = &ui_hidden("field", $in{'field'})."\n".
		      &ui_hidden("for", $in{'for'})."\n".
		      &ui_hidden("match", $in{'match'})."\n";
	}
elsif ($in{'advanced'}) {
	# An advanced search
	for(my $i=0; defined($in{"field_$i"}); $i++) {
		if ($in{"field_$i"}) {
			push(@adv, &quotestr($in{"field_$i"})." ".
				   &make_like($in{"match_$i"}, $in{"for_$i"}));
			$searchargs .= "&field_$i=".&urlize($in{"field_$i"}).
				       "&for_$i=".&urlize($in{"for_$i"}).
				       "&match_$i=".&urlize($in{"match_$i"});
			$searchhids .=
				&ui_hidden("field_$i", $in{"field_$i"})."\n".
				&ui_hidden("for_$i", $in{"for_$i"})."\n".
				&ui_hidden("match_$i", $in{"match_$i"})."\n";
			}
		}
	if (@adv) {
		$search = "where (".join($in{'and'} ? " and " : " or ",
					@adv).")";
		$searchhids .= &ui_hidden("and", $in{'and'})."\n".
			       &ui_hidden("advanced", 1)."\n";
		$searchargs .= "&and=".$in{'and'}.
			       "&advanced=1";
		}
	}
return ($search, $searchhids, $searchargs, scalar(@adv));
}

# get_search_limit(&in)
# Build limiting expression
sub get_search_limit
{
local %in = %{$_[0]};
$in{'start'} ||= 0;
if ($module_name eq "mysql") {
	return "limit $in{'start'},$displayconfig{'perpage'}";
	}
else {
	return "limit $displayconfig{'perpage'} offset $in{'start'}";
	}
}

# get_search_limit(&in)
# Returns an SQL expression for sorting, hidden fields for the current sort order, and
# URL args for the current order
sub get_search_sort
{
local %in = %{$_[0]};
if ($in{'sortfield'}) {
	local ($sort, $sorthids, $sortargs);
	$sort = "order by ".&quotestr($in{'sortfield'})." ".($in{'sortdir'} ? "asc" : "desc");
	$sorthids = &ui_hidden("sortfield", $in{'sortfield'})."\n".
		    &ui_hidden("sortdir", $in{'sortdir'})."\n";
	$sortargs = "&sortfield=".&urlize($in{'sortfield'}).
		    "&sortdir=$in{'sortdir'}";
	return ($sort, $sorthids, $sortargs);
	}
else {
	return ( undef, undef, undef );
	}
}

# make_like(mode, for)
sub make_like
{
local ($match, $for) = @_;
local $qu = $module_name eq "mysql" ? '"' : "'";
return $match == 0 ? "like $qu%$for%$qu" :
       $match == 1 ? "like $qu$for$qu" :
       $match == 2 ? "not like $qu%$for%$qu" :
       $match == 3 ? "not like $qu$for$qu" :
       $match == 4 ? "> $for" :
       $match == 5 ? "< $for" :
		     " = \"\"";
}

# get_databases_return_link(db-name)
# Returns a link back to the DB list, which may be in Virtualmin
sub get_databases_return_link
{
my ($dbname) = @_;
if (&foreign_check("virtual-server") &&
    &foreign_available("virtual-server")) {
	$virtual_server::no_virtualmin_plugins = 1;
	&foreign_require("virtual-server", "virtual-server-lib.pl");
	if (!&virtual_server::master_admin()) {
		my $type = $module_name =~ /^mysql/ ? 'mysql' : 'postgres';
		foreach my $d (grep { &virtual_server::can_edit_domain($_) }
				    &virtual_server::list_domains()) {
			my @dbs = &virtual_server::domain_databases(
					$d, [ $type ]);
			my ($got) = grep { $_->{'name'} eq $dbname } @dbs;
			if ($got) {
				return "../virtual-server/list_databases.cgi?".
				       "dom=$d->{'id'}";
				}
			}
		}
	}
return "";
}