Subversion Repositories ALCASAR

Rev

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

Rev 2809 Rev 2822
1 
<?php
 1 
<?php
2 
# $Id: autoregistrationinfo.php 2809 2020-04-12 17:35:46Z rexy $
 2 
# $Id: autoregistrationinfo.php 2822 2020-05-23 16:03:33Z rexy $
- 
 
 3 
#
- 
 
 4 
# SMS Autoregistration
- 
 
 5 
# By Rexy
3 
 
 6 
 
4 
define('CONF_FILE', '/usr/local/etc/alcasar.conf');
 7 
define('CONF_FILE', '/usr/local/etc/alcasar.conf');
5 
 
 8 
 
6 
// Read CONF_FILE
 9 
// Read CONF_FILE
7 
$file_conf = fopen(CONF_FILE, 'r');
 10 
$file_conf = fopen(CONF_FILE, 'r');
8 
if (!$file_conf) {
 11 
if (!$file_conf) {
9 
	exit('Error opening the file '.CONF_FILE);
 12 
	exit('Error opening the file '.CONF_FILE);
10 
}
 13 
}
11 
while (!feof($file_conf)) {
 14 
while (!feof($file_conf)) {
12 
	$buffer = fgets($file_conf, 4096);
 15 
	$buffer = fgets($file_conf, 4096);
13 
	if ((strpos($buffer, '=') !== false) && (substr($buffer, 0, 1) !== '#')) {
 16 
	if ((strpos($buffer, '=') !== false) && (substr($buffer, 0, 1) !== '#')) {
14 
		$tmp = explode('=', $buffer, 2);
 17 
		$tmp = explode('=', $buffer, 2);
15 
		$conf[trim($tmp[0])] = trim($tmp[1]);
 18 
		$conf[trim($tmp[0])] = trim($tmp[1]);
16 
	}
 19 
	}
17 
}
 20 
}
18 
fclose($file_conf);
 21 
fclose($file_conf);
19 
 
 22 
 
20 
// Check if the SMS service is enable
 23 
// Check if the SMS service is enable
21 
if ($conf['SMS'] !== 'on') {
 24 
if ($conf['SMS'] !== 'on') {
22 
	header('Location: /');
 25 
	header('Location: /');
23 
	exit();
 26 
	exit();
24 
}
 27 
}
25 
 
 - 
 
26 
$organisme   = $conf['ORGANISM'];
 28 
$organisme   = $conf['ORGANISM'];
27 
$current_num = $conf['SMS_NUM'];
 29 
$current_num = $conf['SMS_NUM'];
28 
 
 30 
 
29 
 
 31 
 
30 
// Choice of language
 32 
// Choice of language
31 
$Language = 'en';
 33 
$Language = 'en';
32 
if(isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])) {
 34 
if(isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])) {
33 
	$Langue = explode(',', $_SERVER['HTTP_ACCEPT_LANGUAGE']);
 35 
	$Langue = explode(',', $_SERVER['HTTP_ACCEPT_LANGUAGE']);
34 
	$Language = strtolower(substr(chop($Langue[0]), 0, 2));
 36 
	$Language = strtolower(substr(chop($Langue[0]), 0, 2));
35 
}
 37 
}
36 
if ($Language === 'fr') {	// French
 38 
if ($Language === 'fr') {	// French
37 
	$l_title		= "Page d'auto enregistrement";
 39 
	$l_title		= "Page d'auto enregistrement";
38 
	$l_num_exist		= "Compte actif";
 40 
	$l_num_exist		= "Compte actif";
39 
	$l_num_flood		= "Numéro bloqué: nombre d'essai dépassé.";
 41 
	$l_num_flood		= "Numéro bloqué: nombre d'essai dépassé.";
40 
 
 42 
 
41 
	$l_num_num		= "Numero de téléphone";
 43 
	$l_num_num		= "Numero de téléphone";
42 
	$l_num_raison		= "Etat de votre numéro";
 44 
	$l_num_raison		= "Etat de votre numéro";
43 
	$l_num_expiration	= "Expiration du bloquage";
 45 
	$l_num_expiration	= "Expiration du bloquage";
44 
 
 46 
 
45 
	$l_tuto_1		= "Bienvenue sur la page d'auto enregistrement.";
 47 
	$l_tuto_1		= "Bienvenue sur la page d'auto enregistrement.";
46 
	$l_tuto_2		= "Ce portail d'accès à Internet vous offre la possibilité de vous inscrire en envoyant le mot de passe de votre choix par SMS au numéro suivant (prix d'un SMS, non surtaxé).";
 48 
	$l_tuto_2		= "Ce portail d'accès à Internet vous offre la possibilité de vous inscrire en envoyant le mot de passe de votre choix par SMS au numéro suivant (prix d'un SMS, non surtaxé).";
47 
	$l_tuto_3		= "Votre SMS ne doit contenir qu'un seul mot.";
 49 
	$l_tuto_3		= "Votre SMS ne doit contenir qu'un seul mot.";
48 
	$l_tuto_4		= "Votre inscription sera activée lorsque vous retrouverez votre numéro de téléphone dans le tableau ci-dessous. Ce numéro de téléphone constitue votre identifiant de connexion";
 50 
	$l_tuto_4		= "Votre inscription sera activée lorsque vous retrouverez votre numéro de téléphone dans le tableau ci-dessous. Ce numéro de téléphone constitue votre identifiant de connexion";
49 
	$l_tuto_5		= "Le champ de recherche ci-dessous vous permet de retrouver votre numéro suivant les 5 derniers chiffres.";
51 
	$l_tuto_5		= "Le champ de recherche ci-dessous vous permet de retrouver votre numéro suivant les 5 derniers chiffres.";
50 
 
 52 
 
51 
	$l_tab_first		= "premier";
 53 
	$l_tab_first		= "premier";
52 
	$l_tab_last		= "dernier";
 54 
	$l_tab_last		= "dernier";
53 
	$l_tab_next		= "suivant";
 55 
	$l_tab_next		= "suivant";
54 
	$l_tab_prev		= "précédent";
 56 
	$l_tab_prev		= "précédent";
55 
	$l_tab_search		= "Recherche :";
 57 
	$l_tab_search		= "Recherche :";
56 
	$l_tab_pmenu		= "Affiche la page _PAGE_ sur _PAGES_";
 58 
	$l_tab_pmenu		= "Affiche la page _PAGE_ sur _PAGES_";
57 
	$l_tab_info		= "Montrer _MENU_ résultats par page";
 59 
	$l_tab_info		= "Montrer _MENU_ résultats par page";
58 
	$l_tab_infoempty	= "Aucun résultat";
 60 
	$l_tab_infoempty	= "Aucun résultat";
59 
 
 61 
 
60 
	$l_autorefresh		= "Rafraichissement : 10 sec";
 62 
	$l_autorefresh		= "Rafraichissement : 10 sec";
61 
} else {			// English
 63 
} else {			// English
62 
	$l_title		= "Autoregistration";
 64 
	$l_title		= "Autoregistration";
63 
	$l_num_exist		= "Account enables";
 65 
	$l_num_exist		= "Account enables";
64 
	$l_num_flood		= "Phone number banned: Number of trial exceeded.";
 66 
	$l_num_flood		= "Phone number banned: Number of trial exceeded.";
65 
 
 67 
 
66 
	$l_num_num		= "Phone number";
 68 
	$l_num_num		= "Phone number";
67 
	$l_num_raison		= "Status of your phone number";
 69 
	$l_num_raison		= "Status of your phone number";
68 
	$l_num_expiration	= "Expiration";
 70 
	$l_num_expiration	= "Expiration";
69 
 
 71 
 
70 
	$l_tuto_1		= "Welcome to the auto-enrollment page";
 72 
	$l_tuto_1		= "Welcome to the auto-enrollment page";
71 
	$l_tuto_2		= "This portal allows you to enroll by sending the password of you choice via SMS to the following number (no surcharge) :";
 73 
	$l_tuto_2		= "This portal allows you to enroll by sending the password of you choice via SMS to the following number (no surcharge) :";
72 
	$l_tuto_3		= "Just send 1 word in your SMS.";
 74 
	$l_tuto_3		= "Just send 1 word in your SMS.";
73 
	$l_tuto_4		= "Your registration will be activated when you'll find your phone number in the following table. This phone number is your login name";
 75 
	$l_tuto_4		= "Your registration will be activated when you'll find your phone number in the following table. This phone number is your login name";
74 
	$l_tuto_5		= "You can search your phone number according to the 5 last digits in your phone number.";
 76 
	$l_tuto_5		= "You can search your phone number according to the 5 last digits in your phone number.";
75
77
76 
	$l_tab_first		= "first";
 78 
	$l_tab_first		= "first";
77 
	$l_tab_last		= "last";
 79 
	$l_tab_last		= "last";
78 
	$l_tab_next		= "next";
 80 
	$l_tab_next		= "next";
79 
	$l_tab_prev		= "previous";
 81 
	$l_tab_prev		= "previous";
80 
	$l_tab_search		= "Search :";
 82 
	$l_tab_search		= "Search :";
81 
	$l_tab_pmenu		= "Showing _PAGE_ to _PAGE_ of _PAGE_ entries :";
 83 
	$l_tab_pmenu		= "Showing _PAGE_ to _PAGE_ of _PAGE_ entries :";
82 
	$l_tab_info		= "Show _MENU_ entries";
 84 
	$l_tab_info		= "Show _MENU_ entries";
83 
	$l_tab_infoempty	= "No matching records found";
 85 
	$l_tab_infoempty	= "No matching records found";
84 
 
 86 
 
85 
	$l_autorefresh		= "Refresh: 10 sec";
 87 
	$l_autorefresh		= "Refresh: 10 sec";
86 
}
 88 
}
87 
 
 89 
 
