function maintenance_site() { global $wpdb; $information = array(); if (isset($_POST['action'])) { if ($_POST['action'] === 'save_settings') { if (isset($_POST['enable_alert']) && $_POST['enable_alert'] == 1) { MainWPHelper::update_option('mainwp_maintenance_opt_alert_404', 1, 'yes'); } else { delete_option('mainwp_maintenance_opt_alert_404'); } if (isset($_POST['email']) && !empty($_POST['email'])) { MainWPHelper::update_option('mainwp_maintenance_opt_alert_404_email', $_POST['email'], 'yes'); } else { delete_option('mainwp_maintenance_opt_alert_404_email'); } $information['result'] = 'SUCCESS'; MainWPHelper::write($information); return; } else { if ($_POST['action'] === 'clear_settings') { delete_option('mainwp_maintenance_opt_alert_404'); delete_option('mainwp_maintenance_opt_alert_404_email'); $information['result'] = 'SUCCESS'; MainWPHelper::write($information); } } MainWPHelper::write($information); } $maint_options = $_POST['options']; $max_revisions = isset($_POST['revisions']) ? intval($_POST['revisions']) : 0; if (!is_array($maint_options)) { $information['status'] = 'FAIL'; $maint_options = array(); } if (empty($max_revisions)) { $sql_clean = "DELETE FROM {$wpdb->posts} WHERE post_type = 'revision'"; $wpdb->query($sql_clean); } else { $results = MainWPHelper::getRevisions($max_revisions); $count_deleted = MainWPHelper::deleteRevisions($results, $max_revisions); } if (in_array('autodraft', $maint_options)) { $sql_clean = "DELETE FROM {$wpdb->posts} WHERE post_status = 'auto-draft'"; $wpdb->query($sql_clean); } if (in_array('trashpost', $maint_options)) { $sql_clean = "DELETE FROM {$wpdb->posts} WHERE post_status = 'trash'"; $wpdb->query($sql_clean); } if (in_array('spam', $maint_options)) { $sql_clean = "DELETE FROM {$wpdb->comments} WHERE comment_approved = 'spam'"; $wpdb->query($sql_clean); } if (in_array('pending', $maint_options)) { $sql_clean = "DELETE FROM {$wpdb->comments} WHERE comment_approved = '0'"; $wpdb->query($sql_clean); } if (in_array('trashcomment', $maint_options)) { $sql_clean = "DELETE FROM {$wpdb->comments} WHERE comment_approved = 'trash'"; $wpdb->query($sql_clean); } if (in_array('tags', $maint_options)) { $post_tags = get_terms('post_tag', array('hide_empty' => false)); if (is_array($post_tags)) { foreach ($post_tags as $tag) { if ($tag->count == 0) { wp_delete_term($tag->term_id, 'post_tag'); } } } } if (in_array('categories', $maint_options)) { $post_cats = get_terms('category', array('hide_empty' => false)); if (is_array($post_cats)) { foreach ($post_cats as $cat) { if ($cat->count == 0) { wp_delete_term($cat->term_id, 'category'); } } } } if (in_array('optimize', $maint_options)) { $this->maintenance_optimize(); } if (!isset($information['status'])) { $information['status'] = 'SUCCESS'; } MainWPHelper::write($information); }