[GNUnet-SVN] r5579 - in i18nHTML/src: admin i18nHTML

[gnunet]

Author: grothoff
Date: 2007-08-31 20:54:42 -0600 (Fri, 31 Aug 2007)
New Revision: 5579

Modified:
   i18nHTML/src/admin/accounts.php
   i18nHTML/src/admin/cleanup.php
   i18nHTML/src/admin/status.php
   i18nHTML/src/i18nHTML/i18nhtml.php
Log:
fix

Modified: i18nHTML/src/admin/accounts.php
===================================================================
--- i18nHTML/src/admin/accounts.php     2007-08-31 23:40:37 UTC (rev 5578)
+++ i18nHTML/src/admin/accounts.php     2007-09-01 02:54:42 UTC (rev 5579)
@@ -43,7 +43,7 @@
   die();
  }
 echo "<table border=2>";
-echo "<tr><th>Login</th><th>Real 
name</th><th>Language</th><th>Level</th><th>Actions</th></tr>\n";
+echo "<tr><th>Login</th><th>Real 
name</th><th>Language</th><th>Level</th><th>Translations</th><th>Actions</th></tr>\n";
 while ($num-- > 0) {
   $row = mysql_fetch_array($result);
   $log = $row['username'];
@@ -51,7 +51,13 @@
   $lev = $row['level'];
   $allowed = $row['allowed'];
   $cid = $row['uid'];
-  echo "<tr><td>$log</td><td>$rn</td><td>$allowed</td><td>$lev</td>";
+
+  $query2 = "SELECT count(*) FROM ${i18nHTMLsqlPrefix}map WHERE uid=$cid";
+  $result2 = mysql_query($query2, $connection);     
+  $num2 = 0;
+  if ($result2)
+    $num2 = mysql_numrows($result2); 
+  echo "<tr><td><a 
href=\"by_user.php?xlang=${lang}&truid=${tuid}\">$log</a></td><td>$rn</td><td>$allowed</td><td>$lev</td><td>$num2</td>\n";
   echo "<td>";
   if ($log != "legacy") {
     echo "<a href=\"manage_account.php?cid=$cid&action=delete\">delete</a>,";

Modified: i18nHTML/src/admin/cleanup.php
===================================================================
--- i18nHTML/src/admin/cleanup.php      2007-08-31 23:40:37 UTC (rev 5578)
+++ i18nHTML/src/admin/cleanup.php      2007-09-01 02:54:42 UTC (rev 5579)
@@ -36,6 +36,29 @@
 // delete translations containing only a space
 $query = "DELETE FROM ${i18nHTMLsqlPrefix}map WHERE translation=\" \"";
 mysql_query($query, $connection);
+
+
+
+
+
+$query = "SELECT uid FROM ${i18nHTMLsqlPrefix}accounts WHERE level=0";
+$result = mysql_query($query, $connection);     
+$num = 0;
+if ($result)
+  $num = mysql_numrows($result);
+while ($num-- > 0) {
+  $row = mysql_fetch_array($result);
+  $cid = $row['uid'];
+  $query2 = "SELECT count(*) FROM ${i18nHTMLsqlPrefix}map WHERE uid=$cid";
+  $result2 = mysql_query($query2, $connection);     
+  $num2 = 0;
+  if ($result2)
+    $num2 = mysql_numrows($result2); 
+  if ($num2 == 0) {
+    $query3 = "UPDATE ${i18nHTMLsqlPrefix}accounts SET level=-1 WHERE 
uid=$cid";
+    mysql_query($query3, $connection);     
+  }
+ }
 BP();
 H2("Automatic translation cleanup done.");
 EP();

Modified: i18nHTML/src/admin/status.php
===================================================================
--- i18nHTML/src/admin/status.php       2007-08-31 23:40:37 UTC (rev 5578)
+++ i18nHTML/src/admin/status.php       2007-09-01 02:54:42 UTC (rev 5579)
@@ -83,7 +83,7 @@
 
 
 H2("Translations by translator");
-$query = "SELECT username,realname,uid,allowed FROM 
${i18nHTMLsqlPrefix}accounts";
+$query = "SELECT username,realname,uid,allowed FROM 
${i18nHTMLsqlPrefix}accounts WHERE level >= 0";
 $result = mysql_query($query, $connection);     
 $num = 0;
 if ($result)

Modified: i18nHTML/src/i18nHTML/i18nhtml.php
===================================================================
--- i18nHTML/src/i18nHTML/i18nhtml.php  2007-08-31 23:40:37 UTC (rev 5578)
+++ i18nHTML/src/i18nHTML/i18nhtml.php  2007-09-01 02:54:42 UTC (rev 5579)
@@ -124,8 +124,22 @@
 $xlang = $_REQUEST['xlang'];
 if ($xlang)
   $lang = $xlang;
+
 $lang = ucfirst(strtolower($lang));
 $lang = quote_smart($lang);
+
+$query = "SELECT lang FROM ${i18nHTMLsqlPrefix}languages WHERE lang=\"" . 
mysql_real_escape_string($lang) . "\";";
+$result = mysql_query($query, $connection);     
+$num = 0;
+if ($result)
+  $num = mysql_numrows($result);
+if ($num == 0) {
+  $xlang = $i18nHTMLsrcLang;
+  $lang = $i18nHTMLsrcLang;
+ }
+
+$lang = ucfirst(strtolower($lang));
+$lang = quote_smart($lang);
 $editor = $_REQUEST['editor'];
 $i18nHTMLhasTranslation = 0; // set by last call to translation_query()