class.t3lib_admin.php

Go to the documentation of this file.

<?php
/***************************************************************
*  Copyright notice
*
*  (c) 1999-2004 Kasper Skaarhoj (kasperYYYY@typo3.com)
*  All rights reserved
*
*  This script is part of the TYPO3 project. The TYPO3 project is
*  free software; you can redistribute it and/or modify
*  it under the terms of the GNU General Public License as published by
*  the Free Software Foundation; either version 2 of the License, or
*  (at your option) any later version.
*
*  The GNU General Public License can be found at
*  http://www.gnu.org/copyleft/gpl.html.
*  A copy is found in the textfile GPL.txt and important notices to the license
*  from the author is found in LICENSE.txt distributed with these scripts.
*
*
*  This script is distributed in the hope that it will be useful,
*  but WITHOUT ANY WARRANTY; without even the implied warranty of
*  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
*  GNU General Public License for more details.
*
*  This copyright notice MUST APPEAR in all copies of the script!
***************************************************************/
class t3lib_admin {
   var $genTree_includeDeleted = 1; // if set, genTree() includes deleted pages. This is default.
   var $perms_clause='';      // extra where-clauses for the tree-selection
   var $genTree_makeHTML = 0;       // if set, genTree() generates HTML, that visualizes the tree.
      // internal
   var $genTree_idlist = '';  // Will hold the id-list from genTree()
   var $getTree_HTML = '';    // Will hold the HTML-code visualising the tree. genTree()
   var $backPath='';

      // internal
   var $checkFileRefs = Array();
   var $checkSelectDBRefs = Array();   // From the select-fields
   var $checkGroupDBRefs = Array(); // From the group-fields

   var $page_idArray=Array();
   var $recStat = Array();
   var $lRecords = Array();
   var $lostPagesList = '';

