Changeset 432 for trunk

Timestamp:

Apr 8, 2010, 8:58:16 PM (15 years ago)

Author:

george

Message:

• Upraveno: Raději zobrazovat ve verzích nejen verze ostatních, ale i vlastní.

Location:

trunk

Files:

• TranslationList.php (modified) (1 diff)
• form.php (modified) (3 diffs)

trunk/TranslationList.php

@@ -274 +274 @@
     $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
+  ' AND (`Complete` = 1) AND (`Language` != 0)'; // Do not show uncompleted user translation
     
     WriteQuests($sql);

trunk/form.php

@@ -34 +34 @@
   if(!$Line) ErrorMessage('Překlad nenalezen.');
     
-  $DbResult = $Database->SQLCommand('SELECT * FROM `'.$Table.'` WHERE `Language` = 0  AND `Entry` = '.$Line['Entry'].' AND `VersionEnd` = '.$Line['VersionEnd'].' LIMIT 1');
+  $DbResult = $Database->SQLCommand('SELECT * FROM `'.$Table.'` WHERE (`Language` = 0) AND (`Entry` = '.$Line['Entry'].') AND (`VersionEnd` = '.$Line['VersionEnd'].') LIMIT 1');
   $LineAJ = mysql_fetch_assoc($DbResult);
   if(!$Line) ErrorMessage('Anglický originál k překladu nenalezen.');
@@ -63 +63 @@
   echo('<br />');
    
-  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `'.$Table.'` WHERE (`Entry` = '.$Line['Entry'].') AND (`Language` <> 0) AND (`Complete` = 1) AND (`ID` <> '.$Line['ID'].')');
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `'.$Table.'` WHERE (`Entry` = '.$Line['Entry'].') AND (`Language` <> 0) AND (`Complete` = 1)');
   $Version = mysql_fetch_row($DbResult);
   $Version = $Version[0];
@@ -88 +88 @@
   } else
   {
-    echo('<a href="TranslationList.php?group='.$GroupId.'&amp;action=searchentry&amp;ID='.$Line['Entry'].'">Počet verzí: <strong>'.$Version.'</strong></a>'); 
+    echo('<a href="TranslationList.php?group='.$GroupId.'&amp;action=searchentry&amp;ID='.$Line['ID'].'">Počet verzí: <strong>'.$Version.'</strong></a>'); 
   }