- global $globals;
-
- header("Content-type: text/xml");
-
- $page->changeTpl('geoloc/getCityInfos.tpl', NO_SKIN);
-
- require_once('geoloc.inc.php');
- require_once('search.inc.php');
-
- $usual_fields = advancedSearchFromInput();
- $fields = new SFieldGroup(true, $usual_fields);
- $where = $fields->get_where_statement();
- if ($where) $where = "WHERE ".$where;
-
- $users = XDB::iterator("
- SELECT u.user_id AS id, u.prenom, u.nom, u.promo
- FROM adresses AS a
- INNER JOIN auth_user_md5 AS u ON(u.user_id = a.uid)
- INNER JOIN auth_user_quick AS q ON(q.user_id = a.uid)
- ".$fields->get_select_statement()."
- ".$where."
- GROUP BY u.user_id LIMIT 11", $id);
-
- $page->assign('users', $users);