88 
// Get SMS from database
 90 
// Get SMS from database
89 
require('/etc/freeradius-web/config.php');
 91 
require('/etc/freeradius-web/config.php');
- 
 
 92 
$img_rep         = '/images/';
- 
 
 93 
$img_sms         = 'sms.png';
90 
 
 94 
 
91 
$con = mysqli_connect($config['sql_server'], $config['sql_username'], $config['sql_password'], 'gammu');
 95 
$con = mysqli_connect($config['sql_server'], $config['sql_username'], $config['sql_password'], 'gammu');
92 
 
 96 
 
93 
if (mysqli_connect_errno()) {
 97 
if (mysqli_connect_errno()) {
94 
	exit('Failed to connect to ' . $config['sql_type']/* . ': ' . mysqli_connect_error()*/);
 98 
	exit('Failed to connect to ' . $config['sql_type']/* . ': ' . mysqli_connect_error()*/);
95 
}
 99 
}
96 
 
 100 
 
97 
$result = mysqli_query($con, 'SELECT * FROM `SMS_ban_perm` ORDER BY date_add DESC;');
 101 
$result = mysqli_query($con, 'SELECT * FROM `SMS_ban_perm` ORDER BY date_add DESC;');
98 
 
 102 
 
99 
$smsBanPerms = [];
 103 
$smsBanPerms = [];
100 
while ($row = mysqli_fetch_array($result)) {
 104 
while ($row = mysqli_fetch_array($result)) {
101 
	$smsBanPerms[] = (object) [
 105 
	$smsBanPerms[] = (object) [
102 
		'numberHidden' => substr($row['SenderNumber'], 0, 3) . '****' . substr($row['SenderNumber'], -5),
 106 
		'numberHidden' => substr($row['SenderNumber'], 0, 3) . '****' . substr($row['SenderNumber'], -5),
103 
		'expiration'   => $row['Expiration'],
 107 
		'expiration'   => $row['Expiration'],
104 
		'perm'         => $row['Perm']
 108 
		'perm'         => $row['Perm']
105 
	];
 109 
	];
106 
}
 110 
}
107 
mysqli_close($con);
 111 
mysqli_close($con);
108 
 
 112 
 
109 
?>
 113 
?>
110 
<!DOCTYPE html>
 114 
<!DOCTYPE html>
111 
<html><!-- written by Rexy -->
 115 
<html><!-- written by Rexy -->
112 
<head>
 116 
<head>
113 
	<meta charset="utf-8">
 117 
	<meta charset="utf-8">
- 
 
 118 
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
114 
	<title>Auto enregistrement</title>
 119 
	<title>ALCASAR - <?= $l_title ?></title>
115 
	<link rel="stylesheet" type="text/css" href="/css/error.css">
 120 
	<link rel="stylesheet" type="text/css" href="/css/bootstrap.min.css">
116 
	<!-- DataTables CSS -->
 121 
	<link rel="stylesheet" type="text/css" href="/css/index.css">
117 
	<link rel="stylesheet" type="text/css" href="/css/jquery.dataTables.css">
 122 
	<link rel="stylesheet" type="text/css" href="/css/jquery.dataTables.css">
118 
	<!-- jQuery -->
 - 
 
119 
	<script charset="utf8" src="/js/jquery.min.js"></script>
 123 
	<script src="/js/jquery.min.js"></script>
120 
	<!-- DataTables -->
 - 
 
121 
	<script charset="utf8" src="/js/jquery.dataTables.js"></script>
 124 
	<script src="/js/jquery.dataTables.js"></script>
122 
	<script>
 125 
	<script>
