| Server IP : 49.231.201.246 / Your IP : 216.73.216.248 Web Server : Apache/2.4.18 (Ubuntu) System : Linux 246 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64 User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 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_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/webmin/custom/ |
Upload File : |
#!/usr/bin/perl
# Execute some SQL and display the result
require './custom-lib.pl';
if ($ENV{'CONTENT_TYPE'} =~ /multipart\/form-data/i) {
&ReadParseMime();
}
else {
&ReadParse();
}
&error_setup($text{'srun_err'});
$cmd = &get_command($in{'id'}, $in{'idx'});
&can_run_command($cmd) || &error($text{'run_ecannot'});
# Connect to the DB
use DBI;
$drh = DBI->install_driver($cmd->{'type'});
$drh || &error($text{'srun_edriver'});
($driver) = grep { $_->{'driver'} eq $cmd->{'type'} } &list_dbi_drivers();
$dbh = $drh->connect($driver->{'dbparam'}."=".$cmd->{'db'}.
($cmd->{'host'} ? ";host=$cmd->{'host'}" : ""),
$cmd->{'user'}, $cmd->{'pass'}, { });
$dbh || &error(&text('srun_econnect', $drh->errstr));
# Show header
&ui_print_unbuffered_header(undef, $text{'srun_title'}, "");
print &text('srun_cmd', "<tt>$cmd->{'sql'}</tt>"),"<p>\n";
# Work out params
($env, $export, $str, $displaystr, $args) = &set_parameter_envs($cmd, $cmd->{'sql'}, undef);
# Run it
$cmd = $dbh->prepare($cmd->{'sql'});
if (!$cmd) {
print &text('srun_eprepare', $dbh->errstr),"<p>\n";
}
elsif (!$cmd->execute(@$args)) {
print &text('srun_eexecute', $dbh->errstr),"<p>\n";
}
else {
# Show results
if (@titles = @{$cmd->{'NAME'}}) {
print &ui_columns_start(\@titles);
# Show results
while(my @r = $cmd->fetchrow()) {
print &ui_columns_row(\@r);
}
print &ui_columns_end();
$cmd->finish();
}
else {
$r = $cmd->finish();
print &text('srun_none', $r),"<p>\n";
}
}
&ui_print_footer("", $text{'index_return'});