rework XOrgDB -> XDB (shorter, easier to use).

[platal.git] / htdocs / admin / geoloc_dynamap.php

diff --git a/htdocs/admin/geoloc_dynamap.php b/htdocs/admin/geoloc_dynamap.php
index 88827f9..22841de 100644 (file)
--- a/htdocs/admin/geoloc_dynamap.php
+++ b/htdocs/admin/geoloc_dynamap.php
@@ -36,7 +36,7 @@ if (Env::get('fix') == 'smallest_maps') {
 }
 
 if (Env::get('fix') == 'precise_coordinates') {
-    $globals->xdb->execute("UPDATE adresses AS a INNER JOIN geoloc_city AS c ON(a.cityid = c.id) SET a.glat = c.lat / 100000, a.glng = c.lon / 100000");
+    XDB::execute("UPDATE adresses AS a INNER JOIN geoloc_city AS c ON(a.cityid = c.id) SET a.glat = c.lat / 100000, a.glng = c.lon / 100000");
 }
 
 if (Env::has('new_maps')) {
@@ -45,13 +45,13 @@ if (Env::has('new_maps')) {
         $page->trig("Impossible d'accéder aux nouvelles cartes");
 }
 
-$countMissing = $globals->xdb->query("SELECT COUNT(*) FROM geoloc_city AS c LEFT JOIN geoloc_city_in_maps AS m ON(c.id = m.city_id) WHERE m.city_id IS NULL");
+$countMissing = XDB::query("SELECT COUNT(*) FROM geoloc_city AS c LEFT JOIN geoloc_city_in_maps AS m ON(c.id = m.city_id) WHERE m.city_id IS NULL");
 $missing = $countMissing->fetchOneCell();
 
-$countNoSmallest = $globals->xdb->query("SELECT SUM(IF(infos = 'smallest',1,0)) AS n FROM geoloc_city_in_maps GROUP BY city_id ORDER BY n");
+$countNoSmallest = XDB::query("SELECT SUM(IF(infos = 'smallest',1,0)) AS n FROM geoloc_city_in_maps GROUP BY city_id ORDER BY n");
 $noSmallest = $countNoSmallest->fetchOneCell() == 0;
 
-$countNoCoordinates = $globals->xdb->query("SELECT COUNT(*) FROM adresses WHERE cityid IS NOT NULL AND glat = 0 AND glng = 0");
+$countNoCoordinates = XDB::query("SELECT COUNT(*) FROM adresses WHERE cityid IS NOT NULL AND glat = 0 AND glng = 0");
 $noCoordinates = $countNoCoordinates->fetchOneCell();
 
 if (isset($refresh) && $missing) {