Changeset 241 for quests/export.php

Timestamp:

Jan 17, 2008, 3:43:46 PM (17 years ago)

Author:

maron

Message:

Export pouze od určitých uživatelů

File:

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

quests/export.php

@@ -11 +11 @@
         }
 
-  if (array_key_exists('Type', $_GET)) {
-    $Diacritical = @$_GET['Diacritical'];
-    if (array_key_exists('CZ', $_GET)) $CZ = $_GET['CZ'];    
-    if (array_key_exists('SK', $_GET)) $SK = $_GET['SK'];    
-    if (array_key_exists('OtherLanguage', $_GET)) $OtherLanguage = $_GET['OtherLanguage'];
-    if (array_key_exists('Use', $_GET)) $Use = $_GET['Use'];
-    $Type = $_GET['Type'];
-    $Export = $_GET['Export'];
-    $AddTitle = $_GET['AddTitle'];
-    $NumberVote = $_GET['NumberVote'];
-    $Vote = $_GET['Vote'];
-
-      $AddDetails = @$_GET['AddDetails'];
-      $AddObjectives = @$_GET['AddObjectives'];
-      $AddOfferRewardText = @$_GET['AddOfferRewardText'];
-      $AddRequestItemsText = @$_GET['AddRequestItemsText'];
-      $AddEndText = @$_GET['AddEndText'];
-      $AddObjectiveText1 = @$_GET['AddObjectiveText1']; 
-      $AddObjectiveText2 = @$_GET['AddObjectiveText2']; 
-      $AddObjectiveText3 = @$_GET['AddObjectiveText3']; 
-      $AddObjectiveText4 = @$_GET['AddObjectiveText4']; 
+  if (array_key_exists('Type', $_POST)) {
+    $Diacritical = @$_POST['Diacritical'];
+    if (array_key_exists('CZ', $_POST)) $CZ = $_POST['CZ'];    
+    if (array_key_exists('SK', $_POST)) $SK = $_POST['SK'];    
+    if (array_key_exists('OtherLanguage', $_POST)) $OtherLanguage = $_POST['OtherLanguage'];
+    if (array_key_exists('Use', $_POST)) $Use = $_POST['Use'];
+    $Type = $_POST['Type'];
+    $Export = $_POST['Export'];
+    $AddTitle = $_POST['AddTitle'];
+    $NumberVote = $_POST['NumberVote'];
+    $Vote = $_POST['Vote'];
+    $users = @$_POST['users'];
+    
+
+      $AddDetails = @$_POST['AddDetails'];
+      $AddObjectives = @$_POST['AddObjectives'];
+      $AddOfferRewardText = @$_POST['AddOfferRewardText'];
+      $AddRequestItemsText = @$_POST['AddRequestItemsText'];
+      $AddEndText = @$_POST['AddEndText'];
+      $AddObjectiveText1 = @$_POST['AddObjectiveText1'];        
+      $AddObjectiveText2 = @$_POST['AddObjectiveText2'];        
+      $AddObjectiveText3 = @$_POST['AddObjectiveText3'];        
+      $AddObjectiveText4 = @$_POST['AddObjectiveText4'];        
 
       if (($Export == 'Mangos') and (Licence(1) == False)) {die('Nemáte oprávnìní');}
@@ -51 +53 @@
 
     $sql = "SELECT * FROM quests.quests WHERE Complete = '1' AND CountVote >= '$NumberVote' AND Vote >= '$Vote'";
-    $Where = '';
-    if (isset($CZ)) $Where .= " Language = '1'";
+    $WhereLang = '';
+    if (isset($CZ)) $WhereLang .= " Language = '1'";
     if (isset($SK)) {
-      if ($Where <> '')
-        $Where .= " OR Language = '2'";
+      if ($WhereLang <> '')
+        $WhereLang .= " OR Language = '2'";
       else
-        $Where .= "Language = '2'";
+        $WhereLang .= "Language = '2'";
     }
     if (isset($OtherLanguage)) {
-      if ($Where <> '')
-        $Where .= " OR Language = '3'";
+      if ($WhereLang <> '')
+        $WhereLang .= " OR Language = '3'";
       else
-        $Where .= "Language = '3'";
+        $WhereLang .= "Language = '3'";
     }
-    if ($Where <> "")  $sql .= " AND ($Where)";
+    
+    $WhereUsers = '';
+    
+    for ($i=0; $i<Count($users); $i++):
+      if ($WhereUsers <> '')
+        $WhereUsers .= " OR User = ".$users[$i];
+      else
+        $WhereUsers .= " User = ".$users[$i];
+    endfor;    
+    
+    if ($WhereLang <> '') $sql .= " AND ($WhereLang)";
+    if ($WhereUsers <> '') $sql .=  "AND ($WhereUsers)";
+
+    echo $sql;
+
 
     $ID = $Database->SQLCommand($sql." ORDER BY vote");
@@ -154 +170 @@
   <big><b><i>Pro server:</b></i></big><br>
   <b>Export Questù:</b><br />
-  <form action="export.php" method="get">
-    <table border="1">
-      <tr><th>Sql</th><th>Jazyk</th><th>Texty</th></tr>
+  <form action="export.php" method="POST">
+    <table border="1" cellpadding="1" cellspacing="0">
+      <tr><th>Sql</th><th>Filtr</th><th>Jazyk</th><th>Texty</th></tr>
       <tr><td>
         <input type="radio" name="Export" value="Zip" checked="true"> Exportovat do zip<br>
@@ -171 +187 @@
         <input type="checkbox" name="Use" checked="true"> Pøidat Use mangos <br> 
         <br /> 
-        <b>Filtr:</b><br />
-        <input type="text" name="NumberVote" value="3" size="1"> Poèet nutných hlasù <br>                                                               
-        <input type="text" name="Vote" value="4" size="1"> Známka lep¹í nebo stejná jak                                                               
+      </td><td>
+        &nbsp;<input type="text" name="NumberVote" value="3" size="1"> Poèet nutných hlasù <br>                                                               
+        &nbsp;<input type="text" name="Vote" value="4" size="1"> Známka lep¹í nebo stejná jak  <br>                                                             
+
+        &nbsp;<select name="users[]" size="7" multiple>
+         
+<?php
+// multiple="multiple"
+    $ID = $Database->SQLCommand("SELECT user,ID FROM `user`");
+      while ($Line = mysql_fetch_array($ID))
+        echo '<option value="'.$Line['ID'].'">'.$Line['user'].'</option>';
+   
+?>                
+          
+        </select><br>&nbsp; Exportovat pouze od tìchto u¾ivatalù
+        
+
       </td><td>
         <input type="checkbox" name="Diacritical" checked="true"> Vèetnì diakritiky <br>  
@@ -192 +222 @@
       </td></tr>
     </table>
-    <br><input type="submit" value="Generovat"> SQL soubor (Sta¾ení)
+    <br><input type="submit" value="Generovat"> SQL soubor Questù (Sta¾ení)
   </form>  
   <b>Èeský pøeklad MaNGOS Minimanageru:</b><br />