Subversion Repositories ALCASAR

Rev

Rev 2064 | Rev 2070 | Go to most recent revision | Only display areas with differences | Ignore whitespace | Details | Blame | Last modification | View Log

Rev 2064 Rev 2066
1
<?php
1
<?php
2
# $Id: status.php 2064 2016-11-05 08:11:03Z richard $
2
# $Id: status.php 2066 2016-11-11 18:24:08Z richard $
3
#
3
#
4
# status.php for Alcasar captive portal
4
# status.php for Alcasar captive portal
5
# by steweb57 & Rexy
5
# by steweb57 & Rexy
6
# 
6
# 
7
/****************************************************************
7
/****************************************************************
8
*			GLOBAL FILE PATHS			*
8
*			GLOBAL FILE PATHS			*
9
*****************************************************************/
9
*****************************************************************/
10
define ("CONF_FILE", "/usr/local/etc/alcasar.conf");
10
define ("CONF_FILE", "/usr/local/etc/alcasar.conf");
11
 
11
 
12
/****************************************************************
12
/****************************************************************
13
*				FILE TEST			*
13
*				FILE TEST			*
14
*****************************************************************/
14
*****************************************************************/
15
//Test de présence et des droits en lecture des fichiers de configuration.
15
//Test de présence et des droits en lecture des fichiers de configuration.
16
if (!file_exists(CONF_FILE)){
16
if (!file_exists(CONF_FILE)){
17
	exit("Fichier de configuration ".CONF_FILE." non présent");
17
	exit("Fichier de configuration ".CONF_FILE." non présent");
18
}
18
}
19
if (!is_readable(CONF_FILE)){
19
if (!is_readable(CONF_FILE)){
20
	exit("Vous n'avez pas les droits de lecture sur le fichier ".CONF_FILE);
20
	exit("Vous n'avez pas les droits de lecture sur le fichier ".CONF_FILE);
21
}
21
}
22
 
22
 
23
/****************************************************************
23
/****************************************************************
24
*			Read CONF_FILE				*
24
*			Read CONF_FILE				*
25
*****************************************************************/
25
*****************************************************************/
26
$ouvre=fopen(CONF_FILE,"r");
26
$ouvre=fopen(CONF_FILE,"r");
27
if ($ouvre){
27
if ($ouvre){
28
	while (!feof ($ouvre))
28
	while (!feof ($ouvre))
29
	{
29
	{
30
		$tampon = fgets($ouvre, 4096);
30
		$tampon = fgets($ouvre, 4096);
31
		if (strpos($tampon,"=")!==false){
31
		if (strpos($tampon,"=")!==false){
32
			$tmp = explode("=",$tampon);
32
			$tmp = explode("=",$tampon);
33
			$conf[$tmp[0]] = $tmp[1];
33
			$conf[$tmp[0]] = $tmp[1];
34
		}
34
		}
35
	}
35
	}
36
}else{
36
}else{
37
	exit("Erreur d'ouverture du fichier ".CONF_FILE);
37
	exit("Erreur d'ouverture du fichier ".CONF_FILE);
38
}
38
}
39
fclose($ouvre);
39
fclose($ouvre);
40
 
40
 
41
$organisme = $conf["ORGANISM"];
41
$organisme = $conf["ORGANISM"];
42
 
42
 
43
$remote_ip = ($_SERVER['REMOTE_ADDR']);
43
$remote_ip = ($_SERVER['REMOTE_ADDR']);
44
$connection_history =  "";
44
$connection_history =  "";
45
$nb_connection_history = 3;
45
$nb_connection_history = 3;
46
 
46
 
47
//On récupère le nom de connexion de la session active. on attend que chilli ait mis à jour ses tables
47
//On récupère le nom de connexion de la session active. on attend que chilli ait mis à jour ses tables
48
sleep (1);
48
sleep (1);
49
exec ("sudo /usr/sbin/chilli_query list | grep 'pass' | grep -Ew '($remote_ip)'" , $tab);
49
exec ("sudo /usr/sbin/chilli_query list | grep 'pass' | grep -Ew '($remote_ip)'" , $tab);
50
if(isset($tab[0]))
50
if(isset($tab[0]))
51
$user = explode (" ", $tab[0]);
51
$user = explode (" ", $tab[0]);
52
 
52
 
53
#### Affichage des 3 dernières connexions de $user[5]
53
#### Affichage des 3 dernières connexions de $user[5]
54
function secondsToDuration($seconds = null){
54
function secondsToDuration($seconds = null){
55
	if ($seconds == null) return "";
55
	if ($seconds == null) return "";
56
 
56
 
57
	$temp = $seconds % 3600;
57
	$temp = $seconds % 3600;
58
	$time[0] = ( $seconds - $temp ) / 3600 ;	// hours
58
	$time[0] = ( $seconds - $temp ) / 3600 ;	// hours
59
	$time[2] = $temp % 60 ;				// seconds
59
	$time[2] = $temp % 60 ;				// seconds
60
	$time[1] = ( $temp - $time[2] ) / 60;		// minutes
60
	$time[1] = ( $temp - $time[2] ) / 60;		// minutes
61
	
61
	
62
	return $time[0]." h ".$time[1]." m ".$time[2]." s";
62
	return $time[0]." h ".$time[1]." m ".$time[2]." s";
63
}
63
}
64
 
64
 
65
 
65
 
66
 
66
 
