X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Fprofil%2Fupdate_adresses.inc.php;h=2ba7a00084b4665a7239acff06189e8798e74e93;hb=5912f6b6ec30566211263bfa9bba83d0227b80f1;hp=d6f5213e4875be8c3c34c2536d8171580e4e0bca;hpb=907aa9fa36d3433a15457e18975f6d00ab7178a4;p=platal.git diff --git a/include/profil/update_adresses.inc.php b/include/profil/update_adresses.inc.php index d6f5213..2ba7a00 100644 --- a/include/profil/update_adresses.inc.php +++ b/include/profil/update_adresses.inc.php @@ -61,10 +61,15 @@ foreach ($adresses as $adrid => $adr) { } } else { //c'est une mise à jour + $precise_coords = ""; + if (isset($adr['precise_lat']) && isset($adr['precise_lon'])) { + $precise_coords = ", glat = '".$adr['precise_lat']."'"; + $precise_coords .= ", glng = '".$adr['precise_lon']."'"; + } XDB::execute("UPDATE adresses SET adr1 = {?}, adr2 = {?}, adr3 = {?}, postcode = {?}, city = {?}, cityid = {?}, country = {?}, region = {?}, regiontxt = {?}, - pub = {?}, datemaj = NOW(), statut = {?} + pub = {?}, datemaj = NOW(), statut = {?}".$precise_coords." WHERE uid = {?} AND adrid = {?}", $adr['adr1'], $adr['adr2'], $adr['adr3'], $adr['postcode'], $adr['city'], $adr['cityid'], $adr['country'],