Changeset 208 for quests/action.php

Timestamp:

Jan 11, 2008, 10:12:28 PM (17 years ago)

Author:

maron

Message:

Vyhledávání, oprava Q pro moderátory

File:

• quests/action.php (modified) (1 diff)

quests/action.php

@@ -37 +37 @@
     } else echo 'Ji¾ jste hlasoval!';
   }
-          
+
+  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();      
 ?>