WebSVN – ALCASAR – Diff – /web/acc/manager/htdocs/user_admin.php


<?php
//gestion de la langue
$origine='user_new';
if (is_file("../lib/langues.php"))
	include("../lib/langues.php");
require('/etc/freeradius-web/config.php');
?>
<html>
<head>
<?php
require('../lib/functions.php');
require('../lib/defaults.php');
$date = strftime('%A, %e %B %Y, %T %Z');
 
if (is_file("../lib/$config[general_lib_type]/user_info.php")){
	include("../lib/$config[general_lib_type]/user_info.php");
	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="/css/style.css">
</head>
<body>
<center>
<form action="user_admin.php" method=get>
<b>User Name&nbsp;&nbsp;</b>
<input type="text" size=10 name="login" value="$login">
<b>&nbsp;&nbsp;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.php"))
	include_once("../lib/sql/drivers/$config[sql_type]/functions.php");
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>
<center>
<b>Could not include SQL library functions. Aborting</b>
</body>
</html>
EOM;
	exit();
}
 
if(isset($item_vals['Max-Monthly-Session'][0]) && $item_vals['Max-Monthly-Session'][0] != ''){
	$monthly_limit = $item_vals['Max-Monthly-Session'][0];
} else if (isset($default_vals['Max-Monthly-Session'][0])){
	$monthly_limit = $default_vals['Max-Monthly-Session'][0];
} else {
	$monthly_limit = '';
}
$monthly_limit = ($monthly_limit) ? $monthly_limit : $config['counter_default_monthly'];
 
if(isset($item_vals['Max-Weekly-Session'][0]) && $item_vals['Max-Weekly-Session'][0] != ''){
	$weekly_limit = $item_vals['Max-Weekly-Session'][0];
} else if (isset($default_vals['Max-Weekly-Session'][0])){
	$weekly_limit = $default_vals['Max-Weekly-Session'][0];
} else {
	$weekly_limit = '';
}
$weekly_limit = ($weekly_limit) ? $weekly_limit : $config['counter_default_weekly'];
 
if(isset($item_vals['Max-Daily-Session'][0]) && $item_vals['Max-Daily-Session'][0] != ''){
	$daily_limit = $item_vals['Max-Daily-Session'][0];
} else if (isset($default_vals['Max-Daily-Session'][0])){
	$daily_limit = $default_vals['Max-Daily-Session'][0];
} else {
	$daily_limit = '';
}
$daily_limit = ($daily_limit) ? $daily_limit : $config['counter_default_daily'];
 
if(isset($item_vals['Session-Timeout'][0]) && $item_vals['Session-Timeout'][0] != ''){
	$session_limit = $item_vals['Session-Timeout'][0];
} else if (isset($default_vals['Session-Timeout'][0])){
	$session_limit = $default_vals['Session-Timeout'][0];
} else {
	$session_limit = '';
}
$session_limit = ($session_limit) ? $session_limit : 'none';
 
if(isset($item_vals['Max-All-Session'][0]) && $item_vals['Max-All-Session'][0] != ''){
	$total_limit = $item_vals['Max-All-Session'][0];
} else if (isset($default_vals['Max-All-Session'][0])){
	$total_limit = $default_vals['Max-All-Session'][0];
} else {
	$total_limit = '';
}
$total_limit = ($total_limit) ? $total_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' || (isset($config['counter_monthly_calculate_usage']) && $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' || (isset($config['counter_monthly_calculate_usage']) && $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 " . 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 "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
	if (!isset($logged_now) || !$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 "<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;
$total_limit = (is_numeric($total_limit)) ? time2str($total_limit) : $total_limit;
$remaining = (is_numeric($remaining)) ? time2str($remaining) : $remaining;
 
if (isset($item_vals['Dialup-Access'][0]) && $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> $l_locked_user </b></font>
EON;
else
	$msg =<<<EON
$l_user_remain_login<font color="$log_color"> <b>$remaining $extra_msg</b></font>
EON;
$lock_msg = (isset($item_vals['Dialup-Lock-Msg'][0])) ? $item_vals['Dialup-Lock-Msg'][0] : '';
if ($lock_msg != '')
	$descr =<<<EON
<font color=red><b>$lock_msg </b</font>
EON;
else
	$descr = '-';
 
$expiration = isset($default_vals['Expiration'][0]) ? $default_vals['Expiration'][0] : '';
if (isset($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>$l_user_expired</b></font>
EOM;
}
 
require('../html/user_admin.html.php');
?>
 

Subversion Repositories ALCASAR

(root)/web/acc/manager/htdocs/user_admin.php – Rev 1805 → 1847

Rev 1805		Rev 1847
1	`<?php`	1	`<?php`
2	`//gestion de la langue`	2	`//gestion de la langue`
3	`$origine='user_new';`	3	`$origine='user_new';`
4	`if (is_file("../lib/langues.php"))`	4	`if (is_file("../lib/langues.php"))`
5	`include("../lib/langues.php");`	5	`include("../lib/langues.php");`
6	`require('/etc/freeradius-web/config.php');`	6	`require('/etc/freeradius-web/config.php');`
7	`?>`	7	`?>`
8	`<html>`	8	`<html>`
9	`<head>`	9	`<head>`
10	`<?php`	10	`<?php`
11	`require('../lib/functions.php');`	11	`require('../lib/functions.php');`
12	`require('../lib/defaults.php');`	12	`require('../lib/defaults.php');`
13	`$date = strftime('%A, %e %B %Y, %T %Z');`	13	`$date = strftime('%A, %e %B %Y, %T %Z');`
14		14
15	`if (is_file("../lib/$config[general_lib_type]/user_info.php")){`	15	`if (is_file("../lib/$config[general_lib_type]/user_info.php")){`
16	`include("../lib/$config[general_lib_type]/user_info.php");`	16	`include("../lib/$config[general_lib_type]/user_info.php");`
17	`if ($user_exists == 'no'){`	17	`if ($user_exists == 'no'){`
18	`echo <<<EOM`	18	`echo <<<EOM`
19	`<title>User information page</title>`	19	`<title>User information page</title>`
20	`<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">`	20	`<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">`
21	`<link rel="stylesheet" href="/css/style.css">`	21	`<link rel="stylesheet" href="/css/style.css">`
22	`</head>`	22	`</head>`
23	`<body>`	23	`<body>`
24	`<center>`	24	`<center>`
25	`<form action="user_admin.php" method=get>`	25	`<form action="user_admin.php" method=get>`
26	`<b>User Name  </b>`	26	`<b>User Name  </b>`
27	`<input type="text" size=10 name="login" value="$login">`	27	`<input type="text" size=10 name="login" value="$login">`
28	`<b>  does not exist</b><br>`	28	`<b>  does not exist</b><br>`
29	`<input type=submit class=button value="Show User">`	29	`<input type=submit class=button value="Show User">`
30	`</body>`	30	`</body>`
31	`</html>`	31	`</html>`
32	`EOM;`	32	`EOM;`
33	`exit();`	33	`exit();`
34	`}`	34	`}`
35	`}`	35	`}`
36		36
37	`if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))`	37	`if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))`
38	`include_once("../lib/sql/drivers/$config[sql_type]/functions.php");`	38	`include_once("../lib/sql/drivers/$config[sql_type]/functions.php");`
39	`else{`	39	`else{`
40	`echo <<<EOM`	40	`echo <<<EOM`