Changeset 20 for page_list.php

Timestamp:

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

Author:

maron

Message:

Vlastní výběr

File:

• page_list.php (modified) (2 diffs)

page_list.php

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