Subversion Repositories ALCASAR

Rev

Rev 3285 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log

Rev 3285 Rev 3288
Line 1... Line 1...
1 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
 1 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
2 
<HTML><!-- Written by Rexy, Romero P. & 3abTux -->
 2 
<html><!-- Written by Rexy, Romero P. & 3abTux -->
3 
<HEAD>
 3 
<head>
4 
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
 4 
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
5 
<TITLE>Users import</TITLE>
 5 
	<title>Users import</title>
6 
<link rel="stylesheet" href="/css/acc.css" type="text/css">
 6 
	<link rel="stylesheet" href="/css/acc.css" type="text/css">
7 
</HEAD>
 7 
</head>
8 
<body>
 8 
<body>
9 
<div id="ldoverlay" class="overlay">
 9 
<div id="ldoverlay" class="overlay">
10 
	<div class="lds-spinner" id="spinner"><div></div><div></div><div></div><div></div><div></div><div></div><div></div><div></div><div></div><div></div><div></div><div></div></div>
 10 
	<div class="lds-spinner" id="spinner"><div></div><div></div><div></div><div></div><div></div><div></div><div></div><div></div><div></div><div></div><div></div><div></div></div>
11 
</div>
 11 
</div>
12 
<?php
 12 
<?php
Line 29... Line 29...
29 
  $l_imported_files = "Fichiers des identifiants/mot_de_passe import&eacute;s durant les derni&egrave;res 24h :";
 29 
  $l_imported_files = "Fichiers des identifiants/mot_de_passe import&eacute;s durant les derni&egrave;res 24h :";
30 
  $l_db_import = "Importer à partir d'une sauvegarde de la base d'utilisateurs";
 30 
  $l_db_import = "Importer à partir d'une sauvegarde de la base d'utilisateurs";
31 
  $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.";
 31 
  $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.";
32 
  $l_db_reset = "Vider la base des utilisateurs";
 32 
  $l_db_reset = "Vider la base des utilisateurs";
33 
  $l_remove_old_users = "Supprimer les utilisateurs inactifs depuis plus d'un an";
 33 
  $l_remove_old_users = "Supprimer les utilisateurs inactifs depuis plus d'un an";
- 
 
 34 
  $l_remove_old_users_warn = "Étes-vous sûr de vouloir supprimer ces utilisateurs ?";
34 
  $l_error_ext_txt = "Erreur! Veuillez sélectionner un fichier avec l'extension '.csv' ou '.txt'";
 35 
  $l_error_ext_txt = "Erreur! Veuillez sélectionner un fichier avec l'extension '.csv' ou '.txt'";
35 
  $l_error_ext_sql = "Erreur! Veuillez sélectionner un fichier avec l'extension '.sql' ou '.sql.gz'";
 36 
  $l_error_ext_sql = "Erreur! Veuillez sélectionner un fichier avec l'extension '.sql' ou '.sql.gz'";
36 
  $l_group_empty = "La liste des groupes est vide";
 37 
  $l_group_empty = "La liste des groupes est vide";
37 
  $l_out_title = "   ---  Accès à Internet via ALCASAR  ---  ";
 38 
  $l_out_title = "   ---  Accès à Internet via ALCASAR  ---  ";
38 
  $l_out_login = "Nom de connexion :";
 39 
  $l_out_login = "Nom de connexion :";
Line 52... Line 53...
52 
  $l_imported_files = "Archivos de nombres de usuarios / contraseñas importados durante las últimas 24hs: ";
 53 
  $l_imported_files = "Archivos de nombres de usuarios / contraseñas importados durante las últimas 24hs: ";
53 
  $l_db_import = "Importar desde un archivo de base de datos de usuarios guardado";
 54 
  $l_db_import = "Importar desde un archivo de base de datos de usuarios guardado";
54 
  $l_db_import_help = "Para atribuir las últimas conexiones, la base de datos de usuarios reales se guardará automáticamente.";
 55 
  $l_db_import_help = "Para atribuir las últimas conexiones, la base de datos de usuarios reales se guardará automáticamente.";
55 
  $l_db_reset = "Vaciar la base de datos de usuarios";
 56 
  $l_db_reset = "Vaciar la base de datos de usuarios";
56 
  $l_remove_old_users = "Eliminar usuarios inactivos desde hace más de un año";
 57 
  $l_remove_old_users = "Eliminar usuarios inactivos desde hace más de un año";
- 
 
 58 
  $l_remove_old_users_warn = "¿Estás seguro de que quieres eliminar a estos usuarios?";
