Changeset 20 for ListQuests.php

Timestamp:

Oct 2, 2008, 9:38:57 PM (16 years ago)

Author:

maron

Message:

Vlastní výběr

File:

• ListQuests.php (modified) (2 diffs)

ListQuests.php

@@ -126 +126 @@
 
       if(array_key_exists('nocheck', $_GET)) {
+        echo '<a Title="Zobrazit questy podle vlasního filtru" href="ListQuests.php?filter">Filtr questsù</a> ->
+        <a Title="Zatím nezkontrolované questy" href="ListQuests.php?nocheck">Nezkontrolované questy</a><br><br>';
+
+          WritePages('ListQuests.php?nocheck'," WHERE Language <> 0 AND quests.Complete = '1'
+          AND NOT EXISTS(SELECT 1 FROM tag WHERE ID_user = ".$_SESSION['UserID']." AND tag.type_translation = 1 AND tag.ID_translation = quests.ID)");
+
+        WriteQuests("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User
+         FROM quests WHERE Language <> 0 AND quests.Complete = '1' 
+          AND NOT EXISTS(SELECT 1 FROM tag WHERE ID_user = ".$_SESSION['UserID']." AND tag.type_translation = 1 AND tag.ID_translation = quests.ID)", $_SESSION['limitx'].','.$_SESSION['limity'],'nocheck');
+      } 
+
+      if(array_key_exists('check', $_GET)) {
+        echo '<a Title="Zobrazit questy podle vlasního filtru" href="ListQuests.php?filter">Filtr questù</a> ->
+        <a Title="Zkontrolované questy" href="ListQuests.php?nocheck">Zkontrolované questy</a><br><br>';
+
+  /*        WritePages('ListQuests.php?nocheck'," WHERE Language <> 0 AND quests.Complete = '1'
+          AND EXISTS(SELECT 1 FROM tag WHERE ID_user = ".$_SESSION['UserID']." AND
+           tag.type_translation = 1 AND tag.ID_translation = quests.ID)");
+*/
+        WriteQuests("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User
+         FROM quests WHERE Language <> 0 AND quests.Complete = '1' AND 
+         EXISTS(SELECT 1 FROM tag WHERE ID_user = ".$_SESSION['UserID']." AND 
+         tag.type_translation = 1 AND tag.ID_translation = quests.ID)", $_SESSION['limitx'].','.$_SESSION['limity'],'check');
+      } 
+
+      if(array_key_exists('admin_check', $_GET)) {
+        echo '<a Title="Zobrazit questy podle vlasního filtru" href="npc_list.php?filter">Filtr questù</a> ->
+        <a Title="Zkontrolované questy" href="npc_list.php?admin_nocheck">Zkontrolované questy</a><br><br>';
+
+          WritePages('ListQuests.php?nocheck'," WHERE Language <> 0 AND quests.Complete = '1' AND admin_check = 1");
+
+        WriteQuests("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User
+         FROM quests  WHERE Language <> 0 AND quests.Complete = '1' AND admin_check = 1", $_SESSION['limitx'].','.$_SESSION['limity'],'admin_check');
+      } 
+      if(array_key_exists('admin_nocheck', $_GET)) {
         echo '<a Title="Zobrazit questy podle vlasního filtru" href="npc_list.php?filter">Filtr questsù</a> ->
-        <a Title="Zatím nezkontrolované questy" href="npc_list.php?nocheck">Nezkontrolované questy</a><br><br>';
+        <a Title="Zatím nezkontrolované questy" href="npc_list.php?admin_nocheck">Nezkontrolované questy</a><br><br>';
 
           WritePages('ListQuests.php?nocheck'," WHERE Language <> 0 AND quests.Complete = '1' AND admin_check <> 1");
 
         WriteQuests("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User
-         FROM quests  WHERE Language <> 0 AND quests.Complete = '1' AND admin_check <> 1", $_SESSION['limitx'].','.$_SESSION['limity'],'nocheck');
-      } 
-
-      if(array_key_exists('check', $_GET)) {
-        echo '<a Title="Zobrazit questy podle vlasního filtru" href="npc_list.php?filter">Filtr questù</a> ->
-        <a Title="Zkontrolované questy" href="npc_list.php?nocheck">Zkontrolované questy</a><br><br>';
-
-          WritePages('ListQuests.php?nocheck'," WHERE Language <> 0 AND quests.Complete = '1' AND admin_check = 1");
-
-        WriteQuests("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User
-         FROM quests  WHERE Language <> 0 AND quests.Complete = '1' AND admin_check = 1", $_SESSION['limitx'].','.$_SESSION['limity'],'check');
-      } 
+         FROM quests  WHERE Language <> 0 AND quests.Complete = '1' AND admin_check <> 1", $_SESSION['limitx'].','.$_SESSION['limity'],'admin_nocheck');
+      } 
+
 
       if(array_key_exists('notvote', $_GET)) {
@@ -261 +287 @@
           <tr><td><a Title="Zatím neznámkované questy" href="ListQuests.php?notvote">Neznámkované questy</a></td>
           <td>Zatím neznámkované questy</td></tr>';
-          if  (Licence(2)) {
             echo '<tr><td><a Title="Nezkontrolované Questy" href="ListQuests.php?nocheck">Nezkontrolované q.</a></td></tr>';
             echo '<tr><td><a Title="Zkontrolované Questy" href="ListQuests.php?check">Zkontrolované q.</a></td></tr>';
-          }
         }