TYPO3 Core

Forgot to mention how to test it.

1) Insert the TS in setup, then clear cache and view page in FE.
Notice that the 2nd value is numeric, which is wrong.

2) Then move to another page, and you'll see that the 2nd parameter is now correctly displayed as a text.

Solution:
Change the function "loadTCA" in the file "\typo3\sysext\cms\tslib\class.tslib_fe.php", from:

-- cut --
function includeTCA($TCAloaded=1) {
global $TCA, $PAGES_TYPES, $LANG_GENERAL_LABELS, $TBE_MODULES;
if (!$this->TCAloaded) {
$TCA = Array();
include (TYPO3_tables_script ? PATH_typo3conf.TYPO3_tables_script : PATH_t3lib.'stddb/tables.php');
// Extension additions
if ($GLOBALS['TYPO3_LOADED_EXT']['_CACHEFILE']) {
include(PATH_typo3conf.$GLOBALS['TYPO3_LOADED_EXT']['_CACHEFILE'].'_ext_tables.php');
} else {
include(PATH_t3lib.'stddb/load_ext_tables.php');
}
// ext-script
if (TYPO3_extTableDef_script) {
include (PATH_typo3conf.TYPO3_extTableDef_script);
}
$this->TCAloaded = $TCAloaded;
}
}
-- cut --

into:

-- cut --
function includeTCA($TCAloaded=1) {
global $TCA, $PAGES_TYPES, $LANG_GENERAL_LABELS, $TBE_MODULES;
if (!$this->TCAloaded) {
$TCA = Array();
include (TYPO3_tables_script ? PATH_typo3conf.TYPO3_tables_script : PATH_t3lib.'stddb/tables.php');
// Extension additions
if ($GLOBALS['TYPO3_LOADED_EXT']['_CACHEFILE']) {
include(PATH_typo3conf.$GLOBALS['TYPO3_LOADED_EXT']['_CACHEFILE'].'_ext_tables.php');
} else {
include(PATH_t3lib.'stddb/load_ext_tables.php');
}
// ext-script
if (TYPO3_extTableDef_script) {
include (PATH_typo3conf.TYPO3_extTableDef_script);
}
reset($TCA);
while(list($table)=each($TCA)) {
t3lib_div::loadTCA($table);
}
$this->TCAloaded = $TCAloaded;
}
}
-- cut --

Hallo,

just for info: problem still resides - found it in version 4.2.9.

But I suggest applying t3lib_div::loadTCA() for all table may result in performance problem.

Why not only loading required table?

\typo3\sysext\cms\tslib\class.tslib_content.php:

-- cut --
function TCAlookup($inputValue,$conf) {
global $TCA;

$table = $conf['table'];
        $field = $conf['field'];
        $delimiter = $conf['delimiter']?$conf['delimiter']:' ,';

$GLOBALS['TSFE']->includeTCA();

// --- start modification ---
               if (is_array($TCA[$table])) {
                       t3lib_div::loadTCA($table);
               }
               // --- end modification ---

if (is_array($TCA[$table]) && is_array($TCA[$table]['columns'][$field]) && is_array($TCA[$table]['columns'][$field]['config']['items'])) {
            $values = t3lib_div::trimExplode(',',$inputValue);
            $output = array();
            foreach ($values as $value) {
                    // Traverse the items-array...
                reset($TCA[$table]['columns'][$field]['config']['items']);
                while (list($key,$item)=each($TCA[$table]['columns'][$field]['config']['items'])) {
                        // ... and return the first found label where the value was equal to $key
                    if (!strcmp($item[1],trim($value))) {
                        $output[] = $GLOBALS['TSFE']->sL($item[0]);
                    }
                }
            }
            $returnValue = implode($delimiter,$output);
        } else {
            $returnValue = $inputValue;
        }
        return $returnValue;
    }
-- cut --