TYPO3 Core

* @package TYPO3

* @subpackage t3lib

*/

* @param string Table alias if any

* @return string WHERE clause for filtering out deleted records, eg " AND tablename.deleted=0"

*/

global $TCA;

return ' AND '.($tableAlias ? $tableAlias : $table).'.'.$TCA[$table]['ctrl']['delete'].'=0';

} else {

return '';

* @param boolean Use the deleteClause to check if a record is deleted (default true)

* @return array Returns the row if found, otherwise nothing

*/

$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(

$fields,

$table,

* @param boolean Use the deleteClause to check if a record is deleted (default true)

* @return array Returns the row if found, otherwise nothing

*/

if ($fields !== '*') {

$internalFields = t3lib_div::uniqueList($fields.',uid,pid'.($table == 'pages' ? ',t3ver_swapmode' : ''));

$row = t3lib_BEfunc::getRecord($table,$uid,$internalFields,$where,$useDeleteClause);

* @param string $fields is a list of fields to select, default is '*'

* @return array First row found, if any, FALSE otherwise

*/

$row = FALSE;

$row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res);

$GLOBALS['TYPO3_DB']->sql_free_result($res);

}

* @param boolean Use the deleteClause to check if a record is deleted (default true)

* @return mixed Multidimensional array with selected records (if any is selected)

*/

global $TCA;

if (is_array($TCA[$theTable])) {

$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(

$limit

);

$rows = array();

$rows[] = $row;

}

$GLOBALS['TYPO3_DB']->sql_free_result($res);

* @return string WHERE clause for search

* @deprecated Use $GLOBALS['TYPO3_DB']->searchQuery() directly!

*/

return $GLOBALS['TYPO3_DB']->searchQuery($searchWords,$fields,$table);

}

* @return string WHERE clause for a query

* @deprecated Use $GLOBALS['TYPO3_DB']->listQuery() directly!

*/

return $GLOBALS['TYPO3_DB']->listQuery($field,$value,'');

}

* @param string [tablename]_[uid] string to explode

* @return array

*/

list($uid,$table) = explode('_',strrev($str),2);

return array(strrev($table),strrev($uid));

}

* @param string $default_tablename denotes what table the number '45' is from (if nothing is prepended on the value)

* @return string List of ids

*/

$list = Array();

$tempItemArray = explode(',',trim($in_list));

$val = strrev($val);

$parts = explode('_',$val,2);

$theID = intval(strrev($parts[0]));

$theTable = trim($parts[1]) ? strrev(trim($parts[1])) : $default_tablename;

if ($theTable==$tablename) {$list[]=$theID;}

* @param boolean $inv means that the query will select all records NOT VISIBLE records (inverted selection)

* @return string WHERE clause part

*/

$ctrl = $GLOBALS['TCA'][$table]['ctrl'];

$query=array();

$invQuery=array();

$field = $table.'.'.$ctrl['enablecolumns']['disabled'];

$query[]=$field.'=0';

$invQuery[]=$field.'!=0';

$query[]=$field.'=0';

$invQuery[]=$field.'!=0';

}

$field = $table.'.'.$ctrl['enablecolumns']['starttime'];

$query[]='('.$field.'<='.$GLOBALS['SIM_ACCESS_TIME'].')';

$invQuery[]='('.$field.'!=0 AND '.$field.'>'.$GLOBALS['SIM_ACCESS_TIME'].')';

$query[]='('.$field.'<='.$GLOBALS['SIM_ACCESS_TIME'].')';

$invQuery[]='('.$field.'!=0 AND '.$field.'>'.$GLOBALS['SIM_ACCESS_TIME'].')';

}

$field = $table.'.'.$ctrl['enablecolumns']['endtime'];

$query[]='('.$field.'=0 OR '.$field.'>'.$GLOBALS['SIM_ACCESS_TIME'].')';

$invQuery[]='('.$field.'!=0 AND '.$field.'<='.$GLOBALS['SIM_ACCESS_TIME'].')';

* @deprecated

* @see t3lib_DB::exec_SELECT_mm_query()

*/

$query = $GLOBALS['TYPO3_DB']->SELECTquery(

$select,

$local_table.','.$mm_table.($foreign_table?','.$foreign_table:''),

* @return string Full SQL query for INSERT

* @deprecated

*/

return $GLOBALS['TYPO3_DB']->INSERTquery($table, $fields_values);

}

* @return string Full SQL query for UPDATE

* @deprecated

*/

return $GLOBALS['TYPO3_DB']->UPDATEquery($table, $where, $fields_values);

}

* @param boolean If true, version overlay is applied. This must be requested specifically because it is usually only wanted when the rootline is used for visual output while for permission checking you want the raw thing!

* @return array Root line array, all the way to the page tree root (or as far as $clause allows!)

*/

return $GLOBALS['T3_VAR']['BEgetRootLine_cache'][$uid][$clause][$workspaceOL?1:0];

}