67
# Choice of language
67
# Choice of language
68
//reste quelques traductions à faire
68
//reste quelques traductions à faire
69
$Language = 'en';
69
$Language = 'en';
70
if(isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])){
70
if(isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])){
71
  $Langue = explode(",",$_SERVER['HTTP_ACCEPT_LANGUAGE']);
71
  $Langue = explode(",",$_SERVER['HTTP_ACCEPT_LANGUAGE']);
72
  $Language = strtolower(substr(chop($Langue[0]),0,2)); }
72
  $Language = strtolower(substr(chop($Langue[0]),0,2)); }
73
if($Language == 'es'){
73
if($Language == 'es'){
74
	$l_login1			= "El éxito de la autenticación";
74
	$l_login1			= "El éxito de la autenticación";
75
	$l_logout			= "Conexión de cierre";
75
	$l_logout			= "Conexión de cierre";
76
	$l_logout_question		= "Are you sure you want to disconnect now?";	// to translate
76
	$l_logout_question		= "¿Seguro que desea desconectar?";
77
	$l_loggedout			= "Su sesión se cierra";
77
	$l_loggedout			= "Su sesión se cierra";
78
	$l_wait				= "Por favor, espere un momento ...";
78
	$l_wait				= "Por favor, espere un momento ...";
79
	$l_state_label			= "State";		// to translate
79
	$l_state_label			= "Estado";
80
	$l_session_id_label		= "Session ID";	// to translate
80
	$l_session_id_label		= "Sesión ID";
81
	$l_max_session_time_label	= "Max Session Time";	// to translate
81
	$l_max_session_time_label	= "Tiempo máximo de sesión";
82
	$l_max_idle_time_label		= "Max Idle Time";		// to translate
82
	$l_max_idle_time_label		= "Tiempo de inactividad autorizado";
83
	$l_start_time_label		= "Start Time";	// to translate
83
	$l_start_time_label		= "Start Time";	// to translate
84
	$l_session_time_label		= "Tiempo de conexión";
84
	$l_session_time_label		= "Tiempo de conexión";
85
	$l_idle_time_label		= "Idle Time";	// to translate
85
	$l_idle_time_label		= "Idle Time";	// to translate
86
	$l_downloaded_label		= "Downloaded";	// to translate
86
	$l_downloaded_label		= "Downloaded";	// to translate
87
	$l_uploaded_label		= "Uploaded";	// to translate
87
	$l_uploaded_label		= "Uploaded";	// to translate
88
	$l_original_url_label		= "Original URL";	// to translate
88
	$l_original_url_label		= "Original URL";	// to translate
89
	$l_not_available		= "Not available";	// to translate
89
	$l_not_available		= "Not available";	// to translate
90
	$l_na				= "N/A";		// to translate
90
	$l_na				= "N/A";		// to translate
91
	$l_error			= "error";		// to translate
91
	$l_error			= "error";		// to translate
92
	$l_welcome			= "Welcome";	// to translate
92
	$l_welcome			= "Welcome";	// to translate
93
	$l_conn_history			= "Your last $nb_connection_history connections";	// to translate
93
	$l_conn_history			= "Your last $nb_connection_history connections";	// to translate
94
	$l_connected 			= "logged"; // to translate
94
	$l_connected 			= "logged"; // to translate
95
	$l_a_connection			= "You have"; // to translate
95
	$l_a_connection			= "You have"; // to translate
96
	$l_a_connection_time		= "active connections on the network"; // to translate
96
	$l_a_connection_time		= "active connections on the network"; // to translate
97
}
97
}
-
 
