[GNUnet-SVN] r647 - Extractor-docs/WWW GNUnet-docs/WWW GNUnet-docs/WWW/g

gnunet-svn
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[GNUnet-SVN] r647 - Extractor-docs/WWW GNUnet-docs/WWW GNUnet-docs/WWW/g

From:	grothoff
Subject:	[GNUnet-SVN] r647 - Extractor-docs/WWW GNUnet-docs/WWW GNUnet-docs/WWW/gnu.org doodle-docs/WWW i18nHTML/src
Date:	Sun, 10 Apr 2005 23:53:02 -0700 (PDT)
Author: grothoff
Date: 2005-04-10 23:52:55 -0700 (Sun, 10 Apr 2005)
New Revision: 647

Modified:
   Extractor-docs/WWW/editor.php
   Extractor-docs/WWW/i18nhtml.inc
   GNUnet-docs/WWW/editor.php
   GNUnet-docs/WWW/gnu.org/editor.php
   GNUnet-docs/WWW/gnu.org/i18nhtml.inc
   GNUnet-docs/WWW/i18nhtml.inc
   doodle-docs/WWW/editor.php
   doodle-docs/WWW/i18nhtml.inc
   i18nHTML/src/i18nhtml.inc
Log:
fix

Modified: Extractor-docs/WWW/editor.php
===================================================================
--- Extractor-docs/WWW/editor.php       2005-04-11 06:51:40 UTC (rev 646)
+++ Extractor-docs/WWW/editor.php       2005-04-11 06:52:55 UTC (rev 647)
@@ -81,7 +81,7 @@
     if ($ii < $start)
       continue;
     $cx_plain = fix($row["c"]);
-    $cx_sql = mysql_real_escape_string($cx_sql);
+    $cx_sql = mysql_real_escape_string($cx_plain);
     
     $query = "SELECT ranking FROM map WHERE name=\"$cx_sql\" AND 
lang=\"$lang\"";
     $result2 = mysql_query($query, $connection);

Modified: Extractor-docs/WWW/i18nhtml.inc
===================================================================
--- Extractor-docs/WWW/i18nhtml.inc     2005-04-11 06:51:40 UTC (rev 646)
+++ Extractor-docs/WWW/i18nhtml.inc     2005-04-11 06:52:55 UTC (rev 647)
@@ -561,6 +561,7 @@
   global $i18nHTMLhasTranslation;
   
   $i18nHTMLhasTranslation = 1; // assume translation until failure
+
   if ($a == "")
     return $a;
   $a = fix($a);
@@ -569,6 +570,27 @@
     // database not available, just print English
     return $a;
   }
+
+  /* //  uncomment to selectively clone DB 
+  $fp = fopen("/tmp/clone.sql", "a+", 0);
+  $query = "SELECT * FROM map WHERE name=\"$a_sql\" ORDER BY ranking DESC";
+  $result = mysql_query($query, $connection);
+  $num = 0;
+  if ($result)
+    $num = mysql_num_rows($result);
+  $last = "English";
+  for ($i=0;$i<$num;$i++) {
+    $row = mysql_fetch_array($result);
+    if ($last != mysql_real_escape_string($row["lang"])) {
+      $last = mysql_real_escape_string($row["lang"]);
+      $trans = mysql_real_escape_string($row["translation"]);
+      $rank = $row["ranking"];
+      $ip = $row["ip"];
+      fputs($fp, "INSERT INTO map VALUES(\"$a_sql\", \"$last\", \"$trans\", 
$rank, \"$ip\");\n");
+    }
+  }
+  */
+
   if ("English" == $lang) {
     // no need to translate english, that's the
     // hard-wired source language!
@@ -612,10 +634,12 @@
         $query = "INSERT INTO pending VALUES(\"$a_sql\", \"$lang\", 1)";
       }
       mysql_query($query, $connection);       
+
     }
     $i18nHTMLhasTranslation = 0; // no translation was found
     return $a;              // just return English string
   } else { // translation available
+
     $row = mysql_fetch_array($result);
     return $row["translation"];
   }

Modified: GNUnet-docs/WWW/editor.php
===================================================================
--- GNUnet-docs/WWW/editor.php  2005-04-11 06:51:40 UTC (rev 646)
+++ GNUnet-docs/WWW/editor.php  2005-04-11 06:52:55 UTC (rev 647)
@@ -81,7 +81,7 @@
     if ($ii < $start)
       continue;
     $cx_plain = fix($row["c"]);
-    $cx_sql = mysql_real_escape_string($cx_sql);
+    $cx_sql = mysql_real_escape_string($cx_plain);
     
     $query = "SELECT ranking FROM map WHERE name=\"$cx_sql\" AND 