$pid = $uid;

$loopCheck = 100;

$theRowArray = Array();

$output = Array();

$loopCheck--;

$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(

'pid,uid,title,TSconfig,is_siteroot,storage_pid,t3ver_oid,t3ver_wsid,t3ver_state,t3ver_swapmode,t3ver_stage',

t3lib_BEfunc::deleteClause('pages').' '.

$clause // whereClauseMightContainGroupOrderBy

);

debug($GLOBALS['TYPO3_DB']->sql_error(),1);

}

if($workspaceOL) t3lib_BEfunc::workspaceOL('pages',$row);

t3lib_BEfunc::fixVersioningPid('pages',$row);

$uid = $row['pid'];

$theRowArray[] = $row;

}

}

if ($uid==0) {$theRowArray[] = Array('uid'=>0,'title'=>'');}

reset($theRowArray);

$c=count($theRowArray);

$c--;

$output[$c]['uid'] = $val['uid'];

$output[$c]['pid'] = $val['pid'];

* @param boolean If set, then other open branches are closed.

* @return void

*/

global $BE_USER;

// Get current expansion data:

$expandedPages = array();

} else {

$expandedPages = unserialize($BE_USER->uc['browseTrees']['browsePages']);

// First, find out what mount index to use (if more than one DB mount exists):

$mountIndex = 0;

$mountKeys = array_flip($BE_USER->returnWebmounts());

$mountIndex = $mountKeys[$rLDat['uid']];

break;

}

}

// Traverse rootline and open paths:

$expandedPages[$mountIndex][$rLDat['uid']] = 1;

}

* @param integer Title limit of Full title (typ. set to 1000 or so)

* @return mixed Path of record (string) OR array with short/long title if $fullTitleLimit is set.

*/

if (!$titleLimit) { $titleLimit=1000; }

$loopCheck = 100;

$loopCheck = 100;

$output = $fullOutput = '/';

$loopCheck--;

$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(

'uid,pid,title,t3ver_oid,t3ver_wsid,t3ver_swapmode',

t3lib_BEfunc::deleteClause('pages').

(strlen(trim($clause)) ? ' AND '.$clause : '')

);

t3lib_BEfunc::workspaceOL('pages',$row);

t3lib_BEfunc::fixVersioningPid('pages',$row);

if ($row['_ORIG_pid'] && $row['t3ver_swapmode']>0) { // Branch points

}

}

return array($output, $fullOutput);

} else {

return $output;

*

* @return array Array of arrays with excludeFields (fieldname, table:fieldname) from all TCA entries

*/

global $TCA;

// All TCA keys:

$theExcludeArray = Array();

// All TCA keys:

$theExcludeArray = Array();

$tc_keys = array_keys($TCA);

// Load table

t3lib_div::loadTCA($table);

// All field names configured:

$f_keys = array_keys($TCA[$table]['columns']);

// Get Human Readable names of fields and table:

$Fname=$GLOBALS['LANG']->sl($TCA[$table]['ctrl']['title']).': '.$GLOBALS['LANG']->sl($TCA[$table]['columns'][$field]['label']);

// add entry:

*

* @return array Array with information from all of $TCA

*/

global $TCA;

// Initialize:

t3lib_div::loadTCA($table);

// All field names configured:

$f_keys = array_keys($TCA[$table]['columns']);

$fCfg = $TCA[$table]['columns'][$field]['config'];

if ($fCfg['type']=='select' && $fCfg['authMode']) {

if ($fCfg['type']=='select' && $fCfg['authMode']) {

// Check for items:

// Get Human Readable names of fields and table:

$allowDenyOptions[$table.':'.$field]['tableFieldLabel'] = $GLOBALS['LANG']->sl($TCA[$table]['ctrl']['title']).': '.$GLOBALS['LANG']->sl($TCA[$table]['columns'][$field]['label']);

$allowDenyOptions[$table.':'.$field]['tableFieldLabel'] = $GLOBALS['LANG']->sl($TCA[$table]['ctrl']['title']).': '.$GLOBALS['LANG']->sl($TCA[$table]['columns'][$field]['label']);

// Check for items:

if (strcmp($iVal[1],'')) { // Values '' is not controlled by this setting.

// Find iMode:

// Find iMode:

$iMode = '';

case 'explicitAllow':

$iMode = 'ALLOW';

break;

$iMode = 'DENY';

break;

case 'individual':

$iMode = 'ALLOW';

$iMode = 'DENY';

}

break;

}

// Set iMode:

$allowDenyOptions[$table.':'.$field]['items'][$iVal[1]] = array($iMode, $GLOBALS['LANG']->sl($iVal[0]), $adLabel[$iMode]);

}

}

*

* @return array Array with languages

*/

// Initialize, add default language:

$sysLanguages = array();

// Traverse languages

$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('uid,title,flag','sys_language','pid=0'.t3lib_BEfunc::deleteClause('sys_language'));