123 
	function timedRefresh(timeoutPeriod) {
 126 
	function timedRefresh(timeoutPeriod) {
124 
		var interval = setInterval(refreshPage, timeoutPeriod);
 127 
		var interval = setInterval(refreshPage, timeoutPeriod);
125 
	}
 128 
	}
126 
 
 129 
 
127 
	function refreshPage() {
 130 
	function refreshPage() {
128 
		if ($('input[name=autoRefreshCheckboxes]').is(':checked')) {
 131 
		if ($('input[name=autoRefreshCheckboxes]').is(':checked')) {
129 
			location.reload(true);
 132 
			location.reload(true);
130 
		}
 133 
		}
131 
	}
 134 
	}
132 
 
 135 
 
133 
	$(document).ready( function () {
 136 
	$(document).ready( function () {
134 
		$('#table_id').DataTable({
 137 
		$('#table_id').DataTable({
135 
			"language": {
 138 
			"language": {
136 
				"paginate": {
 139 
				"paginate": {
137 
					"sFirst":    "<?= $l_tab_first ?>",
 140 
					"sFirst":    "<?= $l_tab_first ?>",
138 
					"sLast":     "<?= $l_tab_last ?>",
 141 
					"sLast":     "<?= $l_tab_last ?>",
139 
					"sPrevious": "<?= $l_tab_prev ?>",
 142 
					"sPrevious": "<?= $l_tab_prev ?>",
140 
					"sNext":     "<?= $l_tab_next ?>"
 143 
					"sNext":     "<?= $l_tab_next ?>"
141 
				},
 144 
				},
142 
				"lengthMenu":  "<?= $l_tab_info ?>",
 145 
				"lengthMenu":  "<?= $l_tab_info ?>",
143 
				"zeroRecords": "<?= $l_tab_infoempty ?>",
 146 
				"zeroRecords": "<?= $l_tab_infoempty ?>",
144 
				"info":        "<?= $l_tab_pmenu ?>",
 147 
				"info":        "<?= $l_tab_pmenu ?>",
145 
				"infoEmpty":   "<?= $l_tab_infoempty ?>",
 148 
				"infoEmpty":   "<?= $l_tab_infoempty ?>",
146 
				"sSearch":     "<?= $l_tab_search ?>"
 149 
				"sSearch":     "<?= $l_tab_search ?>"
147 
			}
 150 
			}
148 
		});
 151 
		});
149 
	});
 152 
	});
150 
	</script>
 153 
	</script>
151 
</head>
 154 
</head>
152 
<body onload="timedRefresh(10000);">
 155 
<body onload="timedRefresh(10000);">
153 
	<center>
 - 
 
154 
	<div id="logon">
 156 
	<div class="col-xs-12 col-md-10 col-md-offset-1">
155 
		<h1><?= $organisme ?></h1>
 157 
		<!-- HeaderBox -->
156 
		<h2><?= $l_title ?></h2>
 158 
		<div class="row banner">
157 
 
 - 
 
158 
		<div>
 159 
			<!-- Logo box -->
159 
		<table id="boite-info">
 160 
			<div class="img_banner hidden-xs col-sm-3 col-md-2 col-lg-2">
160 
			<tr>
 - 
 
161 
				<td rowspan="6" width="30%"><img id="logo-organ" src="/images/organisme.png"></td>
 161 
				<img class="img-responsive img-organisme" src="images/organisme.png">
162 
			</tr>
 162 
			</div>
163 
			<tr>
 - 
 
164 
				<td><?= $l_tuto_1 ?></td>
 - 
 
165 
			</tr>
 163 
			<!-- Title -->
166 
			<tr>
 - 
 
167 
				<td><?= $l_tuto_2 ?></td>
 164 
			<div id="cadre_titre" class="titre_banner col-xs-12 col-sm-8">
168 
			</tr>
 - 
 
169 
			<tr>
 - 
 
170 
				<td align="center"><h3><?= $current_num ?></h3></td>
 165 
					<p id="acces_controle" class="titre_controle"><?= $l_title ?></p>
171 
			</tr>
 166 
			</div>
172 
			<tr>
 - 
 
173 
				<td><?= $l_tuto_3 ?></td>
 167 
			<!-- Logo box -->
174 
			</tr>
 - 
 
175 
			<tr>
 - 
 
176 
				<td><?= $l_tuto_4 ?></td>
 168 
			<div class="img_banner hidden-xs col-sm-3 col-md-2 col-lg-2">
177 
			</tr>
 - 
 
178 
<!--
 - 
 
