Documentation TYPO3 par Ameos

class.double_files.php

00001 <?php
00002 /***************************************************************
00003 *  Copyright notice
00004 *
00005 *  (c) 1999-2005 Kasper Skaarhoj (kasperYYYY@typo3.com)
00006 *  All rights reserved
00007 *
00008 *  This script is part of the TYPO3 project. The TYPO3 project is
00009 *  free software; you can redistribute it and/or modify
00010 *  it under the terms of the GNU General Public License as published by
00011 *  the Free Software Foundation; either version 2 of the License, or
00012 *  (at your option) any later version.
00013 *
00014 *  The GNU General Public License can be found at
00015 *  http://www.gnu.org/copyleft/gpl.html.
00016 *  A copy is found in the textfile GPL.txt and important notices to the license
00017 *  from the author is found in LICENSE.txt distributed with these scripts.
00018 *
00019 *
00020 *  This script is distributed in the hope that it will be useful,
00021 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
00022 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
00023 *  GNU General Public License for more details.
00024 *
00025 *  This copyright notice MUST APPEAR in all copies of the script!
00026 ***************************************************************/
00049 require_once (PATH_t3lib.'class.t3lib_basicfilefunc.php');
00050 
00058 class tx_lowlevel_double_files extends tx_lowlevel_cleaner_core {
00059 
00060         var $checkRefIndex = TRUE;
00061 
00067         function tx_lowlevel_double_files()     {
00068                 parent::tx_lowlevel_cleaner_core();
00069 
00070                         // Setting up help:
00071                 $this->cli_help['name'] = 'double_files -- Looking for files from TYPO3 managed records which are referenced more than one time (only one time allowed)';
00072                 $this->cli_help['description'] = trim('
00073 Assumptions:
00074 - a perfect integrity of the reference index table (always update the reference index table before using this tool!)
00075 - files found in deleted records are included (otherwise you would see a false list of lost files)
00076 
00077 Files attached to records in TYPO3 using a "group" type configuration in TCA or FlexForm DataStructure are managed exclusively by the system and there must always exist a 1-1 reference between the file and the reference in the record.
00078 This tool will expose when such files are referenced from multiple locations which is considered an integrity error.
00079 If a multi-reference is found it was typically created because the record was copied or modified outside of TCEmain which will otherwise maintain the relations correctly.
00080 Multi-references should be resolved to 1-1 references as soon as possible. The danger of keeping multi-references is that if the file is removed from one of the refering records it will actually be deleted in the file system, leaving missing files for the remaining referers!
00081 
00082 Automatic Repair of Errors:
00083 - The multi-referenced file is copied under a new name and references updated.
00084 
00085 Manual repair suggestions:
00086 - None that can not be handled by the automatic repair.
00087 ');
00088 
00089                 $this->cli_help['examples'] = '/.../cli_dispatch.phpsh lowlevel_cleaner double_files -s -r
00090 This will check the system for double files relations.';
00091         }
00092 
00099         function main() {
00100                 global $TYPO3_DB;
00101 
00102                         // Initialize result array:
00103                 $resultArray = array(
00104                         'message' => $this->cli_help['name'].chr(10).chr(10).$this->cli_help['description'],
00105                         'headers' => array(
00106                                 'multipleReferencesList_count' => array('Number of multi-reference files','(See below)',0),
00107                                 'singleReferencesList_count' => array('Number of files correctly referenced','The amount of correct 1-1 references',0),
00108                                 'multipleReferencesList' => array('Entries with files having multiple references','These are serious problems that should be resolved ASAP to prevent data loss! '.$this->label_infoString,3),
00109                                 'dirname_registry' => array('Registry of directories in which files are found.','Registry includes which table/field pairs store files in them plus how many files their store.',0),
00110                                 'missingFiles' => array('Tracking missing files','(Extra feature, not related to tracking of double references. Further, the list may include more files than found in the missing_files()-test because this list includes missing files from deleted records.)',0),
00111                                 'warnings' => array('Warnings picked up','',2)
00112                         ),
00113                         'multipleReferencesList_count' => 0,
00114                         'singleReferencesList_count' => 0,
00115                         'multipleReferencesList' => array(),
00116                         'dirname_registry' => array(),
00117                         'missingFiles' => array(),
00118                         'warnings' => array()
00119                 );
00120 
00121                         // Select all files in the reference table not found by a soft reference parser (thus TCA configured)
00122                 $recs = $TYPO3_DB->exec_SELECTgetRows(
00123                         '*',
00124                         'sys_refindex',
00125                         'ref_table='.$TYPO3_DB->fullQuoteStr('_FILE', 'sys_refindex').
00126                                 ' AND softref_key='.$TYPO3_DB->fullQuoteStr('', 'sys_refindex'),
00127                         '',
00128                         'sorting DESC'
00129                 );
00130 
00131                         // Traverse the files and put into a large table:
00132                 $tempCount = array();
00133                 if (is_array($recs)) {
00134                         foreach($recs as $rec)  {
00135 
00136                                         // Compile info string for location of reference:
00137                                 $infoString = $this->infoStr($rec);
00138 
00139                                         // Registering occurencies in directories:
00140                                 $resultArray['dirname_registry'][dirname($rec['ref_string'])][$rec['tablename'].':'.$rec['field']]++;
00141 
00142                                         // Handle missing file:
00143                                 if (!@is_file(PATH_site.$rec['ref_string']))    {
00144                                         $resultArray['missingFiles'][$rec['ref_string']][$rec['hash']] = $infoString;
00145                                 }
00146 
00147                                         // Add entry if file has multiple references pointing to it:
00148                                 if (isset($tempCount[$rec['ref_string']]))      {
00149                                         if (!is_array($resultArray['multipleReferencesList'][$rec['ref_string']]))      {
00150                                                 $resultArray['multipleReferencesList'][$rec['ref_string']] = array();
00151                                                 $resultArray['multipleReferencesList'][$rec['ref_string']][$tempCount[$rec['ref_string']][1]] = $tempCount[$rec['ref_string']][0];
00152                                         }
00153                                         $resultArray['multipleReferencesList'][$rec['ref_string']][$rec['hash']] = $infoString;
00154                                 } else {
00155                                         $tempCount[$rec['ref_string']] = array($infoString,$rec['hash']);
00156                                 }
00157                         }
00158                 }
00159 
00160                         // Add count for multi-references:
00161                 $resultArray['multipleReferencesList_count'] = count($resultArray['multipleReferencesList']);
00162                 $resultArray['singleReferencesList_count'] = count($tempCount) - $resultArray['multipleReferencesList_count'];
00163 
00164                         // Sort dirname registry and add warnings for directories outside uploads/
00165                 ksort($resultArray['dirname_registry']);
00166                 foreach($resultArray['dirname_registry'] as $dir => $temp)      {
00167                         if (!t3lib_div::isFirstPartOfStr($dir,'uploads/'))      {
00168                                 $resultArray['warnings'][] = 'Directory "'.$dir.'" was outside uploads/ which is unusual practice in TYPO3 although not forbidden. Directory used by the following table:field pairs: '.implode(',',array_keys($temp));
00169                         }
00170                 }
00171 
00172                 return $resultArray;
00173         }
00174 
00182         function main_autoFix($resultArray)     {
00183                 foreach($resultArray['multipleReferencesList'] as $key => $value)       {
00184                         $absFileName = t3lib_div::getFileAbsFileName($key);
00185                         if ($absFileName && @is_file($absFileName))     {
00186                                 echo 'Processing file: '.$key.chr(10);
00187                                 $c=0;
00188                                 foreach($value as $hash => $recReference)       {
00189                                         if ($c==0)      {
00190                                                 echo '  Keeping '.$key.' for record "'.$recReference.'"'.chr(10);
00191                                         } else {
00192                                                         // Create unique name for file:
00193                                                 $fileFunc = t3lib_div::makeInstance('t3lib_basicFileFunctions');
00194                                                 $newName = $fileFunc->getUniqueName(basename($key), dirname($absFileName));
00195                                                 echo '  Copying '.$key.' to '.substr($newName,strlen(PATH_site)).' for record "'.$recReference.'": ';
00196 
00197                                                 if ($bypass = $this->cli_noExecutionCheck($recReference))       {
00198                                                         echo $bypass;
00199                                                 } else {
00200                                                         t3lib_div::upload_copy_move($absFileName,$newName);
00201                                                         clearstatcache();
00202 
00203                                                         if (@is_file($newName)) {
00204                                                                 $sysRefObj = t3lib_div::makeInstance('t3lib_refindex');
00205                                                                 $error = $sysRefObj->setReferenceValue($hash,basename($newName));
00206                                                                 if ($error)     {
00207                                                                         echo '  ERROR:  t3lib_refindex::setReferenceValue(): '.$error.chr(10);
00208                                                                         exit;
00209                                                                 } else echo "DONE";
00210                                                         } else {
00211                                                                 echo '  ERROR: File "'.$newName.'" was not created!';
00212                                                         }
00213                                                 }
00214                                                 echo chr(10);
00215                                         }
00216                                         $c++;
00217                                 }
00218                         } else {
00219                                 echo '  ERROR: File "'.$absFileName.'" was not found!';
00220                         }
00221                 }
00222         }
00223 }
00224 
00225 ?>


Généré par Les spécialistes TYPO3 avec  doxygen 1.4.6