   function genTree($theID, $depthData)   {
      $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
               'uid,title,doktype,deleted'.(t3lib_extMgm::isLoaded('cms')?',hidden':''),
               'pages',
               'pid='.intval($theID).' '.((!$this->genTree_includeDeleted)?'AND deleted=0':'').$this->perms_clause,
               '',
               'sorting'
            );
      $a=0;
      $c = $GLOBALS['TYPO3_DB']->sql_num_rows($res);
      while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res))  {
         $a++;
         $newID =$row['uid'];
         if ($this->genTree_makeHTML)  {
            $this->genTree_HTML.=chr(10).'<div><span class="nobr">';
            $PM = 'join';
            $LN = ($a==$c)?'blank':'line';
            $BTM = ($a==$c)?'bottom':'';
            $this->genTree_HTML.= $depthData.'<img'.t3lib_iconWorks::skinImg($this->backPath,'gfx/ol/'.$PM.$BTM.'.gif','width="18" height="16"').' align="top" alt="" />'.t3lib_iconWorks::getIconImage('pages',$row,$this->backPath,'align="top"').htmlspecialchars($row['uid'].': '.t3lib_div::fixed_lgd_cs(strip_tags($row['title']),50)).'</span></div>';
         }

         if (isset($page_idlist[$newID])) {
            $this->recStat['doublePageID'][]=$newID;
         }
         $this->page_idArray[$newID]=$newID;
         if ($row['deleted']) {$this->recStat['deleted']++;}
         if ($row['hidden']) {$this->recStat['hidden']++;}
         $this->recStat['doktype'][$row['doktype']]++;

         $this->genTree($newID,$this->genTree_HTML ? $depthData.'<img'.t3lib_iconWorks::skinImg($this->backPath,'gfx/ol/'.$LN.'.gif','width="18" height="16"').' align="top" alt="" />'  : '');
      }
      return $GLOBALS['TYPO3_DB']->sql_num_rows($res);
   }

   function lostRecords($pid_list)  {
      global $TCA;
      reset($TCA);
      $this->lostPagesList='';
      if ($pid_list) {
         while (list($table)=each($TCA))  {
            t3lib_div::loadTCA($table);
            $garbage = $GLOBALS['TYPO3_DB']->exec_SELECTquery (
                        'uid,pid,'.$TCA[$table]['ctrl']['label'],
                        $table,
                        'pid NOT IN ('.$pid_list.')'
                     );
            $lostIdList=Array();
            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']]) );
               $lostIdList[]=$row['uid'];
            }
            if ($table=='pages') {
               $this->lostPagesList=implode(',',$lostIdList);
            }
         }
      }
   }

   function fixLostRecord($table,$uid) {
      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
            $updateFields[$GLOBALS['TCA'][$table]['ctrl']['enablecolumns']['disabled']] = 1;
         }

         $GLOBALS['TYPO3_DB']->exec_UPDATEquery($table, 'uid='.intval($uid), $updateFields);

         return TRUE;
      } else return FALSE;
   }

   function countRecords($pid_list) {
      global $TCA;
      reset($TCA);
      $list=Array();
      $list_n=Array();
      if ($pid_list) {
         while (list($table)=each($TCA))  {
            t3lib_div::loadTCA($table);
            $count = $GLOBALS['TYPO3_DB']->exec_SELECTquery('count(*)', $table, 'pid IN ('.$pid_list.')');
            if ($row = $GLOBALS['TYPO3_DB']->sql_fetch_row($count))  {
               $list[$table]=$row[0];
            }

            $count = $GLOBALS['TYPO3_DB']->exec_SELECTquery('count(*)', $table, 'pid IN ('.$pid_list.')'.t3lib_BEfunc::deleteClause($table));
            if ($row = $GLOBALS['TYPO3_DB']->sql_fetch_row($count))  {
               $list_n[$table]=$row[0];
            }
         }
      }
      return array('all' => $list, 'non_deleted' => $list_n);
   }

   function getGroupFields($mode)   {
      global $TCA;
      reset ($TCA);
      $result = Array();
      while (list($table)=each($TCA))  {
         t3lib_div::loadTCA($table);
         $cols = $TCA[$table]['columns'];
         reset ($cols);
         while (list($field,$config)=each($cols))  {
            if ($config['config']['type']=='group')   {
               if (
                  ((!$mode||$mode=='file') && $config['config']['internal_type']=='file') ||
                  ((!$mode||$mode=='db') && $config['config']['internal_type']=='db')
                  )  {
                  $result[$table][]=$field;
               }
            }
            if ( (!$mode||$mode=='db') && $config['config']['type']=='select' && $config['config']['foreign_table']) {
               $result[$table][]=$field;
            }
         }
         if ($result[$table]) {
            $result[$table] = implode(',',$result[$table]);
         }
      }
      return $result;
   }

   function getFileFields($uploadfolder)  {
      global $TCA;
      reset ($TCA);
      $result = Array();
      while (list($table)=each($TCA))  {
         t3lib_div::loadTCA($table);
         $cols = $TCA[$table]['columns'];
         reset ($cols);
         while (list($field,$config)=each($cols))  {
            if ($config['config']['type']=='group' && $config['config']['internal_type']=='file' && $config['config']['uploadfolder']==$uploadfolder) {
               $result[]=Array($table,$field);
            }
         }
      }
      return $result;
   }

   function getDBFields($theSearchTable)  {
      global $TCA;
      $result = Array();
      reset ($TCA);
      while (list($table)=each($TCA))  {
         t3lib_div::loadTCA($table);
         $cols = $TCA[$table]['columns'];
         reset ($cols);
         while (list($field,$config)=each($cols))  {
            if ($config['config']['type']=='group' && $config['config']['internal_type']=='db') {
               if (trim($config['config']['allowed'])=='*' || strstr($config['config']['allowed'],$theSearchTable))  {
                  $result[]=Array($table,$field);
               }
            } else if ($config['config']['type']=='select' && $config['config']['foreign_table']==$theSearchTable)   {
               $result[]=Array($table,$field);
            }
         }
      }
      return $result;
   }

   function selectNonEmptyRecordsWithFkeys($fkey_arrays) {
      global $TCA;
      if (is_array($fkey_arrays))   {
         reset($fkey_arrays);
         while (list($table,$field_list)=each($fkey_arrays))   {
            if ($TCA[$table] && trim($field_list)) {
               t3lib_div::loadTCA($table);
               $fieldArr = explode(',',$field_list);
               $cl_fl = implode ('!="" OR ',$fieldArr). '!=""';
               $mres = $GLOBALS['TYPO3_DB']->exec_SELECTquery('uid,'.$field_list, $table, $cl_fl);
               while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($mres)) {
                  reset($fieldArr);
                  while (list(,$field)=each($fieldArr))  {
                     if (trim($row[$field]))    {
                        $fieldConf = $TCA[$table]['columns'][$field]['config'];
                        if ($fieldConf['type']=='group') {
                           if ($fieldConf['internal_type']=='file')  {
                              // files...
                              if ($fieldConf['MM'])   {
                                 $tempArr=array();
                                 $dbAnalysis = t3lib_div::makeInstance('t3lib_loadDBGroup');
                                 $dbAnalysis->start('','files',$fieldConf['MM'],$row['uid']);
                                 reset($dbAnalysis->itemArray);
                                 while (list($somekey,$someval)=each($dbAnalysis->itemArray))   {
                                    if ($someval['id'])  {
                                       $tempArr[]=$someval['id'];
                                    }
                                 }
                              } else {
                                 $tempArr = explode(',',trim($row[$field]));
                              }
                              reset($tempArr);
                              while (list(,$file)=each($tempArr)) {
                                 $file = trim($file);
                                 if ($file)  {
                                    $this->checkFileRefs[$fieldConf['uploadfolder']][$file]+=1;
                                 }
                              }
                           }
                           if ($fieldConf['internal_type']=='db') {
                              // dbs - group
                              $dbAnalysis = t3lib_div::makeInstance('t3lib_loadDBGroup');
                              $dbAnalysis->start($row[$field],$fieldConf['allowed'],$fieldConf['MM'],$row['uid']);
                              reset($dbAnalysis->itemArray);
                              while (list(,$tempArr)=each($dbAnalysis->itemArray))  {
                                 $this->checkGroupDBRefs[$tempArr['table']][$tempArr['id']]+=1;
                              }
                           }
                        }
                        if ($fieldConf['type']=='select' && $fieldConf['foreign_table'])  {
                           // dbs - select
                           $dbAnalysis = t3lib_div::makeInstance('t3lib_loadDBGroup');
                           $dbAnalysis->start($row[$field],$fieldConf['foreign_table'],$fieldConf['MM'],$row['uid']);
                           reset($dbAnalysis->itemArray);
                           while (list(,$tempArr)=each($dbAnalysis->itemArray))  {
                              if ($tempArr['id']>0)   {
                                 $this->checkGroupDBRefs[$fieldConf['foreign_table']][$tempArr['id']]+=1;
                              }
                           }
                        }
                     }
                  }
               }
            }
         }
      }
   }

   function testFileRefs ()   {
      $output=Array();
      reset($this->checkFileRefs);
      while(list($folder,$fileArr)=each($this->checkFileRefs)) {
         $path = PATH_site.$folder;
         if (@is_dir($path))  {
            $d = dir($path);
            while($entry=$d->read()) {
               if (@is_file($path.'/'.$entry))  {
                  if (isset($fileArr[$entry]))  {
                     if ($fileArr[$entry] > 1)  {
                        $temp = $this->whereIsFileReferenced($folder,$entry);
                        $tempList = '';
                        while(list(,$inf)=each($temp))   {
                           $tempList.='['.$inf['table'].']['.$inf['uid'].']['.$inf['field'].'] (pid:'.$inf['pid'].') - ';
                        }
                        $output['moreReferences'][] = Array($path,$entry,$fileArr[$entry],$tempList);
                     }
                     unset($fileArr[$entry]);
                  } else {
                     if (!strstr($entry,'index.htm')) {
                        $output['noReferences'][] = Array($path,$entry);
                     }
                  }
               }
            }
            $d->close();
            reset($fileArr);
            $tempCounter=0;
            while(list($file,)=each($fileArr))  {
               $temp = $this->whereIsFileReferenced($folder,$file);
               $tempList = '';
               while(list(,$inf)=each($temp))   {
                  $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);
            }
         } else {
            $output['error'][] = Array($path);
         }
      }
      return $output;
   }

   function testDBRefs($theArray)   {
      global $TCA;
      reset($theArray);
      while(list($table,$dbArr)=each($theArray))   {
         if ($TCA[$table]) {
            $idlist = Array();
            while(list($id,)=each($dbArr))   {
               $idlist[]=$id;
            }
            $theList = implode(',',$idlist);
            if ($theList)  {
               $mres = $GLOBALS['TYPO3_DB']->exec_SELECTquery('uid', $table, 'uid IN ('.$theList.')'.t3lib_BEfunc::deleteClause($table));
               while($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($mres))  {
                  if (isset($dbArr[$row['uid']]))  {
                     unset ($dbArr[$row['uid']]);
                  } else {
                     $result.='Strange Error. ...<br />';
                  }
               }
               reset($dbArr);
               while (list($theId,$theC)=each($dbArr))   {
                  $result.='There are '.$theC.' records pointing to this missing or deleted record; ['.$table.']['.$theId.']<br />';
               }
            }
         } else {
            $result.='Codeerror. Table is not a table...<br />';
         }
      }
      return $result;
   }

   function whereIsRecordReferenced($searchTable,$id) {
      global $TCA;
      $fileFields = $this->getDBFields($searchTable); // Gets tables / Fields that reference to files...
      $theRecordList=Array();
      while (list(,$info)=each($fileFields)) {
         $table=$info[0];  $field=$info[1];
         t3lib_div::loadTCA($table);
         $mres = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
                     'uid,pid,'.$TCA[$table]['ctrl']['label'].','.$field,
                     $table,
                     $field.' LIKE "%'.$GLOBALS['TYPO3_DB']->quoteStr($id, $table).'%"'
                  );
         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'];

            $dbAnalysis = t3lib_div::makeInstance('t3lib_loadDBGroup');
            $dbAnalysis->start($row[$field],$allowedTables,$fieldConf['MM'],$row['uid']);
            reset($dbAnalysis->itemArray);
            while (list(,$tempArr)=each($dbAnalysis->itemArray))  {
               if ($tempArr['table']==$searchTable && $tempArr['id']==$id) {
                  $theRecordList[]=Array('table'=>$table,'uid'=>$row['uid'],'field'=>$field,'pid'=>$row['pid']);
               }
            }
         }
      }
      return $theRecordList;
   }

   function whereIsFileReferenced($uploadfolder,$filename)  {
      global $TCA;
      $fileFields = $this->getFileFields($uploadfolder); // Gets tables / Fields that reference to files...
      $theRecordList=Array();
      while (list(,$info)=each($fileFields)) {
         $table=$info[0];  $field=$info[1];
         $mres = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
                     'uid,pid,'.$TCA[$table]['ctrl']['label'].','.$field,
                     $table,
                     $field.' LIKE "%'.$GLOBALS['TYPO3_DB']->quoteStr($filename, $table).'%"'
                  );
         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.
            $tempArr = explode(',',trim($row[$field]));
            while (list(,$file)=each($tempArr)) {
               $file = trim($file);
               if ($file==$filename)   {
                  $theRecordList[]=Array('table'=>$table,'uid'=>$row['uid'],'field'=>$field,'pid'=>$row['pid']);
               }
            }
         }
      }
      return $theRecordList;
   }
}


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']);
}
?>

---