/web/acc/manager/htdocs/accounting.php |
---|
28,15 → 28,15 |
if ($config['sql_type'] == 'pg'){ |
$operators=array( '=','<', '>', '<=', '>=', '~', 'like', '~*', '~~*', '<<=' ); |
} |
$link = da_sql_pconnect ($config) or die('cannot connect to sql databse'); |
$fields = da_sql_list_fields($config[sql_accounting_table],$link,$config); |
$no_fields = da_sql_num_fields($fields,$config); |
$fields = da_sql_list_fields($config['sql_accounting_table'],$link,$config); |
unset($items); |
for($i=0;$i<$no_fields;$i++){ |
$key = strtolower(da_sql_field_name($fields,$i,$config)); |
while($row = $fields->fetch_array()) |
{ |
$key = strtolower($row[0]); |
$val = $sql_attrs[$key]['desc']; |
if ($val == '') |
continue; |
120,6 → 120,10 |
<TABLE width="100%" border="1" cellspacing="0" cellpadding="1"> |
<tr><td> |
<?php |
if(!isset($queryflag)) |
{ |
$queryflag = 0; |
} |
if(!$queryflag) { |
echo <<<EOM |
<form method=post> |
178,7 → 182,7 |
$number=1; |
$offset=0; |
while (${"item_of_w$number"}) { |
while (isset(${"item_of_w$number"}) && ${"item_of_w$number"}) { |
if(${"delete_w$number"}==1) {$offset=1;$number++;} |
else { |
$designator=$number-$offset; |
188,7 → 192,7 |
$number++; |
} |
} |
if($add==1) { |
if(isset($add) && $add==1) { |
${"w$number"} = new Qi("w$number","$item_name","$operators[0]"); |
${"w$number"}->show(); |
} |
211,8 → 215,10 |
} |
if ($queryflag == 1){ |
if(!isset($where)) |
$where = ""; |
$i = 1; |
while (${"item_of_w$i"}){ |
while (isset(${"item_of_w$i"}) && ${"item_of_w$i"}){ |
$op_found = 0; |
foreach ($operators as $operator){ |
if (${"operator_of_w$i"} == $operator){ |
223,7 → 229,7 |
if (!$op_found) |
die("L'opération demandé n'est pas valide. Sortie anormale."); |
${"item_of_w$i"} = preg_replace('/\s/','',${"item_of_w$i"}); |
${"value_of_w$i"} = da_sql_escape_string(${"value_of_w$i"}); |
${"value_of_w$i"} = da_sql_escape_string($link,${"value_of_w$i"}); |
$where .= ($i == 1) ? ' WHERE ' . ${"item_of_w$i"} . ' ' . ${"operator_of_w$i"} . " '" . ${"value_of_w$i"} . "'" : |
' AND ' . ${"item_of_w$i"} . ' ' . ${"operator_of_w$i"} . " '" . ${"value_of_w$i"} . "'" ; |
$i++; |
237,14 → 243,25 |
if (!is_numeric($maxresults)) |
die("Max Results is not in numeric form. Exiting abnormally."); |
unset($query_view); |
$query_view = ''; |
foreach ($accounting_show_attrs as $val) |
$query_view .= $val . ','; |
$query_view = ereg_replace(',$','',$query_view); |
unset($sql_extra_query); |
if ($config[sql_accounting_extra_query] != '') |
$sql_extra_query = xlat($config[sql_accounting_extra_query],$login,$config); |
$sql_extra_query = da_sql_escape_string($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); |
} |
else |
{ |
$sql_extra_query = ""; |
} |
if(!isset($where)) |
{ |
$where = ""; |
} |
$query="SELECT " . da_sql_limit($maxresults,0,$config) . " $query_view FROM $config[sql_accounting_table] |
$where $sql_extra_query " . da_sql_limit($maxresults,1,$config) . |
" ORDER BY $order DESC " . da_sql_limit($maxresults,2,$config) . ";"; |
257,8 → 274,14 |
<tr bgcolor="#d0ddb0"> |
</tr> |
EOM; |
foreach($accounting_show_attrs as $val){ |
$desc = $sql_attrs[$val][desc]; |
$desc = $sql_attrs[$val]['desc']; |
if($val == 'acctoutputoctets') |
$desc = "Upload"; |
if($val == 'acctinputoctets') |
$desc = "Download"; |
echo "<th>$desc</th>\n"; |
} |
echo "</tr>\n"; |
266,13 → 289,16 |
$search = da_sql_query($link,$config,$query); |
if ($search){ |
while( $row = da_sql_fetch_array($search,$config) ){ |
$num++; |
//$num++; |
echo "<tr align=center>\n"; |
foreach($accounting_show_attrs as $val){ |
$info = $row[$val]; |
if($val == "acctoutputoctets" || $val == "acctinputoctets") |
$info = bytes2str($info); |
if($val == "acctsessiontime") |
$info = time2strclock($info); |
if ($info == '') |
$info = '-'; |
$info = $sql_attrs[$val][func]($info); |
if ($val == 'username'){ |
$Info = urlencode($info); |
$info = "<a href=\"user_admin.php?login=$Info\" title=\"Edit user $info\">$info<a/>"; |
/web/acc/manager/htdocs/badusers.php |
---|
26,8 → 26,8 |
$now_str = ($now_str != '') ? "$now_str" : date($config[sql_date_format],$now + 86400); |
$prev_str = ($prev_str != '') ? "$prev_str" : "0001-01-01 00:00:00"; |
$now_str = da_sql_escape_string($now_str); |
$prev_str = da_sql_escape_string($prev_str); |
$now_str = da_sql_escape_string($link,$now_str); |
$prev_str = da_sql_escape_string($link,$prev_str); |
$num = 0; |
$pagesize = ($pagesize) ? $pagesize : 10; |
139,7 → 139,7 |
<?php |
$auth_user = $_SERVER["PHP_AUTH_USER"]; |
if ($config[general_restrict_badusers_access] == 'yes'){ |
$auth_user = da_sql_escape_string($auth_user); |
$auth_user = da_sql_escape_string($link,$auth_user); |
$extra_query = "AND admin == '$auth_user'"; |
} |
$link = da_sql_pconnect($config); |
/web/acc/manager/htdocs/failed_logins.php |
---|
33,8 → 33,8 |
$now_str = date($config[sql_full_date_format],$now); |
$prev_str = date($config[sql_full_date_format],$start); |
$now_str = da_sql_escape_string($now_str); |
$prev_str = da_sql_escape_string($prev_str); |
$now_str = da_sql_escape_string($link,$now_str); |
$prev_str = da_sql_escape_string($link,$prev_str); |
$pagesize = ($pagesize) ? $pagesize : 10; |
if (!is_numeric($pagesize) && $pagesize != 'all') |
46,11 → 46,11 |
$order = 'desc'; |
$selected[$order] = 'selected'; |
if ($callerid != ''){ |
$callerid = da_sql_escape_string($callerid); |
$callerid = da_sql_escape_string($link,$callerid); |
$callerid_str = "AND callingstationid = '$callerid'"; |
} |
if ($server != '' && $server != 'all'){ |
$server = da_sql_escape_string($server); |
$server = da_sql_escape_string($link,$server); |
$server_str = "AND nasipaddress = '$server'"; |
} |
106,7 → 106,7 |
unset($sql_extra_query); |
if ($config[sql_accounting_extra_query] != ''){ |
$sql_extra_query = xlat($config[sql_accounting_extra_query],$login,$config); |
$sql_extra_query = da_sql_escape_string($sql_extra_query); |
$sql_extra_query = da_sql_escape_string($link,$sql_extra_query); |
} |
?> |
</tr> |
/web/acc/manager/htdocs/find.php |
---|
95,7 → 95,7 |
<a href="clear_opensessions.php?login=$User" title="$l_open_sessions"><img src=/images/state_ok.gif></a> |
<a href="user_delete.php?login=$User" title="$l_remove"><img src=/images/state_error.gif></a></td><td> |
EOM; |
if (isset($member_groups)) foreach ($member_groups as $group) { $msg .= "$group";} |
if (isset($member_groups)) foreach ($member_groups as $group) { $msg .= "$group ";} |
else $msg .= " "; |
$msg .= "</td>"; |
} |
/web/acc/manager/htdocs/import_user.php |
---|
162,8 → 162,8 |
{ |
$password = GenPassword(); |
} |
$login = da_sql_escape_string($login); |
$passwd = da_sql_escape_string($passwd); |
$login = da_sql_escape_string($link,$login); |
$passwd = da_sql_escape_string($link,$passwd); |
$passwd = da_encrypt($password); |
// insertion (login + password) dans la table "radcheck" (si l'usager existe --> changement de mot de passe) |
$res = @da_sql_query($link,$config,"INSERT INTO $config[sql_check_table] (attribute,value,username $text) VALUES ('$config[sql_password_attribute]','$passwd','$login' $passwd_op);"); |
199,7 → 199,7 |
echo "<b>Could not add user information in user info table: " . da_sql_error($link,$config) . "</b><br>\n"; |
if ($group != '') |
{ |
$group = da_sql_escape_string($group); |
$group = da_sql_escape_string($link,$group); |
$res = @da_sql_query($link,$config,"SELECT username FROM $config[sql_usergroup_table] WHERE username = '$login' AND groupname = '$group';"); |
if ($res) |
{ |
/web/acc/manager/htdocs/stats.php |
---|
30,30 → 30,37 |
$date = strftime('%A, %e %B %Y, %T %Z'); |
$now = time(); |
if ($before == '') |
$before = date($config[sql_date_format], $now + 86400); |
$after = ($after != '') ? "$after" : date($config[sql_date_format], $now - 604800 ); |
$after_time = date2time($after); |
$before_time = date2time($before); |
if (!isset($before)) |
{ |
$before = date($config['sql_date_format'], $now + 86400); |
} |
if (!isset($after)) |
{ |
$after = date($config['sql_date_format'], $now - 604800 ); |
} |
$after_time = strtotime($after); |
$before_time = strtotime($before); |
$days[0] = $after; |
$counter = $after_time + 86400; |
$i = 1; |
while($counter < $before_time){ |
$days[$i++] = date($config[sql_date_format],$counter); |
$days[$i++] = date($config['sql_date_format'],$counter); |
$counter += 86400; |
} |
$days[$i] = $before; |
$num_days = $i; |
$column1 = ($column1 != '') ? "$column1" : 'sessions'; |
$column2 = ($column2 != '') ? "$column2" : 'usage'; |
$column3 = ($column3 != '') ? "$column3" : 'download'; |
$column1 = (isset($column1)) ? "$column1" : 'sessions'; |
$column[1] = "$column1"; |
$selected1["$column1"] = 'selected'; |
$column2 = (isset($column2)) ? "$column2" : 'usage'; |
$column[2] = "$column2"; |
$selected2["$column2"] = 'selected'; |
$column3 = (isset($column3)) ? "$column3" : 'download'; |
$column[3] = "$column3"; |
$selected1["$column1"] = 'selected'; |
$selected2["$column2"] = 'selected'; |
$selected3["$column3"] = 'selected'; |
$message['sessions'] = 'sessions'; |
61,7 → 68,7 |
$message['usage'] = 'temps d\'utilisation total '; |
$message['upload'] = 'uploads'; |
$message['download'] = 'downloads'; |
if ($config[general_stats_use_totacct] == 'yes'){ |
if ($config['general_stats_use_totacct'] == 'yes'){ |
$sql_val['sessions'] = 'connnum'; |
$sql_val['usage'] = 'conntotduration'; |
$sql_val['upload'] = 'inputoctets'; |
72,38 → 79,57 |
$sql_val['upload'] = 'acctinputoctets'; |
$sql_val['download'] = 'acctoutputoctets'; |
} |
$fun['sessions'] = nothing; |
$fun['usage'] = time2strclock; |
$fun['upload'] = bytes2str; |
$fun['download'] = bytes2str; |
$sql_val['user'] = ($login == '') ? "WHERE username LIKE '%'" : "WHERE username = '$login'"; |
$fun['sessions'] = 'nothing'; |
$fun['usage'] = 'time2strclock'; |
$fun['upload'] = 'bytes2str'; |
$fun['download'] = 'bytes2str'; |
$sql_val['user'] = (!isset($login) || $login == '' ) ? "WHERE username LIKE '%'" : "WHERE username = '$login'"; |
for ($j = 1; $j <= 3; $j++){ |
$tmp = "{$sql_val[$column[$j]]}"; |
$res[$j] = ($tmp == "") ? "COUNT(radacctid) AS res_$j" : "sum($tmp) AS res_$j"; |
$res[$j] = (!isset($tmp)) ? "COUNT(radacctid) AS res_$j" : "sum($tmp) AS res_$j"; |
} |
$i = 1; |
$servers[all] = 'all'; |
$servers['all'] = 'all'; |
foreach ($nas_list as $nas){ |
$name = $nas[name]; |
if ($nas[ip] == '') |
$name = $nas['name']; |
if ($nas['ip'] == '') |
continue; |
$servers[$name] = $nas[ip]; |
$servers[$name] = $nas['ip']; |
$i++; |
} |
ksort($servers); |
if ($server != 'all' && $server != ''){ |
$server = da_sql_escape_string($server); |
$s = "AND nasipaddress = '$server'"; |
if(isset($server)) |
{ |
if ($server != 'all' && $server != ''){ |
$server = da_sql_escape_string($link,$server); |
$s = "AND nasipaddress = '$server'"; |
} |
} |
$sql_extra_query = ''; |
if ($config[sql_accounting_extra_query] != '') |
$sql_extra_query = xlat($config[sql_accounting_extra_query],$login,$config); |
if (isset($config['sql_accounting_extra_query'])) |
{ |
$sql_extra_query = xlat($config['sql_accounting_extra_query'],$login,$config); |
} |
else |
{ |
$sql_extra_query = ""; |
} |
$link = @da_sql_pconnect($config); |
if ($link){ |
if ($link) |
{ |
$data['sum'] = array(); |
$data['sum'][1] = ""; |
$data['sum'][2] = ""; |
$data['sum'][3] = ""; |
$stats_num[1] = ""; |
$stats_num[2] = ""; |
$stats_num[3] = ""; |
for ($i = $num_days;$i > -1; $i--){ |
$day = "$days[$i]"; |
if ($config[general_stats_use_totacct] == 'yes') |
if ($config['general_stats_use_totacct'] == 'yes') |
$search = @da_sql_query($link,$config, |
"SELECT $res[1],$res[2],$res[3] FROM $config[sql_total_accounting_table] |
$sql_val[user] AND acctdate = '$day' $s $sql_extra_query;"); |
114,14 → 140,14 |
AND acctstoptime <= '$day 23:59:59' $s $sql_extra_query;"); |
if ($search){ |
$row = @da_sql_fetch_array($search,$config); |
$data[$day][1] = $row[res_1]; |
$data[sum][1] += $row[res_1]; |
$data[$day][1] = $row['res_1']; |
$data['sum'][1] += $row['res_1']; |
$stats_num[1] = ($data[$day][1]) ? $stats_num[1] + 1 : $stats_num[1]; |
$data[$day][2] = $row[res_2]; |
$data[sum][2] += $row[res_2]; |
$data[$day][2] = $row['res_2']; |
$data['sum'][2] += $row['res_2']; |
$stats_num[2] = ($data[$day][2]) ? $stats_num[2] + 1 : $stats_num[2]; |
$data[$day][3] = $row[res_3]; |
$data[sum][3] += $row[res_3]; |
$data[$day][3] = $row['res_3']; |
$data['sum'][3] += $row['res_3']; |
$stats_num[3] = ($data[$day][3]) ? $stats_num[3] + 1 : $stats_num[3]; |
} |
else |
147,6 → 173,10 |
$data['sum'][2] = $fun[$column[2]]($data['sum'][2]); |
$data['sum'][3] = $fun[$column[3]]($data['sum'][3]); |
$max[1] = 0; |
$max[2] = 0; |
$max[3] = 0; |
for ($i = 0; $i <= $num_days; $i++){ |
$day = "$days[$i]"; |
$max[1] = ($max[1] > $data[$day][1] ) ? $max[1] : $data[$day][1]; |
178,9 → 208,9 |
$data[$day][3] = $fun[$column[3]]($data[$day][3]); |
} |
$data[max][1] = $fun[$column[1]]($max[1]); |
$data[max][2] = $fun[$column[2]]($max[2]); |
$data[max][3] = $fun[$column[3]]($max[3]); |
$data['max'][1] = $fun[$column[1]]($max[1]); |
$data['max'][2] = $fun[$column[2]]($max[2]); |
$data['max'][3] = $fun[$column[3]]($max[3]); |
require('../html/stats.html.php'); |
?> |
/web/acc/manager/htdocs/ticket_voucher.php |
---|
125,8 → 125,7 |
// création des données uniques |
$login = GenRandUsersName(); |
$passwd = GenPassword(); |
$login = da_sql_escape_string($login); |
$passwd = da_sql_escape_string($passwd); |
// création des variables d'impression |
$login_imp = $login; |
$passwd1_imp = $passwd; |
/web/acc/manager/htdocs/user_accounting.php |
---|
56,8 → 56,6 |
$link = da_sql_pconnect($config); |
$now_str = da_sql_escape_string($link, $now_str); |
$prev_str = da_sql_escape_string($link, $prev_str); |
//$now_str = da_sql_escape_string($now_str); |
//$prev_str = da_sql_escape_string($prev_str); |
unset($da_name_cache); |
if (isset($_SESSION['da_name_cache'])) |
/web/acc/manager/htdocs/user_edit.php |
---|
397,12 → 397,16 |
</td> |
<td> |
EOM; |
if (isset($member_groups)){ |
echo "<select size=5 name=\"edited_groups[]\" multiple OnChange=\"this.form.group_change.value=1\">"; |
if (isset($member_groups)){ |
echo "<select size=5 name=\"edited_groups[]\" OnChange=\"this.form.group_change.value=1\">"; |
if ($config['sql_show_all_groups'] == 'true'){ |
foreach ($existing_groups as $group => $count){ |
if ($member_groups[$group] == $group) |
if (isset($member_groups[$group]) && ($member_groups[$group] == $group)) |
echo "<option selected value=\"$group\">$group\n"; |
else if(isset($member_groups[0]) && ($member_groups[0] == $group)) |
echo "<option selected value=\"$group\">$group\n"; |
else |
echo "<option value=\"$group\">$group\n"; |
} |
413,7 → 417,7 |
echo "</select></td></tr>"; |
} |
else{ |
echo "aucun group</td></tr>"; |
echo "Aucun groupe</td></tr>"; |
} |
} |
echo "</table><br>"; |
/web/acc/manager/htdocs/user_finger.php |
---|
43,7 → 43,7 |
$sql_extra_query = ''; |
if ($config[sql_accounting_extra_query] != ''){ |
$sql_extra_query = xlat($config[sql_accounting_extra_query],$login,$config); |
$sql_extra_query = da_sql_escape_string($sql_extra_query); |
$sql_extra_query = da_sql_escape_string($link,$sql_extra_query); |
} |
$link = @da_sql_pconnect($config); |
/web/acc/manager/htdocs/user_stats.php |
---|
24,47 → 24,17 |
exit(); |
} |
if ($start == '' && $stop == ''){ |
if (!isset($start) && !isset($stop)){ |
//if($start == '' && $stop == ''){ |
$now = time(); |
$stop = date($config[sql_date_format],$now); |
$stop = date($config['sql_date_format'],$now); |
$now -= 604800; |
$start = date($config[sql_date_format],$now); |
$start = date($config['sql_date_format'],$now); |
} |
$start = da_sql_escape_string($start); |
$stop = da_sql_escape_string($stop); |
$pagesize = ($pagesize) ? $pagesize : 10; |
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($server); |
$server_str = "AND nasipaddress = '$server'"; |
} |
$login_str = ($login) ? "AND username = '$login' " : ''; |
$start = da_sql_escape_string($link,$start); |
$stop = da_sql_escape_string($link,$stop); |
$selected[$order] = 'selected'; |
$selected[$sortby] = 'selected'; |
$sql_extra_query = ''; |
if ($config[sql_accounting_extra_query] != ''){ |
$sql_extra_query = xlat($config[sql_accounting_extra_query],$login,$config); |
$sql_extra_query = da_sql_escape_string($sql_extra_query); |
} |
unset($da_name_cache); |
if (isset($_SESSION['da_name_cache'])) |
$da_name_cache = $_SESSION['da_name_cache']; |
?> |
<head> |
95,20 → 65,75 |
<table border=0 width=100% cellpadding=12 cellspacing=0 bgcolor="#ffffd0" valign=top> |
<tr><td> |
<?php |
if(isset($pagesize)) |
{ |
echo <<<EOM |
De <b>$start</b> à <b>$stop</b> |
EOM; |
?> |
<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ée des connections</th><th>Upload</th><th>Download</th> |
<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> |
</tr> |
EOM; |
<?php |
$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) |
117,7 → 142,7 |
if ($search){ |
while( $row = @da_sql_fetch_array($search,$config) ){ |
$num++; |
$acct_login = $row[username]; |
$acct_login = $row['username']; |
if ($acct_login == '') |
$acct_login = '-'; |
else{ |
124,23 → 149,22 |
$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 = $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_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); |
$acct_server = $da_name_cache[$row[nasipaddress]]; |
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; |
$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; |
$da_name_cache[$row['nasipaddress']] = $acct_server; |
} |
if ($acct_server == '') |
$acct_server = '-'; |
154,15 → 178,42 |
<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> |
173,7 → 224,8 |
<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" >05 |
<option $selected[5] value="5" >5 |
<option $selected[10] value="10">10 |
<option $selected[15] value="15">15 |
<option $selected[20] value="20">20 |
194,6 → 246,7 |
</select> |
</td> |
EOM; |
?> |
<td><input type="submit" class=button value="show"></td></tr> |
205,8 → 258,8 |
<select name="server"> |
<?php |
foreach ($nas_list as $nas){ |
$name = $nas[name]; |
if ($nas[ip] == '') |
$name = $nas['name']; |
if ($nas['ip'] == '') |
continue; |
$servers[$name] = $nas[ip]; |
} |
217,7 → 270,7 |
else |
echo "<option value=\"$ip\">$name\n"; |
} |
if ($server == '' || $server == 'all') |
if (isset($server) && ($server == '' || $server == 'all')) |
echo "<option selected value=\"all\">tous\n"; |
else |
echo "<option value=\"all\">tous\n"; |
224,7 → 277,7 |
?> |
</select> |
</td> |
<td><input type="text" name="login" size="11" value="<?php echo $login ?>"></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> |