user information page

User Name     does not exist
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 <<user information page Could not include SQL library functions. Aborting 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 "Database query failed: " . da_sql_error($link,$config) . "
\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 "Database query failed: " . da_sql_error($link,$config) . "
\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 "Database query failed: " . da_sql_error($link,$config) . "
\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 "Database query failed: " . da_sql_error($link,$config) . "
\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] = "" . time2str($used[$i]) . ""; 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 = "$daily_used"; } } else echo "Database query failed: " . da_sql_error($link,$config) . "
\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 = "$weekly_used"; 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 = "$monthly_used"; } 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 " . da_sql_limit(1,0,$config) . " * FROM $config[sql_accounting_table] WHERE username = '$login' AND acctstoptime IS NULL " . da_sql_limit(1,1,$config) . " ORDER BY acctstarttime DESC " . da_sql_limit(1,2,$config). " ;"); 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_output = bytes2str($lastlog_output); else $lastlog_output = 'not available'; } } else echo "Database query failed: " . da_sql_error($link,$config) . "
\n"; if (! $logged_now){ $search = @da_sql_query($link,$config, "SELECT " . da_sql_limit(1,0,$config) . " * FROM $config[sql_accounting_table] WHERE username = '$login' AND acctsessiontime != '0' " . da_sql_limit(1,1,$config) . " ORDER BY acctstoptime DESC " . da_sql_limit(1,2,$config). " ;"); 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 "Database query failed: " . da_sql_error($link,$config) . "
\n"; } } else echo "Could not connect to SQL database
\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 =<< The user account is locked EON; else $msg =<< $remaining $extra_msg EON; $lock_msg = $item_vals['Dialup-Lock-Msg'][0]; if ($lock_msg != '') $descr =<<$lock_msg 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 = <<User Account has expired EOM; } require('../html/user_admin.html.php3'); ?>