Subversion Repositories ALCASAR

Rev

Rev 1805 | Rev 2347 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log

Rev Author Line No. Line
324 richard 1 
<?php
907 richard 2 
//gestion de la langue
3 
$origine='user_new';
4 
if (is_file("../lib/langues.php"))
5 
	include("../lib/langues.php");
324 richard 6 
require('/etc/freeradius-web/config.php');
7 
?>
8 
<html>
9 
<head>
10 
<?php
11 
require('../lib/functions.php');
12 
require('../lib/defaults.php');
13 
$date = strftime('%A, %e %B %Y, %T %Z');
14 
 
15 
if (is_file("../lib/$config[general_lib_type]/user_info.php")){
16 
	include("../lib/$config[general_lib_type]/user_info.php");
17 
	if ($user_exists == 'no'){
18 
		echo <<<EOM
907 richard 19 
<title>User information page</title>
324 richard 20 
<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">
21 
<link rel="stylesheet" href="/css/style.css">
22 
</head>
23 
<body>
24 
<center>
25 
<form action="user_admin.php" method=get>
26 
<b>User Name&nbsp;&nbsp;</b>
27 
<input type="text" size=10 name="login" value="$login">
28 
<b>&nbsp;&nbsp;does not exist</b><br>
29 
<input type=submit class=button value="Show User">
30 
</body>
31 
</html>
32 
EOM;
33 
		exit();
34 
	}
35 
}
36 
 
37 
if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))
38 
	include_once("../lib/sql/drivers/$config[sql_type]/functions.php");
39 
else{
40 
	echo <<<EOM
907 richard 41 
<title>User information page</title>
324 richard 42 
<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">
43 
<link rel="stylesheet" href="style.css">
44 
</head>
45 
<body>
46 
<center>
47 
<b>Could not include SQL library functions. Aborting</b>
48 
</body>
49 
</html>
50 
EOM;
51 
	exit();
52 
}
53 
 
1805 clement.si 54 
if(isset($item_vals['Max-Monthly-Session'][0]) && $item_vals['Max-Monthly-Session'][0] != ''){
55 
	$monthly_limit = $item_vals['Max-Monthly-Session'][0];
56 
} else if (isset($default_vals['Max-Monthly-Session'][0])){
57 
	$monthly_limit = $default_vals['Max-Monthly-Session'][0];
58 
} else {
59 
	$monthly_limit = '';
60 
}
61 
$monthly_limit = ($monthly_limit) ? $monthly_limit : $config['counter_default_monthly'];
62 
 
63 
if(isset($item_vals['Max-Weekly-Session'][0]) && $item_vals['Max-Weekly-Session'][0] != ''){
64 
	$weekly_limit = $item_vals['Max-Weekly-Session'][0];
65 
} else if (isset($default_vals['Max-Weekly-Session'][0])){
66 
	$weekly_limit = $default_vals['Max-Weekly-Session'][0];
67 
} else {
68 
	$weekly_limit = '';
69 
}
70 
$weekly_limit = ($weekly_limit) ? $weekly_limit : $config['counter_default_weekly'];
71 
 
72 
if(isset($item_vals['Max-Daily-Session'][0]) && $item_vals['Max-Daily-Session'][0] != ''){
73 
	$daily_limit = $item_vals['Max-Daily-Session'][0];
74 
} else if (isset($default_vals['Max-Daily-Session'][0])){
75 
	$daily_limit = $default_vals['Max-Daily-Session'][0];
76 
} else {
77 
	$daily_limit = '';
78 
}
79 
$daily_limit = ($daily_limit) ? $daily_limit : $config['counter_default_daily'];
80 
 
81 
if(isset($item_vals['Session-Timeout'][0]) && $item_vals['Session-Timeout'][0] != ''){
82 
	$session_limit = $item_vals['Session-Timeout'][0];
83 
} else if (isset($default_vals['Session-Timeout'][0])){
84 
	$session_limit = $default_vals['Session-Timeout'][0];
85 
} else {
86 
	$session_limit = '';
87 
}
324 richard 88 
$session_limit = ($session_limit) ? $session_limit : 'none';
1805 clement.si 89 
 
