----------------------------------------------------------------------*/ $expediteur = (!empty($_GET['expediteur'])) ? stripslashes($_GET['expediteur']) : ""; /*--------------------------------------------------------------------- INITIALISATION ----------------------------------------------------------------------*/ $msginfo = ""; /*--------------------------------------------------------------------- ENVOI ----------------------------------------------------------------------*/ $sql = "SELECT * FROM user WHERE email = '" . $expediteur . "'"; $user = CBdd::select_row($sql); // Commune $nomCom = CCom::recupnomCom('commune', 'nom_com', 'id_com', $user['commune_alias']); if ($nomCom == '') $nomCom = CCom::recupnomCom('communeD', 'nom_comD', 'id_user', $user['id']); /*--------------------------------------------------------------------- CONFIRMATION ----------------------------------------------------------------------*/ ?> <script type="text/javascript"> $('nom').value = '<?php echo addslashes($user['nom']); ?>' ; $('prenom').value = '<?php echo addslashes($user['prenom']); ?>' ; $('ville').value = '<?php echo addslashes($nomCom); ?>' ; $('pays').value = '<?php echo addslashes($user['pays']); ?>' ; $('telephone').value = '<?php echo addslashes($user['telephone']); ?>'; </script>
. addslashes($nom) . "', '" . addslashes($prenom) . "', '" . htmlentities(addslashes($pays),ENT_COMPAT ,'UTF-8') . "', '" . htmlentities(addslashes($expediteur),ENT_COMPAT ,'UTF-8') . "', '" . htmlentities(addslashes($telephone),ENT_COMPAT ,'UTF-8') . "')"; if(!CBdd::insert($sql1)) exit; $iduser = mysql_insert_id(); // Commune $idcom = CCom::recupnomCom('commune', 'id_com', 'nom_com', $ville); if ($idcom) CBdd::update("UPDATE user SET commune_alias=".$idcom." WHERE id=".$iduser.""); else { // Estexiste $where = "nom_comD = '".$ville."', pays ='".$pays."',id_user ='******'"; $idcom = CCom::recupnomCom('communeD', 'id_user', 'id_user', $iduser); if ($idcom) CCom::updatecom2('communeD', $where, 'id_user', $iduser); else CCom::insert('communeD', $where); } $sql3 = "UPDATE reponse SET iduser = "******" WHERE iduser = 1 AND date = '" . $date . "'"; CBdd::update($sql3); CUserGroupe::insert($iduser, $id_groupe); } /*--------------------------------------------------------------------- CONFIRMATION ----------------------------------------------------------------------*/ echo $msginfo; ?>