upgrade/0.9.14/geoloc.utf8.php

   1 #!/usr/bin/php5
   2 <?php
   3
   4 global $globals;
   5 require_once 'connect.db.inc.php';
   6 $globals->dbcharset = 'latin1';
   7
   8 function is_utf8($s)
   9 {
  10     return @iconv('utf-8', 'utf-8', $s) == $s;
  11 }
  12
  13 $tables = array ('city', 'city_in_maps', 'maps', 'pays', 'region');
  14 foreach ($tables as $table) {
  15     $res = XDB::query("SELECT * FROM geoloc_$table");
  16     if (!$res) {
  17         echo "$table\n";
  18         continue;
  19     }
  20     $all = $res->fetchAllAssoc();
  21     foreach ($all as &$array) {
  22         $from = array();
  23         $to   = array();
  24         foreach ($array as $key=>$value) {
  25             $from[] = $key . '="' . XDB::escape($value) . '"';
  26             $valued = utf8_decode($value);
  27             if (is_utf8($value) && $valued != $value) {
  28                 $to[] = $key . '="' . XDB::escape($valued) .'"';
  29             }
  30         }
  31         if (!empty($to)) {
  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";
  37             }
  38         }
  39     }
  40 }
  41
  42 ?>