| 18,6 → 18,7 |
|---|
| if($Language == 'fr'){ |
| $l_title = "Importer et vider la base des utilisateurs"; |
| $l_database_state = "État actuel de la base : nombre de groupes = "; |
| $l_number_of_concerned_users = "Nombre d'utilisateurs concernés : "; |
| $l_number_of_users = "Nombre d'utilisateurs"; |
| $l_text_import = "Importer à partir d'un fichier texte"; |
| $l_text_import_help = "Ce fichier ne doit contenir que des noms d'utilisateurs écrits les uns sous les autres."; |
| 42,6 → 43,7 |
|---|
| } else if($Language === 'es') { |
| $l_title = "Importar y vaciar la base de datos de usuarios."; |
| $l_database_state ="Estado de la base de datos: cantidad de grupos = "; |
| $l_number_of_concerned_users = "Número de usuarios afectados :"; |
| $l_number_of_users = "Cantidad de usuarios"; |
| $l_text_import = "Importar desde un archivo de texto"; |
| $l_text_import_help = "En este archivo, debe escribir solo el \"nombre de usuario\" uno debajo del otro."; |
| 66,6 → 68,7 |
|---|
| } else { |
| $l_title = "Import and empty the users database"; |
| $l_database_state ="State of the database : number of groups = "; |
| $l_number_of_concerned_users = "Number of users concerned :"; |
| $l_number_of_users = "Number of users"; |
| $l_text_import = "Import from a text file"; |
| $l_text_import_help = "In this file, you must write only the user login one below the other."; |
| 176,6 → 179,10 |
|---|
| exec ("sudo /usr/local/bin/alcasar-logout.sh all"); |
| exec ("sudo /usr/local/bin/alcasar-mariadb.sh --raz"); |
| } |
| if ($choix == "remove_old_users") |
| { |
| exec ("sudo /usr/local/bin/alcasar-mariadb.sh --old_users"); |
| } |
| // a file is downloaded |
| if(isset($_FILES['import-users']) && ($_FILES['import-users']['name'] !="")) |
| { |
| 365,9 → 372,28 |
|---|
| </form></td></tr> |
| <tr><td valign="middle" align="left"> |
| <h3><center><?= $l_remove_old_users ?></center></h3> |
| <?= $l_db_import_help ?><br><br> |
| <?= $l_number_of_concerned_users ?> |
| <?php |
| if ($link) |
| { |
| $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)"); |
| if ($res) |
| { |
| $nb_user = @da_sql_num_rows($res,$config); |
| echo "$nb_user"; |
| if ($nb_user > 0 ){ |
| echo " ("; |
| while ($row = da_sql_fetch_array($res,$config)) { |
| $old_user = $row['username']; |
| echo "$old_user, "; |
| } |
| echo ")."; |
| } |
| } |
| } |
| ?> |
| <form name="remove_old_users" action="<?= htmlspecialchars($_SERVER['PHP_SELF']) ?>" method="POST" onSubmit="document.getElementById('ldoverlay').style.display='block';"> |
| <input type="hidden" name="choix" value="raz"> |
| <input type="hidden" name="choix" value="remove_old_users"> |
| <input type="submit" onClick="return confirm('<?= $l_remove_old_users_warn ?>')" class="button" value="<?= $l_empty ?>"> |
| </form></td></tr> |
| <tr><td valign="middle" align="left"> |