$mapid);
$fields = new SFieldGroup(true, $SFields);
$where = $fields->get_where_statement();
$mapid);
$fields = new SFieldGroup(true, $SFields);
$where = $fields->get_where_statement();
LEFT JOIN geoloc_city AS gc ON(gcim.city_id = gc.id)",
$where . ($direct ? "gcim.infos = 'smallest'" : '1'),
'gc.id, gc.alias',
LEFT JOIN geoloc_city AS gc ON(gcim.city_id = gc.id)",
$where . ($direct ? "gcim.infos = 'smallest'" : '1'),
'gc.id, gc.alias',
'am.cityid = gcim.city_id',
'map.map_id = gcim.map_id'));
$fields = new SFieldGroup(true, $SFields);
'am.cityid = gcim.city_id',
'map.map_id = gcim.map_id'));
$fields = new SFieldGroup(true, $SFields);
$countryres = $set->get('map.map_id AS id,
COUNT(u.user_id) AS nbPop,
SUM(u.promo % 2) AS yellow,
COUNT(DISTINCT gcim.city_id) AS nbCities,
SUM(IF(u.user_id IS NULL,0,am.glng)) AS lonPop,
SUM(IF(u.user_id IS NULL, 0,am.glat)) AS latPop',
$countryres = $set->get('map.map_id AS id,
COUNT(u.user_id) AS nbPop,
SUM(u.promo % 2) AS yellow,
COUNT(DISTINCT gcim.city_id) AS nbCities,
SUM(IF(u.user_id IS NULL,0,am.glng)) AS lonPop,
SUM(IF(u.user_id IS NULL, 0,am.glat)) AS latPop',
if ($maxpop < $c['nbPop']) $maxpop = $c['nbPop'];
$c['xPop'] = geoloc_to_x($c['lonPop'], $c['latPop']);
$c['yPop'] = geoloc_to_y($c['lonPop'], $c['latPop']);
if ($maxpop < $c['nbPop']) $maxpop = $c['nbPop'];
$c['xPop'] = geoloc_to_x($c['lonPop'], $c['latPop']);
$c['yPop'] = geoloc_to_y($c['lonPop'], $c['latPop']);
if ($nocity && $nbcities < $minentities){
foreach($countries as $i => $c) {
$countries[$i]['nbPop'] = 0;
if ($nocity && $nbcities < $minentities){
foreach($countries as $i => $c) {
$countries[$i]['nbPop'] = 0;
geoloc_getData_subcities($c['id'], $sin, $cities, false);
}
}
geoloc_getData_subcities($c['id'], $sin, $cities, false);
}
}