98
else if($language == 'cn'){
-
 
99
	$l_login1			= "验证通过";
-
 
100
	$l_logout			= "关闭连接";
-
 
101
	$l_logout_question		= "您确定需要断开连接吗?";
-
 
102
	$l_loggedout			= "您已登出";
-
 
103
	$l_wait				= "请等待 ...";
-
 
104
	$l_state_label			= "连接状态";
-
 
105
	$l_session_id_label		= "连接ID";
-
 
106
	$l_max_session_time_label	= "最大连接时间";
-
 
107
	$l_max_idle_time_label		= "最大闲置时间";
-
 
108
	$l_start_time_label		= "起始连接时间";
-
 
109
	$l_session_time_label		= "连接时间";
-
 
110
	$l_idle_time_label		= "闲置时间";
-
 
111
	$l_downloaded_label		= "数据下载";
-
 
112
	$l_uploaded_label		= "数据上传";
-
 
113
	$l_original_url_label		= "初始网址";
-
 
114
	$l_not_available		= "不可用";
-
 
115
	$l_na				= "N/A";
-
 
116
	$l_error			= "出错";
-
 
117
	$l_welcome			= "欢迎";
-
 
118
	$l_conn_history			= "您最近的$nb_connection_history次连接";
-
 
119
	$l_connected 			= "已登录";  
-
 
120
	$l_a_connection			= "您已经有";
-
 
121
	$l_a_connection_time		= "在线时间";
-
 
122
}
98
else if ($Language == 'pt'){
123
else if ($Language == 'pt'){
99
	$l_login1			= "Autenticação bem sucedida.";
124
	$l_login1			= "Autenticação bem sucedida.";
100
	$l_logout			= "Fechando a conexão";
125
	$l_logout			= "Fechando a conexão";
101
	$l_logout_question		= "Tem certeza de que deseja desconectar agora?";
126
	$l_logout_question		= "Tem certeza de que deseja desconectar agora?";
102
	$l_loggedout			= "Sua conexão será fechada";
127
	$l_loggedout			= "Sua conexão será fechada";
103
	$l_wait				= "Por favor, aguarde um momento ...";
128
	$l_wait				= "Por favor, aguarde um momento ...";
104
	$l_state_label			= "Estado da conexão";
129
	$l_state_label			= "Estado da conexão";
105
	$l_session_id_label		= "Sessão ID";
130
	$l_session_id_label		= "Sessão ID";
106
	$l_max_session_time_label	= "Restante em horas da conexão";
131
	$l_max_session_time_label	= "Restante em horas da conexão";
107
	$l_max_idle_time_label		= "Restante máximo liberado por dia";
132
	$l_max_idle_time_label		= "Restante máximo liberado por dia";
108
	$l_start_time_label		= "Dia, mês, ano e hora da conexão";
133
	$l_start_time_label		= "Dia, mês, ano e hora da conexão";
109
	$l_session_time_label		= "Duração da conexão";
134
	$l_session_time_label		= "Duração da conexão";
110
	$l_idle_time_label		= "Tempo de Espera";
135
	$l_idle_time_label		= "Tempo de Espera";
111
	$l_downloaded_label		= "Recebidos";
136
	$l_downloaded_label		= "Recebidos";
112
	$l_uploaded_label		= "Enviados";
137
	$l_uploaded_label		= "Enviados";
113
	$l_original_url_label		= "URL Original";
138
	$l_original_url_label		= "URL Original";
114
	$l_not_available		= "Não disponível";
139
	$l_not_available		= "Não disponível";
115
	$l_na				= "N/A";
140
	$l_na				= "N/A";
116
	$l_error			= "Erro";
141
	$l_error			= "Erro";
117
	$l_welcome			= "Bem-vindo(a)";
142
	$l_welcome			= "Bem-vindo(a)";
118
	$l_conn_history			= "Suas últimos conexões : $nb_connection_history";
143
	$l_conn_history			= "Suas últimos conexões : $nb_connection_history";
119
	$l_connected 			= "Conectado"; 
144
	$l_connected 			= "Conectado"; 
120
	$l_a_connection			= "Conexão ativa já detectada para essa LAN";
145
	$l_a_connection			= "Conexão ativa já detectada para essa LAN";
121
	$l_a_connection_time		= "Tempo (s)";
146
	$l_a_connection_time		= "Tempo (s)";
122
}
147
}
123
else if($Language == 'de'){
148
else if($Language == 'de'){
124
	$l_login1			= "Erfolgreiche Authentifizierung";
149
	$l_login1			= "Erfolgreiche Authentifizierung";
125
	$l_logout			= "Beenden der Verbindung";
150
	$l_logout			= "Beenden der Verbindung";
126
	$l_logout_question		= "Are you sure you want to disconnect now?";	// to translate
151
	$l_logout_question		= "Are you sure you want to disconnect now?";	// to translate
127
	$l_loggedout			= "Ihre Sitzung ist geschlossen";
152
	$l_loggedout			= "Ihre Sitzung ist geschlossen";
128
	$l_wait				= "Bitte warten Sie einen Moment ...";
153
	$l_wait				= "Bitte warten Sie einen Moment ...";
129
	$l_state_label			= "State";		// to translate
154
	$l_state_label			= "State";		// to translate
130
	$l_session_id_label		= "Session ID";	// to translate
155
	$l_session_id_label		= "Session ID";	// to translate
131
	$l_max_session_time_label	= "Max Session Time";	// to translate
156
	$l_max_session_time_label	= "Max Session Time";	// to translate
132
	$l_max_idle_time_label		= "Max Idle Time";		// to translate
157
	$l_max_idle_time_label		= "Max Idle Time";		// to translate
133
	$l_start_time_label		= "Start Time";	// to translate
158
	$l_start_time_label		= "Start Time";	// to translate
134
	$l_session_time_label		= "Online-zeit";
159
	$l_session_time_label		= "Online-zeit";
135
	$l_idle_time_label		= "Idle Time";	// to translate
160
	$l_idle_time_label		= "Idle Time";	// to translate
136
	$l_downloaded_label		= "Downloaded";	// to translate
161
	$l_downloaded_label		= "Downloaded";	// to translate
137
	$l_uploaded_label		= "Uploaded";	// to translate
162
	$l_uploaded_label		= "Uploaded";	// to translate
138
	$l_original_url_label		= "Original URL";	// to translate
163
	$l_original_url_label		= "Original URL";	// to translate
139
	$l_not_available		= "Not available";	// to translate
164
	$l_not_available		= "Not available";	// to translate
140
	$l_na				= "N/A";		// to translate
165
	$l_na				= "N/A";		// to translate
141
	$l_error			= "error";		// to translate
166
	$l_error			= "error";		// to translate
142
	$l_welcome			= "Welcome"; 	// to translate
167
	$l_welcome			= "Welcome"; 	// to translate
143
	$l_conn_history			= "Your last $nb_connection_history connections";	// to translate
168
	$l_conn_history			= "Your last $nb_connection_history connections";	// to translate
144
	$l_connected 			= "logged"; // to translate 
169
	$l_connected 			= "logged"; // to translate 
145
	$l_a_connection			= "You have"; // to translate
170
	$l_a_connection			= "You have"; // to translate
146
	$l_a_connection_time		= "active connections on the network"; // to translate
171
	$l_a_connection_time		= "active connections on the network"; // to translate
147
}
172
}
148
else if($Language == 'nl'){
173
else if($Language == 'nl'){
149
	$l_login1			= "Succesvolle authenticatie";
174
	$l_login1			= "Succesvolle authenticatie";
150
	$l_logout			= "Slotkoers verbinding";
175
	$l_logout			= "Slotkoers verbinding";
151
	$l_logout_question		= "Are you sure you want to disconnect now?";	// to translate
176
	$l_logout_question		= "Are you sure you want to disconnect now?";	// to translate
152
	$l_loggedout			= "Uw sessie is gesloten";
177
	$l_loggedout			= "Uw sessie is gesloten";
153
	$l_wait				= "Wacht een moment ...";
178
	$l_wait				= "Wacht een moment ...";
154
	$l_state_label			= "State";		// to translate
179
	$l_state_label			= "State";		// to translate
155
	$l_session_id_label		= "Session ID";	// to translate
180
	$l_session_id_label		= "Session ID";	// to translate
156
	$l_max_session_time_label	= "Max Session Time";	// to translate
181
	$l_max_session_time_label	= "Max Session Time";	// to translate
157
	$l_max_idle_time_label		= "Max Idle Time";		// to translate
182
	$l_max_idle_time_label		= "Max Idle Time";		// to translate
158
	$l_start_time_label		= "Start Time";	// to translate
183
	$l_start_time_label		= "Start Time";	// to translate
159
	$l_session_time_label		= "Online tijd";
184
	$l_session_time_label		= "Online tijd";
160
	$l_idle_time_label		= "Idle Time";	// to translate
185
	$l_idle_time_label		= "Idle Time";	// to translate
161
	$l_downloaded_label		= "Downloaded";	// to translate
186
	$l_downloaded_label		= "Downloaded";	// to translate
162
	$l_uploaded_label		= "Uploaded";	// to translate
187
	$l_uploaded_label		= "Uploaded";	// to translate
163
	$l_original_url_label		= "Original URL";	// to translate
188
	$l_original_url_label		= "Original URL";	// to translate
164
	$l_not_available		= "Not available";	// to translate
189
	$l_not_available		= "Not available";	// to translate
165
	$l_na				= "N/A";		// to translate
190
	$l_na				= "N/A";		// to translate
166
	$l_error			= "error";		// to translate
191
	$l_error			= "error";		// to translate
167
	$l_welcome			= "Welcome";	// to translate
192
	$l_welcome			= "Welcome";	// to translate
168
	$l_conn_history			= "Your last $nb_connection_history connections";	// to translate
193
	$l_conn_history			= "Your last $nb_connection_history connections";	// to translate
169
	$l_connected 			= "logged"; // to translate 
194
	$l_connected 			= "logged"; // to translate 
170
	$l_a_connection			= "You have"; // to translate
195
	$l_a_connection			= "You have"; // to translate
171
	$l_a_connection_time		= "active connections on the network"; // to translate
196
	$l_a_connection_time		= "active connections on the network"; // to translate
172
}
197
}
173
else if($Language == 'fr'){
198
else if($Language == 'fr'){
174
	$l_login1			= "Authentification réussie";
199
	$l_login1			= "Authentification réussie";
175
	$l_logout			= "Fermeture de la session";
200
	$l_logout			= "Fermeture de la session";
176
	$l_logout_question		= "Etes vous sûr de vouloir vous déconnecter?";
201
	$l_logout_question		= "Êtes vous sûr de vouloir vous déconnecter?";
177
	$l_loggedout			= "Votre session est fermée";
202
	$l_loggedout			= "Votre session est fermée";
178
	$l_wait				= "Patientez un instant ....";
203
	$l_wait				= "Patientez un instant ....";
179
	$l_state_label			= "Etat";
204
	$l_state_label			= "État";
180
	$l_session_id_label		= "Session ID";
205
	$l_session_id_label		= "Session ID";
181
	$l_max_session_time_label	= "Temps de connexion autorisé";
206
	$l_max_session_time_label	= "Temps de connexion autorisé";
182
	$l_max_idle_time_label		= "Inactivité max. autorisée";
207
	$l_max_idle_time_label		= "Temps d'inactivité autorisé";
183
	$l_start_time_label		= "Début de connexion";
208
	$l_start_time_label		= "Début de connexion";
184
	$l_session_time_label		= "Durée de connexion";
209
	$l_session_time_label		= "Durée de connexion";
185
	$l_idle_time_label		= "Inactivité";
210
	$l_idle_time_label		= "Inactivité";
186
	$l_downloaded_label		= "Données téléchargées";
211
	$l_downloaded_label		= "Données téléchargées";
187
	$l_uploaded_label		= "Données envoyées";
212
	$l_uploaded_label		= "Données envoyées";
188
	$l_original_url_label		= "URL demandée";
213
	$l_original_url_label		= "URL demandée";
189
	$l_not_available		= "Non disponible";
214
	$l_not_available		= "Non disponible";
190
	$l_na				= "N/D";	// to translate
215
	$l_na				= "N/D";	// to translate
191
	$l_error			= "erreur";
216
	$l_error			= "erreur";
192
	$l_welcome			= "Bienvenue";
217
	$l_welcome			= "Bienvenue";
193
	$l_conn_history			= "Vos $nb_connection_history dernières connexions";
218
	$l_conn_history			= "Vos $nb_connection_history dernières connexions";
194
	$l_connected 			= "session active";  
219
	$l_connected 			= "session active";  
195
	$l_a_connection			= "Vous avez";
220
	$l_a_connection			= "Vous avez";
196
	$l_a_connection_time		= "connexions actives sur le réseau";
221
	$l_a_connection_time		= "connexions actives sur le réseau";
197
}
222
}
198
else {
223
else {
199
	$l_login1			= "Successful authentication.";
224
	$l_login1			= "Successful authentication.";
200
	$l_logout			= "Closing connection";
225
	$l_logout			= "Closing connection";
201
	$l_logout_question		= "Are you sure you want to disconnect now?";
226
	$l_logout_question		= "Are you sure you want to disconnect now?";
202
	$l_loggedout			= "Your session is closed";
227
	$l_loggedout			= "Your session is closed";
203
	$l_wait				= "Please wait a moment ...";
228
	$l_wait				= "Please wait a moment ...";
204
	$l_state_label			= "State";
229
	$l_state_label			= "State";
205
	$l_session_id_label		= "Session ID";
230
	$l_session_id_label		= "Session ID";
206
	$l_max_session_time_label	= "Max Session Time";
231
	$l_max_session_time_label	= "Max Session Time";
207
	$l_max_idle_time_label		= "Max Idle Time";
232
	$l_max_idle_time_label		= "Max Idle Time";
208
	$l_start_time_label		= "Start Time";
233
	$l_start_time_label		= "Start Time";
209
	$l_session_time_label		= "Session Time";
234
	$l_session_time_label		= "Session Time";
210
	$l_idle_time_label		= "Idle Time";
235
	$l_idle_time_label		= "Idle Time";
211
	$l_downloaded_label		= "Downloaded";
236
	$l_downloaded_label		= "Downloaded";
212
	$l_uploaded_label		= "Uploaded";
237
	$l_uploaded_label		= "Uploaded";
213
	$l_original_url_label		= "Original URL";
238
	$l_original_url_label		= "Original URL";
214
	$l_not_available		= "Not available";
239
	$l_not_available		= "Not available";
215
	$l_na				= "N/A";
240
	$l_na				= "N/A";
216
	$l_error			= "error";
241
	$l_error			= "error";
217
	$l_welcome			= "Welcome";
242
	$l_welcome			= "Welcome";
218
	$l_conn_history			= "Your last $nb_connection_history connections";
243
	$l_conn_history			= "Your last $nb_connection_history connections";
219
	$l_connected 			= "logged"; 
244
	$l_connected 			= "logged"; 
220
	$l_a_connection			= "You have";
245
	$l_a_connection			= "You have";
221
	$l_a_connection_time		= "active connections on the network";
246
	$l_a_connection_time		= "active connections on the network";
222
}
247
}
223
 
