----------------------------------------------------------------------*/
$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;
?>
