Changeset 641

Timestamp:

Dec 12, 2013, 10:04:28 AM (11 years ago)

Author:

maron

Message:

• Added: Last translate name shown at form

Location:

trunk/includes

Files:

• Version.php (modified) (1 diff)
• global.php (modified) (2 diffs)

trunk/includes/Version.php

@@ -6 +6 @@
 // and system will need database update. 
 
-$Revision = 639; // Subversion revision
+$Revision = 641; // Subversion revision
 $DatabaseRevision = 610; // Database structure revision 
-$ReleaseTime = '2013-12-11';
+$ReleaseTime = '2013-12-12';

trunk/includes/global.php

@@ -548 +548 @@
   foreach($TablesColumn as $Table => $Column) 
   {  
+    $orderinby = ' ORDER BY ID DESC ';
     $sql = 'SELECT `ID`, (SELECT CONCAT(  \''.GetIDbyName($Table).'\' )) AS  `GoupId`,`'.$Column.'` AS Orig, (SELECT `'.$Column.'` FROM `'.$Table.'` AS `T` WHERE '.
-      '(`O`.`Entry` = `T`.`Entry`) AND (`Language` <> '.$Config['OriginalLanguage'].') LIMIT 1) AS `Tran` FROM `'.$Table.'` AS `O` WHERE ';
+      '(`O`.`Entry` = `T`.`Entry`) AND (`Language` <> '.$Config['OriginalLanguage'].') '.$orderinby.' LIMIT 1) AS `Tran` FROM `'.$Table.'` AS `O` WHERE ';
     $groupby = ' GROUP BY `'.$Column.'` ';
-    $orderby = ' ORDER BY LENGTH(Orig) DESC ';
 
     $where = '(`Language` = '.$Config['OriginalLanguage'].') ';
@@ -582 +582 @@
   }    
     if ($SqlOK) {
+        $orderby = ' ORDER BY LENGTH(Orig) DESC ';
         $DbResult = $System->Database->query($sqlall.$orderby);
     //  echo ($sql.'|'.$where.'|'.$groupby);