simple-revision-cleaner.php

<?php

/**
 * Simple Revision Cleaner
 *
 * This file is read by WordPress to generate the plugin information in the plugin
 * admin area. This file also includes all of the dependencies used by the plugin,
 * registers the activation and deactivation functions, and defines a function
 * that starts the plugin.
 *
 * @link              https://github.com/my-language-skills/simple-revision-cleaner
 * @since             1.0
 * @package           simple-revision-cleaner
 *
 * @wordpress-plugin
 * Plugin Name:       Simple Revision Cleaner
 * Plugin URI:        https://github.com/my-language-skills/simple-revision-cleaner
 * Description:       The plugin aim is to provide possibility for automatic deletion of old revisions on WordPress multisite.
 * Version:           1.1.1
 * Author:            My Language Skills team
 * Author URI:        https://github.com/my-language-skills/
 * License:           GPL 3.0
 * License URI:       http://www.gnu.org/licenses/gpl-3.0.txt
 * Text Domain:       simple-revision-cleaner
 * Domain Path:       /languages
 * Network:						true
 */

// If this file is called directly, abort.
if ( ! defined( 'WPINC' ) ) {
	die;
}


/**
 * Main function that takes care of flushing database from old revisions.
 *
 * @since 0.1
 *
 */

function src_flush_revisions (){
	global $wpdb;
	$limit = 1000;

	$time_format = get_option( 'time_format' );
	$date_format = get_option( 'date_format' );

	//getting option responsible for time limit of deletion
	$timeLimit = get_option('src_time_limit');
	//if not defined time limit for deleting, skip
	if (isset($timeLimit)) {
		$start = time();
		// We keep only 1 week worth of post revisions.
		$revision_ids = $wpdb->get_col($wpdb->prepare( "SELECT `ID` FROM $wpdb->posts WHERE (`post_type` = 'revision') AND `post_date_gmt` < DATE_SUB(NOW(), INTERVAL '$timeLimit' DAY) LIMIT %d", $limit ));
		$revision_ids_amount = 0;
		foreach ( $revision_ids as $revision_id ) {
			wp_delete_post_revision( $revision_id );
		}

	}
}

/**
 * Function to create settings section on General Settings page.
 *
 * @since 0.1
 *
 */
function src_sett_section(){

	//adding section to main options page
	add_settings_section('src_settings', __('Revisions Cleaner', 'simple-revision-cleaner'), '', 'general');

	//registering setting for interval value
	register_setting('general', 'src_time_limit');

	//callback function for setting field
	$create_field = function () {
		$disabled = get_blog_option(1,'src_freeze_limit') ? 'readonly' : '';
		$value = get_option('src_time_limit');
		$html = '<input type="number" id="src_time_limit" name="src_time_limit" '.$disabled.' value="'.esc_html($value).'">';
		$html .= '<p><i>' . __('Interval in days since today to store revisions.', 'simple-revision-cleaner');
		$html .= $disabled == 'readonly' ? __(' Set by network administrator. In order to change value, please, contact him.', 'simple-revision-cleaner')  : '';
		$html .= '</i></p>';
		echo $html;
	};
	add_settings_field('src_time_limit', __('Time interval', 'simple-revision-cleaner'), $create_field, 'general', 'src_settings');
}

/**
 * Function for displaying content of network settings page.
 *
 * @since 0.1
 *
 */
function src_render_net_set(){
	?>
	<div class="wrap">
		<form method="POST" action="edit.php?action=update_network_options_flush">
			<?php
			settings_fields('src_net_settings');
			do_settings_sections('src_net_settings');
			submit_button();
			?>
		</form>
	</div>
	<?php
}

/**
 * Function to create network settings page for plugin.
 *
 * @since 0.1
 *
 */
