Ignore:
Timestamp:
Dec 12, 2013, 10:04:28 AM (11 years ago)
Author:
maron
Message:
  • Added: Last translate name shown at form
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/includes/global.php

    r636 r641  
    548548  foreach($TablesColumn as $Table => $Column)
    549549  { 
     550    $orderinby = ' ORDER BY ID DESC ';
    550551    $sql = 'SELECT `ID`, (SELECT CONCAT(  \''.GetIDbyName($Table).'\' )) AS  `GoupId`,`'.$Column.'` AS Orig, (SELECT `'.$Column.'` FROM `'.$Table.'` AS `T` WHERE '.
    551       '(`O`.`Entry` = `T`.`Entry`) AND (`Language` <> '.$Config['OriginalLanguage'].') LIMIT 1) AS `Tran` FROM `'.$Table.'` AS `O` WHERE ';
     552      '(`O`.`Entry` = `T`.`Entry`) AND (`Language` <> '.$Config['OriginalLanguage'].') '.$orderinby.' LIMIT 1) AS `Tran` FROM `'.$Table.'` AS `O` WHERE ';
    552553    $groupby = ' GROUP BY `'.$Column.'` ';
    553     $orderby = ' ORDER BY LENGTH(Orig) DESC ';
    554554
    555555    $where = '(`Language` = '.$Config['OriginalLanguage'].') ';
     
    582582  }   
    583583    if ($SqlOK) {
     584        $orderby = ' ORDER BY LENGTH(Orig) DESC ';
    584585        $DbResult = $System->Database->query($sqlall.$orderby);
    585586    //  echo ($sql.'|'.$where.'|'.$groupby);
Note: See TracChangeset for help on using the changeset viewer.