Changeset 20 for npc_list.php

Timestamp:

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

Author:

maron

Message:

Vlastní výběr

File:

• npc_list.php (modified) (2 diffs)

npc_list.php

@@ -105 +105 @@
       
       if(array_key_exists('nocheck', $_GET)) {
-        echo '<a Title="Zobrazit npc_texty podle vlasního filtru" href="npc_list.php?filter">Filtr npc_textù</a> ->
+        echo '<a Title="Zobrazit npc_texty podle vlasního filtru" href="npc_list.php?filter">Filtr npc_textsù</a> ->
         <a Title="Zatím nezkontrolované npc_texty" href="npc_list.php?nocheck">Nezkontrolované npc_texty</a><br><br>';
 
-          WritePages('npc_list.php?nocheck'," WHERE Language <> 0 AND npc_text.Complete = '1' AND admin_check <> 1");
+          WritePages('npc_list.php?nocheck'," WHERE Language <> 0 AND npc_text.Complete = '1'
+          AND NOT EXISTS(SELECT 1 FROM tag WHERE ID_user = ".$_SESSION['UserID']." AND tag.type_translation = 2 AND tag.ID_translation = npc_text.ID)");
 
         Write_npc_text("SELECT *, (SELECT user.user FROM user WHERE user.id = npc_text.user) as User
-         FROM npc_text  WHERE Language <> 0 AND npc_text.Complete = '1' AND admin_check <> 1", $_SESSION['limitx'].','.$_SESSION['limity'],'nocheck');
+         FROM npc_text WHERE Language <> 0 AND npc_text.Complete = '1' 
+          AND NOT EXISTS(SELECT 1 FROM tag WHERE ID_user = ".$_SESSION['UserID']." AND tag.type_translation = 2 AND tag.ID_translation = npc_text.ID)", $_SESSION['limitx'].','.$_SESSION['limity'],'nocheck');
       } 
 
@@ -118 +120 @@
         <a Title="Zkontrolované npc_texty" href="npc_list.php?nocheck">Zkontrolované npc_texty</a><br><br>';
 
-          WritePages('npc_list.php?nocheck'," WHERE Language <> 0 AND npc_text.Complete = '1' AND admin_check = 1");
-
+  /*        Writenpcs('npc_list.php?nocheck'," WHERE Language <> 0 AND npc_text.Complete = '1'
+          AND EXISTS(SELECT 1 FROM tag WHERE ID_user = ".$_SESSION['UserID']." AND
+           tag.type_translation = 2 AND tag.ID_translation = npc_text.ID)");
+*/
         Write_npc_text("SELECT *, (SELECT user.user FROM user WHERE user.id = npc_text.user) as User
-         FROM npc_text  WHERE Language <> 0 AND npc_text.Complete = '1' AND admin_check = 1", $_SESSION['limitx'].','.$_SESSION['limity'],'check');
+         FROM npc_text WHERE Language <> 0 AND npc_text.Complete = '1' AND 
+         EXISTS(SELECT 1 FROM tag WHERE ID_user = ".$_SESSION['UserID']." AND 
+         tag.type_translation = 2 AND tag.ID_translation = npc_text.ID)", $_SESSION['limitx'].','.$_SESSION['limity'],'check');
       } 
+
       if(array_key_exists('notvote', $_GET)) {
         echo '<a Title="Zobrazit npc_texty podle vlasního filtru" href="npc_list.php?filter">Filtr npc_textù</a> ->