Subversion Repositories ALCASAR

<?php

#

# status.php for Alcasar captive portal

# by steweb57

# 

$organisme = "etrs-ssic";

$remote_ip = ($_SERVER['REMOTE_ADDR']);

$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 $remote_ip" , $tab);

$user = explode (" ", $tab[0]);

#### Affichage des 3 dernières connexions de $user[5]

function secondsToDuration($seconds = null){

	if ($seconds == null) return "";

	$temp = $seconds % 3600;

	$time[0] = ( $seconds - $temp ) / 3600 ;	// hours

	$time[2] = $temp % 60 ;				// seconds

	$time[1] = ( $temp - $time[2] ) / 60;		// minutes

	return $time[0]." h ".$time[1]." m ".$time[2]." s";

}

# Choice of language

//reste quelques traductions à faire

$Language = 'en';

if(isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])){

  $Langue = explode(",",$_SERVER['HTTP_ACCEPT_LANGUAGE']);

  $Language = strtolower(substr(chop($Langue[0]),0,2)); }

if($Language == 'es'){

	$l_login1			= "El éxito de la autenticación";

	$l_login2			= "Cierre esta ventana interrumpte la sesion.";

	$l_logout			= "Conexión de cierre";

	$l_logout_question	= "Are you sure you want to disconnect now?";	//à traduire

	$l_loggedout		= "Su sesión se cierra";

	$l_wait				= "Por favor, espere un momento ...";

	$l_state_label				= "State";		//à traduire

	$l_session_id_label			= "Session ID";	//à traduire

	$l_max_session_time_label	= "Max Session Time";	//à traduire

	$l_max_idle_time_label		= "Max Idle Time";		//à traduire

	$l_start_time_label			= "Start Time";	//à traduire

	$l_session_time_label		= "Tiempo de conexión";

	$l_idle_time_label			= "Idle Time";	//à traduire

	$l_downloaded_label			= "Downloaded";	//à traduire

	$l_uploaded_label			= "Uploaded";	//à traduire

	$l_original_url_label		= "Original URL";	//à traduire

	$l_not_available			= "Not available";	//à traduire

	$l_na						= "N/A";		//à traduire

	$l_error					= "error";		//à traduire

	$l_welcome					= "Welcome";	//à traduire

	$l_conn_history				= "Your last $nb_connection_history connections";	//à traduire

	$l_connected 			= "logged"; //à traduire 

}

else if($Language == 'de'){

	$l_login1			= "Erfolgreiche Authentifizierung";

	$l_login2			= "Schlißen dieses fensters unterbricht die sitzung";

	$l_logout			= "Beenden der Verbindung";

	$l_logout_question	= "Are you sure you want to disconnect now?";	//à traduire

	$l_loggedout		= "Ihre Sitzung ist geschlossen";

	$l_wait				= "Bitte warten Sie einen Moment ...";

	$l_state_label				= "State";		//à traduire

	$l_session_id_label			= "Session ID";	//à traduire

	$l_max_session_time_label	= "Max Session Time";	//à traduire

	$l_max_idle_time_label		= "Max Idle Time";		//à traduire

	$l_start_time_label			= "Start Time";	//à traduire

	$l_session_time_label		= "Online-zeit";

	$l_idle_time_label			= "Idle Time";	//à traduire

	$l_downloaded_label			= "Downloaded";	//à traduire

	$l_uploaded_label			= "Uploaded";	//à traduire

	$l_original_url_label		= "Original URL";	//à traduire

	$l_not_available			= "Not available";	//à traduire

	$l_na						= "N/A";		//à traduire

	$l_error					= "error";		//à traduire

	$l_welcome					= "Welcome"; 	//à traduire

	$l_conn_history				= "Your last $nb_connection_history connections";	//à traduire

	$l_connected 			= "logged"; //à traduire 

}

else if($Language == 'nl'){

	$l_login1			= "Succesvolle authenticatie";

	$l_login2			= "Dit venster te sluiten onderbreekt uw sessie.";

	$l_logout			= "Slotkoers verbinding";

	$l_logout_question	= "Are you sure you want to disconnect now?";	//à traduire

	$l_loggedout		= "Uw sessie is gesloten";

	$l_wait				= "Wacht een moment ...";

	$l_state_label				= "State";		//à traduire

	$l_session_id_label			= "Session ID";	//à traduire

	$l_max_session_time_label	= "Max Session Time";	//à traduire

	$l_max_idle_time_label		= "Max Idle Time";		//à traduire

	$l_start_time_label			= "Start Time";	//à traduire

	$l_session_time_label		= "Online tijd";

	$l_idle_time_label			= "Idle Time";	//à traduire

	$l_downloaded_label			= "Downloaded";	//à traduire

	$l_uploaded_label			= "Uploaded";	//à traduire

	$l_original_url_label		= "Original URL";	//à traduire

	$l_not_available			= "Not available";	//à traduire

	$l_na						= "N/A";		//à traduire

	$l_error					= "error";		//à traduire

	$l_welcome					= "Welcome";	//à traduire

	$l_conn_history				= "Your last $nb_connection_history connections";	//à traduire

	$l_connected 			= "logged"; //à traduire 

}