$sysLanguages[] = array($row['title'].' ['.$row['uid'].']', $row['uid'], ($row['flag'] ? 'flags/'.$row['flag'] : ''));

}

* @param string $perms_clause is typically a value generated with $BE_USER->getPagePermsClause(1);

* @return array Returns page record if OK, otherwise false.

*/

$id = intval($id);

$path = '/';

$pageinfo['_thePath'] = $path;

return $pageinfo;

}

} else {

$pageinfo = t3lib_BEfunc::getRecord('pages',$id,'*',($perms_clause ? ' AND '.$perms_clause : ''));

t3lib_BEfunc::workspaceOL('pages', $pageinfo);

t3lib_BEfunc::fixVersioningPid('pages', $pageinfo);

list($pageinfo['_thePath'],$pageinfo['_thePathFull']) = t3lib_BEfunc::getRecordPath(intval($pageinfo['uid']), $perms_clause, 15, 1000);

return $pageinfo;

* @param boolean If $useFieldNameAsKey is set, then the fieldname is associative keys in the return array, otherwise just numeric keys.

* @return array

*/

global $TCA;

t3lib_div::loadTCA($table);

$altFieldList = array();

// Traverse fields in types config and parse the configuration into a nice array:

list($pFieldName, $pAltTitle, $pPalette, $pSpec) = t3lib_div::trimExplode(';', $v);

$defaultExtras = is_array($TCA[$table]['columns'][$pFieldName]) ? $TCA[$table]['columns'][$pFieldName]['defaultExtras'] : '';

$specConfParts = t3lib_BEfunc::getSpecConfParts($pSpec, $defaultExtras);

'spec' => $specConfParts,

'origString' => $v

);

$altFieldList[$fieldList[$k]['field']] = $fieldList[$k];

}

}

$fieldList = $altFieldList;

}

* @return string Field value

* @see getTCAtypes()

*/

global $TCA;

// If no field-value, set it to zero. If there is no type matching the field-value (which now may be zero...) test field-value '1' as default.

// If no field-value, set it to zero. If there is no type matching the field-value (which now may be zero...) test field-value '1' as default.

t3lib_div::loadTCA($table);

$field = $TCA[$table]['ctrl']['type'];

$fieldValue = $field ? ($rec[$field] ? $rec[$field] : 0) : 0;

if (!is_array($TCA[$table]['types'][$fieldValue])) $fieldValue = 1;

* @param string The ['defaultExtras'] value from field configuration

* @return array

*/

// Add defaultExtras:

$specConfParts = t3lib_div::trimExplode(':', $defaultExtras.':'.$str, 1);

$specConfParts = t3lib_div::trimExplode(':', $defaultExtras.':'.$str, 1);

$reg = array();

unset($specConfParts[$k2]);

$specConfParts[trim($reg[1])] = array(

'parameters' => t3lib_div::trimExplode('|', $reg[2], 1)

);

* @param array Array of "[key]=[value]" strings to convert.

* @return array

*/

$out=array();

reset($pArr);

$parts=explode('=',$v,2);

$out[trim($parts[0])]=trim($parts[1]);

} else {

$out[$k]=$v;

* @return mixed If array, the data structure was found and returned as an array. Otherwise (string) it is an error message.

* @see t3lib_TCEforms::getSingleField_typeFlex()

*/

global $TYPO3_CONF_VARS;

// Get pointer field etc from TCA-config:

} else $srcPointer='default';

// Get Data Source: Detect if it's a file reference and in that case read the file and parse as XML. Otherwise the value is expected to be XML.

$file = t3lib_div::getFileAbsFileName(substr($ds_array[$srcPointer],5));

$dataStructArray = t3lib_div::xml2array(t3lib_div::getUrl($file));

} else $dataStructArray = 'The file "'.substr($ds_array[$srcPointer],5).'" in ds-array key "'.$srcPointer.'" was not found ("'.$file.'")'; // Error message.

} else {

$srcPointer = $row[$ds_pointerField];

// Searching recursively back if 'ds_pointerField_searchParent' is defined (typ. a page rootline, or maybe a tree-table):

$rr = t3lib_BEfunc::getRecord($table,$row['uid'],'uid,'.$ds_searchParentField); // Get the "pid" field - we cannot know that it is in the input record! ###NOTE_A###

t3lib_BEfunc::workspaceOL($table,$rr);

t3lib_BEfunc::fixVersioningPid($table,$rr,TRUE); // Added "TRUE" 23/03/06 before 4.0. (Also to similar call below!). Reason: When t3lib_refindex is scanning the system in Live workspace all Pages with FlexForms will not find their inherited datastructure. Thus all references from workspaces are removed! Setting TRUE means that versioning PID doesn't check workspace of the record. I can't see that this should give problems anywhere. See more information inside t3lib_refindex!

}

if (!is_array($rr) || isset($uidAcc[$rr['uid']])) break;

$uidAcc[$rr['uid']]=1;

