Changeset 20 for ListQuests.php


Ignore:
Timestamp:
Oct 2, 2008, 9:38:57 PM (16 years ago)
Author:
maron
Message:

Vlastní výběr

File:
1 edited

Legend:

Unmodified
Added
Removed
  • ListQuests.php

    r18 r20  
    126126
    127127      if(array_key_exists('nocheck', $_GET)) {
     128        echo '<a Title="Zobrazit questy podle vlasního filtru" href="ListQuests.php?filter">Filtr questsù</a> ->
     129        <a Title="Zatím nezkontrolované questy" href="ListQuests.php?nocheck">Nezkontrolované questy</a><br><br>';
     130
     131          WritePages('ListQuests.php?nocheck'," WHERE Language <> 0 AND quests.Complete = '1'
     132          AND NOT EXISTS(SELECT 1 FROM tag WHERE ID_user = ".$_SESSION['UserID']." AND tag.type_translation = 1 AND tag.ID_translation = quests.ID)");
     133
     134        WriteQuests("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User
     135         FROM quests WHERE Language <> 0 AND quests.Complete = '1'
     136          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');
     137      }
     138
     139      if(array_key_exists('check', $_GET)) {
     140        echo '<a Title="Zobrazit questy podle vlasního filtru" href="ListQuests.php?filter">Filtr questù</a> ->
     141        <a Title="Zkontrolované questy" href="ListQuests.php?nocheck">Zkontrolované questy</a><br><br>';
     142
     143  /*        WritePages('ListQuests.php?nocheck'," WHERE Language <> 0 AND quests.Complete = '1'
     144          AND EXISTS(SELECT 1 FROM tag WHERE ID_user = ".$_SESSION['UserID']." AND
     145           tag.type_translation = 1 AND tag.ID_translation = quests.ID)");
     146*/
     147        WriteQuests("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User
     148         FROM quests WHERE Language <> 0 AND quests.Complete = '1' AND
     149         EXISTS(SELECT 1 FROM tag WHERE ID_user = ".$_SESSION['UserID']." AND
     150         tag.type_translation = 1 AND tag.ID_translation = quests.ID)", $_SESSION['limitx'].','.$_SESSION['limity'],'check');
     151      }
     152
     153      if(array_key_exists('admin_check', $_GET)) {
     154        echo '<a Title="Zobrazit questy podle vlasního filtru" href="npc_list.php?filter">Filtr questù</a> ->
     155        <a Title="Zkontrolované questy" href="npc_list.php?admin_nocheck">Zkontrolované questy</a><br><br>';
     156
     157          WritePages('ListQuests.php?nocheck'," WHERE Language <> 0 AND quests.Complete = '1' AND admin_check = 1");
     158
     159        WriteQuests("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User
     160         FROM quests  WHERE Language <> 0 AND quests.Complete = '1' AND admin_check = 1", $_SESSION['limitx'].','.$_SESSION['limity'],'admin_check');
     161      }
     162      if(array_key_exists('admin_nocheck', $_GET)) {
    128163        echo '<a Title="Zobrazit questy podle vlasního filtru" href="npc_list.php?filter">Filtr questsù</a> ->
    129         <a Title="Zatím nezkontrolované questy" href="npc_list.php?nocheck">Nezkontrolované questy</a><br><br>';
     164        <a Title="Zatím nezkontrolované questy" href="npc_list.php?admin_nocheck">Nezkontrolované questy</a><br><br>';
    130165
    131166          WritePages('ListQuests.php?nocheck'," WHERE Language <> 0 AND quests.Complete = '1' AND admin_check <> 1");
    132167
    133168        WriteQuests("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User
    134          FROM quests  WHERE Language <> 0 AND quests.Complete = '1' AND admin_check <> 1", $_SESSION['limitx'].','.$_SESSION['limity'],'nocheck');
    135       }
    136 
    137       if(array_key_exists('check', $_GET)) {
    138         echo '<a Title="Zobrazit questy podle vlasního filtru" href="npc_list.php?filter">Filtr questù</a> ->
    139         <a Title="Zkontrolované questy" href="npc_list.php?nocheck">Zkontrolované questy</a><br><br>';
    140 
    141           WritePages('ListQuests.php?nocheck'," WHERE Language <> 0 AND quests.Complete = '1' AND admin_check = 1");
    142 
    143         WriteQuests("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User
    144          FROM quests  WHERE Language <> 0 AND quests.Complete = '1' AND admin_check = 1", $_SESSION['limitx'].','.$_SESSION['limity'],'check');
    145       }
     169         FROM quests  WHERE Language <> 0 AND quests.Complete = '1' AND admin_check <> 1", $_SESSION['limitx'].','.$_SESSION['limity'],'admin_nocheck');
     170      }
     171
    146172
    147173      if(array_key_exists('notvote', $_GET)) {
     
    261287          <tr><td><a Title="Zatím neznámkované questy" href="ListQuests.php?notvote">Neznámkované questy</a></td>
    262288          <td>Zatím neznámkované questy</td></tr>';
    263           if  (Licence(2)) {
    264289            echo '<tr><td><a Title="Nezkontrolované Questy" href="ListQuests.php?nocheck">Nezkontrolované q.</a></td></tr>';
    265290            echo '<tr><td><a Title="Zkontrolované Questy" href="ListQuests.php?check">Zkontrolované q.</a></td></tr>';
    266           }
    267291        }
    268292       
Note: See TracChangeset for help on using the changeset viewer.