2c772f4a73f726c573272ce7b22487778d6534ed
5 require_once 'connect.db.inc.php';
6 $globals->dbcharset
= 'latin1';
8 $tables = array ('city' => array('id', 'alias'),
9 'city_in_maps' => array('city_id', 'map_id', 'infos'),
10 'maps' => array('map_id'),
11 'pays' => array('a2'),
12 'region' => array('a2', 'region'));
13 foreach ($tables as $table => $keys) {
14 $res = XDB
::query("SELECT * FROM geoloc_$table");
19 $all = $res->fetchAllAssoc();
20 foreach ($all as &$array) {
23 foreach ($array as $key=>$value) {
24 if (in_array($key, $keys)) {
25 $from[] = $key . '=' . XDB
::escape($value);
27 $valued = utf8_decode($value);
28 if (is_utf8($value) && $valued != $value) {
29 $to[] = $key . '=' . XDB
::escape($valued);
33 $to = implode(', ', $to);
34 $from = implode(' AND ', $from);
35 $sql = "UPDATE geoloc_$table SET $to WHERE $from";
36 if (!XDB
::execute($sql)) {
37 echo "Echec : $sql\n";
38 } elseif (XDB
::affectedRows() == 0) {