44,8 → 44,9 |
$connection_history = ""; |
$nb_connection_history = 3; |
|
//On récupère le nom de connexion de la session active. //on a l'info en ajax, mais trop tard -> A MODIFIER |
exec ("sudo /usr/sbin/chilli_query list | grep 'pass' | egrep -w '($remote_ip)'" , $tab); |
//On récupère le nom de connexion de la session active. on attend que chilli ait mis à jour ses tables |
sleep (1); |
exec ("sudo /usr/sbin/chilli_query list | grep 'pass' | grep -Ew '($remote_ip)'" , $tab); |
$user = explode (" ", $tab[0]); |
|
#### Affichage des 3 dernières connexions de $user[5] |
232,7 → 233,7 |
$res = @da_sql_query($link,$config,$sql); // on affiche pas les erreurs |
|
if ($res){ |
$connection_history.= "<ul>"; |
$a_connection = ""; $a_connected=0; $connection_history.= "<ul>"; |
while(($row = @da_sql_fetch_array($res,$config))){ |
$connected = ""; |
$start_conn = date_create($row['acctstarttime']); |
239,33 → 240,19 |
$connection_history.="<li>".date_format($start_conn, 'd M Y - H:i:s')." - ("; |
if ($row['acctstoptime'] == "") { |
$connected = $l_connected; |
$a_connected = $a_connected +1; |
}else{ |
$connected = secondsToDuration($row['acctsessiontime']); |
} |
$connection_history.= "$connected)</li>"; |
// $connection_history.="<li>".date_format($start_conn, 'd M Y - H:i:s')." - (".secondsToDuration($row[acctsessiontime]).") $connected</li>"; |
} |
$connection_history.="</ul>"; |
} |
} |
$sql_2 = "SELECT UserName, AcctStartTime, AcctStopTime, acctsessiontime FROM radacct WHERE UserName='$user[5]' AND AcctStopTime IS NULL ORDER BY AcctStartTime DESC"; |
$link_2 = @da_sql_pconnect($config); // on affiche pas les erreurs |
|
if ($link_2){ |
$res_2 = @da_sql_query($link_2,$config,$sql_2); // on affiche pas les erreurs |
$a_connection = ""; |
if ($res_2){ |
while(($row_2 = @da_sql_fetch_array($res_2,$config))){ |
$a_connected = 1; |
if ($row_2['acctstoptime'] == "") $a_connected = $a_connected + 1; |
} |
if ($a_connected > 1){ |
$a_connection = $l_a_connection." ".$a_connected." ".$l_a_connection_time; |
$a_connection = $l_a_connection." ".$a_connected." ".$l_a_connection_time; } |
} |
} |
} |
} |
} |
?> |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> |
<html lang="fr"> |