Subversion Repositories ALCASAR

Rev

Rev 640 | Rev 732 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log

Rev 640 Rev 725
Line 2... Line 2...
2 
#
 2 
#
3 
# status.php for Alcasar captive portal
 3 
# status.php for Alcasar captive portal
4 
# by steweb57
 4 
# by steweb57
5 
#
5 
#
6 
$organisme = "";
 6 
$organisme = "";
- 
 
 7 
$remote_ip = ($_SERVER['REMOTE_ADDR']);
- 
 
 8 
$connection_history =  "";
- 
 
 9 
$nb_connection_history = 3;
- 
 
 10 
 
- 
 
 11 
//On récupère le nom de connexion de la session active. //on a l'info en ajax, mais trop tard -> A MODIFIER
- 
 
 12 
exec ("sudo /usr/sbin/chilli_query list|grep $remote_ip" , $tab);
- 
 
 13 
$user = explode (" ", $tab[0]);
- 
 
 14 
 
- 
 
 15 
#### Affichage des 3 dernières connexions de $user[5]
- 
 
 16 
function secondsToDuration($seconds = null){
- 
 
 17 
	if ($seconds == null) return "";
- 
 
 18 
 
- 
 
 19 
	$temp = $seconds % 3600;
- 
 
 20 
	$time[0] = ( $seconds - $temp ) / 3600 ;	// hours
- 
 
 21 
	$time[2] = $temp % 60 ;						// seconds
- 
 
 22 
	$time[1] = ( $temp - $time[2] ) / 60;		// minutes
- 
 
 23
- 
 
 24 
	return $time[0]." h ".$time[2]." m ".$time[1]." s";
- 
 
 25 
}
- 
 
 26 
 
- 
 
 27 
$l_connected = "connected"; // a traduire (choix de la langue ci-dessous mais nécessitant de $connection_history)
- 
 
 28 
// si on a pas d'accès à la bdd, la page s'affiche quand même correctement
- 
 
 29 
if (isset($user[5])){
- 
 
 30 
	if ((is_file("./acc/manager/lib/sql/drivers/mysql/functions.php"))&&(is_file("/etc/freeradius-web/config.php"))){
- 
 
 31 
		include_once("/etc/freeradius-web/config.php");
- 
 
 32 
		include_once("./acc/manager/lib/sql/drivers/mysql/functions.php");
- 
 
 33
- 
 
 34 
		$sql = "SELECT UserName, AcctStartTime, AcctStopTime, acctsessiontime FROM radacct WHERE UserName='$user[5]' ORDER BY AcctStartTime DESC LIMIT 0 , $nb_connection_history";
- 
 
 35 
		$link = @da_sql_pconnect($config); // on affiche pas les erreurs
- 
 
 36
- 
 
 37 
		if ($link){
- 
 
 38 
			$res = @da_sql_query($link,$config,$sql); // on affiche pas les erreurs
- 
 
 39
- 
 
 40 
			if ($res){
- 
 
 41 
				$connection_history.= "<ul>";
- 
 
 42 
				while(($row = @da_sql_fetch_array($res,$config))){
- 
 
 43 
					$connected = "";
- 
 
 44 
					if ($row[acctstoptime] == "") $connected = " ($l_connected)";
- 
 
 45 
					$connection_history.="<li title='$row[username] $row[acctstarttime] $row[acctstoptime] (".secondsToDuration($row[acctsessiontime]).")'>$row[acctstarttime] (".secondsToDuration($row[acctsessiontime]).") $connected</li>";
- 
 
 46 
				}
- 
 
 47 
				$connection_history.="</ul>";
- 
 
 48 
			}
- 
 
 49 
		}
- 
 
 50 
	}
- 
 
 51 
}
- 
 
 52 
####
- 
 
 53 
 
7 
 
 54 
 
8 
# Choice of language
 55 
# Choice of language
9 
//reste quelques traductions à faire
 56 
//reste quelques traductions à faire
10 
$Language = 'en';
 57 
