processed_count, 'wp-optimize'), number_format_i18n($this->processed_count)); if ($this->is_multisite_mode()) { $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;"; $postmeta = $this->query($clean); $this->processed_count += $postmeta; } /** * Do actions after get_info() function. */ public function after_get_info() { if ($this->found_count) { $message = sprintf(_n('%s orphaned post meta data in your database', '%s orphaned post meta data in your database', $this->found_count, 'wp-optimize'), number_format_i18n($this->found_count)); } else { $message = __('No orphaned post meta data in your database', 'wp-optimize'); } if ($this->is_multisite_mode()) { $message .= ' ' . sprintf(_n('across %s site', 'across %s sites', count($this->blogs_ids), 'wp-optimize'), count($this->blogs_ids)); } $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); $this->found_count += $postmeta; } public function settings_label() { return __('Clean post meta data', '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'); } }