X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Fphones.check.php;h=62fa4e56704579200e73fe62065a45fc73699212;hb=2db80ab6f7d054ec274c66f7ba983f49596b81cf;hp=077e2fe300f4c8c2d25a171691a0d56a7ad65693;hpb=7972436ae72911c7f2e8d5f3a26204a7ca0ee39d;p=platal.git

diff --git a/bin/cron/phones.check.php b/bin/cron/phones.check.php
index 077e2fe..62fa4e5 100755
--- a/bin/cron/phones.check.php
+++ b/bin/cron/phones.check.php
@@ -19,11 +19,14 @@ function do_update_by_block($values)
       ON DUPLICATE KEY UPDATE  display_tel = VALUES(display_tel)");
 }
 
-$res = XDB::query("SELECT DISTINCT g.phoneprf FROM geoloc_pays AS g WHERE g.phoneprf IS NOT NULL");
+$res = XDB::query("SELECT DISTINCT  phonePrefix
+                              FROM  geoloc_countries
+                             WHERE  phonePrefix IS NOT NULL");
 $prefixes = $res->fetchColumn();
 foreach ($prefixes as $i => $prefix) {
-    $res = XDB::query("SELECT g.phoneformat FROM geoloc_pays AS g
-                        WHERE g.phoneprf = {?} AND g.phoneformat != '' LIMIT 1",
+    $res = XDB::query("SELECT  phoneFormat
+                         FROM  geoloc_countries
+                        WHERE  phonePrefix = {?} AND phoneFormat != '' LIMIT 1",
                       $prefix);
     if ($res->numRows() > 0) {
         $format = $res->fetchOneCell();