/wp-content/plugins/wp-dbmanager/database-empty.php
PHP | 118 lines | 87 code | 9 blank | 22 comment | 13 complexity | ed0c0af95f61057b26dec63a0e8405fc MD5 | raw file
- <?php
- /*
- +----------------------------------------------------------------+
- | |
- | WordPress 2.8 Plugin: WP-DBManager 2.63 |
- | Copyright (c) 2009 Lester "GaMerZ" Chan |
- | |
- | File Written By: |
- | - Lester "GaMerZ" Chan |
- | - http://lesterchan.net |
- | |
- | File Information: |
- | - Database Empty |
- | - wp-content/plugins/wp-dbmanager/database-empty.php |
- | |
- +----------------------------------------------------------------+
- */
- ### Check Whether User Can Manage Database
- if(!current_user_can('manage_database')) {
- die('Access Denied');
- }
- ### Variables Variables Variables
- $base_name = plugin_basename('wp-dbmanager/database-manager.php');
- $base_page = 'admin.php?page='.$base_name;
- $backup = array();
- $backup_options = get_option('dbmanager_options');
- $backup['date'] = current_time('timestamp');
- $backup['mysqldumppath'] = $backup_options['mysqldumppath'];
- $backup['mysqlpath'] = $backup_options['mysqlpath'];
- $backup['path'] = $backup_options['path'];
- ### Form Processing
- if($_POST['do']) {
- // Lets Prepare The Variables
- $emptydrop = $_POST['emptydrop'];
- // Decide What To Do
- switch($_POST['do']) {
- case __('Empty/Drop', 'wp-dbmanager'):
- check_admin_referer('wp-dbmanager_empty');
- $empty_tables = array();
- if(!empty($emptydrop)) {
- foreach($emptydrop as $key => $value) {
- if($value == 'empty') {
- $empty_tables[] = $key;
- } elseif($value == 'drop') {
- $drop_tables .= ', '.$key;
- }
- }
- } else {
- $text = '<font color="red">'.__('No Tables Selected.', 'wp-dbmanager').'</font>';
- }
- $drop_tables = substr($drop_tables, 2);
- if(!empty($empty_tables)) {
- foreach($empty_tables as $empty_table) {
- $empty_query = $wpdb->query("TRUNCATE $empty_table");
- $text .= '<font color="green">'.sprintf(__('Table \'%s\' Emptied', 'wp-dbmanager'), $empty_table).'</font><br />';
- }
- }
- if(!empty($drop_tables)) {
- $drop_query = $wpdb->query("DROP TABLE $drop_tables");
- $text = '<font color="green">'.sprintf(__('Table(s) \'%s\' Dropped', 'wp-dbmanager'), $drop_tables).'</font>';
- }
- break;
- }
- }
- ### Show Tables
- $tables = $wpdb->get_col("SHOW TABLES");
- ?>
- <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?>
- <!-- Empty/Drop Tables -->
- <form method="post" action="<?php echo admin_url('admin.php?page='.plugin_basename(__FILE__)); ?>">
- <?php wp_nonce_field('wp-dbmanager_empty'); ?>
- <div class="wrap">
- <div id="icon-wp-dbmanager" class="icon32"><br /></div>
- <h2><?php _e('Empty/Drop Tables', 'wp-dbmanager'); ?></h2>
- <br style="clear" />
- <table class="widefat">
- <thead>
- <tr>
- <th><?php _e('Tables', 'wp-dbmanager'); ?></th>
- <th><?php _e('Empty', 'wp-dbmanager'); ?> <sup><?php _e('1', 'wp-dbmanager'); ?></sup></th>
- <th><?php _e('Drop', 'wp-dbmanager'); ?> <sup><?php _e('2', 'wp-dbmanager'); ?></sup></th>
- </tr>
- </thead>
- <?php
- foreach($tables as $table_name) {
- if($no%2 == 0) {
- $style = '';
- } else {
- $style = ' class="alternate"';
- }
- $no++;
- echo "<tr $style><th align=\"left\" scope=\"row\">$table_name</th>\n";
- echo "<td><input type=\"radio\" id=\"$table_name-empty\" name=\"emptydrop[$table_name]\" value=\"empty\" /> <label for=\"$table_name-empty\">".__('Empty', 'wp-dbmanager').'</label></td>';
- echo "<td><input type=\"radio\" id=\"$table_name-drop\" name=\"emptydrop[$table_name]\" value=\"drop\" /> <label for=\"$table_name-drop\">".__('Drop', 'wp-dbmanager').'</label></td></tr>';
- }
- ?>
- <tr>
- <td colspan="3">
- <?php _e('1. EMPTYING a table means all the rows in the table will be deleted. This action is not REVERSIBLE.', 'wp-dbmanager'); ?>
- <br />
- <?php _e('2. DROPPING a table means deleting the table. This action is not REVERSIBLE.', 'wp-dbmanager'); ?>
- </td>
- </tr>
- <tr>
- <td colspan="3" align="center"><input type="submit" name="do" value="<?php _e('Empty/Drop', 'wp-dbmanager'); ?>" class="button" onclick="return confirm('<?php _e('You Are About To Empty Or Drop The Selected Databases.\nThis Action Is Not Reversible.\n\n Choose [Cancel] to stop, [Ok] to delete.', 'wp-dbmanager'); ?>')" /> <input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td>
- </tr>
- </table>
- </div>
- </form>