. 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
