[GNUnet-SVN] r586 - i18nHTML/src

[grothoff]

Author: grothoff
Date: 2005-04-03 20:55:29 -0700 (Sun, 03 Apr 2005)
New Revision: 586

Modified:
   i18nHTML/src/i18nhtml.inc
   i18nHTML/src/update.php
Log:
detect bad trans

Modified: i18nHTML/src/i18nhtml.inc
===================================================================
--- i18nHTML/src/i18nhtml.inc   2005-04-04 03:36:12 UTC (rev 585)
+++ i18nHTML/src/i18nhtml.inc   2005-04-04 03:55:29 UTC (rev 586)
@@ -788,7 +788,6 @@
 function TRANSLATE_($a,$args=null) {
   if ($a == "")
     return 0;
-  echo "VNS>>" . translation_query($a) . "<<\n";
   return vsprintf(translation_query($a), $args);
 }
 

Modified: i18nHTML/src/update.php
===================================================================
--- i18nHTML/src/update.php     2005-04-04 03:36:12 UTC (rev 585)
+++ i18nHTML/src/update.php     2005-04-04 03:55:29 UTC (rev 586)
@@ -10,6 +10,7 @@
 $query = "SELECT * FROM map";
 $result = mysql_query($query, $connection);
 $num = 0;
+$loss = 0;
 if ($result) 
   $num = mysql_numrows($result);
 for ($ii=0;$ii<$num;$ii++) {
@@ -19,12 +20,22 @@
   $dst = $row["translation"]; // possibly urlencoded
   $rank = $row["ranking"];
   $rtrans = mysql_real_escape_string(to_unicode(urldecode($dst)));
-  $dst = mysql_real_escape_string($dst);
-  if ($rtrans != $dst) {
-    $subquery = "UPDATE map SET translation=\"$rtrans\" WHERE name=\"$src\" 
AND lang=\"$la\" AND translation=\"$dst\" AND ranking=$rank;\n";
+  // detect "bad" translations (where conversion failed)
+  // if more than 5 values in [0..9] follow => bad conversion
+  $ok = 0 == preg_match("&#[0..9][0..9][0..9][0..9][0..9][0..9]", $rtrans);
+  if ($ok) {
+    $dst = mysql_real_escape_string($dst);
+    if ($rtrans != $dst) {
+      $subquery = "UPDATE map SET translation=\"$rtrans\" WHERE name=\"$src\" 
AND lang=\"$la\" AND translation=\"$dst\" AND ranking=$rank;\n";
+      echo "$subquery\n";
+    }
+  } else {
+    $subquery = "DELETE FROM map WHERE name=\"$src\" AND lang=\"$la\" AND 
translation=\"$dst\" AND ranking=$rank;\n";
     echo "$subquery\n";
+    $loss++;
   }
  }
+echo "# Lost $loss out of $num translations.\n";
 ?>
 # </pre>
 # end of conversion