Changeset 445

Timestamp:

Apr 11, 2010, 4:24:53 PM (15 years ago)

Author:

maron

Message:

Exportování starších textů, které nemají vliv na verzi clienta pokud nejsou dostupné nejnovější

Location:

trunk/export

Files:

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

trunk/export/create_addon.php

@@ -107 +107 @@
     while($Group = $DbResult->fetch_assoc())
     {
+      $ID = $this->Database->query('SELECT LastVersion FROM `Group` WHERE Id = '.$Group['Id']); 
+      $LastVersion = $ID->fetch_assoc();
+      
+      if ($LastVersion['LastVersion'] < $this->ClientVersion['BuildNumber'])
+        $ExportVersion = $LastVersion['LastVersion'];
+      else $ExportVersion = '';
+
       foreach($TranslationTree[$Group['Id']]['Items'] as $Column)
       if($Column['AddonFileName'] != '')  
@@ -123 +130 @@
         $Buffer = 'CZWOW_'.$Column['AddonFileName'].'_count='.$FileIndex.';CZWOW_'.$Column['AddonFileName'].'_'.$FileIndex.'={';
     
-        $DbResult2 = $this->Database->query($this->BuildQuery($Group));
+        $DbResult2 = $this->Database->query($this->BuildQuery($Group,'',$ExportVersion));
         
         while($Line = $DbResult2->fetch_assoc()) 

trunk/export/export.php

@@ -39 +39 @@
   }
   
-  function BuildQuery($Group, $Columns = '')
+  function BuildQuery($Group, $Columns = '', $Version = '')
   {
     global $TranslationTree;
+    
+    if ($Version <> '') 
+      $ExportVersion = $Version;
+    else
+      $ExportVersion = $this->ClientVersion['BuildNumber'];
     
     $Query = 'SELECT * FROM (SELECT `T`.*, '.$Columns.'`User`.`Name` AS `UserName` FROM `'.$Group['TablePrefix'].'` AS `T`'.
@@ -47 +52 @@
     ' JOIN `User` ON `User`.`ID`=`T`.`User`'.
     ' JOIN `ExportLanguage` ON (`ExportLanguage`.`Export`='.$this->Id.')'.
-    ' WHERE (`Complete` = 1) AND (`VersionStart` <= '.$this->ClientVersion['BuildNumber'].') AND (`VersionEnd` >= '.$this->ClientVersion['BuildNumber'].')'.
+    ' WHERE (`Complete` = 1) AND (`VersionStart` <= '.$ExportVersion.') AND (`VersionEnd` >= '.$ExportVersion.')'.
     ' ORDER BY `ExportLanguage`.`Sequence`, `ExportUser`.`Sequence`) AS `TT` GROUP BY `TT`.`Entry`';
-    
+
     // Build columns for english texts
     $OriginalColumns = '';