. htmlentities(addslashes($pays),ENT_COMPAT ,'UTF-8') . "', telephone = '" . htmlentities(addslashes($telephone),ENT_COMPAT ,'UTF-8') . "' WHERE email = '" . htmlentities(addslashes($expediteur),ENT_COMPAT ,'UTF-8') . "'"; CCom::recupnomCom('commune', 'id_com', 'nom_com', $ville); if ($idcom) CBdd::update($sql); $sql3 = "UPDATE reponse SET iduser = "******" WHERE iduser = 1 AND date = '" . $date . "'"; CBdd::update($sql3); CUserGroupe::insert($iduser, $id_groupe); } else { $login = CFonction::formate_chaine($nom, ''); $passe = CFonction::get_password(); $sql1 = "INSERT INTO user(id, login, passe, nom, prenom, pays, email, telephone) VALUES(NULL, '" . $login . "', '" . $passe . "', '" . 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