Changeset 776 for trunk/Modules/Export/CreateAddon.php

Timestamp:

Feb 2, 2014, 8:28:37 PM (11 years ago)

Author:

maron

Message:

• Added: Export last 2 version in addon
• Fixed: Export text only once in addon
• Added: 100% done in progress

File:

• trunk/Modules/Export/CreateAddon.php (modified) (2 diffs)

trunk/Modules/Export/CreateAddon.php

@@ -133 +133 @@
 
         $Buffer = 'CZWOW_'.$Column['AddonFileName'].'_count='.$FileIndex.';CZWOW_'.$Column['AddonFileName'].'_'.$FileIndex.'={';
-    
-        $DbResult2 = $this->Database->query($this->BuildQuery($Group,$ExportVersion));
+        $TableTexts = array();
+    
+        //old version
+        //get version before
+        $BuildNumber = $ExportVersion;
+        if ($ExportVersion == '') $BuildNumber = $this->ClientVersion['BuildNumber'];
+        $ID = $this->Database->query('SELECT `BuildNumber` FROM `ClientVersion` WHERE '.
+        ' `Imported` = 1 AND `BuildNumber` < '.$BuildNumber.' ORDER BY  `BuildNumber` DESC LIMIT 1');  
+        if($ID->num_rows > 0) {        
+          $ExportVersionOld = $ID->fetch_assoc();
+          $ExportVersionOld = $ExportVersionOld['BuildNumber'];
         
+          echo 'old:'.$ExportVersionOld.' last:'.$ExportVersion;
+
+          $DbResult2 = $this->Database->query($this->BuildQuery($Group,$ExportVersionOld));        
+          while($Line = $DbResult2->fetch_assoc()) 
+          {
+            $en = trim($this->ReplaceEnText($Line['En'.$Column['Column']]));  
+            $cz = $this->ReplaceCzText($Line[$Column['Column']]);
+            if(($en <> '') and ($cz <> '') and ($this->NotCancel($en))) 
+            {
+               $TableTexts[$en] = $cz; 
+            }
+          }
+        }
+                //last version
+       
+        $DbResult2 = $this->Database->query($this->BuildQuery($Group,$ExportVersion));        
         while($Line = $DbResult2->fetch_assoc()) 
         {
@@ -142 +167 @@
           if(($en <> '') and ($cz <> '') and ($this->NotCancel($en))) 
           {
-            $Buffer .= "\n".'["'.$en.'"]="'.$cz.'",';
-            $i++;
+             $TableTexts[$en] = $cz; 
           }
         }
+        
+        foreach($TableTexts as $key => $value) {
+            $Buffer .= "\n".'["'.$key.'"]="'.$value.'",';
+            $i++;
+        }
+        
     
         $Buffer = $Buffer."\n};if not CZWOW_".$Column['AddonFileName']." then CZWOW_".$Column['AddonFileName']."=0; end; CZWOW_".$Column['AddonFileName']."=CZWOW_".$Column['AddonFileName']."+".$i.";\n";