2 /***************************************************************************
3 * Copyright (C) 2003-2006 Polytechnique.org *
4 * http://opensource.polytechnique.org/ *
6 * This program is free software; you can redistribute it and/or modify *
7 * it under the terms of the GNU General Public License as published by *
8 * the Free Software Foundation; either version 2 of the License, or *
9 * (at your option) any later version. *
11 * This program is distributed in the hope that it will be useful, *
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
14 * GNU General Public License for more details. *
16 * You should have received a copy of the GNU General Public License *
17 * along with this program; if not, write to the Free Software *
19 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
20 ***************************************************************************/
22 require 'xnet.inc.php';
25 header("Content-type: text/xml");
27 new_nonhtml_page('geoloc/getCityInfos.tpl');
29 require_once('geoloc.inc.php');
30 require_once('search.inc.php');
32 $_REQUEST['asso_id'] = $globals->asso('id');
33 $_REQUEST['only_current'] = 1;
34 $assoField = new RefSField('asso_id',array('gxm.asso_id'),'groupex.membres','gxm','u.user_id=gxm.uid');
35 $cityIdField = new RefSField('cityid',array('av.cityid'),'adresses','av',getadr_join('av'));
37 $fields = new SFieldGroup(true
, array($assoField, $cityIdField));
38 $where = $fields->get_where_statement();
39 if ($where) $where = "WHERE ".$where;
41 $users = XDB
::iterator("
42 SELECT u.user_id AS id, u.prenom, u.nom, u.promo
44 INNER JOIN auth_user_md5 AS u ON(u.user_id = a.uid)
45 INNER JOIN auth_user_quick AS q ON(q.user_id = a.uid)
46 ".$fields->get_select_statement()."
48 GROUP BY u.user_id LIMIT 11",
51 if ($globals->asso('pub') == 'public' || S
::has_perms())
52 $page->assign('users', $users);
55 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker: