get_var("SELECT data_free FROM INFORMATION_SCHEMA.TABLES WHERE table_name = '{$wpdb->prefix}posts'");
$mk_db_broken_tables_size_check = $wpdb->get_var("SELECT data_free FROM INFORMATION_SCHEMA.TABLES WHERE table_name = '{$wpdb->prefix}term_relationships'");
$mk_db_spam_comments_size_check = $wpdb->get_var("SELECT data_free FROM INFORMATION_SCHEMA.TABLES WHERE table_name = '{$wpdb->prefix}commentmeta'");
$mk_db_postmeta_trash_size_check = $wpdb->get_var("SELECT data_free FROM INFORMATION_SCHEMA.TABLES WHERE table_name = '{$wpdb->prefix}postmeta'");
$mk_db_options_size_check = $wpdb->get_var("SELECT data_free FROM INFORMATION_SCHEMA.TABLES WHERE table_name = '{$wpdb->prefix}options'");
if($_POST) {
$retrieved_nonce = $_REQUEST['_wpnonce'];
if (!wp_verify_nonce($retrieved_nonce, 'mk_pm_nonce_action' )){
die( 'Failed security check' );}
else {
if(isset($_POST['mk_revisions_clean'])) {
$islem1 = $wpdb->query("DELETE FROM {$wpdb->prefix}posts WHERE post_type='revision'");
$islem2 = $wpdb->query("OPTIMIZE TABLE `{$wpdb->prefix}posts`");
echo '';
}
if(isset($_POST['mk_draft_posts_clean'])) {
$wpdb->query("DELETE FROM {$wpdb->prefix}posts WHERE post_status = 'draft'");
$wpdb->query("OPTIMIZE TABLE `{$wpdb->prefix}posts`");
echo '';
}
if(isset($_POST['mk_trash_posts_clean'])) {
$wpdb->query("DELETE FROM {$wpdb->prefix}posts WHERE post_status = 'trash'");
$wpdb->query("OPTIMIZE TABLE `{$wpdb->prefix}posts`");
echo '';
}
if(isset($_POST['mk_broken_tables_clean'])) {
$wpdb->query("DELETE FROM {$wpdb->prefix}term_relationships WHERE NOT EXISTS ( SELECT * FROM wp_posts WHERE {$wpdb->prefix}term_relationships.object_id = {$wpdb->prefix}posts.ID)");
$wpdb->query("OPTIMIZE TABLE `{$wpdb->prefix}term_relationships`");
echo '';
}
if(isset($_POST['mk_spam_comments_clean'])) {
$wpdb->query("DELETE FROM {$wpdb->prefix}commentmeta WHERE comment_id NOT IN ( SELECT comment_id FROM wp_comments )");
$wpdb->query("OPTIMIZE TABLE `{$wpdb->prefix}commentmeta`");
echo '';
}
if(isset($_POST['mk_postmeta_trash_clean'])) {
$wpdb->query("DELETE {$wpdb->prefix}postmeta FROM wp_postmeta LEFT JOIN wp_posts ON ({$wpdb->prefix}postmeta.post_id = {$wpdb->prefix}posts.ID) WHERE ({$wpdb->prefix}posts.ID IS NULL)");
$wpdb->query("DELETE FROM {$wpdb->prefix}postmeta WHERE meta_key IN ('_edit_lock','_edit_last')");
$wpdb->query("OPTIMIZE TABLE `{$wpdb->prefix}postmeta`");
echo '';
}
if(isset($_POST['mk_transient_options_clean'])) {
$wpdb->query("DELETE FROM {$wpdb->prefix}options WHERE option_name LIKE ('_transient_%')");
$wpdb->query("DELETE FROM {$wpdb->prefix}options WHERE option_name LIKE ('_transient%_feed_%')");
$wpdb->query("OPTIMIZE TABLE `{$wpdb->prefix}options`");
echo '';
}
if(isset($_POST['mk_postmeta_table_trash_clean'])) {
$wpdb->query("DELETE {$wpdb->prefix}posts FROM wp_posts LEFT JOIN wp_posts child ON ({$wpdb->prefix}posts.post_parent = child.ID) WHERE ({$wpdb->prefix}posts.post_parent <> 0) AND (child.ID IS NULL)");
$wpdb->query("DELETE pm FROM {$wpdb->prefix}postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL");
$wpdb->query("OPTIMIZE TABLE `{$wpdb->prefix}posts`");
echo '';
}
}
}
?>
 .'assets/img/advanced-db-cleaner-logo.png'; ?>){kind=logo}