Subversion Repositories ALCASAR

<?php

# $Id: status.php 2137 2017-03-18 13:18:02Z richard $

#

# status.php for Alcasar captive portal

# by steweb57 & Rexy

# 

/****************************************************************

*			GLOBAL FILE PATHS			*

*****************************************************************/

define ("CONF_FILE", "/usr/local/etc/alcasar.conf");

/****************************************************************

*				FILE TEST			*

*****************************************************************/

//Test de présence et des droits en lecture des fichiers de configuration.

if (!file_exists(CONF_FILE)){

	exit("Fichier de configuration ".CONF_FILE." non présent");

}

if (!is_readable(CONF_FILE)){

	exit("Vous n'avez pas les droits de lecture sur le fichier ".CONF_FILE);

}

/****************************************************************

*			Read CONF_FILE				*

*****************************************************************/

$ouvre=fopen(CONF_FILE,"r");

if ($ouvre){

	while (!feof ($ouvre))

	{

		$tampon = fgets($ouvre, 4096);

		if (strpos($tampon,"=")!==false){

			$tmp = explode("=",$tampon);

			$conf[$tmp[0]] = $tmp[1];

		}

	}

}else{

	exit("Erreur d'ouverture du fichier ".CONF_FILE);

}

fclose($ouvre);

$organisme = $conf["ORGANISM"];

$remote_ip = preg_match('#^([0-9]{1,3}\.){3}[0-9]{1,3}$#', $_SERVER['REMOTE_ADDR']) ? $_SERVER['REMOTE_ADDR'] : "";

$connection_history =  "";

$nb_connection_history = 3;

// Wait for chilli (uptade its tables)

sleep (1);

// Retrieve user info in tab $user[]

exec ("sudo /usr/sbin/chilli_query list | grep 'pass' | grep -Ew '($remote_ip)'" , $tab);

if(isset($tab[0]))

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

