| 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/mysql/ |
Upload File : |
#!/usr/bin/perl
# edit_cpriv.cgi
# Display a form for editing or creating new column permissions
require './mysql-lib.pl';
&ReadParse();
$access{'perms'} || &error($text{'perms_ecannot'});
if (defined($in{'table'})) {
&ui_print_header(undef, $text{'cpriv_title1'}, "", "create_cpriv");
if (defined($in{'db'})) {
# From two fields
$d = $in{'db'};
$t = $in{'table'};
$in{'db'} =~ /^\S+$/ || &error($text{'cpriv_edb'});
$in{'table'} =~ /^\S+$/ || &error($text{'cpriv_etable'});
}
else {
# From selector
($d, $t) = split(/\./, $in{'table'});
}
}
else {
$d = &execute_sql_safe($master_db, "select * from columns_priv order by table_name,column_name");
$u = $d->{'data'}->[$in{'idx'}];
$access{'perms'} == 1 || &can_edit_db($u->[1]) ||
&error($text{'perms_edb'});
$d = $u->[1]; $t = $u->[3];
&ui_print_header(undef, $text{'cpriv_title2'}, "", "edit_cpriv");
}
print &ui_form_start("save_cpriv.cgi");
if ($in{'table'}) {
if (defined($in{'db'})) {
print &ui_hidden("table", $in{'db'}.".".$in{'table'});
}
else {
print &ui_hidden("table", $in{'table'});
}
}
else {
print &ui_hidden("oldhost", $u->[0]);
print &ui_hidden("olddb", $u->[1]);
print &ui_hidden("olduser", $u->[2]);
print &ui_hidden("oldtable", $u->[3]);
print &ui_hidden("oldfield", $u->[4]);
}
print &ui_table_start($text{'cpriv_header'}, undef, 2);
# Apply to DB and table
print &ui_table_row($text{'cpriv_db'}, "<tt>$d</tt>");
print &ui_table_row($text{'cpriv_table'}, "<tt>$t</tt>");
# Table field
print &ui_table_row($text{'cpriv_field'},
&ui_select("field", $in{'table'} ? '' : $u->[4],
[ $in{'table'} ? ( '' ) : ( ),
map { $_->{'field'} } &table_structure($d, $t) ], 1, 0, 1));
# Apply to user
print &ui_table_row($text{'cpriv_user'},
&ui_opt_textbox("user", $u->[2], 20, $text{'cpriv_anon'}));
# Apply to host
print &ui_table_row($text{'cpriv_host'},
&ui_opt_textbox("host", $u->[0] eq '%' ? '' : $u->[0], 40,
$text{'cpriv_any'}));
# Permissions to grant
print &ui_table_row($text{'cpriv_perms'},
&ui_select("perms", [ split(/,/, $u->[6]) ],
[ 'Select','Insert','Update','References' ], 4, 1));
print &ui_table_end();
print &ui_form_end([ $in{'table'} ? ( [ undef, $text{'create'} ] )
: ( [ undef, $text{'save'} ],
[ 'delete', $text{'delete'} ] ) ]);
&ui_print_footer('list_cprivs.cgi', $text{'cprivs_return'},
"", $text{'index_return'});