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


<?php
require('/etc/freeradius-web/config.php');
require('../lib/functions.php');
require('../lib/sql/nas_list.php');
require_once('../lib/xlat.php');
?>
<html>
<?php
 
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>Statistiques utilisateurs</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($start) && !isset($stop)){
//if($start == '' && $stop == ''){
	$now = time();
	$stop = date($config['sql_date_format'],$now);
	$now -= 604800;
	$start = date($config['sql_date_format'],$now);
}
$start = da_sql_escape_string($link,$start);
$stop = da_sql_escape_string($link,$stop);
 
 
?>
 
<head>
<title>Statistiques utilisateurs</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
<center>
<table border=0 width=550 cellpadding=0 cellspacing=0>
<tr valign=top>
<!--<td align=center><img src="images/title2.gif"></td>-->
</tr>
</table>
 
</table>
<br>
 
<tr valign=top>
<td width=65%></td>
<td bgcolor="black" width=35%>
<TABLE width="100%" border=1 cellspacing=0 cellpadding=0>
	<tr bgcolor="#666666"align=center><td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
	<font color="white">Statistiques utilisateurs</font>&nbsp;
	<tr><th></th></tr>
 
 
 
	<tr bgcolor="#FFCC66"><td><img src="/images/pix.gif" width="1" height="2"></td></tr>
