Index: t3lib/class.t3lib_admin.php
===================================================================
--- t3lib/class.t3lib_admin.php (revision 8742)
+++ t3lib/class.t3lib_admin.php (revision )
@@ -1,29 +1,29 @@
array(),
'published_versions' => array(),
'deleted' => array(),
);
- var $lRecords = Array();
+ var $lRecords = array();
var $lostPagesList = '';
@@ -125,21 +107,21 @@
* @param boolean Internal variable, don't set from outside!
* @return void
*/
- function genTree($theID, $depthData, $versions=FALSE) {
+ function genTree($theID, $depthData, $versions = FALSE) {
- if ($versions) {
+ if ($versions) {
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
- 'uid,title,doktype,deleted,t3ver_wsid,t3ver_id,t3ver_count,t3ver_swapmode'.(t3lib_extMgm::isLoaded('cms')?',hidden':''),
+ 'uid,title,doktype,deleted,t3ver_wsid,t3ver_id,t3ver_count,t3ver_swapmode' . (t3lib_extMgm::isLoaded('cms') ? ',hidden' : ''),
'pages',
- 'pid=-1 AND t3ver_oid='.intval($theID).' '.((!$this->genTree_includeDeleted)?'AND deleted=0':'').$this->perms_clause,
+ 'pid=-1 AND t3ver_oid=' . intval($theID) . ' ' . ((!$this->genTree_includeDeleted) ? 'AND deleted=0' : '') . $this->perms_clause,
'',
'sorting'
);
} else {
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
- 'uid,title,doktype,deleted'.(t3lib_extMgm::isLoaded('cms')?',hidden':''),
+ 'uid,title,doktype,deleted' . (t3lib_extMgm::isLoaded('cms') ? ',hidden' : ''),
'pages',
- 'pid='.intval($theID).' '.((!$this->genTree_includeDeleted)?'AND deleted=0':'').$this->perms_clause,
+ 'pid=' . intval($theID) . ' ' . ((!$this->genTree_includeDeleted) ? 'AND deleted=0' : '') . $this->perms_clause,
'',
'sorting'
);
@@ -148,50 +130,58 @@
// Traverse the records selected:
$a = 0;
$c = $GLOBALS['TYPO3_DB']->sql_num_rows($res);
- while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
+ while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
// Prepare the additional label used in the HTML output in case of versions:
- if ($versions) {
+ if ($versions) {
- $versionLabel = '[v1.'.$row['t3ver_id'].'; WS#'.$row['t3ver_wsid'].']';
+ $versionLabel = '[v1.' . $row['t3ver_id'] . '; WS#' . $row['t3ver_wsid'] . ']';
- } else $versionLabel='';
+ } else {
+ $versionLabel = '';
+ }
$a++;
$newID = $row['uid'];
// Build HTML output:
- if ($this->genTree_makeHTML) {
+ if ($this->genTree_makeHTML) {
- $this->genTree_HTML.=LF.'
';
+ $this->genTree_HTML .= LF . '';
$PM = 'join';
- $LN = ($a==$c)?'blank':'line';
+ $LN = ($a == $c) ? 'blank' : 'line';
- $BTM = ($a==$c)?'bottom':'';
+ $BTM = ($a == $c) ? 'bottom' : '';
- $this->genTree_HTML.= $depthData.
+ $this->genTree_HTML .= $depthData .
- 'backPath,'gfx/ol/'.$PM.$BTM.'.gif','width="18" height="16"').' align="top" alt="" />'.
+ 'backPath, 'gfx/ol/' . $PM . $BTM . '.gif', 'width="18" height="16"') . ' align="top" alt="" />' .
- $versionLabel.
+ $versionLabel .
- t3lib_iconWorks::getSpriteIconForRecord('pages', $row) .
+ t3lib_iconWorks::getSpriteIconForRecord('pages', $row) .
- htmlspecialchars($row['uid'].': '.t3lib_div::fixed_lgd_cs(strip_tags($row['title']),50)).' ';
+ htmlspecialchars($row['uid'] . ': ' . t3lib_div::fixed_lgd_cs(strip_tags($row['title']), 50)) . ' ';
}
// Register various data for this item:
- $this->page_idArray[$newID]=$row;
+ $this->page_idArray[$newID] = $row;
$this->recStats['all_valid']['pages'][$newID] = $newID;
-# if ($versions) $this->recStats['versions']['pages'][$newID] = $newID;
+ # if ($versions) $this->recStats['versions']['pages'][$newID] = $newID;
- if ($row['deleted']) $this->recStats['deleted']['pages'][$newID] = $newID;
+ if ($row['deleted']) {
+ $this->recStats['deleted']['pages'][$newID] = $newID;
+ }
- if ($versions && $row['t3ver_count']>=1) {
+ if ($versions && $row['t3ver_count'] >= 1) {
$this->recStats['published_versions']['pages'][$newID] = $newID;
}
- if ($row['deleted']) {$this->recStat['deleted']++;}
- if ($row['hidden']) {$this->recStat['hidden']++;}
+ if ($row['deleted']) {
+ $this->recStat['deleted']++;
+ }
+ if ($row['hidden']) {
+ $this->recStat['hidden']++;
+ }
$this->recStat['doktype'][$row['doktype']]++;
// Create the HTML code prefix for recursive call:
- $genHTML = $depthData.'backPath,'gfx/ol/'.$LN.'.gif','width="18" height="16"').' align="top" alt="" />'.$versionLabel;
+ $genHTML = $depthData . 'backPath, 'gfx/ol/' . $LN . '.gif', 'width="18" height="16"') . ' align="top" alt="" />' . $versionLabel;
// If all records should be shown, do so:
- if ($this->genTree_includeRecords) {
+ if ($this->genTree_includeRecords) {
- foreach($GLOBALS['TCA'] as $tableName => $cfg) {
+ foreach ($GLOBALS['TCA'] as $tableName => $cfg) {
- if ($tableName!='pages') {
+ if ($tableName != 'pages') {
$this->genTree_records($newID, $this->genTree_HTML ? $genHTML : '', $tableName);
}
}
@@ -201,7 +191,7 @@
$this->genTree($newID, $this->genTree_HTML ? $genHTML : '');
// If versions are included in the tree, add those now:
- if ($this->genTree_includeVersions) {
+ if ($this->genTree_includeVersions) {
$this->genTree($newID, $this->genTree_HTML ? $genHTML : '', TRUE);
}
}
@@ -214,70 +204,73 @@
* @param [type] $versions: ...
* @return [type] ...
*/
- function genTree_records($theID, $depthData, $table='', $versions=FALSE) {
+ function genTree_records($theID, $depthData, $table = '', $versions = FALSE) {
global $TCA;
- if ($versions) {
+ if ($versions) {
// Select all records from table pointing to this page:
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
t3lib_BEfunc::getCommonSelectFields($table),
$table,
- 'pid=-1 AND t3ver_oid='.intval($theID).
+ 'pid=-1 AND t3ver_oid=' . intval($theID) .
- (!$this->genTree_includeDeleted?t3lib_BEfunc::deleteClause($table):'')
+ (!$this->genTree_includeDeleted ? t3lib_BEfunc::deleteClause($table) : '')
);
} else {
// Select all records from table pointing to this page:
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
t3lib_BEfunc::getCommonSelectFields($table),
$table,
- 'pid='.intval($theID).
+ 'pid=' . intval($theID) .
- (!$this->genTree_includeDeleted?t3lib_BEfunc::deleteClause($table):'')
+ (!$this->genTree_includeDeleted ? t3lib_BEfunc::deleteClause($table) : '')
);
}
// Traverse selected:
$a = 0;
$c = $GLOBALS['TYPO3_DB']->sql_num_rows($res);
- while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
+ while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
// Prepare the additional label used in the HTML output in case of versions:
- if ($versions) {
+ if ($versions) {
- $versionLabel = '[v1.'.$row['t3ver_id'].'; WS#'.$row['t3ver_wsid'].']';
+ $versionLabel = '[v1.' . $row['t3ver_id'] . '; WS#' . $row['t3ver_wsid'] . ']';
- } else $versionLabel='';
+ } else {
+ $versionLabel = '';
+ }
$a++;
$newID = $row['uid'];
// Build HTML output:
- if ($this->genTree_makeHTML) {
+ if ($this->genTree_makeHTML) {
- $this->genTree_HTML.=LF.'';
+ $this->genTree_HTML .= LF . '';
$PM = 'join';
- $LN = ($a==$c)?'blank':'line';
+ $LN = ($a == $c) ? 'blank' : 'line';
- $BTM = ($a==$c)?'bottom':'';
+ $BTM = ($a == $c) ? 'bottom' : '';
- $this->genTree_HTML.= $depthData.
+ $this->genTree_HTML .= $depthData .
- 'backPath,'gfx/ol/'.$PM.$BTM.'.gif','width="18" height="16"').' align="top" alt="" />'.
+ 'backPath, 'gfx/ol/' . $PM . $BTM . '.gif', 'width="18" height="16"') . ' align="top" alt="" />' .
- $versionLabel.
+ $versionLabel .
- t3lib_iconWorks::getSpriteIconForRecord($table, $row, array('title'=> $table)) . htmlspecialchars($row['uid'] . ': ' . t3lib_BEfunc::getRecordTitle($table,$row)) . ' ';
+ t3lib_iconWorks::getSpriteIconForRecord($table, $row, array('title' => $table)) . htmlspecialchars($row['uid'] . ': ' . t3lib_BEfunc::getRecordTitle($table, $row)) . ' ';
}
// Register various data for this item:
- $this->rec_idArray[$table][$newID]=$row;
+ $this->rec_idArray[$table][$newID] = $row;
$this->recStats['all_valid'][$table][$newID] = $newID;
-# $this->recStats[$versions?'versions':'live'][$table][$newID] = $newID;
+ # $this->recStats[$versions?'versions':'live'][$table][$newID] = $newID;
- if ($row['deleted']) $this->recStats['deleted'][$table][$newID] = $newID;
+ if ($row['deleted']) {
+ $this->recStats['deleted'][$table][$newID] = $newID;
+ }
- if ($versions && $row['t3ver_count']>=1 && $row['t3ver_wsid']==0) {
+ if ($versions && $row['t3ver_count'] >= 1 && $row['t3ver_wsid'] == 0) {
$this->recStats['published_versions'][$table][$newID] = $newID;
}
-# if ($row['deleted']) {$this->recStat['deleted']++;}
-# if ($row['hidden']) {$this->recStat['hidden']++;}
+ # if ($row['deleted']) {$this->recStat['deleted']++;}
+ # if ($row['hidden']) {$this->recStat['hidden']++;}
-
// Select all versions of this record:
if ($this->genTree_includeVersions && $TCA[$table]['ctrl']['versioningWS']) {
- $genHTML = $depthData.'backPath,'gfx/ol/'.$LN.'.gif','width="18" height="16"').' align="top" alt="" />';
+ $genHTML = $depthData . 'backPath, 'gfx/ol/' . $LN . '.gif', 'width="18" height="16"') . ' align="top" alt="" />';
$this->genTree_records($newID, $genHTML, $table, TRUE);
}
@@ -289,54 +282,50 @@
*
* @return [type] ...
*/
- function genTreeStatus($root=0) {
+ function genTreeStatus($root = 0) {
- $this->genTree_includeDeleted = TRUE; // if set, genTree() includes deleted pages. This is default.
+ $this->genTree_includeDeleted = TRUE; // if set, genTree() includes deleted pages. This is default.
- $this->genTree_includeVersions = TRUE; // if set, genTree() includes verisonized pages/records. This is default.
+ $this->genTree_includeVersions = TRUE; // if set, genTree() includes verisonized pages/records. This is default.
- $this->genTree_includeRecords = TRUE; // if set, genTree() includes records from pages.
+ $this->genTree_includeRecords = TRUE; // if set, genTree() includes records from pages.
- $this->perms_clause = ''; // extra where-clauses for the tree-selection
+ $this->perms_clause = ''; // extra where-clauses for the tree-selection
- $this->genTree_makeHTML = 0; // if set, genTree() generates HTML, that visualizes the tree.
+ $this->genTree_makeHTML = 0; // if set, genTree() generates HTML, that visualizes the tree.
- $this->genTree($root,'');
+ $this->genTree($root, '');
return $this->recStats;
}
-
-
-
-
/**
* Fills $this->lRecords with the records from all tc-tables that are not attached to a PID in the pid-list.
*
* @param string list of pid's (page-record uid's). This list is probably made by genTree()
* @return void
*/
- function lostRecords($pid_list) {
+ function lostRecords($pid_list) {
global $TCA;
- $this->lostPagesList='';
+ $this->lostPagesList = '';
- if ($pid_list) {
+ if ($pid_list) {
foreach ($TCA as $table => $tableConf) {
t3lib_div::loadTCA($table);
$pid_list_tmp = $pid_list;
- if (!isset($TCA[$table]['ctrl']['versioningWS']) || !$TCA[$table]['ctrl']['versioningWS']) {
+ if (!isset($TCA[$table]['ctrl']['versioningWS']) || !$TCA[$table]['ctrl']['versioningWS']) {
// Remove preceding "-1," for non-versioned tables
- $pid_list_tmp = preg_replace('/^\-1,/','',$pid_list_tmp);
+ $pid_list_tmp = preg_replace('/^\-1,/', '', $pid_list_tmp);
}
- $garbage = $GLOBALS['TYPO3_DB']->exec_SELECTquery (
+ $garbage = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
- 'uid,pid,'.$TCA[$table]['ctrl']['label'],
+ 'uid,pid,' . $TCA[$table]['ctrl']['label'],
- $table,
+ $table,
- 'pid NOT IN ('.$pid_list_tmp.')'
+ 'pid NOT IN (' . $pid_list_tmp . ')'
- );
+ );
$lostIdList = array();
- while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($garbage)) {
+ while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($garbage)) {
- $this->lRecords[$table][$row['uid']]=Array('uid'=>$row['uid'], 'pid'=>$row['pid'], 'title'=> strip_tags($row[$TCA[$table]['ctrl']['label']]) );
+ $this->lRecords[$table][$row['uid']] = array('uid' => $row['uid'], 'pid' => $row['pid'], 'title' => strip_tags($row[$TCA[$table]['ctrl']['label']]));
- $lostIdList[]=$row['uid'];
+ $lostIdList[] = $row['uid'];
}
- if ($table=='pages') {
+ if ($table == 'pages') {
- $this->lostPagesList=implode(',',$lostIdList);
+ $this->lostPagesList = implode(',', $lostIdList);
}
}
}
@@ -349,20 +338,22 @@
* @param integer The uid of the record which will have the PID value set to 0 (zero)
* @return boolean True if done.
*/
- function fixLostRecord($table,$uid) {
+ function fixLostRecord($table, $uid) {
- if ($table && $GLOBALS['TCA'][$table] && $uid && is_array($this->lRecords[$table][$uid]) && $GLOBALS['BE_USER']->user['admin']) {
+ if ($table && $GLOBALS['TCA'][$table] && $uid && is_array($this->lRecords[$table][$uid]) && $GLOBALS['BE_USER']->user['admin']) {
$updateFields = array();
$updateFields['pid'] = 0;
- if ($GLOBALS['TCA'][$table]['ctrl']['enablecolumns']['disabled']) { // If possible a lost record restored is hidden as default
+ if ($GLOBALS['TCA'][$table]['ctrl']['enablecolumns']['disabled']) { // If possible a lost record restored is hidden as default
$updateFields[$GLOBALS['TCA'][$table]['ctrl']['enablecolumns']['disabled']] = 1;
}
- $GLOBALS['TYPO3_DB']->exec_UPDATEquery($table, 'uid='.intval($uid), $updateFields);
+ $GLOBALS['TYPO3_DB']->exec_UPDATEquery($table, 'uid=' . intval($uid), $updateFields);
return TRUE;
- } else return FALSE;
+ } else {
+ return FALSE;
- }
+ }
+ }
/**
* Counts records from $TCA-tables that ARE attached to an existing page.
@@ -370,26 +361,26 @@
* @param string list of pid's (page-record uid's). This list is probably made by genTree()
* @return array an array with the number of records from all $TCA-tables that are attached to a PID in the pid-list.
*/
- function countRecords($pid_list) {
+ function countRecords($pid_list) {
global $TCA;
- $list=Array();
- $list_n=Array();
+ $list = array();
+ $list_n = array();
- if ($pid_list) {
+ if ($pid_list) {
foreach ($TCA as $table => $tableConf) {
t3lib_div::loadTCA($table);
$pid_list_tmp = $pid_list;
- if (!isset($TCA[$table]['ctrl']['versioningWS']) || !$TCA[$table]['ctrl']['versioningWS']) {
+ if (!isset($TCA[$table]['ctrl']['versioningWS']) || !$TCA[$table]['ctrl']['versioningWS']) {
// Remove preceding "-1," for non-versioned tables
- $pid_list_tmp = preg_replace('/^\-1,/','',$pid_list_tmp);
+ $pid_list_tmp = preg_replace('/^\-1,/', '', $pid_list_tmp);
}
- $count = $GLOBALS['TYPO3_DB']->exec_SELECTcountRows('uid', $table, 'pid IN ('.$pid_list_tmp.')');
+ $count = $GLOBALS['TYPO3_DB']->exec_SELECTcountRows('uid', $table, 'pid IN (' . $pid_list_tmp . ')');
if ($count) {
$list[$table] = $count;
}
- $count = $GLOBALS['TYPO3_DB']->exec_SELECTcountRows('uid', $table, 'pid IN ('.$pid_list_tmp.')' . t3lib_BEfunc::deleteClause($table));
+ $count = $GLOBALS['TYPO3_DB']->exec_SELECTcountRows('uid', $table, 'pid IN (' . $pid_list_tmp . ')' . t3lib_BEfunc::deleteClause($table));
if ($count) {
$list_n[$table] = $count;
}
@@ -404,27 +395,27 @@
* @param string $mode = file, $mode = db, $mode = '' (all...)
* @return array An array with all fields listed that somehow are references to other records (foreign-keys) or files
*/
- function getGroupFields($mode) {
+ function getGroupFields($mode) {
global $TCA;
- $result = Array();
+ $result = array();
foreach ($TCA as $table => $tableConf) {
t3lib_div::loadTCA($table);
$cols = $TCA[$table]['columns'];
foreach ($cols as $field => $config) {
- if ($config['config']['type']=='group') {
+ if ($config['config']['type'] == 'group') {
if (
- ((!$mode||$mode=='file') && $config['config']['internal_type']=='file') ||
+ ((!$mode || $mode == 'file') && $config['config']['internal_type'] == 'file') ||
- ((!$mode||$mode=='db') && $config['config']['internal_type']=='db')
+ ((!$mode || $mode == 'db') && $config['config']['internal_type'] == 'db')
- ) {
+ ) {
- $result[$table][]=$field;
+ $result[$table][] = $field;
}
}
- if ( (!$mode||$mode=='db') && $config['config']['type']=='select' && $config['config']['foreign_table']) {
+ if ((!$mode || $mode == 'db') && $config['config']['type'] == 'select' && $config['config']['foreign_table']) {
- $result[$table][]=$field;
+ $result[$table][] = $field;
}
}
- if ($result[$table]) {
+ if ($result[$table]) {
- $result[$table] = implode(',',$result[$table]);
+ $result[$table] = implode(',', $result[$table]);
}
}
return $result;
@@ -436,15 +427,15 @@
* @param string Path to uploadfolder
* @return array An array with all fields listed that have references to files in the $uploadfolder
*/
- function getFileFields($uploadfolder) {
+ function getFileFields($uploadfolder) {
global $TCA;
- $result = Array();
+ $result = array();
foreach ($TCA as $table => $tableConf) {
t3lib_div::loadTCA($table);
$cols = $TCA[$table]['columns'];
foreach ($cols as $field => $config) {
- if ($config['config']['type']=='group' && $config['config']['internal_type']=='file' && $config['config']['uploadfolder']==$uploadfolder) {
+ if ($config['config']['type'] == 'group' && $config['config']['internal_type'] == 'file' && $config['config']['uploadfolder'] == $uploadfolder) {
- $result[]=Array($table,$field);
+ $result[] = array($table, $field);
}
}
}
@@ -457,20 +448,20 @@
* @param string Table name
* @return array
*/
- function getDBFields($theSearchTable) {
+ function getDBFields($theSearchTable) {
global $TCA;
- $result = Array();
+ $result = array();
- reset ($TCA);
+ reset($TCA);
foreach ($TCA as $table => $tableConf) {
t3lib_div::loadTCA($table);
$cols = $TCA[$table]['columns'];
foreach ($cols as $field => $config) {
- if ($config['config']['type']=='group' && $config['config']['internal_type']=='db') {
+ if ($config['config']['type'] == 'group' && $config['config']['internal_type'] == 'db') {
- if (trim($config['config']['allowed'])=='*' || strstr($config['config']['allowed'],$theSearchTable)) {
+ if (trim($config['config']['allowed']) == '*' || strstr($config['config']['allowed'], $theSearchTable)) {
- $result[]=Array($table,$field);
+ $result[] = array($table, $field);
}
- } else if ($config['config']['type']=='select' && $config['config']['foreign_table']==$theSearchTable) {
+ } elseif ($config['config']['type'] == 'select' && $config['config']['foreign_table'] == $theSearchTable) {
- $result[]=Array($table,$field);
+ $result[] = array($table, $field);
}
}
}
@@ -484,72 +475,72 @@
* @return void
* @see getGroupFields()
*/
- function selectNonEmptyRecordsWithFkeys($fkey_arrays) {
+ function selectNonEmptyRecordsWithFkeys($fkey_arrays) {
global $TCA;
- if (is_array($fkey_arrays)) {
+ if (is_array($fkey_arrays)) {
foreach ($fkey_arrays as $table => $field_list) {
- if ($TCA[$table] && trim($field_list)) {
+ if ($TCA[$table] && trim($field_list)) {
t3lib_div::loadTCA($table);
- $fieldArr = explode(',',$field_list);
+ $fieldArr = explode(',', $field_list);
- if(t3lib_extMgm::isLoaded('dbal')) {
+ if (t3lib_extMgm::isLoaded('dbal')) {
$fields = $GLOBALS['TYPO3_DB']->admin_get_fields($table);
$field = array_shift($fieldArr);
- $cl_fl = ($GLOBALS['TYPO3_DB']->MetaType($fields[$field]['type'],$table) == 'I' || $GLOBALS['TYPO3_DB']->MetaType($fields[$field]['type'],$table) == 'N' || $GLOBALS['TYPO3_DB']->MetaType($fields[$field]['type'],$table) == 'R') ?
+ $cl_fl = ($GLOBALS['TYPO3_DB']->MetaType($fields[$field]['type'], $table) == 'I' || $GLOBALS['TYPO3_DB']->MetaType($fields[$field]['type'], $table) == 'N' || $GLOBALS['TYPO3_DB']->MetaType($fields[$field]['type'], $table) == 'R') ?
- $field.'!=0' : $field.'!=\'\'';
+ $field . '!=0' : $field . '!=\'\'';
foreach ($fieldArr as $field) {
- $cl_fl .= ($GLOBALS['TYPO3_DB']->MetaType($fields[$field]['type'],$table) == 'I' || $GLOBALS['TYPO3_DB']->MetaType($fields[$field]['type'],$table) == 'N' || $GLOBALS['TYPO3_DB']->MetaType($fields[$field]['type'],$table) == 'R') ?
+ $cl_fl .= ($GLOBALS['TYPO3_DB']->MetaType($fields[$field]['type'], $table) == 'I' || $GLOBALS['TYPO3_DB']->MetaType($fields[$field]['type'], $table) == 'N' || $GLOBALS['TYPO3_DB']->MetaType($fields[$field]['type'], $table) == 'R') ?
- ' OR '.$field.'!=0' : ' OR '.$field.'!=\'\'';
+ ' OR ' . $field . '!=0' : ' OR ' . $field . '!=\'\'';
}
unset($fields);
}
else {
- $cl_fl = implode ('!=\'\' OR ',$fieldArr). '!=\'\'';
+ $cl_fl = implode('!=\'\' OR ', $fieldArr) . '!=\'\'';
}
- $mres = $GLOBALS['TYPO3_DB']->exec_SELECTquery('uid,'.$field_list, $table, $cl_fl);
+ $mres = $GLOBALS['TYPO3_DB']->exec_SELECTquery('uid,' . $field_list, $table, $cl_fl);
- while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($mres)) {
+ while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($mres)) {
foreach ($fieldArr as $field) {
- if (trim($row[$field])) {
+ if (trim($row[$field])) {
$fieldConf = $TCA[$table]['columns'][$field]['config'];
- if ($fieldConf['type']=='group') {
+ if ($fieldConf['type'] == 'group') {
- if ($fieldConf['internal_type']=='file') {
+ if ($fieldConf['internal_type'] == 'file') {
- // files...
+ // files...
- if ($fieldConf['MM']) {
+ if ($fieldConf['MM']) {
- $tempArr=array();
+ $tempArr = array();
$dbAnalysis = t3lib_div::makeInstance('t3lib_loadDBGroup');
- $dbAnalysis->start('','files',$fieldConf['MM'],$row['uid']);
+ $dbAnalysis->start('', 'files', $fieldConf['MM'], $row['uid']);
foreach ($dbAnalysis->itemArray as $somekey => $someval) {
- if ($someval['id']) {
+ if ($someval['id']) {
- $tempArr[]=$someval['id'];
+ $tempArr[] = $someval['id'];
}
}
} else {
- $tempArr = explode(',',trim($row[$field]));
+ $tempArr = explode(',', trim($row[$field]));
}
foreach ($tempArr as $file) {
$file = trim($file);
- if ($file) {
+ if ($file) {
- $this->checkFileRefs[$fieldConf['uploadfolder']][$file]+=1;
+ $this->checkFileRefs[$fieldConf['uploadfolder']][$file] += 1;
}
}
}
- if ($fieldConf['internal_type']=='db') {
+ if ($fieldConf['internal_type'] == 'db') {
- // dbs - group
+ // dbs - group
$dbAnalysis = t3lib_div::makeInstance('t3lib_loadDBGroup');
- $dbAnalysis->start($row[$field],$fieldConf['allowed'],$fieldConf['MM'],$row['uid'], $table, $fieldConf);
+ $dbAnalysis->start($row[$field], $fieldConf['allowed'], $fieldConf['MM'], $row['uid'], $table, $fieldConf);
foreach ($dbAnalysis->itemArray as $tempArr) {
- $this->checkGroupDBRefs[$tempArr['table']][$tempArr['id']]+=1;
+ $this->checkGroupDBRefs[$tempArr['table']][$tempArr['id']] += 1;
}
}
}
- if ($fieldConf['type']=='select' && $fieldConf['foreign_table']) {
+ if ($fieldConf['type'] == 'select' && $fieldConf['foreign_table']) {
- // dbs - select
+ // dbs - select
$dbAnalysis = t3lib_div::makeInstance('t3lib_loadDBGroup');
- $dbAnalysis->start($row[$field],$fieldConf['foreign_table'],$fieldConf['MM'],$row['uid'], $table, $fieldConf);
+ $dbAnalysis->start($row[$field], $fieldConf['foreign_table'], $fieldConf['MM'], $row['uid'], $table, $fieldConf);
foreach ($dbAnalysis->itemArray as $tempArr) {
- if ($tempArr['id']>0) {
+ if ($tempArr['id'] > 0) {
- $this->checkGroupDBRefs[$fieldConf['foreign_table']][$tempArr['id']]+=1;
+ $this->checkGroupDBRefs[$fieldConf['foreign_table']][$tempArr['id']] += 1;
}
}
}
@@ -567,8 +558,8 @@
*
* @return array Report over files; keys are "moreReferences", "noReferences", "noFile", "error"
*/
- function testFileRefs () {
+ function testFileRefs() {
- $output=Array();
+ $output = array();
// handle direct references with upload folder setting (workaround)
$newCheckFileRefs = array();
foreach ($this->checkFileRefs as $folder => $files) {
@@ -595,48 +586,48 @@
$this->checkFileRefs = $newCheckFileRefs;
foreach ($this->checkFileRefs as $folder => $fileArr) {
- $path = PATH_site.$folder;
+ $path = PATH_site . $folder;
- if (@is_dir($path)) {
+ if (@is_dir($path)) {
$d = dir($path);
- while($entry=$d->read()) {
+ while ($entry = $d->read()) {
- if (@is_file($path.'/'.$entry)) {
+ if (@is_file($path . '/' . $entry)) {
- if (isset($fileArr[$entry])) {
+ if (isset($fileArr[$entry])) {
- if ($fileArr[$entry] > 1) {
+ if ($fileArr[$entry] > 1) {
- $temp = $this->whereIsFileReferenced($folder,$entry);
+ $temp = $this->whereIsFileReferenced($folder, $entry);
$tempList = '';
foreach ($temp as $inf) {
- $tempList.='['.$inf['table'].']['.$inf['uid'].']['.$inf['field'].'] (pid:'.$inf['pid'].') - ';
+ $tempList .= '[' . $inf['table'] . '][' . $inf['uid'] . '][' . $inf['field'] . '] (pid:' . $inf['pid'] . ') - ';
}
- $output['moreReferences'][] = Array($path,$entry,$fileArr[$entry],$tempList);
+ $output['moreReferences'][] = array($path, $entry, $fileArr[$entry], $tempList);
}
unset($fileArr[$entry]);
} else {
// contains workaround for direct references
if (!strstr($entry, 'index.htm') && !preg_match('/^' . preg_quote($GLOBALS['TYPO3_CONF_VARS']['BE']['fileadminDir'], '/') . '/', $folder)) {
- $output['noReferences'][] = Array($path,$entry);
+ $output['noReferences'][] = array($path, $entry);
}
}
}
}
$d->close();
- $tempCounter=0;
+ $tempCounter = 0;
foreach ($fileArr as $file => $value) {
// workaround for direct file references
if (preg_match('/^' . preg_quote($GLOBALS['TYPO3_CONF_VARS']['BE']['fileadminDir'], '/') . '/', $folder)) {
$file = $folder . '/' . $file;
$folder = '';
- $path = substr(PATH_site, 0, - 1);
+ $path = substr(PATH_site, 0, -1);
}
- $temp = $this->whereIsFileReferenced($folder,$file);
+ $temp = $this->whereIsFileReferenced($folder, $file);
$tempList = '';
foreach ($temp as $inf) {
- $tempList.='['.$inf['table'].']['.$inf['uid'].']['.$inf['field'].'] (pid:'.$inf['pid'].') - ';
+ $tempList .= '[' . $inf['table'] . '][' . $inf['uid'] . '][' . $inf['field'] . '] (pid:' . $inf['pid'] . ') - ';
}
$tempCounter++;
- $output['noFile'][substr($path,-3).'_'.substr($file,0,3).'_'.$tempCounter] = Array($path,$file,$tempList);
+ $output['noFile'][substr($path, -3) . '_' . substr($file, 0, 3) . '_' . $tempCounter] = array($path, $file, $tempList);
}
} else {
- $output['error'][] = Array($path);
+ $output['error'][] = array($path);
}
}
return $output;
@@ -648,28 +639,28 @@
* @param array Table with key/value pairs being table names and arrays with uid numbers
* @return string HTML Error message
*/
- function testDBRefs($theArray) {
+ function testDBRefs($theArray) {
global $TCA;
foreach ($theArray as $table => $dbArr) {
- if ($TCA[$table]) {
+ if ($TCA[$table]) {
$idlist = array_keys($dbArr);
- $theList = implode(',',$idlist);
+ $theList = implode(',', $idlist);
- if ($theList) {
+ if ($theList) {
- $mres = $GLOBALS['TYPO3_DB']->exec_SELECTquery('uid', $table, 'uid IN ('.$theList.')'.t3lib_BEfunc::deleteClause($table));
+ $mres = $GLOBALS['TYPO3_DB']->exec_SELECTquery('uid', $table, 'uid IN (' . $theList . ')' . t3lib_BEfunc::deleteClause($table));
- while($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($mres)) {
+ while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($mres)) {
- if (isset($dbArr[$row['uid']])) {
+ if (isset($dbArr[$row['uid']])) {
unset ($dbArr[$row['uid']]);
} else {
- $result.='Strange Error. ...
';
+ $result .= 'Strange Error. ...
';
}
}
foreach ($dbArr as $theId => $theC) {
- $result.='There are '.$theC.' records pointing to this missing or deleted record; ['.$table.']['.$theId.']
';
+ $result .= 'There are ' . $theC . ' records pointing to this missing or deleted record; [' . $table . '][' . $theId . ']
';
}
}
} else {
- $result.='Codeerror. Table is not a table...
';
+ $result .= 'Codeerror. Table is not a table...
';
}
}
return $result;
@@ -682,28 +673,29 @@
* @param integer Uid of database record
* @return array Array with other arrays containing information about where references was found
*/
- function whereIsRecordReferenced($searchTable,$id) {
+ function whereIsRecordReferenced($searchTable, $id) {
global $TCA;
- $fileFields = $this->getDBFields($searchTable); // Gets tables / Fields that reference to files...
+ $fileFields = $this->getDBFields($searchTable); // Gets tables / Fields that reference to files...
- $theRecordList=Array();
+ $theRecordList = array();
foreach ($fileFields as $info) {
- $table=$info[0]; $field=$info[1];
+ $table = $info[0];
+ $field = $info[1];
t3lib_div::loadTCA($table);
$mres = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
- 'uid,pid,'.$TCA[$table]['ctrl']['label'].','.$field,
+ 'uid,pid,' . $TCA[$table]['ctrl']['label'] . ',' . $field,
- $table,
+ $table,
- $field.' LIKE \'%'.$GLOBALS['TYPO3_DB']->quoteStr($id, $table).'%\''
+ $field . ' LIKE \'%' . $GLOBALS['TYPO3_DB']->quoteStr($id, $table) . '%\''
- );
+ );
- while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($mres)) {
+ while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($mres)) {
// Now this is the field, where the reference COULD come from. But we're not garanteed, so we must carefully examine the data.
$fieldConf = $TCA[$table]['columns'][$field]['config'];
- $allowedTables = ($fieldConf['type']=='group') ? $fieldConf['allowed'] : $fieldConf['foreign_table'];
+ $allowedTables = ($fieldConf['type'] == 'group') ? $fieldConf['allowed'] : $fieldConf['foreign_table'];
$dbAnalysis = t3lib_div::makeInstance('t3lib_loadDBGroup');
- $dbAnalysis->start($row[$field],$allowedTables,$fieldConf['MM'],$row['uid'], $table, $fieldConf);
+ $dbAnalysis->start($row[$field], $allowedTables, $fieldConf['MM'], $row['uid'], $table, $fieldConf);
foreach ($dbAnalysis->itemArray as $tempArr) {
- if ($tempArr['table']==$searchTable && $tempArr['id']==$id) {
+ if ($tempArr['table'] == $searchTable && $tempArr['id'] == $id) {
- $theRecordList[]=Array('table'=>$table,'uid'=>$row['uid'],'field'=>$field,'pid'=>$row['pid']);
+ $theRecordList[] = array('table' => $table, 'uid' => $row['uid'], 'field' => $field, 'pid' => $row['pid']);
}
}
}
@@ -719,24 +711,25 @@
* @param string Filename to search for
* @return array Array with other arrays containing information about where references was found
*/
- function whereIsFileReferenced($uploadfolder,$filename) {
+ function whereIsFileReferenced($uploadfolder, $filename) {
global $TCA;
- $fileFields = $this->getFileFields($uploadfolder); // Gets tables / Fields that reference to files...
+ $fileFields = $this->getFileFields($uploadfolder); // Gets tables / Fields that reference to files...
- $theRecordList=Array();
+ $theRecordList = array();
foreach ($fileFields as $info) {
- $table=$info[0]; $field=$info[1];
+ $table = $info[0];
+ $field = $info[1];
$mres = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
- 'uid,pid,'.$TCA[$table]['ctrl']['label'].','.$field,
+ 'uid,pid,' . $TCA[$table]['ctrl']['label'] . ',' . $field,
- $table,
+ $table,
- $field.' LIKE \'%'.$GLOBALS['TYPO3_DB']->quoteStr($filename, $table).'%\''
+ $field . ' LIKE \'%' . $GLOBALS['TYPO3_DB']->quoteStr($filename, $table) . '%\''
- );
+ );
- while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($mres)) {
+ while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($mres)) {
- // Now this is the field, where the reference COULD come from. But we're not garanteed, so we must carefully examine the data.
+ // Now this is the field, where the reference COULD come from. But we're not garanteed, so we must carefully examine the data.
- $tempArr = explode(',',trim($row[$field]));
+ $tempArr = explode(',', trim($row[$field]));
foreach ($tempArr as $file) {
$file = trim($file);
- if ($file==$filename) {
+ if ($file == $filename) {
- $theRecordList[]=Array('table'=>$table,'uid'=>$row['uid'],'field'=>$field,'pid'=>$row['pid']);
+ $theRecordList[] = array('table' => $table, 'uid' => $row['uid'], 'field' => $field, 'pid' => $row['pid']);
}
}
}
@@ -746,7 +739,7 @@
}
-if (defined('TYPO3_MODE') && $TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['t3lib/class.t3lib_admin.php']) {
+if (defined('TYPO3_MODE') && $TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['t3lib/class.t3lib_admin.php']) {
include_once($TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['t3lib/class.t3lib_admin.php']);
}
?>
\ No newline at end of file