| 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,29 → 240,15 |
|---|
| $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; } |
| } |
| } |
| } |