<?php
/*
Plugin Name: DB Reset
Plugin URI: http://trickeries.com/16/wordpress-database-resetter/
Description: terribly simple plugin to basically drop all of your wordpress tables.
Author: atom smith
Version: 1.0
Author URI: http://trickeries.com/
*/
 
 
add_action('init','db_reset_delete_tables');
add_action('admin_menu', 'add_db_reset_sub_menu');
 
function add_db_reset_sub_menu(){
	add_submenu_page('plugins.php', 'DB Reset', 'DB Reset', 9, __FILE__, 'db_reset_output');
}
 
function db_reset_output(){ ?>
 
	<div class="wrap">
		<h2>DB Reset</h2>
		<?php if(!isSet($_POST['db_reset'])): ?>
			<?php db_reset_get_tables() ?>
		<?php endif; ?>
	</div>
 
<?php }
 
function db_reset_get_tables(){
	global $wpdb;
	$prefixed_tables = $wpdb->prefix . '%';
	$tables = $wpdb->get_results("show tables LIKE '$prefixed_tables'", ARRAY_A);
	?>
	<div class="updated"><strong>Please make sure that you understand what you are doing before using this.  The following tables will be deleted and replaced:</strong>
		<ul>
		<?php foreach($tables as $k => $v): ?>
			<li>
				<?php echo $tables_to_delete[] = pos($v) ?>
			</li>
		<?php endforeach; ?>
		</ul>
	</div>
	<form action="#" method="post">
		<?php foreach($tables_to_delete as $table): ?>
			<input type="hidden" name="delete[]" value="<?php echo $table ?>" />
		<?php endforeach; ?>
		<input style="font-size:100px; width:100%; padding: 20px;" type="submit" name="db_reset" value="Reset DB" />
	</form>
<?php
}
 
function db_reset_delete_tables(){
	if(isSet($_POST['db_reset']) && $_POST['db_reset'] == 'Reset DB'){
		global $wpdb;
		if($wpdb->prefix != ''){
			foreach($_POST['delete'] as $table){
				$wpdb->query("DROP TABLE $table");
			}
			$location = "..";
		}
		header("Location: $location");
	}
}