#### Time conversion 

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_logout			= "Conexión de cierre";

	$l_logout_question		= "¿Seguro que desea desconectar?";

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

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

	$l_state_label			= "Estado";

	$l_session_id_label		= "Sesión ID";

	$l_max_session_time_label	= "Tiempo máximo de sesión";

	$l_max_idle_time_label		= "Tiempo de inactividad autorizado";

	$l_start_time_label		= "Start Time";	// to translate

	$l_session_time_label		= "Tiempo de conexión";

	$l_idle_time_label		= "Idle Time";	// to translate

	$l_downloaded_label		= "Downloaded";	// to translate

	$l_uploaded_label		= "Uploaded";	// to translate

	$l_original_url_label		= "Original URL";	// to translate

	$l_not_available		= "Not available";	// to translate

	$l_error			= "error";		// to translate

	$l_welcome			= "Welcome";	// to translate

	$l_conn_history			= "Your last $nb_connection_history connections";	// to translate

	$l_connected 			= "logged"; // to translate

	$l_a_connection			= "You have"; // to translate

	$l_a_connection_time		= "active connections on the network"; // to translate

}

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

	$l_login1			= "验证通过";

	$l_logout			= "关闭连接";

	$l_logout_question		= "您确定需要断开连接吗？";

	$l_loggedout			= "您已登出";

	$l_wait				= "请等待 ...";

	$l_state_label			= "连接状态";

	$l_session_id_label		= "连接ID";

	$l_max_session_time_label	= "最大连接时间";

	$l_max_idle_time_label		= "最大闲置时间";

	$l_start_time_label		= "起始连接时间";

	$l_session_time_label		= "连接时间";

	$l_idle_time_label		= "闲置时间";

	$l_downloaded_label		= "数据下载";

	$l_uploaded_label		= "数据上传";

	$l_original_url_label		= "初始网址";

	$l_not_available		= "不可用";

	$l_error			= "出错";

	$l_welcome			= "欢迎";

	$l_conn_history			= "您最近的$nb_connection_history次连接";

	$l_connected 			= "已登录";  

	$l_a_connection			= "您已经有";

	$l_a_connection_time		= "在线时间";

}

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

	$l_login1			= "نجاح المصادقة";

	$l_logout			= "إغلاق الدورة";

	$l_logout_question		= "هل تريد فعلاً قطع الاتصال؟";

	$l_loggedout			= "دورتكَ مُغلَقة";

	$l_wait				= "...إنتظر بعض اللحظات";

	$l_state_label			= "وَضْع";

	$l_session_id_label		= "معرف الدورة";

	$l_max_session_time_label	= "الوقت المسموح للإتصال";

	$l_max_idle_time_label		= "الحد الأقصى لعدم التنشيط";

	$l_start_time_label		= "بداية الإتصال";

	$l_session_time_label		= "مدة الإتصال";

	$l_idle_time_label		= "انعدام التنشيط";

	$l_downloaded_label		= "تم تحميل المعطيات";

	$l_uploaded_label		= "تم إرسال المعطيات";

	$l_original_url_label		= "تم طلب URL";

	$l_not_available		= "غير متوفّر";

	$l_na				= "N/D";

	$l_error			= "خطأ";

	$l_welcome			= "مرحباً بك";

	$l_conn_history			= "($nb_connection_history) سِجِل اتصالاتك الاخيرة";

	$l_connected 			= "دورة ناشطة";  

	$l_a_connection			= "لديك";

	$l_a_connection_time		= "اتصالات ناشطة على الشبكة";

}

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

	$l_login1			= "Autenticação bem sucedida.";

	$l_logout			= "Fechando a conexão";

	$l_logout_question		= "Tem certeza de que deseja desconectar agora?";

	$l_loggedout			= "Sua conexão será fechada";

	$l_wait				= "Por favor, aguarde um momento ...";

	$l_state_label			= "Estado da conexão";

	$l_session_id_label		= "Sessão ID";

	$l_max_session_time_label	= "Restante em horas da conexão";

	$l_max_idle_time_label		= "Restante máximo liberado por dia";

	$l_start_time_label		= "Dia, mês, ano e hora da conexão";

	$l_session_time_label		= "Duração da conexão";

	$l_idle_time_label		= "Tempo de Espera";

	$l_downloaded_label		= "Recebidos";

	$l_uploaded_label		= "Enviados";

	$l_original_url_label		= "URL Original";

	$l_not_available		= "Não disponível";

	$l_error			= "Erro";

	$l_welcome			= "Bem-vindo(a)";

	$l_conn_history			= "Suas últimos conexões : $nb_connection_history";

	$l_connected 			= "Conectado"; 

	$l_a_connection			= "Conexão ativa já detectada para essa LAN";

	$l_a_connection_time		= "Tempo (s)";

}

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

	$l_login1			= "Erfolgreiche Authentifizierung";

	$l_logout			= "Beenden der Verbindung";

	$l_logout_question		= "Möchten Sie die Verbindung jetzt wirklich trennen?";

	$l_loggedout			= "Ihre Sitzung ist geschlossen";

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

	$l_state_label			= "State";		// to translate

	$l_session_id_label		= "Session ID";	// to translate

	$l_max_session_time_label	= "Max Session Time";	// to translate

	$l_max_idle_time_label		= "Max Idle Time";		// to translate

	$l_start_time_label		= "Start Time";	// to translate

	$l_session_time_label		= "Online-zeit";

	$l_idle_time_label		= "Idle Time";	// to translate

	$l_downloaded_label		= "Downloaded";	// to translate

	$l_uploaded_label		= "Uploaded";	// to translate

	$l_original_url_label		= "Original URL";	// to translate

	$l_not_available		= "Not available";	// to translate

	$l_error			= "error";		// to translate

	$l_welcome			= "Welcome"; 	// to translate

	$l_conn_history			= "Your last $nb_connection_history connections";	// to translate

	$l_connected 			= "logged"; // to translate 

	$l_a_connection			= "You have"; // to translate

	$l_a_connection_time		= "active connections on the network"; // to translate

}

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

	$l_login1			= "Succesvolle authenticatie";

	$l_logout			= "Slotkoers verbinding";

	$l_logout_question		= "Bent u zeker dat u wilt nu los te koppelen?";

	$l_loggedout			= "Uw sessie is gesloten";

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

	$l_state_label			= "State";		// to translate

	$l_session_id_label		= "Session ID";	// to translate

	$l_max_session_time_label	= "Max Session Time";	// to translate

	$l_max_idle_time_label		= "Max Idle Time";		// to translate

	$l_start_time_label		= "Start Time";	// to translate

	$l_session_time_label		= "Online tijd";

	$l_idle_time_label		= "Idle Time";	// to translate

	$l_downloaded_label		= "Downloaded";	// to translate

	$l_uploaded_label		= "Uploaded";	// to translate

	$l_original_url_label		= "Original URL";	// to translate

	$l_not_available		= "Not available";	// to translate

	$l_error			= "error";		// to translate

	$l_welcome			= "Welcome";	// to translate

	$l_conn_history			= "Your last $nb_connection_history connections";	// to translate

	$l_connected 			= "logged"; // to translate 

	$l_a_connection			= "You have"; // to translate

	$l_a_connection_time		= "active connections on the network"; // to translate

}

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

	$l_login1			= "Authentification réussie";

	$l_logout			= "Fermeture de la session";

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

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

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

	$l_state_label			= "État";

	$l_session_id_label		= "Session ID";

	$l_max_session_time_label	= "Temps de connexion autorisé";

	$l_max_idle_time_label		= "Temps d'inactivité autorisé";

	$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_error			= "erreur";

	$l_welcome			= "Bienvenue";

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

	$l_connected 			= "session active";  

	$l_a_connection			= "Vous avez";

	$l_a_connection_time		= "connexions actives sur le réseau";

}