t3lib_BEfunc::workspaceOL($table,$rr);

t3lib_BEfunc::fixVersioningPid($table,$rr,TRUE);

}

}

// If there is a srcPointer value:

if (t3lib_div::testInt($srcPointer)) { // If integer, then its a record we will look up:

list($tName,$fName) = explode(':',$ds_tableField,2);

$dataStructRec = t3lib_BEfunc::getRecord($tName, $srcPointer);

t3lib_BEfunc::workspaceOL($tName,$dataStructRec);

}

$dataStructArray = t3lib_div::xml2array($dataStructRec[$fName]);

} else $dataStructArray = 'No tablename ('.$tName.') or fieldname ('.$fName.') was found an valid!';

} else { // Otherwise expect it to be a file:

$file = t3lib_div::getFileAbsFileName($srcPointer);

$dataStructArray = t3lib_div::xml2array(t3lib_div::getUrl($file));

} else $dataStructArray='The file "'.$srcPointer.'" was not found ("'.$file.'")'; // Error message.

}

* @param string $ident is just a textual identification in order to inform about the content! May be 20 characters long.

* @return void

*/

$insertFields = array(

'hash' => $hash,

'content' => $data,

* @param integer $expTime represents the expire time in seconds. For instance a value of 3600 would allow cached content within the last hour, otherwise nothing is returned.

* @return string

*/

// if expTime is not set, the hash will never expire

$expTime = intval($expTime);

if ($expTime) {

* @return array Page TSconfig

* @see t3lib_TSparser

*/

$id=intval($id);

$rootLine = t3lib_BEfunc::BEgetRootLine($id,'',TRUE);

}

ksort($rootLine); // Order correctly

ksort($rootLine); // Order correctly

$TSdataArray = array();

$TSdataArray['defaultPageTSconfig']=$GLOBALS['TYPO3_CONF_VARS']['BE']['defaultPageTSconfig']; // Setting default configuration:

$TSdataArray['uid_'.$v['uid']]=$v['TSconfig'];

}

$TSdataArray = t3lib_TSparser::checkIncludeLines_array($TSdataArray);

return $TSdataArray;

}

$hash = md5('pageTS:'.$userTS);

$cachedContent = t3lib_BEfunc::getHash($hash,0);

$TSconfig = array();

$TSconfig = unserialize($cachedContent);

} else {

$parseObj = t3lib_div::makeInstance('t3lib_TSparser');

// get User TSconfig overlay

$userTSconfig = $GLOBALS['BE_USER']->userTS['page.'];

$TSconfig = t3lib_div::array_merge_recursive_overrule($TSconfig, $userTSconfig);

}

return $TSconfig;

* @internal

* @see implodeTSParams(), getPagesTSconfig()

*/

$id=intval($id);

$impParams =t3lib_BEfunc::implodeTSParams(t3lib_BEfunc::getPagesTSconfig($id));

}

reset($pageTS);

}

reset($pageTS);

$set=array();

$f = $TSconfPrefix.$f;

$set[$f]=trim($v);

}

}

// Get page record and TS config lines

$pRec = t3lib_befunc::getRecord('pages',$id);

$TSlines = explode(chr(10),$pRec['TSconfig']);

$TSlines = array_reverse($TSlines);

// Reset the set of changes.

reset($set);

reset($TSlines);

$inserted=0;

$TSlines[$ki]=$f.'='.$v;

$inserted=1;

break;

break;

}

}

$TSlines = array_reverse($TSlines);

$TSlines[]=$f.'='.$v;

$TSlines = array_reverse($TSlines);

* @param string Prefix string

* @return array Imploded TypoScript objectstring/values

*/

$implodeParams=array();

reset($p);

$implodeParams = array_merge($implodeParams,t3lib_BEfunc::implodeTSParams($val,$k.$kb));

} else {

$implodeParams[$k.$kb]=$val;

* @param string Optional $where clause (fx. "AND username='pete'") can be used to limit query

* @return array

*/

$be_user_Array=Array();

$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery($fields, 'be_users', 'pid=0 '.$where.t3lib_BEfunc::deleteClause('be_users'), '', 'username');

$be_user_Array[$row['uid']]=$row;

}

return $be_user_Array;

* @param string WHERE clause

* @return array

*/

$be_group_Array = Array();

$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery($fields, 'be_groups', 'pid=0 '.$where.t3lib_BEfunc::deleteClause('be_groups'), '', 'title');

$be_group_Array[$row['uid']] = $row;

}

return $be_group_Array;

* @param string Field list; $fields specify the fields selected (default: title,uid)

* @return array

*/

$exQ=' AND hide_in_lists=0';

$exQ.=' AND uid IN ('.($GLOBALS['BE_USER']->user['usergroup_cached_list']?$GLOBALS['BE_USER']->user['usergroup_cached_list']:0).')';

}

return t3lib_BEfunc::getGroupNames($fields,$exQ);

