Changeset 428 for trunk

Timestamp:

Apr 8, 2010, 8:12:13 PM (14 years ago)

Author:

george

Message:

• Opraveno: Řazení výsledků ve výpise nejnovějších překladů na hlavní stránce.
• Opraveno: Aktualizace času úpravy pouze při změně textů.

Location:

trunk

Files:

• index.php (modified) (1 diff)
• save.php (modified) (4 diffs)
• sql/updates/428.sql (added)

trunk/index.php

@@ -30 +30 @@
   {
     //echo($DbRow['Name'].', ');
-    $UnionItems[] = 'SELECT `T`.`User`, `T`.`ID`, `T`.`ModifyTime`, '.$DbRow['Id'].' AS `Group`, "'.addslashes($DbRow['Name']).'" AS `GroupName`, `T`.`Take` FROM `'.$DbRow['TablePrefix'].'` AS `T`'.
-    ' WHERE (`T`.`Complete` = 1) AND (`T`.`Language` != 0) LIMIT '.$Count;
+    $UnionItems[] = 'SELECT * FROM(SELECT `T`.`User`, `T`.`ID`, `T`.`ModifyTime`, '.$DbRow['Id'].' AS `Group`, "'.addslashes($DbRow['Name']).'" AS `GroupName`, `T`.`Take` FROM `'.$DbRow['TablePrefix'].'` AS `T`'.
+    ' WHERE (`T`.`Complete` = 1) AND (`T`.`Language` != 0) ORDER BY `T`.`ModifyTime` DESC LIMIT '.$Count.') AS `T`';
   }
   $Query = 'SELECT `TT`.*, `User`.`Name` AS `UserName` FROM ('.implode(' UNION ', $UnionItems).') AS `TT`'.

trunk/save.php

@@ -49 +49 @@
           if($DbResult2->num_rows > 0)
           {
+            // Update existed user translation
             $ExistedText = $DbResult2->fetch_assoc();
-            $Values = '`Language` = '.$Language.', `ModifyTime` = NOW()';
-            
+            $Values = '`Language` = '.$Language;
+            
+            $UpdateModifyTime = false;
             $Completable = true;
             $CompleteParts = $ExistedText['CompleteParts'];
@@ -58 +60 @@
               if($GroupItem['Visible'] == 1)
               {
+                if($SourceText[$GroupItem['Column']] != $ExistedText[$GroupItem['Column']]) 
+                  $UpdateModifyTime = true;
+                
                 if($EnglishFound[$GroupItem['Column']] == $EnglishText[$GroupItem['Column']])
+                {
                   if(array_key_exists($GroupItem['Column'], $_POST))
                   {
@@ -64 +70 @@
                     $CompleteParts |= (1 << ($GroupItem['Sequence'] - 1));
                   }
+                } 
                 if((($CompleteParts & (1 << ($GroupItem['Sequence'] - 1))) == 0) and ($EnglishFound[$GroupItem['Column']] != '')) $Completable = false;
               }
@@ -79 +86 @@
             }
             $Values .= ', `Complete`='.$NewComplete.', `CompleteParts` = '.$CompleteParts;
+            
+            if($UpdateModifyTime) $Values .= ', `ModifyTime` = NOW()';
             
             // Update user translation