else {

	$l_login1			= "Successful authentication.";

	$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_error			= "error";

	$l_welcome			= "Welcome";

	$l_conn_history			= "Your last $nb_connection_history connections";

	$l_connected 			= "logged"; 

	$l_a_connection			= "You have";

	$l_a_connection_time		= "active connections on the network";

}

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

// Retrieve the last connections

	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);

		if ($link){

			$res = @da_sql_query($link,$config,$sql);

			if ($res){

				$a_connection = ""; $a_connected=0; $connection_history.= "<ul>";

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

					$connected = "";

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

					$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.="</ul>";

				if ($a_connected > 1){

					$a_connection = $l_a_connection." ".$a_connected." ".$l_a_connection_time; }

			}

		}

// Retrieve first name & last name

		$sql = "SELECT Name FROM userinfo WHERE UserName='$user[5]'";

		$link = @da_sql_pconnect($config);

		if ($link){

			$res = @da_sql_query($link,$config,$sql);

			if ($res){

				$row = @da_sql_fetch_array($res,$config);

				$cn = ($row['name'] != '') ? $row['name'] : $user[5];

			}

		}

//store the user @IP in a file (to test if he is still active).

		$filename='/var/tmp/havp/current_users.txt';

		$change_me = 1; //avoid duplicate user @IP

		if(file_exists($filename)){

			$fichier = fopen($filename, "r");

			$content = file($filename);

			if (empty($content))

			{

				file_put_contents($filename, $_SERVER['REMOTE_ADDR']);

			}

			else

			{

				// if we found duplicate IP, we will not write user @IP (just set change_me = 0)

				foreach($content as $line){

				        $line = preg_replace('/\s+/', '', $line);

				        if($line == $_SERVER['REMOTE_ADDR'])

				        {

				                $change_me = 0;

				        }

				}

				// if user @IP does not exist, we write it

				if($change_me)

				{

				        file_put_contents($filename, $_SERVER['REMOTE_ADDR'].PHP_EOL , FILE_APPEND);

				}

			}

		}

		else

		{

			//we create filename and we write user @IP.

			file_put_contents($filename, $_SERVER['REMOTE_ADDR'].PHP_EOL);

		}

	}

}

?>

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

<html>

<!-- written by steweb57 & Rexy -->

	<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 colspan="2">

						<table border="0" cellpadding="0" cellspacing="0" width="100%">

							<tr>

								<td valign="top" rowspan="4">

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

								</td>

								<td class="text_auth_welcom">

									<?php echo $l_login1; ?>

								</td>

							</tr>

							<tr>

								<td class="text_auth">

									<?php echo "$l_welcome <br> $cn";?>

								</td>

							</tr>

							<tr>

								<td class="alert">

									<?php if(isset($a_connection))echo $a_connection; ?>

								</td>

							</tr>

							<tr>

								<td colspan="2" align="center" class="link_logout">

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

								</td>

							</tr>

						</table>

					</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_not_available; ?></td>

				</tr>

				<tr id="outputOctetsRow">

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

					<td id="outputOctets" class="chilliValue"><?php echo $l_not_available; ?></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_not_available; ?></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>