Changeset 434 for trunk

Timestamp:

Apr 8, 2010, 10:54:50 PM (15 years ago)

Author:

george

Message:

• Upraveno: Zobrazení rozpracovaných a hotových překladů daného uživatele.

File:

• trunk/TranslationList.php (modified) (1 diff)

trunk/TranslationList.php

@@ -162 +162 @@
   ' -> <strong>Počty překladů uživatele '.$Line[0].': </strong><br /><br />');
   
-  echo('<table class="BaseTable"><tr><th>Skupina</th><th>Překladů</th></tr>');
+  echo('<table class="BaseTable"><tr><th>Skupina</th><th>Rozpracovaných</th><th>Hotových</th></tr>');
   $Total = 0;
+  $Total2 = 0;
   foreach($TranslationTree as $Group)
     if($Group['TablePrefix'] != '')
     {
-      if(array_key_exists('not', $_GET)) 
-      {
-        $sql = 'SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE `Complete` = 0 AND `User`='.$_GET['user'];
-        $ID = $Database->SQLCommand($sql);
-        $Line = mysql_fetch_row($ID);
-        $GroupId = $Group['Id'];
-        echo('<tr><td><a href="?group='.$GroupId.'&amp;action=userid&amp;not&amp;user='.$_GET['user'].'">'.$Group['Name'].'</a></td><td>'.$Line[0].'</td></tr>');
-        $Total += $Line[0];
-      } else 
-      {
-        $sql = 'SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE `User`='.$_GET['user'];
-        $ID = $Database->SQLCommand($sql);
-        $Line = mysql_fetch_row($ID);
-        $GroupId = $Group['Id'];
-        echo('<tr><td><a href="?group='.$GroupId.'&amp;action=userid&amp;user='.$_GET['user'].'">'.$Group['Name'].'</a></td><td>'.$Line[0].'</td></tr>');
-        $Total += $Line[0];
-      }
+      $sql = 'SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE (`Complete` = 0) AND (`User`='.$_GET['user'].')';
+      $ID = $Database->SQLCommand($sql);
+      $Line = mysql_fetch_row($ID);
+      $sql = 'SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE (`Complete` = 1) AND (`User`='.$_GET['user'].')';
+      $ID = $Database->SQLCommand($sql);
+      $Line2 = mysql_fetch_row($ID);
+      $GroupId = $Group['Id'];
+      echo('<tr><td><a href="?group='.$GroupId.'&amp;action=userid&amp;not&amp;user='.$_GET['user'].'">'.$Group['Name'].'</a></td><td>'.$Line[0].'</td><td>'.$Line2[0].'</td></tr>');
+      $Total += $Line[0];
+      $Total2 += $Line2[0];
     }
-  echo('<tr><td><strong>Celkem</strong></td><td><strong>'.$Total.'</strong></td></tr>');
+  echo('<tr><td><strong>Celkem</strong></td><td><strong>'.$Total.'</strong></td><td><strong>'.$Total2.'</strong></td></tr>');
   echo('</table>');
 }