[GNUnet-SVN] r638 - doodle-docs/WWW

[grothoff]

Author: grothoff
Date: 2005-04-10 23:23:40 -0700 (Sun, 10 Apr 2005)
New Revision: 638

Removed:
   doodle-docs/WWW/update0_2_0.php
Log:
update

Deleted: doodle-docs/WWW/update0_2_0.php
===================================================================
--- doodle-docs/WWW/update0_2_0.php     2005-04-11 06:22:18 UTC (rev 637)
+++ doodle-docs/WWW/update0_2_0.php     2005-04-11 06:23:40 UTC (rev 638)
@@ -1,36 +0,0 @@
-<?php
-include("i18nhtml.inc");
-?>
-# This script merely generates the SQL statements<br>
-# to do the update.  You'll have to run the SQL<br>
-# commands yourself to prevent accidental data loss.<br>
-# <pre>
-<?php
-echo "use $i18nHTMLsqlDB;\n";
-$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++) {
-  $row = mysql_fetch_array($result);
-  $la = mysql_real_escape_string($row["lang"]);
-  $src = $row["name"]; // urlencoded
-  $src_sql = mysql_real_escape_string($src);
-  $dst_sql = mysql_real_escape_string($row["translation"]);
-  $rank = $row["ranking"];
-  $rname = fix(urldecode($src));
-  $rname_sql = mysql_real_escape_string(fix(urldecode($src)));
-  // detect "bad" translations (where conversion failed)
-  // if more than 5 values in [0..9] follow => bad conversion
-  $txtCnt = count_chars(urldecode($src), 1);
-  $tCnt = count_chars($rtrans, 1);
-
-  $dst = mysql_real_escape_string($dst);
-  $subquery = "UPDATE map SET name=\"$rname_sql\" WHERE name=\"$src_sql\" AND 
lang=\"$la\" AND translation=\"$dst_sql\" AND ranking=$rank;\n";
-  echo "$subquery";
-}
-?>
-# </pre>
-# end of conversion