Changeset 180 for trunk/export/export.php

Timestamp:

Apr 15, 2009, 8:30:13 PM (15 years ago)

Author:

maron

Message:

Generování addonu pro 2.x.x a 3.x.x

File:

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

trunk/export/export.php

@@ -129 +129 @@
         $ID = $Database->SQLCommand($Query);
                 while($Line = mysql_fetch_assoc($ID)) {
+                        $Ori_text = $Line['name'];
                 $Tran = mysql_fetch_assoc($Database->SQLCommand('SELECT text as en,
                 (SELECT text FROM '.$Config['Database']['Database'].'.global_strings as tabletran
@@ -134 +135 @@
                   AND '.$WhereUsers.' ORDER BY FIELD(User, '.$SelectedUsers.') LIMIT 1) as tran
                  FROM '.$Config['Database']['Database'].'.global_strings as tableen WHERE
-                  text = "'.addslashes($Line['name']).'" LIMIT 1'));
+                  text = "'.addslashes($Ori_text).'" LIMIT 1'));
                         //echo ($Line['name'].'='.$Tran['tran']);
+                        if ($Tran['tran'] <> '') {} else {
+                        $Tran = mysql_fetch_assoc($Database->SQLCommand('SELECT OptionText as en,
+                        (SELECT OptionText FROM '.$Config['Database']['Database'].'.npc_option as tabletran
+                         WHERE tableen.entry = tabletran.entry AND (Complete = 1) AND '.$WhereLang.'
+                          AND '.$WhereUsers.' ORDER BY FIELD(User, '.$SelectedUsers.') LIMIT 1) as tran
+                        FROM '.$Config['Database']['Database'].'.npc_option as tableen WHERE
+                        OptionText = "'.addslashes($Ori_text).'" LIMIT 1'));
+                        }
                         if ($Tran['tran'] <> '')
                                 $Buffer .= 'UPDATE `'.$AoWoWTable.'` SET name = "'.addslashes($Tran['tran']).'" WHERE '.$IndexColum.' = '.$Line[$IndexColum].' ;'."\n";