Changeset 120 for trunk/export

Timestamp:

Feb 21, 2009, 7:38:18 PM (16 years ago)

Author:

george

Message:

• Přidáno: Program MPQEditor ke stažení.
• Přidáno: Možnost exportovat překlady jako Lua překladové soubory.
• Odstraněno: Stará překladová skupina client.

Location:

trunk/export

Files:

• create_addon.php (modified) (2 diffs)
• export.php (modified) (3 diffs)
• index.php (modified) (2 diffs)

trunk/export/create_addon.php

@@ -174 +174 @@
         
   $Buffer = "local f=function(name, en, cz) CzWoW_interface[name]=cz; CzWoW_interface_entoname[en]=name; end; CzWoW_interface={ };CzWoW_interface_entoname={ };\n";
-  $Group = $TranslationTree[9]; // client table
+  $Group = $TranslationTree[14]; // client table
   $Column['Column'] = 'Text';
-  $Query = 'SELECT T2.'.$Column['Column'].' AS Translation, T3.'.$Column['Column'].' as Original, T3.id_text FROM (SELECT T1.entry, T1.'.$Column['Column'].' FROM (SELECT entry,'.$Column['Column'].' FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$WhereLang.' AND '.$WhereUsers.$OrderByUserList.') AS T1 GROUP BY T1.entry) as T2 JOIN '.$Group['TablePrefix'].' AS T3 ON (T2.entry = T3.entry) AND (T3.Language = 0)';
+  $Query = 'SELECT T2.'.$Column['Column'].' AS Translation, T3.'.$Column['Column'].' as Original, T3.ShortCut FROM (SELECT T1.entry, T1.'.$Column['Column'].' FROM (SELECT entry,'.$Column['Column'].' FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$WhereLang.' AND '.$WhereUsers.$OrderByUserList.') AS T1 GROUP BY T1.entry) as T2 JOIN '.$Group['TablePrefix'].' AS T3 ON (T2.entry = T3.entry) AND (T3.Language = 0)';
   $DbResult = $Database->SQLCommand($Query);
   while($Line = mysql_fetch_array($DbResult)) 
@@ -182 +182 @@
         $Original = str_replace("\r", '', str_replace("\n", '\r\\'."\n", addslashes($Line['Original'])));
         $Translated = str_replace("\r", '', str_replace("\n", '\r\\'."\n", addslashes($Line['Translation'])));
-    $Buffer .= 'f("'.addslashes($Line['id_text']).'", "'.$Original.'", "'.$Translated.'");'."\n";
+    $Buffer .= 'f("'.addslashes($Line['ShortCut']).'", "'.$Original.'", "'.$Translated.'");'."\n";
   }
   file_put_contents($TempDir.'LocalizationStrings.lua', $Buffer);

trunk/export/export.php

@@ -167 +167 @@
   global $Database, $Config, $TranslationTree;
   
-  $TempDir = 'tmp/'.$_SESSION['User'].'/dbc/';
+  $TempDir = $Config['Web']['TempFolder'].$_SESSION['User'].'/dbc/';
   if(!file_exists($TempDir)) mkdir($TempDir, 0777, true);
  
@@ -205 +205 @@
         echo($Group['Name'].'... ');
     $DBCFile = new DBCFile();
-    $DBCFile->OpenFile('dbc/'.$Group['DBCFileName'].'.dbc', $Group['DBCColumns']);
+    $DBCFile->OpenFile('../source/'.$Config['Web']['GameVersion'].'/dbc/'.$Group['DBCFileName'].'.dbc', $Group['DBCColumns']);
     $DBCFile2 = new DBCFile();
     $DBCFile2->CreateFile($TempDir.$Group['DBCFileName'].'.dbc', $Group['DBCColumns']);
@@ -235 +235 @@
 }
 