179 
			<tr>
 - 
 
180 
				<td colspan="2"><?= $l_tuto_5 ?></td>
 169 
				<img class="img-responsive img-organisme" src="images/logo-alcasar_70.png">
181 
			</tr>
 170 
			</div>
182 
-->
 - 
 
183 
		</table>
 - 
 
184 
		</div>
 171 
		</div>
185 
 
 - 
 
- 
 
 172 
		<!-- Main content box -->
186 
		<div>
 173 
		<div class="row">
187 
		<label><input type="checkbox" checked="checked" name="autoRefreshCheckboxes"><?= $l_autorefresh ?></label>
 174 
			<div id="contenu_acces" class="col-xs-12 col-lg-offset-1 col-lg-10">
- 
 
 175 
				<h3><?= $l_tuto_2 ?></h3>
- 
 
 176 
				<div class="menu-container container col_xs_12 col-sm-7">
188 
		<table id="table_id" class="display">
 177 
					<div class="box_menu_right box_menu">
- 
 
 178 
						<span><?= $current_num ?></span>
- 
 
 179 
						<div class="menu-image">
- 
 
 180 
							<img class="img-responsive" src="<?= $img_rep.$img_sms ?>">
189 
			<thead>
 181 
						</div>
- 
 
 182 
					</div>
190 
				<tr>
 183 
				</div>
191 
					<th><b><?= $l_num_num ?></b></th>
 184 
				<div class="info-box-container col-sm-5">
192 
					<th><b><?= $l_num_raison ?></b></th>
 185 
					<div id="box_infos">
193 
					<th><b><?= $l_num_expiration ?></b></th>
 186 
						<p class="box_infos_explanations"><?= $l_tuto_3 ?>
- 
 
 187 
					</div>
194 
				</tr>
 188 
				</div>
195 
			</thead>
 189 
			</div>
196 
			<tbody>
 190 
		</div>
- 
 
 191 
	<p>
- 
 
 192 
		<div class="row">
- 
 
 193 
			<div id="contenu_acces" class="col-xs-12 col-lg-offset-1 col-lg-10">
- 
 
 194 
				<h4><?= $l_tuto_4 ?></h4>
- 
 
 195 
				<h4><?= $l_tuto_5 ?></h4>
- 
 
 196 
				<label><input type="checkbox" checked="checked" name="autoRefreshCheckboxes"><?= $l_autorefresh ?></label>
197 
				<?php foreach ($smsBanPerms as $smsBanPerm): ?>
 197 
				<table id="table_id" class="display">
- 
 
 198 
				<thead>
198 
					<tr>
 199 
					<tr>
- 
 
 200 
						<th><b><?= $l_num_num ?></b></th>
- 
 
 201 
						<th><b><?= $l_num_raison ?></b></th>
- 
 
 202 
						<th><b><?= $l_num_expiration ?></b></th>
- 
 
 203 
					</tr>
- 
 
 204 
				</thead>
- 
 
 205 
				<tbody>
- 
 
 206 
					<?php foreach ($smsBanPerms as $smsBanPerm): ?>
- 
 
 207 
						<tr>
199 
						<td><?= $smsBanPerm->numberHidden ?></td>
 208 
							<td><?= $smsBanPerm->numberHidden ?></td>
200 
 
 - 
 
201 
						<?php if ($smsBanPerm->perm == '0'): ?>
 209 
							<?php if ($smsBanPerm->perm == '0'): ?>
202 
							<td><?= $l_num_exist ?></td>
 210 
							<td><?= $l_num_exist ?></td>
203 
						<?php elseif ($smsBanPerm->perm == '1'): ?>
 211 
							<?php elseif ($smsBanPerm->perm == '1'): ?>
204 
							<td><?= $l_num_flood ?></td>
 212 
							<td><?= $l_num_flood ?></td>
205 
						<?php endif ?>
 213 
							<?php endif ?>
206 
 
 - 
 
207 
						<td><?= $smsBanPerm->expiration ?></td>
 214 
							<td><?= $smsBanPerm->expiration ?></td>
208 
					</tr>
 215 
						</tr>
209 
				<?php endforeach; ?>
 216 
					<?php endforeach; ?>
210 
			</tbody>
 217 
				</tbody>
211 
		</table>
 218 
				</table>
- 
 
 219 
			</div>
212 
		</div>
 220 
		</div>
213 
	</div>
 221 
	</div>
214 
	</center>
 - 
 
215 
</body>
 222 
</body>
216 
</html>
 223 
</html>
217 
 
 224