<h2>File Contents: /home/planet5/www/wp-content/plugins/wp-rocket/inc/classes/admin/Database/class-optimization.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/www/wp-content/plugins/wp-rocket/inc/classes/admin/Database/class-optimization.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php
namespace WP_Rocket\Admin\Database;

defined( &#039;ABSPATH&#039; ) || die( &#039;Cheatin&amp;#8217; uh?&#039; );

/**
 * Handles the database optimization process.
 *
 * @since 2.11
 * @author Remy Perona
 */
class Optimization {
	/**
	 * Background process instance
	 *
	 * @since 2.11
	 * @var Optimization_Process $process Background Process instance.
	 * @access protected
	 */
	protected $process;

	/**
	 * Array of option name/label pairs.
	 *
	 * @var array
	 * @access private
	 */
	private $options;

	/**
	 * Class constructor.
	 *
	 * @since 2.11
	 * @author Remy Perona
	 *
	 * @param Optimization_Process $process Background process instance.
	 */
	public function __construct( Optimization_Process $process ) {
		$this-&gt;process = $process;
		$this-&gt;options = [
			&#039;database_revisions&#039;          =&gt; __( &#039;Revisions&#039;, &#039;rocket&#039; ),
			&#039;database_auto_drafts&#039;        =&gt; __( &#039;Auto Drafts&#039;, &#039;rocket&#039; ),
			&#039;database_trashed_posts&#039;      =&gt; __( &#039;Trashed Posts&#039;, &#039;rocket&#039; ),
			&#039;database_spam_comments&#039;      =&gt; __( &#039;Spam Comments&#039;, &#039;rocket&#039; ),
			&#039;database_trashed_comments&#039;   =&gt; __( &#039;Trashed Comments&#039;, &#039;rocket&#039; ),
			&#039;database_expired_transients&#039; =&gt; __( &#039;Expired transients&#039;, &#039;rocket&#039; ),
			&#039;database_all_transients&#039;     =&gt; __( &#039;Transients&#039;, &#039;rocket&#039; ),
			&#039;database_optimize_tables&#039;    =&gt; __( &#039;Tables&#039;, &#039;rocket&#039; ),
		];
	}

	/**
	 * Get Database options
	 *
	 * @since 3.0.4
	 * @author Remy Perona
	 *
	 * @return array
	 */
	public function get_options() {
		return $this-&gt;options;
	}

	/**
	 * Performs the database optimization
	 *
	 * @since 2.11
	 * @author Remy Perona
	 *
	 * @param array $options WP Rocket Database options.
	 */
	public function process_handler( $options ) {
		if ( method_exists( $this-&gt;process, &#039;cancel_process&#039; ) ) {
			$this-&gt;process-&gt;cancel_process();
		}

		array_map( array( $this-&gt;process, &#039;push_to_queue&#039; ), $options );

		$this-&gt;process-&gt;save()-&gt;dispatch();
	}

	/**
	 * Count the number of items concerned by the database cleanup
	 *
	 * @since 2.8
	 * @author Remy Perona
	 *
	 * @param string $type Item type to count.
	 * @return int Number of items for this type
	 */
	public function count_cleanup_items( $type ) {
		global $wpdb;

		$count = 0;

		switch ( $type ) {
			case &#039;database_revisions&#039;:
				$count = $wpdb-&gt;get_var( &quot;SELECT COUNT(ID) FROM $wpdb-&gt;posts WHERE post_type = &#039;revision&#039;&quot; );
				break;
			case &#039;database_auto_drafts&#039;:
				$count = $wpdb-&gt;get_var( &quot;SELECT COUNT(ID) FROM $wpdb-&gt;posts WHERE post_status = &#039;auto-draft&#039;&quot; );
				break;
			case &#039;database_trashed_posts&#039;:
				$count = $wpdb-&gt;get_var( &quot;SELECT COUNT(ID) FROM $wpdb-&gt;posts WHERE post_status = &#039;trash&#039;&quot; );
				break;
			case &#039;database_spam_comments&#039;:
				$count = $wpdb-&gt;get_var( &quot;SELECT COUNT(comment_ID) FROM $wpdb-&gt;comments WHERE comment_approved = &#039;spam&#039;&quot; );
				break;
			case &#039;database_trashed_comments&#039;:
				$count = $wpdb-&gt;get_var( &quot;SELECT COUNT(comment_ID) FROM $wpdb-&gt;comments WHERE (comment_approved = &#039;trash&#039; OR comment_approved = &#039;post-trashed&#039;)&quot; );
				break;
			case &#039;database_expired_transients&#039;:
				$time  = isset( $_SERVER[&#039;REQUEST_TIME&#039;] ) ? (int) $_SERVER[&#039;REQUEST_TIME&#039;] : time();
				$count = $wpdb-&gt;get_var( $wpdb-&gt;prepare( &quot;SELECT COUNT(option_name) FROM $wpdb-&gt;options WHERE option_name LIKE %s AND option_value &lt; %d&quot;, $wpdb-&gt;esc_like( &#039;_transient_timeout&#039; ) . &#039;%&#039;, $time ) );
				break;
			case &#039;database_all_transients&#039;:
				$count = $wpdb-&gt;get_var( $wpdb-&gt;prepare( &quot;SELECT COUNT(option_id) FROM $wpdb-&gt;options WHERE option_name LIKE %s OR option_name LIKE %s&quot;, $wpdb-&gt;esc_like( &#039;_transient_&#039; ) . &#039;%&#039;, $wpdb-&gt;esc_like( &#039;_site_transient_&#039; ) . &#039;%&#039; ) );
				break;
			case &#039;database_optimize_tables&#039;:
				$count = $wpdb-&gt;get_var( &quot;SELECT COUNT(table_name) FROM information_schema.tables WHERE table_schema = &#039;&quot; . DB_NAME . &quot;&#039; and Engine &lt;&gt; &#039;InnoDB&#039; and data_free &gt; 0&quot; );
				break;
		}

		return $count;
	}
}
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fwww%2Fwp-content%2Fplugins%2Fwp-rocket%2Finc%2Fclasses%2Fadmin%2FDatabase'>⬅ Back to Directory</a>