Server IP : 195.201.23.43 / Your IP : 18.226.28.197 Web Server : Apache System : Linux webserver2.vercom.be 5.4.0-192-generic #212-Ubuntu SMP Fri Jul 5 09:47:39 UTC 2024 x86_64 User : kdecoratie ( 1041) PHP Version : 7.1.33-63+ubuntu20.04.1+deb.sury.org+1 Disable Function : 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, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /usr/share/webmin/postgresql/ |
Upload File : |
#!/usr/bin/perl # drop_table.cgi # Delete an existing table require './postgresql-lib.pl'; &ReadParse(); &can_edit_db($in{'db'}) || &error($text{'dbase_ecannot'}); $qt = "e_table($in{'table'}); if ($in{'confirm'}) { # Drop the table &error_setup($text{'tdrop_err'}); &execute_sql_logged($in{'db'}, "drop table $qt"); &webmin_log("delete", "table", $in{'table'}, \%in); &redirect("edit_dbase.cgi?db=$in{'db'}"); } else { # Ask the user if he is sure.. &ui_print_header(undef, $text{'tdrop_title'}, ""); @tables = &list_tables($in{'db'}); $d = &execute_sql_safe($in{'db'}, "select count(*) from $qt"); $rows = $d->{'data'}->[0]->[0]; print "<center><b>", &text('tdrop_rusure', "<tt>$in{'table'}</tt>", "<tt>$in{'db'}</tt>", $rows),"</b><p>\n"; print "<form action=drop_table.cgi>\n"; print "<input type=hidden name=db value='$in{'db'}'>\n"; print "<input type=hidden name=table value='$in{'table'}'>\n"; print "<input type=submit name=confirm value='$text{'tdrop_ok'}'>\n"; print "</form></center>\n"; &ui_print_footer("edit_table.cgi?db=$in{'db'}&table=$in{'table'}", $text{'table_return'}); }Private