gnunet-svn
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[GNUnet-SVN] r4208 - in i18nHTML: . src src/admin src/i18nHTML


From: grothoff
Subject: [GNUnet-SVN] r4208 - in i18nHTML: . src src/admin src/i18nHTML
Date: Sat, 6 Jan 2007 00:03:44 -0800 (PST)

Author: grothoff
Date: 2007-01-06 00:03:39 -0800 (Sat, 06 Jan 2007)
New Revision: 4208

Removed:
   i18nHTML/src/admin/vote.php
Modified:
   i18nHTML/README
   i18nHTML/src/admin/Makefile.am
   i18nHTML/src/admin/commitMassTranslation.php
   i18nHTML/src/admin/commitTranslation.php
   i18nHTML/src/admin/editor.php
   i18nHTML/src/admin/login.php
   i18nHTML/src/admin/signup.php
   i18nHTML/src/admin/status.php
   i18nHTML/src/admin/tables.php
   i18nHTML/src/admin/translate.php
   i18nHTML/src/i18nHTML/i18nhtml.php
   i18nHTML/src/update0_3_0.php
   i18nHTML/todo
Log:
removing voting system

Modified: i18nHTML/README
===================================================================
--- i18nHTML/README     2007-01-06 07:22:03 UTC (rev 4207)
+++ i18nHTML/README     2007-01-06 08:03:39 UTC (rev 4208)
@@ -93,9 +93,7 @@
 
 When translating a given string, all unique translations are
 stored in the database.  The translate.php page (the page
-shown during translation) will list all current translations
-and provide an opportunity to vote (by selecting the choice)
-on which translation to use.
+shown during translation) will list all current translations.
 
 Warning: Although valid translations should be preserved,
 a malicious person can easily force all translations to refer

Modified: i18nHTML/src/admin/Makefile.am
===================================================================
--- i18nHTML/src/admin/Makefile.am      2007-01-06 07:22:03 UTC (rev 4207)
+++ i18nHTML/src/admin/Makefile.am      2007-01-06 08:03:39 UTC (rev 4208)
@@ -1,8 +1,11 @@
 pkgdata_DATA = \
  accounts.php \
  add_language.php \
+ cleanup.php \
  commitMassTranslation.php \
  commitTranslation.php \
+ delete.php \
+ dig.php \
  editor.php \
  index.php \
  languages.php \
@@ -14,5 +17,4 @@
  signup.php \
  status.php \
  tables.php \
- translate.php \
- vote.php
+ translate.php 

Modified: i18nHTML/src/admin/commitMassTranslation.php
===================================================================
--- i18nHTML/src/admin/commitMassTranslation.php        2007-01-06 07:22:03 UTC 
(rev 4207)
+++ i18nHTML/src/admin/commitMassTranslation.php        2007-01-06 08:03:39 UTC 
(rev 4208)
@@ -1,6 +1,6 @@
 <?php
 /*
-     (C) 2003, 2004, 2005 Christian Grothoff
+     (C) 2003, 2004, 2005, 2007 Christian Grothoff
 
      This code is free software; you can redistribute it and/or modify
      it under the terms of the GNU General Public License as published
@@ -17,32 +17,34 @@
      Free Software Foundation, Inc., 59 Temple Place - Suite 330,
      Boston, MA 02111-1307, USA.
 */
-include("i18nHTML/i18nhtml.php");
+include_once("i18nHTML/i18nhtml.php");
 include("login.php");
 if (!$connection) {
   echo "Database is down. Cannot edit translations.";
   die();
 }
 if ($lang == $i18nHTMLsrcLang) {
-  W("Translating to " . $i18nHTMLsrcLang . " currently not allowed.\n");
+  W("Translating to ${i18nHTMLsrcLang} currently not allowed.\n");
   die();
 }
 DOCTYPE("HTML", "Transitional");
 echo "<html><head>";
 TITLE("WWW translation: commit");
 echo "</head><body>";
