'adresse'=>CFunctions::addslashes($adresse),
'cp'=>CFunctions::addslashes($cp),
'ville'=>CFunctions::addslashes($ville),
'pays' => $pays,
'email'=>CFunctions::addslashes($email),
'telephone'=>CFunctions::addslashes($telephone),
'mobile'=>CFunctions::addslashes($mobile),
'societe'=>CFunctions::addslashes($societe),
'web'=>CFunctions::addslashes($web),
'etat_contact' => $etat_contact,
'date_contact' => $date_contact,
'commentaire'=>CFunctions::addslashes($commentaire),
'idopportunite' => $idopportunite)
);
$tuse->update();
}
CTableRdv::delete_rdv_of_user($id);
if($date_rdv) {
$trdv = new CTableRdv(array('iduser' => $id, 'nom'=>CFunctions::addslashes($nom_rdv), 'date' => $date_rdv, 'heure' => $heure_rdv, 'type' => $type_rdv, 'etat' => $etat_rdv));
$trdv->insert();
}
// --- DEBUT envoye mail
if ($radioText && $idopportunite)
{
$zSqlEnvoieMail = " SELECT opportunite.*, hbpiecesjointes.piece AS piece, text FROM opportunite" ;
$zSqlEnvoieMail .= " LEFT JOIN hbpiecesjointes ON hbpiecesjointes.id = pieId" ;
$zSqlEnvoieMail .= " LEFT JOIN texte ON texte.id = texId" ;
