X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fprofile%2Faddresses.inc.php;h=1e518aadcaa21b3afa699f2e479b552018a1f82a;hb=93f3f260cdb11c082f0ebb268b0e75d518099604;hp=2fe7a8d4c08749f6c3039cb5ed1affe8034aaaa5;hpb=2db7542dfaefedbe9d86b03d60f73b05667976d6;p=platal.git diff --git a/modules/profile/addresses.inc.php b/modules/profile/addresses.inc.php index 2fe7a8d..1e518aa 100644 --- a/modules/profile/addresses.inc.php +++ b/modules/profile/addresses.inc.php @@ -138,17 +138,17 @@ class ProfileAddress extends ProfileGeoloc postcode, city, cityid, country, region, regiontxt, pub, datemaj, statut, - uid, adrid, glat, glng) + uid, adrid, glat, glng, comment) VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, FROM_UNIXTIME({?}), {?}, - {?}, {?}, {?}, {?})", + {?}, {?}, {?}, {?}, {?})", $address['adr1'], $address['adr2'], $address['adr3'], $address['postcode'], $address['city'], $address['cityid'], $address['country'], $address['region'], $address['regiontxt'], $address['pub'], $address['datemaj'], $flags, - S::i('uid'), $adrid, $address['precise_lat'], $address['precise_lon']); + S::i('uid'), $adrid, $address['precise_lat'], $address['precise_lon'], $address['comment']); foreach ($address['tel'] as $telid=>&$tel) { $this->saveTel($adrid, $telid, $tel); } @@ -191,7 +191,8 @@ class ProfileAddresses extends ProfilePage FIND_IN_SET('courrier', a.statut) AS mail, FIND_IN_SET('temporaire', a.statut) AS temporary, FIND_IN_SET('active', a.statut) AS current, - a.glat AS precise_lat, a.glng AS precise_lon + a.glat AS precise_lat, a.glng AS precise_lon, + a.comment FROM adresses AS a INNER JOIN geoloc_pays AS gp ON(gp.a2 = a.country) WHERE uid = {?} AND NOT FIND_IN_SET('pro', statut)