Changeset 330

Timestamp:

Feb 21, 2010, 3:58:08 PM (15 years ago)

Author:

maron

Message:

generování i starších textů u addonu pokud nejsou k dispozici nové

File:

• trunk/export/create_addon.php (modified) (1 diff)

trunk/export/create_addon.php

@@ -111 +111 @@
         $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);
+                        
+                }
+        
         while($Line = $DbResult2->fetch_assoc()) 
         {