248
 
224
// si on a pas d'accès à la bdd, la page s'affiche quand même correctement
249
// si on a pas d'accès à la bdd, la page s'affiche quand même correctement
225
if (isset($user[5])){
250
if (isset($user[5])){
226
	if ((is_file("./acc/manager/lib/sql/drivers/mysql/functions.php"))&&(is_file("/etc/freeradius-web/config.php"))){
251
	if ((is_file("./acc/manager/lib/sql/drivers/mysql/functions.php"))&&(is_file("/etc/freeradius-web/config.php"))){
227
		include_once("/etc/freeradius-web/config.php");
252
		include_once("/etc/freeradius-web/config.php");
228
		include_once("./acc/manager/lib/sql/drivers/mysql/functions.php");
253
		include_once("./acc/manager/lib/sql/drivers/mysql/functions.php");
229
		
254
		
230
		$sql = "SELECT UserName, AcctStartTime, AcctStopTime, acctsessiontime FROM radacct WHERE UserName='$user[5]' ORDER BY AcctStartTime DESC LIMIT 0 , $nb_connection_history";
255
		$sql = "SELECT UserName, AcctStartTime, AcctStopTime, acctsessiontime FROM radacct WHERE UserName='$user[5]' ORDER BY AcctStartTime DESC LIMIT 0 , $nb_connection_history";
231
		$link = @da_sql_pconnect($config); // on affiche pas les erreurs
256
		$link = @da_sql_pconnect($config); // on affiche pas les erreurs
232
		
257
		
233
		if ($link){
258
		if ($link){
234
			$res = @da_sql_query($link,$config,$sql); // on affiche pas les erreurs
259
			$res = @da_sql_query($link,$config,$sql); // on affiche pas les erreurs
235
			
260
			
236
			if ($res){
261
			if ($res){
237
				$a_connection = ""; $a_connected=0; $connection_history.= "<ul>";
262
				$a_connection = ""; $a_connected=0; $connection_history.= "<ul>";
238
				while(($row = @da_sql_fetch_array($res,$config))){
263
				while(($row = @da_sql_fetch_array($res,$config))){
239
					$connected = "";
264
					$connected = "";
240
					$start_conn = date_create($row['acctstarttime']);
265
					$start_conn = date_create($row['acctstarttime']);
241
					$connection_history.="<li>".date_format($start_conn, 'd M Y - H:i:s')." - (";
266
					$connection_history.="<li>".date_format($start_conn, 'd M Y - H:i:s')." - (";
242
					if ($row['acctstoptime'] == "") {
267
					if ($row['acctstoptime'] == "") {
243
						$connected = $l_connected;
268
						$connected = $l_connected;
244
						$a_connected = $a_connected +1;
269
						$a_connected = $a_connected +1;
245
					}else{
270
					}else{
246
						$connected = secondsToDuration($row['acctsessiontime']);
271
						$connected = secondsToDuration($row['acctsessiontime']);
247
					}
272
					}
248
					$connection_history.= "$connected)</li>";
273
					$connection_history.= "$connected)</li>";
249
				}
274
				}
250
				$connection_history.="</ul>";
275
				$connection_history.="</ul>";
251
				if ($a_connected > 1){
276
				if ($a_connected > 1){
252
					$a_connection = $l_a_connection." ".$a_connected." ".$l_a_connection_time; }
277
					$a_connection = $l_a_connection." ".$a_connected." ".$l_a_connection_time; }
253
			}
278
			}
254
		}
279
		}
255
		
280
		
256
		//store in a file user @IP who can join this page.
281
		//store in a file user @IP who can join this page.
257
		$filename='/tmp/current_users.txt';
282
		$filename='/tmp/current_users.txt';
258
		//change me avoid duplicate user @IP
283
		//change me avoid duplicate user @IP
259
		$change_me = 1;
284
		$change_me = 1;
260
 
285
 
261
		//check if filename exists
286
		//check if filename exists
262
		if(file_exists($filename)){
287
		if(file_exists($filename)){
263
			$fichier = fopen($filename, "r");
288
			$fichier = fopen($filename, "r");
264
			$content = file($filename);
289
			$content = file($filename);
265
 
290
 
266
			//if file is empty, we put user @IP in it.
291
			//if file is empty, we put user @IP in it.
267
			if(empty($content))
292
			if(empty($content))
268
			{
293
			{
269
				file_put_contents($filename, $_SERVER['REMOTE_ADDR']);
294
				file_put_contents($filename, $_SERVER['REMOTE_ADDR']);
270
			}
295
			}
271
			else
296
			else
272
			{
297
			{
273
				//if we found duplicate IP, it will not write user @IP in filename (set change_me = 0)
298
				//if we found duplicate IP, it will not write user @IP in filename (set change_me = 0)
274
				foreach($content as $line){
299
				foreach($content as $line){
275
				        $line = preg_replace('/\s+/', '', $line);
300
				        $line = preg_replace('/\s+/', '', $line);
276
				        if($line == $_SERVER['REMOTE_ADDR'])
301
				        if($line == $_SERVER['REMOTE_ADDR'])
277
				        {
302
				        {
278
				                $change_me = 0;
303
				                $change_me = 0;
279
				        }
304
				        }
280
 
305
 
281
				}
306
				}
282
 
307
 
283
				//if user @IP does not exist, we will write it in filename
308
				//if user @IP does not exist, we will write it in filename
284
				if($change_me)
309
				if($change_me)
285
				{
310
				{
286
				        file_put_contents($filename, $_SERVER['REMOTE_ADDR'].PHP_EOL , FILE_APPEND);
311
				        file_put_contents($filename, $_SERVER['REMOTE_ADDR'].PHP_EOL , FILE_APPEND);
287
				}
312
				}
288
			}
313
			}
289
 
314
 
290
		}
315
		}
291
		else
316
		else
292
		{
317
		{
293
			//we create filename and we put user @IP in it.
318
			//we create filename and we put user @IP in it.
294
			file_put_contents($filename, $_SERVER['REMOTE_ADDR'].PHP_EOL);
319
			file_put_contents($filename, $_SERVER['REMOTE_ADDR'].PHP_EOL);
295
		}
320
		}
296
		
321
		
297
		
322
		
298
	}
323
	}
299
}
324
}
300
?>
325
?>
301
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
326
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
302
<html lang="fr">
327
<html lang="fr">
303
<!-- written by steweb57 -->
328
<!-- written by steweb57 -->
304
	<head>
