From 04e36710efa0cf940bec401a520b8d06f8766447 Mon Sep 17 00:00:00 2001 From: Aurelien LAJOIE Date: Sun, 30 Jan 2005 22:09:14 +0000 Subject: [PATCH] Pour les portables sur manageurs git-archimport-id: opensource@polytechnique.org--2005/platal--mainline--0.9--patch-415 --- include/webservices/manageurs.server.inc.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/include/webservices/manageurs.server.inc.php b/include/webservices/manageurs.server.inc.php index dc2cb08..6a13fa9 100644 --- a/include/webservices/manageurs.server.inc.php +++ b/include/webservices/manageurs.server.inc.php @@ -33,18 +33,20 @@ function get_annuaire_infos($method, $params) { } else{ $res = $globals->xdb->iterRow( - "SELECT a.mobile AS cell, a.naissance AS age, + "SELECT aq.profile_mobile AS cell, a.naissance AS age, adr.adr1, adr.adr2, adr.adr3, adr.cp, adr.ville, adr.pays, adr.tel, adr.fax FROM auth_user_md5 AS a + INNER JOIN auth_user_quick AS aq ON (a.user_id = aq.user_id) LEFT JOIN adresses AS adr ON(adr.uid = a.user_id) WHERE a.matricule = {?} AND NOT FIND_IN_SET('pro', adr.statut) ORDER BY NOT FIND_IN_SET('active', adr.statut), FIND_IN_SET('res-secondaire', adr.statut), NOT FIND_IN_SET('courrier', adr.statut)", $params[1]); - } + + } //traitement des adresss si necessaire if (isset($params[2])) { -- 2.1.4