require_once('geoloc.inc.php');
+global $adresses;
+
// on limite à 6 adresses personnelles par utilisateur
$nb_adr_max = 6; // ( = max(adrid possibles)
// on limite à 4 numéros de téléphone par adresse
function delete_address($adrid, $in_request_array = false){
XDB::execute("DELETE FROM adresses WHERE uid = {?} AND adrid = {?}",
- Session::getInt('uid', -1), $adrid);
+ S::v('uid', -1), $adrid);
XDB::execute("DELETE FROM tels WHERE uid = {?} AND adrid = {?}",
- Session::getInt('uid', -1), $adrid);
+ S::v('uid', -1), $adrid);
if ($in_request_array == true){
unset($_REQUEST['adrid'][$adrid]);
} else{
}
//on verifie si on nous a demande une suppression
-$req_adrid_del = Env::getMixed('adrid_del', Array());
+$req_adrid_del = Env::v('adrid_del', Array());
for ($i = 1; $i <= $nb_adr_max; $i++) {
if (isset($req_adrid_del[$i])) {
delete_address($i,true);
$sql_order = '';
//recuperation des adrid
-$res = XDB::query("SELECT adrid FROM adresses WHERE uid = {?} AND NOT FIND_IN_SET('pro', statut) ".$sql_order, Session::getInt('uid', -1));
+$res = XDB::query("SELECT adrid FROM adresses WHERE uid = {?} AND NOT FIND_IN_SET('pro', statut) ".$sql_order, S::v('uid', -1));
$adrids = $res->fetchColumn();
//recuperation des donnees de la bd
gp.pays AS countrytxt, gp.display
FROM adresses AS a INNER JOIN geoloc_pays AS gp ON(gp.a2 = a.country)
WHERE uid = {?} AND NOT FIND_IN_SET('pro',statut) ".$sql_order
-, Session::getInt('uid', -1)
+, S::v('uid', -1)
);
$nb_adr = $res->total();
t.adrid, telid, tel_type, t.tel_pub, t.tel
FROM tels AS t INNER JOIN adresses AS a ON(t.uid = a.uid AND t.adrid = a.adrid)
WHERE t.uid = {?} AND NOT FIND_IN_SET('pro',statut) ORDER BY t.adrid, tel_type DESC, telid"
-, Session::getInt('uid', -1)
+, S::v('uid', -1)
);
while ($tel = $restels->next()) {
$adrid = $tel['adrid'];