Changeset 430 for trunk

Timestamp:

Apr 8, 2010, 8:39:54 PM (14 years ago)

Author:

george

Message:

• Opraveno: V nabídce alternativních překladů jiných nenabízej nenabízet nedokončené překlady.

File:

• trunk/TranslationList.php (modified) (1 diff)

trunk/TranslationList.php

@@ -265 +265 @@
   global $Table;
   
-  if(array_key_exists('ID', $_GET)) $Search = $_GET['ID'];
-  else if(array_key_exists('ID', $_POST)) $Search = $_POST['ID'];
+  if(array_key_exists('ID', $_GET) and is_numeric($_GET['ID'])) $Search = $_GET['ID'];
+  else if(array_key_exists('ID', $_POST) and is_numeric($_POST['ID'])) $Search = $_POST['ID'];
   else $Search = '';
  
-  $sql = 'SELECT *, (SELECT `User`.`Name` FROM `User` WHERE `User`.`ID` = `'.$Table.'`.`User`) AS `UserName` FROM `'.$Table.'` WHERE `Entry` LIKE "'.$Search.'"';
+  $sql = 'SELECT *, (SELECT `User`.`Name` FROM `User` WHERE `User`.`ID` = `'.$Table.'`.`User`) AS `UserName` FROM `'.$Table.'` WHERE (`Entry` LIKE "'.$Search.'")'.
+  ' AND ((`Language` = 0) OR ((`Complete` = 1) AND (`Language` != 0)))'; // Do not show uncompleted user translation
     
   WriteQuests($sql);