57 
  $l_error_ext_txt = "¡Error! Seleccione un archivo con la extensión '.txt' o '.csv'";
 59 
  $l_error_ext_txt = "¡Error! Seleccione un archivo con la extensión '.txt' o '.csv'";
58 
  $l_error_ext_sql = "¡Error! Seleccione un archivo con la extensión '.sql' o '.sql.gz'";
 60 
  $l_error_ext_sql = "¡Error! Seleccione un archivo con la extensión '.sql' o '.sql.gz'";
59 
  $l_group_empty = "La lista de grupos está vacía.";
 61 
  $l_group_empty = "La lista de grupos está vacía.";
60 
  $l_out_title = "   ---  Accesos a Internet mediante ALCASAR  ---  ";
 62 
  $l_out_title = "   ---  Accesos a Internet mediante ALCASAR  ---  ";
61 
  $l_out_login = "Nombre de usuario:";
 63 
  $l_out_login = "Nombre de usuario:";
Line 75... Line 77...
75 
  $l_imported_files = "Logins/passwords file imported during the last 24h :";
 77 
  $l_imported_files = "Logins/passwords file imported during the last 24h :";
76 
  $l_db_import = "Import from a saved users database file";
 78 
  $l_db_import = "Import from a saved users database file";
77 
  $l_db_import_help = "In order to impute the last connections, the actual users database will be automaticly saved.";
 79 
  $l_db_import_help = "In order to impute the last connections, the actual users database will be automaticly saved.";
78 
  $l_db_reset = "Empty the users database";
 80 
  $l_db_reset = "Empty the users database";
79 
  $l_remove_old_users = "Delete users who have been inactive for more than a year";
 81 
  $l_remove_old_users = "Delete users who have been inactive for more than a year";
- 
 
 82 
  $l_remove_old_users_warn = "Are you sure you want to delete these users?";
80 
  $l_error_ext_txt = "Error! Please select a file with '.txt' or '.csv' extension";
 83 
  $l_error_ext_txt = "Error! Please select a file with '.txt' or '.csv' extension";
81 
  $l_error_ext_sql = "Error! Please select a file with '.sql' or '.sql.gz' extension";
 84 
  $l_error_ext_sql = "Error! Please select a file with '.sql' or '.sql.gz' extension";
82 
  $l_group_empty = "The group list is empty";
 85 
  $l_group_empty = "The group list is empty";
83 
  $l_out_title = "   ---  Internet access via ALCASAR  ---  ";
 86 
  $l_out_title = "   ---  Internet access via ALCASAR  ---  ";
84 
  $l_out_login = "Login :";
 87 
  $l_out_login = "Login :";
Line 138... Line 141...
138 
 
 141 
 
139 
	return $login;
 142 
	return $login;
140 
}
 143 
}
141 
 
 144 
 
142 
?>
 145 
?>
143 
<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
 146 
<table width="100%" border="0" cellspacing="0" cellpadding="0">
144 
<tr><th><? echo "$l_title"; ?></th></tr>
 147 
	<tr><th><? echo "$l_title"; ?></th></tr>
145 
<tr bgcolor="#FFCC66"><td><img src="/images/pix.gif" width="1" height="2"></td></tr>
 148 
	<tr bgcolor="#FFCC66"><td><img src="/images/pix.gif" width="1" height="2"></td></tr>
146 
</TABLE>
 149 
</table>
147 
<TABLE width="100%" border=1 cellspacing=0 cellpadding=1>
 150 
<table width="100%" border=1 cellspacing=0 cellpadding=1>
148 
<tr><td valign="middle" align="center">
 151 
	<tr><td valign="middle" align="center"><H3><?= $l_database_state ?>
149 
<H3>
- 
 
150 
<?php
 152 
<?php
151 
echo "$l_database_state";
 - 
 
- 
 
 153 
 
152 
$LIBpath = "../lib/";
 154 
$LIBpath = "../lib/";
153 
if (is_file($LIBpath."sql/drivers/$config[sql_type]/functions.php"))
 155 
if (is_file($LIBpath."sql/drivers/$config[sql_type]/functions.php"))
154 
	{
 156 
	{
155 
	include_once($LIBpath."sql/drivers/$config[sql_type]/functions.php");
 157 
	include_once($LIBpath."sql/drivers/$config[sql_type]/functions.php");
156 
	}
 158 
	}
Line 307... Line 309...
307 
		{
 309 
		{
308 
		$nb_user = @da_sql_num_rows($res,$config);
 310 
		$nb_user = @da_sql_num_rows($res,$config);
309 
		echo "$nb_user";
 311 
		echo "$nb_user";
310 
		}
 312 
		}
