CleanUp.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Install\Controller\Action\Tool;

use TYPO3\CMS\Core\Utility\MathUtility;
use TYPO3\CMS\Install\Controller\Action;
use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Install\Status\ErrorStatus;
use TYPO3\CMS\Install\Status\OkStatus;

class CleanUp extends Action\AbstractAction {

    protected $actionMessages = array();

    protected function executeAction() {
        if (isset($this->postValues['set']['clearTables'])) {
            $this->actionMessages[] = $this->clearSelectedTables();
        }
        if (isset($this->postValues['set']['resetBackendUserUc'])) {
            $this->actionMessages[] = $this->resetBackendUserUc();
        }
        if (isset($this->postValues['set']['clearProcessedFiles'])) {
            $this->actionMessages[] = $this->clearProcessedFiles();
        }

        $this->view->assign('cleanableTables', $this->getCleanableTableList());

        $typo3TempData = $this->getTypo3TempStatistics();
        $this->view->assign('typo3TempData', $typo3TempData);

        $this->view->assign('actionMessages', $this->actionMessages);
        return $this->view->render();
    }

    protected function getCleanableTableList() {
        $tableCandidates = array(
            array(
                'name' => 'be_sessions',
                'description' => 'Backend user sessions'
            ),
            array(
                'name' => 'cache_imagesizes',
                'description' => 'Cached image sizes',
            ),
            array(
                'name' => 'cache_md5params',
                'description' => 'Frontend redirects',
            ),
            array(
                'name' => 'cache_typo3temp_log',
                'description' => 'Image rendering lock information',
            ),
            array(
                'name' => 'fe_sessions',
                'description' => 'Frontend user sessions',
            ),
            array(
                'name' => 'fe_session_data',
                'description' => 'Frontend user session data',
            ),
            array(
                'name' => 'sys_history',
                'description' => 'Tracking of database record changes through TYPO3 backend forms',
            ),
            array(
                'name' => 'sys_lockedrecords',
                'description' => 'Record locking of backend user editing',
            ),
            array(
                'name' => 'sys_log',
                'description' => 'General log table',
            ),
            array(
                'name' => 'sys_preview',
                'description' => 'Workspace preview links',
            ),
            array(
                'name' => 'tx_extensionmanager_domain_model_extension',
                'description' => 'List of TER extensions',
            ),
            array(
                'name' => 'tx_rsaauth_keys',
                'description' => 'Login process key storage'
            ),
        );
        $database = $this->getDatabaseConnection();
        $allTables = array_keys($database->admin_get_tables());
        $tables = array();
        foreach ($tableCandidates as $candidate) {
            if (in_array($candidate['name'], $allTables)) {
                $candidate['rows'] = $database->exec_SELECTcountRows('*', $candidate['name']);
                $tables[] = $candidate;
            }
        }
        return $tables;
    }

    protected function clearSelectedTables() {
        $clearedTables = array();
        $database = $this->getDatabaseConnection();
        foreach ($this->postValues['values'] as $tableName => $selected) {
            if ($selected == 1) {
                $database->exec_TRUNCATEquery($tableName);
                $clearedTables[] = $tableName;
            }
        }
        if (count($clearedTables)) {
            $message = $this->objectManager->get('TYPO3\\CMS\\Install\\Status\\OkStatus');
            $message->setTitle('Cleared tables');
            $message->setMessage('List of cleared tables: ' . implode(', ', $clearedTables));
        } else {
            $message = $this->objectManager->get('TYPO3\\CMS\\Install\\Status\\InfoStatus');
            $message->setTitle('No tables selected to clear');
        }
        return $message;
    }

    protected function resetBackendUserUc() {
        $database = $this->getDatabaseConnection();
        $database->exec_UPDATEquery('be_users', '', array('uc' => ''));
        $message = $this->objectManager->get('TYPO3\\CMS\\Install\\Status\\OkStatus');
        $message->setTitle('Reset all backend users preferences');
        return $message;
    }

