Changeset 226

Timestamp:

Jul 2, 2009, 11:18:27 AM (15 years ago)

Author:

maron

Message:

Oprava importu dbc

Location:

trunk

Files:

• import/index.php (modified) (5 diffs)
• includes/global_function.php (modified) (2 diffs)

trunk/import/index.php

@@ -32 +32 @@
       foreach($TranslationTree as $Group)
       {
-        if(($Group['MangosTable'] != '') and ($Group['TablePrefix'] != ''))
+        if(($Group['MangosTable'] != '') and ($Group['TablePrefix'] != '') and ($Group['MangosDatabase'] == 'mangos'))
         {
           $tables[] = $Group['Id'];
@@ -87 +87 @@
         foreach($tables as $table)
         {
-                  echo('<a href="?source=sql_mangos&amp;group='.$table.'">'.$TranslationTree[$table]['Name'].'</a>');   
+                  echo('<a href="?source=dbc&amp;group='.$table.'">'.$TranslationTree[$table]['Name'].'</a>');  
                   if ($table == $tables[0]) echo(' <strong>Pracuje</strong>');
                   echo ('<br />');
@@ -96 +96 @@
                 {
           echo('<script type="text/javascript" language="JavaScript" charset="utf-8">'.
-          'setTimeout("parent.location.href=\''.htmlspecialchars_decode('?source=sql_mangos&amp;group='.$tables[1]).'\'", 3000)</script>');
+          'setTimeout("parent.location.href=\''.htmlspecialchars_decode('?source=dbc&amp;group='.$tables[1]).'\'", 3000)</script>');
                 } else {
           echo('<script type="text/javascript" language="JavaScript" charset="utf-8">'.
@@ -104 +104 @@
         foreach($tables as $table)
         {
-                  echo('<a href="?source=sql_mangos&amp;group='.$table.'">'.$TranslationTree[$table]['Name'].'</a>');   
+                  echo('<a href="?source=dbc&amp;group='.$table.'">'.$TranslationTree[$table]['Name'].'</a>');  
                   if ($table < $_GET['group']) echo (' <strong>Hotovo</strong>');
                   if ($table == $_GET['group']) echo (' <strong>Pracuje</strong>');
@@ -114 +114 @@
                 {
           echo('<script type="text/javascript" language="JavaScript" charset="utf-8">'.
-          'setTimeout("parent.location.href=\''.htmlspecialchars_decode('?source=sql_mangos&amp;group='.$tables[array_search($_GET['group'],$tables)+1]).'\'", 3000)</script>');
+          'setTimeout("parent.location.href=\''.htmlspecialchars_decode('?source=dbc&amp;group='.$tables[array_search($_GET['group'],$tables)+1]).'\'", 3000)</script>');
                 } else {
           echo('<script type="text/javascript" language="JavaScript" charset="utf-8">'.

trunk/includes/global_function.php

@@ -253 +253 @@
         
   
-    if ($GroupItem['MangosColumn'] <> '')  
+    if (($GroupItem['MangosColumn'] <> '') and ($Group['MangosDatabase'] == 'mangos'))
       $new = $Value[$GroupItem['MangosColumn']];
     else
@@ -290 +290 @@
 function GetVersionWOW($BuildNumber)
 {
-  global $Database;
-        
-  $sql = 'SELECT Version FROM `wow_client_version` WHERE BuildNumber = "'.$BuildNumber.'"';
-  $Version = mysql_fetch_assoc($Database->SQLCommand($sql));
-  return($Version['Version']);
+  global $Database,$VersionsWOW;
+  if (isset($VersionsWOW[$BuildNumber]) == false) 
+  {
+    $sql = 'SELECT Version FROM `wow_client_version` WHERE BuildNumber = "'.$BuildNumber.'"';
+    $Version = mysql_fetch_assoc($Database->SQLCommand($sql));
+    $VersionsWOW[$BuildNumber] = $Version['Version'];
+  }
+    return($VersionsWOW[$BuildNumber]);
 }
 
 function GetDBCColumns($Version,$DBCFileName)
 {
-  global $Database;
-        
-  $sql = 'SELECT DBCColumns_'.$DBCFileName.' as DBCColumns FROM `wow_client_version` WHERE Version = "'.$Version.'"';
-  $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
-  return($DbRow['DBCColumns']);
+  global $Database,$BuildNumbers;
+  if (isset($BuildNumbers[$Version]) == false) 
+  {
+    $sql = 'SELECT DBCColumns_'.$DBCFileName.' as DBCColumns FROM `wow_client_version` WHERE Version = "'.$Version.'"';
+    $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
+    $BuildNumbers[$Version] = $DbRow['DBCColumns'];
+  }
+  return($BuildNumbers[$Version]);
 }