else if($Language == 'fr'){

	$l_login1			= "Authentification réussie";

	$l_login2			= "La fermeture de cette fenêtre interrompt votre session.";

	$l_logout			= "Fermeture de la session";

	$l_logout_question	= "Etes vous sûr de vouloir vous déconnecter?";

	$l_loggedout		= "Votre session est fermée";

	$l_wait				= "Patientez un instant ....";

	$l_state_label				= "Etat";

	$l_session_id_label			= "Session ID";

	$l_max_session_time_label	= "Temps de connexion autoris&eacute";

	$l_max_idle_time_label		= "Inactivité max. autorisée";

	$l_start_time_label			= "Début de connexion";

	$l_session_time_label		= "Durée de connexion";

	$l_idle_time_label			= "Inactivité";

	$l_downloaded_label			= "Données téléchargées";

	$l_uploaded_label			= "Données envoyées";

	$l_original_url_label		= "URL demandée";

	$l_not_available			= "Non disponible";

	$l_na						= "N/D";	//à traduire

	$l_error					= "erreur";

	$l_welcome					= "Bienvenue";

	$l_conn_history				= "Vos $nb_connection_history dernières connexions";

	$l_connected 			= "connecté";  

}

else {

	$l_login1			= "Successful authentication.";

	$l_login2			= "Closing this window interrupts your session.";

	$l_logout			= "Closing connection";

	$l_logout_question	= "Are you sure you want to disconnect now?";

	$l_loggedout		= "Your session is closed";

	$l_wait				= "Please wait a moment ...";

	$l_state_label				= "State";

	$l_session_id_label			= "Session ID";

	$l_max_session_time_label	= "Max Session Time";

	$l_max_idle_time_label		= "Max Idle Time";

	$l_start_time_label			= "Start Time";

	$l_session_time_label		= "Session Time";

	$l_idle_time_label			= "Idle Time";

	$l_downloaded_label			= "Downloaded";

	$l_uploaded_label			= "Uploaded";

	$l_original_url_label		= "Original URL";

	$l_not_available			= "Not available";

	$l_na						= "N/A";

	$l_error					= "error";

	$l_welcome					= "Welcome";

	$l_conn_history				= "Your last $nb_connection_history connections";

	$l_connected 			= "logged"; 

}

// si on a pas d'accès à la bdd, la page s'affiche quand même correctement

if (isset($user[5])){

	if ((is_file("./acc/manager/lib/sql/drivers/mysql/functions.php"))&&(is_file("/etc/freeradius-web/config.php"))){

		include_once("/etc/freeradius-web/config.php");

		include_once("./acc/manager/lib/sql/drivers/mysql/functions.php");

		$sql = "SELECT UserName, AcctStartTime, AcctStopTime, acctsessiontime FROM radacct WHERE UserName='$user[5]' ORDER BY AcctStartTime DESC LIMIT 0 , $nb_connection_history";

		$link = @da_sql_pconnect($config); // on affiche pas les erreurs

		if ($link){

			$res = @da_sql_query($link,$config,$sql); // on affiche pas les erreurs

			if ($res){

				$connection_history.= "<ul>";

				while(($row = @da_sql_fetch_array($res,$config))){

					$connected = "";

					$start_conn = date_create($row[acctstarttime]);

					if ($row[acctstoptime] == "") $connected = " ($l_connected)";

					$connection_history.="<li>".date_format($start_conn, 'd M Y - H:i:s')." - (".secondsToDuration($row[acctsessiontime]).") $connected</li>";

				}

				$connection_history.="</ul>";

			}

		}

	}

}

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html lang="fr">

