Changeset 208

Timestamp:

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

Author:

maron

Message:

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

Location:

quests

Files:

• action.php (modified) (1 diff)
• form.php (modified) (2 diffs)
• includes/global.php (modified) (3 diffs)
• save.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();      
 ?>

quests/form.php

@@ -39 +39 @@
         <input type="text" name="vote" value="4" size="2">
         <input type="hidden" name="ID" value="'.$QuestID.'">
-        <input type="submit" value="Hlasovat">
+        <input type="submit" value="Hlasovat" Title="Hlasovat libovalný poèet hlasù (jenom pro GM)">
         ';  
         
         echo '<input type="hidden" name="UserRepair" value="'.$Line['User'].'">';
-        echo '<a style="color: Red" title="smazat" href="action.php?delete=1&amp;ID='.$QuestID.'">x</a>  
-        <a style="color: Red" title="Není hotovo" href="action.php?NotComplete=1&amp;ID='.$QuestID.'"><-</a> 
+        echo '<a style="color: Red" title="smazat (jenom pro GM)" href="action.php?delete=1&amp;ID='.$QuestID.'">x</a>  
+        <a style="color: Red" title="Není hotovo (jenom pro GM)" href="action.php?NotComplete=1&amp;ID='.$QuestID.'"><-</a> 
         
         ';  
@@ -54 +54 @@
     <input type="submit" value="Ulo¾it do rozepsaných" name="save" Title="Kliknìte na ulo¾it pro pozdìj¹í dokonèení Q">
     <input type="submit" value="Dokonèeno" name="End" Title="Kliknìte na Dokonèeno jesli jsou v¹echny texty hotové a chcete ji¾ publikovat">
+<?php
+  if (Licence(1)) {
+    echo '<input type="submit" value="Opravit" name="Repair" Title="Opravit po u¾ivateli chyby (jenom pro GM)">';  
+  }
+?>
     $B - Odøádkování, $N - Jméno, $C - povolání
     <input type="hidden" name="entry" value="<?php echo $LineAJ['entry']?>">

quests/includes/global.php

@@ -101 +101 @@
       <a href="http://wow.zdechov.net/forum/viewforum.php?f=22">Forum projektu</a><br />
       <a href="http://wow.zdechov.net/">Web serveru</a><br /><br />
+      
+<form action="action.php" method="get">
+<input type="text" name="search" size="13"><br>
+<input type="submit" value="Hledat">
+</form>
       ';
       
@@ -111 +116 @@
   <table>
     <tr>
-      <td><input type="text" name="LoginUser"></td>
+      <td><input type="text" name="LoginUser" size="13"></td>
     </tr>
     <tr>
-      <td><input type="password" name="LoginPass"></td>
+      <td><input type="password" name="LoginPass" size="13"></td>
     </tr>
     <tr>
@@ -146 +151 @@
 
 ?>
-

quests/save.php

@@ -24 +24 @@
     else 
       $complete = 0;
+    
+    $Line = mysql_fetch_array($Database->SQLCommand("SELECT user FROM quests Where ID = '$QuestID'"));
+    if (array_key_exists('Repair', $_POST)) 
+      $UserID = $Line['user'];