+BP();
 W("Processing translations...");
 P();
+$start = $_POST["start"];
 $skip = 0;
 foreach($_POST as $dec=>$val) {
-  if ( ($dec == "xlang") || ($dec == "start") )
+  if ($dec == "start")
     continue;
   if ($val == "") {
     $skip++;
     continue;
   }
   $val = fix($val);
-  $query = "SELECT c FROM ".$i18nHTMLsqlPrefix."pending WHERE lang=\"$lang\"";
+  $query = "SELECT c FROM ${i18nHTMLsqlPrefix}pending WHERE lang=\"$lang\"";
   $result = mysql_query($query, $connection);
   $num = 0;
   if ($result)
@@ -61,13 +63,13 @@
     W("Did not find &quot;%s&quot; in pending translations, skipping.",
       $dec);
     P();
+    $skip++;
     continue;
   }
-  $query = "DELETE FROM ".$i18nHTMLsqlPrefix."pending WHERE lang=\"$lang\" AND 
c=\"$enc_sql\"";
+  $query = "DELETE FROM ${i18nHTMLsqlPrefix}pending WHERE lang=\"$lang\" AND 
c=\"$enc_sql\"";
   mysql_query($query, $connection);
   $val_sql = mysql_real_escape_string(to_unicode($val));
-  $query = "SELECT ranking FROM ".$i18nHTMLsqlPrefix."map WHERE 
name=\"$enc_sql\"" .
-           " AND lang=\"$lang\" AND translation=\"$val_sql\"";
+  $query = "SELECT tid FROM ${i18nHTMLsqlPrefix}map WHERE name=\"$enc_sql\" 
AND lang=\"$lang\" AND translation=\"$val_sql\"";
   $result = mysql_query($query, $connection);
   $num = 0;
   if ($result)
@@ -82,7 +84,7 @@
       W("Also, a single displayed %% sign must be translated into two (%%%%) 
such signs.");
       P();
     } else {
-      $query = "INSERT INTO ".$i18nHTMLsqlPrefix."map VALUES(\"$enc_sql\", 
\"$lang\", " .
+      $query = "INSERT INTO ${i18nHTMLsqlPrefix}map VALUES(\"$enc_sql\", 
\"$lang\", " .
                "\"$val_sql\", 1, \"" . $_SERVER['REMOTE_ADDR'] . "\", $uid);";
       mysql_query($query, $connection);
       W("Storing translation for &quot;%s&quot = &quot;%s&quot;.",
@@ -93,11 +95,12 @@
   }
 }
 P();
-echo "<a href=\"" . $i18nHTMLbase . "editor.php?xlang=" . $lang . "&start=" . 
($start + $skip) . "\">";
+echo "<a href=\"${i18nHTMLbase}editor.php?xlang=${lang}&start=" . ($start + 
$skip) . "\">";
 $t = TRANSLATE("Continue mass-editing...");
 echo "</a>";
 if ($t == 1)
   translateLink($b);
+EP();
 generateFooter();
 echo "</body></html>";
 ?>

Modified: i18nHTML/src/admin/commitTranslation.php
===================================================================
--- i18nHTML/src/admin/commitTranslation.php    2007-01-06 07:22:03 UTC (rev 
4207)
+++ i18nHTML/src/admin/commitTranslation.php    2007-01-06 08:03:39 UTC (rev 
4208)
@@ -38,20 +38,17 @@
 
 $back            = $_REQUEST['back'];
 // check for identical translation
-$query = "SELECT ranking,translation FROM ${i18nHTMLsqlPrefix}map WHERE 
name=\"$text_sql\" AND lang=\"$lang\"";
+$query = "SELECT translation FROM ${i18nHTMLsqlPrefix}map WHERE 
name=\"$text_sql\" AND lang=\"$lang\"";
 
 $result = mysql_query($query, $connection);
 $num = 0;
 if ($result)
   $num = mysql_numrows($result);
 $exists = 0;