90 
if(isset($item_vals['Max-All-Session'][0]) && $item_vals['Max-All-Session'][0] != ''){
91 
	$total_limit = $item_vals['Max-All-Session'][0];
92 
} else if (isset($default_vals['Max-All-Session'][0])){
93 
	$total_limit = $default_vals['Max-All-Session'][0];
94 
} else {
95 
	$total_limit = '';
96 
}
907 richard 97 
$total_limit = ($total_limit) ? $total_limit : 'none';
1805 clement.si 98 
 
324 richard 99 
$remaining = 'unlimited time';
100 
$log_color = 'green';
101 
 
102 
$now = time();
103 
$week = $now - 604800;
104 
$now_str = date("$config[sql_date_format]",$now + 86400);
105 
$week_str = date("$config[sql_date_format]",$week);
106 
$day = date('w');
1805 clement.si 107 
$week_start = date($config['sql_date_format'],$now - ($day)*86400);
108 
$month_start = date($config['sql_date_format'],$now - date('j')*86400);
324 richard 109 
$today = $day;
110 
$now_tmp = $now;
111 
for ($i = $day; $i >-1; $i--){
1805 clement.si 112 
	$days[$i] = date($config['sql_date_format'],$now_tmp);
324 richard 113 
	$now_tmp -= 86400;
114 
}
115 
$day++;
116 
//$now -= ($day * 86400);
117 
$now -= 604800;
118 
$now += 86400;
119 
for ($i = $day; $i <= 6; $i++){
1805 clement.si 120 
	$days[$i] = date($config['sql_date_format'],$now);
324 richard 121 
//	$now -= 86400;
122 
	$now += 86400;
123 
}
124 
 
125 
$daily_used = $weekly_used = $monthly_used = $lastlog_session_time = '-';
126 
$extra_msg = '';
127 
$used = array('-','-','-','-','-','-','-');
128 
 
