File Manager

X7ROOT File Manager

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

home / okeydcqc / brownbrommel.com / wp-content / plugins / 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: postmeta.php

<?php

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

class WP_Optimization_postmeta extends WP_Optimization {

public $ui_sort_order = 8000;

public $available_for_auto = false;

public $available_for_saving = true;

public $auto_default = false;

/**
	 * Prepare data for preview widget.
	 *
	 * @param array $params
	 *
	 * @return array
	 */
	public function preview($params) {
		// get data requested for preview.
		// `$this->wpdb->prepare` is `$wpdb->prepare` from global variable.
		// phpcs:disable
		$sql = $this->wpdb->prepare(
			"SELECT pm.* FROM `" . $this->wpdb->postmeta . "` pm".
			" LEFT JOIN `" . $this->wpdb->posts . "` wp ON wp.ID = pm.post_id".
			" WHERE wp.ID IS NULL".
			" ORDER BY pm.meta_id LIMIT %d, %d;",
			array(
				$params['offset'],
				$params['limit'],
			)
		);

$posts = $this->wpdb->get_results($sql, ARRAY_A);
		// phpcs:enable

// get total count post meta for optimization.
		$sql = "SELECT COUNT(*) FROM `" . $this->wpdb->postmeta . "` pm LEFT JOIN `" . $this->wpdb->posts . "` wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;";

$total = $this->wpdb->get_var($sql); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- Statement is safe, no user input used

return array(
			'id_key' => 'meta_id',
			'columns' => array(
				'meta_id' => __('ID', 'wp-optimize'),
				'post_id' => __('Post ID', 'wp-optimize'),
				'meta_key' => __('Meta Key', 'wp-optimize'), // phpcs:ignore WordPress.DB.SlowDBQuery.slow_db_query_meta_key -- This is not a query
				'meta_value' => __('Meta Value', 'wp-optimize'), // phpcs:ignore WordPress.DB.SlowDBQuery.slow_db_query_meta_value -- This is not a query
			),
			'offset' => $params['offset'],
			'limit' => $params['limit'],
			'total' => $total,
			'data' => $this->htmlentities_array($posts, array('ID')),
			'message' => $total > 0 ? '' : __('No orphaned post metadata in your database', 'wp-optimize'),
		);
	}

/**
	 * Do actions after optimize() function.
	 */
	public function after_optimize() {
		// translators: %s: number of orphaned post metadata records
		$message = sprintf(_n('%s orphaned post metadata deleted', '%s orphaned post metadata deleted', $this->processed_count, 'wp-optimize'), number_format_i18n($this->processed_count));

if ($this->is_multisite_mode()) {
			// translators: %s: number of sites
			$message .= ' ' . sprintf(_n('across %s site', 'across %s sites', count($this->blogs_ids), 'wp-optimize'), count($this->blogs_ids));
		}

$this->logger->info($message);
		$this->register_output($message);
	}

/**
	 * Do optimization.
	 */
	public function optimize() {
		$clean = "DELETE pm FROM `" . $this->wpdb->postmeta . "` pm LEFT JOIN `" . $this->wpdb->posts . "` wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL";

// if posted ids in params, then remove only selected items. used by preview widget.
		if (isset($this->data['ids'])) {
			$clean .= ' AND pm.meta_id in ('.join(',', $this->data['ids']).')';
		}

$clean .= ";";

$postmeta = $this->query($clean);
		$this->processed_count += $postmeta;
	}

/**
	 * Do actions after get_info() function.
	 */
	public function after_get_info() {
		if ($this->found_count) {
			// translators: %s: number of orphaned post metadata records
			$message = sprintf(_n('%s orphaned post metadata in your database', '%s orphaned post metadata in your database', $this->found_count, 'wp-optimize'), number_format_i18n($this->found_count));
		} else {
			$message = __('No orphaned post metadata in your database', 'wp-optimize');
		}

// add preview link to message.
		if ($this->found_count > 0) {
			$message = $this->get_preview_link($message);
		}

$this->register_output($message);
	}

/**
	 * Get count of unoptimized items.
	 */
	public function get_info() {
		$sql = "SELECT COUNT(*) FROM `" . $this->wpdb->postmeta . "` pm LEFT JOIN `" . $this->wpdb->posts . "` wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;";
		$postmeta = $this->wpdb->get_var($sql); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- Statement is safe, no user input used

$this->found_count += $postmeta;
	}

public function settings_label() {
		return __('Clean post metadata', 'wp-optimize');
	}

/**
	 * N.B. This is not currently used; it was commented out in 1.9.1
	 *
	 * @return string Returns the description once auto remove option has ran
	 */
	public function get_auto_option_description() {
		return __('Remove orphaned post meta', 'wp-optimize');
	}
}

X7ROOT File Manager

Editing: postmeta.php

Upload File

Create Folder