Changeset 554 for trunk/export

Timestamp:

Jul 29, 2013, 9:25:33 PM (11 years ago)

Author:

chronos

Message:

• Fixed: Error in user profile page if user id is not given.
• Fixed: Error in translation list view if translation group item filter is empty.
• Fixed: SQL constraint error in case of export deletion which have records in related tables.
• Fixed: Error when table ordering parameter contain invalid value.

File:

• trunk/export/index.php (modified) (1 diff)

trunk/export/index.php

@@ -116 +116 @@
   if($User->Licence(LICENCE_USER))
   {   
-    $System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId'].' AND `User`='.$User->Id);
-    $System->Database->query('DELETE FROM `Export` WHERE `Id`='.$_GET['ExportId']);
-    DeleteDirectory('../tmp/Export/'.$_GET['ExportId'].'/');
-    $Output = ShowMessage('Export smazán.');
-    $_GET['Filter'] = 'my';
-    WriteLog('Smazán export '.$_GET['ExportId'], LOG_TYPE_EXPORT);
-    $Output .= ExportList();
+    $DbResult = $System->Database->query('SELECT * FROM `Export` WHERE (`Id`='.($_GET['ExportId'] * 1).') AND (`User`='.$User->Id.')');
+    if($DbResult->num_rows > 0)
+    {
+      $System->Database->query('DELETE FROM `ExportGroup` WHERE `Export`='.$_GET['ExportId']);
+      $System->Database->query('DELETE FROM `ExportLanguage` WHERE `Export`='.$_GET['ExportId']);
+      $System->Database->query('DELETE FROM `ExportTask` WHERE `Export`='.$_GET['ExportId']);
+      $System->Database->query('DELETE FROM `ExportUser` WHERE `Export`='.$_GET['ExportId']);
+      $System->Database->query('DELETE FROM `Export` WHERE `Id`='.$_GET['ExportId']);
+      DeleteDirectory('../tmp/Export/'.$_GET['ExportId'].'/');
+      $Output = ShowMessage('Export smazán.');
+      $_GET['Filter'] = 'my';
+      WriteLog('Smazán export '.$_GET['ExportId'], LOG_TYPE_EXPORT);
+      $Output .= ExportList();
+    } else $Output = ShowMessage('Export nenalezen.', MESSAGE_CRITICAL);
   } else $Output = ShowMessage('Nemáte oprávnění.', MESSAGE_CRITICAL);
   return($Output);