* @param boolean If $excludeBlindedFlag is set, then these records are unset from the array $usernames

* @return array User names, blinded

*/

$userN=$uid;

$set=0;

reset($groupArray);

$userN = $row['username'];

$set=1;

}

* @param boolean If $excludeBlindedFlag is set, then these records are unset from the array $usernames

* @return array

*/

$groupN=$uid;

$set=0;

$groupN=$row['title'];

$set=1;

}

* @param integer Time stamp, seconds

* @return integer

*/

$delta_t = $tstamp-$GLOBALS['EXEC_TIME'];

return ceil($delta_t/(3600*24));

}

* @param integer Time stamp, seconds

* @return string Formatted time

*/

return date($GLOBALS['TYPO3_CONF_VARS']['SYS']['ddmmyy'],$tstamp);

}

* @param integer Time stamp, seconds

* @return string Formatted time

*/

return date($GLOBALS['TYPO3_CONF_VARS']['SYS']['ddmmyy'].' '.$GLOBALS['TYPO3_CONF_VARS']['SYS']['hhmm'], $value);

}

* @param boolean Output hh:mm:ss. If false: hh:mm

* @return string Formatted time

*/

$hh = floor($value/3600);

$min = floor(($value-$hh*3600)/60);

$sec = $value-$hh*3600-$min*60;

$min = floor(($value-$hh*3600)/60);

$sec = $value-$hh*3600-$min*60;

$l = sprintf('%02d',$hh).':'.sprintf('%02d',$min);

$l .= ':'.sprintf('%02d',$sec);

}

return $l;

* @param string $labels should be something like ' min| hrs| days| yrs'. This value is typically delivered by this function call: $GLOBALS["LANG"]->sL("LLL:EXT:lang/locallang_core.php:labels.minutesHoursDaysYears")

* @return string Formatted time

*/

$labelArr = explode('|',$labels);

$prefix='';

if ($seconds<0) {$prefix='-'; $seconds=abs($seconds);}

$seconds = round ($seconds/60).' '.trim($labelArr[0]);

$seconds = round ($seconds/3600).' '.trim($labelArr[1]);

$seconds = round ($seconds/(24*3600)).' '.trim($labelArr[2]);

} else {

$seconds = round ($seconds/(365*24*3600)).' '.trim($labelArr[3]);

* @param string $date=="date" will yield "dd:mm:yy" formatting, otherwise "dd:mm:yy hh:mm"

* @return string

*/

return $tstamp ?

($date=='date' ? t3lib_BEfunc::date($tstamp) : t3lib_BEfunc::datetime($tstamp)).

' ('.t3lib_BEfunc::calcAge($prefix*(time()-$tstamp),$GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_core.php:labels.minutesHoursDaysYears')).')' : '';

* @return string

* @deprecated The idea made sense with older browsers, but now all browsers should support the "title" attribute - so just hardcode the title attribute instead!

*/

global $CLIENT;

$attrib= ($CLIENT['BROWSER']=='net'&&$CLIENT['VERSION']<5)||$CLIENT['BROWSER']=='konqu' ? 'alt' : 'title';

return strcmp($content,'')?' '.$attrib.'="'.($hsc?htmlspecialchars($content):$content).'"' : $attrib;

* @param string Value for 'alt' and 'title' attributes (will be htmlspecialchars()'ed before output)

* @return string

*/

$out='';

$out.=' alt="'.htmlspecialchars($content).'"';

$out.=' title="'.htmlspecialchars($content).'"';

* @param integer Optional: $size is [w]x[h] of the thumbnail. 56 is default.

* @return string Thumbnail image tag.

*/

global $TCA;

// Load table.

t3lib_div::loadTCA($table);

$uploaddir = preg_replace('#/$#','',$uploaddir);

// Set thumbs-script:

$thumbScript='gfx/notfound_thumb.gif';

$thumbScript='thumbs.php';

}

// Check and parse the size parameter

// Traverse files:

$thumbs = explode(',', $row[$field]);

$thumbData='';

$fI = t3lib_div::split_fileref($theFile);

$ext = $fI['fileext'];

// New 190201 start

if (is_array($imgInfo)) {$max = max($imgInfo[0],$imgInfo[1]);}

}

// use the original image if it's size fits to the thumbnail size

$theFile = $url = ($abs?'':'../').($uploaddir?$uploaddir.'/':'').trim($theFile);

$onClick = 'top.launchView(\''.$theFile.'\',\'\',\''.$backPath.'\');return false;';

$thumbData.= '<a href="#" onclick="'.htmlspecialchars($onClick).'"><img src="'.$backPath.$url.'" '.$imgInfo[3].' hspace="2" border="0" title="'.trim($url).'"'.$tparams.' alt="" /></a> ';

* @param integer $size is the size of the thumbnail send along to "thumbs.php"

* @return string Image tag

*/

$check = basename($theFile).':'.filemtime($theFile).':'.$GLOBALS['TYPO3_CONF_VARS']['SYS']['encryptionKey'];