329
	<head>
305
		<title>Alcasar - <?php echo $organisme; ?></title>
330
		<title>Alcasar - <?php echo $organisme; ?></title>
306
		<meta http-equiv="Cache-control" content="no-cache">
331
		<meta http-equiv="Cache-control" content="no-cache">
307
		<meta http-equiv="Pragma" content="no-cache">
332
		<meta http-equiv="Pragma" content="no-cache">
308
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
333
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
309
		<script type="text/javascript" src="./js/ChilliLibrary.js"></script>
334
		<script type="text/javascript" src="./js/ChilliLibrary.js"></script>
310
		<script type="text/javascript" src="./js/statusControler.js"></script>
335
		<script type="text/javascript" src="./js/statusControler.js"></script>
311
		<link type="text/css" href="./css/status.css" rel="stylesheet">
336
		<link type="text/css" href="./css/status.css" rel="stylesheet">
312
	</head>
337
	</head>
313
	<body>
338
	<body>
314
		<div id="Chilli">
339
		<div id="Chilli">
315
		<div id="locationName"></div>
340
		<div id="locationName"></div>
316
		<div id="chilliPage">
341
		<div id="chilliPage">
317
		<div id="loggedOutPage" class="c1">
342
		<div id="loggedOutPage" class="c1">
318
			<table id="disconnectTable">
