Subversion Repositories ALCASAR

<?php

# $Id: status.php 2413 2017-09-17 16:05:20Z tom.houdayer $

#

# status.php for ALCASAR captive portal

# by steweb57 & Rexy

# 

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

*			GLOBAL FILE PATHS			*

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

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

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

*			FILE reading test			*

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

$conf_files = array(CONF_FILE);

foreach ($conf_files as $file) {

	if (!file_exists($file)) {

		exit("Fichier $file non présent");

	}

	if (!is_readable($file)) {

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

	}

}

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

*			Read CONF_FILE				*

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

$file_conf = fopen(CONF_FILE, 'r');

if (!$file_conf) {

	exit('Error opening the file '.CONF_FILE);

}

while (!feof($file_conf)) {

	$buffer = fgets($file_conf, 4096);

	if ((strpos($buffer, '=') !== false) && (substr($buffer, 0, 1) !== '#')) {

		$tmp = explode('=', $buffer);

		$conf[trim($tmp[0])] = trim($tmp[1]);

	}

}

fclose($file_conf);

$organisme = $conf['ORGANISM'];

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

$cn = '';

$connection_history = '';

$nb_connection_history = 3;

$homepage_url = (($conf['HTTPS_LOGIN'] === 'on') ? 'https' : 'http' ).'://'.$conf['HOSTNAME'].'.'.$conf['DOMAIN'].'/';

$useHTTPS = ((isset($_SERVER['HTTPS'])) && (!empty($_SERVER['HTTPS'])) && ($_SERVER['HTTPS'] !== 'off'));

// Wait for chilli (update its tables)

sleep(1); // TODO: wait after login only?

// 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[2] = $temp % 60 ;			// seconds

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

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

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

}

# Choice of language

// TODO: 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') {		// Spanish

	$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

	$l_close_warning		= "Advertencia: se desconectará si cierra esta ventana";

	$l_back_homepage		= "Volver a la página de inicio";

} else if ($Language === 'zh') {	// Chinese

	$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		= "在线时间";

	$l_close_warning		= "警告: 您将会断开连接如果您在关闭此窗口";

	$l_back_homepage		= "回到主页";

} else if ($Language === 'ar') {	// Arabic

	$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		= "اتصالات ناشطة على الشبكة";

	$l_close_warning		= "تحذير: سيتم قطع الاتصال إذا قمت بإغلاق هذه النافذة";

	$l_back_homepage		= "الرجوع إلى الصفحة الرئيسية";

} else if ($Language === 'pt') {	// Portuguese

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

	$l_close_warning		= "Aviso: você será desconectado se fechar esta janela";

	$l_back_homepage		= "Voltar à página inicial";

} else if ($Language === 'de') {	// German

	$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

	$l_close_warning		= "Warnung: Sie werden getrennt, wenn Sie dieses Fenster schließen";

	$l_back_homepage		= "Zurück zur Startseite";

} else if ($Language === 'nl') {	// Dutch

	$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

	$l_close_warning		= "Waarschuwing: u zal worden afgebroken als u dit venster sluiten";

	$l_back_homepage		= "Terug naar de homepage";

} else if ($Language === 'fr') {	// French

	$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";

	$l_close_warning		= "Attention : vous serez déconnecté si vous fermez cette fenêtre";

	$l_back_homepage		= "Revenir à la page d'accueil";

} else {				// English

	$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";

	$l_close_warning		= "Warning: you will be disconnected if you close this window";

	$l_back_homepage		= "Back to homepage";

}

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

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

		require_once('/etc/freeradius-web/config.php');

		require_once('acc/manager/lib/sql/drivers/mysql/functions.php');

		$link = @da_sql_pconnect($config);

		if ($link) {

			// Retrieve the last connections

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

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

			if ($res) {

				$connection_history = '<ul>';

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

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

					if (empty($row['acctstoptime'])) {

						$connected = $l_connected;

					} else {

						$connected = secondsToDuration($row['acctsessiontime']);

					}

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

				}

				$connection_history .= '</ul>';

			}

			// Retrieve number of open session

			$sql = "SELECT COUNT(*) AS nb_open FROM radacct WHERE username = '$user[5]' AND acctstoptime IS NULL;";

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

			if ($res) {

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

				$nb_open_session = $row['nb_open'];

			}

			// Retrieve first name & last name

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

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

			if ($res) {

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

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

			}

		}

	}

}

// Cleaning the cache

header('Expires: Tue, 01 Jan 2000 00:00:00 GMT');

header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');

header('Cache-Control: no-store, no-cache, must-revalidate, max-age=0');

header('Cache-Control: post-check=0, pre-check=0', false);

header('Pragma: no-cache');

?>

<!DOCTYPE html>

<html>

	<head>

		<meta charset="UTF-8">

		<title>ALCASAR - <?= $organisme ?></title>

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

		<script src="js/ChilliLibrary.js"></script>

		<script>

			chilliController.host = '<?= $conf['HOSTNAME'].'.'.$conf['DOMAIN'] ?>';

			chilliController.port = <?= (($useHTTPS) ? 3991 : 3990) ?>;

			chilliController.ssl  = <?= (($useHTTPS) ? 'true' : 'false') ?>;

		</script>

		<script src="js/statusControler.js"></script>

	</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"><?= $l_loggedout ?></p>

								<p class="text_homelink"><a href="<?= $homepage_url ?>"><?= $l_back_homepage ?></a></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">

											<?= $l_login1 ?>

										</td>

									</tr>

									<tr>

										<td class="text_auth">

											<?= $l_welcome ?><br><?= $cn ?>

										</td>

									</tr>

									<tr>

										<td class="alert">

											<?= ((isset($nb_open_session) && ($nb_open_session > 1)) ? $l_a_connection.' '.$nb_open_session.' '.$l_a_connection_time : '') ?>

										</td>

									</tr>

									<tr>

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

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

										</td>

									</tr>

								</table>

							</td>

						</tr>

<!-- 

						<tr id="connectRow">

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

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

						</tr>

						<tr id="sessionIdRow">

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

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

						</tr>

-->

						<tr id="sessionTimeoutRow">

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

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

						</tr>

						<tr id="idleTimeoutRow">

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

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

						</tr>

						<tr id="startTimeRow">

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

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

						</tr>

						<tr id="sessionTimeRow">

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

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

						</tr>

						<tr id="idleTimeRow">

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

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

						</tr>

						<tr id="inputOctetsRow">

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

							<td id="inputOctets" class="chilliValue"><?= $l_not_available ?></td>

						</tr>

						<tr id="outputOctetsRow">

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

							<td id="outputOctets" class="chilliValue"><?= $l_not_available ?></td>

						</tr>

<!-- 

						<tr id="originalURLRow">

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

							<td id="originalURL" class="chilliValue"><?= $l_not_available ?></td>

						</tr>

 -->

						<tr>

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

						</tr>

						<tr id="conHistoryRow">

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

						</tr>

						<tr>

							<td colspan="2" id="close-warning">(<?= $l_close_warning ?>)</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="<?= $l_wait ?>"><?= $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"><?= $l_error ?></span></td>

						</tr>

					</table>

				</div>

			</div>

		</div>

	</body>

</html>