Changeset 178 for trunk/export/index.php

Timestamp:

Apr 11, 2009, 12:34:37 PM (15 years ago)

Author:

maron

Message:

Export do AoWoW ke stažení

File:

• trunk/export/index.php (modified) (5 diffs)

trunk/export/index.php

@@ -97 +97 @@
       
         echo('Pokud nezačalo stahování, soubor by mělo jít stáhnout pomocí tohoto odkazu: '. 
-          '<a href="'.$SaveFilename.'">CzWoW_SQL.zip</a><br />'.
+          '<a href="'.$SaveFilename.'">'.$SQLFilename.'</a><br />'.
           'Pokud se vám zdá, že filtr na export nefunguje, vymažte si vyrovnávací paměť prohlížeče a zkuste stáhnout soubor znovu.');
             break;
@@ -105 +105 @@
         echo('</pre>');
             break;
-          case 'AoWoWSQL':
+          case 'AoWoWSQLCompressed':
+        if(function_exists('gzcompress')) 
+        {
+                  $TempDir = $Config['Web']['TempFolder'].$_SESSION['User'].'/';
+                  if(!file_exists($TempDir)) mkdir($TempDir, 0777, true);
+          $SaveFilename = $TempDir.'CzAoWoW_SQL.zip';
+          $SQLFilename = 'CzAoWoW_SQL.sql';        
+          $BufferZip = ExportToAoWoWSQL($ExportSetting);
+          $ZipFile = new zipfile();
+          $ZipFile->addFile($BufferZip, $SQLFilename);
+          $Buffer = $ZipFile->file();
+          file_put_contents($SaveFilename, $Buffer);
+        } else echo('Funkce pro tvorbu Zip souboru není podporována!');
+        echo('<script type="text/javascript" language="JavaScript" charset="utf-8">'.
+          'setTimeout("parent.location.href=\''.$SaveFilename.'\'", 1000)'.
+          '</script>');
+      
+        echo('Pokud nezačalo stahování, soubor by mělo jít stáhnout pomocí tohoto odkazu: '. 
+          '<a href="'.$SaveFilename.'">'.$SQLFilename.'</a><br />'.
+          'Pokud se vám zdá, že filtr na export nefunguje, vymažte si vyrovnávací paměť prohlížeče a zkuste stáhnout soubor znovu.');
+            break;
+          case 'AoWoWSQLDirect':
+        echo('Vygenerovaný SQL kód: <br /><pre class="SQLCode">');
+        echo(htmlspecialchars(ExportToAoWoWSQL($ExportSetting)));
+        echo('</pre>');
+            break;
+          case 'AoWoWImport':
                 require_once('../aowow/configs/config.php');
         echo('Gewneruji SQL kód ');
-        $AoWoWSQL = ExportToMangosSQL($ExportSetting);
+        $AoWoWSQL = ExportToAoWoWSQL($ExportSetting);
         echo ('<strong>Hotovo</strong><br />');
         
-        echo('Importuji do Mangos a spell ');
+        echo('Importuji do AoWoW ');
                 $Database->SelectDatabase($AoWoWconf['mangos']['db']);    
                 $Database->SQLCommand('SET NAMES '.$Config['Database']['Charset']);
@@ -120 +146 @@
                         echo('. ');
                   }       
