Changeset 407 for trunk/export/create_addon.php

Timestamp:

Mar 28, 2010, 6:09:33 PM (14 years ago)

Author:

george

Message:

• Opraveno: Exportování addonu. Funkce BuildQuery rozšířena pro načítání anglických originálů. Názvy sloupců s anglickými texty jsou prefixovýny pomocí En.

File:

• trunk/export/create_addon.php (modified) (2 diffs)

trunk/export/create_addon.php

@@ -123 +123 @@
         $Buffer = 'CZWOW_'.$Column['AddonFileName'].'_count='.$FileIndex.';CZWOW_'.$Column['AddonFileName'].'_'.$FileIndex.'={';
     
-        $Query = 'SELECT `T2`.`'.$Column['Column'].'` AS `Translation`, `T3`.`'.$Column['Column'].'` AS `Original` FROM (SELECT `T1`.`Entry`, `T1`.`'.$Column['Column'].'` FROM (SELECT `Entry`,`'.$Column['Column'].'` FROM `'.$Group['TablePrefix'].'` WHERE (`Complete` = 1) AND (`VersionStart` <= '.$this->ClientVersion['BuildNumber'].') AND (`VersionEnd` >= '.$this->ClientVersion['BuildNumber'].') AND '.$this->WhereLang.' AND '.$this->WhereUsers.$this->OrderByUserList.') AS `T1` GROUP BY `T1`.`Entry`) AS `T2` JOIN `'.$Group['TablePrefix'].'` AS `T3` ON (`T2`.`Entry` = `T3`.`Entry`) AND (`T3`.`Language` = 0)';
-        $DbResult2 = $this->Database->query($Query);
-        
-        
-        if ($this->Database->affected_rows == 0) {
-      $ID = $this->Database->query('SELECT MAX(`VersionEnd`) FROM `'.$Group['TablePrefix'].'`');
-      $BuildNumber_max = $ID->fetch_assoc();
-      $BuildNumber_max = $BuildNumber_max['MAX(`VersionEnd`)'];
-      
-      $Query = 'SELECT `T2`.`'.$Column['Column'].'` AS `Translation`, `T3`.`'.$Column['Column'].'` AS `Original` FROM (SELECT `T1`.`Entry`, `T1`.`'.$Column['Column'].'` FROM (SELECT `Entry`,`'.$Column['Column'].'` FROM `'.$Group['TablePrefix'].'` WHERE (`Complete` = 1) AND (`VersionStart` <= '.$BuildNumber_max.') AND (`VersionEnd` >= '.$BuildNumber_max.') AND '.$this->WhereLang.' AND '.$this->WhereUsers.$this->OrderByUserList.') AS `T1` GROUP BY `T1`.`Entry`) AS `T2` JOIN `'.$Group['TablePrefix'].'` AS `T3` ON (`T2`.`Entry` = `T3`.`Entry`) AND (`T3`.`Language` = 0)';
-            $DbResult2 = $this->Database->query($Query);
-      
-    }
+        $DbResult2 = $this->Database->query($this->BuildQuery($Group));
         
         while($Line = $DbResult2->fetch_assoc()) 
         {
-          $en = trim($this->ReplaceEnText($Line['Original']));  
-          $cz = $this->ReplaceCzText($Line['Translation']);
+          $en = trim($this->ReplaceEnText($Line['En'.$Column['Column']]));  
+          $cz = $this->ReplaceCzText($Line[$Column['Column']]);
           if(($en <> '') and ($cz <> '') and ($this->NotCancel($en))) 
           {
@@ -174 +162 @@
     $Group = $TranslationTree[14]; // client table
     $Column['Column'] = 'Text';
-    $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 (`VersionStart` <= '.$this->ClientVersion['BuildNumber'].') AND (`VersionEnd` >= '.$this->ClientVersion['BuildNumber'].') AND '.$this->WhereLang.' AND '.$this->WhereUsers.$this->OrderByUserList.') AS `T1` GROUP BY `T1`.`Entry`) AS `T2` JOIN `'.$Group['TablePrefix'].'` AS `T3` ON (`T2`.`Entry` = `T3`.`Entry`) AND (`T3`.`Language` = 0)';
-    $DbResult = $this->Database->query($Query);
+    
+    $DbResult = $this->Database->query($this->BuildQuery($Group));
     while($Line = $DbResult->fetch_array()) 
     {
-      $Original = $this->my_trim($Line['Original']);
-      $Translated = $this->my_trim($Line['Translation']);
-      if ($this->ClientVersion['Version'] == '2.4.3') 
+      $Original = $this->my_trim($Line['En'.$Column['Column']]);
+      $Translated = $this->my_trim($Line[$Column['Column']]);
+      if($this->ClientVersion['Version'] == '2.4.3') 
       {
         $Original = str_replace("|Hchannel:%d|h[%s]|h", '[%s]', $Original);