5 require_once 'connect.db.inc.php';
6 $globals->dbcharset
= 'latin1';
10 return @iconv
('utf-8', 'utf-8', $s) == $s;
13 $tables = array ('city', 'city_in_maps', 'maps', 'pays', 'region');
14 foreach ($tables as $table) {
15 $res = XDB
::query("SELECT * FROM geoloc_$table");
20 $all = $res->fetchAllAssoc();
21 foreach ($all as &$array) {
24 foreach ($array as $key=>$value) {
25 $from[] = $key . '="' . XDB
::_db_escape($value) . '"';
26 $valued = utf8_decode($value);
27 if (is_utf8($value) && $valued != $value) {
28 $to[] = $key . '="' . XDB
::_db_escape($valued) .'"';
32 $to = implode(', ', $to);
33 $from = implode(' AND ', $from);
34 $sql = "UPDATE geoloc_$table SET $to WHERE $from";
35 if (!XDB
::execute($sql)) {
36 echo "Echec : $sql\n";