Subversion Repositories ALCASAR

Rev

Rev 907 | Rev 1847 | Go to most recent revision | Only display areas with differences | Regard whitespace | Details | Blame | Last modification | View Log

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