Changeset 249 for quests/ListQuests.php

Timestamp:

Jan 19, 2008, 10:51:11 PM (17 years ago)

Author:

maron

Message:

Ve vyhledávání pouze uživatelé, kteří mají questy, vyhledávání podle ID questu

File:

• quests/ListQuests.php (modified) (5 diffs)

quests/ListQuests.php

@@ -150 +150 @@
       }
       
+      
+      if(array_key_exists('users', $_GET)) {
+        echo '<a Title="Zobrazit questy podle vlasního filtru" href="ListQuests.php?filter">Filtr questù</a> ->
+        <b>Vypsání questù od urèitých u¾ivatelù</b><br><br>';
+        $users = @$_POST['users'];
+  
+        $WhereUsers = '';
+    
+        for ($i=0; $i<Count($users); $i++):
+          if ($WhereUsers <> '')
+           $WhereUsers .= " OR User = ".$users[$i];
+          else
+            $WhereUsers .= " User = ".$users[$i];
+        endfor;    
+        WriteQuests("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User FROM quests Where $WhereUsers", '', 'users');
+  
+      }
+
+      if(array_key_exists('byvote', $_GET)) {
+        echo '<a Title="Zobrazit questy podle vlasního filtru" href="ListQuests.php?filter">Filtr questù</a> ->
+        <b>Vypsání podle známky</b><br><br>';
+        
+        $SingVote = $_POST['SingVote'];
+        $SingNumberVote = $_POST['SingNumberVote'];
+        $Vote = $_POST['Vote'];
+        $NumberVote = $_POST['NumberVote'];
+        
+        WriteQuests("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User 
+        FROM quests WHERE Vote $SingVote $Vote AND CountVote $SingNumberVote $NumberVote", '', 'users');
+  
+      }
+      
+  if (array_key_exists('search', $_GET)) {
+    $Search = $_GET['search'];
+  
+    $sql = "SELECT * FROM `quests`.`quests` WHERE `ID` LIKE '%$Search%'
+    OR `entry` LIKE '%$Search%'
+    OR `Title` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
+    OR `Details` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
+    OR `Objectives` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
+    OR `OfferRewardText` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
+    OR `RequestItemsText` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
+    OR `EndText` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
+    OR `ObjectiveText1` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
+    OR `ObjectiveText2` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
+    OR `ObjectiveText3` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
+    OR `ObjectiveText4` LIKE CONVERT( _utf8 '%$Search%' USING latin2 ) COLLATE latin2_czech_cs
+    OR `Language` LIKE '%$Search%'
+    OR `Vote` LIKE '%$Search%'
+    OR `User` LIKE '%$Search%'
+    OR `complete` LIKE '%$Search%'";
+    
+    WriteQuests($sql, '', 'search='.$Search);
+  }        
+      
+  if (array_key_exists('searchentry', $_GET)) {
+    $Search = $_GET['searchentry'];
+  
+    $sql = "SELECT * FROM `quests`.`quests` WHERE `entry` LIKE '$Search'";
+    
+    WriteQuests($sql, '', 'searchentry='.$Search);
+  }        
+      
       if(array_key_exists('filter', $_GET)) {
         echo '<a Title="Zobrazit questy podle vlasního filtru" href="ListQuests.php?filter">Filtr questù</a><br><br><br>';
@@ -171 +234 @@
           &nbsp;<select name="users[]" size="10" multiple>';
          
-          $ID = $Database->SQLCommand("SELECT user,ID FROM `user`");
+          $ID = $Database->SQLCommand("SELECT user,ID FROM `user` WHERE
+          EXISTS(SELECT 1 FROM quests WHERE user = user.ID) ORDER BY user");
           while ($Line = mysql_fetch_array($ID))
             echo '<option value="'.$Line['ID'].'">'.$Line['user'].'</option>';
@@ -195 +259 @@
           </td><td>Zobrazit podle známky</td></tr>';
           
-          echo '<tr><td><form action="action.php" method="get">
+          echo '<tr><td><form action="ListQuests.php" method="get">
           <input type="text" name="search" size="8">
           <input type="submit" value="Hledat">
@@ -201 +265 @@
           </td><td>Vyhledat pomocí textu</td></tr>
           ';
+          
+          echo '<tr><td><form action="ListQuests.php" method="get">
+          <input type="text" name="searchentry" size="8">
+          <input type="submit" value="Hledat">
+          </form>
+          </td><td>Zobrazit podle ID questu v mangosu</td></tr>
+          ';
                                                                             
 
@@ -208 +279 @@
       }
       
-      if(array_key_exists('users', $_GET)) {
-        echo '<a Title="Zobrazit questy podle vlasního filtru" href="ListQuests.php?filter">Filtr questù</a> ->
-        <b>Vypsání questù od urèitých u¾ivatelù</b><br><br>';
-        $users = @$_POST['users'];
-  
-        $WhereUsers = '';
-    
-        for ($i=0; $i<Count($users); $i++):
-          if ($WhereUsers <> '')
-           $WhereUsers .= " OR User = ".$users[$i];
-          else
-            $WhereUsers .= " User = ".$users[$i];
-        endfor;    
-        WriteQuests("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User FROM quests Where $WhereUsers", '', 'users');
-  
-      }
-
-      if(array_key_exists('byvote', $_GET)) {
-        echo '<a Title="Zobrazit questy podle vlasního filtru" href="ListQuests.php?filter">Filtr questù</a> ->
-        <b>Vypsání podle známky</b><br><br>';
-        
-        $SingVote = $_POST['SingVote'];
-        $SingNumberVote = $_POST['SingNumberVote'];
-        $Vote = $_POST['Vote'];
-        $NumberVote = $_POST['NumberVote'];
-        
-        WriteQuests("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User 
-        FROM quests WHERE Vote $SingVote $Vote AND CountVote $SingNumberVote $NumberVote", '', 'users');
-  
-      }
 
   ShowFooter();