Index: branches/5.1.x/units/currencies/currencies_config.php =================================================================== diff -u -r13100 -r13147 --- branches/5.1.x/units/currencies/currencies_config.php (.../currencies_config.php) (revision 13100) +++ branches/5.1.x/units/currencies/currencies_config.php (.../currencies_config.php) (revision 13147) @@ -1,6 +1,6 @@ Array (), - 'ListSQLs' => Array ( ''=> 'SELECT %1$s.*, - phr.Translation - FROM %1$s - LEFT JOIN '.TABLE_PREFIX.'Phrase phr ON - %1$s.Name = phr.Phrase'), - // key - special, value - list select sql - 'ItemSQLs' => Array ( ''=> 'SELECT * FROM %s'), + 'ListSQLs' => Array ( + '' => ' SELECT %1$s.* %2$s + FROM %1$s + LEFT JOIN '.TABLE_PREFIX.'Phrase phr ON %1$s.Name = phr.Phrase' + ), - 'CalculatedFields' => Array ( - '' => Array ( - 'Translation' => 'phr.Translation', - ), - ), + 'CalculatedFields' => Array ( + '' => Array ( + 'Translation' => 'phr.l%4$s_Translation', + ), + ), 'ListSortings' => Array ( '' => Array ( @@ -116,9 +114,10 @@ 'Priority' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0), ), - 'VirtualFields' => Array ( - 'Translation' => Array ('type' => 'string'), - ), + 'VirtualFields' => Array ( + 'Translation' => Array ('type' => 'string', 'default' => ''), + ), + 'Grids' => Array ( 'Default' => Array ( 'Icons' => Array (