343
			<table id="disconnectTable">
319
				<tr>
344
				<tr>
320
					<td><img height="150" src="./images/logo-alcasar.png" alt="logo"></td>
345
					<td><img height="150" src="./images/logo-alcasar.png" alt="logo"></td>
321
					<td><p class="text_auth"><?php echo $l_loggedout; ?></p></td>
346
					<td><p class="text_auth"><?php echo $l_loggedout; ?></p></td>
322
				</tr>
347
				</tr>
323
			</table>
348
			</table>
324
		</div>
349
		</div>
325
		<div id="statusPage" class="c1">
350
		<div id="statusPage" class="c1">
326
			<table border="0" id="statusTable">
351
			<table border="0" id="statusTable">
327
				<tr>
352
				<tr>
328
					<td colspan="2">
353
					<td colspan="2">
329
						<table border="0" cellpadding="0" cellspacing="0" width="100%">
354
						<table border="0" cellpadding="0" cellspacing="0" width="100%">
330
							<tr>
355
							<tr>
331
								<td valign="top" rowspan="4">
356
								<td valign="top" rowspan="4">
332
									<img height="150" src="./images/logo-alcasar.png" alt="logo">
357
									<img height="150" src="./images/logo-alcasar.png" alt="logo">
333
								</td>
358
								</td>
