settings = new DB_Cleaner_Settings( $this->options ); add_action( 'wp_ajax_adminoptim_clean_db_now', [ $this, 'ajax_clean_db_now' ] ); add_action( 'init', [ $this, 'schedule_database_cleanup' ] ); add_action( 'adminoptim_database_cleanup', [ $this, 'clean_db_on_schedule' ] ); add_action( 'adminoptim_database_remnant_cleanup', [ $this, 'clean_remnant' ] ); add_action( 'adminoptim_deactivate_plugin', [ $this, 'remove_schedule_on_deactivation' ] ); add_filter( 'adminoptim_notification_message_' . self::MODULE_SLUG, static function ( string $message, string $display ): string { if ( 'banner' === $display ) { return sprintf( /* translators: 1: Opening strong tag, 2: Closing strong tag. */ __( '%1$sKeeping your WordPress database clean?%2$s Leave a ★★★★★ review on WordPress.org and help others discover Admin Optimizer.', 'admin-optimizer' ), '', '' ); } else { return sprintf( /* translators: 1: Opening strong tag, 2: Closing strong tag. */ __( '%1$sKeeping your WordPress database clean?%2$s Schedule automatic cleanups and unlock advanced database maintenance with Admin Optimizer Pro.', 'admin-optimizer' ), '', '' ); } }, 10, 2 ); } /** * Set default options for this module. * * @return array */ protected function get_default_options() { return [ 'enable_day' => 'sunday', 'enable_time_hour' => '3', 'enable_time_min' => '00', 'enable_logging' => '1', 'delete_revisions' => '1', 'delete_auto_draft' => '1', 'delete_trashed_posts' => '1', 'delete_orphaned_postmeta' => '1', 'delete_duplicate_postmeta' => '1', 'delete_empty_postmeta' => '1', 'delete_oembed_cache' => '1', 'delete_unapproved_comments' => '1', 'delete_spam_comments' => '1', 'delete_trashed_comments' => '1', 'delete_duplicate_commentmeta' => '1', 'delete_orphaned_commentmeta' => '1', 'delete_empty_commentmeta' => '1', 'delete_pingbacks' => '1', 'delete_unused_terms' => '1', 'delete_duplicate_termmeta' => '1', 'delete_orphaned_termmeta' => '1', 'delete_orphaned_term_rs' => '1', 'delete_duplicate_usermeta' => '1', 'delete_orphaned_usermeta' => '1', 'batch_size' => 500, ]; } /** * Return the module's submenu definition. * * @return array */ protected function get_submenu_config(): array { return [ 'page_title' => __( 'Database Cleaner', 'admin-optimizer' ), 'menu_title' => __( 'Database Cleaner', 'admin-optimizer' ), 'menu_slug' => self::MENU_SLUG, 'callback' => [ $this->settings, 'render_settings_page' ], ]; } /** * Schedule database cleanup * * @return void */ public function schedule_database_cleanup() { if ( ! empty( $this->options['enable'] ) ) { $day = $this->options['enable_day'] ?? 'sunday'; $hour = $this->options['enable_time_hour'] ?? '3'; // set default time as 3am. $min = $this->options['enable_time_min'] ?? '00'; $timestamp = strtotime( "this $day $hour hour $min minutes" ); if ( $timestamp < time() ) { $timestamp = strtotime( "next $day $hour hour $min minutes" ); } if ( ! as_has_scheduled_action( 'adminoptim_database_cleanup' ) ) { as_schedule_recurring_action( $timestamp, WEEK_IN_SECONDS, 'adminoptim_database_cleanup', [], '', true ); } } elseif ( as_has_scheduled_action( 'adminoptim_database_cleanup' ) ) { as_unschedule_all_actions( 'adminoptim_database_cleanup' ); } } /** * Deactivate schedule * * @return void */ public function remove_schedule_on_deactivation() { if ( as_has_scheduled_action( 'adminoptim_database_cleanup' ) ) { as_unschedule_action( 'adminoptim_database_cleanup' ); } } /** * Clean database on schedule * * @return void */ public function clean_db_on_schedule() { set_time_limit( 300 ); // phpcs:ignore Squiz.PHP.DiscouragedFunctions.Discouraged $log = [ 'start' => time() ]; $log_message = []; $cleaner = new DB_Queries(); try { if ( ! empty( $this->options['delete_revisions'] ) ) { $response = $cleaner->clean_revisions(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' revisions deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_auto_draft'] ) ) { $response = $cleaner->clean_auto_draft(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' Auto draft deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_trashed_posts'] ) ) { $response = $cleaner->clean_trashed_post(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' trashed posts deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_orphaned_postmeta'] ) ) { $response = $cleaner->clean_orphaned_postmeta(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' orphaned post meta deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_duplicate_postmeta'] ) ) { $response = $cleaner->clean_duplicate_postmeta(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' duplicate post meta deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_empty_postmeta'] ) ) { $response = $cleaner->clean_empty_postmeta(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' empty post meta deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_oembed_cache'] ) ) { $response = $cleaner->clean_oembed_cache(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' oEmbed cache deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_unapproved_comments'] ) ) { $response = $cleaner->clean_comments(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' unapproved comments deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_spam_comments'] ) ) { $response = $cleaner->clean_comments( 'spam' ); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' spam comments deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_trashed_comments'] ) ) { $response = $cleaner->clean_comments( 'trash' ); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' trashed comments deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_duplicate_commentmeta'] ) ) { $response = $cleaner->clean_duplicate_commentmeta(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' duplicate comment meta deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_orphaned_commentmeta'] ) ) { $response = $cleaner->clean_orphaned_commentmeta(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' orphaned comment meta deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_empty_commmentmeta'] ) ) { $response = $cleaner->clean_empty_commentmeta(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' empty comment meta deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_pingbacks'] ) ) { $response = $cleaner->clean_pingbacks(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' pingbacks deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_unused_terms'] ) ) { $response = $cleaner->clean_unused_terms(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' unused terms deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_duplicate_termmeta'] ) ) { $response = $cleaner->clean_duplicate_termmeta(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' duplicate term meta deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_orphaned_termmeta'] ) ) { $response = $cleaner->clean_orphaned_termmeta(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' orphaned term meta deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_orphaned_term_rs'] ) ) { $response = $cleaner->clean_orphaned_term_rs(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' orphaned term relationship deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_duplicate_usermeta'] ) ) { $response = $cleaner->clean_duplicate_usermeta(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' duplicate user meta deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } if ( ! empty( $this->options['delete_orphaned_usermeta'] ) ) { $response = $cleaner->clean_orphaned_usermeta(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html( $response['count'] . __( ' orphaned user meta deleted', 'admin-optimizer' ) ); } else { $log_message[] = esc_html( $response['message'] ); } } $response = $cleaner->optimize_database(); if ( 'success' === $response['status'] ) { $log_message[] = esc_html__( 'Optimized all tables in database', 'admin-optimizer' ); } else { $log_message[] = $response['message']; } } catch ( \Error $e ) { $log_message[] = $e->getMessage(); } $log['end'] = time(); $log['clean_log'] = implode( '%%', $log_message ); if ( ! empty( $this->options['enable_logging'] ) ) { $db_log = get_option( 'adminoptim_db_log', [] ); $db_log[] = $log; if ( 5 < count( $db_log ) ) { array_shift( $db_log ); } update_option( 'adminoptim_db_log', $db_log, false ); } } /** * Ajax function to clean db * * @return void */ public function ajax_clean_db_now() { if ( ! current_user_can( 'manage_options' ) ) { wp_send_json_error( new \WP_Error( 'adminoptim-unauthorized-user', ao_get_admin_notice( __( 'Unauthorized action.', 'admin-optimizer' ), [ 'type' => 'error', ] ) ) ); } check_ajax_referer( 'adminoptim-db-cleanup', 'nonce' ); do_action( 'adminoptim_database_cleanup' ); $response = [ 'message' => __( 'Database cleanup completed. Check the logs for more details.', 'admin-optimizer' ) ]; wp_send_json_success( $response ); } }