-$max = 0;
 for ($ii=0;$ii<$num;$ii++) {
   $row = mysql_fetch_array($result);
   if ($row["translation"] == $translation_sql)
     $exists = 1;
-  if ($row["rank"] > $max)
-    $max = $row["rank"];
  }
 
 if ($exists == 1) {
@@ -78,7 +75,7 @@
       echo "</body></html>";
   } else {
     $query = "INSERT INTO ${i18nHTMLsqlPrefix}map VALUES(\"$text_sql\", 
\"$lang\", " .
-             "\"$translation_sql\", $max+1, \"" . $_SERVER['REMOTE_ADDR'] . 
"\", $uid);";
+             "\"$translation_sql\", \"" . $_SERVER['REMOTE_ADDR'] . "\", 
$uid);";
     $result = mysql_query($query, $connection);
     if ($result) {
       $query = "DELETE FROM ${i18nHTMLsqlPrefix}pending WHERE lang=\"$lang\" 
AND c=\"$text_sql\"";

Modified: i18nHTML/src/admin/editor.php
===================================================================
--- i18nHTML/src/admin/editor.php       2007-01-06 07:22:03 UTC (rev 4207)
+++ i18nHTML/src/admin/editor.php       2007-01-06 08:03:39 UTC (rev 4208)
@@ -45,7 +45,7 @@
 W("Do not copy the quotes (&quot;) from the original messages into the 
translations.");
 W("Leave translations that you cannot do blank.");
 
-$query = "SELECT c FROM ".$i18nHTMLsqlPrefix."pending WHERE lang=\"$lang\" 
ORDER BY count DESC";
+$query = "SELECT c FROM ${i18nHTMLsqlPrefix}pending WHERE lang=\"$lang\" ORDER 
BY count DESC";
 $result = mysql_query($query, $connection);
 $num = 0;
 if ($result)
@@ -69,8 +69,7 @@
     ARRAY($start, $end));
   P();
 
-  echo "<form method=\"POST\" action=\"" . $i18nHTMLbase . 
"commitMassTranslation.php\">";
-  echo "<input type=hidden name=\"xlang\" value=\"$xlang\">";
+  echo "<form method=\"POST\" 
action=\"${i18nHTMLbase}commitMassTranslation.php?xlang=${lang}\">";
   echo "<input type=hidden name=\"start\" value=\"$start\">";
 
   echo "<table border=5>";
@@ -85,7 +84,7 @@
     $cx_plain = fix($row["c"]);
     $cx_sql = mysql_real_escape_string($cx_plain);
 
-    $query = "SELECT ranking FROM ".$i18nHTMLsqlPrefix."map WHERE 
name=\"$cx_sql\" AND lang=\"$lang\"";
+    $query = "SELECT tid FROM ${i18nHTMLsqlPrefix}map WHERE name=\"$cx_sql\" 
AND lang=\"$lang\"";
     $result2 = mysql_query($query, $connection);
     $num2 = 0;
     if ($result2)
@@ -94,7 +93,7 @@
     echo "&quot;" . htmlentities($cx_plain) . "&quot;";
     echo "</td>\n\t<td width=\"50%\">";
     if ($num2 > 0) {
-      $query = "DELETE FROM ".$i18nHTMLsqlPrefix."pending WHERE lang=\"$lang\" 
AND c=\"$cx_sql\"";
+      $query = "DELETE FROM ${i18nHTMLsqlPrefix}pending WHERE lang=\"$lang\" 
AND c=\"$cx_sql\"";
       mysql_query($query, $connection);
       W("Skipped (already translated).");
     } else {
@@ -109,14 +108,14 @@
 }
 if ($end < $num) {
   P();
-  echo "<a href=\"" . $i18nHTMLbase . "editor.php?xlang=" . $lang . "&start=" 
. $end . "\">";
+  echo "<a href=\"${i18nHTMLbase}editor.php?xlang=${lang}&start=${end}\">";
   $t = TRANSLATE("Skip these sentences, continue with next set.");
   echo "</a>";
   if ($t == 1)
     translateLink($b);
 } else {
   W("Statistics about translation progress can be found %s.\n",
-    intlink_($i18nHTMLbase . "status.php", "here"));
+    intlink_("${i18nHTMLbase}status.php", "here"));
 }
 P();
 H2("Remarks");