function src_net_sett_section(){

	add_submenu_page('settings.php', __('Revisions Cleaner', 'simple-revision-cleaner'),
								__('Revisions Cleaner', 'simple-revision-cleaner'),
								'manage_network_options', 'src_net_settings' ,'src_render_net_set');

	//adding section to main options page
	add_settings_section('src_net_settings', __('Revisions Cleaner', 'simple-revision-cleaner'),
	 											'', 'src_net_settings');

	//registering setting for freezing value over all sites in multisite
	register_setting('src_net_settings', 'src_freeze_limit');
	//registering setting for interval value
	register_setting('src_net_settings', 'src_net_time_limit');

	//callback function for setting field
	$create_field = function () {
		$value = get_option('src_net_time_limit');
		$html = '<input type="number" id="src_net_time_limit" required name="src_net_time_limit" value="'.esc_html($value).'">';
		$html .= '<p><i>' .  __('Interval in days since today to store revisions.', 'simple-revision-cleaner') . '</i></p>';
		echo $html;
	};

	//callback function for freezing setting field
	$create_freeze_field = function () {
		$checked = get_option('src_freeze_limit') ? 'checked' : '';
		$html = '<input type="checkbox" id="src_freeze_limit" name="src_freeze_limit" '.$checked.' value="1">';
		$html .= '<p><i>' . __('If checked, the interval over all blogs will be equal to the one above.', 'simple-revision-cleaner') . '</i></p>';
		echo $html;
	};

	add_settings_field('src_net_time_limit', __('Time interval', 'simple-revision-cleaner') , $create_field, 'src_net_settings', 'src_net_settings');
	add_settings_field('src_freeze_limit', __('Set for all sites', 'simple-revision-cleaner'), $create_freeze_field, 'src_net_settings', 'src_net_settings');
}

/**
 * Function responsible for option overwriting over all sites.
 *
 * @since 0.1
 * @since 1.1.1 Fixed a overwriting bug for Main Blog
 *
 */
function src_update_flush_options (){

	global $wpdb;

	if(check_admin_referer('src_net_settings-options')){ //is Network setting page
		update_option( 'src_net_time_limit', sanitize_text_field( $_POST['src_net_time_limit'] ) );
		update_option('src_freeze_limit', sanitize_key($_POST['src_freeze_limit']));
	}

	//Grabbing all the site IDs
	$blogids = $wpdb->get_col("SELECT blog_id FROM $wpdb->blogs");

	//Going through the sites
	foreach ($blogids as $blog_id) {

		//Switching site
		switch_to_blog($blog_id);
		if (isset($_POST['src_freeze_limit'])) {
			update_option( 'src_time_limit',   sanitize_text_field($_POST['src_net_time_limit']));
			src_flush_revisions();
		}
	}

	// At the end we redirect back to our options page.
	 wp_redirect(add_query_arg(array('page' => 'src_net_settings',
	                                'updated' => 'true'), network_admin_url('settings.php')));

	exit;
}

/**
 * Function called during activation process.
 *
 * @since 0.1
 *
 */
function src_activator() {

	global $wpdb;

	//Grabbing all the site IDs
	$siteids = $wpdb->get_col( "SELECT blog_id FROM $wpdb->blogs" );

	//Going through the sites
	foreach ( $siteids as $site_id ) {
		switch_to_blog($site_id);
		if ($site_id == 1){
			update_option( 'src_net_time_limit', '365' );
			continue;
		}
		update_option( 'src_time_limit', '365' );
	}
}

//executing flush on admin area visiting
add_action('admin_init', 'src_flush_revisions');
//adding settings section on main settings page
add_action('admin_menu', 'src_sett_section');
//activation process
register_activation_hook(__FILE__, 'src_activator');

//add network page if is multisite installation and handle option updates
if (is_multisite()){
	add_action('network_admin_menu', 'src_net_sett_section');
	add_action('network_admin_edit_update_network_options_flush', 'src_update_flush_options');
}

/**
 * Internalization.
 * It loads the MO file for plugin's translation.
 *
 * @since 1.1.1
 *
 * @return void
 */
	function src_load_plugin_textdomain() {
    load_plugin_textdomain( 'simple-revision-cleaner', FALSE, basename( dirname( __FILE__ ) ) . '/languages/' );
}

/**
 * Internalization
 * Called when the activated plugin has been loaded.
 */
add_action( 'plugins_loaded', 'src_load_plugin_textdomain' );