334
								<td class="text_auth_welcom">
359
								<td class="text_auth_welcom">
335
									<?php echo $l_login1; ?>
360
									<?php echo $l_login1; ?>
336
								</td>
361
								</td>
337
							</tr>
362
							</tr>
338
							<tr>
363
							<tr>
339
								<td class="text_auth">
364
								<td class="text_auth">
340
									<?php echo $l_welcome; ?>
365
									<?php echo $l_welcome; ?>
341
									<br><span id="userName"></span>
366
									<br><span id="userName"></span>
342
								</td>
367
								</td>
343
							</tr>
368
							</tr>
344
							<tr>
369
							<tr>
345
								<td class="alert">
370
								<td class="alert">
346
									<?php if(isset($a_connection))echo $a_connection; ?>
371
									<?php if(isset($a_connection))echo $a_connection; ?>
347
								</td>
372
								</td>
348
							</tr>
373
							</tr>
349
							<tr>
374
							<tr>
350
								<td colspan="2" align="center" class="link_logout">
375
								<td colspan="2" align="center" class="link_logout">
351
									<a href="#" onclick="return logoutWithConfirmation('<?php echo $l_logout_question;?>');" class="lien_deco"><?php echo $l_logout; ?></a>
376
									<a href="#" onclick="return logoutWithConfirmation('<?php echo $l_logout_question;?>');" class="lien_deco"><?php echo $l_logout; ?></a>
352
								</td>
377
								</td>
353
							</tr>
378
							</tr>
354
						</table>
379
						</table>
355
					</td>
380
					</td>
356
				</tr>
381
				</tr>
357
<!--tr id="connectRow">
382
<!--tr id="connectRow">
358
<td id="statusMessageLabel" class="chilliLabel"><strong><?php echo $l_state_label; ?></strong></td>
383
<td id="statusMessageLabel" class="chilliLabel"><strong><?php echo $l_state_label; ?></strong></td>
359
<td id="statusMessage" class="chilliValue">Connected</td>
384
<td id="statusMessage" class="chilliValue">Connected</td>
360
</tr-->
385
</tr-->
361
<!--tr id="sessionIdRow">
386
<!--tr id="sessionIdRow">
362
<td id="sessionIdLabel" class="chilliLabel"><strong><?php echo $l_session_id_label; ?></strong></td>
387
<td id="sessionIdLabel" class="chilliLabel"><strong><?php echo $l_session_id_label; ?></strong></td>
363
<td id="sessionId" class="chilliValue"><?php echo $l_not_available; ?></td>
388
<td id="sessionId" class="chilliValue"><?php echo $l_not_available; ?></td>
364
</tr-->
389
</tr-->
365
				<tr id="sessionTimeoutRow">
390
				<tr id="sessionTimeoutRow">
366
					<td id="sessionTimeoutLabel" class="chilliLabel"><?php echo $l_max_session_time_label; ?></td>
391
					<td id="sessionTimeoutLabel" class="chilliLabel"><?php echo $l_max_session_time_label; ?></td>
367
					<td id="sessionTimeout" class="chilliValue"><?php echo $l_not_available; ?></td>
392
					<td id="sessionTimeout" class="chilliValue"><?php echo $l_not_available; ?></td>
368
				</tr>
393
				</tr>
369
				<tr id="idleTimeoutRow">
394
				<tr id="idleTimeoutRow">
370
					<td id="idleTimeoutLabel" class="chilliLabel"><?php echo $l_max_idle_time_label; ?></td>
395
					<td id="idleTimeoutLabel" class="chilliLabel"><?php echo $l_max_idle_time_label; ?></td>
371
					<td id="idleTimeout" class="chilliValue"><?php echo $l_not_available; ?></td>
396
					<td id="idleTimeout" class="chilliValue"><?php echo $l_not_available; ?></td>
372
				</tr>
397
				</tr>
373
				<tr id="startTimeRow">
398
				<tr id="startTimeRow">
374
					<td id="startTimeLabel" class="chilliLabel"><?php echo $l_start_time_label; ?></td>
399
					<td id="startTimeLabel" class="chilliLabel"><?php echo $l_start_time_label; ?></td>
375
					<td id="startTime" class="chilliValue"><?php echo $l_not_available; ?></td>
400
					<td id="startTime" class="chilliValue"><?php echo $l_not_available; ?></td>
376
				</tr>
401
				</tr>
377
				<tr id="sessionTimeRow">
402
				<tr id="sessionTimeRow">
378
					<td id="sessionTimeLabel" class="chilliLabel"><?php echo $l_session_time_label; ?></td>
403
					<td id="sessionTimeLabel" class="chilliLabel"><?php echo $l_session_time_label; ?></td>
379
					<td id="sessionTime" class="chilliValue"><?php echo $l_not_available; ?></td>
404
					<td id="sessionTime" class="chilliValue"><?php echo $l_not_available; ?></td>
380
				</tr>
405
				</tr>
381
				<tr id="idleTimeRow">
406
				<tr id="idleTimeRow">
382
					<td id="idleTimeLabel" class="chilliLabel"><?php echo $l_idle_time_label; ?></td>
