Changeset 366 for trunk/export/export_output.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/export_output.php (modified) (3 diffs)

trunk/export/export_output.php

@@ -190 +190 @@
   if(array_key_exists('Regenerate', $_POST))
   {
-    $Database->SQLCommand('UPDATE ExportTask SET TimeStart = NOW(), TimeFinish = NULL');
+    $Database->SQLCommand('UPDATE `ExportTask` SET `TimeStart` = NOW(), `TimeFinish` = NULL');
     echo('Soubor zařazen znovu ke zpracování.<br/><br/>');
   }
-  $DbResult = $Database->SQLCommand('SELECT * FROM ExportTask WHERE Export = '.$ExportId);
+  $DbResult = $Database->SQLCommand('SELECT * FROM `ExportTask` WHERE `Export` = '.$ExportId);
   $ExportTask = mysql_fetch_assoc($DbResult);
   if($ExportTask['TimeFinish'] > $ExportTask['TimeStart'])
@@ -201 +201 @@
     $Export->Id = $ExportId;
     $Export->Init();
-    $DbResult = $System->Database->query('SELECT `group`.* FROM `ExportGroup` JOIN `group` ON `group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$Export->Id.' AND `group`.`DBCFileName` != ""');
+    $DbResult = $System->Database->query('SELECT `Group`.* FROM `ExportGroup` JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$Export->Id.' AND `Group`.`DBCFileName` != ""');
     while($Group = $DbResult->fetch_assoc())
     {
@@ -234 +234 @@
   echo('<strong>Soubory:</strong><br/>'.  
     'Souhrný archív <a href="'.$SaveFilename.'">CzWoW_Lua.zip</a><br />');
-  $DbResult = $System->Database->query('SELECT `group`.* FROM `ExportGroup` JOIN `group` ON `group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$Export->Id.' AND `group`.`LuaFileName` != ""');
+  $DbResult = $System->Database->query('SELECT `Group`.* FROM `ExportGroup` JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$Export->Id.' AND `Group`.`LuaFileName` != ""');
   while($Group = $DbResult->fetch_assoc())
   {