get_row( $wpdb->prepare( "SELECT count(*) AS count, SUM( LENGTH( option_value ) ) as autoload_size FROM {$wpdb->options} WHERE autoload IN ( $placeholders )", $autoload_values ) ); // phpcs:enable WordPress.DB update_option( 'option_optimizer', [ 'starting_point_kb' => ( $result->autoload_size / 1024 ), 'starting_point_num' => $result->count, 'starting_point_date' => current_time( 'mysql' ), 'used_options' => [], ], true ); } /** * Deactivation hooked function to remove autoload from the plugin option. * * @return void */ function aaa_option_optimizer_deactivation() { $aaa_option_value = get_option( 'option_optimizer' ); update_option( 'option_optimizer', $aaa_option_value, false ); } /** * Initializes the plugin. * * @return void */ function aaa_option_optimizer_init() { $optimizer = new Emilia\OptionOptimizer\Plugin(); $optimizer->register_hooks(); } aaa_option_optimizer_init();