Changeset 366 for trunk/includes/global_function.php

Timestamp:

Mar 9, 2010, 1:01:14 PM (14 years ago)

Author:

george

Message:

• Upraveno: Přejmenovány všechny tabulky textů na názvy s prvními velkými písmeny ve slovech plus pro odlišení s prefixem Text.
• Upraveno: Další SQL dotazy doplněny o SQL uvozovky.

File:

• trunk/includes/global_function.php (modified) (6 diffs)

trunk/includes/global_function.php

@@ -256 +256 @@
   
   $Result = array();
-  $DbResult = $Database->SQLCommand('SELECT * FROM `group` ORDER BY `name`');
+  $DbResult = $Database->SQLCommand('SELECT * FROM `Group` ORDER BY `Name`');
   while($DbRow = mysql_fetch_assoc($DbResult))
   {
@@ -262 +262 @@
     $Result[$DbRow['Id']] = $DbRow;
   }
-  $DbResult = $Database->SQLCommand('SELECT * FROM `group_item`');
+  $DbResult = $Database->SQLCommand('SELECT * FROM `GroupItem`');
   while($DbRow = mysql_fetch_assoc($DbResult))
   {
@@ -378 +378 @@
   if(isset($BuildNumbers[$Version]) == false) 
   {
-    $sql = 'SELECT `BuildNumber` FROM `wow_client_version` WHERE `Version` = "'.$Version.'"';
+    $sql = 'SELECT `BuildNumber` FROM `ClientVersion` WHERE `Version` = "'.$Version.'"';
     $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
     $BuildNumbers[$Version] = $DbRow['BuildNumber'];
@@ -391 +391 @@
   if(isset($VersionsWOW[$BuildNumber]) == false) 
   {
-    $sql = 'SELECT `Version` FROM `wow_client_version` WHERE `BuildNumber` = "'.$BuildNumber.'"';
+    $sql = 'SELECT `Version` FROM `ClientVersion` WHERE `BuildNumber` = "'.$BuildNumber.'"';
     $Version = mysql_fetch_assoc($Database->SQLCommand($sql));
     $VersionsWOW[$BuildNumber] = $Version['Version'];
@@ -404 +404 @@
   if(isset($DBCColumns[$Version][$DBCFileName]) == false) 
   {
-    $sql = 'SELECT `DBCColumns_'.$DBCFileName.'` AS `DBCColumns` FROM `wow_client_version` WHERE `Version` = "'.$Version.'"';
+    $sql = 'SELECT `DBCColumns_'.$DBCFileName.'` AS `DBCColumns` FROM `ClientVersion` WHERE `Version` = "'.$Version.'"';
     $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
     $DBCColumns[$Version][$DBCFileName] = $DbRow['DBCColumns'];
@@ -417 +417 @@
   if(isset($DBCColumnIndex[$Version][$DBCFileName][$Column]) == false) 
   {
-    $sql = 'SELECT `'.$DBCFileName.'_'.$Column.'` AS `DBCColumns` FROM `wow_client_version` WHERE `Version` = "'.$Version.'"';
+    $sql = 'SELECT `'.$DBCFileName.'_'.$Column.'` AS `DBCColumns` FROM `ClientVersion` WHERE `Version` = "'.$Version.'"';
     $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
     $DBCColumnIndex[$Version][$DBCFileName][$Column] = $DbRow['DBCColumns'];