3 # Edit or create a db table record
5 require './mysql-lib.pl';
7 $access{'perms'} || &error($text{'perms_ecannot'});
10 &ui_print_header(undef, $text{'db_title1'}, "", "create_db");
13 $d = &execute_sql_safe($master_db, "select * from db order by db");
14 $u = $d->{'data'}->[$in{'idx'}];
15 $access{'perms'} == 1 || &can_edit_db($u->[1]) ||
16 &error($text{'perms_edb'});
17 &ui_print_header(undef, $text{'db_title2'}, "", "edit_db");
20 print &ui_form_start("save_db.cgi");
22 print &ui_hidden("new", 1);
25 print &ui_hidden("oldhost", $u->[0]);
26 print &ui_hidden("olddb", $u->[1]);
27 print &ui_hidden("olduser", $u->[2]);
29 print &ui_table_start($text{'db_header'}, undef, 2);
32 print &ui_table_row($text{'db_db'}, &select_db($u->[1]));
35 print &ui_table_row($text{'db_user'},
36 &ui_opt_textbox("user", $u->[2], 20, $text{'db_anon'}));
39 print &ui_table_row($text{'db_host'},
40 &ui_radio("host_mode", $u->[0] eq '' ? 0 : $u->[0] eq '%' ? 1 : 2,
41 [ [ 0, $text{'db_hosts'} ],
42 [ 1, $text{'db_any'} ],
43 [ 2, &ui_textbox("host", $u->[0] eq '%' ? '' : $u->[0], 40) ] ]));
46 for($i=3; $i<=&db_priv_cols()+3-1; $i++) {
47 push(@opts, [ $i, $text{"db_priv$i"} ]);
48 push(@sel, $i) if ($u->[$i] eq 'Y');
50 print &ui_table_row($text{'db_perms'},
51 &ui_select("perms", \@sel, \@opts, 10, 1, 1));
53 print &ui_table_end();
54 print &ui_form_end([ $in{'new'} ? ( [ undef, $text{'create'} ] )
55 : ( [ undef, $text{'save'} ],
56 [ 'delete', $text{'delete'} ] ) ]);
58 &ui_print_footer('list_dbs.cgi', $text{'dbs_return'},
59 "", $text{'index_return'});