$params = '&file='.rawurlencode($theFile);

$params.= trim($size)?'&size='.trim($size):'';

* @param boolean If $includeAttrib is set, then the 'title=""' attribute is wrapped about the return value, which is in any case htmlspecialchar()'ed already

* @return string

*/

global $TCA,$LANG;

$parts=array();

$parts[] = 'id='.$row['uid'];

if ($row['alias']) $parts[]=$LANG->sL($TCA['pages']['columns']['alias']['label']).' '.$row['alias'];

if ($row['pid']<0) $parts[] = 'v#1.'.$row['t3ver_id'];

case 1:

$parts[] = 'PLH WSID#'.$row['t3ver_wsid'];

break;

break;

}

$parts[]=$LANG->sL($TCA['pages']['columns']['url']['label']).' '.$row['url'];

$label = t3lib_BEfunc::getRecordPath(intval($row['shortcut']),$perms_clause,20);

} else {

$lRec = t3lib_BEfunc::getRecordWSOL('pages',intval($row['shortcut']),'title');

$lRec = t3lib_BEfunc::getRecordWSOL('pages',intval($row['shortcut']),'title');

$label = $lRec['title'];

}

$label.=', '.$LANG->sL($TCA['pages']['columns']['shortcut_mode']['label']).' '.

$LANG->sL(t3lib_BEfunc::getLabelFromItemlist('pages','shortcut_mode',$row['shortcut_mode']));

}

$LANG->sL(t3lib_BEfunc::getLabelFromItemlist('pages','shortcut_mode',$row['shortcut_mode']));

}

$parts[]=$LANG->sL($TCA['pages']['columns']['shortcut']['label']).' '.$label;

$label = t3lib_BEfunc::getRecordPath(intval($row['mount_pid']),$perms_clause,20);

} else {

$lRec = t3lib_BEfunc::getRecordWSOL('pages',intval($row['mount_pid']),'title');

$label = $lRec['title'];

}

$parts[]=$LANG->sL($TCA['pages']['columns']['mount_pid']['label']).' '.$label;

$parts[] = $LANG->sL($TCA['pages']['columns']['mount_pid_ol']['label']);

}

}

if ($row['hidden']) $parts[] = $LANG->sL('LLL:EXT:lang/locallang_core.php:labels.hidden');

if ($row['starttime']) $parts[] = $LANG->sL($TCA['pages']['columns']['starttime']['label']).' '.t3lib_BEfunc::dateTimeAge($row['starttime'],-1,'date');

if ($row['endtime']) $parts[] = $LANG->sL($TCA['pages']['columns']['endtime']['label']).' '.t3lib_BEfunc::dateTimeAge($row['endtime'],-1,'date');

$fe_groups = array();

$fe_groups[] = $LANG->sL(t3lib_BEfunc::getLabelFromItemlist('pages','fe_group',$fe_group));

} else {

$lRec = t3lib_BEfunc::getRecordWSOL('fe_groups',$fe_group,'title');

* @param string Table name

* @return string

*/

$out = t3lib_BEfunc::titleAttribForPages($row,'',0);

} else {

$ctrl = $GLOBALS['TCA'][$table]['ctrl']['enablecolumns'];

$ctrl = $GLOBALS['TCA'][$table]['ctrl']['enablecolumns'];

$out='id='.$row['uid']; // Uid is added

$out.=' / '.$row['alias'];

}

$out.=' - v#1.'.$row['t3ver_id'];

}

case 1:

$out.= ' - PLH WSID#'.$row['t3ver_wsid'];

break;

if ($ctrl['disabled']) { // Hidden ...

$out.=($row[$ctrl['disabled']]?' - '.$GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_core.php:labels.hidden'):'');

}

$out.=' - '.$GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_core.php:labels.starttime').':'.t3lib_BEfunc::date($row[$ctrl['starttime']]).' ('.t3lib_BEfunc::daysUntil($row[$ctrl['starttime']]).' '.$GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_core.php:labels.days').')';

}

}

$out.=' - '.$GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_core.php:labels.endtime').': '.t3lib_BEfunc::date($row[$ctrl['endtime']]).' ('.t3lib_BEfunc::daysUntil($row[$ctrl['endtime']]).' '.$GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_core.php:labels.days').')';

}

}

* @param string items-array value to match

* @return string Label for item entry

*/

global $TCA;

// Load full TCA for $table

t3lib_div::loadTCA($table);

t3lib_div::loadTCA($table);

// Check, if there is an "items" array:

// Traverse the items-array...

reset($TCA[$table]['columns'][$col]['config']['items']);

// ... and return the first found label where the value was equal to $key

if (!strcmp($v[1],$key)) return $v[0];

}

* @param string Wrap value - set function description

* @return string

*/

global $TCA;

// Load full TCA for $table

t3lib_div::loadTCA($table);

// Load full TCA for $table

t3lib_div::loadTCA($table);

