. */ declare(strict_types=1); namespace Fisharebest\Webtrees\Services; use Carbon\Carbon; use Exception; use Illuminate\Database\Capsule\Manager as DB; use League\Flysystem\Filesystem; /** * Clean up old data, files and folders. */ class HousekeepingService { // This is a list of old files and directories, from earlier versions of webtrees. // git diff 1.7.9..master --name-status | grep ^D private const OLD_PATHS = [ // Removed in 1.0.2 'language/en.mo', // Removed in 1.0.3 'themechange.php', // Removed in 1.1.0 'addremotelink.php', 'addsearchlink.php', 'client.php', 'dir_editor.php', 'editconfig_gedcom.php', 'editgedcoms.php', 'edit_merge.php', 'edit_news.php', 'genservice.php', 'logs.php', 'manageservers.php', 'media.php', 'module_admin.php', //WT_ROOT.'modules', // Do not delete - users may have stored custom modules/data here 'opensearch.php', 'PEAR.php', 'pgv_to_wt.php', 'places', //WT_ROOT.'robots.txt', // Do not delete this - it may contain user data 'serviceClientTest.php', 'siteconfig.php', 'SOAP', 'themes/clouds/mozilla.css', 'themes/clouds/netscape.css', 'themes/colors/mozilla.css', 'themes/colors/netscape.css', 'themes/fab/mozilla.css', 'themes/fab/netscape.css', 'themes/minimal/mozilla.css', 'themes/minimal/netscape.css', 'themes/webtrees/mozilla.css', 'themes/webtrees/netscape.css', 'themes/webtrees/style_rtl.css', 'themes/xenea/mozilla.css', 'themes/xenea/netscape.css', 'uploadmedia.php', 'useradmin.php', 'webservice', 'wtinfo.php', // Removed in 1.1.2 'treenav.php', // Removed in 1.2.0 'themes/clouds/jquery', 'themes/colors/jquery', 'themes/fab/jquery', 'themes/minimal/jquery', 'themes/webtrees/jquery', 'themes/xenea/jquery', // Removed in 1.2.2 'themes/clouds/chrome.css', 'themes/clouds/opera.css', 'themes/clouds/print.css', 'themes/clouds/style_rtl.css', 'themes/colors/chrome.css', 'themes/colors/opera.css', 'themes/colors/print.css', 'themes/colors/style_rtl.css', 'themes/fab/chrome.css', 'themes/fab/opera.css', 'themes/minimal/chrome.css', 'themes/minimal/opera.css', 'themes/minimal/print.css', 'themes/minimal/style_rtl.css', 'themes/xenea/chrome.css', 'themes/xenea/opera.css', 'themes/xenea/print.css', 'themes/xenea/style_rtl.css', // Removed in 1.2.3 'modules_v2', // Removed in 1.2.4 'search_engine.php', 'themes/clouds/modules.css', 'themes/colors/modules.css', 'themes/fab/modules.css', 'themes/minimal/modules.css', 'themes/webtrees/modules.css', 'themes/xenea/modules.css', // Removed in 1.2.5 'sidebar.php', // Removed in 1.2.6 // Removed in 1.2.7 'login_register.php', // Removed in 1.3.0 'admin_site_ipaddress.php', 'downloadgedcom.php', 'export_gedcom.php', 'gedcheck.php', 'images', // Removed in 1.3.1 'imageflush.php', '/lightbox/js/tip_balloon_RTL.js', // Removed in 1.4.0 'imageview.php', 'media/MediaInfo.txt', 'media/thumbs/ThumbsInfo.txt', 'themes/webtrees/chrome.css', // Removed in 1.4.2 'themes/clouds/jquery-ui-1.10.0', 'themes/colors/jquery-ui-1.10.0', 'themes/fab/jquery-ui-1.10.0', 'themes/minimal/jquery-ui-1.10.0', 'themes/webtrees/jquery-ui-1.10.0', 'themes/xenea/jquery-ui-1.10.0', // Removed in 1.5.0 'themes/clouds/favicon.png', 'themes/clouds/images', 'themes/clouds/msie.css', 'themes/clouds/style.css', 'themes/colors/css', 'themes/colors/favicon.png', 'themes/colors/images', 'themes/colors/ipad.css', 'themes/colors/msie.css', 'themes/fab/favicon.png', 'themes/fab/images', 'themes/fab/msie.css', 'themes/fab/style.css', 'themes/minimal/favicon.png', 'themes/minimal/images', 'themes/minimal/msie.css', 'themes/minimal/style.css', 'themes/webtrees/favicon.png', 'themes/webtrees/images', 'themes/webtrees/msie.css', 'themes/webtrees/style.css', 'themes/xenea/favicon.png', 'themes/xenea/images', 'themes/xenea/msie.css', 'themes/xenea/style.css', // Removed in 1.5.1 'themes/clouds/css-1.5.0', 'themes/colors/css-1.5.0', 'themes/fab/css-1.5.0', 'themes/minimal/css-1.5.0', 'themes/webtrees/css-1.5.0', 'themes/xenea/css-1.5.0', // Removed in 1.5.2 'themes/clouds/css-1.5.1', 'themes/colors/css-1.5.1', 'themes/fab/css-1.5.1', 'themes/minimal/css-1.5.1', 'themes/webtrees/css-1.5.1', 'themes/xenea/css-1.5.1', // Removed in 1.5.3 'readme.html', 'themes/clouds/css-1.5.2', 'themes/colors/css-1.5.2', 'themes/fab/css-1.5.2', 'themes/minimal/css-1.5.2', 'themes/webtrees/css-1.5.2', 'themes/xenea/css-1.5.2', // Removed in 1.6.0 'downloadbackup.php', 'site-php-version.php', 'themes/clouds/css-1.5.3', 'themes/colors/css-1.5.3', 'themes/fab/css-1.5.3', 'themes/minimal/css-1.5.3', 'themes/webtrees/css-1.5.3', 'themes/xenea/css-1.5.3', // Removed in 1.6.2 'themes/clouds/jquery-ui-1.10.3', 'themes/colors/css-1.6.0', 'themes/colors/jquery-ui-1.10.3', 'themes/fab/css-1.6.0', 'themes/fab/jquery-ui-1.10.3', 'themes/minimal/css-1.6.0', 'themes/minimal/jquery-ui-1.10.3', 'themes/webtrees/css-1.6.0', 'themes/webtrees/jquery-ui-1.10.3', 'themes/xenea/css-1.6.0', 'themes/xenea/jquery-ui-1.10.3', // Removed in 1.7.0 'admin_site_other.php', 'js', 'language/en_GB.mo', // Replaced with en-GB.mo 'language/en_US.mo', // Replaced with en-US.mo 'language/pt_BR.mo', // Replaced with pt-BR.mo 'language/zh_CN.mo', // Replaced with zh-Hans.mo 'language/extra', 'library', 'save.php', 'themes/clouds/css-1.6.2', 'themes/clouds/templates', 'themes/clouds/header.php', 'themes/clouds/footer.php', 'themes/colors/css-1.6.2', 'themes/colors/templates', 'themes/colors/header.php', 'themes/colors/footer.php', 'themes/fab/css-1.6.2', 'themes/fab/templates', 'themes/fab/header.php', 'themes/fab/footer.php', 'themes/minimal/css-1.6.2', 'themes/minimal/templates', 'themes/minimal/header.php', 'themes/minimal/footer.php', 'themes/webtrees/css-1.6.2', 'themes/webtrees/templates', 'themes/webtrees/header.php', 'themes/webtrees/footer.php', 'themes/xenea/css-1.6.2', 'themes/xenea/templates', 'themes/xenea/header.php', 'themes/xenea/footer.php', // Removed in 1.7.2 'assets/js-1.7.0', // Removed in 1.7.4 'assets/js-1.7.2', 'themes/clouds/css-1.7.0', 'themes/colors/css-1.7.0', 'themes/fab/css-1.7.0', 'themes/minimal/css-1.7.0', 'themes/webtrees/css-1.7.0', 'themes/xenea/css-1.7.0', // Removed in 1.7.5 'themes/clouds/css-1.7.4', 'themes/colors/css-1.7.4', 'themes/fab/css-1.7.4', 'themes/minimal/css-1.7.4', 'themes/webtrees/css-1.7.4', 'themes/xenea/css-1.7.4', // Removed in 1.7.7 'assets/js-1.7.4', // Removed in 1.7.8 'themes/clouds/css-1.7.5', 'themes/colors/css-1.7.5', 'themes/fab/css-1.7.5', 'themes/minimal/css-1.7.5', 'themes/webtrees/css-1.7.5', 'themes/xenea/css-1.7.5', // Removed in 2.0.0 'action.php', 'addmedia.php', 'addmin.php', 'admin_media.php', 'admin_media_upload.php', 'admin_module_blocks.php', 'admin_module_charts.php', 'admin_module_menus.php', 'admin_module_reports.php', 'admin_module_sidebar.php', 'admin_module_tabs.php', 'admin_modules.php', 'admin_pgv_to_wt.php', 'admin_site_access.php', 'admin_site_change.php', 'admin_site_clean.php', 'admin_site_config.php', 'admin_site_info.php', 'admin_site_logs.php', 'admin_site_merge.php', 'admin_site_readme.php', 'admin_site_upgrade.php', 'admin_trees_check.php', 'admin_trees_config.php', 'admin_trees_download.php', 'admin_trees_duplicates.php', 'admin_trees_export.php', 'admin_trees_manage.php', 'admin_trees_merge.php', 'admin_trees_places.php', 'admin_trees_renumber.php', 'admin_trees_unconnected.php', 'admin_users.php', 'admin_users_bulk.php', 'ancestry.php', 'app/Controller', 'app/HitCounter.php', 'app/Module/ClippingsCart/ClippingsCartController.php', 'app/Module/FamiliesSidebarModule.php', 'app/Module/FamilyTreeFavorites', 'app/Module/GoogleMaps', 'app/Module/IndividualSidebarModule.php', 'app/Module/PageMenuModule.php', 'app/Query', 'app/SpecialChars', 'assets/js-1.7.7', 'assets/js-1.7.9', 'autocomplete.php', 'block_edit.php', 'branches.php', 'calendar.php', 'compact.php', 'data/html_purifier_cache', 'descendancy.php', 'editnews.php', 'edituser.php', 'edit_changes.php', 'edit_interface.php', 'expand_view.php', 'familybook.php', 'famlist.php', 'fanchart.php', 'find.php', 'help_text.php', 'hourglass.php', 'hourglass_ajax.php', 'import.php', 'includes', 'index_edit.php', 'indilist.php', 'inverselink.php', 'lifespan.php', 'login.php', 'logout.php', 'mediafirewall.php', 'medialist.php', 'message.php', 'module.php', 'modules_v3', 'notelist.php', 'packages', 'pedigree.php', 'relationship.php', 'repolist.php', 'reportengine.php', 'search.php', 'search_advanced.php', 'site-offline.php', 'site-unavailable.php', 'sourcelist.php', 'statistics.php', 'statisticsplot.php', 'themes/_administration', 'themes/_custom', 'themes/clouds/css-1.7.8', 'themes/clouds/jquery-ui-1.11.2', 'themes/colors/css-1.7.8', 'themes/colors/jquery-ui-1.11.2', 'themes/fab/css-1.7.8', 'themes/fab/jquery-ui-1.11.2', 'themes/minimal/css-1.7.8', 'themes/minimal/jquery-ui-1.11.2', 'themes/webtrees/css-1.7.8', 'themes/webtrees/jquery-ui-1.11.2', 'themes/xenea/css-1.7.8', 'themes/xenea/jquery-ui-1.11.2', 'timeline.php', ]; /** * Delete files and folders that belonged to an earlier version of webtrees. * Return a list of those that we could not delete. * * @param Filesystem $filesystem * * @return array */ public function deleteOldWebtreesFiles(Filesystem $filesystem): array { $paths_to_delete = []; foreach (self::OLD_PATHS as $path) { if (!$this->deleteFileOrFolder($filesystem, $path)) { $paths_to_delete[] = $path; } } return $paths_to_delete; } /** * Delete old cache files. * * @param Filesystem $filesystem * @param string $path * @param int $max_age Seconds * * @return void */ public function deleteOldFiles(Filesystem $filesystem, string $path, int $max_age) { $list = $filesystem->listContents($path, true); $timestamp = Carbon::now()->timestamp; foreach ($list as $metadata) { if ($metadata['timestamp'] ?? $timestamp < $timestamp - $max_age) { $this->deleteFileOrFolder($filesystem, $metadata['path']); } } } /** * @param int $max_age_in_seconds * * @return void */ public function deleteOldLogs(int $max_age_in_seconds) { $timestamp = Carbon::now()->subSeconds($max_age_in_seconds); DB::table('log') ->whereIn('log_type', ['error', 'media']) ->where('log_time', '<', $timestamp) ->delete(); } /** * @param int $max_age_in_seconds * * @return void */ public function deleteOldSessions(int $max_age_in_seconds) { $timestamp = Carbon::now()->subSeconds($max_age_in_seconds); DB::table('session') ->where('session_time', '<', $timestamp) ->delete(); } /** * Delete a file or folder, if we can. * * @param Filesystem $filesystem * @param string $path * * @return bool */ private function deleteFileOrFolder(Filesystem $filesystem, string $path): bool { if ($filesystem->has($path)) { try { $metadata = $filesystem->getMetadata($path); if ($metadata['type'] === 'dir') { $filesystem->deleteDir($path); } if ($metadata['type'] === 'file') { $filesystem->delete($path); } } catch (Exception $ex) { return false; } } return true; } }