|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /usr/libexec/webmin/postgresql/ |
Upload File : |
#!/usr/bin/perl
# list_users.cgi
# Display all users in the database
require './postgresql-lib.pl';
$access{'users'} || &error($text{'user_ecannot'});
&ui_print_header(undef, $text{'user_title'}, "", "list_users");
$s = &execute_sql_safe($config{'basedb'}, "select * from pg_shadow");
print &ui_form_start("delete_users.cgi", "post");
@rowlinks = ( &select_all_link("d", 0),
&select_invert_link("d", 0),
"<a href='edit_user.cgi?new=1'>$text{'user_add'}</a>" );
print &ui_links_row(\@rowlinks);
print &ui_columns_start([ "", $text{'user_name'},
$text{'user_pass'},
$text{'user_db'},
$text{'user_other'},
$text{'user_until'} ], 100);
foreach $u (sort { $a->[0] cmp $b->[0] } @{$s->{'data'}}) {
local @cols;
push(@cols, "<a href='edit_user.cgi?user=$u->[0]'>".
&html_escape($u->[0])."</a>");
push(@cols, $u->[5] ? $text{'yes'} : $text{'no'});
push(@cols, $u->[2] =~ /t|1/ ? $text{'yes'} : $text{'no'});
push(@cols, $u->[4] =~ /t|1/ ? $text{'yes'} : $text{'no'});
push(@cols, $u->[6] ? &html_escape($u->[6])
: $text{'user_forever'});
print &ui_checked_columns_row(\@cols, undef, "d", $u->[0]);
}
print &ui_columns_end();
print &ui_links_row(\@rowlinks);
print &ui_form_end([ [ "delete", $text{'user_delete'} ] ]);
if (&get_postgresql_version() >= 7 && &foreign_installed("useradmin")) {
print &ui_hr();
print &ui_form_start("save_sync.cgi");
print "$text{'user_sync'}<br>\n";
print &ui_checkbox("sync_create", 1, $text{'user_sync_create'},
$config{'sync_create'}),"<br>\n";
print &ui_checkbox("sync_modify", 1, $text{'user_sync_modify'},
$config{'sync_modify'}),"<br>\n";
print &ui_checkbox("sync_delete", 1, $text{'user_sync_delete'},
$config{'sync_delete'}),"<br>\n";
print &ui_form_end([ [ "save", $text{'save'} ] ]);
}
&ui_print_footer("", $text{'index_return'});