</table>
<?php
if(isset($pagesize))
{	
echo <<<EOM
De <b>$start</b> &agrave;  <b>$stop</b>
 
<p>
	<table border=1 bordercolordark=#ffffe0 bordercolorlight=#000000 width=100% cellpadding=2 cellspacing=0 bgcolor="#ffffe0" valign=top>
	<tr bgcolor="#d0ddb0">
	<th>#</th><th>Identifiant</th><th>Date</th><th>Serveur</th><th>Nombres de connections</th><th>Dur&eacute;e des connections</th><th>Upload</th><th>Download</th><th>Serveur</th>
	</tr>
EOM;
 
$pagesize = ($pagesize) ? $pagesize : 10;
 
 
$selected[5] = "";
$selected[10] = "";
$selected[15] = "";
$selected[20] = "";
$selected[40] = "";
$selected[80] = "";
$selected['all'] = "";
$selected['num'] = "";
$selected['time'] = "";
$selected['asc'] = "";
$selected['desc'] = "";
 
if (!is_numeric($pagesize) && $pagesize != 'all')
	$pagezise = 10;
if ($pagesize > 100)
	$pagesize = 100;
$limit = ($pagesize == 'all') ? '100' : "$pagesize";
$selected[$pagesize] = 'selected';
$order = ($order) ? $order : $config['general_accounting_info_order'];
if ($order != 'desc' && $order != 'asc')
	$order = 'desc';
if ($sortby != '')
	$order_attr = ($sortby == 'num') ? 'connnum' : 'conntotduration';
else
	$order_attr = 'connnum';
if ($server != '' && $server != 'all'){
	$server = da_sql_escape_string($link,$server);
	$server_str = "AND nasipaddress = '$server'";
}
else
{
	$server_str = "";
}
$login_str = ($login) ? "AND username = '$login' " : '';
 
$selected[$order] = 'selected';
$selected[$sortby] = 'selected';
 
$sql_extra_query = '';
if (isset($config['sql_accounting_extra_query'])){
	$sql_extra_query = xlat($config['sql_accounting_extra_query'],$login,$config);
	$sql_extra_query = da_sql_escape_string($link,$sql_extra_query);
}
 
unset($da_name_cache);
if (isset($_SESSION['da_name_cache']))
	$da_name_cache = $_SESSION['da_name_cache'];
 
 
 
 
$link = @da_sql_pconnect($config);
if ($link){
	$num = 0;
	$search = @da_sql_query($link,$config,
	"SELECT " . da_sql_limit($limit,0,$config) . " * FROM $config[sql_total_accounting_table]
	WHERE acctdate >= '$start' AND acctdate <= '$stop' $server_str $login_str $sql_extra_query " . da_sql_limit($limit,1,$config)
	. " ORDER BY $order_attr $order " . da_sql_limit($limit,2,$config) . " ;");
 
	if ($search){
		while( $row = @da_sql_fetch_array($search,$config) ){
			$num++;
			$acct_login = $row['username'];
			if ($acct_login == '')
				$acct_login = '-';
			else{
				$Acct_login = urlencode($acct_login);
				$acct_login = "<a href=\"user_admin.php?login=$Acct_login\" title=\"Editer l'utilisateur $acct_login\">$acct_login</a>";
			}
			$acct_time = $row['conntotduration'];
			$acct_time = time2str($acct_time);
			$acct_conn_num = $row['connnum'];
			$acct_date = $row['acctdate'];
			$acct_upload = $row['inputoctets'];
			$acct_download = $row['outputoctets'];
			$acct_upload = bytes2str($acct_upload);
			$acct_download = bytes2str($acct_download);
			if (!isset($acct_server)){
				$acct_server = @gethostbyaddr($row['nasipaddress']);
				if (!isset($da_name_cache) && $config['general_use_session'] == 'yes'){
					$da_name_cache[$row['nasipaddress']] = $acct_server;
					session_register('da_name_cache');
				}
				else
					$da_name_cache[$row['nasipaddress']] = $acct_server;
			}
			if ($acct_server == '')
				$acct_server = '-';
			echo <<<EOM
			<tr align=center bgcolor="white">
				<td>$num</td>
				<td>$acct_login</td>
				<td>$acct_date</td>
				<td>$acct_server</td>
				<td>$acct_conn_num</td>
				<td>$acct_time</td>
				<td>$acct_upload</td>
				<td>$acct_download</td>
				<td>$acct_server</td>
 
			</tr>
EOM;
		}
	}
 
}
echo <<<EOM
	</table>
<tr><td>
<hr>
EOM;
}
else
{
	//create dummy selected
	if(!isset($selected))	
	{
		$selected = array();
		$selected[5] = "";
		$selected[10] = "";
		$selected[15] = "";
		$selected[20] = "";
		$selected[40] = "";
		$selected[80] = "";
		$selected['all'] = "";
		$selected['num'] = "";
		$selected['time'] = "";
		$selected['asc'] = "";
		$selected['desc'] = "";
	}
 
 
}
echo <<<EOM
<tr><td align="left">
	<form action="user_stats.php" method="post" name="master">
	<table border=0>
		<tr valign="bottom">
			<td><small><b>date d&eacute;but</td><td><small><b>date fin</td><td><small><b>nbr./page</td><td><small><b>tri&eacute; par</td><td><small><b>class&eacute; par ordre </td>
	<tr valign="middle"><td>
<input type="hidden" name="show" value="0">
<input type="text" name="start" size="11" value="$start"></td>
<td><input type="text" name="stop" size="11" value="$stop"></td>
<td><select name="pagesize">
 
<option $selected[5] value="5" >5
<option $selected[10] value="10">10
<option $selected[15] value="15">15
<option $selected[20] value="20">20
<option $selected[40] value="40">40
<option $selected[80] value="80">80
<option $selected[all] value="all">tous
</select>
</td>
<td>
<select name="sortby">
<option $selected[num] value="num">Nombre de connexions
<option $selected[time] value="time">Dur&eacute;e des connexions
</select>
</td>
<td><select name="order">
<option $selected[asc] value="asc">croissant
<option $selected[desc] value="desc">d&eacute;croissant
</select>
</td>
EOM;
 
?>
 