    protected function getTypo3TempStatistics() {
        $data = array();
        $pathTypo3Temp= PATH_site . 'typo3temp/';
        $postValues = $this->postValues['values'];

        $condition = '0';
        if (isset($postValues['condition'])) {
            $condition = $postValues['condition'];
        }
        $numberOfFilesToDelete = 0;
        if (isset($postValues['numberOfFiles'])) {
            $numberOfFilesToDelete = $postValues['numberOfFiles'];
        }
        $subDirectory = '';
        if (isset($postValues['subDirectory'])) {
            $subDirectory = $postValues['subDirectory'];
        }

        // Run through files
        $fileCounter = 0;
        $deleteCounter = 0;
        $criteriaMatch = 0;
        $timeMap = array('day' => 1, 'week' => 7, 'month' => 30);
        $directory = @dir($pathTypo3Temp . $subDirectory);
        if (is_object($directory)) {
            while ($entry = $directory->read()) {
                $absoluteFile = $pathTypo3Temp . $subDirectory . '/' . $entry;
                if (@is_file($absoluteFile)) {
                    $ok = FALSE;
                    $fileCounter++;
                    if ($condition) {
                        if (MathUtility::canBeInterpretedAsInteger($condition)) {
                            if (filesize($absoluteFile) > $condition * 1024) {
                                $ok = TRUE;
                            }
                        } else {
                            if (fileatime($absoluteFile) < $GLOBALS['EXEC_TIME'] - (int)$timeMap[$condition] * 60 * 60 * 24) {
                                $ok = TRUE;
                            }
                        }
                    } else {
                        $ok = TRUE;
                    }
                    if ($ok) {
                        $hashPart = substr(basename($absoluteFile), -14, 10);
                        // This is a kind of check that the file being deleted has a 10 char hash in it
                        if (
                            !preg_match('/[^a-f0-9]/', $hashPart)
                            || substr($absoluteFile, -6) === '.cache'
                            || substr($absoluteFile, -4) === '.tbl'
                            || substr($absoluteFile, -4) === '.css'
                            || substr($absoluteFile, -3) === '.js'
                            || substr($absoluteFile, -5) === '.gzip'
                            || substr(basename($absoluteFile), 0, 8) === 'installTool'
                        ) {
                            if ($numberOfFilesToDelete && $deleteCounter < $numberOfFilesToDelete) {
                                $deleteCounter++;
                                unlink($absoluteFile);
                            } else {
                                $criteriaMatch++;
                            }
                        }
                    }
                }
            }
            $directory->close();
        }
        $data['numberOfFilesMatchingCriteria'] = $criteriaMatch;
        $data['numberOfDeletedFiles'] = $deleteCounter;

        if ($deleteCounter > 0) {
            $message = $this->objectManager->get('TYPO3\\CMS\\Install\\Status\\OkStatus');
            $message->setTitle('Deleted ' . $deleteCounter . ' files from typo3temp/' . $subDirectory . '/');
            $this->actionMessages[] = $message;
        }

        $data['selectedCondition'] = $condition;
        $data['numberOfFiles'] = $numberOfFilesToDelete;
        $data['selectedSubDirectory'] = $subDirectory;

        // Set up sub directory data
        $data['subDirectories'] = array(
            '' => array(
                'name' => '',
                'filesNumber' => count(GeneralUtility::getFilesInDir($pathTypo3Temp)),
            ),
        );
        $directories = dir($pathTypo3Temp);
        if (is_object($directories)) {
            while ($entry = $directories->read()) {
                if (is_dir($pathTypo3Temp . $entry) && $entry != '..' && $entry != '.') {
                    $data['subDirectories'][$entry]['name'] = $entry;
                    $data['subDirectories'][$entry]['filesNumber'] = count(GeneralUtility::getFilesInDir($pathTypo3Temp . $entry));
                    $data['subDirectories'][$entry]['selected'] = FALSE;
                    if ($entry === $data['selectedSubDirectory']) {
                        $data['subDirectories'][$entry]['selected'] = TRUE;
                    }
                }
            }
        }
        $data['numberOfFilesInSelectedDirectory'] = $data['subDirectories'][$data['selectedSubDirectory']]['filesNumber'];

        return $data;
    }

    protected function clearProcessedFiles() {
        // make the DB available
        $GLOBALS['TYPO3_DB'] = $this->getDatabaseConnection();

        $repository = GeneralUtility::makeInstance('TYPO3\\CMS\\Core\\Resource\\ProcessedFileRepository');
        $failedDeletions = $repository->removeAll();
        if ($failedDeletions) {
            $message = $this->objectManager->get('TYPO3\\CMS\\Install\\Status\\ErrorStatus');
            $message->setTitle('Failed to delete ' . $failedDeletions . ' processed files. See TYPO3 log (by default typo3temp/logs/typo3.log)');
        } else {
            $message = $this->objectManager->get('TYPO3\\CMS\\Install\\Status\\OkStatus');
            $message->setTitle('Cleared processed files');
        }

        return $message;
    }

}