Changeset 281 for quests/export.php

Timestamp:

Jan 27, 2008, 6:07:07 PM (17 years ago)

Author:

maron

Message:

export page_text

File:

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

quests/export.php

@@ -1 +1 @@
 <?php
-
-  include('includes/global.php');
-
-  include 'includes/zip.lib.php';
 
         function WithOutDiacritical($teststring){
@@ -11 +7 @@
         }
 
-  if (array_key_exists('Type', $_POST)) {
     $Diacritical = @$_POST['Diacritical'];
     if (array_key_exists('CZ', $_POST)) $CZ = $_POST['CZ'];    
@@ -35 +30 @@
     Poèet nutných hlasù: '.$NumberVote.'
     Známka vy¾¹í jak: '.$Vote.'
-    Tabluky: Quests: '.@$_POST['Quests'].' , NPC_text: '.@$_POST['NPC_texts'].'   */
+    Tabluky: 
+      Quests: '.@$_POST['Quests'].'
+      NPC_text: '.@$_POST['NPC_texts'].'
+      page_text: '.@$_POST['page_texts'].'   */
     
     ';
@@ -166 +164 @@
     }
   }  
+
+  //export page_textù
+  $x = 0;
+  if (array_key_exists('page_texts', $_POST)) {
+    
+    $sql = "SELECT * FROM page_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 page_text SET ";
+      for ($i=0; $i<count($page_text); ++$i) {
+        if ($Line[$page_text[$i]] <> '')
+          $sql .= " ".$page_text[$i]." = '".mysql_escape_string($Line[$page_text[$i]])."' , ";
+      }
+      $sql .= " ID = '".$Line['entry']."' WHERE ID = ".$Line['entry'].";";
+      
+      if ($Diacritical == False) $sql=WithOutDiacritical($sql);
+      
+    $Bufferpage[$x] = $sql;
+    ++$x;
+    }
+  }  
   
   //vypisování
@@ -179 +203 @@
         ';
       }
+      for ($i=0; $i<count(@$Bufferpage); ++$i) {
+        echo $Bufferpage[$i].'
+        ';
+      }
     echo '</textarea>';
   }
@@ -189 +217 @@
       for ($i=0; $i<count(@$BufferNPC); ++$i) {
         $Database->SQLCommand($BufferNPC[$i]);
+      }
+      for ($i=0; $i<count(@$Bufferpage); ++$i) {
+        $Database->SQLCommand($Bufferpage[$i]);
       }
       echo 'Hotovo!';
@@ -207 +238 @@
           ';
         }
+        for ($i=0; $i<count(@$Bufferpage); ++$i) {
+          $BufferZip .= $Bufferpage[$i].'
+          ';
+        }
 
    //     echo $BufferZip.'<br><br><br>';
@@ -225 +260 @@
         <script type="text/javascript" language="JavaScript" charset="iso-8859-2">
             setTimeout("parent.location.href=\''.$save_filename.'\'",1000)
-        </script>
-      
+        </script>';
+      
+      echo '
       Pokud nezaèalo stahování soubor by mìlo jít stáhnout z tohoto odkazu: 
       <a href="'.$save_filename.'">'.$save_filename.'</a><br />
@@ -234 +270 @@
       WriteLog('Sta¾ení SQL souboru: Typ Exportu: <b>'.$Export.'</b> Diakritika: <b>'.$Diacritical.'</b>
        Poèet nutných hlasù: <b>'.$NumberVote.'</b> Známka vy¾¹í jak: <b>'.$Vote.'</b>', 2);
-    
-    
-} else {
+      
 ?>
-<div style="    border: 2px dotted black;       padding: 0px 5px 5px 5px;">
-  <big><b><i>Pro server:</i></b></big><br>
-  <b>Export Pøekladu:</b><br />
-  <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>
-        <input type="radio" name="Export" value="Display"> Export zobrazit<br>
-<?php
-      if (Licence(2)) {
-          echo '<input type="radio" name="Export" value="Mangos"> Import na server (Admin only)<br>';
-      }
-?>
-        <br />
-        <input type="radio" name="Type" value="Insert"> Insert (zatím nefunguje)<br>
-        <input type="radio" name="Type" value="Update" checked="true"> Update <br>
-        <br />
-        <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>                                                               
-        &nbsp; <input type="text" name="Vote" value="4" size="1"> Známka lep¹í nebo stejná jak  <br>                                                             
-            <br />
-        &nbsp; <select name="users[]" size="10" multiple>
-         
-<?php
-// multiple="multiple"
-    $ID = $Database->SQLCommand("SELECT user,ID FROM `user` WHERE
-          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>';
-   
-?>          
-          
-        </select><br> &nbsp; Exportovat pouze od tìchto u¾ivatalù<br>
-        &nbsp; Vybrat více u¾ivatelù mù¾ete pomocí CTRL+click
-        
-
-      </td><td>
-        <input type="checkbox" name="Diacritical" checked="true"> Vèetnì diakritiky <br>  
-        <br />                                                               
-        <input type="checkbox" name="CZ" checked="true"> Èeský pøeklad <br>                                                                 
-        <input type="checkbox" name="SK" checked="true"> Slovenský pøeklad <br>                                                                 
-        <input type="checkbox" name="OtherLanguage"> Jiné jazyky <br>
-      </td><td>
-        <b>Title questu:</b><br>
-        <input type="radio" name="AddTitle" value="Translate" checked="true"> Pøelo¾ený název <br>
-        <input type="radio" name="AddTitle" value="EN"> Pùvodní název <br>
-        <input type="radio" name="AddTitle" value="Both"> Pøelo¾ený název (Anglický název) <br>
-    <br>                                                                 
-<?php    
-  foreach($Texts as $Index => $TextItem)
-    echo '<input type="checkbox" name="Add'.$TextItem[0].'" checked="true"> '.$TextItem[0].'<br>';
-?>
-      </td></tr>
-    </table>
-    <br><input type="submit" value="Generovat SQL soubor pøekladu  (Sta¾ení)"> 
-  </form>  
-  <b>Èeský pøeklad MaNGOS Minimanageru:</b><br />
-  - Stránky projektu: <a href="http://sourceforge.net/projects/mmfpm/">http://sourceforge.net/projects/mmfpm/</a><br>
-  - Pøeklad: <a href="http://wow.zdechov.net/minimanager/lang/csCZ.zip">Èe¹tina do minimanageru</a><br>
-  - Diskusní forum pro pøípadné pøipomínky k pøekladu: <a href="http://wow.zdechov.net/forum/viewtopic.php?p=5533">Forum</a>
-
-</div>
-<br>
-<div style="    border: 2px dotted black;       padding: 0px 5px 5px 5px;">
-  <big><b><i>Pro klinta:</i></b></big><br>
-  <b>Diakritika ve høe</b><br />
-   - Pro správné zobrazování diakrity ve høe si stáhnìte <a href="http://wow.zdechov.net/download_soubory/ceske_fonty_do_wow.zip">Èeské fonty do hry</a><br />
-   <br />
-  <b>Zvukové hlá¹ky ve høe</b><br />
-   - zvukové soubory pøevzaté z èeské verze Warcraftu III <a href="http://www.wowresource.eu/index.php?showtopic=4260&amp;hl=hl%C3%A1%C5%A1ky" title="http://www.wowresource.eu/index.php?showtopic=4260&amp;hl=hl%C3%A1%C5%A1ky">Èeské hlá¹ky z Warcraftu III</a>
-</div> 
-<?php
-}
-  
-          
-  ShowFooter();      
-?>