Файловый менеджер

Файловый менеджер - Редактировать - /home/bean7936/deribos.com/wp-content3e392d/plugins/breeze/inc/breeze-configuration.php

Назад
<?php /** * @copyright 2017 Cloudways https://www.cloudways.com * * This plugin is inspired from WP Speed of Light by JoomUnited. * * This program 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. * * This program 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. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA / defined( 'ABSPATH' ) \|\| die( 'No direct script access allowed!' ); class Breeze_Configuration { public function __construct() { global $breeze_network_subsite_settings; $breeze_network_subsite_settings = false; // Save the tabs settings. add_action( 'wp_ajax_save_settings_tab_basic', array( &$this, 'update_options_for_basic' ) ); add_action( 'wp_ajax_save_settings_tab_file', array( &$this, 'update_options_for_file' ) ); add_action( 'wp_ajax_save_settings_tab_preload', array( &$this, 'update_options_for_preload' ) ); add_action( 'wp_ajax_save_settings_tab_advanced', array( &$this, 'update_options_for_advanced' ) ); add_action( 'wp_ajax_save_settings_tab_heartbeat', array( &$this, 'update_options_for_heartbeat' ) ); add_action( 'wp_ajax_save_settings_tab_database', array( &$this, 'update_options_for_database' ) ); add_action( 'wp_ajax_save_settings_tab_cdn', array( &$this, 'update_options_for_cdn' ) ); add_action( 'wp_ajax_save_settings_tab_tools', array( &$this, 'update_options_for_tools' ) ); add_action( 'wp_ajax_save_settings_tab_faq', array( &$this, 'update_options_for_faq' ) ); add_action( 'wp_ajax_save_settings_tab_varnish', array( &$this, 'update_options_for_varnish' ) ); add_action( 'wp_ajax_save_settings_tab_inherit', array( &$this, 'update_options_for_inherit' ) ); add_action( 'wp_ajax_refresh_api_token_key', array( &$this, 'regenerate_breeze_api_key' ) ); } /* * Regenerate breeze API key via ajax * @return void * @throws Exception / public function regenerate_breeze_api_key() { breeze_is_restricted_access(); check_ajax_referer( '_breeze_save_options', 'security' ); set_as_network_screen(); $breeze_api_token = self::breeze_generate_token(); $response = array(); $response['new_token'] = $breeze_api_token; wp_send_json( $response ); } public function update_options_for_varnish() { breeze_is_restricted_access(); check_ajax_referer( '_breeze_save_options', 'security' ); set_as_network_screen(); $wp_filesystem = breeze_get_filesystem(); $response = array(); $post_item = array(); if ( isset( $_POST['form-data'] ) ) { parse_str( wp_unslash( $_POST['form-data'] ), $post_item ); // phpcs:ignore WordPress.Security.ValidatedSanitizedInput.InputNotSanitized } $varnish = array( 'auto-purge-varnish' => ( isset( $post_item['auto-purge-varnish'] ) ? '1' : '0' ), 'breeze-varnish-server-ip' => preg_replace( '/[^a-zA-Z0-9\-\_\.]/', '', $post_item['varnish-server-ip'] ), ); breeze_update_option( 'varnish_cache', $varnish, true ); Breeze_ConfigCache::factory()->write_config_cache(); // Clear varnish cache after settings do_action( 'breeze_clear_varnish' ); wp_send_json( $response ); } /** * Save the Basic Options settings via Ajax call. * * @access public * @since 2.0.0 / public function update_options_for_basic() { breeze_is_restricted_access(); check_ajax_referer( '_breeze_save_options', 'security' ); set_as_network_screen(); $wp_filesystem = breeze_get_filesystem(); $response = array(); $post_item = array(); if ( isset( $_POST['form-data'] ) ) { parse_str( wp_unslash( $_POST['form-data'] ), $post_item ); } $post_activate_cache = isset( $post_item['breeze-admin-cache'] ) ? $post_item['breeze-admin-cache'] : array(); $all_user_roles = breeze_all_wp_user_roles(); $active_cache_users = array(); foreach ( $all_user_roles as $usr_role ) { $active_cache_users[ $usr_role ] = 0; if ( isset( $post_activate_cache[ $usr_role ] ) ) { $active_cache_users[ $usr_role ] = 1; } } $iframe_lazy_load = ( isset( $post_item['bz-lazy-load-iframe'] ) ? '1' : '0' ); $iframe_lazy_videos = ( isset( $post_item['bz-lazy-load-videos'] ) ? '1' : '0' ); $lazy_load = ( isset( $post_item['bz-lazy-load'] ) ? '1' : '0' ); if ( false === filter_var( $lazy_load, FILTER_VALIDATE_BOOLEAN ) ) { $iframe_lazy_load = '0'; } $separate_mobile_cache_system = ( isset( $post_item['breeze-mobile-separate'] ) ? '1' : '0' ); // The values for this work different on CW server. // Added exception. $is_cloudways_server = breeze_is_cloudways_server(); if ( true === $is_cloudways_server ) { $mobile_cache_cw = is_breeze_mobile_cache( true ); if ( true === $mobile_cache_cw ) { $separate_mobile_cache_system = '1'; } else { $separate_mobile_cache_system = '0'; } } $basic = array( 'breeze-active' => ( isset( $post_item['cache-system'] ) ? '1' : '0' ), 'breeze-mobile-separate' => $separate_mobile_cache_system, 'breeze-cross-origin' => ( isset( $post_item['safe-cross-origin'] ) ? '1' : '0' ), 'breeze-disable-admin' => $active_cache_users, 'breeze-gzip-compression' => ( isset( $post_item['gzip-compression'] ) ? '1' : '0' ), 'breeze-browser-cache' => ( isset( $post_item['browser-cache'] ) ? '1' : '0' ), 'breeze-lazy-load' => ( isset( $post_item['bz-lazy-load'] ) ? '1' : '0' ), 'breeze-lazy-load-native' => ( isset( $post_item['bz-lazy-load-nat'] ) ? '1' : '0' ), 'breeze-lazy-load-iframes' => $iframe_lazy_load, 'breeze-lazy-load-videos' => $iframe_lazy_videos, 'breeze-desktop-cache' => '1', 'breeze-mobile-cache' => '1', 'breeze-display-clean' => '1', 'breeze-b-ttl' => (int) $post_item['cache-ttl'], ); breeze_update_option( 'basic_settings', $basic, true ); // Storage information to cache pages Breeze_ConfigCache::factory()->write(); Breeze_ConfigCache::factory()->write_config_cache(); // Turn on WP_CACHE to support advanced-cache file if ( isset( $post_item['cache-system'] ) ) { Breeze_ConfigCache::factory()->toggle_caching( true ); } else { Breeze_ConfigCache::factory()->toggle_caching( false ); } // Reschedule cron events if ( isset( $post_item['cache-system'] ) ) { Breeze_PurgeCacheTime::factory()->unschedule_events(); Breeze_PurgeCacheTime::factory()->schedule_events( (int) $post_item['cache-ttl'] ); } // Add expires header self::update_htaccess(); //delete cache after settings do_action( 'breeze_clear_all_cache' ); wp_send_json( $response ); } /* * Save the File optimisation tab settings via Ajax call. * * @access public * @since 2.0.0 / public function update_options_for_file() { breeze_is_restricted_access(); check_ajax_referer( '_breeze_save_options', 'security' ); set_as_network_screen(); $wp_filesystem = breeze_get_filesystem(); $response = array(); $post_item = array(); if ( isset( $_POST['form-data'] ) ) { parse_str( wp_unslash( $_POST['form-data'] ), $post_item ); } $exclude_css = $this->string_convert_arr( sanitize_textarea_field( $post_item['exclude-css'] ) ); $exclude_js = $this->string_convert_arr( sanitize_textarea_field( $post_item['exclude-js'] ) ); $no_delay_js = $this->string_convert_arr( sanitize_textarea_field( $post_item['no-delay-js-scripts'] ) ); $delay_js = $this->string_convert_arr( sanitize_textarea_field( $post_item['delay-js-scripts'] ) ); if ( ! empty( $exclude_js ) ) { $exclude_js = array_unique( $exclude_js ); } if ( ! empty( $no_delay_js ) ) { $no_delay_js = array_unique( $no_delay_js ); } if ( ! empty( $delay_js ) ) { $delay_js = array_unique( $delay_js ); } if ( ! empty( $exclude_css ) ) { $exclude_css = array_unique( $exclude_css ); } $move_to_footer_js = $defer_js = array(); if ( ! empty( $post_item['move-to-footer-js'] ) ) { foreach ( $post_item['move-to-footer-js'] as $url ) { if ( trim( $url ) == '' ) { continue; } $url = current( explode( '?', $url, 2 ) ); $move_to_footer_js[ sanitize_text_field( $url ) ] = sanitize_text_field( $url ); } } if ( ! empty( $post_item['defer-js'] ) ) { foreach ( $post_item['defer-js'] as $url ) { if ( trim( $url ) == '' ) { continue; } $url = current( explode( '?', $url, 2 ) ); $defer_js[ sanitize_text_field( $url ) ] = sanitize_text_field( $url ); } } $is_minification_js = ( isset( $post_item['minification-js'] ) ? '1' : '0' ); $is_inline_minification_js = ( isset( $post_item['include-inline-js'] ) ? '1' : '0' ); $is_group_js = ( isset( $post_item['group-js'] ) ? '1' : '0' ); if ( 0 === absint( $is_minification_js ) \|\| 0 === absint( $is_inline_minification_js ) ) { //$is_group_js = '0'; } $file_settings = array( 'breeze-minify-html' => ( isset( $post_item['minification-html'] ) ? '1' : '0' ), // -- 'breeze-minify-css' => ( isset( $post_item['minification-css'] ) ? '1' : '0' ), 'breeze-font-display-swap' => ( isset( $post_item['font-display'] ) ? '1' : '0' ), 'breeze-group-css' => ( isset( $post_item['group-css'] ) ? '1' : '0' ), 'breeze-exclude-css' => $exclude_css, 'breeze-include-inline-css' => ( isset( $post_item['include-inline-css'] ) ? '1' : '0' ), // -- 'breeze-minify-js' => $is_minification_js, 'breeze-group-js' => $is_group_js, 'breeze-include-inline-js' => $is_inline_minification_js, 'breeze-exclude-js' => $exclude_js, 'breeze-move-to-footer-js' => $move_to_footer_js, 'breeze-defer-js' => $defer_js, 'breeze-enable-js-delay' => ( isset( $post_item['enable-js-delay'] ) ? '1' : '0' ), 'breeze-delay-js-scripts' => $delay_js, 'no-breeze-no-delay-js' => $no_delay_js, 'breeze-delay-all-js' => ( isset( $post_item['breeze-delay-all-js'] ) ? '1' : '0' ), ); breeze_update_option( 'file_settings', $file_settings, true ); // Storage information to cache pages. Breeze_ConfigCache::factory()->write(); Breeze_ConfigCache::factory()->write_config_cache(); // Delete cache after settings do_action( 'breeze_clear_all_cache' ); wp_send_json( $response ); } /* * Save the Preload option settings via Ajax call. * * @access public * @since 2.0.0 / public function update_options_for_preload() { breeze_is_restricted_access(); check_ajax_referer( '_breeze_save_options', 'security' ); set_as_network_screen(); $wp_filesystem = breeze_get_filesystem(); $response = array(); $preload_fonts = array(); $post_item = array(); if ( isset( $_POST['form-data'] ) ) { parse_str( wp_unslash( $_POST['form-data'] ), $post_item ); } if ( isset( $post_item['breeze-preload-font'] ) && ! empty( $post_item['breeze-preload-font'] ) ) { foreach ( $post_item['breeze-preload-font'] as $font_url ) { if ( '' === trim( $font_url ) ) { continue; } $font_url = current( explode( '?', $font_url, 2 ) ); $preload_fonts[ sanitize_text_field( $font_url ) ] = sanitize_text_field( $font_url ); } } $prefetch_urls = $this->string_convert_arr( sanitize_textarea_field( $post_item['br-prefetch-urls'] ) ); if ( ! empty( $prefetch_urls ) ) { $prefetch_urls = array_unique( $prefetch_urls ); // ltrim( $current_url, 'https:' ) foreach ( $prefetch_urls as &$url_prefetch ) { //$url_prefetch = ltrim( $url_prefetch, 'https:' ); $link_schema = wp_parse_url( $url_prefetch ); if ( isset( $link_schema['host'] ) ) { $url_prefetch = '//' . $link_schema['host']; } else { unset( $url_prefetch ); } } } $preload = array( 'breeze-preload-fonts' => $preload_fonts, 'breeze-preload-links' => ( isset( $post_item['preload-links'] ) ? '1' : '0' ), 'breeze-prefetch-urls' => $prefetch_urls, ); breeze_update_option( 'preload_settings', $preload, true ); // Storage information to cache pages. Breeze_ConfigCache::factory()->write(); Breeze_ConfigCache::factory()->write_config_cache(); // Delete cache after settings do_action( 'breeze_clear_all_cache' ); wp_send_json( $response ); } /* * Save the Advanced option settings via Ajax call. * * @access public * @throws Exception * @since 2.0.0 / public function update_options_for_advanced() { breeze_is_restricted_access(); check_ajax_referer( '_breeze_save_options', 'security' ); set_as_network_screen(); $wp_filesystem = breeze_get_filesystem(); $response = array(); $post_item = array(); if ( isset( $_POST['form-data'] ) ) { parse_str( wp_unslash( $_POST['form-data'] ), $post_item ); } $exclude_urls = $this->string_convert_arr( isset( $post_item['exclude-urls'] ) ? $post_item['exclude-urls'] : '' ); if ( is_array( $exclude_urls ) && ! empty( $exclude_urls ) ) { foreach ( $exclude_urls as &$url_list_item ) { if ( false === strpos( $url_list_item, ':' ) ) { $url_list_item = esc_url( '/' . $url_list_item ); $url_list_item = ltrim( $url_list_item, '/' ); } else { $url_list_item = esc_url( $url_list_item ); } } } $cache_query_str = $this->string_convert_arr( sanitize_textarea_field( $post_item['cache-query-str'] ) ); $breeze_api_token = $post_item['breeze-api-token']; if ( ! empty( $exclude_urls ) ) { $exclude_urls = array_unique( $exclude_urls ); } if ( ! empty( $cache_query_str ) ) { $cache_query_str = array_unique( $cache_query_str ); } if ( empty( $breeze_api_token ) ) { $breeze_api_token = self::breeze_generate_token(); } $advanced = array( 'breeze-exclude-urls' => $exclude_urls, 'cached-query-strings' => $cache_query_str, 'breeze-wp-emoji' => ( isset( $post_item['breeze-wpjs-emoji'] ) ? '1' : '0' ), 'breeze-store-googlefonts-locally' => ( isset( $post_item['breeze-store-googlefonts-locally'] ) ? '1' : '0' ), 'breeze-store-googleanalytics-locally' => ( isset( $post_item['breeze-store-googleanalytics-locally'] ) ? '1' : '0' ), 'breeze-store-facebookpixel-locally' => ( isset( $post_item['breeze-store-facebookpixel-locally'] ) ? '1' : '0' ), 'breeze-store-gravatars-locally' => ( isset( $post_item['breeze-store-gravatars-locally'] ) ? '1' : '0' ), 'breeze-enable-api' => ( isset( $post_item['breeze-enable-api'] ) ? '1' : '0' ), 'breeze-api-token' => sanitize_text_field( $breeze_api_token ), ); if ( !empty( $breeze_api_token ) && true === $this->is_api_token_valid( $breeze_api_token ) ) { $advanced['breeze-api-token'] = sanitize_text_field($breeze_api_token); }else{ $current_token = Breeze_Options_Reader::get_option_value( 'breeze-api-token' ); if( !empty( $current_token ) ){ $advanced['breeze-api-token'] = sanitize_text_field($current_token); } } breeze_update_option( 'advanced_settings', $advanced, true ); // Storage information to cache pages. Breeze_ConfigCache::factory()->write(); Breeze_ConfigCache::factory()->write_config_cache(); // Delete cache after settings do_action( 'breeze_clear_all_cache' ); wp_send_json( $response ); } public function is_api_token_valid($provided_token){ if ( strlen( $provided_token ) < 32 ) { return false; } return true; } /* * Save the Heartbeat API settings via Ajax call. * * @access public * @since 2.0.0 / public function update_options_for_heartbeat() { breeze_is_restricted_access(); check_ajax_referer( '_breeze_save_options', 'security' ); set_as_network_screen(); $wp_filesystem = breeze_get_filesystem(); $response = array(); $post_item = array(); if ( isset( $_POST['form-data'] ) ) { parse_str( wp_unslash( $_POST['form-data'] ), $post_item ); } $heartbeat = array( 'breeze-control-heartbeat' => ( isset( $post_item['breeze-control-hb'] ) ? '1' : '0' ), 'breeze-heartbeat-front' => sanitize_textarea_field( $post_item['br-heartbeat-front'] ), 'breeze-heartbeat-postedit' => sanitize_textarea_field( $post_item['br-heartbeat-postedit'] ), 'breeze-heartbeat-backend' => sanitize_textarea_field( $post_item['br-heartbeat-backend'] ), ); breeze_update_option( 'heartbeat_settings', $heartbeat, true ); // Storage information to cache pages. Breeze_ConfigCache::factory()->write(); Breeze_ConfigCache::factory()->write_config_cache(); // Delete cache after settings do_action( 'breeze_clear_all_cache' ); wp_send_json( $response ); } /* * Database tab only has actions for now and it will not save anything. * * @access public * @since 2.0.0 / public function update_options_for_database() { // Does not have anything to save. } /* * Save the CDN option settings via Ajax call. * * @access public * @since 2.0.0 / public function update_options_for_cdn() { breeze_is_restricted_access(); check_ajax_referer( '_breeze_save_options', 'security' ); set_as_network_screen(); $wp_filesystem = breeze_get_filesystem(); $response = array(); $post_item = array(); if ( isset( $_POST['form-data'] ) ) { parse_str( wp_unslash( $_POST['form-data'] ), $post_item ); } $cdn_content = array(); $exclude_content = array(); if ( ! empty( $post_item['cdn-content'] ) ) { $cdn_content = explode( ',', sanitize_text_field( $post_item['cdn-content'] ) ); $cdn_content = array_unique( $cdn_content ); } if ( ! empty( $post_item['cdn-exclude-content'] ) ) { $exclude_content = explode( ',', sanitize_text_field( $post_item['cdn-exclude-content'] ) ); $exclude_content = array_unique( $exclude_content ); } $cdn_url = ( isset( $post_item['cdn-url'] ) ? sanitize_text_field( $post_item['cdn-url'] ) : '' ); if ( ! empty( $cdn_url ) ) { $http_schema = wp_parse_url( $cdn_url, PHP_URL_SCHEME ); $cdn_url = ltrim( $cdn_url, 'https:' ); $cdn_url = '//' . ltrim( $cdn_url, '//' ); if ( ! empty( $http_schema ) ) { $cdn_url = $http_schema . ':' . $cdn_url; } } $cdn = array( 'cdn-active' => ( isset( $post_item['activate-cdn'] ) ? '1' : '0' ), 'cdn-url' => $cdn_url, 'cdn-content' => $cdn_content, 'cdn-exclude-content' => $exclude_content, 'cdn-relative-path' => ( isset( $post_item['cdn-relative-path'] ) ? '1' : '0' ), ); breeze_update_option( 'cdn_integration', $cdn, true ); // Storage information to cache pages. Breeze_ConfigCache::factory()->write(); Breeze_ConfigCache::factory()->write_config_cache(); // Delete cache after settings do_action( 'breeze_clear_all_cache' ); wp_send_json( $response ); } /* * Tools tab has not options that need save here. * * @access public * @since 2.0.0 / public function update_options_for_tools() { // Does not have anything to save. } /* * FAQ does not have any options to save, text information only. * * @access public * @since 2.0.0 / public function update_options_for_faq() { // Does not have anything to save. } /* * FAQ does not have any options to save, text information only. * * @access public * @since 2.0.0 / public function update_options_for_inherit() { breeze_is_restricted_access(); // Does not have anything to save. check_ajax_referer( 'breeze_inherit_settings', 'security' ); set_as_network_screen(); $wp_filesystem = breeze_get_filesystem(); $response = array(); $inherit_settings = ( ( true === filter_var( $_POST['is-selected'], FILTER_VALIDATE_BOOLEAN ) ) ? '1' : '0' ); update_option( 'breeze_inherit_settings', $inherit_settings ); Breeze_ConfigCache::factory()->write(); Breeze_ConfigCache::factory()->write_config_cache(); // Delete cache after settings do_action( 'breeze_clear_all_cache' ); wp_send_json( $response ); } /* * Trigger update to htaccess file. * * @param bool $clean If true, will clear custom .htaccess rules. * * @return bool / public static function update_htaccess( bool $clean = false ): bool { $htaccess_init = new Breeze_Htaccess_Settings(); if ( $clean ) { $htaccess_init->update_gzip_htaccess( true ); $htaccess_init->update_expires_htaccess( true ); return true; } if ( is_multisite() ) { $htaccess_init->update_gzip_htaccess( $clean ); $htaccess_init->update_expires_htaccess( $clean ); return true; } else { // Single-site setup. if ( '1' === Breeze_Options_Reader::get_option_value( 'breeze-active' ) ) { $is_gzip = Breeze_Options_Reader::get_option_value( 'breeze-gzip-compression' ); $is_expire = Breeze_Options_Reader::get_option_value( 'breeze-browser-cache' ); $is_gzip = ! filter_var( $is_gzip, FILTER_VALIDATE_BOOLEAN ); $is_expire = ! filter_var( $is_expire, FILTER_VALIDATE_BOOLEAN ); $htaccess_init->update_gzip_htaccess( $is_gzip ); $htaccess_init->update_expires_htaccess( $is_expire ); return true; } else { // Caching not activated, clean up. $htaccess_init->update_gzip_htaccess( true ); $htaccess_init->update_expires_htaccess( true ); return true; } } } /* * Database optimization actions. * Used to clean the database. * * Changed completely in 2.0.0 * * @param string $type Optimization type. * * @return bool * @since 2.0.0 / public static function clean_system( $type = '' ) { global $wpdb; set_as_network_screen(); $return_value = true; switch ( $type ) { case 'revisions': /* * Delete all revisions using WP_Query and wp_delete_post_revision / $revisions_query = new WP_Query( array( 'post_type' => 'revision', 'post_status' => 'inherit', 'posts_per_page' => -1, 'fields' => 'ids', ) ); if ( $revisions_query->have_posts() ) { foreach ( $revisions_query->posts as $post_id ) { $post_id = intval( $post_id ); if ( 0 !== $post_id ) { wp_delete_post_revision( $post_id ); } } } wp_reset_postdata(); // Clear cache after cleaning wp_cache_delete( 'breeze_clean_count_revisions', 'breeze_database' ); break; case 'drafted': /* * Delete all draft entries using WP_Query and wp_delete_post / $drafts_query = new WP_Query( array( 'post_status' => 'auto-draft', 'posts_per_page' => -1, 'fields' => 'ids', ) ); if ( $drafts_query->have_posts() ) { foreach ( $drafts_query->posts as $post_id ) { $post_id = intval( $post_id ); if ( 0 !== $post_id ) { wp_delete_post( $post_id, true ); } } } wp_reset_postdata(); wp_cache_delete( 'breeze_clean_count_drafted', 'breeze_database' ); break; case 'trash': /* * Delete all trashed posts/pages using WP_Query and wp_delete_post / $trash_query = new WP_Query( array( 'post_status' => 'trash', 'posts_per_page' => -1, 'fields' => 'ids', ) ); if ( $trash_query->have_posts() ) { foreach ( $trash_query->posts as $post_id ) { $post_id = intval( $post_id ); if ( 0 !== $post_id ) { wp_delete_post( $post_id, true ); } } } wp_reset_postdata(); wp_cache_delete( 'breeze_clean_count_trash', 'breeze_database' ); break; case 'comments_trash': /* * Delete all trashed comments using get_comments and wp_delete_comment / $comments_trashed = get_comments( array( 'status' => array( 'trash', 'post-trashed' ), 'fields' => 'ids', ) ); if ( ! empty( $comments_trashed ) ) { foreach ( $comments_trashed as $comment_id ) { $comment_id = intval( $comment_id ); if ( 0 !== $comment_id ) { wp_delete_comment( $comment_id, true ); } } } wp_cache_delete( 'breeze_clean_count_comments_trash', 'breeze_database' ); break; case 'comments_spam': /* * Delete all spam comments using get_comments and wp_delete_comment / $comments_spam = get_comments( array( 'status' => 'spam', 'fields' => 'ids', ) ); if ( ! empty( $comments_spam ) ) { foreach ( $comments_spam as $comment_id ) { $comment_id = intval( $comment_id ); if ( 0 !== $comment_id ) { wp_delete_comment( $comment_id, true ); } } } wp_cache_delete( 'breeze_clean_count_comments_spam', 'breeze_database' ); break; case 'trackbacks': /* * Delete all Track-back and Ping-back comments using get_comments / $comments_trackback = get_comments( array( 'type' => array( 'trackback', 'pingback' ), 'fields' => 'ids', ) ); if ( ! empty( $comments_trackback ) ) { foreach ( $comments_trackback as $comment_id ) { $comment_id = intval( $comment_id ); if ( 0 !== $comment_id ) { wp_delete_comment( $comment_id, true ); } } } wp_cache_delete( 'breeze_clean_count_trackbacks', 'breeze_database' ); break; case 'transient': /* * Delete all Transients. / //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $all_transients = $wpdb->get_col( / translators: comment type, comment type / $wpdb->prepare( "SELECT option_name FROM $wpdb->options WHERE option_name LIKE %s OR option_name LIKE %s", $wpdb->esc_like( '_transient_' ) . '%', $wpdb->esc_like( '_site_transient_' ) . '%' ) ); if ( ! empty( $all_transients ) ) { foreach ( $all_transients as $transient ) { if ( strpos( $transient, '_site_transient_' ) !== false ) { $transient_name = str_replace( '_site_transient_', '', $transient ); $is_deleted = delete_site_transient( $transient_name ); } else { $transient_name = str_replace( '_transient_', '', $transient ); $is_deleted = delete_transient( $transient_name ); } } //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $data_sql = $wpdb->query( $wpdb->prepare( "DELETE FROM `$wpdb->options` WHERE `option_name` LIKE %s OR `option_name` LIKE %s", $wpdb->esc_like( '_transient_' ) . '%', $wpdb->esc_like( '_site_transient_' ) . '%' ) ); } wp_cache_delete( 'breeze_clean_count_transient', 'breeze_database' ); break; case 'orphan_post_meta': //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $the_query = $wpdb->get_results( "SELECT post_id, meta_key FROM $wpdb->postmeta WHERE post_id NOT IN (SELECT ID FROM $wpdb->posts)" ); if ( $the_query ) { foreach ( $the_query as $orphan_data ) { $post_id = (int) $orphan_data->post_id; // if $post_id is equal to zero then the entry was bugged/bad code, we delete the entry only if ( 0 === $post_id ) { // Direct query required for orphan meta cleanup - no WP equivalent exists. // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->postmeta WHERE post_id = %d AND meta_key = %s", $post_id, $orphan_data->meta_key ) ); } else { // If post ID exists, we can use WordPress function to delete the meta. delete_post_meta( $post_id, $orphan_data->meta_key ); } } } wp_cache_delete( 'breeze_clean_count_orphan_post_meta', 'breeze_database' ); break; case 'oembed_cache': //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $the_query = $wpdb->get_results( $wpdb->prepare( "SELECT post_id, meta_key FROM $wpdb->postmeta WHERE meta_key LIKE(%s)", '%_oembed_%' ) ); if ( $the_query ) { foreach ( $the_query as $post_meta_data ) { $post_id = (int) $post_meta_data->post_id; // if $post_id is equal to zero then the entry was bugged/bad code, we delete the entry only. // Entries with zero value as $post_id are basically orphaned entries by default. if ( 0 === $post_id ) { // Direct query required for oembed cache cleanup - no WP equivalent exists. // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->postmeta WHERE post_id = %d AND meta_key = %s", $post_id, $post_meta_data->meta_key ) ); } else { // If $post_id ID exists, we can use WordPress function to delete the meta. delete_post_meta( $post_id, $post_meta_data->meta_key ); } } } wp_cache_delete( 'breeze_clean_count_oembed_cache', 'breeze_database' ); break; case 'duplicated_post_meta': //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $the_query = $wpdb->get_results( $wpdb->prepare( "SELECT GROUP_CONCAT(meta_id ORDER BY meta_id DESC) AS meta_ids, post_id, COUNT() AS count FROM $wpdb->postmeta GROUP BY post_id, meta_key, meta_value HAVING count > %d", 1 ) ); if ( $the_query ) { foreach ( $the_query as $post_meta ) { $post_meta_id_list = array_map( 'absint', explode( ',', $post_meta->meta_ids ) ); // We need to make sure that at least one entry is remaining. array_pop( $post_meta_id_list ); $implode_id_list = implode( ',', $post_meta_id_list ); // Direct query required for duplicate meta cleanup - no WP equivalent exists. // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->postmeta WHERE meta_id IN ({$implode_id_list}) AND post_id = %d", $post_meta->post_id ) // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared ); } } wp_cache_delete( 'breeze_clean_count_duplicated_post_meta', 'breeze_database' ); break; case 'comments_unapproved': /** * Delete unapproved comments using get_comments and wp_delete_comment / $the_query = get_comments( array( 'status' => 'hold', 'fields' => 'ids', ) ); if ( $the_query ) { foreach ( $the_query as $comment_id ) { // it's best to use WP delete function. wp_delete_comment( (int) $comment_id, true ); } } wp_cache_delete( 'breeze_clean_count_comments_unapproved', 'breeze_database' ); break; case 'comments_orphan_meta': //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $the_query = $wpdb->get_results( $wpdb->prepare( "SELECT comment_id, meta_key FROM $wpdb->commentmeta WHERE comment_id NOT IN (SELECT comment_ID FROM $wpdb->comments)", '' ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared if ( $the_query ) { foreach ( $the_query as $orphan_data ) { $comment_id = (int) $orphan_data->comment_id; // if $comment_id is equal to zero then the entry was bugged/bad code, we delete the entry only. if ( 0 === $comment_id ) { // Direct query required for orphan comment meta cleanup - no WP equivalent exists. // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->commentmeta WHERE comment_id = %d AND meta_key = %s", $comment_id, $orphan_data->meta_key ) ); } else { // If $comment_id ID exists, we can use WordPress function to delete the meta. delete_comment_meta( $comment_id, $orphan_data->meta_key ); } } } wp_cache_delete( 'breeze_clean_count_comments_orphan_meta', 'breeze_database' ); break; case 'comments_duplicate_meta': //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $the_query = $wpdb->get_results( $wpdb->prepare( "SELECT GROUP_CONCAT(meta_id ORDER BY meta_id DESC) AS comment_ids, comment_id, COUNT() AS count FROM $wpdb->commentmeta GROUP BY comment_id, meta_key, meta_value HAVING count > %d", 1 ) ); if ( $the_query ) { foreach ( $the_query as $comment_meta ) { $comment_meta_id_list = array_map( 'absint', explode( ',', $comment_meta->comment_ids ) ); // We need to make sure that at least one entry is remaining. array_pop( $comment_meta_id_list ); if ( ! empty( $comment_meta_id_list ) ) { $placeholders = implode( ',', array_fill( 0, count( $comment_meta_id_list ), '%d' ) ); // Direct query required for duplicate comment meta cleanup - no WP equivalent exists. // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->commentmeta WHERE meta_id IN ($placeholders) AND comment_id = %d", // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared array_merge( $comment_meta_id_list, array( $comment_meta->comment_id ) ) ) ); } } } wp_cache_delete( 'breeze_clean_count_comments_duplicate_meta', 'breeze_database' ); break; case 'expired_transients': // get current PHP time, offset by a minute to avoid clashes with other tasks //$threshold = current_time( 'timestamp' ) - MINUTE_IN_SECONDS; // phpcs:ignore $threshold = time() - MINUTE_IN_SECONDS; // phpcs:ignore // Delete expired transients, using the paired timeout record to find them /** * Function was added in WP 4.9.0 / if ( function_exists( 'delete_expired_transients' ) ) { delete_expired_transients( true ); } //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $select_expired = $wpdb->get_results( $wpdb->prepare( " SELECT option_name FROM $wpdb->options WHERE (option_name LIKE %s OR option_name LIKE %s) AND CAST(option_value AS SIGNED) < %d ", '\_transient\_timeout\_%', '\_site\_transient\_timeout\_%', $threshold ) ); foreach ( $select_expired as $expired_transient ) { $the_timer = $expired_transient->option_name; if ( strpos( $the_timer, '_site_transient_' ) !== false ) { $the_transient = str_replace( '_site_transient_timeout_', '_site_transient_', $the_timer ); } else { $the_transient = str_replace( '_transient_timeout_', '_transient_', $the_timer ); } //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->get_var( $wpdb->prepare( "DELETE FROM $wpdb->options WHERE option_name = %s", $the_transient ) ); //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->get_var( $wpdb->prepare( "DELETE FROM $wpdb->options WHERE option_name = %s", $the_timer ) ); } $is_network = false; if ( isset( $_GET['is-network'] ) ) { $is_network = filter_var( $_GET['is-network'], FILTER_VALIDATE_BOOLEAN ); } if ( isset( $_POST['is-network'] ) ) { $is_network = filter_var( $_POST['is-network'], FILTER_VALIDATE_BOOLEAN ); } if ( is_multisite() && true === $is_network ) { //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $select_expired = $wpdb->get_results( $wpdb->prepare( "SELECT meta_key FROM $wpdb->sitemeta WHERE ( meta_key LIKE %s OR meta_key LIKE %s ) AND UNIX_TIMESTAMP(meta_value) < UNIX_TIMESTAMP(NOW())", '\_transient\_timeout\_%', '\_site\_transient\_timeout\_%' ) ); foreach ( $select_expired as $expired_transient ) { $the_timer = $expired_transient->option_name; if ( strpos( $the_timer, '_site_transient_' ) !== false ) { $the_transient = str_replace( '_site_transient_timeout_', '_site_transient_', $the_timer ); } else { $the_transient = str_replace( '_transient_timeout_', '_transient_', $the_timer ); } $wpdb->prepare( "DELETE FROM $wpdb->sitemeta WHERE meta_key = %s", $the_transient ); $wpdb->prepare( "DELETE FROM $wpdb->sitemeta WHERE meta_key = %s", $the_timer ); } } break; case 'orphan_user_meta': //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $the_query = $wpdb->get_results( "SELECT user_id, meta_key FROM $wpdb->usermeta WHERE user_id NOT IN (SELECT ID FROM $wpdb->users)" ); if ( $the_query ) { foreach ( $the_query as $orphan_data ) { $user_id = (int) $orphan_data->user_id; // if $user_id is equal to zero then the entry was bugged/bad code, we delete the entry only. if ( 0 === $user_id ) { //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->usermeta WHERE user_id = %d AND meta_key = %s", $user_id, $orphan_data->meta_key ) ); } else { // If $user_id ID exists, we can use WordPress function to delete the meta. delete_user_meta( $user_id, $orphan_data->meta_key ); } } } break; case 'duplicated_user_meta': //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $the_query = $wpdb->get_results( $wpdb->prepare( "SELECT GROUP_CONCAT(umeta_id ORDER BY umeta_id DESC) AS user_meta_ids, user_id, COUNT() AS count FROM $wpdb->usermeta GROUP BY user_id, meta_key, meta_value HAVING count > %d", 1 ) ); if ( $the_query ) { foreach ( $the_query as $user_meta ) { $user_meta_id_list = array_map( 'absint', explode( ',', $user_meta->user_meta_ids ) ); // We need to make sure that at least one entry is remaining. array_pop( $user_meta_id_list ); $implode_id_list = implode( ',', $user_meta_id_list ); //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->usermeta WHERE umeta_id IN ({$implode_id_list}) AND user_id = %d", $user_meta->user_id ) // phpcs:ignore ); } } break; case 'orphan_term_meta': //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $the_query = $wpdb->get_results( "SELECT term_id, meta_key FROM $wpdb->termmeta WHERE term_id NOT IN (SELECT term_id FROM $wpdb->terms)" ); if ( $the_query ) { foreach ( $the_query as $orphan_data ) { $term_id = (int) $orphan_data->term_id; // if $term_id is equal to zero then the entry was bugged/bad code, we delete the entry only. if ( 0 === $term_id ) { //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->termmeta WHERE term_id = %d AND meta_key = %s", $term_id, $orphan_data->meta_key ) ); } else { // If $term_id ID exists, we can use WordPress function to delete the meta. delete_term_meta( $term_id, $orphan_data->meta_key ); } } } break; case 'duplicated_term_meta': //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $the_query = $wpdb->get_results( $wpdb->prepare( "SELECT GROUP_CONCAT(meta_id ORDER BY meta_id DESC) AS term_meta_ids, term_id, COUNT() AS count FROM $wpdb->termmeta GROUP BY term_id, meta_key, meta_value HAVING count > %d", 1 ) ); if ( $the_query ) { foreach ( $the_query as $term_meta ) { $term_meta_id_list = array_map( 'absint', explode( ',', $term_meta->term_meta_ids ) ); // We need to make sure that at least one entry is remaining. array_pop( $term_meta_id_list ); $implode_id_list = implode( ',', $term_meta_id_list ); //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->termmeta WHERE meta_id IN ({$implode_id_list}) AND term_id = %d", $term_meta->term_id ) // phpcs:ignore ); } } break; case 'optimize_database': $all_db_tables = array(); $total_of_tables = 0; if ( defined( 'WP_NETWORK_ADMIN' ) \|\| ! is_multisite() ) { // Direct query required for schema inspection - no WP equivalent exists. // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $sql_get = $wpdb->get_results( $wpdb->prepare( 'SELECT `TABLE_NAME` FROM INFORMATION_SCHEMA.TABLES WHERE `TABLE_SCHEMA`=%s AND (`ENGINE`=%s OR `ENGINE`=%s OR `ENGINE`=%s)', DB_NAME, 'InnoDB', 'MyISAM', 'ARCHIVE' ) ); if ( $sql_get ) { foreach ( $sql_get as $db_table ) { $all_db_tables[] = $db_table->TABLE_NAME; } $total_of_tables = count( $all_db_tables ); } } else { $blog_id = (int) $wpdb->blogid; if ( 1 === $blog_id ) { // Direct query required for schema inspection - no WP equivalent exists. // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $sql_get = $wpdb->get_results( $wpdb->prepare( 'SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE `TABLE_SCHEMA`=%s AND (`ENGINE`=%s OR `ENGINE`=%s OR `ENGINE`=%s)', DB_NAME, 'InnoDB', 'MyISAM', 'ARCHIVE' ), OBJECT ); $table_list = ''; if ( $sql_get ) { foreach ( $sql_get as $db_table ) { $table_list .= "{$db_table->TABLE_NAME}\n"; } preg_match_all( '/(wp_[^_\d_].)/i', $table_list, $tables_list ); if ( isset( $tables_list[0] ) && ! empty( $tables_list[0] ) ) { $all_db_tables = $tables_list[0]; } $total_of_tables = count( $all_db_tables ); } } else { // Direct query required for schema inspection - no WP equivalent exists. // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $sql_get = $wpdb->get_results( $wpdb->prepare( 'SELECT `TABLE_NAME` FROM INFORMATION_SCHEMA.TABLES WHERE `TABLE_SCHEMA`=%s AND (`ENGINE`=%s OR `ENGINE`=%s OR `ENGINE`=%s) AND `TABLE_NAME` LIKE %s', DB_NAME, 'InnoDB', 'MyISAM', 'ARCHIVE', $wpdb->prefix . '%' ) ); if ( $sql_get ) { foreach ( $sql_get as $db_table ) { $all_db_tables[] = $db_table->TABLE_NAME; } $total_of_tables = count( $all_db_tables ); } } } if ( ! isset( $_POST['db_count'] ) ) { $db_count = 0; } else { $db_count = absint( $_POST['db_count'] ); } $only_these_tables = array_chunk( $all_db_tables, 50, true ); if ( isset( $only_these_tables[ $db_count ] ) ) { // Sanitize and validate table names by ensuring they exist in the database. $valid_tables = array(); foreach ( $only_these_tables[ $db_count ] as $table ) { // Remove any characters that aren't alphanumeric, underscore, or hyphen. $sanitized = preg_replace( '/[^a-zA-Z0-9_-]/', '', $table ); // Verify table exists in database (additional security check). // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $table_exists = $wpdb->get_var( $wpdb->prepare( 'SELECT COUNT() FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = %s AND TABLE_NAME = %s', DB_NAME, $sanitized ) ); if ( $table_exists ) { // Use esc_sql as an additional layer of protection for identifier. $valid_tables[] = esc_sql( $sanitized ); } } if ( ! empty( $valid_tables ) ) { $tables = implode( ',', $valid_tables ); // Direct query is required for table optimization - no WP equivalent exists. // Table names cannot be parameterized in SQL. // Sanitized via regex, validated against DB schema, and escaped. // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.InterpolatedNotPrepared $wpdb->query( "OPTIMIZE TABLE $tables" ); } } ++$db_count; if ( isset( $only_these_tables[ $db_count ] ) ) { $return_value = array( 'optmize_no' => $db_count, 'db_total' => $total_of_tables, ); } else { $return_value = true; } break; } return $return_value; } /* * Returns the count of each section in the Database tab. * * Changed completely in 2.0.0 * * @param string $type * * @return int * @since 2.0.0 / public static function get_element_to_clean( $type = '' ) { global $wpdb; $return = 0; // Create a cache key based on the type $cache_key = 'breeze_clean_count_' . $type; $cache_group = 'breeze_database'; // Try to get from cache first $cached_value = wp_cache_get( $cache_key, $cache_group ); if ( false !== $cached_value ) { return (int) $cached_value; } switch ( $type ) { case 'revisions': // Use WP_Query instead of direct database query $revisions_query = new WP_Query( array( 'post_type' => 'revision', 'post_status' => 'inherit', 'posts_per_page' => -1, 'fields' => 'ids', 'no_found_rows' => false, ) ); $return = $revisions_query->found_posts; wp_reset_postdata(); break; case 'drafted': // Use WP_Query instead of direct database query $drafts_query = new WP_Query( array( 'post_status' => 'auto-draft', 'posts_per_page' => -1, 'fields' => 'ids', 'no_found_rows' => false, ) ); $return = $drafts_query->found_posts; wp_reset_postdata(); break; case 'trash': // Use WP_Query instead of direct database query $trash_query = new WP_Query( array( 'post_status' => 'trash', 'posts_per_page' => -1, 'fields' => 'ids', 'no_found_rows' => false, ) ); $return = $trash_query->found_posts; wp_reset_postdata(); break; case 'comments_trash': // Use get_comments instead of direct database query $return = get_comments( array( 'status' => array( 'trash', 'post-trashed' ), 'count' => true, ) ); break; case 'comments_spam': // Use get_comments instead of direct database query $return = get_comments( array( 'status' => 'spam', 'count' => true, ) ); break; case 'trackbacks': // Use get_comments instead of direct database query $return = get_comments( array( 'type' => array( 'trackback', 'pingback' ), 'count' => true, ) ); break; case 'transient': // Direct query required to count transients - no WP equivalent exists. // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $return = $wpdb->get_var( / translators: comment type, comment type / $wpdb->prepare( "SELECT COUNT() FROM $wpdb->options WHERE option_name LIKE %s OR option_name LIKE %s", $wpdb->esc_like( '_transient' ) . '%', $wpdb->esc_like( '_site_transient_' ) . '%' ) ); break; // Added after 2.0.7 case 'comments_unapproved': // Use get_comments instead of direct database query $return = get_comments( array( 'status' => 'hold', 'count' => true, ) ); break; case 'comments_orphan_meta': // Check for meta with no existing comment as parent. //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $return = $wpdb->get_var( "SELECT COUNT() FROM $wpdb->commentmeta WHERE comment_id NOT IN (SELECT comment_ID FROM $wpdb->comments)" ); break; case 'comments_duplicate_meta': //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $return = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(meta_id) AS COUNT FROM $wpdb->commentmeta GROUP BY comment_id, meta_key, meta_value HAVING count > %d", 1 ) ); break; case 'orphan_post_meta': //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $return = $wpdb->get_var( "SELECT COUNT() FROM $wpdb->postmeta WHERE post_id NOT IN (SELECT ID FROM $wpdb->posts)" ); break; case 'duplicated_post_meta': //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $query = $wpdb->get_col( $wpdb->prepare( "SELECT COUNT(meta_id) AS COUNT FROM $wpdb->postmeta GROUP BY post_id, meta_key, meta_value HAVING count > %d", 1 ) ); if ( is_array( $query ) ) { $return = array_sum( array_map( 'absint', $query ) ); } else { $return = absint( $query ); } break; case 'oembed_cache': //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $return = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT() FROM $wpdb->postmeta WHERE meta_key LIKE(%s)", '%_oembed_%' ) ); break; case 'expired_transients': // get current PHP time, offset by a minute to avoid clashes with other tasks $threshold = time() - MINUTE_IN_SECONDS; // phpcs:ignore // count transient expiration records, expired //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery $return = $wpdb->get_var( $wpdb->prepare( " SELECT COUNT() FROM $wpdb->options WHERE (option_name LIKE %s OR option_name LIKE %s) AND CAST(option_value AS SIGNED) < %d ", '\_transient\_timeout\_%', '\_site\_transient\_timeout\_%', $threshold ) ); break; case 'orphan_user_meta': //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery $return = $wpdb->get_var( "SELECT COUNT() FROM $wpdb->usermeta WHERE user_id NOT IN (SELECT ID FROM $wpdb->users)" ); break; case 'duplicated_user_meta': //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery $query = $wpdb->get_col( $wpdb->prepare( "SELECT COUNT(umeta_id) AS count FROM $wpdb->usermeta GROUP BY user_id, meta_key, meta_value HAVING count > %d", 1 ) ); if ( is_array( $query ) ) { $return = array_sum( array_map( 'absint', $query ) ); } else { $return = absint( $query ); } break; case 'orphan_term_meta': //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery $return = $wpdb->get_var( "SELECT COUNT() FROM $wpdb->termmeta WHERE term_id NOT IN (SELECT term_id FROM $wpdb->terms)" ); break; case 'duplicated_term_meta': //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery $query = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(meta_id) AS count FROM $wpdb->termmeta GROUP BY term_id, meta_key, meta_value HAVING count > %d", 1 ) ); if ( is_array( $query ) ) { $return = array_sum( array_map( 'absint', $query ) ); } else { $return = absint( $query ); } break; case 'optimize_database': if ( defined( 'WP_NETWORK_ADMIN' ) \|\| ! is_multisite() ) { //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery $return = $wpdb->get_var( $wpdb->prepare( 'SELECT COUNT() FROM INFORMATION_SCHEMA.TABLES WHERE `TABLE_SCHEMA`=%s AND (`ENGINE`=%s OR `ENGINE`=%s OR `ENGINE`=%s)', DB_NAME, 'InnoDB', 'MyISAM', 'ARCHIVE' ) ); } else { $blog_id = (int) $wpdb->blogid; $return = 0; if ( 1 === $blog_id ) { //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery $sql_get = $wpdb->get_results( $wpdb->prepare( 'SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE `TABLE_SCHEMA`=%s AND (`ENGINE`=%s OR `ENGINE`=%s OR `ENGINE`=%s)', DB_NAME, 'InnoDB', 'MyISAM', 'ARCHIVE' ), OBJECT ); $table_list = ''; if ( $sql_get ) { foreach ( $sql_get as $db_table ) { $table_list .= "{$db_table->TABLE_NAME}\n"; } preg_match_all( '/(wp_[^_\d_].)/i', $table_list, $tables_list ); if ( isset( $tables_list[0] ) && ! empty( $tables_list[0] ) ) { $return = count( $tables_list[0] ); } } } else { //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery $return = $wpdb->get_var( $wpdb->prepare( 'SELECT COUNT() FROM INFORMATION_SCHEMA.TABLES WHERE `TABLE_SCHEMA`=%s AND (`ENGINE`=%s OR `ENGINE`=%s OR `ENGINE`=%s) AND `TABLE_NAME` LIKE %s', DB_NAME, 'InnoDB', 'MyISAM', 'ARCHIVE', $wpdb->prefix . '%' ) ); } } #$return = count( $wpdb->get_col( 'SHOW TABLES' ) ); break; } // Cache the result for 5 minutes wp_cache_set( $cache_key, $return, $cache_group, 300 ); return (int) $return; } // Convert string to array protected function string_convert_arr( $input ) { $output = array(); if ( ! empty( $input ) ) { $input = rawurldecode( $input ); $input = trim( $input ); $input = str_replace( ' ', '', $input ); $input = explode( "\n", $input ); foreach ( $input as $k => $v ) { $output[] = trim( $v ); } } return $output; } //ajax clean cache public static function breeze_clean_cache() { // Check whether we're clearing the cache for one subsite on the network. $is_subsite = is_multisite() && ! is_network_admin(); // analysis size cache $cachepath = untrailingslashit( breeze_get_cache_base_path( is_network_admin() ) ); $size_cache = breeze_get_directory_size( $cachepath ); // Analyze minification directory sizes. $files_path = rtrim( WP_CONTENT_DIR, '/' ) . '/cache/breeze-minification'; if ( $is_subsite ) { $blog_id = get_current_blog_id(); $files_path .= DIRECTORY_SEPARATOR . $blog_id; } $size_cache += breeze_get_directory_size( $files_path, array( 'index.html' ) ); $result = self::formatBytes( $size_cache ); //delete minify file Breeze_MinificationCache::clear_minification(); //delete all cache Breeze_PurgeCache::breeze_cache_flush( true, true, true ); return $result; } / Ajax clean cache / public static function breeze_ajax_clean_cache() { breeze_is_restricted_access(); //check security nonce check_ajax_referer( '_breeze_purge_cache', 'security' ); $result = self::breeze_clean_cache(); echo json_encode( $result ); exit; } / * Ajax purge varnish / public static function purge_varnish_action( $breeze_admin ) { breeze_is_restricted_access(); //check security check_ajax_referer( '_breeze_purge_varnish', 'security' ); $res = $breeze_admin->breeze_clear_varnish(); if ( $res ) { $success_message = __( 'Varnish Cache has been purged.', 'breeze' ); wp_send_json_success( $success_message, 200 ); } else { $error_message = __( 'Varnish Cache could not be purged.', 'breeze' ); wp_send_json_error( $error_message, 500 ); } exit; } public static function breeze_ajax_check_cdn_url() { breeze_is_restricted_access(); check_ajax_referer( '_breeze_check_cdn_url', 'security' ); $cdn_url = isset( $_POST['cdn_url'] ) ? trim( $_POST['cdn_url'] ) : ''; $cdn_url = ltrim( $cdn_url, 'https:' ); $cdn_url = 'https:' . $cdn_url; if ( false === filter_var( $cdn_url, FILTER_VALIDATE_URL ) ) { return false; } $breeze_user_agent = 'breeze-cdn-check-help-user'; $ssl_verification = apply_filters( 'breeze_ssl_check_certificate', true ); if ( ! is_bool( $ssl_verification ) ) { $ssl_verification = true; } if ( defined( 'WP_DEBUG' ) && true === WP_DEBUG ) { $ssl_verification = false; } $args = array( 'timeout' => 10, 'redirection' => 3, 'user-agent' => $breeze_user_agent, 'headers' => array( 'Referer' => home_url(), ), 'sslverify' => $ssl_verification, ); $response = wp_remote_get( 'https://sitecheck.sucuri.net/api/v3/?scan=' . $cdn_url, $args ); if ( is_wp_error( $response ) ) { wp_send_json( array( 'success' => true, 'message' => '', ) ); exit; } $http_code = wp_remote_retrieve_response_code( $response ); $the_json = wp_remote_retrieve_body( $response ); $response_data = array(); $is_json = json_decode( $the_json, true ); if ( null === $is_json && json_last_error() !== JSON_ERROR_NONE ) { // incorrect data show error message $is_safe = true; } else { // decoded with success $is_safe = true; if ( isset( $is_json['warnings'], $is_json['warnings']['security'], $is_json['warnings']['security']['malware'] ) ) { $is_safe = false; $response_data['message'] = '<strong>' . __( 'Important: ', 'breeze' ) . '</strong>'; $response_data['message'] .= __( 'The CDN URL you\'ve used is insecure.', 'breeze' ); } } $response_data['success'] = $is_safe; wp_send_json( $response_data ); exit; } /* * Ajax purge Object Cache * * @return void / public static function breeze_ajax_purge_opcache() { breeze_is_restricted_access(); //check security check_ajax_referer( '_breeze_purge_opcache', 'security' ); echo wp_json_encode( array( 'clear' => Breeze_PurgeCache::__flush_object_cache() ) ); exit; } / * Ajax purge database / public static function breeze_ajax_purge_database() { breeze_is_restricted_access(); //check security check_ajax_referer( '_breeze_purge_database', 'security' ); set_as_network_screen(); $items = array( 'post_revisions' => array( 'revisions' ), 'auto_drafts' => array( 'drafted' ), 'trashed_posts' => array( 'trash' ), 'trashed_comments' => array( 'comments_trash' ), 'spam_comments' => array( 'comments_spam' ), 'trackbacks_pingbacks' => array( 'trackbacks' ), 'all_transients' => array( 'transient' ), 'all' => array( 'revisions', 'drafted', 'trash', 'comments_trash', 'comments_spam', 'trackbacks', 'transient', /* * @since 2.0.7 / 'orphan_post_meta', 'oembed_cache', 'duplicated_post_meta', 'comments_unapproved', 'comments_orphan_meta', 'comments_duplicate_meta', 'expired_transients', 'orphan_user_meta', 'duplicated_user_meta', 'orphan_term_meta', 'duplicated_term_meta', 'optimize_database', ), /* * @since 2.0.7 / 'orphan_post_meta' => array( 'orphan_post_meta' ), 'oembed_cache' => array( 'oembed_cache' ), 'duplicated_post_meta' => array( 'duplicated_post_meta' ), 'comments_unapproved' => array( 'comments_unapproved' ), 'comments_orphan_meta' => array( 'comments_orphan_meta' ), 'comments_duplicate_meta' => array( 'comments_duplicate_meta' ), 'expired_transients' => array( 'expired_transients' ), 'orphan_user_meta' => array( 'orphan_user_meta' ), 'duplicated_user_meta' => array( 'duplicated_user_meta' ), 'orphan_term_meta' => array( 'orphan_term_meta' ), 'duplicated_term_meta' => array( 'duplicated_term_meta' ), 'optimize_database' => array( 'optimize_database' ), ); $return_value = true; if ( isset( $_POST['action_type'] ) ) { $type = $_POST['action_type']; if ( 'custom' === $type ) { $services = json_decode( stripslashes( $_POST['services'] ), true ); if ( ! empty( $services ) && is_array( $services ) ) { foreach ( $services as $service ) { if ( isset( $items[ $service ] ) ) { self::optimize_database( $items[ $service ] ); } } } } else { if ( isset( $items[ $type ] ) ) { $return_value = self::optimize_database( $items[ $type ] ); } } } // $type = array( 'revisions', 'drafted', 'trash', 'comments_trash', 'comments_spam', 'trackbacks', 'transient' ); echo json_encode( array( 'clear' => $return_value ) ); exit; } public static function formatBytes( $bytes, $precision = 2 ) { if ( $bytes >= 1073741824 ) { $bytes = number_format( $bytes / 1073741824, 2 ); } elseif ( $bytes >= 1048576 ) { $bytes = number_format( $bytes / 1048576, 2 ); } elseif ( $bytes >= 1024 ) { $bytes = number_format( $bytes / 1024, 2 ); } elseif ( $bytes > 1 ) { $bytes = $bytes; } elseif ( $bytes == 1 ) { $bytes = $bytes; } else { $bytes = '0'; } return $bytes; } /* * Generate a random token * * @param $length * * @return string * @throws Exception / public static function breeze_generate_token( $length = 32 ){ $characters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789'; $token = ''; for ( $i = 0; $i < $length; $i++ ) { $token .= $characters[ random_int( 0, strlen( $characters ) - 1 ) ]; } return $token; } /* * Perform database optimization. * * @param array $items / public static function optimize_database( $items ) { set_as_network_screen(); $to_return = true; if ( 'optimize_database' !== $items[0] && is_multisite() && is_network_admin() ) { $sites = get_sites( array( 'fields' => 'ids', 'number' => 0, ) ); foreach ( $sites as $blog_id ) { switch_to_blog( $blog_id ); foreach ( $items as $item ) { $to_return = self::clean_system( $item ); } restore_current_blog(); } } else { foreach ( $items as $item ) { $action_result = self::clean_system( $item ); if ( ! is_bool( $action_result ) ) { $to_return = $action_result; } } } return $to_return; } /* * Function to reach by ajax to reset all options to default * * @return void / public static function reset_to_default_ajax() { breeze_is_restricted_access(); check_ajax_referer( '_breeze_reset_default', 'security' ); set_as_network_screen(); $is_blog_id = 0; if ( true === filter_var( $_POST['is-network'], FILTER_VALIDATE_BOOLEAN ) ) { $is_blog_id = 'network'; } $response = self::reset_to_default( $is_blog_id, $_POST['is-network'] ); wp_send_json( $response ); } /* * Reset all options to default * * @param $blog_id * @param $is_network * * @return bool */ public static function reset_to_default( $blog_id = null, $is_network = 'false' ) { set_as_network_screen(); // Default basic if ( ! empty( $blog_id ) && is_numeric( $blog_id ) ) { $blog_id = intval( $blog_id ); } $all_user_roles = breeze_all_wp_user_roles(); $active_cache_users = array(); foreach ( $all_user_roles as $usr_role ) { $active_cache_users[ $usr_role ] = 0; } $default_basic = array( 'breeze-active' => '1', 'breeze-cross-origin' => '0', 'breeze-disable-admin' => $active_cache_users, 'breeze-gzip-compression' => '1', 'breeze-desktop-cache' => '1', 'breeze-mobile-cache' => '1', 'breeze-browser-cache' => '1', 'breeze-lazy-load' => '0', 'breeze-lazy-load-native' => '0', 'breeze-lazy-load-iframes' => '0', 'breeze-lazy-load-videos' => '0', 'breeze-display-clean' => '1', ); $basic = $default_basic; // Default File $default_file = array( 'breeze-minify-html' => '0', // -- 'breeze-minify-css' => '0', 'breeze-font-display-swap' => '0', 'breeze-group-css' => '0', 'breeze-exclude-css' => array(), // -- 'breeze-minify-js' => '0', 'breeze-group-js' => '0', 'breeze-include-inline-js' => '0', 'breeze-exclude-js' => array(), 'breeze-move-to-footer-js' => array(), 'breeze-defer-js' => array(), 'breeze-enable-js-delay' => '0', 'no-breeze-no-delay-js' => array(), 'breeze-delay-all-js' => '0', ); $file = $default_file; $token = Breeze_Configuration::breeze_generate_token(); // Default Advanced $default_advanced = array( 'breeze-exclude-urls' => array(), 'cached-query-strings' => array(), 'breeze-wp-emoji' => '0', 'breeze-enable-api' => '0', 'breeze-api-token' => $token, ); $default_heartbeat = array( 'breeze-control-heartbeat' => '0', 'breeze-heartbeat-front' => '', 'breeze-heartbeat-postedit' => '', 'breeze-heartbeat-backend' => '', ); $heartbeat = $default_heartbeat; $breeze_delay_js_scripts = array( 'gtag', 'document.write', 'html5.js', 'show_ads.js', 'google_ad', 'blogcatalog.com/w', 'tweetmeme.com/i', 'mybloglog.com/', 'histats.com/js', 'ads.smowtion.com/ad.js', 'statcounter.com/counter/counter.js', 'widgets.amung.us', 'ws.amazon.com/widgets', 'media.fastclick.net', '/ads/', 'comment-form-quicktags/quicktags.php', 'edToolbar', 'intensedebate.com', 'scripts.chitika.net/', '_gaq.push', 'jotform.com/', 'admin-bar.min.js', 'GoogleAnalyticsObject', 'plupload.full.min.js', 'syntaxhighlighter', 'adsbygoogle', 'gist.github.com', '_stq', 'nonce', 'post_id', 'data-noptimize', 'googletagmanager', ); breeze_update_option( 'advanced_settings_120', 'yes', true ); $advanced = $default_advanced; //CDN default $wp_content = substr( WP_CONTENT_DIR, strlen( ABSPATH ) ); $default_cdn = array( 'cdn-active' => '0', 'cdn-url' => '', 'cdn-content' => array( 'wp-includes', $wp_content ), 'cdn-exclude-content' => array( '.php' ), 'cdn-relative-path' => '1', ); $cdn = $default_cdn; // Preload default $default_preload = array( 'breeze-preload-fonts' => array(), 'breeze-preload-links' => '1', 'breeze-prefetch-urls' => array(), ); $preload = $default_preload; // Varnish default $default_varnish = array( 'auto-purge-varnish' => '1', 'breeze-varnish-server-ip' => '127.0.0.1', 'breeze-ttl' => 1440, ); $varnish = $default_varnish; if ( is_multisite() ) { if ( true === filter_var( $is_network, FILTER_VALIDATE_BOOLEAN ) \|\| 'network' === $blog_id ) { // get file setting $save_advanced = $file; $save_advanced['breeze-delay-js-scripts'] = $breeze_delay_js_scripts; // Update each blog to default $blogs = get_sites( array( 'number' => 0 ) ); foreach ( $blogs as $blog ) { update_blog_option( $blog->blog_id, 'breeze_basic_settings', $basic ); update_blog_option( $blog->blog_id, 'breeze_advanced_settings', $advanced ); update_blog_option( $blog->blog_id, 'breeze_heartbeat_settings', $heartbeat ); update_blog_option( $blog->blog_id, 'breeze_preload_settings', $preload ); update_blog_option( $blog->blog_id, 'breeze_file_settings', $save_advanced ); update_blog_option( $blog->blog_id, 'breeze_cdn_integration', $cdn ); update_blog_option( $blog->blog_id, 'breeze_varnish_cache', $varnish ); } breeze_update_option( 'basic_settings', $basic ); breeze_update_option( 'advanced_settings', $advanced ); breeze_update_option( 'heartbeat_settings', $heartbeat ); breeze_update_option( 'preload_settings', $preload ); breeze_update_option( 'cdn_integration', $cdn ); breeze_update_option( 'varnish_cache', $varnish ); $file_setting = $file; $file_setting['breeze-delay-js-scripts'] = $breeze_delay_js_scripts; breeze_update_option( 'file_settings', $file_setting ); } else { if ( empty( $blog_id ) ) { $blog_id = get_current_blog_id(); } update_blog_option( $blog_id, 'breeze_basic_settings', $basic ); update_blog_option( $blog_id, 'breeze_advanced_settings', $advanced ); update_blog_option( $blog_id, 'breeze_heartbeat_settings', $heartbeat ); update_blog_option( $blog_id, 'breeze_preload_settings', $preload ); update_blog_option( $blog_id, 'breeze_cdn_integration', $cdn ); update_blog_option( $blog_id, 'breeze_varnish_cache', $varnish ); $save_file = $file; $save_file['breeze-delay-js-scripts'] = $breeze_delay_js_scripts; update_blog_option( $blog_id, 'breeze_file_settings', $save_file ); } } else { breeze_update_option( 'basic_settings', $basic ); breeze_update_option( 'advanced_settings', $advanced ); breeze_update_option( 'heartbeat_settings', $heartbeat ); breeze_update_option( 'preload_settings', $preload ); breeze_update_option( 'cdn_integration', $cdn ); breeze_update_option( 'varnish_cache', $varnish ); $save_advanced = $file; $save_advanced['breeze-delay-js-scripts'] = $breeze_delay_js_scripts; breeze_update_option( 'file_settings', $save_advanced, true ); } //add header to htaccess if setting is enabled or by default if first installed Breeze_Configuration::update_htaccess(); if ( ! empty( $blog_id ) && is_numeric( $blog_id ) ) { // Multisite sub-blog switch_to_blog( $blog_id ); //automatic config start cache Breeze_ConfigCache::factory()->write(); Breeze_ConfigCache::factory()->write_config_cache(); //delete cache after settings do_action( 'breeze_clear_all_cache' ); restore_current_blog(); } elseif ( 'network' === $blog_id ) { // Multisite network $blogs = get_sites( array( 'number' => 0 ) ); foreach ( $blogs as $blog ) { switch_to_blog( $blog_id ); //automatic config start cache Breeze_ConfigCache::factory()->write(); Breeze_ConfigCache::factory()->write_config_cache(); //delete cache after settings do_action( 'breeze_clear_all_cache' ); restore_current_blog(); } } elseif ( empty( $blog_id ) ) { // Single site //automatic config start cache Breeze_ConfigCache::factory()->write(); Breeze_ConfigCache::factory()->write_config_cache(); //delete cache after settings do_action( 'breeze_clear_all_cache' ); } if ( ! empty( $basic ) && ! empty( $basic['breeze-active'] ) ) { Breeze_ConfigCache::factory()->toggle_caching( true ); } if ( is_multisite() ) { if ( true === filter_var( $is_network, FILTER_VALIDATE_BOOLEAN ) \|\| 'network' === $blog_id ) { Breeze_ConfigCache::factory()->write_config_cache( true ); } } return true; } } //init configuration object new Breeze_Configuration();

| ver. 1.6 | Github | . | PHP 8.3.30 | Генерация страницы: 0 | proxy | phpinfo | Настройка