Changeset 212

Timestamp:

Jan 12, 2008, 1:45:45 AM (17 years ago)

Author:

maron

Message:

Export questů do zip

Location:

quests

Files:

• SqlTranslate.zip (added)
• action.php (modified) (1 diff)
• export.php (modified) (6 diffs)
• includes/zip.lib.php (added)

quests/action.php

@@ -21 +21 @@
     
     if (($vote > 5) OR ($vote < 1)) die ('Spadná známka');
-
-  //  if (Licence(0)) die('Hlasovat mùžou jenom registrovaní!');
+    
+  //TODO:  if (Licence(0)) die('Hlasovat mùžou jenom registrovaní!');
 
 

quests/export.php

@@ -2 +2 @@
 
   include('includes/global.php');
+
+  include 'includes/zip.lib.php';
 
         function WithOutDiacritical($teststring){
@@ -16 +18 @@
     if (array_key_exists('Use', $_GET)) $Use = $_GET['Use'];
     $Type = $_GET['Type'];
+    $Export = $_GET['Export'];
     $AddTitle = $_GET['AddTitle'];
     $NumberVote = $_GET['NumberVote'];
@@ -31 +34 @@
 
     
-    echo '<textarea rows="30" cols="100">';
-    echo '
+    $Buffer = '
 /*  File made by maron web aplikacion 
     =================================
@@ -42 +44 @@
     ';
     
-    if (isset($Use)) echo 'USE `mangos`;
+    if (isset($Use)) $Buffer .= 'USE `mangos`;
     
     ';
@@ -106 +108 @@
     $sql = "UPDATE quest_template SET $Details $Objectives $OfferRewardText $RequestItemsText $Title WHERE entry = '$entry';"; 
     if ($Diacritical == False) $sql=WithOutDiacritical($sql);
-    echo $sql." 
+    
+    $Buffer .= $sql." 
     ";
+
   }  
-  echo '</textarea>';
+  
+  if ($Export == 'Display') {
+    echo '<textarea rows="30" cols="100">';
+    echo $Buffer;
+    echo '</textarea>';
+  }
+  
+  if ($Export == 'Zip') {
+      if (@function_exists('gzcompress')) {
+        $save_filename = 'SqlTranslate.zip';
+        $SQL_filename = 'SqlTranslate.sql';
+          
+        $zipfile = new zipfile();
+        $zipfile -> addFile($Buffer, $SQL_filename);
+        $Buffer = $zipfile -> file();
+
+        $file_handle = @fopen($save_filename, 'w');
+        $write_result = @fwrite($file_handle, $Buffer);
+        fclose($file_handle);
+        header("Location: ".$save_filename);
+
+      }
+  }
+    
+    
 } else {
 ?>
@@ -116 +144 @@
       <tr><th>Sql</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>
+        <br />
         <input type="radio" name="Type" value="Insert"> Insert (zatím nefunguje)<br>
         <input type="radio" name="Type" value="Update" checked="true"> Update <br>
-        <input type="checkbox" name="Use" checked="true"> Pøidat Use mangos <br>  
+        <input type="checkbox" name="Use" checked="true"> Pøidat Use mangos <br> 
+        <br /> 
+        <b>Filtr:</b><br />
         <input type="text" name="NumberVote" value="4" size="1"> Poèet nutných hlasù <br>                                                               
         <input type="text" name="Vote" value="3" size="1"> Známka lep¹í jak