$Language = 'en';
11 
if(isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])){
 58 
if(isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])){
Line 30... Line 77...
30 
	$l_original_url_label		= "Original URL";	//à traduire
 77 
	$l_original_url_label		= "Original URL";	//à traduire
31 
	$l_not_available			= "Not available";	//à traduire
 78 
	$l_not_available			= "Not available";	//à traduire
32 
	$l_na						= "N/A";		//à traduire
 79 
	$l_na						= "N/A";		//à traduire
33 
	$l_error					= "error";		//à traduire
 80 
	$l_error					= "error";		//à traduire
34 
	$l_welcome					= "Welcome";	//à traduire
 81 
	$l_welcome					= "Welcome";	//à traduire
- 
 
 82 
	$l_conn_history				= "$nb_connection_history last connections";	//à traduire
35 
}
 83 
}
36 
else if($Language == 'de'){
 84 
else if($Language == 'de'){
37 
	$l_login1			= "Erfolgreiche Authentifizierung.";
 85 
	$l_login1			= "Erfolgreiche Authentifizierung.";
38 
	$l_login2			= "Schlißen dieses fensters unterbricht die sitzung";
 86 
	$l_login2			= "Schlißen dieses fensters unterbricht die sitzung";
39 
	$l_logout			= "Beenden der Verbindung";
 87 
	$l_logout			= "Beenden der Verbindung";
Line 52... Line 100...
52 
	$l_original_url_label		= "Original URL";	//à traduire
 100 
	$l_original_url_label		= "Original URL";	//à traduire
53 
	$l_not_available			= "Not available";	//à traduire
 101 
	$l_not_available			= "Not available";	//à traduire
54 
	$l_na						= "N/A";		//à traduire
 102 
	$l_na						= "N/A";		//à traduire
55 
	$l_error					= "error";		//à traduire
 103 
	$l_error					= "error";		//à traduire
56 
	$l_welcome					= "Welcome"; 	//à traduire
 104 
	$l_welcome					= "Welcome"; 	//à traduire
- 
 
 105 
	$l_conn_history				= "$nb_connection_history last connections";	//à traduire
57 
}
 106 
}
58 
else if($Language == 'nl'){
 107 
else if($Language == 'nl'){
59 
	$l_login1			= "Succesvolle authenticatie.";
 108 
	$l_login1			= "Succesvolle authenticatie.";
60 
	$l_login2			= "Dit venster te sluiten onderbreekt uw sessie.";
 109 
	$l_login2			= "Dit venster te sluiten onderbreekt uw sessie.";
61 
	$l_logout			= "Slotkoers verbinding";
 110 
	$l_logout			= "Slotkoers verbinding";
Line 74... Line 123...
74 
	$l_original_url_label		= "Original URL";	//à traduire
 123 
	$l_original_url_label		= "Original URL";	//à traduire
75 
	$l_not_available			= "Not available";	//à traduire
 124 
	$l_not_available			= "Not available";	//à traduire
76 
	$l_na						= "N/A";		//à traduire
 125 
	$l_na						= "N/A";		//à traduire
77 
	$l_error					= "error";		//à traduire
 126 
	$l_error					= "error";		//à traduire
78 
	$l_welcome					= "Welcome";	//à traduire
 127 
	$l_welcome					= "Welcome";	//à traduire
- 
 
 128 
	$l_conn_history				= "$nb_connection_history last connections";	//à traduire
79 
}
 129 
}
80 
else if($Language == 'fr'){
 130 
else if($Language == 'fr'){
81 
	$l_login1			= "Authentification r&eacute;ussie.";
 131 
	$l_login1			= "Authentification r&eacute;ussie.";
82 
	$l_login2			= "La fermeture de cette fenêtre interrompt votre session.";
 132 
	$l_login2			= "La fermeture de cette fenêtre interrompt votre session.";
83 
	$l_logout			= "Fermeture de la session";
 133 
	$l_logout			= "Fermeture de la session";
Line 96... Line 146...
96 
	$l_original_url_label		= "URL demand&eacute;e";
 146 
	$l_original_url_label		= "URL demand&eacute;e";
97 
	$l_not_available			= "Non disponible";
 147 
	$l_not_available			= "Non disponible";
98 
	$l_na						= "N/D";	//à traduire
 148 
	$l_na						= "N/D";	//à traduire
99 
	$l_error					= "erreur";
 149 
	$l_error					= "erreur";
100 
	$l_welcome					= "Bienvenue";
 150 
	$l_welcome					= "Bienvenue";
- 
 
 151 
	$l_conn_history				= "$nb_connection_history derni&egrave;res connexions";
101 
}
 152 
}
102 
else {
 153 
else {
103 
	$l_login1			= "Successful authentication.";
 154 
	$l_login1			= "Successful authentication.";
104 
	$l_login2			= "Closing this window interrupts your session.";
 155 
	$l_login2			= "Closing this window interrupts your session.";
105 
	$l_logout			= "Closing connection";
 156 
	$l_logout			= "Closing connection";
Line 118... Line 169...
118 
	$l_original_url_label		= "Original URL";
 169 
	$l_original_url_label		= "Original URL";
119 
	$l_not_available			= "Not available";
 170 
	$l_not_available			= "Not available";
120 
	$l_na						= "N/A";
 171 
	$l_na						= "N/A";
121 
	$l_error					= "error";
 172 
	$l_error					= "error";
122 
	$l_welcome					= "Welcome";
 173 
	$l_welcome					= "Welcome";
- 
 
 174 
	$l_conn_history				= "$nb_connection_history last connections";
123 
}
 175 
}
124 
?>
 176 
?>
125 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
 177 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
126 
<html lang="fr">
 178 
<html lang="fr">
127 
<!-- written by steweb57 -->
 179 
<!-- written by steweb57 -->
Line 197... Line 249...
197 
</tr>
 249 
</tr>
198 
<tr id="outputOctetsRow">
 250 
<tr id="outputOctetsRow">
199 
<td id="outputOctetsLabel" class="chilliLabel"><strong><?php echo $l_uploaded_label; ?></strong></td>
 251 
<td id="outputOctetsLabel" class="chilliLabel"><strong><?php echo $l_uploaded_label; ?></strong></td>
200 
<td id="outputOctets" class="chilliValue"><?php echo $l_na; ?></td>
 252 
<td id="outputOctets" class="chilliValue"><?php echo $l_na; ?></td>
201 
</tr>
 253 
</tr>
202 
<tr id="originalURLRow">
 254 
<!--tr id="originalURLRow">
203 
<td id="originalURLLabel" class="chilliLabel"><strong><?php echo $l_original_url_label; ?></strong></td>
 255 
<td id="originalURLLabel" class="chilliLabel"><strong><?php echo $l_original_url_label; ?></strong></td>
204 
<td id="originalURL" class="chilliValue"><?php echo $l_na; ?></td>
 256 
<td id="originalURL" class="chilliValue"><?php echo $l_na; ?></td>
- 
 
 257 
</tr-->
- 
 
 258 
<tr id="conHistoryRow">
- 
 
 259 
<td id="conHistoryLabel" class="chilliLabel"><strong><?php echo $l_conn_history; ?></strong></td>
- 
 
 260 
<td id="conHistory" class="chilliValue"><?php echo $connection_history; ?></td>
205 
</tr>
 261 
</tr>
206 
</table>
 262 
</table>
207 
</div>
 263 
</div>
208 
<div id="waitPage">
 264 
<div id="waitPage">
209 
<table id="waitTable">
 265 
<table id="waitTable">