Changeset 541

Timestamp:

May 27, 2013, 10:38:07 PM (12 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.

Location:

trunk

Files:

• action.php (modified) (1 diff)
• export/index.php (modified) (1 diff)
• includes/Version.php (modified) (1 diff)
• userlist.php (modified) (1 diff)

trunk/action.php

@@ -8 +8 @@
   
   if(array_key_exists('search', $_GET)) $Search = $_GET['search'];
-  else $Search = $_POST['search'];
+  else if(array_key_exists('search', $_POST)) $Search = $_POST['search'];
+  else $Search = '';
 
   $Output = '<table class="BaseTable"><tr><th>Skupina</th><th>Výsledků</th></tr>';

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);

trunk/includes/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 540; // Subversion revision
+$Revision = 541; // Subversion revision
 $DatabaseRevision = 539; // Database structure revision 
-$ReleaseTime = '2013-05-18';
+$ReleaseTime = '2013-05-27';
 
 ?>

trunk/userlist.php

@@ -9 +9 @@
 if(array_key_exists('search', $_GET))
 {
-  $_SESSION['Where'] = ' WHERE `User`.`User` LIKE "%'.$_GET['search'].'%"'; 
+  $_SESSION['Where'] = ' WHERE `User`.`Name` LIKE "%'.$_GET['search'].'%"'; 
 }
 if(array_key_exists('team', $_GET))