if (!defined('WPO_VERSION')) die('No direct access allowed'); class WP_Optimization_repairtables extends WP_Optimization { public $available_for_auto = false; public $setting_default = true; public $changes_table_data = true; public $run_multisite = false; /** * Display or hide optimization in optimizations list. * * @return bool */ public function display_in_optimizations_list() { return false; } /** * Run optimization. */ public function optimize() { // check if single table name posted or optimize all tables. if (isset($this->data['optimization_table']) && '' != $this->data['optimization_table']) { $table = $this->optimizer->get_table($this->data['optimization_table']); $result = $this->repair_table($table); if ($result) { $wp_optimize = WP_Optimize(); $tablestatus = $wp_optimize->get_db_info()->get_table_status($table->Name, true); $is_optimizable = $wp_optimize->get_db_info()->is_table_optimizable($table->Name); $tableinfo = array( 'rows' => number_format_i18n($tablestatus->Rows), 'data_size' => $wp_optimize->format_size($tablestatus->Data_length), 'index_size' => $wp_optimize->format_size($tablestatus->Index_length), 'overhead' => $is_optimizable ? $wp_optimize->format_size($tablestatus->Data_free) : '-', 'type' => $table->Engine, 'is_optimizable' => $is_optimizable, ); $this->register_meta('tableinfo', $tableinfo); } $this->register_meta('success', $result); } else { $tables = $this->optimizer->get_tables(); $repaired = $corrupted = 0; foreach ($tables as $table) { if (false == $table->is_needing_repair) continue; if ($this->repair_table($table)) { $repaired++; } else { $corrupted++; } } $this->register_output(sprintf(_n('%s table repaired', '%s tables repaired', $repaired), $repaired)); if ($corrupted > 0) { $this->register_output(sprintf(_n('Repairing %s table was unsuccessful', 'Repairing %s tables were unsuccessful', $corrupted), $corrupted)); } } } /** * Repair table. * * @param object $table_obj object contains information about database table. * * @return bool */ private function repair_table($table_obj) { global $wpdb; $success = false; if (false == $table_obj->is_needing_repair) return true; $this->logger->info('REPAIR TABLE '.$table_obj->Name); $results = $wpdb->get_results('REPAIR TABLE '.$table_obj->Name); if (!empty($results)) { foreach ($results as $row) { if ('status' == strtolower($row->Msg_type) && 'ok' == strtolower($row->Msg_text)) { $success = true; } $this->logger->info($row->Msg_text); } } return $success; } /** * Register info about optimization. */ public function get_info() { $tablesinfo = $this->optimizer->get_tables(); $corrupted_tables = 0; if (!empty($tablesinfo)) { foreach ($tablesinfo as $tableinfo) { if ($tableinfo->is_needing_repair) { $corrupted_tables++; } } } if (0 == $corrupted_tables) { $this->register_output(__('No corrupted tables found', 'wp-optimize')); } else { $this->register_output(sprintf(_n('%s corrupted table found', '%s corrupted tables found', $corrupted_tables), $corrupted_tables)); } } /** * Returns settings label. * * @return string */ public function settings_label() { return __('Repair database tables', 'wp-optimize'); } } Residential - Pest Control Specialist Malaysia
Residential - Pest Control Specialist Malaysia
999
page-template-default,page,page-id-999,woocommerce-no-js,ajax_fade,page_not_loaded,,qode-title-hidden,qode_grid_1300,hide_top_bar_on_mobile_header,qode-content-sidebar-responsive,columns-4,qode-theme-ver-13.2,qode-theme-bridge,wpb-js-composer js-comp-ver-5.4.5,vc_responsive

Residential Pest Solutions

Your Comfort Is Our Priority

At SamPest Pest Solutions, we understand that the safety and comfort of your home is your top priority. That’s why we offer comprehensive residential pest solutions that cater to all your pest control and prevention needs. Because we understand that each pest problem is unique, our technicians are trained with the highest of standards.

Residential Pest Control Since 2008

Our customer service representatives and service technicians are ready to help. Our family truly cares about protecting your property and your family, that’s why we have high hiring standards for our employees.

Residents of West Malaysia have trusted us since 2008.  We know we’re the right choice for your family.  Whether its Termite attacking your door frame, cockroaches in your washroom, or suspected bed bugs…no matter what type of pest problem you have, SamPest Pest Control is here to help.

One-Time Pest Control Services

SamPest offers one time services to target a single pest. While prevention is recommended and our service packages provide great protection, we understand that sometimes you have a problem can can be solved with one visit. Our technicians will work with you to decide if your pest problems can be solved on an as-needed basis or if there is a bigger issue at hand.

Residential Service Packages

Prevention is always better than procrastination. Annual service packages from SamPest ensure your family and home are safe and pest free. We offer a variety of programs to best fit your homes’ unique needs. Learn more about our Packages.

Having trouble with Pests?

Give us a call:

Or schedule a call with Sam Pest today:




Testimonials

Facebook
Watch Youtube
E-Store
WhatsApp chat