Subversion Repositories ALCASAR

Rev

Rev 907 | Rev 1847 | 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
 
337
if ($item_vals['Dialup-Access'][0] == 'FALSE' || (!isset($item_vals['Dialup-Access'][0]) && $attrmap['Dialup-Access'] != '' && $attrmap['Dialup-Access'] != 'none'))
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] : '';
324 richard 354
if ($item_vals['Expiration'][0] != '')
355
	$expiration = $item_vals['Expiration'][0];
356
if ($expiration != ''){
357
	$expiration = strtotime($expiration);
358
	if ($expiration != -1 && $expiration < time())
359
		$descr = <<<EOM
907 richard 360
<font color=red><b>$l_user_expired</b></font>
324 richard 361
EOM;
362
}
363
 
364
require('../html/user_admin.html.php');
365
?>