| Line 16... |
Line 16... |
| 16 |
$Langue = explode(",",$_SERVER['HTTP_ACCEPT_LANGUAGE']);
|
16 |
$Langue = explode(",",$_SERVER['HTTP_ACCEPT_LANGUAGE']);
|
| 17 |
$Language = strtolower(substr(chop($Langue[0]),0,2)); }
|
17 |
$Language = strtolower(substr(chop($Langue[0]),0,2)); }
|
| 18 |
if($Language == 'fr'){
|
18 |
if($Language == 'fr'){
|
| 19 |
$l_title = "Importer et vider la base des utilisateurs";
|
19 |
$l_title = "Importer et vider la base des utilisateurs";
|
| 20 |
$l_database_state = "État actuel de la base : nombre de groupes = ";
|
20 |
$l_database_state = "État actuel de la base : nombre de groupes = ";
|
| - |
|
21 |
$l_number_of_concerned_users = "Nombre d'utilisateurs concernés : ";
|
| 21 |
$l_number_of_users = "Nombre d'utilisateurs";
|
22 |
$l_number_of_users = "Nombre d'utilisateurs";
|
| 22 |
$l_text_import = "Importer à partir d'un fichier texte";
|
23 |
$l_text_import = "Importer à partir d'un fichier texte";
|
| 23 |
$l_text_import_help = "Ce fichier ne doit contenir que des noms d'utilisateurs écrits les uns sous les autres.";
|
24 |
$l_text_import_help = "Ce fichier ne doit contenir que des noms d'utilisateurs écrits les uns sous les autres.";
|
| 24 |
$l_file = "Fichier";
|
25 |
$l_file = "Fichier";
|
| 25 |
$l_users_group = "Définissez leur groupe (conseillé)";
|
26 |
$l_users_group = "Définissez leur groupe (conseillé)";
|
| Line 40... |
Line 41... |
| 40 |
$l_out_passwd = "Mot de passe :";
|
41 |
$l_out_passwd = "Mot de passe :";
|
| 41 |
$l_out_mind = "Pensez à changer votre mot de passe (lien sur la page d'authentification)";
|
42 |
$l_out_mind = "Pensez à changer votre mot de passe (lien sur la page d'authentification)";
|
| 42 |
} else if($Language === 'es') {
|
43 |
} else if($Language === 'es') {
|
| 43 |
$l_title = "Importar y vaciar la base de datos de usuarios.";
|
44 |
$l_title = "Importar y vaciar la base de datos de usuarios.";
|
| 44 |
$l_database_state ="Estado de la base de datos: cantidad de grupos = ";
|
45 |
$l_database_state ="Estado de la base de datos: cantidad de grupos = ";
|
| - |
|
46 |
$l_number_of_concerned_users = "Número de usuarios afectados :";
|
| 45 |
$l_number_of_users = "Cantidad de usuarios";
|
47 |
$l_number_of_users = "Cantidad de usuarios";
|
| 46 |
$l_text_import = "Importar desde un archivo de texto";
|
48 |
$l_text_import = "Importar desde un archivo de texto";
|
| 47 |
$l_text_import_help = "En este archivo, debe escribir solo el \"nombre de usuario\" uno debajo del otro.";
|
49 |
$l_text_import_help = "En este archivo, debe escribir solo el \"nombre de usuario\" uno debajo del otro.";
|
| 48 |
$l_file = "Archivo";
|
50 |
$l_file = "Archivo";
|
| 49 |
$l_users_group = "Definir el grupo (aconsejable)";
|
51 |
$l_users_group = "Definir el grupo (aconsejable)";
|
| Line 64... |
Line 66... |
| 64 |
$l_out_passwd = "Contraseña:";
|
66 |
$l_out_passwd = "Contraseña:";
|
| 65 |
$l_out_mind = "No olvide cambiar su contraseña (hay un enlace en la ventana de autenticación)";
|
67 |
$l_out_mind = "No olvide cambiar su contraseña (hay un enlace en la ventana de autenticación)";
|
| 66 |
} else {
|
68 |
} else {
|
| 67 |
$l_title = "Import and empty the users database";
|
69 |
$l_title = "Import and empty the users database";
|
| 68 |
$l_database_state ="State of the database : number of groups = ";
|
70 |
$l_database_state ="State of the database : number of groups = ";
|
| - |
|
71 |
$l_number_of_concerned_users = "Number of users concerned :";
|
| 69 |
$l_number_of_users = "Number of users";
|
72 |
$l_number_of_users = "Number of users";
|
| 70 |
$l_text_import = "Import from a text file";
|
73 |
$l_text_import = "Import from a text file";
|
| 71 |
$l_text_import_help = "In this file, you must write only the user login one below the other.";
|
74 |
$l_text_import_help = "In this file, you must write only the user login one below the other.";
|
| 72 |
$l_file = "File";
|
75 |
$l_file = "File";
|
| 73 |
$l_users_group = "Define their group (advisable)";
|
76 |
$l_users_group = "Define their group (advisable)";
|
| Line 174... |
Line 177... |
| 174 |
if ($choix == "raz")
|
177 |
if ($choix == "raz")
|
| 175 |
{
|
178 |
{
|
| 176 |
exec ("sudo /usr/local/bin/alcasar-logout.sh all");
|
179 |
exec ("sudo /usr/local/bin/alcasar-logout.sh all");
|
| 177 |
exec ("sudo /usr/local/bin/alcasar-mariadb.sh --raz");
|
180 |
exec ("sudo /usr/local/bin/alcasar-mariadb.sh --raz");
|
| 178 |
}
|
181 |
}
|
| - |
|
182 |
if ($choix == "remove_old_users")
|
| - |
|
183 |
{
|
| - |
|
184 |
exec ("sudo /usr/local/bin/alcasar-mariadb.sh --old_users");
|
| - |
|
185 |
}
|
| 179 |
// a file is downloaded
|
186 |
// a file is downloaded
|
| 180 |
if(isset($_FILES['import-users']) && ($_FILES['import-users']['name'] !=""))
|
187 |
if(isset($_FILES['import-users']) && ($_FILES['import-users']['name'] !=""))
|
| 181 |
{
|
188 |
{
|
| 182 |
unset($result);
|
189 |
unset($result);
|
| 183 |
if (isset ($_POST['groupe'])) $group = $_POST ['groupe'];
|
190 |
if (isset ($_POST['groupe'])) $group = $_POST ['groupe'];
|
| Line 363... |
Line 370... |
| 363 |
<?if (($choix == "bdd") && isset($result)) echo "<b>".$result."</b><BR>";?>
|
370 |
<?if (($choix == "bdd") && isset($result)) echo "<b>".$result."</b><BR>";?>
|
| 364 |
<input type="submit" onClick="document.getElementById('ldoverlay').style.display='block';" class="button" value="<?= $l_send ?>">
|
371 |
<input type="submit" onClick="document.getElementById('ldoverlay').style.display='block';" class="button" value="<?= $l_send ?>">
|
| 365 |
</form></td></tr>
|
372 |
</form></td></tr>
|
| 366 |
<tr><td valign="middle" align="left">
|
373 |
<tr><td valign="middle" align="left">
|
| 367 |
<h3><center><?= $l_remove_old_users ?></center></h3>
|
374 |
<h3><center><?= $l_remove_old_users ?></center></h3>
|
| 368 |
<?= $l_db_import_help ?><br><br>
|
375 |
<?= $l_number_of_concerned_users ?>
|
| - |
|
376 |
<?php
|
| - |
|
377 |
if ($link)
|
| - |
|
378 |
{
|
| - |
|
379 |
$res = @da_sql_query($link,$config,"SELECT username FROM userinfo WHERE username NOT IN (SELECT DISTINCT username FROM radacct WHERE acctstarttime >= NOW() - INTERVAL 1 YEAR)");
|
| - |
|
380 |
if ($res)
|
| - |
|
381 |
{
|
| - |
|
382 |
$nb_user = @da_sql_num_rows($res,$config);
|
| - |
|
383 |
echo "$nb_user";
|
| - |
|
384 |
if ($nb_user > 0 ){
|
| - |
|
385 |
echo " (";
|
| - |
|
386 |
while ($row = da_sql_fetch_array($res,$config)) {
|
| - |
|
387 |
$old_user = $row['username'];
|
| - |
|
388 |
echo "$old_user, ";
|
| - |
|
389 |
}
|
| - |
|
390 |
echo ").";
|
| - |
|
391 |
}
|
| - |
|
392 |
}
|
| - |
|
393 |
}
|
| - |
|
394 |
?>
|
| 369 |
<form name="remove_old_users" action="<?= htmlspecialchars($_SERVER['PHP_SELF']) ?>" method="POST" onSubmit="document.getElementById('ldoverlay').style.display='block';">
|
395 |
<form name="remove_old_users" action="<?= htmlspecialchars($_SERVER['PHP_SELF']) ?>" method="POST" onSubmit="document.getElementById('ldoverlay').style.display='block';">
|
| 370 |
<input type="hidden" name="choix" value="raz">
|
396 |
<input type="hidden" name="choix" value="remove_old_users">
|
| 371 |
<input type="submit" onClick="return confirm('<?= $l_remove_old_users_warn ?>')" class="button" value="<?= $l_empty ?>">
|
397 |
<input type="submit" onClick="return confirm('<?= $l_remove_old_users_warn ?>')" class="button" value="<?= $l_empty ?>">
|
| 372 |
</form></td></tr>
|
398 |
</form></td></tr>
|
| 373 |
<tr><td valign="middle" align="left">
|
399 |
<tr><td valign="middle" align="left">
|
| 374 |
<h3><center><?= $l_db_reset ?></center></h3>
|
400 |
<h3><center><?= $l_db_reset ?></center></h3>
|
| 375 |
<?= $l_db_import_help ?><br><br>
|
401 |
<?= $l_db_import_help ?><br><br>
|