311 
	}
 313 
	}
- 
 
 314 
?>
312 
echo "</H3></td></tr><tr><td>";
 315 
	</H3></td></tr>
- 
 
 316 
	<tr><td>
313 
echo "<TABLE width=\"100%\" border=0 cellspacing=0 cellpadding=1>";
 317 
		<table width="100%" border=0 cellspacing=0 cellpadding=1>
314 
echo "<tr><td valign=\"middle\" align=\"center\" colspan=\"2\">";
 318 
			<tr><td valign="middle" align="center" colspan="2"><H3><?= $l_text_import ?></H3></td></tr>
315 
echo "<H3>$l_text_import</H3></td></tr>";
 - 
 
316 
echo "<tr><td valign=\"middle\" align=\"left\">";
 319 
			<tr><td valign="middle" align="left"><?= $l_text_import_help ?><br>
317 
echo "$l_text_import_help<br>";
 - 
 
318 
echo "<tr><td valign=\"middle\" align=\"left\">";
 320 
			<tr><td valign="middle" align="left"><br>
319 
echo "<br><FORM action='$_SERVER[PHP_SELF]' method=POST ENCTYPE=\"multipart/form-data\">";
 321 
				<form action="<?= htmlspecialchars($_SERVER['PHP_SELF']) ?>" method="POST" ENCTYPE="multipart/form-data">
320 
echo "$l_file (.txt or .csv) : <input type=\"file\" name=\"import-users\"><br>";
 322 
				<?= $l_file ?> (.txt or .csv) : <input type="file" name="import-users"><br>
321 
echo "$l_users_group : ";
 323 
				<?= $l_users_group ?> :
- 
 
 324 
<?PHP
322 
require("../lib/defaults.php");
 325 
require("../lib/defaults.php");
323 
include_once("../lib/$config[general_lib_type]/group_info.php");
 326 
include_once("../lib/$config[general_lib_type]/group_info.php");
324 
if (isset($existing_groups)){
 327 
if (isset($existing_groups)){
325 
	echo "<select name=\"groupe\">";
 328 
	echo "<select name=\"groupe\">";
326 
	echo "<option value=\"\" selected>";
 329 
	echo "<option value=\"\" selected>";
327 
	foreach ($member_groups as $group)
 330 
	foreach ($member_groups as $group)
328 
		echo "<option value=\"$group\">$group\n";
 331 
		echo "<option value=\"$group\">$group\n";
329 
	echo " </select>";
 332 
	echo " </select>";
330 
	}
 333 
	}
331 
else echo "$l_group_empty";
 334 
else echo "$l_group_empty";
- 
 
 335 
?>
332 
echo "<br>";
 336 
				<br>
333 
echo "<input type='hidden' name='choix' value='csv'>";
 337 
				<input type="hidden" name="choix" value="csv">
334 
if (($choix == "csv") && isset($result)) echo "<b>".$result."</b><BR>";
 338 
				<?PHP if (($choix == "csv") && isset($result)) echo "<b>".$result."</b><BR>"; ?>
335 
echo "<input type=\"submit\" onClick=\"this.disabled=true'; document.getElementById('ldoverlay').style.display='block';\" value=\"$l_send\">";
 339 
				<input type="submit" onClick="this.disabled=true; document.getElementById('ldoverlay').style.display='block';" value="<?= $l_send ?>">
336 
echo "</FORM></td>";
 340 
				</form></td>
337 
echo "<td>";
 341 
			<td>
- 
 
 342 
<?PHP
338 
$ImportFileList = getImportFileList();
 343 
$ImportFileList = getImportFileList();
339 
if (count($ImportFileList) > 0){
 344 
if (count($ImportFileList) > 0){
340 
	echo "$l_imported_files";
 345 
	echo "$l_imported_files";
341 
	echo "<ul>";
 346 
	echo "<ul>";
342 
	foreach ( $ImportFileList as $ImportFile )
 347 
	foreach ( $ImportFileList as $ImportFile )
Line 345... Line 350...
345 
	}
350 
	}
346 
	echo "</ul>";
 351 
	echo "</ul>";
347 
} else {
 352 
} else {
348 
	echo "<br>";
 353 
	echo "<br>";
349 
}
 354 
}
350 
echo "</td></tr></table>";
 - 
 
351 
echo "<tr><td valign=\"middle\" align=\"left\">";
 - 
 
