Changeset 251 for quests/export.php

Timestamp:

Jan 20, 2008, 8:44:37 PM (17 years ago)

Author:

maron

Message:

NPC_text

File:

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

quests/export.php

@@ -23 +23 @@
     $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(2) == False)) {die('Nemáte oprávnìní');}
-    
-    
-    $Buffer = '
+
+    $BufferHeader = '
 /*  File made by maron web aplikacion 
     =================================
@@ -44 +30 @@
     WebProject: http://wow.zdechov.net/quests/
     email: maron2@cetrum.cz 
-    DateExport: '.date("m.d.y  H:i").'   */
+    DateExport: '.date("m.d.y  H:i").'
+    Diakritika: '.$Diacritical.'
+    Poèet nutných hlasù: '.$NumberVote.'
+    Známka vy¾¹í jak: '.$Vote.'
+    Tabluky: Quests: '.@$_POST['Quests'].' , NPC_text: '.@$_POST['NPC_texts'].'   */
     
     ';
     
-    if (isset($Use)) $Buffer .= 'USE `mangos`;
+    if (isset($Use)) $BufferHeader .= 'USE `mangos`;
     
     ';
 
-    $sql = "SELECT * FROM quests.quests WHERE Complete = '1' AND CountVote >= '$NumberVote' AND Vote >= '$Vote'";
+
     $WhereLang = '';
     if (isset($CZ)) $WhereLang .= " Language = '1'";
@@ -76 +66 @@
         $WhereUsers .= " User = ".$users[$i];
     endfor;    
+
+    
+    if (array_key_exists('Quests', $_POST)) {
+      $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(2) == False)) {die('Nemáte oprávnìní');}
+    
+    
+    $sql = "SELECT * FROM quests.quests WHERE Complete = '1' AND CountVote >= '$NumberVote' AND Vote >= '$Vote'";
     
     if ($WhereLang <> '') $sql .= " AND ($WhereLang)";
@@ -82 +89 @@
    // echo $sql;
 
-
+    $i = 0;
     $ID = $Database->SQLCommand($sql." ORDER BY vote");
     while ($Line = mysql_fetch_array($ID)) {
@@ -127 +134 @@
     if ($Diacritical == False) $sql=WithOutDiacritical($sql);
     
-    if ($Export == 'Mangos') {     
-      $Database->SelectDatabase($Config['Database']['DatabaseMangos']);    
-      $Database->SQLCommand($sql);
-    }  
-    $Buffer .= $sql." 
-    ";
-    
+    $Buffer[$i] = $sql;
+    ++$i;
+    
+  }
   }  
   
+  //export npc_textù
+  $x = 0;
+  if (array_key_exists('NPC_texts', $_POST)) {
+    
+    $sql = "SELECT * FROM NPC_text WHERE Complete = '1' AND CountVote >= '$NumberVote' AND Vote >= '$Vote'";
+    
+    if ($WhereLang <> '') $sql .= " AND ($WhereLang)";
+    if ($WhereUsers <> '') $sql .=  "AND ($WhereUsers)";
+
+    $ID = $Database->SQLCommand($sql." ORDER BY vote");
+    while ($Line = mysql_fetch_array($ID)) {
+    
+      $sql = "UPDATE npc_text SET ";
+      for ($i=0; $i<count($npc_text); ++$i) {
+        if ($Line[$npc_text[$i]] <> '')
+          $sql .= " ".$npc_text[$i]." = '".$Line[$npc_text[$i]]."' , ";
+      }
+      $sql .= " ID = '".$Line['entry']."' WHERE ID = ".$Line['entry'];
+      if ($Diacritical == False) $sql=WithOutDiacritical($sql);
+      
+    $BufferNPC[$x] = $sql;
+    ++$x;
+    }
+  }  
+  
+  //vypisování
   if ($Export == 'Display') {
     echo 'Vygenerovaný SQL kód: <br /><textarea rows="30" cols="100">';
-    echo $Buffer;
+      echo $BufferHeader;
+      for ($i=0; $i<count(@$Buffer); ++$i) {
+        echo $Buffer[$i].'
+        ';
+      }
+      for ($i=0; $i<count(@$BufferNPC); ++$i) {
+        echo $BufferNPC[$i].'
+        ';
+      }
     echo '</textarea>';
   }
-  if ($Export == 'Mangos') {
-    echo 'Hotovo';
-  }
+
+  if ($Export == 'Mangos') {     
+    $Database->SelectDatabase($Config['Database']['DatabaseMangos']);    
+      for ($i=0; $i<count(@$Buffer); ++$i) {
+        $Database->SQLCommand($Buffer[$i]);
+      }
+      for ($i=0; $i<count(@$BufferNPC); ++$i) {
+        $Database->SQLCommand($BufferNPC[$i]);
+      }
+  }  
   
   if ($Export == 'Zip') {
@@ -149 +194 @@
         $save_filename = 'SqlTranslate.zip';
         $SQL_filename = 'SqlTranslate.sql';
-          
+        
+        $BufferZip = $BufferHeader;
+        for ($i=0; $i<count(@$Buffer); ++$i) {
+          $BufferZip .= $Buffer[$i];
+        }
+        for ($i=0; $i<count(@$BufferNPC); ++$i) {
+          $BufferZip .= $BufferNPC[$i];
+        }
+
+        $Buffer  = $BufferZip;
+        
         $zipfile = new zipfile();
         $zipfile -> addFile($Buffer, $SQL_filename);
@@ -188 +243 @@
         <input type="checkbox" name="Use" checked="true"> Pøidat Use mangos <br> 
         <br /> 
+        <input type="checkbox" name="Quests" checked="true"> Questy <br> 
+        <input type="checkbox" name="NPC_texts" checked="true"> NPC_texts <br> 
       </td><td>
         &nbsp; <input type="text" name="NumberVote" value="3" size="1"> Poèet nutných hlasù <br>                                                               
@@ -197 +254 @@
 // multiple="multiple"
     $ID = $Database->SQLCommand("SELECT user,ID FROM `user` WHERE
-          EXISTS(SELECT 1 FROM quests WHERE user = user.ID) ORDER BY user");
+          EXISTS(SELECT 1 FROM quests WHERE user = user.ID) OR 
+          EXISTS(SELECT 1 FROM npc_text WHERE user = user.ID) ORDER BY user");
       while ($Line = mysql_fetch_array($ID))
         echo '<option value="'.$Line['ID'].'">'.$Line['user'].'</option>';
@@ -225 +283 @@
       </td></tr>
     </table>
-    <br><input type="submit" value="Generovat SQL soubor Questù"> (Sta¾ení)
+    <br><input type="submit" value="Generovat SQL soubor pøekladu"> (Sta¾ení)
   </form>  
   <b>Èeský pøeklad MaNGOS Minimanageru:</b><br />