📄 user_admin.php3
字号:
<?phprequire('../conf/config.php3');?><html><head><?phprequire('../lib/functions.php3');require('../lib/defaults.php3');$date = strftime('%A, %e %B %Y, %T %Z');if (is_file("../lib/$config[general_lib_type]/user_info.php3")){ include("../lib/$config[general_lib_type]/user_info.php3"); if ($user_exists == 'no'){ echo <<<EOM<title>user information page</title><meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]"><link rel="stylesheet" href="style.css"></head><body bgcolor="#80a040" background="images/greenlines1.gif" link="black" alink="black"><center><form action="user_admin.php3" method=get><b>User Name </b><input type="text" size=10 name="login" value="$login"><b> does not exist</b><br><input type=submit class=button value="Show User"></body></html>EOM; exit(); }}if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php3")) include_once("../lib/sql/drivers/$config[sql_type]/functions.php3");else{ echo <<<EOM<title>user information page</title><meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]"><link rel="stylesheet" href="style.css"></head><body bgcolor="#80a040" background="images/greenlines1.gif" link="black" alink="black"><center><b>Could not include SQL library functions. Aborting</b></body></html>EOM; exit();}$monthly_limit = ($item_vals['Max-Monthly-Session'][0] != '') ? $item_vals['Max-Monthly-Session'][0] : $default_vals['Max-Monthly-Session'][0];$monthly_limit = ($monthly_limit) ? $monthly_limit : $config[counter_default_monthly];$weekly_limit = ($item_vals['Max-Weekly-Session'][0] != '') ? $item_vals['Max-Weekly-Session'][0] : $default_vals['Max-Weekly-Session'][0];$weekly_limit = ($weekly_limit) ? $weekly_limit : $config[counter_default_weekly];$daily_limit = ($item_vals['Max-Daily-Session'][0] != '') ? $item_vals['Max-Daily-Session'][0] : $default_vals['Max-Daily-Session'][0];$daily_limit = ($daily_limit) ? $daily_limit : $config[counter_default_daily];$session_limit = ($item_vals['Session-Timeout'][0] != '') ? $item_vals['Session-Timeout'][0] : $default_vals['Session-Timeout'][0];$session_limit = ($session_limit) ? $session_limit : 'none';$remaining = 'unlimited time';$log_color = 'green';$now = time();$week = $now - 604800;$now_str = date("$config[sql_date_format]",$now + 86400);$week_str = date("$config[sql_date_format]",$week);$day = date('w');$week_start = date($config[sql_date_format],$now - ($day)*86400);$month_start = date($config[sql_date_format],$now - date('j')*86400);$today = $day;$now_tmp = $now;for ($i = $day; $i >-1; $i--){ $days[$i] = date($config[sql_date_format],$now_tmp); $now_tmp -= 86400;}$day++;//$now -= ($day * 86400);$now -= 604800;$now += 86400;for ($i = $day; $i <= 6; $i++){ $days[$i] = date($config[sql_date_format],$now);// $now -= 86400; $now += 86400;}$daily_used = $weekly_used = $monthly_used = $lastlog_session_time = '-';$extra_msg = '';$used = array('-','-','-','-','-','-','-');$link = @da_sql_pconnect($config);if ($link){ $search = @da_sql_query($link,$config, "SELECT sum(acctsessiontime) AS sum_sess_time, sum(acctinputoctets) AS sum_in_octets, sum(acctoutputoctets) AS sum_out_octets, avg(acctsessiontime) AS avg_sess_time, avg(acctinputoctets) AS avg_in_octets, avg(acctoutputoctets) AS avg_out_octets, COUNT(*) as counter FROM $config[sql_accounting_table] WHERE username = '$login' AND acctstarttime >= '$week_str' AND acctstarttime <= '$now_str';"); if ($search){ $row = @da_sql_fetch_array($search,$config); $tot_time = time2str($row[sum_sess_time]); $tot_input = bytes2str($row[sum_in_octets]); $tot_output = bytes2str($row[sum_out_octets]); $avg_time = time2str($row[avg_sess_time]); $avg_input = bytes2str($row[avg_in_octets]); $avg_output = bytes2str($row[avg_out_octets]); $tot_conns = $row[counter]; } else echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n"; $search = @da_sql_query($link,$config, "SELECT sum(acctsessiontime) AS sum_sess_time FROM $config[sql_accounting_table] WHERE username = '$login' AND acctstarttime >= '$week_start' AND acctstarttime <= '$now_str';"); if ($search){ $row = @da_sql_fetch_array($search,$config); $weekly_used = $row[sum_sess_time]; } else echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n"; if ($monthly_limit != 'none' || $config[counter_monthly_calculate_usage] == 'true'){ $search = @da_sql_query($link,$config, "SELECT sum(acctsessiontime) AS sum_sess_time FROM $config[sql_accounting_table] WHERE username = '$login' AND acctstarttime >= '$month_start' AND acctstarttime <= '$now_str';"); if ($search){ $row = @da_sql_fetch_array($search,$config); $monthly_used = $row[sum_sess_time]; } else echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n"; } $search = @da_sql_query($link,$config, "SELECT COUNT(*) AS counter FROM $config[sql_accounting_table] WHERE username = '$login' AND acctstoptime >= '$week_str' AND acctstoptime <= '$now_str' AND (acctterminatecause LIKE 'Login-Incorrect%' OR acctterminatecause LIKE 'Invalid-User%' OR acctterminatecause LIKE 'Multiple-Logins%');"); if ($search){ $row = @da_sql_fetch_array($search,$config); $tot_badlogins = $row[counter]; } else echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n"; for($i = 0; $i <=6; $i++){ if ($days[$i] == '') continue; $search = @da_sql_query($link,$config, "SELECT sum(acctsessiontime) AS sum_sess_time FROM $config[sql_accounting_table] WHERE username = '$login' AND acctstoptime >= '$days[$i] 00:00:00' AND acctstoptime <= '$days[$i] 23:59:59';"); if ($search){ $row = @da_sql_fetch_array($search,$config); $used[$i] = $row[sum_sess_time]; if ($daily_limit != 'none' && $used[$i] > $daily_limit) $used[$i] = "<font color=red>" . time2str($used[$i]) . "</font>"; else $used[$i] = time2str($used[$i]); if ($today == $i){ $daily_used = $row[sum_sess_time]; if ($daily_limit != 'none'){ $remaining = $daily_limit - $daily_used; if ($remaining <=0) $remaining = 0; $log_color = ($remaining) ? 'green' : 'red'; if (!$remaining) $extra_msg = '(Out of daily quota)'; } $daily_used = time2str($daily_used); if ($daily_limit != 'none' && !$remaining) $daily_used = "<font color=red>$daily_used</font>"; } } else echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n"; } if ($weekly_limit != 'none'){ $tmp = $weekly_limit - $weekly_used; if ($tmp <=0){ $tmp = 0; $extra_msg .= '(Out of weekly quota)'; } if (!is_numeric($remaining)) $remaining = $tmp; if ($remaining > $tmp) $remaining = $tmp; $log_color = ($remaining) ? 'green' : 'red'; } $weekly_used = time2str($weekly_used); if ($weekly_limit != 'none' && !$tmp) $weekly_used = "<font color=red>$weekly_used</font>"; if ($monthly_limit != 'none'){ $tmp = $monthly_limit - $monthly_used; if ($tmp <=0){ $tmp = 0; $extra_msg .= '(Out of monthly quota)'; } if (!is_numeric($remaining)) $remaining = $tmp; if ($remaining > $tmp) $remaining = $tmp; $log_color = ($remaining) ? 'green' : 'red'; } if ($monthly_limit != 'none' || $config[counter_monthly_calculate_usage] == 'true'){ $monthly_used = time2str($monthly_used); if ($monthly_limit != 'none' && !$tmp) $monthly_used = "<font color=red>$monthly_used</font>"; } if ($session_limit != 'none'){ if (!is_numeric($remaining)) $remaining = $session_limit; if ($remaining > $session_limit) $remaining = $session_limit; } $search = @da_sql_query($link,$config, "SELECT * FROM $config[sql_accounting_table] WHERE username = '$login' AND acctstoptime IS NULL ORDER BY acctstarttime DESC LIMIT 1;"); if ($search){ if (@da_sql_num_rows($search,$config)){ $logged_now = 1; $row = @da_sql_fetch_array($search,$config); $lastlog_time = $row['acctstarttime']; $lastlog_server_ip = $row['nasipaddress']; $lastlog_server_port = $row['nasportid']; $lastlog_session_time = date2timediv($lastlog_time,0); if ($daily_limit != 'none'){ $remaining = $remaining - $lastlog_session_time; if ($remaining < 0) $remaining = 0; $log_color = ($remaining) ? 'green' : 'red'; } $lastlog_session_time_jvs = 1000 * $lastlog_session_time; $lastlog_session_time = time2strclock($lastlog_session_time); $lastlog_client_ip = $row['framedipaddress']; $lastlog_server_name = @gethostbyaddr($lastlog_server_ip); $lastlog_client_name = @gethostbyaddr($lastlog_client_ip); $lastlog_callerid = $row['callingstationid']; if ($lastlog_callerid == '') $lastlog_callerid = 'not available'; $lastlog_input = $row['acctinputoctets']; if ($lastlog_input) $lastlog_input = bytes2str($lastlog_input); else $lastlog_input = 'not available'; $lastlog_output = $row['acctoutputoctets']; if ($lastlog_output) $lastlog_input = bytes2str($lastlog_output); else $lastlog_output = 'not available'; } } else echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n"; if (! $logged_now){ $search = @da_sql_query($link,$config, "SELECT * FROM $config[sql_accounting_table] WHERE username = '$login' AND acctsessiontime != '0' ORDER BY acctstoptime DESC LIMIT 1;"); if ($search){ if (@da_sql_num_rows($search,$config)){ $row = @da_sql_fetch_array($search,$config); $lastlog_time = $row['acctstarttime']; $lastlog_server_ip = $row['nasipaddress']; $lastlog_server_port = $row['nasportid']; $lastlog_session_time = time2str($row['acctsessiontime']); $lastlog_client_ip = $row['framedipaddress']; $lastlog_server_name = ($lastlog_server_ip != '') ? @gethostbyaddr($lastlog_server_ip) : '-'; $lastlog_client_name = ($lastlog_client_ip != '') ? @gethostbyaddr($lastlog_client_ip) : '-'; $lastlog_callerid = $row['callingstationid']; if ($lastlog_callerid == '') $lastlog_callerid = 'not available'; $lastlog_input = $row['acctinputoctets']; $lastlog_input = bytes2str($lastlog_input); $lastlog_output = $row['acctoutputoctets']; $lastlog_output = bytes2str($lastlog_output); } else $not_known = 1; } else echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n"; }}else echo "<b>Could not connect to SQL database</b><br>\n";$monthly_limit = (is_numeric($monthly_limit)) ? time2str($monthly_limit) : $monthly_limit;$weekly_limit = (is_numeric($weekly_limit)) ? time2str($weekly_limit) : $weekly_limit;$daily_limit = (is_numeric($daily_limit)) ? time2str($daily_limit) : $daily_limit;$session_limit = (is_numeric($session_limit)) ? time2str($session_limit) : $session_limit;$remaining = (is_numeric($remaining)) ? time2str($remaining) : $remaining;if ($item_vals['Dialup-Access'][0] == 'FALSE' || (!isset($item_vals['Dialup-Access'][0]) && $attrmap['Dialup-Access'] != '' && $attrmap['Dialup-Access'] != 'none')) $msg =<<<EON<font color=red><b> The user account is locked </b></font>EON;else $msg =<<<EONuser can login for <font color="$log_color"> <b>$remaining $extra_msg</font>EON;$lock_msg = $item_vals['Dialup-Lock-Msg'][0];if ($lock_msg != '') $descr =<<<EON<font color=red><b>$lock_msg </b</font>EON;else $descr = '-';$expiration = $default_vals['Expiration'][0];if ($item_vals['Expiration'][0] != '') $expiration = $item_vals['Expiration'][0];if ($expiration != ''){ $expiration = strtotime($expiration); if ($expiration != -1 && $expiration < time()) $descr = <<<EOM<font color=red><b>User Account has expired</b></font>EOM;}require('../html/user_admin.html.php3');⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -