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

<?php

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

/**
 * Class WP_Optimization_attachments
 */
class WP_Optimization_attachments extends WP_Optimization {

public $ui_sort_order = 4500;

public $available_for_auto = false;

public $auto_default = false;

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

/**
	 * Do actions after optimize() function.
	 */
	public function after_optimize() {

// translators: %s: number of orphaned attachments
		$message = sprintf(_n('%s orphaned attachment deleted', '%s orphaned attachments 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() {

$sql = "SELECT p.ID FROM `{$this->wpdb->posts}` p LEFT JOIN `{$this->wpdb->posts}` pp ON pp.ID = p.post_parent WHERE p.post_parent > %d AND p.post_type = %s AND pp.ID IS NULL;";
		
		$attachment_ids = $this->wpdb->get_col($this->wpdb->prepare($sql, 0, 'attachment')); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- `$this->wpdb` is `$wpdb`
		$count_ids = count($attachment_ids);

if ($count_ids > 0) {
			foreach ($attachment_ids as $attachment_id) {
				wp_delete_attachment($attachment_id, true);
			}
		}

$this->processed_count += $count_ids;

}

/**
	 * Do actions after get_info() function.
	 */
	public function after_get_info() {

if ($this->found_count) {
			// translators: %s: number of orphaned attachments
			$message = sprintf(_n('%s orphaned attachment found', '%s orphaned attachments found', $this->found_count, 'wp-optimize'), number_format_i18n($this->found_count));
		} else {
			$message = __('No orphaned attachments found', 'wp-optimize');
		}

$this->register_output($message);

}
	/**
	 * Estimate count of unoptimized items.
	 */
	public function get_info() {

$sql = "SELECT COUNT(*) FROM `{$this->wpdb->posts}` p LEFT JOIN `{$this->wpdb->posts}` pp ON pp.ID = p.post_parent WHERE p.post_parent > %d AND p.post_type = %s AND pp.ID IS NULL;";
		$postmeta = $this->wpdb->get_var($this->wpdb->prepare($sql, 0, 'attachment')); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- `$this->wpdb` is `$wpdb`

$this->found_count += $postmeta;

}

/**
	 * Returns settings label
	 *
	 * @return string|void
	 */
	public function settings_label() {
		return __('Remove orphaned attachments', 'wp-optimize');
	}
	
	/**
	 * Return description
	 * N.B. This is not currently used; it was commented out in 1.9.1
	 *
	 * @return string|void
	 */
	public function get_auto_option_description() {
		return __('Remove orphaned attachments', 'wp-optimize');
	}
}

X7ROOT File Manager

Editing: attachments.php

Upload File

Create Folder