407
					<td id="idleTimeLabel" class="chilliLabel"><?php echo $l_idle_time_label; ?></td>
383
					<td id="idleTime" class="chilliValue"><?php echo $l_not_available; ?></td>
408
					<td id="idleTime" class="chilliValue"><?php echo $l_not_available; ?></td>
384
				</tr>
409
				</tr>
385
				<tr id="inputOctetsRow">
410
				<tr id="inputOctetsRow">
386
					<td id="inputOctetsLabel" class="chilliLabel"><?php echo $l_downloaded_label; ?></td>
411
					<td id="inputOctetsLabel" class="chilliLabel"><?php echo $l_downloaded_label; ?></td>
387
					<td id="inputOctets" class="chilliValue"><?php echo $l_na; ?></td>
412
					<td id="inputOctets" class="chilliValue"><?php echo $l_na; ?></td>
388
				</tr>
413
				</tr>
389
				<tr id="outputOctetsRow">
414
				<tr id="outputOctetsRow">
390
					<td id="outputOctetsLabel" class="chilliLabel"><?php echo $l_uploaded_label; ?></td>
415
					<td id="outputOctetsLabel" class="chilliLabel"><?php echo $l_uploaded_label; ?></td>
391
					<td id="outputOctets" class="chilliValue"><?php echo $l_na; ?></td>
416
					<td id="outputOctets" class="chilliValue"><?php echo $l_na; ?></td>
392
				</tr>
417
				</tr>
393
<!--tr id="originalURLRow">
418
<!--tr id="originalURLRow">
394
<td id="originalURLLabel" class="chilliLabel"><?php echo $l_original_url_label; ?></td>
419
<td id="originalURLLabel" class="chilliLabel"><?php echo $l_original_url_label; ?></td>
395
<td id="originalURL" class="chilliValue"><?php echo $l_na; ?></td>
420
<td id="originalURL" class="chilliValue"><?php echo $l_na; ?></td>
396
</tr-->
421
</tr-->
397
				<tr>
422
				<tr>
398
					<td colspan=2 id="conHistoryLabel" class="chilliLabel"><?php echo $l_conn_history; ?></td>
423
					<td colspan=2 id="conHistoryLabel" class="chilliLabel"><?php echo $l_conn_history; ?></td>
399
				</tr>
424
				</tr>
400
				<tr id="conHistoryRow">
425
				<tr id="conHistoryRow">
401
					<td colspan=2 id="conHistory" class="chilliValue"><?php echo $connection_history; ?></td>
426
					<td colspan=2 id="conHistory" class="chilliValue"><?php echo $connection_history; ?></td>
402
				</tr>
427
				</tr>
403
			</table>
428
			</table>
404
		</div>
429
		</div>
405
		<div id="waitPage">
430
		<div id="waitPage">
406
			<table id="waitTable">
431
			<table id="waitTable">
407
				<tr>
432
				<tr>
408
					<td><img height="150" src="./images/logo-alcasar.png" alt="logo"></td>
433
					<td><img height="150" src="./images/logo-alcasar.png" alt="logo"></td>
409
					<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>
434
					<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>
410
				</tr>
435
				</tr>
411
			</table>
436
			</table>
412
		</div>
437
		</div>
413
		<div id="errorPage">
438
		<div id="errorPage">
414
			<table id="errorTable">
439
			<table id="errorTable">
415
				<tr>
440
				<tr>
416
					<td><img height="150" src="./images/logo-alcasar.png" alt="logo"></td>
441
					<td><img height="150" src="./images/logo-alcasar.png" alt="logo"></td>
417
					<td><span id="errorMessage"><?php echo $l_error; ?></span></td>
442
					<td><span id="errorMessage"><?php echo $l_error; ?></span></td>
418
				</tr>
443
				</tr>
419
			</table>
444
			</table>
420
		</div>
445
		</div>
421
		</div>
446
		</div>
422
<!--div id="debugPage" style="display:inline;">
447
<!--div id="debugPage" style="display:inline;">
423
<textarea id="debugarea" rows="20" cols="60">
448
<textarea id="debugarea" rows="20" cols="60">
424
</textarea>
449
</textarea>
425
</div-->
450
</div-->
426
		</div>
451
		</div>
427
	</body>
452
	</body>
428
	
453
	
429
<!-- For no compliant browser with these javascript functions : onbeforeunload and unload, to disconnect users whose close status.php window. Now, we check if user is still connected while he is joinning 'still_connected.php' -->
454
<!-- For no compliant browser with these javascript functions : onbeforeunload and unload, to disconnect users whose close status.php window. Now, we check if user is still connected while he is joinning 'still_connected.php' -->
430
<iframe id='iframe1' name='iframe1' src='/still_connected.php' frameborder="0" frameborder="0" width='0' height='0'></iframe>
455
<iframe id='iframe1' name='iframe1' src='/still_connected.php' frameborder="0" frameborder="0" width='0' height='0'></iframe>
431
<script>
456
<script>
432
document.getElementById('iframe1').contentDocument.location.reload(true);
457
document.getElementById('iframe1').contentDocument.location.reload(true);
433
window.setInterval("reloadIFrame();", 170000);
458
window.setInterval("reloadIFrame();", 170000);
434
function reloadIFrame() {
459
function reloadIFrame() {
435
	document.getElementById("iframe1").src="/still_connected.php";
460
	document.getElementById("iframe1").src="/still_connected.php";
436
}
461
}
437
</script>
462
</script>
438
 
463
 
439
</html>
464
</html>
440
 
465