Changeset 224 for quests/export.php

Timestamp:

Jan 13, 2008, 7:39:02 PM (17 years ago)

Author:

maron

Message:

Menší opravy + import do mangos databáze

File:

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

quests/export.php

@@ -33 +33 @@
       $AddObjectiveText4 = @$_GET['AddObjectiveText4']; 
 
+      if (($Export == 'Mangos') and (Licence(1))) {} else die('');
+    
     
     $Buffer = '
@@ -68 +70 @@
     while ($Line = mysql_fetch_array($ID)) {
       $entry = $Line['entry']; 
-      $Title = $Line['Title'];  
-      $Details = $Line['Details'];
-      $Objectives = $Line['Objectives'];
-      $OfferRewardText = $Line['OfferRewardText'];
-      $RequestItemsText = $Line['RequestItemsText'];
-      $EndText = $Line['EndText'];
-      $ObjectiveText1 = $Line['ObjectiveText1'];        
-      $ObjectiveText2 = $Line['ObjectiveText2'];        
-      $ObjectiveText3 = $Line['ObjectiveText3'];        
-      $ObjectiveText4 = $Line['ObjectiveText4'];        
+      $Title = mysql_escape_string($Line['Title']);  
+      $Details = mysql_escape_string($Line['Details']);
+      $Objectives = mysql_escape_string($Line['Objectives']);
+      $OfferRewardText = mysql_escape_string($Line['OfferRewardText']);
+      $RequestItemsText = mysql_escape_string($Line['RequestItemsText']);
+      $EndText = mysql_escape_string($Line['EndText']);
+      $ObjectiveText1 = mysql_escape_string($Line['ObjectiveText1']);   
+      $ObjectiveText2 = mysql_escape_string($Line['ObjectiveText2']);   
+      $ObjectiveText3 = mysql_escape_string($Line['ObjectiveText3']);   
+      $ObjectiveText4 = mysql_escape_string($Line['ObjectiveText4']);   
     
     if ($AddTitle == 'Translate')
@@ -109 +111 @@
     if ($Diacritical == False) $sql=WithOutDiacritical($sql);
     
+    $Database->SelectDatabase($Config['Database']['DatabaseMangos']);    
+    if ($Export == 'Mangos')    
+      $Database->SQLCommand($sql);
+      
     $Buffer .= $sql." 
     ";
@@ -118 +124 @@
     echo $Buffer;
     echo '</textarea>';
+  }
+  if ($Export == 'Mangos') {
+    echo 'Hotovo';
   }
   
@@ -146 +155 @@
         <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(1)) {
+          echo '<input type="radio" name="Export" value="Mangos"> Import na server<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 />