Changeset 541 for trunk/export/index.php

Timestamp:

May 27, 2013, 10:38:07 PM (11 years ago)

Author:

chronos

Message:

• Opraveno: Chyba v SQL dotazu při hledání uživatelů.
• Opraveno: Chyba zobrazení výstupu exportu, pokud nebyla vybrána verze klienta.

File:

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

trunk/export/index.php

@@ -564 +564 @@
   $Export = $DbResult->fetch_assoc();
   if($Export['OutputType'] == '') $Output .= ShowMessage('Nevybrán typ exportu', MESSAGE_CRITICAL);
+  else if($Export['ClientVersion'] == '') $Output .= ShowMessage('Export nemá vybránu verzi klienta', MESSAGE_CRITICAL);
   else {
         $DbResult = $System->Database->query('SELECT * FROM `ExportOutputType` WHERE `Id`='.$Export['OutputType']);
   if($DbResult->num_rows > 0)
   {
-    $DbResult = $System->Database->query('SELECT * FROM `ExportVersion` WHERE `ExportType`='.$Export[ 'OutputType'].' AND `ClientVersion`='.$Export['ClientVersion']);
+    $DbResult = $System->Database->query('SELECT * FROM `ExportVersion` WHERE (`ExportType`='.$Export['OutputType'].') AND (`ClientVersion`='.$Export['ClientVersion'].')');
     if($DbResult->num_rows > 0)
     {  
-      $System->Database->query('UPDATE Export SET UsedCount = UsedCount + 1 WHERE Id='.$Export['Id']);
+      $System->Database->query('UPDATE `Export` SET `UsedCount` = `UsedCount` + 1 WHERE `Id`='.$Export['Id']);
       $Output = ExportOutput($Export['Id'], $Export['OutputType']);
     } else $Output = ShowMessage('Nebyla vybrána požadovaná verze klienta.', MESSAGE_CRITICAL);