+function ExportToLua($Setting)
+{
+  global $Database, $Config, $TranslationTree;
+  
+  $TempDir = $Config['Web']['TempFolder'].$_SESSION['User'].'/lua/';
+  if(!file_exists($TempDir)) mkdir($TempDir, 0777, true);
+ 
+  if($_SESSION['UserID'] != '')
+  {
+    $DbResult = $Database->SQLCommand('SELECT user FROM `user` WHERE ID='.$_SESSION['UserID']);
+    $User = mysql_fetch_assoc($DbResult);
+  } else $User = array('user' => 'Neznámý');
+
+  $WhereLang = '';
+  if($Setting['language-cz']) $WhereLang .= " OR (Language = 1)";
+  if($Setting['language-sk']) $WhereLang .= " OR (Language = 2)";
+  if($Setting['language-other']) $WhereLang .= " OR (Language = 3)";
+  if($WhereLang == '') $WhereLang = 1; 
+    else $WhereLang = '('.substr($WhereLang, 4).')';
+
+  $SelectedUsers = '';  
+  foreach($Setting['users-selection'] as $Item)
+    $SelectedUsers .= ','.$Item;
+  $SelectedUsers = substr($SelectedUsers, 1);
+
+  if($SelectedUsers == '') $Where = 0;
+    else $Where = 'ID IN ('.$SelectedUsers.')';
+  
+  $UserNames = '';
+  $DbResult = $Database->SQLCommand('SELECT user FROM `user` WHERE '.$Where);
+  while($DbRow = mysql_fetch_assoc($DbResult))
+    $UserNames .= ','.$DbRow['user'];
+  $UserNames = substr($UserNames, 1);    
+   
+  if($SelectedUsers == '') $WhereUsers = 1; 
+    else $WhereUsers = '(User IN ('.$SelectedUsers.'))';
+  
+  foreach($TranslationTree as $Group)
+  if(in_array($Group['Id'], $Setting['groups']) and ($Group['LuaFileName'] != '')) 
+  { 
+        echo($Group['Name'].'... ');
+    $File = new FileStream();
+    $File->OpenFile('../source/'.$Config['Web']['GameVersion'].'/lua/'.$Group['LuaFileName'].'.lua');
+    $File2 = new FileStream();
+    $File2->CreateFile($TempDir.$Group['LuaFileName'].'.lua');
+
+    while(!$File->EOF())
+        {
+          $Line = $File->ReadLine();
+          if(strpos($Line, '=') !== false)
+          {
+                $LineParts = explode(';', $Line);
+        $LineParts2 = explode('=', $LineParts[0]);
+                $Value['ShortCut'] = addslashes(trim($LineParts2[0]));
+                $Value['Text'] = addslashes(substr(trim($LineParts2[1]), 1, -1));
+                $Value['Comment'] = addslashes(substr(trim($LineParts[1]), 3));
+
+            $Query = 'SELECT * FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$WhereLang.' AND '.$WhereUsers.' AND (ShortCut="'.$Value['ShortCut'].'") ORDER BY FIELD(User, '.$SelectedUsers.')) AS T GROUP BY T.entry';
+                //echo($Query);
+            $DbResult = $Database->SQLCommand($Query);
+            if(mysql_num_rows($DbResult) > 0)
+            {
+              $DbRow = mysql_fetch_assoc($DbResult);
+                  $Value['Text'] = $DbRow['Text'];
+                  $Value['Comment'] = $DbRow['Comment'];
+              //echo('.');
+                }
+                $File2->WriteLine($Value['ShortCut'].' = "'.$Value['Text'].'"; -- '.$Value['Comment']."\n");
+          } else $File2->WriteLine($Line."\n");
+        }
+    echo('Hotovo <br />');
+  }
+}
+
 ?>

trunk/export/index.php

@@ -197 +197 @@
           '<a href="'.$SaveFilename.'">CzWoW_DBC.zip</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.');
-                echo('<br /><strong>Použití ve hře</strong><br />Ze souborů vytvořte MPQ archív a nahrajte ho do hry do podsložky Data/enUS jako patch-enUS-5.MPQ. Hru spusťte pomocí programu WoWMe.exe (WoW Model Editor Fix).');
+                echo('<br /><br /><strong>Použití ve hře</strong><br />Ze souborů vytvořte MPQ archív a nahrajte ho do hry do podsložky Data/enUS jako patch-enUS-5.MPQ. Hru spusťte pomocí programu WoWMe.exe (WoW Model Editor Fix).');
+            break;
+          case 'Lua':
+        if(function_exists('gzcompress')) 
+        {
+          $TempDir = $Config['Web']['TempFolder'].$_SESSION['User'].'/lua/';
+              echo('Generování lua souborů...<br />');
+          ExportToLUA($ExportSetting);
+          $SaveFilename = $Config['Web']['TempFolder'].$_SESSION['User'].'/CzWoW_Lua.zip';          
+          $Zip = new zipfile();
+          CreateZipFromDir($Zip, $TempDir, '');
+              $Buffer = $Zip->file();
+          file_put_contents($SaveFilename, $Buffer);
+                  echo('Hotovo<br /><br />');
+        } 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.'">CzWoW_Lua.zip</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.');
+                echo('<br /><br /><strong>Použití ve hře</strong><br />Ze souborů vytvořte MPQ archív a nahrajte ho do hry do podsložky Data/enUS jako patch-enUS-5.MPQ. Hru spusťte pomocí programu WoWMe.exe (WoW Model Editor Fix).');
             break;
         }
@@ -217 +239 @@
           RadioButton('Export', 'XMLCompressed', $ExportSetting['Export'] == 'XMLCompressed').'XML - komprimovaný soubor<br />'.
       //RadioButton('Export', 'DBC', $ExportSetting['Export'] == 'DBC').'DBC - komprimovaný soubor<br />'.
-          RadioButton('Export', 'Addon', $ExportSetting['Export'] == 'Addon').'Addon - komprimovaný soubor<br />');
+          RadioButton('Export', 'Addon', $ExportSetting['Export'] == 'Addon').'Addon - komprimovaný soubor<br />'.
+          RadioButton('Export', 'Lua', $ExportSetting['Export'] == 'Lua').'Lua skripty - komprimovaný soubor<br />');
     if(Licence(LICENCE_ADMIN)) 
       echo(RadioButton('Export', 'Server', $ExportSetting['Export'] == 'Server').'Poslat přímo na server (pouze admin)<br />');