<!-- written by steweb57 -->

	<head>

		<title>Alcasar - <?php echo $organisme; ?></title>

		<meta http-equiv="Cache-control" content="no-cache">

		<meta http-equiv="Pragma" content="no-cache">

		<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

		<script type="text/javascript" src="./js/ChilliLibrary.js"></script>

		<script type="text/javascript" src="./js/statusControler.js"></script>

		<link type="text/css" href="./css/status.css" rel="stylesheet">

	</head>

	<body>

		<div id="Chilli">

		<div id="locationName"></div>

		<div id="chilliPage">

		<div id="loggedOutPage" class="c1">

			<table id="disconnectTable">

				<tr>

					<td><img height="150" src="./images/logo-alcasar.png" alt="logo"></td>

					<td><p class="text_auth"><?php echo $l_loggedout; ?></p></td>

				</tr>

			</table>

		</div>

		<div id="statusPage" class="c1">

			<table border="0" id="statusTable">

				<tr>

					<td rowspan="2" valign="top"><img height="150" src="./images/logo-alcasar.png" alt="logo"></td>

					<td>

						<p class="text_auth_welcom"><?php echo $l_login1; ?></p>

						<p class="text_auth"><?php echo $l_welcome; ?><br><span id="userName"></span></p>

						<hr>

						<?php echo $l_login2; ?>

					</td>

				</tr>

				<tr>

					<td align="center"><br><a href="#" onclick="return logoutWithConfirmation('<?php echo $l_logout_question;?>');" class="lien_deco"><?php echo $l_logout; ?></a><br><br></td>

				</tr>

<!--tr id="connectRow">

<td id="statusMessageLabel" class="chilliLabel"><strong><?php echo $l_state_label; ?></strong></td>

<td id="statusMessage" class="chilliValue">Connected</td>

</tr-->

<!--tr id="sessionIdRow">

<td id="sessionIdLabel" class="chilliLabel"><strong><?php echo $l_session_id_label; ?></strong></td>

<td id="sessionId" class="chilliValue"><?php echo $l_not_available; ?></td>

</tr-->

				<tr id="sessionTimeoutRow">

					<td id="sessionTimeoutLabel" class="chilliLabel"><?php echo $l_max_session_time_label; ?></td>

					<td id="sessionTimeout" class="chilliValue"><?php echo $l_not_available; ?></td>

				</tr>

				<tr id="idleTimeoutRow">

					<td id="idleTimeoutLabel" class="chilliLabel"><?php echo $l_max_idle_time_label; ?></td>

					<td id="idleTimeout" class="chilliValue"><?php echo $l_not_available; ?></td>

				</tr>

				<tr id="startTimeRow">

					<td id="startTimeLabel" class="chilliLabel"><?php echo $l_start_time_label; ?></td>

					<td id="startTime" class="chilliValue"><?php echo $l_not_available; ?></td>

				</tr>

				<tr id="sessionTimeRow">

					<td id="sessionTimeLabel" class="chilliLabel"><?php echo $l_session_time_label; ?></td>

					<td id="sessionTime" class="chilliValue"><?php echo $l_not_available; ?></td>

				</tr>

				<tr id="idleTimeRow">

					<td id="idleTimeLabel" class="chilliLabel"><?php echo $l_idle_time_label; ?></td>

					<td id="idleTime" class="chilliValue"><?php echo $l_not_available; ?></td>

				</tr>

				<tr id="inputOctetsRow">

					<td id="inputOctetsLabel" class="chilliLabel"><?php echo $l_downloaded_label; ?></td>

					<td id="inputOctets" class="chilliValue"><?php echo $l_na; ?></td>

				</tr>

				<tr id="outputOctetsRow">

					<td id="outputOctetsLabel" class="chilliLabel"><?php echo $l_uploaded_label; ?></td>

					<td id="outputOctets" class="chilliValue"><?php echo $l_na; ?></td>

				</tr>

<!--tr id="originalURLRow">

<td id="originalURLLabel" class="chilliLabel"><?php echo $l_original_url_label; ?></td>

<td id="originalURL" class="chilliValue"><?php echo $l_na; ?></td>

</tr-->

				<tr>

					<td colspan=2 id="conHistoryLabel" class="chilliLabel"><?php echo $l_conn_history; ?></td>

				</tr>

				<tr id="conHistoryRow">

					<td colspan=2 id="conHistory" class="chilliValue"><?php echo $connection_history; ?></td>

				</tr>

			</table>

		</div>

		<div id="waitPage">

			<table id="waitTable">

				<tr>

					<td><img height="150" src="./images/logo-alcasar.png" alt="logo"></td>

					<td><p class="text_auth"><img src="./images/wait.gif" width="16" height="16" class="wait" alt="<?php echo $l_wait; ?>"><?php echo $l_wait; ?></p></td>

				</tr>

			</table>

		</div>

		<div id="errorPage">

			<table id="errorTable">

				<tr>

					<td><img height="150" src="./images/logo-alcasar.png" alt="logo"></td>

					<td><span id="errorMessage"><?php echo $l_error; ?></span></td>

				</tr>

			</table>

		</div>

		</div>

<!--div id="debugPage" style="display:inline;">

<textarea id="debugarea" rows="20" cols="60">

</textarea>

</div-->

		</div>

	</body>

</html>