File Manager

X7ROOT File Manager

Current Path: /home/okeydcqc/okeyanueyiagu.com/wp-content/plugins-off/wp-optimize/optimizations

home / okeydcqc / okeyanueyiagu.com / wp-content / plugins-off / wp-optimize / optimizations /

ðŸ“ ..
ðŸ“„ attachments.php(3.15 KB)
ðŸ“„ autodraft.php(5.33 KB)
ðŸ“„ commentmeta.php(7.53 KB)
ðŸ“„ inactive-tags.php(569 B)
ðŸ“„ optimizetables.php(6.7 KB)
ðŸ“„ orphandata.php(2.39 KB)
ðŸ“„ orphanedtables.php(5.42 KB)
ðŸ“„ pingbacks.php(4.51 KB)
ðŸ“„ postmeta.php(4.55 KB)
ðŸ“„ repairtables.php(4.38 KB)
ðŸ“„ revisions.php(8.07 KB)
ðŸ“„ spam.php(8.17 KB)
ðŸ“„ trackbacks.php(4.41 KB)
ðŸ“„ transient.php(14.3 KB)
ðŸ“„ trash.php(6.78 KB)
ðŸ“„ unapproved.php(5.94 KB)
ðŸ“„ usermeta.php(4.45 KB)

Editing: orphanedtables.php

<?php

if (!defined('WPO_VERSION')) die('No direct access allowed');

class WP_Optimization_orphanedtables extends WP_Optimization {

public $available_for_auto = false;

public $setting_default = true;

public $changes_table_data = true;

public $run_multisite = false;

private $last_message;

/**
	 * Display or hide optimization in optimizations list.
	 *
	 * @return bool
	 */
	public function display_in_optimizations_list() {
		return false;
	}

/**
	 * Run optimization.
	 */
	public function optimize() {
		// check if the data contain action attribute then lead to innoDb conversion.
		if (isset($this->data['optimization_action']) && 'toinnodb' == $this->data['optimization_action']) {
			$table = $this->optimizer->get_table($this->data['optimization_table']);
			if (false === $table) {
				$this->register_meta('error', 1);
				// translators: %s is the table name
				$this->register_meta('message', sprintf(__('The table "%s" does not exist.', 'wp-optimize'), $this->data['optimization_table']));
				return false;
			}
			$result = $this->convert_table($table);

if (false === $result) {
				$this->register_meta('message', $this->last_message);
				return false;
			}
			$this->register_meta('success', 1);
			return true;
		}
		
		// 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']);

if (false === $table) {
				$this->register_meta('error', 1);
				// translators: %s is the table name
				$this->register_meta('message', sprintf(__('The table "%s" does not exist.', 'wp-optimize'), $this->data['optimization_table']));
				return false;
			}

$result = $this->delete_table($table);
		
			if (false === $result) {
				$this->register_meta('message', $this->last_message);
				return false;
			}
			$this->register_meta('success', 1);
		} else {
			// delete all orphaned tables if table name was not selected.
			$tables = $this->optimizer->get_tables();
			$deleted = 0;

foreach ($tables as $table) {
				if ($table->is_using) continue;

if ($this->delete_table($table)) {
					$deleted++;
				}
			}

// translators: %s is the number of deleted orphaned tables
			$this->register_output(sprintf(_n('%s orphaned table deleted', '%s orphaned tables deleted', $deleted, 'wp-optimize'), $deleted));

if ($deleted > 0) {
				// translators: %s is the number of tables
				$this->register_output(sprintf(_n('Deleting %s orphaned table was unsuccessful', 'Repairing %s orphaned tables were unsuccessful', $deleted, 'wp-optimize'), $deleted));
			}
		}
	}
			
			
	/**
	 * Alter table engine to InnoDB.
	 *
	 * @param object $table_obj object contains information about database table.
	 *
	 * @return bool
	 */
	private function convert_table($table_obj) {
		global $wpdb;
		$inno_db = 0;
		
		// check InnoDB is Active
		$mysql_engine = $wpdb->get_results('SHOW ENGINES');
		foreach ($mysql_engine as $check) {
			if ('InnoDB' == $check->Engine && ('DEFAULT' == $check->Support || 'YES' == $check->Support)) {
				$inno_db=1;
			}
		}

if (0 == $inno_db) return false;
		// If InnoDB is active then convert MyISAM to InnoDB.
		else {
			$table_name = esc_sql($table_obj->Name);
			$sql_query = "ALTER TABLE `{$table_name}`  ENGINE=InnoDB";
			$this->logger->info($sql_query);
			$result = $wpdb->query($sql_query); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- Statement is safe, not using user input
		}
		// check if alter query finished successfully.
		if ('' != $wpdb->last_error) {
			$this->last_message = $wpdb->last_error;
			$this->logger->info($wpdb->last_error);
		}
		
		return $result;
	}

/**
	 * Drop table from database.
	 *
	 * @param object $table_obj object contains information about database table.
	 *
	 * @return bool
	 */
	private function delete_table($table_obj) {
		global $wpdb;

// don't delete table if it in use and plugin active.
		if (!$table_obj->can_be_removed) return true;

$table_name = esc_sql($table_obj->Name);
		$sql_query = "DROP TABLE `{$table_name}`";

$this->logger->info($sql_query);

$result = $wpdb->query($sql_query); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- Statement is safe, not using user input

// check if drop query finished successfully.
		if ('' != $wpdb->last_error) {
			$this->last_message = $wpdb->last_error;
			$this->logger->info($wpdb->last_error);
		}

return $result;
	}

/**
	 * Get count of unused database tables, i.e. not using by any of installed plugin.
	 *
	 * @return int
	 */
	public function get_unused_tables_count() {
		$tablesinfo = $this->optimizer->get_tables();

$unused_tables = 0;

if (!empty($tablesinfo)) {
			foreach ($tablesinfo as $tableinfo) {
				if (false == $tableinfo->is_using) {
					$unused_tables++;
				}
			}
		}

return $unused_tables;
	}

/**
	 * Register info about optimization.
	 */
	public function get_info() {

$corrupted_tables = $this->get_unused_tables_count();

if (0 == $corrupted_tables) {
			$this->register_output(__('No corrupted tables found', 'wp-optimize'));
		} else {
			// translators: %s is the number of corrupted tables
			$this->register_output(sprintf(_n('%s corrupted table found', '%s corrupted tables found', $corrupted_tables, 'wp-optimize'), $corrupted_tables));
		}
	}

/**
	 * Returns settings label.
	 *
	 * @return string
	 */
	public function settings_label() {
		return __('Delete orphaned database tables', 'wp-optimize');
	}
}

X7ROOT File Manager

Editing: orphanedtables.php

Upload File

Create Folder