1805 clement.si 129 
$link = da_sql_pconnect($config);
324 richard 130 
if ($link){
1805 clement.si 131 
	$search = da_sql_query($link,$config,
324 richard 132 
	"SELECT sum(acctsessiontime) AS sum_sess_time,
133 
	sum(acctinputoctets) AS sum_in_octets,
134 
	sum(acctoutputoctets) AS sum_out_octets,
135 
	avg(acctsessiontime) AS avg_sess_time,
136 
	avg(acctinputoctets) AS avg_in_octets,
137 
	avg(acctoutputoctets) AS avg_out_octets,
138 
	COUNT(*) as counter FROM
139 
	$config[sql_accounting_table] WHERE username = '$login'
140 
	AND acctstarttime >= '$week_str' AND acctstarttime <= '$now_str';");
141 
	if ($search){
1805 clement.si 142 
		$row = da_sql_fetch_array($search,$config);
143 
		$tot_time = time2str($row['sum_sess_time']);
144 
		$tot_input = bytes2str($row['sum_in_octets']);
145 
		$tot_output = bytes2str($row['sum_out_octets']);
146 
		$avg_time = time2str($row['avg_sess_time']);
147 
		$avg_input = bytes2str($row['avg_in_octets']);
148 
		$avg_output = bytes2str($row['avg_out_octets']);
149 
		$tot_conns = $row['counter'];
324 richard 150 
	}
151 
	else
152 
		echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
1805 clement.si 153 
	$search = da_sql_query($link,$config,
324 richard 154 
	"SELECT sum(acctsessiontime) AS sum_sess_time FROM $config[sql_accounting_table] WHERE username = '$login'
155 
	AND acctstarttime >= '$week_start' AND acctstarttime <= '$now_str';");
156 
	if ($search){
1805 clement.si 157 
		$row = da_sql_fetch_array($search,$config);
158 
		$weekly_used = $row['sum_sess_time'];
324 richard 159 
	}
160 
	else
161 
		echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
1805 clement.si 162 
	if ($monthly_limit != 'none' || (isset($config['counter_monthly_calculate_usage']) && $config['counter_monthly_calculate_usage'] == 'true')){
163 
		$search = da_sql_query($link,$config,
324 richard 164 
		"SELECT sum(acctsessiontime) AS sum_sess_time FROM $config[sql_accounting_table] WHERE username = '$login'
165 
		AND acctstarttime >= '$month_start' AND acctstarttime <= '$now_str';");
166 
		if ($search){
1805 clement.si 167 
			$row = da_sql_fetch_array($search,$config);
168 
			$monthly_used = $row['sum_sess_time'];
324 richard 169 
		}
170 
		else
171 
			echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
172 
	}
1805 clement.si 173 
	$search = da_sql_query($link,$config,
324 richard 174 
	"SELECT COUNT(*) AS counter FROM $config[sql_accounting_table] WHERE username = '$login'
175 
	AND acctstoptime >= '$week_str' AND acctstoptime <= '$now_str'
176 
	AND (acctterminatecause LIKE 'Login-Incorrect%' OR
177 
	acctterminatecause LIKE 'Invalid-User%' OR
178 
	acctterminatecause LIKE 'Multiple-Logins%');");
179 
	if ($search){
1805 clement.si 180 
		$row = da_sql_fetch_array($search,$config);
181 
		$tot_badlogins = $row['counter'];
324 richard 182 
	}
183 
	else
184 
		echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
185 
	for($i = 0; $i <=6; $i++){
186 
		if ($days[$i] == '')
187 
			continue;
1805 clement.si 188 
		$search = da_sql_query($link,$config,
324 richard 189 
		"SELECT sum(acctsessiontime) AS sum_sess_time FROM $config[sql_accounting_table] WHERE
190 
		username = '$login' AND acctstoptime >= '$days[$i] 00:00:00'
191 
		AND acctstoptime <= '$days[$i] 23:59:59';");
192 
		if ($search){
1805 clement.si 193 
			$row = da_sql_fetch_array($search,$config);
194 
			$used[$i] = $row['sum_sess_time'];
324 richard 195 
			if ($daily_limit != 'none' && $used[$i] > $daily_limit)
196 
				$used[$i] = "<font color=red>" . time2str($used[$i]) . "</font>";
197 
			else
198 
				$used[$i] = time2str($used[$i]);
199 
			if ($today == $i){
1805 clement.si 200 
				$daily_used = $row['sum_sess_time'];
324 richard 201 
				if ($daily_limit != 'none'){
202 
					$remaining = $daily_limit - $daily_used;
203 
					if ($remaining <=0)
204 
						$remaining = 0;
205 
					$log_color = ($remaining) ? 'green' : 'red';
206 
					if (!$remaining)
207 
						$extra_msg = '(Out of daily quota)';
208 
				}
209 
				$daily_used = time2str($daily_used);
210 
				if ($daily_limit != 'none' && !$remaining)
211 
					$daily_used = "<font color=red>$daily_used</font>";
212 
			}
213 
		}
214 
		else
215 
			echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
216 
	}
217 
	if ($weekly_limit != 'none'){
218 
		$tmp = $weekly_limit - $weekly_used;
219 
		if ($tmp <=0){
220 
			$tmp = 0;
221 
			$extra_msg .= '(Out of weekly quota)';
222 
		}
223 
		if (!is_numeric($remaining))
224 
			$remaining = $tmp;
225 
		if ($remaining > $tmp)
226 
			$remaining = $tmp;
227 
		$log_color = ($remaining) ? 'green' : 'red';
228 
	}
229 
	$weekly_used = time2str($weekly_used);
230 
	if ($weekly_limit != 'none' && !$tmp)
231 
		$weekly_used = "<font color=red>$weekly_used</font>";
232 
 
233 
	if ($monthly_limit != 'none'){
234 
		$tmp = $monthly_limit - $monthly_used;
235 
		if ($tmp <=0){
236 
			$tmp = 0;
237 
			$extra_msg .= '(Out of monthly quota)';
238 
		}
239 
		if (!is_numeric($remaining))
240 
			$remaining = $tmp;
241 
		if ($remaining > $tmp)
242 
			$remaining = $tmp;
243 
		$log_color = ($remaining) ? 'green' : 'red';
244 
	}
1805 clement.si 245 
	if ($monthly_limit != 'none' || (isset($config['counter_monthly_calculate_usage']) && $config['counter_monthly_calculate_usage'] == 'true')){
324 richard 246 
		$monthly_used = time2str($monthly_used);
247 
		if ($monthly_limit != 'none' && !$tmp)
248 
			$monthly_used = "<font color=red>$monthly_used</font>";
249 
	}
250 
	if ($session_limit != 'none'){
251 
		if (!is_numeric($remaining))
252 
			$remaining = $session_limit;
253 
		if ($remaining > $session_limit)
254 
			$remaining = $session_limit;
255 
	}
256 
 
1805 clement.si 257 
	$search = da_sql_query($link,$config,
324 richard 258 
	"SELECT " . da_sql_limit(1,0,$config) . " * FROM $config[sql_accounting_table]
259 
	WHERE username = '$login' AND acctstoptime IS NULL " . da_sql_limit(1,1,$config) . "
260 
	 ORDER BY acctstarttime DESC " . da_sql_limit(1,2,$config). " ;");
261 
	if ($search){
1805 clement.si 262 
		if (da_sql_num_rows($search,$config)){
324 richard 263 
			$logged_now = 1;
1805 clement.si 264 
			$row = da_sql_fetch_array($search,$config);
324 richard 265 
			$lastlog_time = $row['acctstarttime'];
266 
			$lastlog_server_ip = $row['nasipaddress'];
267 
			$lastlog_server_port = $row['nasportid'];
268 
			$lastlog_session_time = date2timediv($lastlog_time,0);
269 
			if ($daily_limit != 'none'){
270 
				$remaining = $remaining - $lastlog_session_time;
271 
				if ($remaining < 0)
272 
					$remaining = 0;
1805 clement.si 273 
				$log_color = ($remaining) ? 'green' : 'red';
324 richard 274 
			}
275 
			$lastlog_session_time_jvs = 1000 * $lastlog_session_time;
276 
			$lastlog_session_time = time2strclock($lastlog_session_time);
1805 clement.si 277 
			$lastlog_client_ip = $row['framedipaddress'];
324 richard 278 
			$lastlog_server_name = @gethostbyaddr($lastlog_server_ip);
279 
			$lastlog_client_name = @gethostbyaddr($lastlog_client_ip);
280 
			$lastlog_callerid = $row['callingstationid'];
281 
			if ($lastlog_callerid == '')
282 
				$lastlog_callerid = 'not available';
283 
			$lastlog_input = $row['acctinputoctets'];
284 
			if ($lastlog_input)
285 
				$lastlog_input = bytes2str($lastlog_input);
286 
			else
287 
				$lastlog_input = 'not available';
288 
			$lastlog_output = $row['acctoutputoctets'];
289 
			if ($lastlog_output)
290 
				$lastlog_output = bytes2str($lastlog_output);
291 
			else
292 
				$lastlog_output = 'not available';
293 
		}
294 
	}
295 
	else
296 
		echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
1805 clement.si 297 
	if (!isset($logged_now) || !$logged_now){
298 
		$search = da_sql_query($link,$config,
324 richard 299 
		"SELECT " . da_sql_limit(1,0,$config) . " * FROM $config[sql_accounting_table]
300 
		WHERE username = '$login' AND acctsessiontime != '0' " . da_sql_limit(1,1,$config) . "
301 
		 ORDER BY acctstoptime DESC " . da_sql_limit(1,2,$config). " ;");
302 
		if ($search){
1805 clement.si 303 
			if (da_sql_num_rows($search,$config)){
304 
				$row = da_sql_fetch_array($search,$config);
324 richard 305 
				$lastlog_time = $row['acctstarttime'];
306 
				$lastlog_server_ip = $row['nasipaddress'];
307 
				$lastlog_server_port = $row['nasportid'];
308 
				$lastlog_session_time = time2str($row['acctsessiontime']);
1805 clement.si 309 
				$lastlog_client_ip = $row['framedipaddress'];
324 richard 310 
		$lastlog_server_name = ($lastlog_server_ip != '') ? @gethostbyaddr($lastlog_server_ip) : '-';
311 
		$lastlog_client_name = ($lastlog_client_ip != '') ? @gethostbyaddr($lastlog_client_ip) : '-';
312 
				$lastlog_callerid = $row['callingstationid'];
313 
				if ($lastlog_callerid == '')
314 
					$lastlog_callerid = 'not available';
315 
				$lastlog_input = $row['acctinputoctets'];
316 
				$lastlog_input = bytes2str($lastlog_input);
317 
				$lastlog_output = $row['acctoutputoctets'];
318 
				$lastlog_output = bytes2str($lastlog_output);
319 
			}
320 
			else
321 
				$not_known = 1;
322 
		}
323 
		else
324 
			echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
325 
	}
326 
}
327 
else
328 
	echo "<b>Could not connect to SQL database</b><br>\n";
329 
 
330 
$monthly_limit = (is_numeric($monthly_limit)) ? time2str($monthly_limit) : $monthly_limit;
331 
$weekly_limit = (is_numeric($weekly_limit)) ? time2str($weekly_limit) : $weekly_limit;
332 
$daily_limit = (is_numeric($daily_limit)) ? time2str($daily_limit) : $daily_limit;
333 
$session_limit = (is_numeric($session_limit)) ? time2str($session_limit) : $session_limit;
907 richard 334 
$total_limit = (is_numeric($total_limit)) ? time2str($total_limit) : $total_limit;
324 richard 335 
$remaining = (is_numeric($remaining)) ? time2str($remaining) : $remaining;
336 
 
1847 raphael.pi 337 
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'))
324 richard 338 
	$msg =<<<EON
907 richard 339 
<font color=red><b> $l_locked_user </b></font>
324 richard 340 
EON;
341 
else
342 
	$msg =<<<EON
907 richard 343 
$l_user_remain_login<font color="$log_color"> <b>$remaining $extra_msg</b></font>
324 richard 344 
EON;
1805 clement.si 345 
$lock_msg = (isset($item_vals['Dialup-Lock-Msg'][0])) ? $item_vals['Dialup-Lock-Msg'][0] : '';
324 richard 346 
if ($lock_msg != '')
347 
	$descr =<<<EON
348 
<font color=red><b>$lock_msg </b</font>
349 
EON;
350 
else
351 
	$descr = '-';
352 
 
1805 clement.si 353 
$expiration = isset($default_vals['Expiration'][0]) ? $default_vals['Expiration'][0] : '';
1847 raphael.pi 354 
if (isset($item_vals['Expiration'][0]))
324 richard 355 
	$expiration = $item_vals['Expiration'][0];
1847 raphael.pi 356 
 
324 richard 357 
if ($expiration != ''){
358 
	$expiration = strtotime($expiration);
359 
	if ($expiration != -1 && $expiration < time())
360 
		$descr = <<<EOM
907 richard 361 
<font color=red><b>$l_user_expired</b></font>
324 richard 362 
EOM;
363 
}
364 
 
365 
require('../html/user_admin.html.php');
366 
?>