-        echo ('<strong>Hotovo</strong><br />');
-                
-        echo('Importuji do AoWoW ');
-            $Query = 'SELECT name FROM aowow_resistances';
-        $ID = $Database->SQLCommand($Query);
-                while($Line = mysql_fetch_assoc($ID)) {
-                $Tran = mysql_fetch_assoc($Database->SQLCommand('SELECT text as en,
-                (SELECT text FROM '.$Config['Database']['Database'].'.global_strings as tabletran
-                 WHERE tableen.entry = tabletran.entry AND Language <> 0 LIMIT 1) as tran
-                 FROM '.$Config['Database']['Database'].'.global_strings as tableen WHERE text = "'.$Line['name'].'" LIMIT 1'));
-                        //echo ($Line['name'].'='.$Tran['tran']);
-                        if ($Tran['tran'] <> '')
-                        $Database->SQLCommand('UPDATE aowow_resistances SET name = "'.$Tran['tran'].'" WHERE name = "'.$Line['name'].'"');
-                        echo('. ');
-                }
-                
-            $Query = 'SELECT name FROM aowow_skill';
-        $ID = $Database->SQLCommand($Query);
-                while($Line = mysql_fetch_assoc($ID)) {
-                $Tran = mysql_fetch_assoc($Database->SQLCommand('SELECT text as en,
-                (SELECT text FROM '.$Config['Database']['Database'].'.global_strings as tabletran
-                 WHERE tableen.entry = tabletran.entry AND Language <> 0 LIMIT 1) as tran
-                 FROM '.$Config['Database']['Database'].'.global_strings as tableen WHERE text = "'.$Line['name'].'" LIMIT 1'));
-                        //echo ($Line['name'].'='.$Tran['tran']);
-                        if ($Tran['tran'] <> '')
-                        $Database->SQLCommand('UPDATE aowow_skill SET name = "'.$Tran['tran'].'" WHERE name = "'.$Line['name'].'"');
-                        echo('. ');
-                }
-                
-                $Query = 'SELECT name FROM aowow_spelldispeltype';
-        $ID = $Database->SQLCommand($Query);
-                while($Line = mysql_fetch_assoc($ID)) {
-                $Tran = mysql_fetch_assoc($Database->SQLCommand('SELECT text as en,
-                (SELECT text FROM '.$Config['Database']['Database'].'.global_strings as tabletran
-                 WHERE tableen.entry = tabletran.entry AND Language <> 0 LIMIT 1) as tran
-                 FROM '.$Config['Database']['Database'].'.global_strings as tableen WHERE text = "'.$Line['name'].'" LIMIT 1'));
-                        //echo ($Line['name'].'='.$Tran['tran']);
-                        if ($Tran['tran'] <> '')
-                        $Database->SQLCommand('UPDATE aowow_spelldispeltype SET name = "'.$Tran['tran'].'" WHERE name = "'.$Line['name'].'"');
-                        echo('. ');
-                }
         echo ('<strong>Hotovo</strong><br />');
                 
@@ -348 +333 @@
       RadioButton('Export', 'MangosSQLDirect', $ExportSetting['Export'] == 'MangosSQLDirect').'MaNGOS SQL - přímo zobrazit<br />'.
           RadioButton('Export', 'MangosSQLCompressed', $ExportSetting['Export'] == 'MangosSQLCompressed').'MaNGOS SQL - komprimovaný soubor<br />'.
+          RadioButton('Export', 'AoWoWSQLDirect', $ExportSetting['Export'] == 'AoWoWSQLDirect').'AoWoW SQL - přímo zobrazit<br />'.
+          RadioButton('Export', 'AoWoWSQLCompressed', $ExportSetting['Export'] == 'AoWoWSQLCompressed').'AoWoW SQL - komprimovaný soubor<br />'.
       RadioButton('Export', 'XMLDirect', $ExportSetting['Export'] == 'XMLDirect').'XML - přímo zobrazit<br />'.
           RadioButton('Export', 'XMLCompressed', $ExportSetting['Export'] == 'XMLCompressed').'XML - komprimovaný soubor<br />'.
@@ -354 +341 @@
     if(Licence(LICENCE_ADMIN)) {
           echo (RadioButton('Export', 'DBC', $ExportSetting['Export'] == 'DBC').'DBC - komprimovaný soubor (pouze admin)<br />');
-          echo(RadioButton('Export', 'AoWoWSQL', $ExportSetting['Export'] == 'AoWoWSQL').'Importovat do AoWoW (pouze admin)<br />');
+          echo(RadioButton('Export', 'AoWoWImport', $ExportSetting['Export'] == 'AoWoWImport').'Importovat do AoWoW (pouze admin)<br />');
           echo(RadioButton('Export', 'VerseCZ', $ExportSetting['Export'] == 'VerseCZ').'Vytvoření verze češtiny <a href="../download.php?createverse" Title="Před konečným exportováním napište popis k verzi" Target="_NEW">Popis k verzi</a> (pouze admin)<br />');
     }