Changeset 255 for trunk/includes/global_function.php

Timestamp:

Jul 24, 2009, 11:39:21 AM (15 years ago)

Author:

maron

Message:

Plánované úkoly stahování dbc zatím pouze admin

File:

• trunk/includes/global_function.php (modified) (1 diff)

trunk/includes/global_function.php

@@ -323 +323 @@
 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,$DBCColumns;
+  if (isset($DBCColumns[$Version][$DBCFileName]) == false) 
+  {
+    $sql = 'SELECT DBCColumns_'.$DBCFileName.' as DBCColumns FROM `wow_client_version` WHERE Version = "'.$Version.'"';
+    $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
+    $DBCColumns[$Version][$DBCFileName] = $DbRow['DBCColumns'];
+  }
+    return($DBCColumns[$Version][$DBCFileName]);
 }
 
 function GetDBCColumnIndex($Version,$DBCFileName,$Column)
 {
-  global $Database;
-        
-  $sql = 'SELECT '.$DBCFileName.'_'.$Column.' as DBCColumns FROM `wow_client_version` WHERE Version = "'.$Version.'"';
-  $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
-  return($DbRow['DBCColumns']);
+  global $Database,$DBCColumnIndex;
+  if (isset($DBCColumnIndex[$Version][$DBCFileName][$Column]) == false) 
+  {
+    $sql = 'SELECT '.$DBCFileName.'_'.$Column.' as DBCColumns FROM `wow_client_version` WHERE Version = "'.$Version.'"';
+    $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
+    $DBCColumnIndex[$Version][$DBCFileName][$Column] = $DbRow['DBCColumns'];
+  }
+    return($DBCColumnIndex[$Version][$DBCFileName][$Column]);
 }