Modified: i18nHTML/src/admin/login.php
===================================================================
--- i18nHTML/src/admin/login.php        2007-01-06 07:22:03 UTC (rev 4207)
+++ i18nHTML/src/admin/login.php        2007-01-06 08:03:39 UTC (rev 4208)
@@ -40,7 +40,8 @@
   while ($num > 0) {
     $row = mysql_fetch_array($result);
     $allowed = $row["allowed"];
-    if ($allowed == $lang) {
+    if ( ($allowed == $lang) ||
+        ($allowed == $i18nHTMLsrcLang) ) {
       $uid = $row["uid"];
       $level = $row["level"];
       break;

Modified: i18nHTML/src/admin/signup.php
===================================================================
--- i18nHTML/src/admin/signup.php       2007-01-06 07:22:03 UTC (rev 4207)
+++ i18nHTML/src/admin/signup.php       2007-01-06 08:03:39 UTC (rev 4208)
@@ -54,6 +54,11 @@
   $realname =  mysql_real_escape_string($_SESSION['realname']);
   $password =  mkpass();
 
+  if ($language == $i18nHTMLsrcLang) {
+    W("You must use the MySQL prompt to create accounts that will work for all 
languages.");
+    die();
+  }
+
   $query = "SELECT lang FROM ${i18nHTMLsqlPrefix}languages WHERE 
lang=\"$language\";";
   $result = mysql_query($query, $connection);     
   $num = 0;

Modified: i18nHTML/src/admin/status.php
===================================================================
--- i18nHTML/src/admin/status.php       2007-01-06 07:22:03 UTC (rev 4207)
+++ i18nHTML/src/admin/status.php       2007-01-06 08:03:39 UTC (rev 4208)
@@ -42,46 +42,26 @@
   $num = mysql_numrows($result);
 W("Sentences in the original ${i18nHTMLsrcLang} text: %s",
   $num);
-EP();
-if ($mode == 1) {  
-  H2("All available translations");
-  echo "<table border='5'>\n";
-  echo "<tr>";
-  TH("Original");
-  TH("Language");
-  TH("Translation");
-  TH("Votes");
-  echo "</tr>\n";
-}
+P();
+
 $stats = ARRAY();
-$query = "SELECT name,ranking,translation,lang FROM ${i18nHTMLsqlPrefix}map";
+$query = "SELECT lang FROM ${i18nHTMLsqlPrefix}languages ORDER BY lang";
 $result = mysql_query($query, $connection);
 $num = 0;
 if ($result)
   $num = mysql_numrows($result);
+echo "<center>[<a href=\"?xlang=${i18nHTMLsrcLang}\">" . W_($i18nHTMLsrcLang) 
. "</a>";
 while ($num-- > 0) {
   $row = mysql_fetch_array($result);
-  $text = stripslashes($row["name"]);
-  $translation = stripslashes($row["translation"]);
-  $ranking = $row["ranking"];
-  $stats[$row["lang"]]++;
-  if ($mode == 1) {
-    printf("<tr><td>%s</td><td>%s</td><td><a href=\"vote.php3?" .
-           "lang=%s&text=%s&translation=%s\">%s</a></td><td>%s</td></tr>\n",
-          $text,
-          $row["lang"],
-          urlencode($row["lang"]),
-          urlencode($text),
-          urlencode($translation),
-          $translation,
-          $ranking);
-  }
-}
-if ($mode == 1) {
-  echo "</table>";
-  HR();
-}
-BP();
+  $clang = $row["lang"];
+  $query2 = "SELECT tid FROM ${i18nHTMLsqlPrefix}map WHERE lang=\"${clang}\"";
+  $result2 = mysql_query($query2, $connection);
+  $num = 0;
+  if ($result)
+    $num = mysql_numrows($result2);
+  $stats[$clang] = $num;
+ }
+
 W("%s translated sentences in database.", $num);
 EP();
 echo "<center><table border=5>\n";

Modified: i18nHTML/src/admin/tables.php
===================================================================
--- i18nHTML/src/admin/tables.php       2007-01-06 07:22:03 UTC (rev 4207)
+++ i18nHTML/src/admin/tables.php       2007-01-06 08:03:39 UTC (rev 4208)
@@ -20,8 +20,8 @@
 include("i18nHTML/i18nhtml.php");
 // ensure the mapping and pending tables exist, creating them if not
 $query="CREATE TABLE IF NOT EXISTS ${i18nHTMLsqlPrefix}map" .
-       " (name BLOB, lang TINYBLOB, translation BLOB, ranking INT, ip 
TINYTEXT, uid INT, " .
-       "INDEX(name(10)), INDEX(lang(4)), INDEX(ranking), 
INDEX(translation(10)))";
+       " (name BLOB, lang TINYBLOB, translation BLOB, ip TINYTEXT, uid INT, 
tid BIGINT NOT NULL AUTO_INCREMENT, " .
+       "INDEX(name(10)), INDEX(lang(4)), INDEX(translation(10)), PRIMARY 
KEY(tid))";
 $result = mysql_query($query, $connection);
 if (!$result) {
   die('Unable to initialize map table.  Invalid query: ' . mysql_error());

Modified: i18nHTML/src/admin/translate.php
===================================================================
--- i18nHTML/src/admin/translate.php    2007-01-06 07:22:03 UTC (rev 4207)
+++ i18nHTML/src/admin/translate.php    2007-01-06 08:03:39 UTC (rev 4208)
@@ -1,6 +1,6 @@
 <?php
 /*
-     (C) 2003, 2004, 2005, 2006 Christian Grothoff
+     (C) 2003, 2004, 2005, 2006, 2007 Christian Grothoff
 
      This code is free software; you can redistribute it and/or modify
      it under the terms of the GNU General Public License as published
@@ -35,7 +35,9 @@
 echo "\">";
 echo "</head><body>";
 if ($lang == $i18nHTMLsrcLang) {
-  echo "Cannot translate to " . $i18nHTMLsrcLang . ".";
+  echo "Cannot translate to ${i18nHTMLsrcLang}.";
+  generateFooter();
+  echo "</body></html>";
   die();
  }
 H2("Original Text");
@@ -44,7 +46,7 @@
 W("Destination language: ");
 W($lang);
 P();
-echo "<form method=\"POST\" action=\"" . $i18nHTMLbase . 
"commitTranslation.php\">\n";
+echo "<form method=\"POST\" 
action=\"${i18nHTMLbase}commitTranslation.php\">\n";
 echo "<input type=hidden name=\"text\" value=\"$text_url\">\n";
 echo "<input type=hidden name=\"xlang\" value=\"$xlang\">\n";
 echo "<input type=hidden name=\"back\" value=\"$back\">\n";
@@ -59,20 +61,16 @@
 H2("All available translations");
 echo "<table border=5 width=95%>\n";
 echo "<tr><th>" . W_("Language") . "</th><th>" . W_("Translation") . 
"</th></tr>\n";
-$query = "SELECT translation,lang FROM ".$i18nHTMLsqlPrefix."map WHERE 
name=\"$text_sql\" ORDER BY ranking DESC";
+$query = "SELECT translation,lang FROM ${i18nHTMLsqlPrefix}map WHERE 
name=\"$text_sql\"";
 $result = mysql_query($query, $connection);
 $num = 0;
 if ($result)
   $num = mysql_num_rows($result);
-for ($i=0;$i<$num;$i++) {
+while ($num-- > 0) {
   $row = mysql_fetch_array($result);
   $translation = $row["translation"];
-  printf("<tr><td>%s</td><td><a href=\"" . $i18nHTMLbase .
-         "vote.php?xlang=%s&text=%s&translation=%s\">%s</a></td></tr>\n",
+  printf("<tr><td>%s</td><td>%s</td></tr>\n",
          W_($row["lang"]),
-         urlencode($row["lang"]),
-         urlencode($text_url),  // yes, we need urlencode twice!
-         urlencode(urlencode($translation)), // yes, we need urlencode twice!
          fix($translation));
 }
 echo "</table>";
@@ -86,7 +84,7 @@
 H3("Language specific special characters");
 W("Various languages use special characters.");
 W("The code has not been tested with certain character sets, such as 
Chinese.");
-W("If you are trying to translate the page to such a language, please contact 
the developerws if you encounter any problems.");
+W("If you are trying to translate the page to such a language, please contact 
the developers if you encounter any problems.");
 P();
 H3("Copyright");
 W("The original english text is released under the GNU Free Documentation 
License (FDL).");

Deleted: i18nHTML/src/admin/vote.php
===================================================================
--- i18nHTML/src/admin/vote.php 2007-01-06 07:22:03 UTC (rev 4207)
+++ i18nHTML/src/admin/vote.php 2007-01-06 08:03:39 UTC (rev 4208)
@@ -1,59 +0,0 @@
-<?php
-/*
-     (C) 2003, 2004, 2005, 2006 Christian Grothoff
-
-     This code is free software; you can redistribute it and/or modify
-     it under the terms of the GNU General Public License as published
-     by the Free Software Foundation; either version 2, or (at your
-     option) any later version.
-
-     The code is distributed in the hope that it will be useful, but
-     WITHOUT ANY WARRANTY; without even the implied warranty of
-     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
-     General Public License for more details.
-
-     You should have received a copy of the GNU General Public License
-     along with the code; see the file COPYING.  If not, write to the
-     Free Software Foundation, Inc., 59 Temple Place - Suite 330,
-     Boston, MA 02111-1307, USA.
-*/
-// This file records votes from users for translations.
-// For sentences with multiple translations, the one with the most
-// votes is displayed.
-include_once("i18nHTML/i18nhtml.php");
-include("login.php");
-DOCTYPE("HTML", "Transitional");
-echo "<html><head>";
-TITLE("WWW translation: vote");
-echo "</head><body>";
-if (!$connection) {
-  echo "Database is down. Cannot edit translations.";
-  die();
- }
-$text            = fix(urldecode($_REQUEST['text']));
-$translation     = fix(urldecode($_REQUEST['translation']));
-$text_sql        = quote_smart($text);
-$translation_sql = quote_smart(to_unicode($translation));
-
-$query = "SELECT ranking FROM ${i18nHTMLsqlPrefix}map WHERE " .
-         "name=\"$text_sql\" AND lang=\"$lang\" AND 
translation=\"$translation_sql\"";
-$result = mysql_query($query, $connection);
-$num = 0;
-if ($result)
-  $num = mysql_numrows($result);
-if ($num > 0) {
-  $row = mysql_fetch_array($result);
-  $ranking = $row["ranking"] + 1;
-  $query = "UPDATE ${i18nHTMLsqlPrefix}map SET ranking=\"$ranking\" WHERE " .
-           "name=\"$text_sql\" AND lang=\"$lang\" AND 
translation=\"$translation_sql\"";
-  mysql_query($query, $connection);
-  W("Ranking of translation is now: ");
-  echo "$ranking";
-} else {
-  W("Translation '%s' of '%s' does not exist (bug?).",
-    ARRAY($translation, $text));
-}
-HR();
-generateFooter();
-echo "</body></html>\n";
-?>

Modified: i18nHTML/src/i18nHTML/i18nhtml.php
===================================================================
--- i18nHTML/src/i18nHTML/i18nhtml.php  2007-01-06 07:22:03 UTC (rev 4207)
+++ i18nHTML/src/i18nHTML/i18nhtml.php  2007-01-06 08:03:39 UTC (rev 4208)
@@ -588,8 +588,8 @@
     }
     return $a;
   }
