Changeset 287

Timestamp:

Dec 22, 2009, 10:40:43 AM (14 years ago)

Author:

george

Message:

• Opraveno: Kontrola zaslání položek formuláře při zadávání slov ve slovníku.

Location:

trunk

Files:

• TranslationList.php (modified) (2 diffs)
• dictionary.php (modified) (1 diff)

trunk/TranslationList.php

@@ -205 +205 @@
   
   $WhereUsers = '';    
-  for($i = 0; $i < Count($users); $i++)
-  {
-    if($WhereUsers <> '') $WhereUsers .= ' OR `User` = '.$users[$i];
-      else $WhereUsers .= ' `User` = '.$users[$i];
-  }
-  if($WhereUsers == '') $WhereUsers = '0';
-  
+  foreach($users as $Index => $User)
+  {
+    if($WhereUsers <> '') $WhereUsers .= ' OR `User` = '.$User;
+      else $WhereUsers .= ' `User` = '.$User;
+  }
+  if($WhereUsers == '') $WhereUsers = '0';  
   
   WriteQuests('SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` WHERE '.$WhereUsers, '', 'users');
@@ -317 +316 @@
 {
   if(array_key_exists('ID', $_GET)) $Search = $_GET['ID'];
-  else $Search = $_POST['ID'];
+  else if(array_key_exists('ID', $_POST)) $Search = $_POST['ID'];
+  else $Search = '';
  
   $sql = 'SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` WHERE `entry` LIKE "'.$Search.'"';

trunk/dictionary.php

@@ -142 +142 @@
     if(($_GET['action'] == 'save') and Licence(LICENCE_USER))
     {
-      $DbResult = $Database->SQLCommand('SELECT * FROM `dictionary` WHERE `Text` = "'.$_POST['Original'].'" AND Language=0');
-      if(mysql_num_rows($DbResult) > 0)
-      {
-        $DbRow = mysql_fetch_assoc($DbResult);
-        $Entry = $DbRow['Entry'];
-      } else 
-      {
-        $DbResult = $Database->SQLCommand('SELECT MAX(Entry) FROM dictionary');
-        $DbRow = mysql_fetch_row($DbResult);
-        $Entry = $DbRow[0] + 1;
-        $Database->SQLCommand('INSERT INTO `dictionary` ( `Text` , `Entry` , `Description` , `User`, `Language` ) VALUES ("'.$_POST['Original'].'", "'.$Entry.'", "", 0, 0);');
-      }
+      if(array_key_exists('Original', $_POST) and array_key_exists('Translated', $_POST) and array_key_exists('Description', $_POST))
+      {       
+        $DbResult = $Database->SQLCommand('SELECT * FROM `dictionary` WHERE `Text` = "'.$_POST['Original'].'" AND Language=0');
+        if(mysql_num_rows($DbResult) > 0)
+        {
+          $DbRow = mysql_fetch_assoc($DbResult);
+          $Entry = $DbRow['Entry'];
+        } else 
+        {
+          $DbResult = $Database->SQLCommand('SELECT MAX(Entry) FROM dictionary');
+          $DbRow = mysql_fetch_row($DbResult);
+          $Entry = $DbRow[0] + 1;
+          $Database->SQLCommand('INSERT INTO `dictionary` ( `Text` , `Entry` , `Description` , `User`, `Language` ) VALUES ("'.$_POST['Original'].'", "'.$Entry.'", "", 0, 0);');
+        }
       
-      $DbResult = $Database->SQLCommand('SELECT Id FROM `dictionary` WHERE `Entry` = '.$Entry.' AND Language='.$_SESSION['language'].' AND User='.$_SESSION['UserID']);
-      if(mysql_num_rows($DbResult) > 0)
-      {
-        $DbRow = mysql_fetch_assoc($DbResult);
-        $Database->SQLCommand('UPDATE `dictionary` SET `Text`="'.$_POST['Translated'].'", `Description` = "'.$_POST['Description'].'" WHERE Id='.$DbRow['Id']);
-      } else      
-        $Database->SQLCommand('INSERT INTO `dictionary` ( `Text` , `Entry` , `Description` , `User`, `Language` ) VALUES ("'.$_POST['Translated'].'", "'.$Entry.'", "'.$_POST['Description'].'", '.$_SESSION['UserID'].', '.$_SESSION['language'].')');
-      echo('Záznam byl uložen!');
+        $DbResult = $Database->SQLCommand('SELECT Id FROM `dictionary` WHERE `Entry` = '.$Entry.' AND Language='.$_SESSION['language'].' AND User='.$_SESSION['UserID']);
+        if(mysql_num_rows($DbResult) > 0)
+        {
+          $DbRow = mysql_fetch_assoc($DbResult);
+          $Database->SQLCommand('UPDATE `dictionary` SET `Text`="'.$_POST['Translated'].'", `Description` = "'.$_POST['Description'].'" WHERE Id='.$DbRow['Id']);
+        } else      
+          $Database->SQLCommand('INSERT INTO `dictionary` ( `Text` , `Entry` , `Description` , `User`, `Language` ) VALUES ("'.$_POST['Translated'].'", "'.$Entry.'", "'.$_POST['Description'].'", '.$_SESSION['UserID'].', '.$_SESSION['language'].')');
+        echo('Záznam byl uložen!');
+      } else echo('Nebyly zaslány všechny položky formuláře.');
     } else
     if(($_GET['action'] == 'remove') and Licence(LICENCE_USER))