echo "<div id=\"" . $id_page . "-dialog\"></div>"; aff_table($id_page . "-liste", false, true); } echo "</div>"; //------------------------------------------------------------------------------ #Log echo "<div id=\"log\">"; if ($niveau['all'] >= 255) { $id_page = "admin-log"; echo "<div id=\"titre2\">"; echo $lang[$lang_select]["titre_" . $id_page]; echo "</div>"; echo "<div style=\"float:right;\">"; echo "<button id=\"" . $id_page . "-del-button\">" . $lang[$lang_select]['del'] . "</button> "; echo "</div>"; echo "<div id=\"" . $id_page . "-dialog\"></div>"; aff_table($id_page . "-liste", true, false); } echo "</div>"; break; //------------------------------------------------------------------------------ #Envoi des mots de passes (Super Admin) //------------------------------------------------------------------------------ #Envoi des mots de passes (Super Admin) case "mdp": $sujet = "[FCBN] Accès à la plateforme CODEX"; $select = $_GET['select']; if (!empty($select) and strpos($select, '&') == null) { $query = "SELECT a.id_user, lib_cbn, nom, prenom, login, pw, tel_bur, tel_port, email, web, descr, aze.lr,qsd.eee,wxc.refnat,zer.catnat,sdf.lsi,xcv.fsd,ref_lr, ref_eee, ref_lsi, ref_catnat, ref_refnat,ref_fsd\n\t FROM applications.utilisateur a\n\t\tJOIN referentiels.cbn z ON a.id_cbn = z.id_cbn\n\t\tJOIN (SELECT id_user, lib as lr FROM applications.utilisateur a JOIN referentiels.user_ref z ON niveau_lr = cd) as aze ON aze.id_user = a.id_user\n\t\tJOIN (SELECT id_user, lib as eee FROM applications.utilisateur a JOIN referentiels.user_ref z ON niveau_eee = cd) as qsd ON qsd.id_user = a.id_user\n\t\tJOIN (SELECT id_user, lib as refnat FROM applications.utilisateur a JOIN referentiels.user_ref z ON niveau_refnat = cd) as wxc ON wxc.id_user = a.id_user\n\t\tJOIN (SELECT id_user, lib as catnat FROM applications.utilisateur a JOIN referentiels.user_ref z ON niveau_catnat = cd) as zer ON zer.id_user = a.id_user\n\t\tJOIN (SELECT id_user, lib as lsi FROM applications.utilisateur a JOIN referentiels.user_ref z ON niveau_lsi = cd) as sdf ON sdf.id_user = a.id_user\n\t\tJOIN (SELECT id_user, lib as fsd FROM applications.utilisateur a JOIN referentiels.user_ref z ON niveau_fsd = cd) as xcv ON xcv.id_user = a.id_user\n\t\tWHERE a.id_user = '******';\n\t\t"; $result = pg_query($db, $query) or die("Erreur pgSQL : " . pg_result_error($result)); $row = pg_fetch_array($result); $message_html = msg_pw($row); envoi_mail($row['email'], $sujet, $message_html, ""); } elseif (strlen($select) > 0) {
?> <!DOCTYPE html PUBLIC "-//W3C//Dtd html 4.0 Transitional//EN"> <html> <head> <meta HTTP-EQUIV="CONTENT-TYPE" content="text/html; charset=UTF-8"> <title>script</title> </head> <body> <h1> Choisir une table dans la liste </h1> <?php $table = $_GET["table"]; $colone = $_GET["colone"]; $liste = ''; for ($i = 0; $i < count($colone); $i++) { $liste = $liste . $colone[$i]; if ($i < count($colone) - 1) { $liste = $liste . ","; } $liste = $liste . " "; } echo $liste; echo $table; $req = "SELECT " . $liste . " FROM " . $table . ""; $query = pg_query($dbconn, $req); aff_table($query); echo "<a href='http://www.ecole.ensicaen.fr/~pelay/BDD/script3.php?table=" . $table . "' >Retour au choix des colones</a> "; echo "</br>"; echo "<a href='http://www.ecole.ensicaen.fr/~pelay/BDD/script2.php'> Retour au choix de la table</a>"; ?> </body> </html>