Changeset 431 for trunk/TranslationList.php

Timestamp:

Apr 8, 2010, 8:49:29 PM (14 years ago)

Author:

george

Message:

• Opraveno: Zobrazovat v nabídce ostatních variant překladů jen dokončené a nezobrazovat vlastní překlad.

File:

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

trunk/TranslationList.php

@@ -263 +263 @@
 function SearchEntry()
 {
-  global $Table;
+  global $Table, $System;
   
   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.'")'.
-  ' AND ((`Language` = 0) OR ((`Complete` = 1) AND (`Language` != 0)))'; // Do not show uncompleted user translation
+  else ErrorMessage('Nebylo zadáno ID položky');
+  
+  $DbResult = $System->Database->query('SELECT `Entry` FROM `'.$Table.'` WHERE `ID`='.$Search);
+  if($DbResult->num_rows > 0)
+  { 
+    $DbRow = $DbResult->fetch_assoc();
+    $sql = 'SELECT *, (SELECT `User`.`Name` FROM `User` WHERE `User`.`ID` = `'.$Table.'`.`User`) AS `UserName` FROM `'.$Table.'` WHERE (`Entry` = '.$DbRow['Entry'].')'.
+  ' AND (`Complete` = 1) AND (`Language` != 0) AND (`ID` != '.$Search.')'; // Do not show uncompleted user translation
     
-  WriteQuests($sql);
+    WriteQuests($sql);
+  } else echo('Položka nenalezena');
 }