Changeset 249 for quests/action.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/action.php (modified) (1 diff)

quests/action.php

@@ -65 +65 @@
   }
 
-  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%'";
-
-  
-        echo '<table border="1" cellpadding="2" cellspacing="0">
-              <tr><th>Poøadové èíslo</th><th>ID questu</th><th>Název Questu</th><th>Poèet hlasù</th></tr>';
-        $ID = $Database->SQLCommand($sql);
-          while ($Line = mysql_fetch_array($ID)) {
-            echo '<tr><td><a href="form.php?ID='.$Line['ID'].'">'.$Line['ID'].'</a></td>
-            <td>'.$Line['entry'].'</td>
-            <td>'.$Line['Title'].'</td>
-            <td>'.$Line['Vote'].'</td></tr>';
-          }
-        echo '</table>';  
-  
-  
-  
-  }        
   ShowFooter();      
 ?>