Changeset 176 for trunk/export/index.php

Timestamp:

Apr 10, 2009, 7:42:43 PM (16 years ago)

Author:

maron

Message:

Import textů do aowow

File:

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

trunk/export/index.php

@@ -111 +111 @@
         echo ('<strong>Hotovo</strong><br />');
         
-        echo('Importuji do AoWoW ');
+        echo('Importuji do Mangos a spell ');
                 $Database->SelectDatabase($AoWoWconf['mangos']['db']);    
                 $Database->SQLCommand('SET NAMES '.$Config['Database']['Charset']);
@@ -118 +118 @@
           {
                         if ($Line <> '') $Database->SQLCommand($Line);
-                        echo('.');
-                  }
+                        echo('. ');
+                  }       
         echo ('<strong>Hotovo</strong><br />');
+                
+        echo('Importuji do AoWoW ');
+            $Query = 'SELECT name FROM aowow_resistances';
+        $ID = $Database->SQLCommand($Query);
+                while($Line = mysql_fetch_assoc($ID)) {
+                $Tran = mysql_fetch_assoc($Database->SQLCommand('SELECT text as en,
+                (SELECT text FROM '.$Config['Database']['Database'].'.global_strings as tabletran
+                 WHERE tableen.entry = tabletran.entry AND Language <> 0 LIMIT 1) as tran
+                 FROM '.$Config['Database']['Database'].'.global_strings as tableen WHERE text = "'.$Line['name'].'" LIMIT 1'));
+                        //echo ($Line['name'].'='.$Tran['tran']);
+                        
+                        $Database->SQLCommand('UPDATE aowow_resistances SET name = "'.$Tran['tran'].'" WHERE name = "'.$Line['name'].'"');
+                        echo('. ');
+                }
+                
+            $Query = 'SELECT name FROM aowow_skill';
+        $ID = $Database->SQLCommand($Query);
+                while($Line = mysql_fetch_assoc($ID)) {
+                $Tran = mysql_fetch_assoc($Database->SQLCommand('SELECT text as en,
+                (SELECT text FROM '.$Config['Database']['Database'].'.global_strings as tabletran
+                 WHERE tableen.entry = tabletran.entry AND Language <> 0 LIMIT 1) as tran
+                 FROM '.$Config['Database']['Database'].'.global_strings as tableen WHERE text = "'.$Line['name'].'" LIMIT 1'));
+                        //echo ($Line['name'].'='.$Tran['tran']);
+                        
+                        $Database->SQLCommand('UPDATE aowow_skill SET name = "'.$Tran['tran'].'" WHERE name = "'.$Line['name'].'"');
+                        echo('. ');
+                }
+                
+                $Query = 'SELECT name FROM aowow_spelldispeltype';
+        $ID = $Database->SQLCommand($Query);
+                while($Line = mysql_fetch_assoc($ID)) {
+                $Tran = mysql_fetch_assoc($Database->SQLCommand('SELECT text as en,
+                (SELECT text FROM '.$Config['Database']['Database'].'.global_strings as tabletran
+                 WHERE tableen.entry = tabletran.entry AND Language <> 0 LIMIT 1) as tran
+                 FROM '.$Config['Database']['Database'].'.global_strings as tableen WHERE text = "'.$Line['name'].'" LIMIT 1'));
+                        //echo ($Line['name'].'='.$Tran['tran']);
+                        
+                        $Database->SQLCommand('UPDATE aowow_spelldispeltype SET name = "'.$Tran['tran'].'" WHERE name = "'.$Line['name'].'"');
+                        echo('. ');
+                }
+        echo ('<strong>Hotovo</strong><br />');
+                
+                //TODO   aowow_itemenchantmet, aowow_char_titles, aowow_factions, aowow_itemset, aowow_spelldispeltype, aowow_spellmechanic, aowow_spellrange, aowow_zones
                 
                 echo('Aktualizuji aktuality ');