-  // attempt to get translations, ranked for best
-  $query = "SELECT translation FROM ${i18nHTMLsqlPrefix}map WHERE 
name=\"$a_sql\" AND lang=\"$lang\" ORDER BY ranking DESC";
+  // attempt to get translation
+  $query = "SELECT translation FROM ${i18nHTMLsqlPrefix}map WHERE 
name=\"$a_sql\" AND lang=\"$lang\"";
   $result = mysql_query($query, $connection);
   $num = 0;
   if ($result)
@@ -608,8 +608,7 @@
       if ($num > 0) {
         $row = mysql_fetch_array($result);
         $count = $row["count"] + 1;
-        $query = "UPDATE " . $i18nHTMLsqlPrefix . 
-                 "pending SET count=$count WHERE c=\"$a_sql\" AND 
lang=\"$lang\"";
+        $query = "UPDATE $i18nHTMLsqlPrefix{pending} SET count=$count WHERE 
c=\"$a_sql\" AND lang=\"$lang\"";
       } else {
         $query = "INSERT INTO ${i18nHTMLsqlPrefix}pending VALUES(\"$a_sql\", 
\"$lang\", 1)";
       }
@@ -754,7 +753,8 @@
 // displays a list of all languages currently available with
 // at least 1 translated string.
 function generateLanguageBar() {
-  global $connection, $i18nHTMLsqlPrefix;
+  global $connection;
+  global $i18nHTMLsqlPrefix;
   global $i18nHTMLsrcLang;
 
   if ($connection) {

Modified: i18nHTML/src/update0_3_0.php
===================================================================
--- i18nHTML/src/update0_3_0.php        2007-01-06 07:22:03 UTC (rev 4207)
+++ i18nHTML/src/update0_3_0.php        2007-01-06 08:03:39 UTC (rev 4208)
@@ -6,7 +6,7 @@
 
 // alter map, adding UID field
 # UID 2 == legacy
-$query="ALTER TABLE ${i18nHTMLsqlPrefix}map ADD uid INT DEFAULT 2 AFTER ip;";
+$query="ALTER TABLE ${i18nHTMLsqlPrefix}map ADD uid INT DEFAULT 2 AFTER ip, 
ADD tid BIGINT NOT NULL AUTO_INCREMENT AFTER uid, ADD PRIMARY KEY(tid), DROP 
ranking;";
 $result = mysql_query($query, $connection);
 if (!$result) {
   die('Unable to initialize map table.  Invalid query: ' . mysql_error());

Modified: i18nHTML/todo
===================================================================
--- i18nHTML/todo       2007-01-06 07:22:03 UTC (rev 4207)
+++ i18nHTML/todo       2007-01-06 08:03:39 UTC (rev 4208)
@@ -1,8 +1,8 @@
 Ideas for future development (with priority):
 
 Users:
-* enable users to edit their own translations
 * expand on-line documentation [MED]
+* enable users to view & edit their own translations
 
 Installation:
 * finish debian package:  [HIGH]
@@ -12,6 +12,3 @@
   - add dependencies (apache2, php, mysql)
 * create script for gathering of initial set of translations [MED]
 
-Internals:
-* get rid of voting system
-* consider allowing anonymous account (have "universal" language for login) 
[LOW]





reply via email to

[Prev in Thread] Current Thread [Next in Thread]