// Check if column exists

// Re

return $TCA[$table]['columns'][$col]['label'];

}

$parts = explode('|',$printAllWrap);

return $parts[0].$col.$parts[1];

}

* @param boolean If set, the function always returns an output. If no value is found for the title, '[No title]' is returned (localized).

* @return string

*/

global $TCA;

if (is_array($TCA[$table])) {

if (is_array($TCA[$table])) {

// If configured, call userFunc

$params['table'] = $table;

$params['row'] = $row;

$params['title'] = '';

// No userFunc: Build label

$t = t3lib_BEfunc::getProcessedValue($table,$TCA[$table]['ctrl']['label'],$row[$TCA[$table]['ctrl']['label']],0,0,false,$row['uid'],$forceResult);

$altFields=t3lib_div::trimExplode(',',$TCA[$table]['ctrl']['label_alt'],1);

$tA=array();

if (!empty($t)) $tA[] = $t;

$t = trim(strip_tags($row[$fN]));

$t = t3lib_BEfunc::getProcessedValue($table,$fN,$t,0,0,false,$row['uid']);

break;

}

$tA[] = $t;

$tA[] = $t;

}

}

$t=implode(', ',$tA);

}

}

}

// If the current result is empty, set it to '[No title]' (localized) and prepare for output if requested

if ($prep) {

$t = t3lib_BEfunc::getRecordTitlePrep($t);

}

* @param integer $titleLength: Crop title after this length - if not set, BE_USER->uc['titleLen'] is used

* @return string The processed title string, wrapped in <span title="...">|</span> if cropped

*/

// If $titleLength is not a valid positive integer, use BE_USER->uc['titleLen']:

if (!$titleLength || !t3lib_div::testInt($titleLength) || $titleLength < 0) {

$titleLength = $GLOBALS['BE_USER']->uc['titleLen'];

* @param boolean $prep: Wrap result in <em>|</em>

* @return string Localized [No title] string

*/

$noTitle = '['.$GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_core.php:labels.no_title',1).']';

if ($prep) $noTitle = '<em>'.$noTitle.'</em>';

return $noTitle;

* @param boolean If t3lib_BEfunc::getRecordTitle is used to process the value, this parameter is forwarded.

* @return string

*/

global $TCA;

global $TYPO3_CONF_VARS;

// Load full TCA for $table

// Load full TCA for $table

t3lib_div::loadTCA($table);

// Check if table and field is configured:

// Depending on the fields configuration, make a meaningful output value.

$theColConf = $TCA[$table]['columns'][$col]['config'];

}

$l='';

case 'radio':

$l=t3lib_BEfunc::getLabelFromItemlist($table,$col,$value);

$l=$GLOBALS['LANG']->sL($l);

$l=$GLOBALS['LANG']->sL($l);

break;

case 'select':

// Display the title of MM related records in lists

$MMfield = $theColConf['foreign_table'].'.uid';

} else {

$MMfields = array($theColConf['foreign_table'].'.'.$TCA[$theColConf['foreign_table']]['ctrl']['label']);

$MMfields[] = $theColConf['foreign_table'].'.'.$f;

}

$MMfield = join(',',$MMfields);

$theColConf['foreign_table'],

'uid IN ('.implode(',', $selectUids).')'

);

$mmlA[] = ($noRecordLookup?$MMrow['uid']:t3lib_BEfunc::getRecordTitle($theColConf['foreign_table'], $MMrow, FALSE, $forceResult));

}

if (is_array($mmlA)) {

} else {

$l = t3lib_BEfunc::getLabelFromItemlist($table,$col,$value);

$l = $GLOBALS['LANG']->sL($l);

$l = $value;

} else {

$rParts = t3lib_div::trimExplode(',',$value,1);

$rParts = t3lib_div::trimExplode(',',$value,1);

reset($rParts);

$lA = array();

$rVal = intval($rVal);

if ($rVal>0) {

$r=t3lib_BEfunc::getRecordWSOL($theColConf['foreign_table'],$rVal);

} else {

$r=t3lib_BEfunc::getRecordWSOL($theColConf['neg_foreign_table'],-$rVal);

}

$lA[]=$GLOBALS['LANG']->sL($rVal>0?$theColConf['foreign_table_prefix']:$theColConf['neg_foreign_table_prefix']).t3lib_BEfunc::getRecordTitle($rVal>0?$theColConf['foreign_table']:$theColConf['neg_foreign_table'],$r,FALSE,$forceResult);

} else {

$lA[]=$rVal?'['.$rVal.'!]':'';

$l = implode(', ',t3lib_div::trimExplode(',',$value,1));

break;

case 'check':

$l = $value ? 'Yes' : '';

} else {

reset($theColConf['items']);

} else {

reset($theColConf['items']);

$lA=Array();

if ($value & pow(2,$key)) {$lA[]=$GLOBALS['LANG']->sL($val[0]);}

}

$l = implode(', ',$lA);

}