lang=\"$lang\"";
     $result2 = mysql_query($query, $connection);

Modified: GNUnet-docs/WWW/gnu.org/editor.php
===================================================================
--- GNUnet-docs/WWW/gnu.org/editor.php  2005-04-11 06:51:40 UTC (rev 646)
+++ GNUnet-docs/WWW/gnu.org/editor.php  2005-04-11 06:52:55 UTC (rev 647)
@@ -81,7 +81,7 @@
     if ($ii < $start)
       continue;
     $cx_plain = fix($row["c"]);
-    $cx_sql = mysql_real_escape_string($cx_sql);
+    $cx_sql = mysql_real_escape_string($cx_plain);
     
     $query = "SELECT ranking FROM map WHERE name=\"$cx_sql\" AND 
lang=\"$lang\"";
     $result2 = mysql_query($query, $connection);

Modified: GNUnet-docs/WWW/gnu.org/i18nhtml.inc
===================================================================
--- GNUnet-docs/WWW/gnu.org/i18nhtml.inc        2005-04-11 06:51:40 UTC (rev 
646)
+++ GNUnet-docs/WWW/gnu.org/i18nhtml.inc        2005-04-11 06:52:55 UTC (rev 
647)
@@ -561,6 +561,7 @@
   global $i18nHTMLhasTranslation;
   
   $i18nHTMLhasTranslation = 1; // assume translation until failure
+
   if ($a == "")
     return $a;
   $a = fix($a);
@@ -569,6 +570,27 @@
     // database not available, just print English
     return $a;
   }
+
+  /* //  uncomment to selectively clone DB 
+  $fp = fopen("/tmp/clone.sql", "a+", 0);
+  $query = "SELECT * FROM map WHERE name=\"$a_sql\" ORDER BY ranking DESC";
+  $result = mysql_query($query, $connection);
+  $num = 0;
+  if ($result)
+    $num = mysql_num_rows($result);
+  $last = "English";
+  for ($i=0;$i<$num;$i++) {
+    $row = mysql_fetch_array($result);
+    if ($last != mysql_real_escape_string($row["lang"])) {
+      $last = mysql_real_escape_string($row["lang"]);
+      $trans = mysql_real_escape_string($row["translation"]);
+      $rank = $row["ranking"];
+      $ip = $row["ip"];
+      fputs($fp, "INSERT INTO map VALUES(\"$a_sql\", \"$last\", \"$trans\", 
$rank, \"$ip\");\n");
+    }
+  }
+  */
+
   if ("English" == $lang) {
     // no need to translate english, that's the
     // hard-wired source language!
@@ -612,10 +634,12 @@
         $query = "INSERT INTO pending VALUES(\"$a_sql\", \"$lang\", 1)";
       }
       mysql_query($query, $connection);       
+
     }
     $i18nHTMLhasTranslation = 0; // no translation was found
     return $a;              // just return English string
   } else { // translation available
+
     $row = mysql_fetch_array($result);
     return $row["translation"];
   }

Modified: GNUnet-docs/WWW/i18nhtml.inc
===================================================================
--- GNUnet-docs/WWW/i18nhtml.inc        2005-04-11 06:51:40 UTC (rev 646)
+++ GNUnet-docs/WWW/i18nhtml.inc        2005-04-11 06:52:55 UTC (rev 647)
@@ -561,6 +561,7 @@
   global $i18nHTMLhasTranslation;
   
   $i18nHTMLhasTranslation = 1; // assume translation until failure
+
   if ($a == "")
     return $a;
   $a = fix($a);
@@ -569,6 +570,27 @@
     // database not available, just print English
     return $a;
   }
+
+  /* //  uncomment to selectively clone DB 
+  $fp = fopen("/tmp/clone.sql", "a+", 0);
+  $query = "SELECT * FROM map WHERE name=\"$a_sql\" ORDER BY ranking DESC";
+  $result = mysql_query($query, $connection);
+  $num = 0;
+  if ($result)
+    $num = mysql_num_rows($result);
+  $last = "English";
+  for ($i=0;$i<$num;$i++) {
+    $row = mysql_fetch_array($result);
+    if ($last != mysql_real_escape_string($row["lang"])) {
+      $last = mysql_real_escape_string($row["lang"]);
+      $trans = mysql_real_escape_string($row["translation"]);
+      $rank = $row["ranking"];
+      $ip = $row["ip"];
+      fputs($fp, "INSERT INTO map VALUES(\"$a_sql\", \"$last\", \"$trans\", 
$rank, \"$ip\");\n");
+    }
+  }
+  */
+
   if ("English" == $lang) {
     // no need to translate english, that's the
     // hard-wired source language!
@@ -612,10 +634,12 @@
         $query = "INSERT INTO pending VALUES(\"$a_sql\", \"$lang\", 1)";
       }
       mysql_query($query, $connection);       
