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: usermeta.php

<?php

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

class WP_Optimization_usermeta extends WP_Optimization {

public $ui_sort_order = 8001;

public $available_for_auto = true;

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 global `$wpdb->prepare`
		// phpcs:disable
		$sql = $this->wpdb->prepare(
			"SELECT um.* FROM `" . $this->wpdb->usermeta . "` um".
			" LEFT JOIN `" . $this->wpdb->users . "` wu ON wu.ID = um.user_id".
			" WHERE wu.ID IS NULL".
			" ORDER BY um.umeta_id LIMIT %d, %d;",
			array(
				$params['offset'],
				$params['limit'],
			)
		);

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

// get total count user meta for optimization.
		$sql = "SELECT COUNT(*) FROM `" . $this->wpdb->usermeta . "` um LEFT JOIN `" . $this->wpdb->users . "` wu ON wu.ID = um.user_id WHERE wu.ID IS NULL;";

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

return array(
			'id_key' => 'umeta_id',
			'columns' => array(
				'umeta_id' => __('ID', 'wp-optimize'),
				'user_id' => __('User 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($users, array('ID')),
			'message' => $total > 0 ? '' : __('No orphaned user metadata in your database', 'wp-optimize'),
		);
	}

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

if ($this->is_multisite_mode()) {
			// translators: %s is the number 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 um FROM `" . $this->wpdb->usermeta . "` um LEFT JOIN `" . $this->wpdb->users . "` wu ON wu.ID = um.user_id WHERE wu.ID IS NULL";

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

$clean .= ";";

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

/**
	 * Do actions after get_info() function.
	 */
	public function after_get_info() {
		if ($this->found_count) {
			// translators: %s is the number of orphaned user metadata
			$message = sprintf(_n('%s orphaned user metadata in your database', '%s orphaned user metadata in your database', $this->found_count, 'wp-optimize'), number_format_i18n($this->found_count));
		} else {
			$message = __('No orphaned user 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->usermeta . "` um LEFT JOIN `" . $this->wpdb->users . "` wu ON wu.ID = um.user_id WHERE wu.ID IS NULL;";
		$usermeta = $this->wpdb->get_var($sql); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- safe, no user input used

$this->found_count += $usermeta;
	}

/**
	 * Get settings label.
	 */
	public function settings_label() {
		return __('Clean user metadata', 'wp-optimize');
	}

/**
	 * Get auto option description.
	 */
	public function get_auto_option_description() {
		return __('Remove orphaned user meta', 'wp-optimize');
	}
}

X7ROOT File Manager

Editing: usermeta.php

Upload File

Create Folder