Line 11... |
Line 11... |
11 |
$Language = 'en';
|
11 |
$Language = 'en';
|
12 |
if(isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])){
|
12 |
if(isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])){
|
13 |
$Langue = explode(",",$_SERVER['HTTP_ACCEPT_LANGUAGE']);
|
13 |
$Langue = explode(",",$_SERVER['HTTP_ACCEPT_LANGUAGE']);
|
14 |
$Language = strtolower(substr(chop($Langue[0]),0,2)); }
|
14 |
$Language = strtolower(substr(chop($Langue[0]),0,2)); }
|
15 |
if($Language == 'fr'){
|
15 |
if($Language == 'fr'){
|
16 |
$l_title = "Import d'usagers";
|
16 |
$l_title = "Importer et vider la base des usagers";
|
17 |
$l_database_state = "État actuel de la base : nombre de groupes =";
|
17 |
$l_database_state = "état actuel de la base : nombre de groupes =";
|
18 |
$l_number_of_users = "Nombre d'usagers";
|
18 |
$l_number_of_users = "Nombre d'usagers";
|
19 |
$l_text_import = "Importer à partir d'un fichier texte ('.txt')";
|
19 |
$l_text_import = "Importer à partir d'un fichier texte";
|
20 |
$l_text_import_help = "Ce fichier ne doit contenir que des noms d'usagers écrits les uns sous les autres.";
|
20 |
$l_text_import_help = "Ce fichier ne doit contenir que des noms d'usagers écrits les uns sous les autres.";
|
21 |
$l_file = "Fichier";
|
21 |
$l_file = "Fichier";
|
22 |
$l_users_group = "Définissez leur groupe (conseillé)";
|
22 |
$l_users_group = "Définissez leur groupe (conseillé)";
|
23 |
$l_send = "Envoyer";
|
23 |
$l_send = "Importer";
|
- |
|
24 |
$l_empty = "Vider";
|
24 |
$l_imported_files = "Fichiers des identifiants/mot_de_passe importés durant les dernières 24h :";
|
25 |
$l_imported_files = "Fichiers des identifiants/mot_de_passe importés durant les dernières 24h :";
|
25 |
$l_db_import = "Importer à partir d'une sauvegarde de la base d'usagers (format SQL)";
|
26 |
$l_db_import = "Importer à partir d'une sauvegarde de la base d'usagers";
|
26 |
$l_db_import_help = "Afin de pouvoir imputer les dernières traces de connexion, une sauvegarde de la base actuelle sera automatiquement réalisée.";
|
27 |
$l_db_import_help = "Afin de pouvoir imputer les dernières traces de connexion, une sauvegarde de la base actuelle sera automatiquement réalisée.";
|
27 |
$l_db_reset = "Remise à zéro de la base usagers";
|
28 |
$l_db_reset = "Vider la base des usagers";
|
28 |
$l_error_ext_txt = "Erreur! Veuillez sélectionner un fichier avec l'extension '.csv' ou '.txt'";
|
29 |
$l_error_ext_txt = "Erreur! Veuillez sélectionner un fichier avec l'extension '.csv' ou '.txt'";
|
29 |
$l_error_ext_sql = "Erreur! Veuillez sélectionner un fichier avec l'extension '.sql'";
|
30 |
$l_error_ext_sql = "Erreur! Veuillez sélectionner un fichier avec l'extension '.sql' ou '.sql.gz'";
|
30 |
$l_group_empty = "La liste des groupes est vide";
|
31 |
$l_group_empty = "La liste des groupes est vide";
|
31 |
$l_out_title = " --- Accès à Internet via ALCASAR --- ";
|
32 |
$l_out_title = " --- Accès à Internet via ALCASAR --- ";
|
32 |
$l_out_login = "Nom de connexion :";
|
33 |
$l_out_login = "Nom de connexion :";
|
33 |
$l_out_passwd = "Mot de passe :";
|
34 |
$l_out_passwd = "Mot de passe :";
|
34 |
$l_out_mind = "Pensez à changer votre mot de passe (lien sur la page d'authentification)";
|
35 |
$l_out_mind = "Pensez à changer votre mot de passe (lien sur la page d'authentification)";
|
35 |
}
|
36 |
}
|
36 |
else {
|
37 |
else {
|
37 |
$l_title = "Users import";
|
38 |
$l_title = "Import and empty the users database";
|
38 |
$l_database_state ="State of the database : number of groups =";
|
39 |
$l_database_state ="State of the database : number of groups =";
|
39 |
$l_number_of_users = "Number of users";
|
40 |
$l_number_of_users = "Number of users";
|
40 |
$l_text_import = "Import from a text file ('.txt')";
|
41 |
$l_text_import = "Import from a text file";
|
41 |
$l_text_import_help = "In this file, you must write only the user login one below the other.";
|
42 |
$l_text_import_help = "In this file, you must write only the user login one below the other.";
|
42 |
$l_file = "File";
|
43 |
$l_file = "File";
|
43 |
$l_users_group = "Define their group (advisable)";
|
44 |
$l_users_group = "Define their group (advisable)";
|
44 |
$l_send = "Send";
|
45 |
$l_send = "Import";
|
- |
|
46 |
$l_empty = "Empty";
|
45 |
$l_imported_files = "Logins/passwords file imported during the last 24h :";
|
47 |
$l_imported_files = "Logins/passwords file imported during the last 24h :";
|
46 |
$l_db_import = "Import from a saved users database file (SQL format)";
|
48 |
$l_db_import = "Import from a saved users database file";
|
47 |
$l_db_import_help = "In order to impute the last connections, the actual users database will be automaticly saved.";
|
49 |
$l_db_import_help = "In order to impute the last connections, the actual users database will be automaticly saved.";
|
48 |
$l_db_reset = "Reset the users database";
|
50 |
$l_db_reset = "Empty the users database";
|
49 |
$l_error_ext_txt = "Error! Please select a file with '.txt' or '.csv' extension";
|
51 |
$l_error_ext_txt = "Error! Please select a file with '.txt' or '.csv' extension";
|
50 |
$l_error_ext_sql = "Error! Please select a file with '.sql' extension";
|
52 |
$l_error_ext_sql = "Error! Please select a file with '.sql' or '.sql.gz' extension";
|
51 |
$l_group_empty = "The group list is empty";
|
53 |
$l_group_empty = "The group list is empty";
|
52 |
$l_out_title = " --- Internet access via ALCASAR --- ";
|
54 |
$l_out_title = " --- Internet access via ALCASAR --- ";
|
53 |
$l_out_login = "Login :";
|
55 |
$l_out_login = "Login :";
|
54 |
$l_out_passwd = "Password :";
|
56 |
$l_out_passwd = "Password :";
|
55 |
$l_out_mind = "Don't forget to change your password (a link is on the authentication window)";
|
57 |
$l_out_mind = "Don't forget to change your password (a link is on the authentication window)";
|
Line 124... |
Line 126... |
124 |
// a file is downloaded
|
126 |
// a file is downloaded
|
125 |
if(isset($_FILES['import-users']) && ($_FILES['import-users']['name'] !=""))
|
127 |
if(isset($_FILES['import-users']) && ($_FILES['import-users']['name'] !=""))
|
126 |
{
|
128 |
{
|
127 |
unset($result);
|
129 |
unset($result);
|
128 |
if (isset ($_POST['groupe'])) $group = $_POST ['groupe'];
|
130 |
if (isset ($_POST['groupe'])) $group = $_POST ['groupe'];
|
129 |
$destination = '/tmp/import_file.txt';
|
- |
|
130 |
list($file_name , $extension) = explode("." , $_FILES['import-users']['name']);
|
131 |
list($file_name , $extension) = explode("." , $_FILES['import-users']['name'] , 2);
|
131 |
if ($choix == "csv") // import of a txt file
|
132 |
if ($choix == "csv") // import of a txt file
|
132 |
{
|
133 |
{
|
133 |
if (($extension != 'csv') && ($extension != 'txt')) $result = $l_error_ext_txt;
|
134 |
if (($extension != 'csv') && ($extension != 'txt')) $result = $l_error_ext_txt;
|
134 |
else
|
135 |
else
|
135 |
{
|
136 |
{
|
- |
|
137 |
$destination = '/tmp/import_file.txt';
|
136 |
exec ("sudo /usr/local/sbin/alcasar-mysql.sh --dump");
|
138 |
exec ("sudo /usr/local/sbin/alcasar-mysql.sh --dump");
|
137 |
move_uploaded_file($_FILES['import-users']['tmp_name'], $destination);
|
139 |
move_uploaded_file($_FILES['import-users']['tmp_name'], $destination);
|
138 |
$RS_in = file ($destination);
|
140 |
$RS_in = file ($destination);
|
139 |
$da_abort=0;
|
141 |
$da_abort=0;
|
140 |
if ($link)
|
142 |
if ($link)
|
Line 217... |
Line 219... |
217 |
} // end if ($login !='')
|
219 |
} // end if ($login !='')
|
218 |
} // end foreach
|
220 |
} // end foreach
|
219 |
fclose($RS_out);
|
221 |
fclose($RS_out);
|
220 |
} // end if (is file)
|
222 |
} // end if (is file)
|
221 |
} // end if (link)
|
223 |
} // end if (link)
|
222 |
}
|
224 |
unlink ($destination);
|
- |
|
225 |
} // end if (extension = (txt or cvs))
|
223 |
}
|
226 |
}
|
224 |
else if ($choix == "bdd") // database import
|
227 |
else if ($choix == "bdd") // database import
|
225 |
{
|
228 |
{
|
226 |
if ($extension != 'sql') $result = $l_error_ext_sql;
|
229 |
if (($extension == 'sql') || ($extension == 'sql.gz'))
|
227 |
else
|
- |
|
228 |
{
|
230 |
{
|
- |
|
231 |
$destination = '/tmp/import_file.'.$extension;
|
229 |
exec ("sudo /usr/local/sbin/alcasar-mysql.sh --dump");
|
232 |
exec ("sudo /usr/local/sbin/alcasar-mysql.sh --dump");
|
230 |
move_uploaded_file($_FILES['import-users']['tmp_name'], $destination);
|
233 |
move_uploaded_file($_FILES['import-users']['tmp_name'], $destination);
|
231 |
exec ("sudo /usr/local/sbin/alcasar-mysql.sh --import $destination");
|
234 |
exec ("sudo /usr/local/sbin/alcasar-mysql.sh --import $destination");
|
232 |
echo "OK : $destination";
|
235 |
//echo "OK : $destination";
|
- |
|
236 |
unlink ($destination);
|
233 |
}
|
237 |
}
|
- |
|
238 |
else $result = $l_error_ext_sql;
|
234 |
}
|
239 |
}
|
235 |
}
|
240 |
}
|
236 |
if ($link)
|
241 |
if ($link)
|
237 |
{
|
242 |
{
|
238 |
$res = @da_sql_query($link,$config,"SELECT GroupName FROM radusergroup GROUP BY GroupName");
|
243 |
$res = @da_sql_query($link,$config,"SELECT GroupName FROM radusergroup GROUP BY GroupName");
|
Line 258... |
Line 263... |
258 |
echo "<CENTER><H3>$l_text_import</H3></CENTER></td></tr>";
|
263 |
echo "<CENTER><H3>$l_text_import</H3></CENTER></td></tr>";
|
259 |
echo "<tr><td valign=\"middle\" align=\"left\">";
|
264 |
echo "<tr><td valign=\"middle\" align=\"left\">";
|
260 |
echo "$l_text_import_help<br>";
|
265 |
echo "$l_text_import_help<br>";
|
261 |
echo "<tr><td valign=\"middle\" align=\"left\">";
|
266 |
echo "<tr><td valign=\"middle\" align=\"left\">";
|
262 |
echo "<br><FORM action='$_SERVER[PHP_SELF]' method=POST ENCTYPE=\"multipart/form-data\">";
|
267 |
echo "<br><FORM action='$_SERVER[PHP_SELF]' method=POST ENCTYPE=\"multipart/form-data\">";
|
263 |
echo "$l_file (.txt) : <input type=\"file\" name=\"import-users\"><br>";
|
268 |
echo "$l_file (.txt or .csv) : <input type=\"file\" name=\"import-users\"><br>";
|
264 |
echo "$l_users_group : ";
|
269 |
echo "$l_users_group : ";
|
265 |
require("../lib/defaults.php");
|
270 |
require("../lib/defaults.php");
|
266 |
include_once("../lib/$config[general_lib_type]/group_info.php");
|
271 |
include_once("../lib/$config[general_lib_type]/group_info.php");
|
267 |
if (isset($existing_groups)){
|
272 |
if (isset($existing_groups)){
|
268 |
echo "<select name=\"groupe\">";
|
273 |
echo "<select name=\"groupe\">";
|
Line 293... |
Line 298... |
293 |
echo "</td></tr></table>";
|
298 |
echo "</td></tr></table>";
|
294 |
echo "<tr><td valign=\"middle\" align=\"left\">";
|
299 |
echo "<tr><td valign=\"middle\" align=\"left\">";
|
295 |
echo "<H3><CENTER>$l_db_import</CENTER></H3>";
|
300 |
echo "<H3><CENTER>$l_db_import</CENTER></H3>";
|
296 |
echo "$l_db_import_help <br><br>";
|
301 |
echo "$l_db_import_help <br><br>";
|
297 |
echo "<FORM action='$_SERVER[PHP_SELF]' method=POST ENCTYPE=\"multipart/form-data\">";
|
302 |
echo "<FORM action='$_SERVER[PHP_SELF]' method=POST ENCTYPE=\"multipart/form-data\">";
|
298 |
echo "$l_file (.sql) : <input type=\"file\" name=\"import-users\"><br>";
|
303 |
echo "$l_file (.sql or .sql.gz) : <input type=\"file\" name=\"import-users\"><br>";
|
299 |
echo "<input type='hidden' name='choix' value='bdd'>";
|
304 |
echo "<input type='hidden' name='choix' value='bdd'>";
|
300 |
if (($choix == "bdd") && isset($result)) echo "<b>".$result."</b><BR>";
|
305 |
if (($choix == "bdd") && isset($result)) echo "<b>".$result."</b><BR>";
|
301 |
echo "<input type=\"submit\" value=\"$l_send\">";
|
306 |
echo "<input type=\"submit\" value=\"$l_send\">";
|
302 |
echo "</FORM>";
|
307 |
echo "</FORM>";
|
303 |
echo "</td></tr>";
|
308 |
echo "</td></tr>";
|
304 |
echo "<tr><td valign=\"middle\" align=\"left\">";
|
309 |
echo "<tr><td valign=\"middle\" align=\"left\">";
|
305 |
echo "<H3><CENTER>$l_db_reset</CENTER></H3>";
|
310 |
echo "<H3><CENTER>$l_db_reset</CENTER></H3>";
|
306 |
echo "$l_db_import_help<br><br>";
|
311 |
echo "$l_db_import_help<br><br>";
|
307 |
echo "<FORM action='$_SERVER[PHP_SELF]' method=POST>";
|
312 |
echo "<FORM action='$_SERVER[PHP_SELF]' method=POST>";
|
308 |
echo "<input type='hidden' name='choix' value='raz'>";
|
313 |
echo "<input type='hidden' name='choix' value='raz'>";
|
309 |
echo "<input type=\"submit\" value=\"$l_send\">";
|
314 |
echo "<input type=\"submit\" value=\"$l_empty\">";
|
310 |
echo "</FORM>";
|
315 |
echo "</FORM>";
|
311 |
echo "</TD></TR></TABLE>";
|
316 |
echo "</TD></TR></TABLE>";
|
312 |
?>
|
317 |
?>
|
313 |
</BODY>
|
318 |
</BODY>
|
314 |
</HTML>
|
319 |
</HTML>
|