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

trunk/export/process_task.php

@@ -12 +12 @@
 while(1)
 {
-  $DbResult = $Database->SQLCommand('SELECT ExportTask.Export, Export.Id AS ExportId FROM ExportTask LEFT JOIN Export ON Export.Id = ExportTask.Export WHERE ExportTask.TimeFinish IS NULL');
+  $DbResult = $Database->SQLCommand('SELECT `ExportTask`.`Export`, `Export`.`Id` AS `ExportId` FROM `ExportTask` LEFT JOIN `Export` ON `Export`.`Id` = `ExportTask`.`Export` WHERE `ExportTask`.`TimeFinish` IS NULL');
   while($DbRow = mysql_fetch_assoc($DbResult)) 
   {
@@ -34 +34 @@
           echo('Hotovo');
         } else echo('Funkce pro tvorbu Zip souboru není podporována!');
-        $Database->SQLCommand('UPDATE ExportTask SET TimeFinish=NOW() WHERE Export='.$Export->Id);
+        $Database->SQLCommand('UPDATE `ExportTask` SET `TimeFinish`=NOW() WHERE `Export`='.$Export->Id);
       } catch (Exception $e) 
       {
@@ -41 +41 @@
     } else
     {
-      $Database->SQLCommand('DELETE FROM ExportTask WHERE Export='.$DbRow['Export']);
+      $Database->SQLCommand('DELETE FROM `ExportTask` WHERE `Export`='.$DbRow['Export']);
       echo('Export '.$DbRow['Export'].' nenalezen. Jeho úloha smazána.'."\n");
     }