<td><input type="submit" class=button value="show"></td></tr>
<tr><td>
<b>Sur le serveur d'acc&egrave;s :</b>
</td>
<td><b>Utilisateur</b></td></tr>
<tr><td>
<select name="server">
<?php
foreach ($nas_list as $nas){
	$name = $nas['name'];
	if ($nas['ip'] == '')
		continue;
	$servers[$name] = $nas[ip];
}
ksort($servers);
foreach ($servers as $name => $ip){
	if ($server == $ip)
		echo "<option selected value=\"$ip\">$name\n";
	else
		echo "<option value=\"$ip\">$name\n";
}
if (isset($server) && ($server == '' || $server == 'all'))
	echo "<option selected value=\"all\">tous\n";
else
	echo "<option value=\"all\">tous\n";
?>
</select>
</td>
<td><input type="text" name="login" size="11" value="<?php if(!isset($login)){echo "";}else{ echo $login;} ?>"></td>
</tr>
</table></td></tr></form>
</table>
</tr>
</table>
</body>
</html>
 

Rev 1831	Rev 1956
1	`<?php`	1	`<?php`
2	`require('/etc/freeradius-web/config.php');`	2	`require('/etc/freeradius-web/config.php');`
3	`require('../lib/functions.php');`	3	`require('../lib/functions.php');`
4	`require('../lib/sql/nas_list.php');`	4	`require('../lib/sql/nas_list.php');`
5	`require_once('../lib/xlat.php');`	5	`require_once('../lib/xlat.php');`
6	`?>`	6	`?>`
7	`<html>`	7	`<html>`
8	`<?php`	8	`<?php`
9		9
10	`if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))`	10	`if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))`
11	`include_once("../lib/sql/drivers/$config[sql_type]/functions.php");`	11	`include_once("../lib/sql/drivers/$config[sql_type]/functions.php");`
12	`else{`	12	`else{`
13	`echo <<<EOM`	13	`echo <<<EOM`
14	`<title>Statistiques utilisateurs</title>`	14	`<title>Statistiques utilisateurs</title>`
15	`<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">`	15	`<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">`
16	`<link rel="stylesheet" href="style.css">`	16	`<link rel="stylesheet" href="style.css">`
17	`</head>`	17	`</head>`
18	`<body>`	18	`<body>`
19	`<center>`	19	`<center>`
20	`<b>Could not include SQL library functions. Aborting</b>`	20	`<b>Could not include SQL library functions. Aborting</b>`
21	`</body>`	21	`</body>`
22	`</html>`	22	`</html>`
23	`EOM;`	23	`EOM;`
24	`exit();`	24	`exit();`
25	`}`	25	`}`
26		26
27	`if (!isset($start) && !isset($stop)){`	27	`if (!isset($start) && !isset($stop)){`
28	`//if($start == '' && $stop == ''){`	28	`//if($start == '' && $stop == ''){`
29	`$now = time();`	29	`$now = time();`
30	`$stop = date($config['sql_date_format'],$now);`	30	`$stop = date($config['sql_date_format'],$now);`
31	`$now -= 604800;`	31	`$now -= 604800;`
32	`$start = date($config['sql_date_format'],$now);`	32	`$start = date($config['sql_date_format'],$now);`
33	`}`	33	`}`
34	`$start = da_sql_escape_string($link,$start);`	34	`$start = da_sql_escape_string($link,$start);`
35	`$stop = da_sql_escape_string($link,$stop);`	35	`$stop = da_sql_escape_string($link,$stop);`
36		36
37		37
38	`?>`	38	`?>`
39		39
40	`<head>`	40	`<head>`
41	`<title>Statistiques utilisateurs</title>`	41	`<title>Statistiques utilisateurs</title>`
42	`<link rel="stylesheet" href="style.css">`	42	`<link rel="stylesheet" href="style.css">`
43	`</head>`	43	`</head>`
44	`<body>`	44	`<body>`
45	`<center>`	45	`<center>`
46	`<table border=0 width=550 cellpadding=0 cellspacing=0>`	46	`<table border=0 width=550 cellpadding=0 cellspacing=0>`
47	`<tr valign=top>`	47	`<tr valign=top>`
48	`<!--<td align=center><img src="images/title2.gif"></td>-->`	48	`<!--<td align=center><img src="images/title2.gif"></td>-->`
49	`</tr>`	49	`</tr>`
50	`</table>`	50	`</table>`
51	`<table border=0 width=400 cellpadding=0 cellspacing=2>`	-
52	`</table>`	51	`</table>`
53	`<br>`	52	`<br>`
54	`<table border=0 width=840 cellpadding=1 cellspacing=1>`	-
55	`<tr valign=top>`	53	`<tr valign=top>`
56	`<td width=65%></td>`	54	`<td width=65%></td>`
57	`<td bgcolor="black" width=35%>`	55	`<td bgcolor="black" width=35%>`
58	`<table border=0 width=100% cellpadding=2 cellspacing=0>`	56	`<TABLE width="100%" border=1 cellspacing=0 cellpadding=0>`
59	`<tr bgcolor="#907030" align=right valign=top><th>`	57	`<tr bgcolor="#666666"align=center><td>`
-		58	`<table width="100%" border="0" cellspacing="0" cellpadding="0">`
60	`<font color="white">Statistiques utilisateurs</font> `	59	`<font color="white">Statistiques utilisateurs</font> `
61	`</th></tr>`	60	`<tr><th></th></tr>`
62	`</table>`	-
63	`</td></tr>`	-
64	`<tr bgcolor="black" valign=top><td colspan=2>`	-
65	`<table border=0 width=100% cellpadding=12 cellspacing=0 bgcolor="#ffffd0" valign=top>`	61	`<tr bgcolor="#FFCC66"><td><img src="/images/pix.gif" width="1" height="2"></td></tr>`
66	`<tr><td>`	62	`</table>`
67	`<?php`	63	`<?php`
68	`if(isset($pagesize))`	64	`if(isset($pagesize))`
69	`{`	65	`{`
70	`echo <<<EOM`	66	`echo <<<EOM`
71	`De <b>$start</b> à <b>$stop</b>`	67	`De <b>$start</b> à <b>$stop</b>`
72		68
73	`<p>`	69	`<p>`
74	`<table border=1 bordercolordark=#ffffe0 bordercolorlight=#000000 width=100% cellpadding=2 cellspacing=0 bgcolor="#ffffe0" valign=top>`	70	`<table border=1 bordercolordark=#ffffe0 bordercolorlight=#000000 width=100% cellpadding=2 cellspacing=0 bgcolor="#ffffe0" valign=top>`
75	`<tr bgcolor="#d0ddb0">`	71	`<tr bgcolor="#d0ddb0">`
76	`<th>#</th><th>Identifiant</th><th>Date</th><th>Serveur</th><th>Nombres de connections</th><th>Durée des connections</th><th>Upload</th><th>Download</th><th>Serveur</th>`	72	`<th>#</th><th>Identifiant</th><th>Date</th><th>Serveur</th><th>Nombres de connections</th><th>Durée des connections</th><th>Upload</th><th>Download</th><th>Serveur</th>`
77	`</tr>`	73	`</tr>`
78	`EOM;`	74	`EOM;`
79		75
80	`$pagesize = ($pagesize) ? $pagesize : 10;`	76	`$pagesize = ($pagesize) ? $pagesize : 10;`
81		77
82		78
83	`$selected[5] = "";`	79	`$selected[5] = "";`
84	`$selected[10] = "";`	80	`$selected[10] = "";`
85	`$selected[15] = "";`	81	`$selected[15] = "";`
86	`$selected[20] = "";`	82	`$selected[20] = "";`
87	`$selected[40] = "";`	83	`$selected[40] = "";`
88	`$selected[80] = "";`	84	`$selected[80] = "";`
89	`$selected['all'] = "";`	85	`$selected['all'] = "";`
90	`$selected['num'] = "";`	86	`$selected['num'] = "";`
91	`$selected['time'] = "";`	87	`$selected['time'] = "";`
92	`$selected['asc'] = "";`	88	`$selected['asc'] = "";`
93	`$selected['desc'] = "";`	89	`$selected['desc'] = "";`
94		90
95	`if (!is_numeric($pagesize) && $pagesize != 'all')`	91	`if (!is_numeric($pagesize) && $pagesize != 'all')`
96	`$pagezise = 10;`	92	`$pagezise = 10;`
97	`if ($pagesize > 100)`	93	`if ($pagesize > 100)`
98	`$pagesize = 100;`	94	`$pagesize = 100;`
99	`$limit = ($pagesize == 'all') ? '100' : "$pagesize";`	95	`$limit = ($pagesize == 'all') ? '100' : "$pagesize";`
100	`$selected[$pagesize] = 'selected';`	96	`$selected[$pagesize] = 'selected';`
101	`$order = ($order) ? $order : $config['general_accounting_info_order'];`	97	`$order = ($order) ? $order : $config['general_accounting_info_order'];`
102	`if ($order != 'desc' && $order != 'asc')`	98	`if ($order != 'desc' && $order != 'asc')`
103	`$order = 'desc';`	99	`$order = 'desc';`
104	`if ($sortby != '')`	100	`if ($sortby != '')`
105	`$order_attr = ($sortby == 'num') ? 'connnum' : 'conntotduration';`	101	`$order_attr = ($sortby == 'num') ? 'connnum' : 'conntotduration';`
106	`else`	102	`else`
107	`$order_attr = 'connnum';`	103	`$order_attr = 'connnum';`
108	`if ($server != '' && $server != 'all'){`	104	`if ($server != '' && $server != 'all'){`
109	`$server = da_sql_escape_string($link,$server);`	105	`$server = da_sql_escape_string($link,$server);`
110	`$server_str = "AND nasipaddress = '$server'";`	106	`$server_str = "AND nasipaddress = '$server'";`
111	`}`	107	`}`
112	`else`	108	`else`
113	`{`	109	`{`
114	`$server_str = "";`	110	`$server_str = "";`
115	`}`	111	`}`
116	`$login_str = ($login) ? "AND username = '$login' " : '';`	112	`$login_str = ($login) ? "AND username = '$login' " : '';`
117		113
118	`$selected[$order] = 'selected';`	114	`$selected[$order] = 'selected';`
119	`$selected[$sortby] = 'selected';`	115	`$selected[$sortby] = 'selected';`
120		116
121	`$sql_extra_query = '';`	117	`$sql_extra_query = '';`
122	`if (isset($config['sql_accounting_extra_query'])){`	118	`if (isset($config['sql_accounting_extra_query'])){`
123	`$sql_extra_query = xlat($config['sql_accounting_extra_query'],$login,$config);`	119	`$sql_extra_query = xlat($config['sql_accounting_extra_query'],$login,$config);`
124	`$sql_extra_query = da_sql_escape_string($link,$sql_extra_query);`	120	`$sql_extra_query = da_sql_escape_string($link,$sql_extra_query);`
125	`}`	121	`}`
126		122
127	`unset($da_name_cache);`	123	`unset($da_name_cache);`
128	`if (isset($_SESSION['da_name_cache']))`	124	`if (isset($_SESSION['da_name_cache']))`
129	`$da_name_cache = $_SESSION['da_name_cache'];`	125	`$da_name_cache = $_SESSION['da_name_cache'];`
130		126
131		127
132		128
133		129
134	`$link = @da_sql_pconnect($config);`	130	`$link = @da_sql_pconnect($config);`
135	`if ($link){`	131	`if ($link){`
136	`$num = 0;`	132	`$num = 0;`
137	`$search = @da_sql_query($link,$config,`	133	`$search = @da_sql_query($link,$config,`
138	`"SELECT " . da_sql_limit($limit,0,$config) . " * FROM $config[sql_total_accounting_table]`	134	`"SELECT " . da_sql_limit($limit,0,$config) . " * FROM $config[sql_total_accounting_table]`
139	`WHERE acctdate >= '$start' AND acctdate <= '$stop' $server_str $login_str $sql_extra_query " . da_sql_limit($limit,1,$config)`	135	`WHERE acctdate >= '$start' AND acctdate <= '$stop' $server_str $login_str $sql_extra_query " . da_sql_limit($limit,1,$config)`
140	`. " ORDER BY $order_attr $order " . da_sql_limit($limit,2,$config) . " ;");`	136	`. " ORDER BY $order_attr $order " . da_sql_limit($limit,2,$config) . " ;");`
141		137
142	`if ($search){`	138	`if ($search){`
143	`while( $row = @da_sql_fetch_array($search,$config) ){`	139	`while( $row = @da_sql_fetch_array($search,$config) ){`
144	`$num++;`	140	`$num++;`
145	`$acct_login = $row['username'];`	141	`$acct_login = $row['username'];`
146	`if ($acct_login == '')`	142	`if ($acct_login == '')`
147	`$acct_login = '-';`	143	`$acct_login = '-';`
148	`else{`	144	`else{`
149	`$Acct_login = urlencode($acct_login);`	145	`$Acct_login = urlencode($acct_login);`
150	`$acct_login = "<a href=\"user_admin.php?login=$Acct_login\" title=\"Editer l'utilisateur $acct_login\">$acct_login</a>";`	146	`$acct_login = "<a href=\"user_admin.php?login=$Acct_login\" title=\"Editer l'utilisateur $acct_login\">$acct_login</a>";`
151	`}`	147	`}`
152	`$acct_time = $row['conntotduration'];`	148	`$acct_time = $row['conntotduration'];`
153	`$acct_time = time2str($acct_time);`	149	`$acct_time = time2str($acct_time);`
154	`$acct_conn_num = $row['connnum'];`	150	`$acct_conn_num = $row['connnum'];`
155	`$acct_date = $row['acctdate'];`	151	`$acct_date = $row['acctdate'];`
156	`$acct_upload = $row['inputoctets'];`	152	`$acct_upload = $row['inputoctets'];`
157	`$acct_download = $row['outputoctets'];`	153	`$acct_download = $row['outputoctets'];`
158	`$acct_upload = bytes2str($acct_upload);`	154	`$acct_upload = bytes2str($acct_upload);`
159	`$acct_download = bytes2str($acct_download);`	155	`$acct_download = bytes2str($acct_download);`
160	`if (!isset($acct_server)){`	156	`if (!isset($acct_server)){`
161	`$acct_server = @gethostbyaddr($row['nasipaddress']);`	157	`$acct_server = @gethostbyaddr($row['nasipaddress']);`
162	`if (!isset($da_name_cache) && $config['general_use_session'] == 'yes'){`	158	`if (!isset($da_name_cache) && $config['general_use_session'] == 'yes'){`
163	`$da_name_cache[$row['nasipaddress']] = $acct_server;`	159	`$da_name_cache[$row['nasipaddress']] = $acct_server;`
164	`session_register('da_name_cache');`	160	`session_register('da_name_cache');`
165	`}`	161	`}`
166	`else`	162	`else`
167	`$da_name_cache[$row['nasipaddress']] = $acct_server;`	163	`$da_name_cache[$row['nasipaddress']] = $acct_server;`
168	`}`	164	`}`
169	`if ($acct_server == '')`	165	`if ($acct_server == '')`
170	`$acct_server = '-';`	166	`$acct_server = '-';`
171	`echo <<<EOM`	167	`echo <<<EOM`
172	`<tr align=center bgcolor="white">`	168	`<tr align=center bgcolor="white">`
173	`<td>$num</td>`	169	`<td>$num</td>`
174	`<td>$acct_login</td>`	170	`<td>$acct_login</td>`
175	`<td>$acct_date</td>`	171	`<td>$acct_date</td>`
176	`<td>$acct_server</td>`	172	`<td>$acct_server</td>`
177	`<td>$acct_conn_num</td>`	173	`<td>$acct_conn_num</td>`
178	`<td>$acct_time</td>`	174	`<td>$acct_time</td>`
179	`<td>$acct_upload</td>`	175	`<td>$acct_upload</td>`
180	`<td>$acct_download</td>`	176	`<td>$acct_download</td>`
181	`<td>$acct_server</td>`	177	`<td>$acct_server</td>`
182		178
183	`</tr>`	179	`</tr>`
184	`EOM;`	180	`EOM;`
185	`}`	181	`}`
186	`}`	182	`}`
187		183
188	`}`	184	`}`
189	`echo <<<EOM`	185	`echo <<<EOM`
190	`</table>`	186	`</table>`
191	`<tr><td>`	187	`<tr><td>`
192	`<hr>`	188	`<hr>`
193	`EOM;`	189	`EOM;`
194	`}`	190	`}`
195	`else`	191	`else`
196	`{`	192	`{`
197	`//create dummy selected`	193	`//create dummy selected`
198	`if(!isset($selected))`	194	`if(!isset($selected))`
199	`{`	195	`{`
200	`$selected = array();`	196	`$selected = array();`
201	`$selected[5] = "";`	197	`$selected[5] = "";`
202	`$selected[10] = "";`	198	`$selected[10] = "";`
203	`$selected[15] = "";`	199	`$selected[15] = "";`
204	`$selected[20] = "";`	200	`$selected[20] = "";`
205	`$selected[40] = "";`	201	`$selected[40] = "";`
206	`$selected[80] = "";`	202	`$selected[80] = "";`
207	`$selected['all'] = "";`	203	`$selected['all'] = "";`
208	`$selected['num'] = "";`	204	`$selected['num'] = "";`
209	`$selected['time'] = "";`	205	`$selected['time'] = "";`
210	`$selected['asc'] = "";`	206	`$selected['asc'] = "";`
211	`$selected['desc'] = "";`	207	`$selected['desc'] = "";`
212	`}`	208	`}`
213		209
214		210
215	`}`	211	`}`
216	`echo <<<EOM`	212	`echo <<<EOM`
217	`<tr><td align="left">`	213	`<tr><td align="left">`
218	`<form action="user_stats.php" method="post" name="master">`	214	`<form action="user_stats.php" method="post" name="master">`
219	`<table border=0>`	215	`<table border=0>`
220	`<tr valign="bottom">`	216	`<tr valign="bottom">`
221	`<td><small><b>date début</td><td><small><b>date fin</td><td><small><b>nbr./page</td><td><small><b>trié par</td><td><small><b>classé par ordre </td>`	217	`<td><small><b>date début</td><td><small><b>date fin</td><td><small><b>nbr./page</td><td><small><b>trié par</td><td><small><b>classé par ordre </td>`
222	`<tr valign="middle"><td>`	218	`<tr valign="middle"><td>`
223	`<input type="hidden" name="show" value="0">`	219	`<input type="hidden" name="show" value="0">`
224	`<input type="text" name="start" size="11" value="$start"></td>`	220	`<input type="text" name="start" size="11" value="$start"></td>`
225	`<td><input type="text" name="stop" size="11" value="$stop"></td>`	221	`<td><input type="text" name="stop" size="11" value="$stop"></td>`
226	`<td><select name="pagesize">`	222	`<td><select name="pagesize">`
227		223
228	`<option $selected[5] value="5" >5`	224	`<option $selected[5] value="5" >5`
229	`<option $selected[10] value="10">10`	225	`<option $selected[10] value="10">10`
230	`<option $selected[15] value="15">15`	226	`<option $selected[15] value="15">15`
231	`<option $selected[20] value="20">20`	227	`<option $selected[20] value="20">20`
232	`<option $selected[40] value="40">40`	228	`<option $selected[40] value="40">40`
233	`<option $selected[80] value="80">80`	229	`<option $selected[80] value="80">80`
234	`<option $selected[all] value="all">tous`	230	`<option $selected[all] value="all">tous`
235	`</select>`	231	`</select>`
236	`</td>`	232	`</td>`
237	`<td>`	233	`<td>`
238	`<select name="sortby">`	234	`<select name="sortby">`
239	`<option $selected[num] value="num">Nombre de connexions`	235	`<option $selected[num] value="num">Nombre de connexions`
240	`<option $selected[time] value="time">Durée des connexions`	236	`<option $selected[time] value="time">Durée des connexions`
241	`</select>`	237	`</select>`
242	`</td>`	238	`</td>`
243	`<td><select name="order">`	239	`<td><select name="order">`
244	`<option $selected[asc] value="asc">croissant`	240	`<option $selected[asc] value="asc">croissant`
245	`<option $selected[desc] value="desc">décroissant`	241	`<option $selected[desc] value="desc">décroissant`
246	`</select>`	242	`</select>`
247	`</td>`	243	`</td>`
248	`EOM;`	244	`EOM;`
249		245
250	`?>`	246	`?>`
251		247
252	`<td><input type="submit" class=button value="show"></td></tr>`	248	`<td><input type="submit" class=button value="show"></td></tr>`
253	`<tr><td>`	249	`<tr><td>`
254	`<b>Sur le serveur d'accès :</b>`	250	`<b>Sur le serveur d'accès :</b>`
255	`</td>`	251	`</td>`
256	`<td><b>Utilisateur</b></td></tr>`	252	`<td><b>Utilisateur</b></td></tr>`
257	`<tr><td>`	253	`<tr><td>`
258	`<select name="server">`	254	`<select name="server">`
259	`<?php`	255	`<?php`
260	`foreach ($nas_list as $nas){`	256	`foreach ($nas_list as $nas){`
261	`$name = $nas['name'];`	257	`$name = $nas['name'];`
262	`if ($nas['ip'] == '')`	258	`if ($nas['ip'] == '')`
263	`continue;`	259	`continue;`
264	`$servers[$name] = $nas[ip];`	260	`$servers[$name] = $nas[ip];`
265	`}`	261	`}`
266	`ksort($servers);`	262	`ksort($servers);`
267	`foreach ($servers as $name => $ip){`	263	`foreach ($servers as $name => $ip){`
268	`if ($server == $ip)`	264	`if ($server == $ip)`
269	`echo "<option selected value=\"$ip\">$name\n";`	265	`echo "<option selected value=\"$ip\">$name\n";`
270	`else`	266	`else`
271	`echo "<option value=\"$ip\">$name\n";`	267	`echo "<option value=\"$ip\">$name\n";`
272	`}`	268	`}`
273	`if (isset($server) && ($server == '' \|\| $server == 'all'))`	269	`if (isset($server) && ($server == '' \|\| $server == 'all'))`
274	`echo "<option selected value=\"all\">tous\n";`	270	`echo "<option selected value=\"all\">tous\n";`
275	`else`	271	`else`
276	`echo "<option value=\"all\">tous\n";`	272	`echo "<option value=\"all\">tous\n";`
277	`?>`	273	`?>`
278	`</select>`	274	`</select>`
279	`</td>`	275	`</td>`
280	`<td><input type="text" name="login" size="11" value="<?php if(!isset($login)){echo "";}else{ echo $login;} ?>"></td>`	276	`<td><input type="text" name="login" size="11" value="<?php if(!isset($login)){echo "";}else{ echo $login;} ?>"></td>`
281	`</tr>`	277	`</tr>`
282	`</table></td></tr></form>`	278	`</table></td></tr></form>`
283	`</table>`	279	`</table>`
284	`</tr>`	280	`</tr>`
285	`</table>`	281	`</table>`
286	`</body>`	282	`</body>`
287	`</html>`	283	`</html>`
288		284

Subversion Repositories ALCASAR

(root)/web/acc/manager/htdocs/user_stats.php – Rev 1831 → 1956