| Server IP : 49.231.201.246 / Your IP : 216.73.216.149 Web Server : Apache/2.4.18 (Ubuntu) System : User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : exec,passthru,mail,shell_exec,system,proc_open,popen,ini_alter,dl,proc_close,curl_exec,curl_multi_exec,readfile,parse_ini_file,escapeshellarg,escapeshellcmd,show_source,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,mail,php_uname,phpinfo MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/webmin/postgresql/ |
Upload File : |
#!/usr/bin/perl
# save_field.cgi
# Create or rename a field
require './postgresql-lib.pl';
&ReadParse();
&can_edit_db($in{'db'}) || &error($text{'dbase_ecannot'});
$qt = "e_table($in{'table'});
if ($in{'delete'}) {
# Attempt to remove field
&error_setup($text{'field_err1'});
&execute_sql_logged($in{'db'}, "alter table $qt ".
"drop column \"$in{'old'}\"");
}
else {
# Validate inputs
&error_setup($text{'field_err2'});
$in{'field'} =~ /^\S+$/ || &error(&text('field_efield', $in{'field'}));
if ($in{'new'}) {
# Add field
if (defined($in{'size'})) {
$in{'size'} =~ /^\d+(,\d+)?$/ ||
&error(&text('field_esize', $in{'size'}));
$size = "($in{'size'})";
}
$arr = $in{'arr'} ? "[]" : "";
&execute_sql_logged($in{'db'}, "alter table $qt add ".
"\"$in{'field'}\" $in{'type'}$size$arr");
}
elsif ($in{'old'} ne $in{'field'}) {
# Rename field
&execute_sql_logged($in{'db'}, "alter table $qt rename ".
"\"$in{'old'}\" to \"$in{'field'}\"");
}
}
&redirect("edit_table.cgi?db=$in{'db'}&table=$in{'table'}");