Changeset 192 for trunk/TranslationList.php

Timestamp:

May 10, 2009, 1:37:21 PM (16 years ago)

Author:

maron

Message:

Zobrazení všech mých rozepsaných

File:

• trunk/TranslationList.php (modified) (2 diffs)

trunk/TranslationList.php

@@ -190 +190 @@
     if($Group['TablePrefix'] != '')
         {
-      $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];
+          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];
+          }
         }
   echo('<tr><td><strong>Celkem</strong></td><td><strong>'.$Total.'</strong></td></tr>');
@@ -240 +249 @@
   echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a> ->
         <strong>Vypis překladů uživatele '.$Line[0].': </strong><br /><br />');
-  WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where user = '.$_GET['user'], '', 'userid');
+  if(array_key_exists('not', $_GET)) 
+          WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where Complete = 0 AND user = '.$_GET['user'], '', 'userid');
+  else 
+          WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where user = '.$_GET['user'], '', 'userid');
 } else
 if($Action == 'search')