break;

case 'input':

$l = t3lib_BEfunc::date($value).' ('.(time()-$value>0?'-':'').t3lib_BEfunc::calcAge(abs(time()-$value), $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_core.php:labels.minutesHoursDaysYears')).')';

$l = t3lib_BEfunc::time($value, FALSE);

$l = t3lib_BEfunc::time($value);

$l = t3lib_BEfunc::datetime($value);

} else {

$l = $value;

$l = strip_tags($value);

break;

default:

$l=$value;

$l='N/A';

$l=t3lib_div::fixed_lgd_cs(strip_tags($value),200);

}

break;

}

}

return t3lib_div::fixed_lgd_cs($l,$fixed_lgd_chars);

} else {

return $l;

* @return string

* @see getProcessedValue()

*/

global $TCA;

$fVnew = t3lib_BEfunc::getProcessedValue($table,$fN,$fV,$fixed_lgd_chars,0,0,$uid,$forceResult);

$fVnew = t3lib_BEfunc::datetime($fV);

} elseif ($fN=='pid'){

$fVnew = t3lib_BEfunc::getRecordPath($fV,'1=1',20); // Fetches the path with no regard to the users permissions to select pages.

* @param string File extension, lowercase

* @return string File icon filename

*/

return $GLOBALS['FILEICONS'][$ext] ? $GLOBALS['FILEICONS'][$ext] : $GLOBALS['FILEICONS']['default'];

}

* @param array Preset fields (must include prefix if that is used)

* @return string List of fields.

*/

global $TCA;

$fields[] = $prefix.'uid';

$fields[] = $prefix.$TCA[$table]['ctrl']['label'];

$fields[] = $prefix.'uid';

$fields[] = $prefix.$TCA[$table]['ctrl']['label'];

$secondFields = t3lib_div::trimExplode(',',$TCA[$table]['ctrl']['label_alt'],1);

$fields[] = $prefix.$fieldN;

}

}

$fields[] = $prefix.'t3ver_id';

$fields[] = $prefix.'t3ver_state';

$fields[] = $prefix.'t3ver_wsid';

* @param string Prefix for formfields

* @return string HTML for a form.

*/

$params = $defaults;

reset($configArray);

$lines=array();

$lines[$fname]='<strong>'.htmlspecialchars($config[1]).'</strong><br />';

$lines[$fname].=$config[2].'<br />';

case 'string':

case 'short':

$formEl = '<input type="text" name="'.$dataPrefix.'['.$fname.']" value="'.$params[$fname].'"'.$GLOBALS['TBE_TEMPLATE']->formWidth($config[0]=='short'?24:48).' />';

case 'select':

reset($config[3]);

$opt=array();

$opt[]='<option value="'.htmlspecialchars($k).'"'.($params[$fname]==$k?' selected="selected"':'').'>'.htmlspecialchars($v).'</option>';

}

$formEl = '<select name="'.$dataPrefix.'['.$fname.']">'.implode('',$opt).'</select>';

* @param boolean Force display of icon nomatter BE_USER setting for help

* @return string HTML content for a help icon/text

*/

global $TCA_DESCR,$BE_USER;

$onClick = 'vHWin=window.open(\''.$BACK_PATH.'view_help.php?tfID='.($table.'.'.$field).'\',\'viewFieldHelp\',\'height=400,width=600,status=0,menubar=0,scrollbars=1\');vHWin.focus();return false;';

* @param string DEPRECATED: Additional style-attribute content for wrapping table (now: only in function cshItem needed)

* @return string HTML content for help text

*/

global $TCA_DESCR,$BE_USER;

$output = '';

$data = $TCA_DESCR[$table]['columns'][$field];

// add see also arrow

$arrow = '<img'.t3lib_iconWorks::skinImg($BACK_PATH,'gfx/rel_db.gif','width="13" height="12"').' class="absmiddle" alt="" />';

}

// add description text

* @return string HTML content for help text

* @see helpText(), helpTextIcon()

*/

global $TCA_DESCR, $LANG, $BE_USER;

$LANG->loadSingleTableDescription($table);

// Creating CSH icon and short description:

$fullText = t3lib_BEfunc::helpText($table,$field,$BACK_PATH,'');

$icon = t3lib_BEfunc::helpTextIcon($table,$field,$BACK_PATH);

} else {

$output = $icon;

$wrParts = explode('|',$wrap);

$output = $wrParts[0].$output.$wrParts[1];

}

* @return string

* @see template::issueCommand()

*/

$retUrl = 'returnUrl='.($requestUri==-1?"'+T3_THIS_LOCATION+'":rawurlencode($requestUri?$requestUri:t3lib_div::getIndpEnv('REQUEST_URI')));

return "window.location.href='".$backPath."alt_doc.php?".$retUrl.$params."'; return false;";

}

* @param boolean If true, then the preview window will gain the focus.

* @return string

*/

$url = $altUrl;

} else {