+
     }
     $i18nHTMLhasTranslation = 0; // no translation was found
     return $a;              // just return English string
   } else { // translation available
+
     $row = mysql_fetch_array($result);
     return $row["translation"];
   }

Modified: doodle-docs/WWW/editor.php
===================================================================
--- doodle-docs/WWW/editor.php  2005-04-11 06:51:40 UTC (rev 646)
+++ doodle-docs/WWW/editor.php  2005-04-11 06:52:55 UTC (rev 647)
@@ -81,7 +81,7 @@
     if ($ii < $start)
       continue;
     $cx_plain = fix($row["c"]);
-    $cx_sql = mysql_real_escape_string($cx_sql);
+    $cx_sql = mysql_real_escape_string($cx_plain);
     
     $query = "SELECT ranking FROM map WHERE name=\"$cx_sql\" AND 
lang=\"$lang\"";
     $result2 = mysql_query($query, $connection);

Modified: doodle-docs/WWW/i18nhtml.inc
===================================================================
--- doodle-docs/WWW/i18nhtml.inc        2005-04-11 06:51:40 UTC (rev 646)
+++ doodle-docs/WWW/i18nhtml.inc        2005-04-11 06:52:55 UTC (rev 647)
@@ -561,6 +561,7 @@
   global $i18nHTMLhasTranslation;
   
   $i18nHTMLhasTranslation = 1; // assume translation until failure
+
   if ($a == "")
     return $a;
   $a = fix($a);
@@ -569,6 +570,27 @@
     // database not available, just print English
     return $a;
   }
+
+  /* //  uncomment to selectively clone DB 
+  $fp = fopen("/tmp/clone.sql", "a+", 0);
+  $query = "SELECT * FROM map WHERE name=\"$a_sql\" ORDER BY ranking DESC";
+  $result = mysql_query($query, $connection);
+  $num = 0;
+  if ($result)
+    $num = mysql_num_rows($result);
+  $last = "English";
+  for ($i=0;$i<$num;$i++) {
+    $row = mysql_fetch_array($result);
+    if ($last != mysql_real_escape_string($row["lang"])) {
+      $last = mysql_real_escape_string($row["lang"]);
+      $trans = mysql_real_escape_string($row["translation"]);
+      $rank = $row["ranking"];
+      $ip = $row["ip"];
+      fputs($fp, "INSERT INTO map VALUES(\"$a_sql\", \"$last\", \"$trans\", 
$rank, \"$ip\");\n");
+    }
+  }
+  */
+
   if ("English" == $lang) {
     // no need to translate english, that's the
     // hard-wired source language!
@@ -612,10 +634,12 @@
         $query = "INSERT INTO pending VALUES(\"$a_sql\", \"$lang\", 1)";
       }
       mysql_query($query, $connection);       
+
     }
     $i18nHTMLhasTranslation = 0; // no translation was found
     return $a;              // just return English string
   } else { // translation available
+
     $row = mysql_fetch_array($result);
     return $row["translation"];
   }

Modified: i18nHTML/src/i18nhtml.inc
===================================================================
--- i18nHTML/src/i18nhtml.inc   2005-04-11 06:51:40 UTC (rev 646)
+++ i18nHTML/src/i18nhtml.inc   2005-04-11 06:52:55 UTC (rev 647)
@@ -571,6 +571,7 @@
     return $a;
   }
 
+  /* //  uncomment to selectively clone DB 
   $fp = fopen("/tmp/clone.sql", "a+", 0);
   $query = "SELECT * FROM map WHERE name=\"$a_sql\" ORDER BY ranking DESC";
   $result = mysql_query($query, $connection);
@@ -588,6 +589,7 @@
       fputs($fp, "INSERT INTO map VALUES(\"$a_sql\", \"$last\", \"$trans\", 
$rank, \"$ip\");\n");
     }
   }
+  */
 
   if ("English" == $lang) {
     // no need to translate english, that's the
[Prev in Thread]
Current Thread
[Next in Thread]
[GNUnet-SVN] r647 - Extractor-docs/WWW GNUnet-docs/WWW GNUnet-docs/WWW/gnu.org doodle-docs/WWW i18nHTML/src, grothoff <=
Prev by Date: [GNUnet-SVN] r644 - i18nHTML-docs/WWW
Next by Date: [GNUnet-SVN] r649 - doodle-docs/WWW
Previous by thread: [GNUnet-SVN] r644 - i18nHTML-docs/WWW
Next by thread: [GNUnet-SVN] r649 - doodle-docs/WWW
Index(es):
- Date
- Thread