352 
echo "<H3><CENTER>$l_db_import</CENTER></H3>";
 - 
 
353 
echo "$l_db_import_help <br><br>";
 - 
 
354 
echo "<FORM action='$_SERVER[PHP_SELF]' method=POST ENCTYPE=\"multipart/form-data\">";
 - 
 
355 
echo "$l_file (.sql or .sql.gz) : <input type=\"file\" name=\"import-users\"><br>";
 - 
 
356 
echo "<input type='hidden' name='choix' value='bdd'>";
 - 
 
357 
if (($choix == "bdd") && isset($result)) echo "<b>".$result."</b><BR>";
 - 
 
358 
echo "<input type=\"submit\" onClick=\"this.disabled=true; document.getElementById('ldoverlay').style.display='block';\" value=\"$l_send\">";
 - 
 
359 
echo "</FORM>";
 - 
 
360 
echo "</td></tr>";
 - 
 
361 
echo "<tr><td valign=\"middle\" align=\"left\">";
 - 
 
362 
echo "<H3><CENTER>$l_remove_old_users</CENTER></H3>";
 - 
 
363 
echo "$l_db_import_help<br><br>";
 - 
 
364 
echo "<FORM onsubmit=\"return confirm('$l_empty_warn');\" action='$_SERVER[PHP_SELF]' method=POST>";
 - 
 
365 
echo "<input type='hidden' name='choix' value='raz'>";
 - 
 
366 
echo "<input type=\"submit\" onClick=\"this.disabled=true; document.getElementById('ldoverlay').style.display='block';\" value=\"$l_empty\">";
 - 
 
367 
echo "</FORM>";
 - 
 
368 
echo "</td></tr>";
 - 
 
369 
echo "<tr><td valign=\"middle\" align=\"left\">";
 - 
 
370 
echo "<H3><CENTER>$l_db_reset</CENTER></H3>";
 - 
 
371 
echo "$l_db_import_help<br><br>";
 - 
 
372 
echo "<FORM onsubmit=\"return confirm('$l_empty_warn');\" action='$_SERVER[PHP_SELF]' method=POST>";
 - 
 
373 
echo "<input type='hidden' name='choix' value='raz'>";
 - 
 
374 
echo "<input type=\"submit\" onClick=\"this.disabled=true; document.getElementById('ldoverlay').style.display='block';\" value=\"$l_empty\">";
 - 
 
375 
echo "</FORM>";
 - 
 
376 
echo "</td></tr></table>";
 - 
 
377 
?>
 355 
?>
- 
 
 356 
</td></tr></table>
- 
 
 357 
<tr><td valign="middle" align="left">
- 
 
 358 
	<H3><center><?= $l_db_import ?> </center></H3>
- 
 
 359 
	<?= $l_db_import_help ?><br><br>
- 
 
 360 
		<form action="<?= htmlspecialchars($_SERVER['PHP_SELF']) ?>" method="POST" ENCTYPE="multipart/form-data">
- 
 
 361 
			<?= $l_file ?>(.sql or .sql.gz) : <input type="file" name="import-users"><br>
- 
 
 362 
			<input type="hidden" name="choix" value="bdd">
- 
 
 363 
			<?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 ?>">
- 
 
 365 
		</form></td></tr>
- 
 
 366 
	<tr><td valign="middle" align="left">
- 
 
 367 
		<h3><center><?= $l_remove_old_users ?></center></h3>
- 
 
 368 
		<?= $l_db_import_help ?><br><br>
- 
 
 369 
		<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">
- 
 
 371 
			<input type="submit" onClick="return confirm('<?= $l_remove_old_users_warn ?>')" class="button" value="<?= $l_empty ?>">
- 
 
 372 
	</form></td></tr>
- 
 
 373 
	<tr><td valign="middle" align="left">
- 
 
 374 
		<h3><center><?= $l_db_reset ?></center></h3>
- 
 
 375 
		<?= $l_db_import_help ?><br><br>
- 
 
 376 
		<form name="db_reset" action="<?= htmlspecialchars($_SERVER['PHP_SELF']) ?>" method="POST" onSubmit="document.getElementById('ldoverlay').style.display='block';">
- 
 
 377 
			<input type="hidden" name="choix" value="raz">
- 
 
 378 
			<input type="submit" onClick="return confirm('<?= $l_empty_warn ?>')" class="button" value="<?= $l_empty ?>">
- 
 
 379 
	</form></td></tr>
- 
 
 380 
</table>
378 
</BODY>
 381 
</body>
379 
</HTML>
 382 
</html>