0,0 → 1,236 |
<?php |
require('/etc/freeradius-web/config.php'); |
require('../lib/attrshow.php'); |
require('../lib/sql/nas_list.php'); |
if (!isset($usage_summary)){ |
echo <<<EOM |
<html> |
<head> |
<META HTTP-EQUIV="Refresh" CONTENT="50"> |
<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]"> |
<title>Usagers connectées</title> |
<link rel="stylesheet" href="/css/style.css"> |
</head> |
EOM; |
} |
|
if ($config[general_decode_normal_attributes] == 'yes'){ |
if (is_file("../lib/lang/$config[general_prefered_lang]/utf8.php")) |
include_once("../lib/lang/$config[general_prefered_lang]/utf8.php"); |
else |
include_once('../lib/lang/default/utf8.php'); |
$k = init_decoder(); |
$decode_normal = 1; |
} |
require_once('../lib/functions.php'); |
require("../lib/$config[general_lib_type]/functions.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 |
<body> |
<center> |
<b>Could not include SQL library functions. Aborting</b> |
</body> |
</html> |
EOM; |
exit(); |
} |
setlocale (LC_ALL, 'fr_FR'); |
$date = strftime('%A, %e %B %Y, %T %Z'); |
|
$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); |
} |
|
$link = @da_sql_pconnect($config); |
$link2 = connect2db($config); |
$tot_in = $tot_rem = 0; |
if ($link){ |
$h = 21; |
$servers_num = 0; |
if ($config[general_ld_library_path] != '') |
putenv("LD_LIBRARY_PATH=$config[general_ld_library_path]"); |
foreach($nas_list as $nas){ |
$j = 0; |
$num = 0; |
|
if ($server != ''){ |
if ($nas[name] == $server) |
$servers_num++; |
else |
continue; |
} |
else |
$servers_num++; |
if ($nas[ip] == '') |
continue; |
$name_data = $nas[ip]; |
$community_data = $nas[community]; |
$server_name[$servers_num] = $nas[name]; |
$server_model[$servers_num] = $nas[model]; |
$extra = ""; |
$finger_type = $config[general_finger_type]; |
if ($nas[finger_type] != '') |
$finger_type = $nas[finger_type]; |
if ($finger_type == 'snmp'){ |
$nas_type = ($nas[type] != '') ? $nas[type] : $config[general_nas_type]; |
if ($nas_type == '') |
$nas_type = 'cisco'; |
|
$users=exec("$config[general_snmpfinger_bin] $name_data $community_data $nas_type"); |
if (strlen($users)){ |
$extra = "AND username IN ($users)"; |
if ($config[general_strip_realms] == 'yes'){ |
if ($config[general_realm_format] == 'prefix') |
$match = "'[^']+" . $config[general_realm_delimiter]; |
else |
$match = $config[general_realm_delimiter] . "[^']+'"; |
$extra = preg_replace("/$match/","'",$extra); |
} |
} |
} |
$search = @da_sql_query($link,$config, |
"SELECT COUNT(*) AS onlineusers FROM $config[sql_accounting_table] WHERE |
acctstoptime IS NULL AND nasipaddress = '$name_data' $extra $sql_extra_query;"); |
if ($search){ |
if (($row = @da_sql_fetch_array($search,$config))) |
$num = $row[onlineusers]; |
} |
$search = @da_sql_query($link,$config, |
"SELECT DISTINCT username,acctstarttime,framedipaddress,callingstationid |
FROM $config[sql_accounting_table] WHERE |
acctstoptime IS NULL AND nasipaddress = '$name_data' $extra $sql_extra_query |
GROUP BY username,acctstarttime,framedipaddress,callingstationid |
ORDER BY acctstarttime;"); |
if ($search){ |
$now = time(); |
while($row = @da_sql_fetch_array($search,$config)){ |
$j++; |
$h += 21; |
$user = $row['username']; |
$finger_info[$servers_num][$j]['ip'] = $row['framedipaddress']; |
if ($finger_info[$servers_num][$j]['ip'] == '') |
$finger_info[$servers_num][$j]['ip'] = '-'; |
$session_time = $row['acctstarttime']; |
$session_time = date2timediv($session_time,$now); |
$finger_info[$servers_num][$j]['session_time'] = time2strclock($session_time); |
$finger_info[$servers_num][$j]['user'] = $user; |
$finger_info[$servers_num][$j]['callerid'] = $row['callingstationid']; |
if ($finger_info[$servers_num][$j]['callerid'] == '') |
$finger_info[$servers_num][$j]['callerid'] = '-'; |
if ($user_info["$user"] == ''){ |
$user_info["$user"] = get_user_info($link2,$user,$config,$decode_normal,$k); |
if ($user_info["$user"] == '' || $user_info["$user"] == ' ') |
$user_info["$user"] = 'Unknown User'; |
} |
} |
$height[$servers_num] = $h; |
} |
$server_counting[$servers_num] = $j; |
$server_loggedin[$servers_num] = $num; |
$server_rem[$servers_num] = ($config[$portnum]) ? ($config[$portnum] - $num) : 'unknown'; |
$tot_in += $num; |
if (is_numeric($server_rem[$servers_num])) |
$tot_rem += $server_rem[$servers_num]; |
} |
} |
else |
echo "<b>Could not connect to SQL database</b><br>\n"; |
if (isset($usage_summary)){ |
echo "Online: $tot_in Free: $tot_rem\n"; |
exit(); |
} |
?> |
|
<body> |
<TABLE width="100%" border="0" cellspacing="0" cellpadding="0"> |
<tr><th>Gestion des usagers</th></tr> |
<tr bgcolor="#FFCC66"><td><img src="/images/pix.gif" width="1" |
height="2"></td></tr> |
</TABLE> |
<TABLE width="100%" border=0 cellspacing=0 cellpadding=1> |
<tr bgcolor="#666666"><td> |
<TABLE width="100%" border=0 cellspacing=0 cellpadding=2> |
<tr><td valign="middle" align="left"> |
<center> |
<table border=0 width=550 cellpadding=0 cellspacing=0> |
<tr valign=top> |
<!--<td align=center><img src="images/title2.gif"></td>--> |
</tr> |
</table> |
<br> |
<table border=0 width=540 cellpadding=1 cellspacing=1> |
<tr valign=top> |
<td width=340></td> |
<td bgcolor="black" width=200> |
<table border=0 width=100% cellpadding=2 cellspacing=0> |
<tr bgcolor="#907030" align=right valign=top><th> |
<font color="white">Usagers en ligne</font> |
</th></tr> |
</table> |
</td></tr> |
<tr bgcolor="black" valign=top><td colspan=2> |
<table border=0 width=100% cellpadding=12 cellspacing=0 bgcolor="#ffffd0" valign=top> |
<tr><td> |
<?php |
echo <<<EOM |
<center><b>$date</b></center> |
EOM; |
for($j = 1; $j <= $servers_num; $j++){ |
echo <<<EOM |
<p> |
<table width=100% cellpadding=0 height=30><tr> |
<th align=left>$server_name[$j]</th><th align=right><font color="red">$server_loggedin[$j] usager(s) connecté(s)</font></th><th>$server_model[$j]</th> |
</tr> |
</table> |
<div height="$height[$j]" style="height:$height[$j]"> |
<table border=1 bordercolordark=#ffffe0 bordercolorlight=#000000 width=100% cellpadding=2 cellspacing=0 bgcolor="#ffffe0" valign=top> |
<tr bgcolor="#d0ddb0"> |
<th>#</th><th>usager</th> |
EOM; |
if ($acct_attrs['uf'][4] != '') echo "<th>" . $acct_attrs[uf][4] . "</th>\n"; |
if ($acct_attrs['uf'][9] != '') echo "<th>" . $acct_attrs[uf][9] . "</th>\n"; |
echo <<<EOM |
<th>nom</th><th>durée</th> |
</tr> |
EOM; |
for( $k = 1; $k <= $server_counting[$j]; $k++){ |
$user = $finger_info[$j][$k][user]; |
if ($user == '') |
$user = ' '; |
$User = urlencode($user); |
$time = $finger_info[$j][$k][session_time]; |
$ip = $finger_info[$j][$k][ip]; |
$cid = $finger_info[$j][$k][callerid]; |
$inf = $user_info[$user]; |
echo <<<EOM |
<tr align=center> |
<td>$k</td><td><a href="user_admin.php?login=$User" title="Editer l'utilisateur $user">$user</a></td> |
EOM; |
if ($acct_attrs['uf'][4] != '') echo "<td>$ip</td>\n"; |
if ($acct_attrs['uf'][9] != '') echo "<td>$cid</td>\n"; |
echo <<<EOM |
<td>$inf</td><td>$time</td> |
</tr> |
EOM; |
} |
|
echo <<<EOM |
</table> |
</div> |
EOM; |
} |
?> |
</td></tr> |
</table> |
</td></tr> |
</table> |
</TD></TR> |
</TABLE> |
</td></tr> |
</TABLE><p> |
</html> |