Changeset 120 for trunk/export/export.php

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.

File:

• trunk/export/export.php (modified) (3 diffs)

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 />');
+  }
+}
+
 ?>