Changeset 366 for trunk/export/index.php

Timestamp:

Mar 9, 2010, 1:01:14 PM (15 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/export/index.php (modified) (6 diffs)

trunk/export/index.php

@@ -127 +127 @@
   if(array_key_exists('ExportId', $_GET))
   {
-    $DbRows = $Database->SQLCommand('SELECT * FROM Export WHERE Id='.$_GET['ExportId']);
+    $DbRows = $Database->SQLCommand('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
     if(mysql_num_rows($DbRows) > 0)
     {    
@@ -148 +148 @@
           if(array_key_exists('sel'.$UserId, $_POST)) $Selected = true; 
             else $Selected = false;
-          $Condition = ' WHERE Export='.$_GET['ExportId'].' AND User='.$UserId;
-          $DbResult = $Database->SQLCommand('SELECT * FROM ExportUser '.$Condition);
+          $Condition = ' WHERE `Export`='.$_GET['ExportId'].' AND `User`='.$UserId;
+          $DbResult = $Database->SQLCommand('SELECT * FROM `ExportUser` '.$Condition);
           if(mysql_num_rows($DbResult) > 0)
           {
-            if(!$Selected) $Database->SQLCommand('DELETE FROM ExportUser '.$Condition);
-              else $Database->SQLCommand('UPDATE ExportUser SET Sequence='.$Value.$Condition);
+            if(!$Selected) $Database->SQLCommand('DELETE FROM `ExportUser` '.$Condition);
+              else $Database->SQLCommand('UPDATE `ExportUser` SET `Sequence`='.$Value.$Condition);
           } else
           {
-            if($Selected) $Database->SQLCommand('INSERT INTO ExportUser (Export, User, Sequence) VALUES ('.$_GET['ExportId'].', '.$UserId.', '.$Value.')');
+            if($Selected) $Database->SQLCommand('INSERT INTO `ExportUser` (`Export`, `User`, `Sequence`) VALUES ('.$_GET['ExportId'].', '.$UserId.', '.$Value.')');
           }         
         }
@@ -163 +163 @@
       // Recalculate sequence number
       $Database->SQLCommand('SET @I = 0');
-      $Database->SQLCommand('UPDATE ExportUser SET Sequence = (@I := @I + 1) WHERE Export='.$_GET['ExportId'].' ORDER BY Sequence;');
+      $Database->SQLCommand('UPDATE `ExportUser` SET `Sequence` = (@I := @I + 1) WHERE `Export`='.$_GET['ExportId'].' ORDER BY `Sequence`;');
     }
   }
 
   $TableColumns = array(
-    array('Name' => 'user', 'Title' => 'Jméno'), 
+    array('Name' => 'Name', 'Title' => 'Jméno'), 
     array('Name' => 'TranslatedCount', 'Title' => 'Překladů'), 
     array('Name' => 'XP', 'Title' => 'Úroveň'), 
@@ -201 +201 @@
   echo($Order['Output']);
 
-  $Query = 'SELECT * FROM ('.$Query.') AS TX '.$Order['SQL'].$PageList['SQLLimit'];
+  $Query = 'SELECT * FROM ('.$Query.') AS `TX` '.$Order['SQL'].$PageList['SQLLimit'];
   $Database->SQLCommand('SET @I = 0');
   $DbResult = $Database->SQLCommand($Query);
@@ -396 +396 @@
   }
 
-  $Query = 'SELECT `group`.*, `ExportGroup`.`Id` AS `ExportGroupId` FROM `group` LEFT JOIN `ExportGroup` ON `ExportGroup`.`Export`='.$_GET['ExportId'].' AND `Group`=`group`.`Id`';
+  $Query = 'SELECT `Group`.*, `ExportGroup`.`Id` AS `ExportGroupId` FROM `Group` LEFT JOIN `ExportGroup` ON `ExportGroup`.`Export`='.$_GET['ExportId'].' AND `Group`=`Group`.`Id`';
 
   $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM ('.$Query.') AS X');
@@ -505 +505 @@
   $Export = mysql_fetch_assoc($DbResult);
 
-  $Query = 'SELECT `wow_client_version`.* FROM `ExportVersion` LEFT JOIN `wow_client_version` ON `wow_client_version`.`Id`=`ExportVersion`.`ClientVersion` WHERE `ExportType`='.$Export['OutputType'];
+  $Query = 'SELECT `ClientVersion`.* FROM `ExportVersion` LEFT JOIN `ClientVersion` ON `ClientVersion`.`Id`=`ExportVersion`.`ClientVersion` WHERE `ExportType`='.$Export['OutputType'];
 
   $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM ('.$Query.') AS `X`');