Changeset 641 for trunk/includes/global.php

Timestamp:

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

Author:

maron

Message:

• Added: Last translate name shown at form

File:

• trunk/includes/global.php (modified) (2 diffs)

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);