WP-DBManager - Version 2.30

Version Description

Download this release

Release Info

Developer GamerZ
Plugin Icon WP-DBManager
Version 2.30
Comparing to
See all releases

Code changes from version 2.20 to 2.30

Files changed (14) hide show
  1. dbmanager/database-backup.php → database-backup.php +55 -49
  2. dbmanager/database-empty.php → database-empty.php +26 -21
  3. dbmanager/database-manage.php → database-manage.php +32 -28
  4. dbmanager/database-manager.php → database-manager.php +37 -29
  5. dbmanager/database-optimize.php → database-optimize.php +21 -18
  6. dbmanager/database-repair.php → database-repair.php +20 -17
  7. dbmanager/database-run.php → database-run.php +22 -14
  8. dbmanager/database-uninstall.php → database-uninstall.php +47 -45
  9. dbmanager/wp-dbmanager.mo +0 -0
  10. readme.html +23 -25
  11. readme.txt +3 -3
  12. wp-dbmanager.mo +0 -0
  13. dbmanager/dbmanager.php → wp-dbmanager.php +169 -141
  14. dbmanager/wp-dbmanager.pot → wp-dbmanager.pot +224 -205
dbmanager/database-backup.php → database-backup.php RENAMED
@@ -2,8 +2,8 @@
2
  /*
3
  +----------------------------------------------------------------+
4
  | |
5
- | WordPress 2.1 Plugin: WP-DBManager 2.20 |
6
- | Copyright (c) 2007 Lester "GaMerZ" Chan |
7
  | |
8
  | File Written By: |
9
  | - Lester "GaMerZ" Chan |
@@ -11,7 +11,7 @@
11
  | |
12
  | File Information: |
13
  | - Database Backup |
14
- | - wp-content/plugins/dbmanager/database-backup.php |
15
  | |
16
  +----------------------------------------------------------------+
17
  */
@@ -24,9 +24,9 @@ if(!current_user_can('manage_database')) {
24
 
25
 
26
  ### Variables Variables Variables
27
- $base_name = plugin_basename('dbmanager/database-manager.php');
28
  $base_page = 'admin.php?page='.$base_name;
29
- $current_date = gmdate(sprintf(__('%s @ %s', 'wp-dbmanager'), get_option('date_format'), get_option('time_format')), (time() + (get_option('gmt_offset') * 3600)));
30
  $backup = array();
31
  $backup_options = get_option('dbmanager_options');
32
  $backup['date'] = current_time('timestamp');
@@ -50,8 +50,7 @@ if($_POST['do']) {
50
  $backup['filepath'] = $backup['path'].'/'.$backup['filename'];
51
  $backup['command'] = $backup['mysqldumppath'].' --host="'.DB_HOST.'" --user="'.DB_USER.'" --password="'.DB_PASSWORD.'" --add-drop-table --skip-lock-tables '.DB_NAME.' > '.$backup['filepath'];
52
  }
53
- check_backup_files();
54
- passthru($backup['command'], $error);
55
  if(!is_writable($backup['path'])) {
56
  $text = '<font color="red">'.sprintf(__('Database Failed To Backup On \'%s\'. Backup Folder Not Writable.', 'wp-dbmanager'), $current_date).'</font>';
57
  } elseif(filesize($backup['filepath']) == 0) {
@@ -84,13 +83,13 @@ $stats_function_disabled = 0;
84
  <p>
85
  <?php _e('Checking Backup Folder', 'wp-dbmanager'); ?> (<strong><?php echo stripslashes($backup['path']); ?></strong>) ...<br />
86
  <?php
87
- if(is_dir(stripslashes($backup['path']))) {
88
  echo '<font color="green">'.__('Backup folder exists', 'wp-dbmanager').'</font><br />';
89
  $status_count++;
90
  } else {
91
  echo '<font color="red">'.__('Backup folder does NOT exist. Please create \'backup-db\' folder in \'wp-content\' folder and CHMOD it to \'777\' or change the location of the backup folder under DB Option.', 'wp-dbmanager').'</font><br />';
92
  }
93
- if(is_writable(stripslashes($backup['path']))) {
94
  echo '<font color="green">'.__('Backup folder is writable', 'wp-dbmanager').'</font>';
95
  $status_count++;
96
  } else {
@@ -100,7 +99,7 @@ $stats_function_disabled = 0;
100
  </p>
101
  <p>
102
  <?php
103
- if(file_exists(stripslashes($backup['mysqldumppath']))) {
104
  echo __('Checking MYSQL Dump Path', 'wp-dbmanager').' (<strong>'.stripslashes($backup['mysqldumppath']).'</strong>) ...<br />';
105
  echo '<font color="green">'.__('MYSQL dump path exists.', 'wp-dbmanager').'</font>';
106
  $status_count++;
@@ -112,7 +111,7 @@ $stats_function_disabled = 0;
112
  </p>
113
  <p>
114
  <?php
115
- if(file_exists(stripslashes($backup['mysqlpath']))) {
116
  echo __('Checking MYSQL Path', 'wp-dbmanager').' (<strong>'.stripslashes($backup['mysqlpath']).'</strong>) ...<br />';
117
  echo '<font color="green">'.__('MYSQL path exists.', 'wp-dbmanager').'</font>';
118
  $status_count++;
@@ -160,41 +159,48 @@ $stats_function_disabled = 0;
160
  <p><i><?php _e('Note: The checking of backup status is still undergoing testing, it may not be accurate.', 'wp-dbmanager'); ?></i></p>
161
  </div>
162
  <!-- Backup Database -->
163
- <div class="wrap">
164
- <h2><?php _e('Backup Database', 'wp-dbmanager'); ?></h2>
165
- <form action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="post">
166
- <table width="100%" cellspacing="3" cellpadding="3" border="0">
167
- <tr>
168
- <th align="left" scope="row"><?php _e('Database Name:', 'wp-dbmanager'); ?></th>
169
- <td><?php echo DB_NAME; ?></td>
170
- </tr>
171
- <tr style="background-color: #eee;">
172
- <th align="left" scope="row"><?php _e('Database Backup To:', 'wp-dbmanager'); ?></th>
173
- <td><?php echo stripslashes($backup['path']); ?></td>
174
- </tr>
175
- <tr>
176
- <th align="left" scope="row"><?php _e('Database Backup Date:', 'wp-dbmanager'); ?></th>
177
- <td><?php echo gmdate(sprintf(__('%s @ %s', 'wp-dbmanager'), get_option('date_format'), get_option('time_format')), $backup['date']); ?></td>
178
- </tr>
179
- <tr style="background-color: #eee;">
180
- <th align="left" scope="row"><?php _e('Database Backup File Name:', 'wp-dbmanager'); ?></th>
181
- <td><?php echo $backup['filename']; ?></td>
182
- </tr>
183
- <tr>
184
- <th align="left" scope="row"><?php _e('Database Backup Type:', 'wp-dbmanager'); ?></th>
185
- <td><?php _e('Full (Structure and Data)', 'wp-dbmanager'); ?></td>
186
- </tr>
187
- <tr style="background-color: #eee;">
188
- <th align="left" scope="row"><?php _e('MYSQL Dump Location:', 'wp-dbmanager'); ?></th>
189
- <td><?php echo stripslashes($backup['mysqldumppath']); ?></td>
190
- </tr>
191
- <tr>
192
- <th align="left" scope="row"><?php _e('GZIP Database Backup File?', 'wp-dbmanager'); ?></th>
193
- <td><input type="radio" name="gzip" value="1" /><?php _e('Yes', 'wp-dbmanager'); ?>&nbsp;&nbsp;<input type="radio" name="gzip" value="0" checked="checked" /><?php _e('No', 'wp-dbmanager'); ?></td>
194
- </tr>
195
- <tr>
196
- <td colspan="2" align="center"><input type="submit" name="do" value="<?php _e('Backup', 'wp-dbmanager'); ?>" class="button" />&nbsp;&nbsp;<input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td>
197
- </tr>
198
- </table>
199
- </form>
200
- </div>
 
 
 
 
 
 
 
2
  /*
3
  +----------------------------------------------------------------+
4
  | |
5
+ | WordPress 2.5 Plugin: WP-DBManager 2.30 |
6
+ | Copyright (c) 2008 Lester "GaMerZ" Chan |
7
  | |
8
  | File Written By: |
9
  | - Lester "GaMerZ" Chan |
11
  | |
12
  | File Information: |
13
  | - Database Backup |
14
+ | - wp-content/plugins/wp-dbmanager/database-backup.php |
15
  | |
16
  +----------------------------------------------------------------+
17
  */
24
 
25
 
26
  ### Variables Variables Variables
27
+ $base_name = plugin_basename('wp-dbmanager/database-manager.php');
28
  $base_page = 'admin.php?page='.$base_name;
29
+ $current_date = mysql2date(sprintf(__('%s @ %s', 'wp-dbmanager'), get_option('date_format'), get_option('time_format')), gmdate('Y-m-d H:i:s', current_time('timestamp')));
30
  $backup = array();
31
  $backup_options = get_option('dbmanager_options');
32
  $backup['date'] = current_time('timestamp');
50
  $backup['filepath'] = $backup['path'].'/'.$backup['filename'];
51
  $backup['command'] = $backup['mysqldumppath'].' --host="'.DB_HOST.'" --user="'.DB_USER.'" --password="'.DB_PASSWORD.'" --add-drop-table --skip-lock-tables '.DB_NAME.' > '.$backup['filepath'];
52
  }
53
+ $error = execute_backup($backup['command']);
 
54
  if(!is_writable($backup['path'])) {
55
  $text = '<font color="red">'.sprintf(__('Database Failed To Backup On \'%s\'. Backup Folder Not Writable.', 'wp-dbmanager'), $current_date).'</font>';
56
  } elseif(filesize($backup['filepath']) == 0) {
83
  <p>
84
  <?php _e('Checking Backup Folder', 'wp-dbmanager'); ?> (<strong><?php echo stripslashes($backup['path']); ?></strong>) ...<br />
85
  <?php
86
+ if(@is_dir(stripslashes($backup['path']))) {
87
  echo '<font color="green">'.__('Backup folder exists', 'wp-dbmanager').'</font><br />';
88
  $status_count++;
89
  } else {
90
  echo '<font color="red">'.__('Backup folder does NOT exist. Please create \'backup-db\' folder in \'wp-content\' folder and CHMOD it to \'777\' or change the location of the backup folder under DB Option.', 'wp-dbmanager').'</font><br />';
91
  }
92
+ if(@is_writable(stripslashes($backup['path']))) {
93
  echo '<font color="green">'.__('Backup folder is writable', 'wp-dbmanager').'</font>';
94
  $status_count++;
95
  } else {
99
  </p>
100
  <p>
101
  <?php
102
+ if(@file_exists(stripslashes($backup['mysqldumppath']))) {
103
  echo __('Checking MYSQL Dump Path', 'wp-dbmanager').' (<strong>'.stripslashes($backup['mysqldumppath']).'</strong>) ...<br />';
104
  echo '<font color="green">'.__('MYSQL dump path exists.', 'wp-dbmanager').'</font>';
105
  $status_count++;
111
  </p>
112
  <p>
113
  <?php
114
+ if(@file_exists(stripslashes($backup['mysqlpath']))) {
115
  echo __('Checking MYSQL Path', 'wp-dbmanager').' (<strong>'.stripslashes($backup['mysqlpath']).'</strong>) ...<br />';
116
  echo '<font color="green">'.__('MYSQL path exists.', 'wp-dbmanager').'</font>';
117
  $status_count++;
159
  <p><i><?php _e('Note: The checking of backup status is still undergoing testing, it may not be accurate.', 'wp-dbmanager'); ?></i></p>
160
  </div>
161
  <!-- Backup Database -->
162
+ <form action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="post">
163
+ <div class="wrap">
164
+ <h2><?php _e('Backup Database', 'wp-dbmanager'); ?></h2>
165
+ <br style="clear" />
166
+ <table class="widefat">
167
+ <thead>
168
+ <tr>
169
+ <th><?php _e('Option', 'wp-dbmanager'); ?></th>
170
+ <th><?php _e('Value', 'wp-dbmanager'); ?></th>
171
+ </tr>
172
+ </thead>
173
+ <tr>
174
+ <th><?php _e('Database Name:', 'wp-dbmanager'); ?></th>
175
+ <td><?php echo DB_NAME; ?></td>
176
+ </tr>
177
+ <tr style="background-color: #eee;">
178
+ <th><?php _e('Database Backup To:', 'wp-dbmanager'); ?></th>
179
+ <td><?php echo stripslashes($backup['path']); ?></td>
180
+ </tr>
181
+ <tr>
182
+ <th><?php _e('Database Backup Date:', 'wp-dbmanager'); ?></th>
183
+ <td><?php echo mysql2date(sprintf(__('%s @ %s', 'wp-dbmanager'), get_option('date_format'), get_option('time_format')), gmdate('Y-m-d H:i:s', $backup['date'])); ?></td>
184
+ </tr>
185
+ <tr style="background-color: #eee;">
186
+ <th><?php _e('Database Backup File Name:', 'wp-dbmanager'); ?></th>
187
+ <td><?php echo $backup['filename']; ?></td>
188
+ </tr>
189
+ <tr>
190
+ <th><?php _e('Database Backup Type:', 'wp-dbmanager'); ?></th>
191
+ <td><?php _e('Full (Structure and Data)', 'wp-dbmanager'); ?></td>
192
+ </tr>
193
+ <tr style="background-color: #eee;">
194
+ <th><?php _e('MYSQL Dump Location:', 'wp-dbmanager'); ?></th>
195
+ <td><?php echo stripslashes($backup['mysqldumppath']); ?></td>
196
+ </tr>
197
+ <tr>
198
+ <th><?php _e('GZIP Database Backup File?', 'wp-dbmanager'); ?></th>
199
+ <td><input type="radio" id="gzip-yes" name="gzip" value="1" />&nbsp;<label for="gzip-yes"><?php _e('Yes', 'wp-dbmanager'); ?></label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" id="gzip-no" name="gzip" value="0" checked="checked" />&nbsp;<label for="gzip-no"><?php _e('No', 'wp-dbmanager'); ?></label></td>
200
+ </tr>
201
+ <tr>
202
+ <td colspan="2" align="center"><input type="submit" name="do" value="<?php _e('Backup', 'wp-dbmanager'); ?>" class="button" />&nbsp;&nbsp;<input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td>
203
+ </tr>
204
+ </table>
205
+ </div>
206
+ </form>
dbmanager/database-empty.php → database-empty.php RENAMED
@@ -2,8 +2,8 @@
2
  /*
3
  +----------------------------------------------------------------+
4
  | |
5
- | WordPress 2.1 Plugin: WP-DBManager 2.20 |
6
- | Copyright (c) 2007 Lester "GaMerZ" Chan |
7
  | |
8
  | File Written By: |
9
  | - Lester "GaMerZ" Chan |
@@ -11,7 +11,7 @@
11
  | |
12
  | File Information: |
13
  | - Database Empty |
14
- | - wp-content/plugins/dbmanager/database-empty.php |
15
  | |
16
  +----------------------------------------------------------------+
17
  */
@@ -24,7 +24,7 @@ if(!current_user_can('manage_database')) {
24
 
25
 
26
  ### Variables Variables Variables
27
- $base_name = plugin_basename('dbmanager/database-manager.php');
28
  $base_page = 'admin.php?page='.$base_name;
29
  $backup = array();
30
  $backup_options = get_option('dbmanager_options');
@@ -75,36 +75,41 @@ $tables = $wpdb->get_col("SHOW TABLES");
75
  ?>
76
  <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?>
77
  <!-- Empty/Drop Tables -->
78
- <div class="wrap">
79
- <h2><?php _e('Empty/Drop Tables', 'wp-dbmanager'); ?></h2>
80
- <form action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="post">
81
- <table width="100%" cellspacing="3" cellpadding="3" border="0">
82
- <tr class="thead">
83
- <th align="left"><?php _e('Tables', 'wp-dbmanager'); ?></th>
84
- <th align="left"><?php _e('Empty', 'wp-dbmanager'); ?></th>
85
- <th align="left"><?php _e('Drop', 'wp-dbmanager'); ?></th>
86
- </tr>
 
 
 
87
  <?php
88
  foreach($tables as $table_name) {
89
  if($no%2 == 0) {
90
- $style = 'style=\'background: none;\'';
91
  } else {
92
- $style = 'style=\'background-color: #eee;\'';
93
  }
94
  $no++;
95
  echo "<tr $style><th align=\"left\" scope=\"row\">$table_name</th>\n";
96
- echo "<td><input type=\"radio\" name=\"emptydrop[$table_name]\" value=\"empty\" />&nbsp;".__('Empty', 'wp-dbmanager').'</td>';
97
- echo "<td><input type=\"radio\" name=\"emptydrop[$table_name]\" value=\"drop\" />&nbsp;".__('Drop', 'wp-dbmanager').'</td></tr>';
98
  }
99
  ?>
100
  <tr>
101
  <td colspan="3">
102
- <?php _e('1. DROPPING a table means deleting the table. This action is not REVERSIBLE.', 'wp-dbmanager'); ?><br />
103
- <?php _e('2. EMPTYING a table means all the rows in the table will be deleted. This action is not REVERSIBLE.', 'wp-dbmanager'); ?></td>
 
 
104
  </tr>
105
  <tr>
106
  <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'); ?>')" />&nbsp;&nbsp;<input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td>
107
  </tr>
108
  </table>
109
- </form>
110
- </div>
2
  /*
3
  +----------------------------------------------------------------+
4
  | |
5
+ | WordPress 2.5 Plugin: WP-DBManager 2.30 |
6
+ | Copyright (c) 2008 Lester "GaMerZ" Chan |
7
  | |
8
  | File Written By: |
9
  | - Lester "GaMerZ" Chan |
11
  | |
12
  | File Information: |
13
  | - Database Empty |
14
+ | - wp-content/plugins/wp-dbmanager/database-empty.php |
15
  | |
16
  +----------------------------------------------------------------+
17
  */
24
 
25
 
26
  ### Variables Variables Variables
27
+ $base_name = plugin_basename('wp-dbmanager/database-manager.php');
28
  $base_page = 'admin.php?page='.$base_name;
29
  $backup = array();
30
  $backup_options = get_option('dbmanager_options');
75
  ?>
76
  <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?>
77
  <!-- Empty/Drop Tables -->
78
+ <form action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="post">
79
+ <div class="wrap">
80
+ <h2><?php _e('Empty/Drop Tables', 'wp-dbmanager'); ?></h2>
81
+ <br style="clear" />
82
+ <table class="widefat">
83
+ <thead>
84
+ <tr>
85
+ <th><?php _e('Tables', 'wp-dbmanager'); ?></th>
86
+ <th><?php _e('Empty', 'wp-dbmanager'); ?> <sup><?php _e('1', 'wp-dbmanager'); ?></sup></th>
87
+ <th><?php _e('Drop', 'wp-dbmanager'); ?> <sup><?php _e('2', 'wp-dbmanager'); ?></sup></th>
88
+ </tr>
89
+ </thead>
90
  <?php
91
  foreach($tables as $table_name) {
92
  if($no%2 == 0) {
93
+ $style = '';
94
  } else {
95
+ $style = ' class="alternate"';
96
  }
97
  $no++;
98
  echo "<tr $style><th align=\"left\" scope=\"row\">$table_name</th>\n";
99
+ echo "<td><input type=\"radio\" id=\"$table_name-empty\" name=\"emptydrop[$table_name]\" value=\"empty\" />&nbsp;<label for=\"$table_name-empty\">".__('Empty', 'wp-dbmanager').'</label></td>';
100
+ echo "<td><input type=\"radio\" id=\"$table_name-drop\" name=\"emptydrop[$table_name]\" value=\"drop\" />&nbsp;<label for=\"$table_name-drop\">".__('Drop', 'wp-dbmanager').'</label></td></tr>';
101
  }
102
  ?>
103
  <tr>
104
  <td colspan="3">
105
+ <?php _e('1. EMPTYING a table means all the rows in the table will be deleted. This action is not REVERSIBLE.', 'wp-dbmanager'); ?>
106
+ <br />
107
+ <?php _e('2. DROPPING a table means deleting the table. This action is not REVERSIBLE.', 'wp-dbmanager'); ?>
108
+ </td>
109
  </tr>
110
  <tr>
111
  <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'); ?>')" />&nbsp;&nbsp;<input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td>
112
  </tr>
113
  </table>
114
+ </div>
115
+ </form>
dbmanager/database-manage.php → database-manage.php RENAMED
@@ -2,8 +2,8 @@
2
  /*
3
  +----------------------------------------------------------------+
4
  | |
5
- | WordPress 2.1 Plugin: WP-DBManager 2.20 |
6
- | Copyright (c) 2007 Lester "GaMerZ" Chan |
7
  | |
8
  | File Written By: |
9
  | - Lester "GaMerZ" Chan |
@@ -11,7 +11,7 @@
11
  | |
12
  | File Information: |
13
  | - Database Restore |
14
- | - wp-content/plugins/dbmanager/database-restore.php |
15
  | |
16
  +----------------------------------------------------------------+
17
  */
@@ -24,7 +24,7 @@ if(!current_user_can('manage_database')) {
24
 
25
 
26
  ### Variables Variables Variables
27
- $base_name = plugin_basename('dbmanager/database-manager.php');
28
  $base_page = 'admin.php?page='.$base_name;
29
  $backup = array();
30
  $backup_options = get_option('dbmanager_options');
@@ -38,7 +38,7 @@ $backup['path'] = $backup_options['path'];
38
  if($_POST['do']) {
39
  // Lets Prepare The Variables
40
  $database_file = trim($_POST['database_file']);
41
- $nice_file_date = gmdate(sprintf(__('%s @ %s', 'wp-dbmanager'), get_option('date_format'), get_option('time_format')), substr($database_file, 0, 10));
42
 
43
  // Decide What To Do
44
  switch($_POST['do']) {
@@ -138,24 +138,26 @@ if($_POST['do']) {
138
  ?>
139
  <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?>
140
  <!-- Manage Backup Database -->
141
- <div class="wrap">
142
- <h2><?php _e('Manage Backup Database', 'wp-dbmanager'); ?></h2>
143
- <p><?php _e('Choose A Backup Date To E-Mail, Restore, Download Or Delete', 'wp-dbmanager'); ?></p>
144
- <form action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="post">
145
- <table width="100%" cellspacing="3" cellpadding="3" border="0">
146
- <tr class="thead">
147
- <th align="left"><?php _e('No.', 'wp-dbmanager'); ?></th>
148
- <th align="left"><?php _e('Database File', 'wp-dbmanager'); ?></th>
149
- <th align="left"><?php _e('Date/Time', 'wp-dbmanager'); ?></th>
150
- <th align="left"><?php _e('Size', 'wp-dbmanager'); ?></th>
151
- <th align="left"><?php _e('Select', 'wp-dbmanager'); ?></th>
152
- </tr>
 
 
153
  <?php
154
  if(!is_emtpy_folder($backup['path'])) {
155
  if ($handle = opendir($backup['path'])) {
156
  $database_files = array();
157
  while (false !== ($file = readdir($handle))) {
158
- if ($file != '.' && $file != '..' && (file_ext($file) == 'sql' || file_ext($file) == 'gz')) {
159
  $database_files[] = $file;
160
  }
161
  }
@@ -163,15 +165,15 @@ if($_POST['do']) {
163
  sort($database_files);
164
  for($i = (sizeof($database_files)-1); $i > -1; $i--) {
165
  if($no%2 == 0) {
166
- $style = 'style=\'background: none\'';
167
  } else {
168
- $style = 'style=\'background-color: #eee\'';
169
  }
170
  $no++;
171
  $database_text = substr($database_files[$i], 13);
172
- $date_text = gmdate(sprintf(__('%s @ %s', 'wp-dbmanager'), get_option('date_format'), get_option('time_format')), substr($database_files[$i], 0, 10));
173
  $size_text = filesize($backup['path'].'/'.$database_files[$i]);
174
- echo "<tr $style>\n<td>$no</td>";
175
  echo "<td>$database_text</td>";
176
  echo "<td>$date_text</td>";
177
  echo '<td>'.format_size($size_text).'</td>';
@@ -186,12 +188,14 @@ if($_POST['do']) {
186
  }
187
  ?>
188
  <tr class="thead">
189
- <th align="left" colspan="3"><?php echo $no; ?> <?php _e('Backup File(s)', 'wp-dbmanager'); ?></th>
190
- <th align="left"><?php echo format_size($totalsize); ?></th>
191
- <td>&nbsp;</td>
192
  </tr>
 
 
193
  <tr>
194
- <td colspan="5"><?php _e('E-mail database backup file to:', 'wp-dbmanager'); ?> <input type="text" name="email_to" size="30" maxlength="50" value="<?php echo get_option('admin_email'); ?>" />&nbsp;&nbsp;<input type="submit" name="do" value="<?php _e('E-Mail', 'wp-dbmanager'); ?>" class="button" /></td>
195
  </tr>
196
  <tr>
197
  <td colspan="5" align="center">
@@ -201,5 +205,5 @@ if($_POST['do']) {
201
  <input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td>
202
  </tr>
203
  </table>
204
- </form>
205
- </div>
2
  /*
3
  +----------------------------------------------------------------+
4
  | |
5
+ | WordPress 2.5 Plugin: WP-DBManager 2.30 |
6
+ | Copyright (c) 2008 Lester "GaMerZ" Chan |
7
  | |
8
  | File Written By: |
9
  | - Lester "GaMerZ" Chan |
11
  | |
12
  | File Information: |
13
  | - Database Restore |
14
+ | - wp-content/plugins/wp-dbmanager/database-restore.php |
15
  | |
16
  +----------------------------------------------------------------+
17
  */
24
 
25
 
26
  ### Variables Variables Variables
27
+ $base_name = plugin_basename('wp-dbmanager/database-manager.php');
28
  $base_page = 'admin.php?page='.$base_name;
29
  $backup = array();
30
  $backup_options = get_option('dbmanager_options');
38
  if($_POST['do']) {
39
  // Lets Prepare The Variables
40
  $database_file = trim($_POST['database_file']);
41
+ $nice_file_date = mysql2date(sprintf(__('%s @ %s', 'wp-dbmanager'), get_option('date_format'), get_option('time_format')), gmdate('Y-m-d H:i:s', substr($database_file, 0, 10)));
42
 
43
  // Decide What To Do
44
  switch($_POST['do']) {
138
  ?>
139
  <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?>
140
  <!-- Manage Backup Database -->
141
+ <form action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="post">
142
+ <div class="wrap">
143
+ <h2><?php _e('Manage Backup Database', 'wp-dbmanager'); ?></h2>
144
+ <p><?php _e('Choose A Backup Date To E-Mail, Restore, Download Or Delete', 'wp-dbmanager'); ?></p>
145
+ <table class="widefat">
146
+ <thead>
147
+ <tr>
148
+ <th><?php _e('No.', 'wp-dbmanager'); ?></th>
149
+ <th><?php _e('Database File', 'wp-dbmanager'); ?></th>
150
+ <th><?php _e('Date/Time', 'wp-dbmanager'); ?></th>
151
+ <th><?php _e('Size', 'wp-dbmanager'); ?></th>
152
+ <th><?php _e('Select', 'wp-dbmanager'); ?></th>
153
+ </tr>
154
+ </thead>
155
  <?php
156
  if(!is_emtpy_folder($backup['path'])) {
157
  if ($handle = opendir($backup['path'])) {
158
  $database_files = array();
159
  while (false !== ($file = readdir($handle))) {
160
+ if ($file != '.' && $file != '..' && $file != '.htaccess' && (file_ext($file) == 'sql' || file_ext($file) == 'gz')) {
161
  $database_files[] = $file;
162
  }
163
  }
165
  sort($database_files);
166
  for($i = (sizeof($database_files)-1); $i > -1; $i--) {
167
  if($no%2 == 0) {
168
+ $style = '';
169
  } else {
170
+ $style = ' class="alternate"';
171
  }
172
  $no++;
173
  $database_text = substr($database_files[$i], 13);
174
+ $date_text = mysql2date(sprintf(__('%s @ %s', 'wp-dbmanager'), get_option('date_format'), get_option('time_format')), gmdate('Y-m-d H:i:s', substr($database_files[$i], 0, 10)));
175
  $size_text = filesize($backup['path'].'/'.$database_files[$i]);
176
+ echo "<tr$style>\n<td>$no</td>";
177
  echo "<td>$database_text</td>";
178
  echo "<td>$date_text</td>";
179
  echo '<td>'.format_size($size_text).'</td>';
188
  }
189
  ?>
190
  <tr class="thead">
191
+ <th colspan="3"><?php echo $no; ?> <?php _e('Backup File(s)', 'wp-dbmanager'); ?></th>
192
+ <th><?php echo format_size($totalsize); ?></th>
193
+ <th>&nbsp;</th>
194
  </tr>
195
+ </table>
196
+ <table class="form-table">
197
  <tr>
198
+ <td colspan="5" align="center"><label for="email_to"><?php _e('E-mail database backup file to:', 'wp-dbmanager'); ?></label> <input type="text" id="email_to" name="email_to" size="30" maxlength="50" value="<?php echo get_option('admin_email'); ?>" />&nbsp;&nbsp;<input type="submit" name="do" value="<?php _e('E-Mail', 'wp-dbmanager'); ?>" class="button" /></td>
199
  </tr>
200
  <tr>
201
  <td colspan="5" align="center">
205
  <input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td>
206
  </tr>
207
  </table>
208
+ </div>
209
+ </form>
dbmanager/database-manager.php → database-manager.php RENAMED
@@ -2,8 +2,8 @@
2
  /*
3
  +----------------------------------------------------------------+
4
  | |
5
- | WordPress 2.1 Plugin: WP-DBManager 2.20 |
6
- | Copyright (c) 2007 Lester "GaMerZ" Chan |
7
  | |
8
  | File Written By: |
9
  | - Lester "GaMerZ" Chan |
@@ -11,7 +11,7 @@
11
  | |
12
  | File Information: |
13
  | - Database Manager |
14
- | - wp-content/plugins/dbmanager/database-manager.php |
15
  | |
16
  +----------------------------------------------------------------+
17
  */
@@ -24,7 +24,7 @@ if(!current_user_can('manage_database')) {
24
 
25
 
26
  ### Variables Variables Variables
27
- $base_name = plugin_basename('dbmanager/database-manager.php');
28
  $base_page = 'admin.php?page='.$base_name;
29
  $backup = array();
30
  $backup_options = get_option('dbmanager_options');
@@ -41,16 +41,19 @@ $sqlversion = $wpdb->get_var("SELECT VERSION() AS version");
41
  <!-- Database Information -->
42
  <div class="wrap">
43
  <h2><?php _e('Database Information', 'wp-dbmanager'); ?></h2>
44
- <table width="100%" cellspacing="3" cellpadding="3" border="0">
45
- <tr class="thead">
46
- <th align="left"><?php _e('Setting', 'wp-dbmanager'); ?></th>
47
- <th align="left"><?php _e('Value', 'wp-dbmanager'); ?></th>
48
- </tr>
 
 
 
49
  <tr>
50
  <td><?php _e('Database Host', 'wp-dbmanager'); ?></td>
51
  <td><?php echo DB_HOST; ?></td>
52
  </tr>
53
- <tr style="background-color: #eee;">
54
  <td><?php _e('Database Name', 'wp-dbmanager'); ?></td>
55
  <td><?php echo DB_NAME; ?></td>
56
  </tr>
@@ -58,7 +61,7 @@ $sqlversion = $wpdb->get_var("SELECT VERSION() AS version");
58
  <td><?php _e('Database User', 'wp-dbmanager'); ?></td>
59
  <td><?php echo DB_USER; ?></td>
60
  </tr>
61
- <tr style="background-color: #eee;">
62
  <td><?php _e('Database Type', 'wp-dbmanager'); ?></td>
63
  <td>MYSQL</td>
64
  </tr>
@@ -68,29 +71,34 @@ $sqlversion = $wpdb->get_var("SELECT VERSION() AS version");
68
  </tr>
69
  </table>
70
  </div>
 
 
71
  <div class="wrap">
72
  <h2><?php _e('Tables Information', 'wp-dbmanager'); ?></h2>
73
- <table width="100%" cellspacing="3" cellpadding="3" border="0">
74
- <tr class="thead">
75
- <th align="left"><?php _e('No.', 'wp-dbmanager'); ?></th>
76
- <th align="left"><?php _e('Tables', 'wp-dbmanager'); ?></th>
77
- <th align="left"><?php _e('Records', 'wp-dbmanager'); ?></th>
78
- <th align="left"><?php _e('Data Usage', 'wp-dbmanager'); ?></th>
79
- <th align="left"><?php _e('Index Usage', 'wp-dbmanager'); ?></th>
80
- <th align="left"><?php _e('Overhead', 'wp-dbmanager'); ?></th>
81
- </tr>
 
 
 
82
  <?php
83
  // If MYSQL Version More Than 3.23, Get More Info
84
  if($sqlversion >= '3.23') {
85
  $tablesstatus = $wpdb->get_results("SHOW TABLE STATUS");
86
  foreach($tablesstatus as $tablestatus) {
87
  if($no%2 == 0) {
88
- $style = 'style=\'background: none;\'';
89
  } else {
90
- $style = 'style=\'background-color: #eee;\'';
91
  }
92
  $no++;
93
- echo "<tr $style>\n";
94
  echo "<td>$no</td>\n";
95
  echo "<td>$tablestatus->Name</td>\n";
96
  echo '<td>'.number_format($tablestatus->Rows).'</td>'."\n";
@@ -104,12 +112,12 @@ if($sqlversion >= '3.23') {
104
  echo '</tr>'."\n";
105
  }
106
  echo '<tr class="thead">'."\n";
107
- echo '<th align="left">'.__('Total:', 'wp-dbmanager').'</th>'."\n";
108
- echo '<th align="left">'.$no.' '.__('Tables', 'wp-dbmanager').'</th>'."\n";
109
- echo '<th align="left">'.number_format($row_usage).'</th>'."\n";
110
- echo '<th align="left">'.format_size($data_usage).'</th>'."\n";
111
- echo '<th align="left">'.format_size($index_usage).'</th>'."\n";
112
- echo '<th align="left">'.format_size($overhead_usage).'</th>'."\n";
113
  echo '</tr>';
114
  } else {
115
  echo '<tr><td colspan="6" align="center"><strong>'.__('Could Not Show Table Status Due To Your MYSQL Version Is Lower Than 3.23.', 'wp-dbmanager').'</strong></td></tr>';
2
  /*
3
  +----------------------------------------------------------------+
4
  | |
5
+ | WordPress 2.5 Plugin: WP-DBManager 2.30 |
6
+ | Copyright (c) 2008 Lester "GaMerZ" Chan |
7
  | |
8
  | File Written By: |
9
  | - Lester "GaMerZ" Chan |
11
  | |
12
  | File Information: |
13
  | - Database Manager |
14
+ | - wp-content/plugins/wp-dbmanager/database-manager.php |
15
  | |
16
  +----------------------------------------------------------------+
17
  */
24
 
25
 
26
  ### Variables Variables Variables
27
+ $base_name = plugin_basename('wp-dbmanager/database-manager.php');
28
  $base_page = 'admin.php?page='.$base_name;
29
  $backup = array();
30
  $backup_options = get_option('dbmanager_options');
41
  <!-- Database Information -->
42
  <div class="wrap">
43
  <h2><?php _e('Database Information', 'wp-dbmanager'); ?></h2>
44
+ <br style="clear" />
45
+ <table class="widefat">
46
+ <thead>
47
+ <tr>
48
+ <th><?php _e('Setting', 'wp-dbmanager'); ?></th>
49
+ <th><?php _e('Value', 'wp-dbmanager'); ?></th>
50
+ </tr>
51
+ </thead>
52
  <tr>
53
  <td><?php _e('Database Host', 'wp-dbmanager'); ?></td>
54
  <td><?php echo DB_HOST; ?></td>
55
  </tr>
56
+ <tr class="alternate">
57
  <td><?php _e('Database Name', 'wp-dbmanager'); ?></td>
58
  <td><?php echo DB_NAME; ?></td>
59
  </tr>
61
  <td><?php _e('Database User', 'wp-dbmanager'); ?></td>
62
  <td><?php echo DB_USER; ?></td>
63
  </tr>
64
+ <tr class="alternate">
65
  <td><?php _e('Database Type', 'wp-dbmanager'); ?></td>
66
  <td>MYSQL</td>
67
  </tr>
71
  </tr>
72
  </table>
73
  </div>
74
+ <p>&nbsp;</p>
75
+
76
  <div class="wrap">
77
  <h2><?php _e('Tables Information', 'wp-dbmanager'); ?></h2>
78
+ <br style="clear" />
79
+ <table class="widefat">
80
+ <thead>
81
+ <tr>
82
+ <th><?php _e('No.', 'wp-dbmanager'); ?></th>
83
+ <th><?php _e('Tables', 'wp-dbmanager'); ?></th>
84
+ <th><?php _e('Records', 'wp-dbmanager'); ?></th>
85
+ <th><?php _e('Data Usage', 'wp-dbmanager'); ?></th>
86
+ <th><?php _e('Index Usage', 'wp-dbmanager'); ?></th>
87
+ <th><?php _e('Overhead', 'wp-dbmanager'); ?></th>
88
+ </tr>
89
+ </thead>
90
  <?php
91
  // If MYSQL Version More Than 3.23, Get More Info
92
  if($sqlversion >= '3.23') {
93
  $tablesstatus = $wpdb->get_results("SHOW TABLE STATUS");
94
  foreach($tablesstatus as $tablestatus) {
95
  if($no%2 == 0) {
96
+ $style = '';
97
  } else {
98
+ $style = ' class="alternate"';
99
  }
100
  $no++;
101
+ echo "<tr$style>\n";
102
  echo "<td>$no</td>\n";
103
  echo "<td>$tablestatus->Name</td>\n";
104
  echo '<td>'.number_format($tablestatus->Rows).'</td>'."\n";
112
  echo '</tr>'."\n";
113
  }
114
  echo '<tr class="thead">'."\n";
115
+ echo '<th>'.__('Total:', 'wp-dbmanager').'</th>'."\n";
116
+ echo '<th>'.$no.' '.__('Tables', 'wp-dbmanager').'</th>'."\n";
117
+ echo '<th>'.number_format($row_usage).'</th>'."\n";
118
+ echo '<th>'.format_size($data_usage).'</th>'."\n";
119
+ echo '<th>'.format_size($index_usage).'</th>'."\n";
120
+ echo '<th>'.format_size($overhead_usage).'</th>'."\n";
121
  echo '</tr>';
122
  } else {
123
  echo '<tr><td colspan="6" align="center"><strong>'.__('Could Not Show Table Status Due To Your MYSQL Version Is Lower Than 3.23.', 'wp-dbmanager').'</strong></td></tr>';
dbmanager/database-optimize.php → database-optimize.php RENAMED
@@ -2,8 +2,8 @@
2
  /*
3
  +----------------------------------------------------------------+
4
  | |
5
- | WordPress 2.1 Plugin: WP-DBManager 2.20 |
6
- | Copyright (c) 2007 Lester "GaMerZ" Chan |
7
  | |
8
  | File Written By: |
9
  | - Lester "GaMerZ" Chan |
@@ -11,7 +11,7 @@
11
  | |
12
  | File Information: |
13
  | - Database Optimize |
14
- | - wp-content/plugins/dbmanager/database-optimize.php |
15
  | |
16
  +----------------------------------------------------------------+
17
  */
@@ -24,7 +24,7 @@ if(!current_user_can('manage_database')) {
24
 
25
 
26
  ### Variables Variables Variables
27
- $base_name = plugin_basename('dbmanager/database-manager.php');
28
  $base_page = 'admin.php?page='.$base_name;
29
 
30
  ### Form Processing
@@ -63,24 +63,27 @@ $tables = $wpdb->get_col("SHOW TABLES");
63
  ?>
64
  <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?>
65
  <!-- Optimize Database -->
66
- <div class="wrap">
67
- <h2><?php _e('Optimize Database', 'wp-dbmanager'); ?></h2>
68
- <form action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="post">
69
- <table width="100%" cellspacing="3" cellpadding="3" border="0">
70
- <tr class="thead">
71
- <th align="left"><?php _e('Tables', 'wp-dbmanager'); ?></th>
72
- <th align="left"><?php _e('Options', 'wp-dbmanager'); ?></th>
73
- </tr>
 
 
 
74
  <?php
75
  foreach($tables as $table_name) {
76
  if($no%2 == 0) {
77
- $style = 'style=\'background: none\'';
78
  } else {
79
- $style = 'style=\'background-color: #eee;\'';
80
  }
81
  $no++;
82
- echo "<tr $style><th align=\"left\" scope=\"row\">$table_name</th>\n";
83
- echo "<td><input type=\"radio\" name=\"optimize[$table_name]\" value=\"no\" />".__('No', 'wp-dbmanager')."&nbsp;&nbsp;&nbsp;<input type=\"radio\" name=\"optimize[$table_name]\" value=\"yes\" checked=\"checked\" />".__('Yes', 'wp-dbmanager').'</td></tr>';
84
  }
85
  ?>
86
  <tr>
@@ -90,5 +93,5 @@ $tables = $wpdb->get_col("SHOW TABLES");
90
  <td colspan="2" align="center"><input type="submit" name="do" value="<?php _e('Optimize', 'wp-dbmanager'); ?>" class="button" />&nbsp;&nbsp;<input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td>
91
  </tr>
92
  </table>
93
- </form>
94
- </div>
2
  /*
3
  +----------------------------------------------------------------+
4
  | |
5
+ | WordPress 2.5 Plugin: WP-DBManager 2.30 |
6
+ | Copyright (c) 2008 Lester "GaMerZ" Chan |
7
  | |
8
  | File Written By: |
9
  | - Lester "GaMerZ" Chan |
11
  | |
12
  | File Information: |
13
  | - Database Optimize |
14
+ | - wp-content/plugins/wp-dbmanager/database-optimize.php |
15
  | |
16
  +----------------------------------------------------------------+
17
  */
24
 
25
 
26
  ### Variables Variables Variables
27
+ $base_name = plugin_basename('wp-dbmanager/database-manager.php');
28
  $base_page = 'admin.php?page='.$base_name;
29
 
30
  ### Form Processing
63
  ?>
64
  <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?>
65
  <!-- Optimize Database -->
66
+ <form action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="post">
67
+ <div class="wrap">
68
+ <h2><?php _e('Optimize Database', 'wp-dbmanager'); ?></h2>
69
+ <br style="clear" />
70
+ <table class="widefat">
71
+ <thead>
72
+ <tr>
73
+ <th><?php _e('Tables', 'wp-dbmanager'); ?></th>
74
+ <th><?php _e('Options', 'wp-dbmanager'); ?></th>
75
+ </tr>
76
+ </thead>
77
  <?php
78
  foreach($tables as $table_name) {
79
  if($no%2 == 0) {
80
+ $style = '';
81
  } else {
82
+ $style = ' class="alternate"';
83
  }
84
  $no++;
85
+ echo "<tr$style><th align=\"left\" scope=\"row\">$table_name</th>\n";
86
+ echo "<td><input type=\"radio\" id=\"$table_name-no\" name=\"optimize[$table_name]\" value=\"no\" />&nbsp;<label for=\"$table_name-no\">".__('No', 'wp-dbmanager')."</label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type=\"radio\" id=\"$table_name-yes\" name=\"optimize[$table_name]\" value=\"yes\" checked=\"checked\" />&nbsp;<label for=\"$table_name-yes\">".__('Yes', 'wp-dbmanager').'</label></td></tr>';
87
  }
88
  ?>
89
  <tr>
93
  <td colspan="2" align="center"><input type="submit" name="do" value="<?php _e('Optimize', 'wp-dbmanager'); ?>" class="button" />&nbsp;&nbsp;<input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td>
94
  </tr>
95
  </table>
96
+ </div>
97
+ </form>
dbmanager/database-repair.php → database-repair.php RENAMED
@@ -2,8 +2,8 @@
2
  /*
3
  +----------------------------------------------------------------+
4
  | |
5
- | WordPress 2.1 Plugin: WP-DBManager 2.20 |
6
- | Copyright (c) 2007 Lester "GaMerZ" Chan |
7
  | |
8
  | File Written By: |
9
  | - Lester "GaMerZ" Chan |
@@ -11,7 +11,7 @@
11
  | |
12
  | File Information: |
13
  | - Database Repair |
14
- | - wp-content/plugins/dbmanager/database-repair.php |
15
  | |
16
  +----------------------------------------------------------------+
17
  */
@@ -24,7 +24,7 @@ if(!current_user_can('manage_database')) {
24
 
25
 
26
  ### Variables Variables Variables
27
- $base_name = plugin_basename('dbmanager/database-manager.php');
28
  $base_page = 'admin.php?page='.$base_name;
29
 
30
  ### Form Processing
@@ -59,29 +59,32 @@ $tables = $wpdb->get_col("SHOW TABLES");
59
  ?>
60
  <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?>
61
  <!-- Repair Database -->
62
- <div class="wrap">
63
- <h2><?php _e('Repair Database', 'wp-dbmanager'); ?></h2>
64
- <form action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="post">
65
- <table width="100%" cellspacing="3" cellpadding="3" border="0">
66
- <tr class="thead">
67
- <th align="left"><?php _e('Tables', 'wp-dbmanager'); ?></th>
68
- <th align="left"><?php _e('Options', 'wp-dbmanager'); ?></th>
69
- </tr>
 
 
 
70
  <?php
71
  foreach($tables as $table_name) {
72
  if($no%2 == 0) {
73
- $style = 'style=\'background: none\'';
74
  } else {
75
- $style = 'style=\'background-color: #eee;\'';
76
  }
77
  $no++;
78
  echo "<tr $style><th align=\"left\" scope=\"row\">$table_name</th>\n";
79
- echo "<td><input type=\"radio\" name=\"repair[$table_name]\" value=\"no\" />".__('No', 'wp-dbmanager')."&nbsp;&nbsp;&nbsp;<input type=\"radio\" name=\"repair[$table_name]\" value=\"yes\" checked=\"checked\" />".__('Yes', 'wp-dbmanager').'</td></tr>';
80
  }
81
  ?>
82
  <tr>
83
  <td colspan="2" align="center"><input type="submit" name="do" value="<?php _e('Repair', 'wp-dbmanager'); ?>" class="button" />&nbsp;&nbsp;<input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td>
84
  </tr>
85
  </table>
86
- </form>
87
- </div>
2
  /*
3
  +----------------------------------------------------------------+
4
  | |
5
+ | WordPress 2.5 Plugin: WP-DBManager 2.30 |
6
+ | Copyright (c) 2008 Lester "GaMerZ" Chan |
7
  | |
8
  | File Written By: |
9
  | - Lester "GaMerZ" Chan |
11
  | |
12
  | File Information: |
13
  | - Database Repair |
14
+ | - wp-content/plugins/wp-dbmanager/database-repair.php |
15
  | |
16
  +----------------------------------------------------------------+
17
  */
24
 
25
 
26
  ### Variables Variables Variables
27
+ $base_name = plugin_basename('wp-dbmanager/database-manager.php');
28
  $base_page = 'admin.php?page='.$base_name;
29
 
30
  ### Form Processing
59
  ?>
60
  <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?>
61
  <!-- Repair Database -->
62
+ <form action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="post">
63
+ <div class="wrap">
64
+ <h2><?php _e('Repair Database', 'wp-dbmanager'); ?></h2>
65
+ <br style="clear" />
66
+ <table class="widefat">
67
+ <thead>
68
+ <tr>
69
+ <th><?php _e('Tables', 'wp-dbmanager'); ?></th>
70
+ <th><?php _e('Options', 'wp-dbmanager'); ?></th>
71
+ </tr>
72
+ </thead>
73
  <?php
74
  foreach($tables as $table_name) {
75
  if($no%2 == 0) {
76
+ $style = '';
77
  } else {
78
+ $style = ' class="alternate"';
79
  }
80
  $no++;
81
  echo "<tr $style><th align=\"left\" scope=\"row\">$table_name</th>\n";
82
+ echo "<td><input type=\"radio\" id=\"$table_name-no\" name=\"repair[$table_name]\" value=\"no\" />&nbsp;<label for=\"$table_name-no\">".__('No', 'wp-dbmanager')."</label>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type=\"radio\" id=\"$table_name-yes\" name=\"repair[$table_name]\" value=\"yes\" checked=\"checked\" />&nbsp;<label for=\"$table_name-yes\">".__('Yes', 'wp-dbmanager').'</label></td></tr>';
83
  }
84
  ?>
85
  <tr>
86
  <td colspan="2" align="center"><input type="submit" name="do" value="<?php _e('Repair', 'wp-dbmanager'); ?>" class="button" />&nbsp;&nbsp;<input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td>
87
  </tr>
88
  </table>
89
+ </div>
90
+ </form>
dbmanager/database-run.php → database-run.php RENAMED
@@ -2,8 +2,8 @@
2
  /*
3
  +----------------------------------------------------------------+
4
  | |
5
- | WordPress 2.1 Plugin: WP-DBManager 2.20 |
6
- | Copyright (c) 2007 Lester "GaMerZ" Chan |
7
  | |
8
  | File Written By: |
9
  | - Lester "GaMerZ" Chan |
@@ -11,7 +11,7 @@
11
  | |
12
  | File Information: |
13
  | - Database Run Query |
14
- | - wp-content/plugins/dbmanager/database-run.php |
15
  | |
16
  +----------------------------------------------------------------+
17
  */
@@ -24,7 +24,7 @@ if(!current_user_can('manage_database')) {
24
 
25
 
26
  ### Variables Variables Variables
27
- $base_name = plugin_basename('dbmanager/database-manager.php');
28
  $base_page = 'admin.php?page='.$base_name;
29
  $backup = array();
30
  $backup_options = get_option('dbmanager_options');
@@ -81,18 +81,26 @@ if($_POST['do']) {
81
  ?>
82
  <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?>
83
  <!-- Run SQL Query -->
84
- <div class="wrap">
85
- <h2><?php _e('Run SQL Query', 'wp-dbmanager'); ?></h2>
86
- <form action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="post">
87
- <p>
 
88
  <strong><?php _e('Seperate Multiple Queries With A New Line', 'wp-dbmanager'); ?></strong><br />
89
  <font color="green"><?php _e('Use Only INSERT, UPDATE, REPLACE, DELETE, CREATE and ALTER statements.', 'wp-dbmanager'); ?></font>
90
- </p>
91
- <p align="center"><textarea cols="120" rows="30" name="sql_query"></textarea></p>
92
- <p align="center"><input type="submit" name="do" value="<?php _e('Run', 'wp-dbmanager'); ?>" class="button" />&nbsp;&nbsp;<input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></p>
 
 
 
 
 
 
93
  <p>
94
  <?php _e('1. CREATE statement will return an error, which is perfectly normal due to the database class. To confirm that your table has been created check the Manage Database page.', 'wp-dbmanager'); ?><br />
95
  <?php _e('2. UPDATE statement may return an error sometimes due to the newly updated value being the same as the previous value.', 'wp-dbmanager'); ?><br />
96
- <?php _e('3. ALTER statement will return an error because there is no value returned.', 'wp-dbmanager'); ?></p>
97
- </form>
98
- </div>
 
2
  /*
3
  +----------------------------------------------------------------+
4
  | |
5
+ | WordPress 2.5 Plugin: WP-DBManager 2.30 |
6
+ | Copyright (c) 2008 Lester "GaMerZ" Chan |
7
  | |
8
  | File Written By: |
9
  | - Lester "GaMerZ" Chan |
11
  | |
12
  | File Information: |
13
  | - Database Run Query |
14
+ | - wp-content/plugins/wp-dbmanager/database-run.php |
15
  | |
16
  +----------------------------------------------------------------+
17
  */
24
 
25
 
26
  ### Variables Variables Variables
27
+ $base_name = plugin_basename('wp-dbmanager/database-manager.php');
28
  $base_page = 'admin.php?page='.$base_name;
29
  $backup = array();
30
  $backup_options = get_option('dbmanager_options');
81
  ?>
82
  <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?>
83
  <!-- Run SQL Query -->
84
+ <form action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="post">
85
+ <div class="wrap">
86
+ <h2><?php _e('Run SQL Query', 'wp-dbmanager'); ?></h2>
87
+ <br style="clear" />
88
+ <div>
89
  <strong><?php _e('Seperate Multiple Queries With A New Line', 'wp-dbmanager'); ?></strong><br />
90
  <font color="green"><?php _e('Use Only INSERT, UPDATE, REPLACE, DELETE, CREATE and ALTER statements.', 'wp-dbmanager'); ?></font>
91
+ </div>
92
+ <table class="form-table">
93
+ <tr>
94
+ <td align="center"><textarea cols="120" rows="30" name="sql_query" style="width: 99%;"></textarea></td>
95
+ </tr>
96
+ <tr>
97
+ <td align="center"><input type="submit" name="do" value="<?php _e('Run', 'wp-dbmanager'); ?>" class="button" />&nbsp;&nbsp;<input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td>
98
+ </tr>
99
+ </table>
100
  <p>
101
  <?php _e('1. CREATE statement will return an error, which is perfectly normal due to the database class. To confirm that your table has been created check the Manage Database page.', 'wp-dbmanager'); ?><br />
102
  <?php _e('2. UPDATE statement may return an error sometimes due to the newly updated value being the same as the previous value.', 'wp-dbmanager'); ?><br />
103
+ <?php _e('3. ALTER statement will return an error because there is no value returned.', 'wp-dbmanager'); ?>
104
+ </p>
105
+ </div>
106
+ </form>
dbmanager/database-uninstall.php → database-uninstall.php RENAMED
@@ -2,8 +2,8 @@
2
  /*
3
  +----------------------------------------------------------------+
4
  | |
5
- | WordPress 2.1 Plugin: WP-DBManager 2.20 |
6
- | Copyright (c) 2007 Lester "GaMerZ" Chan |
7
  | |
8
  | File Written By: |
9
  | - Lester "GaMerZ" Chan |
@@ -11,7 +11,7 @@
11
  | |
12
  | File Information: |
13
  | - Uninstall WP-DBManager |
14
- | - wp-content/plugins/dbmanager/dbmanager-uninstall.php |
15
  | |
16
  +----------------------------------------------------------------+
17
  */
@@ -24,7 +24,7 @@ if(!current_user_can('manage_database')) {
24
 
25
 
26
  ### Variables Variables Variables
27
- $base_name = plugin_basename('dbmanager/database-manager.php');
28
  $base_page = 'admin.php?page='.$base_name;
29
  $mode = trim($_GET['mode']);
30
  $db_settings = array('dbmanager_options');
@@ -70,9 +70,9 @@ if(!empty($_POST['do'])) {
70
  switch($mode) {
71
  // Deactivating WP-DBManager
72
  case 'end-UNINSTALL':
73
- $deactivate_url = 'plugins.php?action=deactivate&amp;plugin=dbmanager/dbmanager.php';
74
  if(function_exists('wp_nonce_url')) {
75
- $deactivate_url = wp_nonce_url($deactivate_url, 'deactivate-plugin_dbmanager/dbmanager.php');
76
  }
77
  echo '<div class="wrap">';
78
  echo '<h2>'.__('Uninstall WP-DBManager', 'wp-dbmanager').'</h2>';
@@ -84,45 +84,47 @@ switch($mode) {
84
  ?>
85
  <!-- Uninstall WP-DBManager -->
86
  <form action="<?php echo htmlspecialchars($_SERVER['REQUEST_URI']); ?>" method="post">
87
- <div class="wrap">
88
- <h2><?php _e('Uninstall WP-DBManager', 'wp-dbmanager'); ?></h2>
89
- <p style="text-align: left;">
90
- <?php _e('Deactivating WP-DBManager plugin does not remove any data that may have been created, such as the database options. To completely remove this plugin, you can uninstall it here.', 'wp-dbmanager'); ?>
91
- </p>
92
- <p style="text-align: left; color: red">
93
- <strong><?php _e('WARNING:', 'wp-dbmanager'); ?></strong><br />
94
- <?php _e('Once uninstalled, this cannot be undone. You should use a Database Backup plugin of WordPress to back up all the data first.', 'wp-dbmanager'); ?>
95
- </p>
96
- <p style="text-align: left; color: red">
97
- <strong><?php _e('NOTE:', 'wp-dbmanager'); ?></strong><br />
98
- <?php _e('The database backup files generated by WP-DBManager <strong>WILL NOT</strong> be deleted. You will have to delete it manually.', 'wp-dbmanager'); ?><br />
99
- <?php printf(__('The path to the backup folder is <strong>\'%s\'</strong>.', 'wp-dbmanager'), $backup_options_path); ?>
100
- </p>
101
- <p style="text-align: left; color: red">
102
- <strong><?php _e('The following WordPress Options will be DELETED:', 'wp-dbmanager'); ?></strong><br />
103
- </p>
104
- <table width="50%" border="0" cellspacing="3" cellpadding="3">
105
- <tr class="thead">
106
- <td align="center"><strong><?php _e('WordPress Options', 'wp-dbmanager'); ?></strong></td>
107
- </tr>
108
- <tr>
109
- <td valign="top" style="background-color: #eee;">
110
- <ol>
111
- <?php
112
- foreach($db_settings as $settings) {
113
- echo '<li>'.$settings.'</li>'."\n";
114
- }
115
- ?>
116
- </ol>
117
- </td>
118
- </tr>
119
- </table>
120
- <p>&nbsp;</p>
121
- <p style="text-align: center;">
122
- <input type="checkbox" name="uninstall_db_yes" value="yes" />&nbsp;<?php _e('Yes', 'wp-dbmanager'); ?><br /><br />
123
- <input type="submit" name="do" value="<?php _e('UNINSTALL WP-DBManager', 'wp-dbmanager'); ?>" class="button" onclick="return confirm('<?php _e('You Are About To Uninstall WP-DBManager From WordPress.\nThis Action Is Not Reversible.\n\n Choose [Cancel] To Stop, [OK] To Uninstall.', 'wp-dbmanager'); ?>')" />
124
- </p>
125
- </div>
 
 
126
  </form>
127
  <?php
128
  } // End switch($mode)
2
  /*
3
  +----------------------------------------------------------------+
4
  | |
5
+ | WordPress 2.5 Plugin: WP-DBManager 2.30 |
6
+ | Copyright (c) 2008 Lester "GaMerZ" Chan |
7
  | |
8
  | File Written By: |
9
  | - Lester "GaMerZ" Chan |
11
  | |
12
  | File Information: |
13
  | - Uninstall WP-DBManager |
14
+ | - wp-content/plugins/wp-dbmanager/dbmanager-uninstall.php |
15
  | |
16
  +----------------------------------------------------------------+
17
  */
24
 
25
 
26
  ### Variables Variables Variables
27
+ $base_name = plugin_basename('wp-dbmanager/database-manager.php');
28
  $base_page = 'admin.php?page='.$base_name;
29
  $mode = trim($_GET['mode']);
30
  $db_settings = array('dbmanager_options');
70
  switch($mode) {
71
  // Deactivating WP-DBManager
72
  case 'end-UNINSTALL':
73
+ $deactivate_url = 'plugins.php?action=deactivate&amp;plugin=wp-dbmanager/wp-dbmanager.php';
74
  if(function_exists('wp_nonce_url')) {
75
+ $deactivate_url = wp_nonce_url($deactivate_url, 'deactivate-plugin_wp-dbmanager/wp-dbmanager.php');
76
  }
77
  echo '<div class="wrap">';
78
  echo '<h2>'.__('Uninstall WP-DBManager', 'wp-dbmanager').'</h2>';
84
  ?>
85
  <!-- Uninstall WP-DBManager -->
86
  <form action="<?php echo htmlspecialchars($_SERVER['REQUEST_URI']); ?>" method="post">
87
+ <div class="wrap">
88
+ <h2><?php _e('Uninstall WP-DBManager', 'wp-dbmanager'); ?></h2>
89
+ <p style="text-align: left;">
90
+ <?php _e('Deactivating WP-DBManager plugin does not remove any data that may have been created, such as the database options. To completely remove this plugin, you can uninstall it here.', 'wp-dbmanager'); ?>
91
+ </p>
92
+ <p style="text-align: left; color: red">
93
+ <strong><?php _e('WARNING:', 'wp-dbmanager'); ?></strong><br />
94
+ <?php _e('Once uninstalled, this cannot be undone. You should use a Database Backup plugin of WordPress to back up all the data first.', 'wp-dbmanager'); ?>
95
+ </p>
96
+ <p style="text-align: left; color: red">
97
+ <strong><?php _e('NOTE:', 'wp-dbmanager'); ?></strong><br />
98
+ <?php _e('The database backup files generated by WP-DBManager <strong>WILL NOT</strong> be deleted. You will have to delete it manually.', 'wp-dbmanager'); ?><br />
99
+ <?php printf(__('The path to the backup folder is <strong>\'%s\'</strong>.', 'wp-dbmanager'), $backup_options_path); ?>
100
+ </p>
101
+ <p style="text-align: left; color: red">
102
+ <strong><?php _e('The following WordPress Options will be DELETED:', 'wp-dbmanager'); ?></strong><br />
103
+ </p>
104
+ <table class="widefat">
105
+ <thead>
106
+ <tr>
107
+ <th><?php _e('WordPress Options', 'wp-dbmanager'); ?></th>
108
+ </tr>
109
+ </thead>
110
+ <tr>
111
+ <td valign="top">
112
+ <ol>
113
+ <?php
114
+ foreach($db_settings as $settings) {
115
+ echo '<li>'.$settings.'</li>'."\n";
116
+ }
117
+ ?>
118
+ </ol>
119
+ </td>
120
+ </tr>
121
+ </table>
122
+ <p>&nbsp;</p>
123
+ <p style="text-align: center;">
124
+ <input type="checkbox" name="uninstall_db_yes" value="yes" />&nbsp;<?php _e('Yes', 'wp-dbmanager'); ?><br /><br />
125
+ <input type="submit" name="do" value="<?php _e('UNINSTALL WP-DBManager', 'wp-dbmanager'); ?>" class="button" onclick="return confirm('<?php _e('You Are About To Uninstall WP-DBManager From WordPress.\nThis Action Is Not Reversible.\n\n Choose [Cancel] To Stop, [OK] To Uninstall.', 'wp-dbmanager'); ?>')" />
126
+ </p>
127
+ </div>
128
  </form>
129
  <?php
130
  } // End switch($mode)
dbmanager/wp-dbmanager.mo DELETED
Binary file
readme.html CHANGED
@@ -2,7 +2,7 @@
2
  <html>
3
  <head>
4
  <meta http-equiv="content-type" content="text/html; charset=utf-8" />
5
- <title>WP-DBManager 2.20 Readme</title>
6
  <style type="text/css" media="screen">
7
  /* Default Style */
8
  BODY {
@@ -203,7 +203,7 @@
203
  <body>
204
  <div id="Container">
205
  <!-- Title -->
206
- <div id="Title">WP-DBManager 2.20&nbsp;&nbsp;&nbsp;<span style="color: #aaaaaa;">Readme</span></div>
207
 
208
  <!-- Tabs -->
209
  <ul id="Tabs">
@@ -224,15 +224,6 @@
224
  <strong>Author:</strong><br />
225
  <strong>&raquo;</strong> Lester 'GaMerZ' Chan
226
  </p>
227
- <p>
228
- <strong>EMail:</strong><br />
229
- <strong>&raquo;</strong>
230
- <script type="text/javascript">
231
- /* <![CDATA[*/
232
- document.write(' <a href="mailto:gamerz84@hotmail.com?Subject=WP-DBManager%202.20%20Support" title="EMail To gamerz84@hotmail.com">gamerz84@hotmail.com</a>');
233
- /* ]]> */
234
- </script>
235
- </p>
236
  <p>
237
  <strong>Website:</strong><br />
238
  <strong>&raquo;</strong> <a href="http://lesterchan.net/" title="http://lesterchan.net/">http://lesterchan.net/</a>
@@ -243,9 +234,9 @@
243
  </p>
244
  <p>
245
  <strong>Download:</strong><br />
246
- <strong>&raquo;</strong> <a href="http://lesterchan.net/others/downloads.php?id=15" title="http://lesterchan.net/others/downloads.php?id=15">WP-DBManager 2.20 For WordPress 2.1.x And Above</a><br />
247
- <strong>&raquo;</strong> <a href="http://lesterchan.net/others/downloads/wp-dbmanager205.zip" title="http://lesterchan.net/others/downloads/wp-dbmanager205.zip">WP-DBManager 2.05 For WordPress 2.0.x</a><br />
248
- <strong>&raquo;</strong> <a href="http://lesterchan.net/others/downloads/wp-dbmanager.zip" title="http://lesterchan.net/others/downloads/wp-dbmanager.zip">WP-DBManager 1.00 For WordPress 1.5.2</a>
249
  </p>
250
  <p>
251
  <strong>Screenshots:</strong><br />
@@ -267,10 +258,6 @@
267
  <strong>Support Forums:</strong><br />
268
  <strong>&raquo;</strong> <a href="http://forums.lesterchan.net/index.php?board=11.0" title="http://forums.lesterchan.net/index.php?board=11.0">http://forums.lesterchan.net/index.php?board=11.0</a>
269
  </p>
270
- <p>
271
- <strong>Updated:</strong><br />
272
- <strong>&raquo;</strong> 1st October 2007
273
- </p>
274
  <p>
275
  <strong>Note:</strong><br />
276
  <strong>&raquo;</strong> The <strong>Changelog</strong>, <strong>Installation</strong>, <strong>Upgrade</strong>, <strong>Usage</strong> Tab at the top of the page.
@@ -280,7 +267,7 @@
280
  <strong>&raquo;</strong> I spent most of my free time creating, updating, maintaining and supporting these plugins, if you really love my plugins and could spare me a couple of bucks as my school allowance, I will really appericiate it. If not feel free to use it without any obligations. Thank You. My Paypal account is
281
  <script type="text/javascript">
282
  /* <![CDATA[*/
283
- document.write(' <strong>gamerz84@hotmail.com</strong>.');
284
  /* ]]> */
285
  </script>
286
  </p>
@@ -290,6 +277,15 @@
290
  <div id="Changelog" style="display: none;">
291
  <div class="SubTitle">&raquo; Changelog</div>
292
  <ul>
 
 
 
 
 
 
 
 
 
293
  <li>
294
  <strong>Version 2.20 (01-10-2007)</strong>
295
  <ul>
@@ -380,7 +376,7 @@
380
  </li>
381
  <li>
382
  Put:
383
- <blockquote>Folder: dbmanager</blockquote>
384
  </li>
385
  <li>
386
  <strong>Activate</strong> WP-DBManager Plugin
@@ -402,7 +398,7 @@
402
  <!-- Upgrade Instructions -->
403
  <div id="Upgrade" style="display: none;">
404
  <div class="SubTitle">&raquo; Upgrade Instructions</div>
405
- <div class="SubSubTitle">From v2.0x To v2.20</div>
406
  <ol>
407
  <li>
408
  <strong>Deactivate</strong> WP-DBManager Plugin
@@ -412,11 +408,13 @@
412
  </li>
413
  <li>
414
  Put/Overwrite:
415
- <blockquote>Folder: dbmanager</blockquote>
416
  </li>
417
  <li>
418
- Delete:
419
- <blockquote>File: wp-content/plugins/dbmanager/database-config.php</blockquote>
 
 
420
  </li>
421
  <li>
422
  <strong>Activate</strong> WP-DBManager Plugin
@@ -442,6 +440,6 @@
442
  </div>
443
  </div>
444
  </div>
445
- <p id="Copyright">WP-DBManager 2.20<br />Copyright &copy; 2007 Lester 'GaMerZ' Chan. All Rights Reserved.</p>
446
  </body>
447
  </html>
2
  <html>
3
  <head>
4
  <meta http-equiv="content-type" content="text/html; charset=utf-8" />
5
+ <title>WP-DBManager 2.30 Readme</title>
6
  <style type="text/css" media="screen">
7
  /* Default Style */
8
  BODY {
203
  <body>
204
  <div id="Container">
205
  <!-- Title -->
206
+ <div id="Title">WP-DBManager 2.30&nbsp;&nbsp;&nbsp;<span style="color: #aaaaaa;">Readme</span></div>
207
 
208
  <!-- Tabs -->
209
  <ul id="Tabs">
224
  <strong>Author:</strong><br />
225
  <strong>&raquo;</strong> Lester 'GaMerZ' Chan
226
  </p>
 
 
 
 
 
 
 
 
 
227
  <p>
228
  <strong>Website:</strong><br />
229
  <strong>&raquo;</strong> <a href="http://lesterchan.net/" title="http://lesterchan.net/">http://lesterchan.net/</a>
234
  </p>
235
  <p>
236
  <strong>Download:</strong><br />
237
+ <strong>&raquo;</strong> <a href="http://downloads.wordpress.org/plugin/wp-dbmanager.2.30.zip" title="http://downloads.wordpress.org/plugin/wp-dbmanager.2.30.zip">WP-DBManager 2.30 For WordPress 2.1.x And Above</a><br />
238
+ <strong>&raquo;</strong> <a href="http://downloads.wordpress.org/plugin/wp-dbmanager.2.05.zip" title="http://downloads.wordpress.org/plugin/wp-dbmanager.2.05.zip">WP-DBManager 2.05 For WordPress 2.0.x</a><br />
239
+ <strong>&raquo;</strong> <a href="http://downloads.wordpress.org/plugin/wp-dbmanager.1.00.zip" title="http://downloads.wordpress.org/plugin/wp-dbmanager.1.00.zip">WP-DBManager 1.00 For WordPress 1.5.2</a>
240
  </p>
241
  <p>
242
  <strong>Screenshots:</strong><br />
258
  <strong>Support Forums:</strong><br />
259
  <strong>&raquo;</strong> <a href="http://forums.lesterchan.net/index.php?board=11.0" title="http://forums.lesterchan.net/index.php?board=11.0">http://forums.lesterchan.net/index.php?board=11.0</a>
260
  </p>
 
 
 
 
261
  <p>
262
  <strong>Note:</strong><br />
263
  <strong>&raquo;</strong> The <strong>Changelog</strong>, <strong>Installation</strong>, <strong>Upgrade</strong>, <strong>Usage</strong> Tab at the top of the page.
267
  <strong>&raquo;</strong> I spent most of my free time creating, updating, maintaining and supporting these plugins, if you really love my plugins and could spare me a couple of bucks as my school allowance, I will really appericiate it. If not feel free to use it without any obligations. Thank You. My Paypal account is
268
  <script type="text/javascript">
269
  /* <![CDATA[*/
270
+ document.write(' <strong>lesterchan@gmail.com</strong>.');
271
  /* ]]> */
272
  </script>
273
  </p>
277
  <div id="Changelog" style="display: none;">
278
  <div class="SubTitle">&raquo; Changelog</div>
279
  <ul>
280
+ <li>
281
+ <strong>Version 2.30 (01-06-2008)</strong>
282
+ <ul>
283
+ <li>NEW: Uses /wp-dbmanager/ Folder Instead Of /dbmanager/</li>
284
+ <li>NEW: Uses wp-dbmanager.php Instead Of dbmanager.php</li>
285
+ <li>NEW: Added Minute(s) Option To Backup And Optimize Cron Jobs</li>
286
+ <li>NEW: Uses GiB, MiB, KiB Instead Of GB, MB, KB</li>
287
+ </ul>
288
+ </li>
289
  <li>
290
  <strong>Version 2.20 (01-10-2007)</strong>
291
  <ul>
376
  </li>
377
  <li>
378
  Put:
379
+ <blockquote>Folder: wp-dbmanager</blockquote>
380
  </li>
381
  <li>
382
  <strong>Activate</strong> WP-DBManager Plugin
398
  <!-- Upgrade Instructions -->
399
  <div id="Upgrade" style="display: none;">
400
  <div class="SubTitle">&raquo; Upgrade Instructions</div>
401
+ <div class="SubSubTitle">From v2.0x To v2.30</div>
402
  <ol>
403
  <li>
404
  <strong>Deactivate</strong> WP-DBManager Plugin
408
  </li>
409
  <li>
410
  Put/Overwrite:
411
+ <blockquote>Folder: wp-dbmanager</blockquote>
412
  </li>
413
  <li>
414
+ Delete this folder if exists:
415
+ <blockquote>
416
+ Folder: dbmanager
417
+ </blockquote>
418
  </li>
419
  <li>
420
  <strong>Activate</strong> WP-DBManager Plugin
440
  </div>
441
  </div>
442
  </div>
443
+ <p id="Copyright">WP-DBManager 2.30<br />Copyright &copy; 2008 Lester 'GaMerZ' Chan. All Rights Reserved.</p>
444
  </body>
445
  </html>
readme.txt CHANGED
@@ -2,10 +2,10 @@
2
  Contributors: GamerZ
3
  Donate link: http://lesterchan.net/wordpress
4
  Tags: database, manage, wp-dbmanager, manager, table, optimize, backup, queries, query, drop, empty, tables, table, run, repair, cron, schedule, scheduling, automatic
5
- Requires at least: 2.1.0
6
- Stable tag: 2.20
7
 
8
- Manages your Wordpress database.
9
 
10
  == Description ==
11
 
2
  Contributors: GamerZ
3
  Donate link: http://lesterchan.net/wordpress
4
  Tags: database, manage, wp-dbmanager, manager, table, optimize, backup, queries, query, drop, empty, tables, table, run, repair, cron, schedule, scheduling, automatic
5
+ Requires at least: 2.5.0
6
+ Stable tag: 2.30
7
 
8
+ Manages your WordPress database.
9
 
10
  == Description ==
11
 
wp-dbmanager.mo ADDED
Binary file
dbmanager/dbmanager.php → wp-dbmanager.php RENAMED
@@ -1,16 +1,16 @@
1
  <?php
2
  /*
3
  Plugin Name: WP-DBManager
4
- Plugin URI: http://lesterchan.net/portfolio/programming.php
5
  Description: Manages your Wordpress database. Allows you to optimize database, repair database, backup database, restore database, delete backup database , drop/empty tables and run selected queries. Supports automatic scheduling of backing up and optimizing of database.
6
- Version: 2.20
7
  Author: Lester 'GaMerZ' Chan
8
  Author URI: http://lesterchan.net
9
  */
10
 
11
 
12
  /*
13
- Copyright 2007 Lester Chan (email : gamerz84@hotmail.com)
14
 
15
  This program is free software; you can redistribute it and/or modify
16
  it under the terms of the GNU General Public License as published by
@@ -31,7 +31,7 @@ Author URI: http://lesterchan.net
31
  ### Create Text Domain For Translations
32
  add_action('init', 'dbmanager_textdomain');
33
  function dbmanager_textdomain() {
34
- load_plugin_textdomain('wp-dbmanager', 'wp-content/plugins/dbmanager');
35
  }
36
 
37
 
@@ -39,17 +39,17 @@ function dbmanager_textdomain() {
39
  add_action('admin_menu', 'dbmanager_menu');
40
  function dbmanager_menu() {
41
  if (function_exists('add_menu_page')) {
42
- add_menu_page(__('Database', 'wp-dbmanager'), __('Database', 'wp-dbmanager'), 'manage_database', 'dbmanager/database-manager.php');
43
  }
44
  if (function_exists('add_submenu_page')) {
45
- add_submenu_page('dbmanager/database-manager.php', __('Backup DB', 'wp-dbmanager'), __('Backup DB', 'wp-dbmanager'), 'manage_database', 'dbmanager/database-backup.php');
46
- add_submenu_page('dbmanager/database-manager.php', __('Manage Backup DB', 'wp-dbmanager'), __('Manage Backup DB', 'wp-dbmanager'), 'manage_database', 'dbmanager/database-manage.php');
47
- add_submenu_page('dbmanager/database-manager.php', __('Optimize DB', 'wp-dbmanager'), __('Optimize DB', 'wp-dbmanager'), 'manage_database', 'dbmanager/database-optimize.php');
48
- add_submenu_page('dbmanager/database-manager.php', __('Repair DB', 'wp-dbmanager'), __('Repair DB', 'wp-dbmanager'), 'manage_database', 'dbmanager/database-repair.php');
49
- add_submenu_page('dbmanager/database-manager.php', __('Empty/Drop Tables', 'wp-dbmanager'), __('Empty/Drop Tables', 'wp-dbmanager'), 'manage_database', 'dbmanager/database-empty.php');
50
- add_submenu_page('dbmanager/database-manager.php', __('Run SQL Query', 'wp-dbmanager'), __('Run SQL Query', 'wp-dbmanager'), 'manage_database', 'dbmanager/database-run.php');
51
- add_submenu_page('dbmanager/database-manager.php', __('DB Options', 'wp-dbmanager'), __('DB Options', 'wp-dbmanager'), 'manage_database', 'dbmanager/dbmanager.php', 'dbmanager_options');
52
- add_submenu_page('dbmanager/database-manager.php', __('Uninstall WP-DBManager', 'wp-dbmanager'), __('Uninstall WP-DBManager', 'wp-dbmanager'), 'manage_database', 'dbmanager/database-uninstall.php');
53
  }
54
  }
55
 
@@ -63,7 +63,7 @@ function cron_dbmanager_backup() {
63
  $backup_options = get_option('dbmanager_options');
64
  $backup_email = stripslashes($backup_options['backup_email']);
65
  if(intval($backup_options['backup_period']) > 0) {
66
- $current_date = gmdate(sprintf(__('%s @ %s', 'wp-dbmanager'), get_option('date_format'), get_option('time_format')), (time() + (get_option('gmt_offset') * 3600)));
67
  $backup = array();
68
  $backup['date'] = current_time('timestamp');
69
  $backup['mysqldumppath'] = $backup_options['mysqldumppath'];
@@ -78,14 +78,13 @@ function cron_dbmanager_backup() {
78
  $backup['filename'] = $backup['date'].'_-_'.DB_NAME.'.sql';
79
  $backup['filepath'] = $backup['path'].'/'.$backup['filename'];
80
  $backup['command'] = $backup['mysqldumppath'].' --host="'.DB_HOST.'" --user="'.DB_USER.'" --password="'.DB_PASSWORD.'" --add-drop-table --skip-lock-tables '.DB_NAME.' > '.$backup['filepath'];
81
- }
82
- check_backup_files();
83
- passthru($backup['command']);
84
  if(!empty($backup_email)) {
85
  // Get And Read The Database Backup File
86
  $file_path = $backup['filepath'];
87
  $file_size = format_size(filesize($file_path));
88
- $file_date = gmdate(sprintf(__('%s @ %s', 'wp-dbmanager'), get_option('date_format'), get_option('time_format')), substr($backup['filename'], 0, 10));
89
  $file = fopen($file_path,'rb');
90
  $file_data = fread($file,filesize($file_path));
91
  fclose($file);
@@ -172,8 +171,8 @@ function detect_mysql() {
172
  }
173
  } else {
174
  if(function_exists('exec')) {
175
- $paths['mysql'] = exec('which mysql');
176
- $paths['mysqldump'] = exec('which mysqldump');
177
  } else {
178
  $paths['mysql'] = 'mysql';
179
  $paths['mysqldump'] = 'mysqldump';
@@ -183,15 +182,34 @@ function detect_mysql() {
183
  }
184
 
185
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
186
  ### Function: Format Bytes Into KB/MB
187
  if(!function_exists('format_size')) {
188
  function format_size($rawSize) {
189
  if($rawSize / 1073741824 > 1)
190
- return round($rawSize/1048576, 1) . ' GB';
191
  else if ($rawSize / 1048576 > 1)
192
- return round($rawSize/1048576, 1) . ' MB';
193
  else if ($rawSize / 1024 > 1)
194
- return round($rawSize/1024, 1) . ' KB';
195
  else
196
  return round($rawSize, 1) . ' bytes';
197
  }
@@ -212,7 +230,9 @@ if(!function_exists('is_emtpy_folder')) {
212
  if(is_dir($folder) ){
213
  $handle = opendir($folder);
214
  while( (gettype( $name = readdir($handle)) != 'boolean')){
215
- $name_array[] = $name;
 
 
216
  }
217
  foreach($name_array as $temp)
218
  $folder_content .= $temp;
@@ -251,7 +271,7 @@ function check_backup_files() {
251
 
252
 
253
  ### Function: Database Manager Role
254
- add_action('activate_dbmanager/dbmanager.php', 'dbmanager_init');
255
  function dbmanager_init() {
256
  global $wpdb;
257
  $auto = detect_mysql();
@@ -286,7 +306,7 @@ function dbmanager_init() {
286
  add_action('init', 'download_database');
287
  function download_database() {
288
  if($_POST['do'] == 'Download' && !empty($_POST['database_file'])) {
289
- if(strpos($_SERVER['HTTP_REFERER'], get_option('siteurl').'/wp-admin/admin.php?page=dbmanager/database-manage.php') !== false) {
290
  $backup_options = get_option('dbmanager_options');
291
  $file_path = $backup_options['path'].'/'.$_POST['database_file'];
292
  header("Pragma: public");
@@ -356,121 +376,129 @@ function dbmanager_options() {
356
  </script>
357
  <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?>
358
  <!-- Database Options -->
359
- <div class="wrap">
360
- <h2><?php _e('Database Options', 'wp-dbmanager'); ?></h2>
361
- <form action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="post">
362
- <fieldset class="options">
363
- <legend><?php _e('Paths', 'wp-dbmanager'); ?></legend>
364
- <table class="optiontable">
365
- <tr>
366
- <td width="20%" valign="top"><strong><?php _e('Path To mysqldump:', 'wp-dbmanager'); ?></strong></td>
367
- <td width="80%">
368
- <input type="text" id="db_mysqldumppath" name="db_mysqldumppath" size="60" maxlength="100" value="<?php echo stripslashes($backup_options['mysqldumppath']); ?>" />&nbsp;&nbsp;<input type="button" value="<?php _e('Auto Detect', 'wp-dbmanager'); ?>" onclick="mysqldumppath();" />
369
- <p><?php _e('The absolute path to mysqldump without trailing slash. If unsure, please email your server administrator about this.', 'wp-dbmanager'); ?></p>
370
- </td>
371
- </tr>
372
- <tr>
373
- <td valign="top"><strong><?php _e('Path To mysql:', 'wp-dbmanager'); ?></strong></td>
374
- <td>
375
- <input type="text" id="db_mysqlpath" name="db_mysqlpath" size="60" maxlength="100" value="<?php echo stripslashes($backup_options['mysqlpath']); ?>" />&nbsp;&nbsp;<input type="button" value="<?php _e('Auto Detect', 'wp-dbmanager'); ?>" onclick="mysqlpath();" />
376
- <p><?php _e('The absolute path to mysql without trailing slash. If unsure, please email your server administrator about this.', 'wp-dbmanager'); ?></p>
377
- </td>
378
- </tr>
379
- <tr>
380
- <td valign="top"><strong><?php _e('Path To Backup:', 'wp-dbmanager'); ?></strong></td>
381
- <td>
382
- <input type="text" name="db_path" size="60" maxlength="100" value="<?php echo stripslashes($backup_options['path']); ?>" />
383
- <p><?php _e('The absolute path to your database backup folder without trailing slash. Make sure the folder is writable.', 'wp-dbmanager'); ?></p>
384
- </td>
385
- </tr>
386
- <tr>
387
- <td valign="top"><strong><?php _e('Maximum Backup Files:', 'wp-dbmanager'); ?></strong></td>
388
- <td>
389
- <input type="text" name="db_max_backup" size="5" maxlength="5" value="<?php echo stripslashes($backup_options['max_backup']); ?>" />
390
- <p><?php _e('The maximum number of database backup files that is allowed in the backup folder as stated above. The oldest database backup file is always deleted in order to maintain this value. This is to prevent the backup folder from getting too large.', 'wp-dbmanager'); ?></p>
391
- </td>
392
- </tr>
393
- </table>
394
- <p>
395
- <strong><?php _e('Windows Server', 'wp-dbmanager'); ?></strong><br />
396
- <?php _e('For mysqldump path, you can try \'<strong>mysqldump.exe</strong>\'.', 'wp-dbmanager'); ?><br />
397
- <?php _e('For mysql path, you can try \'<strong>mysql.exe</strong>\'.', 'wp-dbmanager'); ?>
398
- </p>
399
- <p>
400
- <strong><?php _e('Linux Server', 'wp-dbmanager'); ?></strong><br />
401
- <?php _e('For mysqldump path, normally is just \'<strong>mysqldump</strong>\'.', 'wp-dbmanager'); ?><br />
402
- <?php _e('For mysql path, normally is just \'<strong>mysql</strong>\'.', 'wp-dbmanager'); ?>
403
- </p>
404
- <p>
405
- <strong><?php _e('Note', 'wp-dbmanager'); ?></strong><br />
406
- <?php _e('The \'Auto Detect\' function does not work for some servers. If it does not work for you, please contact your server administrator for the MYSQL and MYSQL DUMP paths.', 'wp-dbmanager'); ?>
407
- </p>
408
- <p>&nbsp;</p>
409
- </fieldset>
410
- <fieldset class="options">
411
- <legend><?php _e('Automatic Scheduling', 'wp-dbmanager'); ?></legend>
412
- <table class="optiontable">
413
- <tr>
414
- <td valign="top"><strong><?php _e('Automatic Backing Up Of DB:', 'wp-dbmanager'); ?></strong></td>
415
- <td>
416
- <?php
417
- _e('Next backup date: ', 'wp-dbmanager');
418
- if(wp_next_scheduled('dbmanager_cron_backup')) {
419
- echo '<strong>'.gmdate(sprintf(__('%s @ %s', 'wp-dbmanager'), get_option('date_format'), get_option('time_format')), (wp_next_scheduled('dbmanager_cron_backup') + (get_option('gmt_offset') * 3600))).'</strong>';
420
- } else {
421
- _e('N/A', 'wp-dbmanager');
422
- }
423
- ?>
424
- <p>
425
- <?php _e('Every', 'wp-dbmanager'); ?>&nbsp;<input type="text" name="db_backup" size="3" maxlength="5" value="<?php echo intval($backup_options['backup']); ?>" />&nbsp;
426
- <select name="db_backup_period" size="1">
427
- <option value="0"<?php selected('0', $backup_options['backup_period']); ?>><?php _e('Disable', 'wp-dbmanager'); ?></option>
428
- <option value="3600"<?php selected('3600', $backup_options['backup_period']); ?>><?php _e('Hour(s)', 'wp-dbmanager'); ?></option>
429
- <option value="86400"<?php selected('86400', $backup_options['backup_period']); ?>><?php _e('Day(s)', 'wp-dbmanager'); ?></option>
430
- <option value="604800"<?php selected('604800', $backup_options['backup_period']); ?>><?php _e('Week(s)', 'wp-dbmanager'); ?></option>
431
- <option value="18144000"<?php selected('18144000', $backup_options['backup_period']); ?>><?php _e('Month(s)', 'wp-dbmanager'); ?></option>
432
- </select>&nbsp;&nbsp;&nbsp;
433
- <?php _e('Gzip', 'wp-dnmanager'); ?>
434
- <select name="db_backup_gzip" size="1">
435
- <option value="0"<?php selected('0', $backup_options['backup_gzip']); ?>><?php _e('No', 'wp-dbmanager'); ?></option>
436
- <option value="1"<?php selected('1', $backup_options['backup_gzip']); ?>><?php _e('Yes', 'wp-dbmanager'); ?></option>
437
- </select>
438
- </p>
439
- <p><?php _e('E-mail backup to:', 'wp-dbmanager'); ?> <input type="text" name="db_backup_email" size="30" maxlength="50" value="<?php echo stripslashes($backup_options['backup_email']) ?>" />&nbsp;&nbsp;&nbsp;<?php _e('(Leave black to disable this feature)', 'wp-dbmanager'); ?></p>
440
- <p><?php _e('WP-DBManager can automatically backup your database after a certain period.', 'wp-dbmanager'); ?></p>
441
- </td>
442
- </tr>
443
- <tr>
444
- <td valign="top"><strong><?php _e('Automatic Optimizing Of DB:', 'wp-dbmanager'); ?></strong></td>
445
- <td>
446
- <?php
447
- _e('Next optimize date: ', 'wp-dbmanager');
448
- if(wp_next_scheduled('dbmanager_cron_optimize')) {
449
- echo '<strong>'.gmdate(sprintf(__('%s @ %s', 'wp-dbmanager'), get_option('date_format'), get_option('time_format')), (wp_next_scheduled('dbmanager_cron_optimize') + (get_option('gmt_offset') * 3600))).'</strong>';
450
- } else {
451
- _e('N/A', 'wp-dbmanager');
452
- }
453
- ?>
454
- <p>
455
- <?php _e('Every', 'wp-dbmanager'); ?>&nbsp;<input type="text" name="db_optimize" size="3" maxlength="5" value="<?php echo intval($backup_options['optimize']); ?>" />&nbsp;
456
- <select name="db_optimize_period" size="1">
457
- <option value="0"<?php selected('0', $backup_options['optimize_period']); ?>><?php _e('Disable', 'wp-dbmanager'); ?></option>
458
- <option value="3600"<?php selected('3600', $backup_options['optimize_period']); ?>><?php _e('Hour(s)', 'wp-dbmanager'); ?></option>
459
- <option value="86400"<?php selected('86400', $backup_options['optimize_period']); ?>><?php _e('Day(s)', 'wp-dbmanager'); ?></option>
460
- <option value="604800"<?php selected('604800', $backup_options['optimize_period']); ?>><?php _e('Week(s)', 'wp-dbmanager'); ?></option>
461
- <option value="18144000"<?php selected('18144000', $backup_options['optimize_period']); ?>><?php _e('Month(s)', 'wp-dbmanager'); ?></option>
462
- </select>
463
- </p>
464
- <p><?php _e('WP-DBManager can automatically optimize your database after a certain period.', 'wp-dbmanager'); ?></p>
465
- </td>
466
- </tr>
467
- <tr>
468
- <td width="100%" colspan="2" align="center"><input type="submit" name="Submit" class="button" value="<?php _e('Update Options', 'wp-dbmanager'); ?>" />&nbsp;&nbsp;<input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td>
469
- </tr>
470
- </table>
471
- </fieldset>
472
- </form>
473
- </div>
 
 
 
 
 
 
 
 
474
  <?php
475
  }
476
  ?>
1
  <?php
2
  /*
3
  Plugin Name: WP-DBManager
4
+ Plugin URI: http://lesterchan.net/portfolio/programming/php/
5
  Description: Manages your Wordpress database. Allows you to optimize database, repair database, backup database, restore database, delete backup database , drop/empty tables and run selected queries. Supports automatic scheduling of backing up and optimizing of database.
6
+ Version: 2.30
7
  Author: Lester 'GaMerZ' Chan
8
  Author URI: http://lesterchan.net
9
  */
10
 
11
 
12
  /*
13
+ Copyright 2008 Lester Chan (email : lesterchan@gmail.com)
14
 
15
  This program is free software; you can redistribute it and/or modify
16
  it under the terms of the GNU General Public License as published by
31
  ### Create Text Domain For Translations
32
  add_action('init', 'dbmanager_textdomain');
33
  function dbmanager_textdomain() {
34
+ load_plugin_textdomain('wp-dbmanager', 'wp-content/plugins/wp-dbmanager');
35
  }
36
 
37
 
39
  add_action('admin_menu', 'dbmanager_menu');
40
  function dbmanager_menu() {
41
  if (function_exists('add_menu_page')) {
42
+ add_menu_page(__('Database', 'wp-dbmanager'), __('Database', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/database-manager.php');
43
  }
44
  if (function_exists('add_submenu_page')) {
45
+ add_submenu_page('wp-dbmanager/database-manager.php', __('Backup DB', 'wp-dbmanager'), __('Backup DB', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/database-backup.php');
46
+ add_submenu_page('wp-dbmanager/database-manager.php', __('Manage Backup DB', 'wp-dbmanager'), __('Manage Backup DB', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/database-manage.php');
47
+ add_submenu_page('wp-dbmanager/database-manager.php', __('Optimize DB', 'wp-dbmanager'), __('Optimize DB', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/database-optimize.php');
48
+ add_submenu_page('wp-dbmanager/database-manager.php', __('Repair DB', 'wp-dbmanager'), __('Repair DB', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/database-repair.php');
49
+ add_submenu_page('wp-dbmanager/database-manager.php', __('Empty/Drop Tables', 'wp-dbmanager'), __('Empty/Drop Tables', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/database-empty.php');
50
+ add_submenu_page('wp-dbmanager/database-manager.php', __('Run SQL Query', 'wp-dbmanager'), __('Run SQL Query', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/database-run.php');
51
+ add_submenu_page('wp-dbmanager/database-manager.php', __('DB Options', 'wp-dbmanager'), __('DB Options', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/wp-dbmanager.php', 'dbmanager_options');
52
+ add_submenu_page('wp-dbmanager/database-manager.php', __('Uninstall WP-DBManager', 'wp-dbmanager'), __('Uninstall WP-DBManager', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/database-uninstall.php');
53
  }
54
  }
55
 
63
  $backup_options = get_option('dbmanager_options');
64
  $backup_email = stripslashes($backup_options['backup_email']);
65
  if(intval($backup_options['backup_period']) > 0) {
66
+ $current_date = mysql2date(sprintf(__('%s @ %s', 'wp-dbmanager'), get_option('date_format'), get_option('time_format')), gmdate('Y-m-d H:i:s', current_time('timestamp')));
67
  $backup = array();
68
  $backup['date'] = current_time('timestamp');
69
  $backup['mysqldumppath'] = $backup_options['mysqldumppath'];
78
  $backup['filename'] = $backup['date'].'_-_'.DB_NAME.'.sql';
79
  $backup['filepath'] = $backup['path'].'/'.$backup['filename'];
80
  $backup['command'] = $backup['mysqldumppath'].' --host="'.DB_HOST.'" --user="'.DB_USER.'" --password="'.DB_PASSWORD.'" --add-drop-table --skip-lock-tables '.DB_NAME.' > '.$backup['filepath'];
81
+ }
82
+ execute_backup($backup['command']);
 
83
  if(!empty($backup_email)) {
84
  // Get And Read The Database Backup File
85
  $file_path = $backup['filepath'];
86
  $file_size = format_size(filesize($file_path));
87
+ $file_date = mysql2date(sprintf(__('%s @ %s', 'wp-dbmanager'), get_option('date_format'), get_option('time_format')), gmdate('Y-m-d H:i:s', substr($backup['filename'], 0, 10)));
88
  $file = fopen($file_path,'rb');
89
  $file_data = fread($file,filesize($file_path));
90
  fclose($file);
171
  }
172
  } else {
173
  if(function_exists('exec')) {
174
+ $paths['mysql'] = @exec('which mysql');
175
+ $paths['mysqldump'] = @exec('which mysqldump');
176
  } else {
177
  $paths['mysql'] = 'mysql';
178
  $paths['mysqldump'] = 'mysqldump';
182
  }
183
 
184
 
185
+ ### Executes OS-Dependent mysqldump Command (By: Vlad Sharanhovich)
186
+ function execute_backup($command) {
187
+ $backup_options = get_option('dbmanager_options');
188
+ check_backup_files();
189
+ if(substr(PHP_OS, 0, 3) == 'WIN') {
190
+ $writable_dir = $backup_options['path'];
191
+ $tmpnam = $writable_dir.'/wp-dbmanager.bat';
192
+ $fp = fopen($tmpnam, 'w');
193
+ fwrite($fp, $command);
194
+ fclose($fp);
195
+ system($tmpnam.' > NUL', $error);
196
+ unlink($tmpnam);
197
+ } else {
198
+ passthru($command, $error);
199
+ }
200
+ return $error;
201
+ }
202
+
203
+
204
  ### Function: Format Bytes Into KB/MB
205
  if(!function_exists('format_size')) {
206
  function format_size($rawSize) {
207
  if($rawSize / 1073741824 > 1)
208
+ return round($rawSize/1048576, 1) . ' GiB';
209
  else if ($rawSize / 1048576 > 1)
210
+ return round($rawSize/1048576, 1) . ' MiB';
211
  else if ($rawSize / 1024 > 1)
212
+ return round($rawSize/1024, 1) . ' KiB';
213
  else
214
  return round($rawSize, 1) . ' bytes';
215
  }
230
  if(is_dir($folder) ){
231
  $handle = opendir($folder);
232
  while( (gettype( $name = readdir($handle)) != 'boolean')){
233
+ if($name != '.htaccess') {
234
+ $name_array[] = $name;
235
+ }
236
  }
237
  foreach($name_array as $temp)
238
  $folder_content .= $temp;
271
 
272
 
273
  ### Function: Database Manager Role
274
+ add_action('activate_wp-dbmanager/wp-dbmanager.php', 'dbmanager_init');
275
  function dbmanager_init() {
276
  global $wpdb;
277
  $auto = detect_mysql();
306
  add_action('init', 'download_database');
307
  function download_database() {
308
  if($_POST['do'] == 'Download' && !empty($_POST['database_file'])) {
309
+ if(strpos($_SERVER['HTTP_REFERER'], get_option('siteurl').'/wp-admin/admin.php?page=wp-dbmanager/database-manage.php') !== false) {
310
  $backup_options = get_option('dbmanager_options');
311
  $file_path = $backup_options['path'].'/'.$_POST['database_file'];
312
  header("Pragma: public");
376
  </script>
377
  <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?>
378
  <!-- Database Options -->
379
+ <form action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="post">
380
+ <div class="wrap">
381
+ <h2><?php _e('Database Options', 'wp-dbmanager'); ?></h2>
382
+ <h3><?php _e('Paths', 'wp-dbmanager'); ?></h3>
383
+ <table class="form-table">
384
+ <tr>
385
+ <td width="20%" valign="top"><strong><?php _e('Path To mysqldump:', 'wp-dbmanager'); ?></strong></td>
386
+ <td width="80%">
387
+ <input type="text" id="db_mysqldumppath" name="db_mysqldumppath" size="60" maxlength="100" value="<?php echo stripslashes($backup_options['mysqldumppath']); ?>" />&nbsp;&nbsp;<input type="button" value="<?php _e('Auto Detect', 'wp-dbmanager'); ?>" onclick="mysqldumppath();" />
388
+ <p><?php _e('The absolute path to mysqldump without trailing slash. If unsure, please email your server administrator about this.', 'wp-dbmanager'); ?></p>
389
+ </td>
390
+ </tr>
391
+ <tr>
392
+ <td valign="top"><strong><?php _e('Path To mysql:', 'wp-dbmanager'); ?></strong></td>
393
+ <td>
394
+ <input type="text" id="db_mysqlpath" name="db_mysqlpath" size="60" maxlength="100" value="<?php echo stripslashes($backup_options['mysqlpath']); ?>" />&nbsp;&nbsp;<input type="button" value="<?php _e('Auto Detect', 'wp-dbmanager'); ?>" onclick="mysqlpath();" />
395
+ <p><?php _e('The absolute path to mysql without trailing slash. If unsure, please email your server administrator about this.', 'wp-dbmanager'); ?></p>
396
+ </td>
397
+ </tr>
398
+ <tr>
399
+ <td valign="top"><strong><?php _e('Path To Backup:', 'wp-dbmanager'); ?></strong></td>
400
+ <td>
401
+ <input type="text" name="db_path" size="60" maxlength="100" value="<?php echo stripslashes($backup_options['path']); ?>" />
402
+ <p><?php _e('The absolute path to your database backup folder without trailing slash. Make sure the folder is writable.', 'wp-dbmanager'); ?></p>
403
+ </td>
404
+ </tr>
405
+ <tr>
406
+ <td valign="top"><strong><?php _e('Maximum Backup Files:', 'wp-dbmanager'); ?></strong></td>
407
+ <td>
408
+ <input type="text" name="db_max_backup" size="5" maxlength="5" value="<?php echo stripslashes($backup_options['max_backup']); ?>" />
409
+ <p><?php _e('The maximum number of database backup files that is allowed in the backup folder as stated above. The oldest database backup file is always deleted in order to maintain this value. This is to prevent the backup folder from getting too large.', 'wp-dbmanager'); ?></p>
410
+ </td>
411
+ </tr>
412
+ </table>
413
+
414
+ <h3><?php _e('Note', 'wp-dbmanager'); ?></h3>
415
+ <table class="form-table">
416
+ <tr>
417
+ <td>
418
+ <strong><?php _e('Windows Server', 'wp-dbmanager'); ?></strong><br />
419
+ <?php _e('For mysqldump path, you can try \'<strong>mysqldump.exe</strong>\'.', 'wp-dbmanager'); ?><br />
420
+ <?php _e('For mysql path, you can try \'<strong>mysql.exe</strong>\'.', 'wp-dbmanager'); ?>
421
+ </td>
422
+ </tr>
423
+ <tr>
424
+ <td>
425
+ <strong><?php _e('Linux Server', 'wp-dbmanager'); ?></strong><br />
426
+ <?php _e('For mysqldump path, normally is just \'<strong>mysqldump</strong>\'.', 'wp-dbmanager'); ?><br />
427
+ <?php _e('For mysql path, normally is just \'<strong>mysql</strong>\'.', 'wp-dbmanager'); ?>
428
+ </td>
429
+ </tr>
430
+ <tr>
431
+ <td>
432
+ <strong><?php _e('Note', 'wp-dbmanager'); ?></strong><br />
433
+ <?php _e('The \'Auto Detect\' function does not work for some servers. If it does not work for you, please contact your server administrator for the MYSQL and MYSQL DUMP paths.', 'wp-dbmanager'); ?>
434
+ </td>
435
+ </tr>
436
+ </table>
437
+
438
+ <h3><?php _e('Automatic Scheduling', 'wp-dbmanager'); ?></h3>
439
+ <table class="form-table">
440
+ <tr>
441
+ <td valign="top"><strong><?php _e('Automatic Backing Up Of DB:', 'wp-dbmanager'); ?></strong></td>
442
+ <td>
443
+ <?php
444
+ _e('Next backup date: ', 'wp-dbmanager');
445
+ if(wp_next_scheduled('dbmanager_cron_backup')) {
446
+ echo '<strong>'.mysql2date(sprintf(__('%s @ %s', 'wp-dbmanager'), get_option('date_format'), get_option('time_format')), gmdate('Y-m-d H:i:s', (wp_next_scheduled('dbmanager_cron_backup') + (get_option('gmt_offset') * 3600)))).'</strong>';
447
+ } else {
448
+ _e('N/A', 'wp-dbmanager');
449
+ }
450
+ ?>
451
+ <p>
452
+ <?php _e('Every', 'wp-dbmanager'); ?>&nbsp;<input type="text" name="db_backup" size="3" maxlength="5" value="<?php echo intval($backup_options['backup']); ?>" />&nbsp;
453
+ <select name="db_backup_period" size="1">
454
+ <option value="0"<?php selected('0', $backup_options['backup_period']); ?>><?php _e('Disable', 'wp-dbmanager'); ?></option>
455
+ <option value="60"<?php selected('60', $backup_options['backup_period']); ?>><?php _e('Minutes(s)', 'wp-dbmanager'); ?></option>
456
+ <option value="3600"<?php selected('3600', $backup_options['backup_period']); ?>><?php _e('Hour(s)', 'wp-dbmanager'); ?></option>
457
+ <option value="86400"<?php selected('86400', $backup_options['backup_period']); ?>><?php _e('Day(s)', 'wp-dbmanager'); ?></option>
458
+ <option value="604800"<?php selected('604800', $backup_options['backup_period']); ?>><?php _e('Week(s)', 'wp-dbmanager'); ?></option>
459
+ <option value="18144000"<?php selected('18144000', $backup_options['backup_period']); ?>><?php _e('Month(s)', 'wp-dbmanager'); ?></option>
460
+ </select>&nbsp;&nbsp;&nbsp;
461
+ <?php _e('Gzip', 'wp-dnmanager'); ?>
462
+ <select name="db_backup_gzip" size="1">
463
+ <option value="0"<?php selected('0', $backup_options['backup_gzip']); ?>><?php _e('No', 'wp-dbmanager'); ?></option>
464
+ <option value="1"<?php selected('1', $backup_options['backup_gzip']); ?>><?php _e('Yes', 'wp-dbmanager'); ?></option>
465
+ </select>
466
+ </p>
467
+ <p><?php _e('E-mail backup to:', 'wp-dbmanager'); ?> <input type="text" name="db_backup_email" size="30" maxlength="50" value="<?php echo stripslashes($backup_options['backup_email']) ?>" />&nbsp;&nbsp;&nbsp;<?php _e('(Leave black to disable this feature)', 'wp-dbmanager'); ?></p>
468
+ <p><?php _e('WP-DBManager can automatically backup your database after a certain period.', 'wp-dbmanager'); ?></p>
469
+ </td>
470
+ </tr>
471
+ <tr>
472
+ <td valign="top"><strong><?php _e('Automatic Optimizing Of DB:', 'wp-dbmanager'); ?></strong></td>
473
+ <td>
474
+ <?php
475
+ _e('Next optimize date: ', 'wp-dbmanager');
476
+ if(wp_next_scheduled('dbmanager_cron_optimize')) {
477
+ echo '<strong>'.mysql2date(sprintf(__('%s @ %s', 'wp-dbmanager'), get_option('date_format'), get_option('time_format')), gmdate('Y-m-d H:i:s', (wp_next_scheduled('dbmanager_cron_optimize') + (get_option('gmt_offset') * 3600)))).'</strong>';
478
+ } else {
479
+ _e('N/A', 'wp-dbmanager');
480
+ }
481
+ ?>
482
+ <p>
483
+ <?php _e('Every', 'wp-dbmanager'); ?>&nbsp;<input type="text" name="db_optimize" size="3" maxlength="5" value="<?php echo intval($backup_options['optimize']); ?>" />&nbsp;
484
+ <select name="db_optimize_period" size="1">
485
+ <option value="0"<?php selected('0', $backup_options['optimize_period']); ?>><?php _e('Disable', 'wp-dbmanager'); ?></option>
486
+ <option value="60"<?php selected('60', $backup_options['optimize_period']); ?>><?php _e('Minutes(s)', 'wp-dbmanager'); ?></option>
487
+ <option value="3600"<?php selected('3600', $backup_options['optimize_period']); ?>><?php _e('Hour(s)', 'wp-dbmanager'); ?></option>
488
+ <option value="86400"<?php selected('86400', $backup_options['optimize_period']); ?>><?php _e('Day(s)', 'wp-dbmanager'); ?></option>
489
+ <option value="604800"<?php selected('604800', $backup_options['optimize_period']); ?>><?php _e('Week(s)', 'wp-dbmanager'); ?></option>
490
+ <option value="18144000"<?php selected('18144000', $backup_options['optimize_period']); ?>><?php _e('Month(s)', 'wp-dbmanager'); ?></option>
491
+ </select>
492
+ </p>
493
+ <p><?php _e('WP-DBManager can automatically optimize your database after a certain period.', 'wp-dbmanager'); ?></p>
494
+ </td>
495
+ </tr>
496
+ </table>
497
+ <p class="submit">
498
+ <input type="submit" name="Submit" class="button" value="<?php _e('Save Changes', 'wp-dbmanager'); ?>" />
499
+ </p>
500
+ </div>
501
+ </form>
502
  <?php
503
  }
504
  ?>
dbmanager/wp-dbmanager.pot → wp-dbmanager.pot RENAMED
@@ -1,12 +1,13 @@
1
  msgid ""
2
  msgstr ""
3
- "Project-Id-Version: WP-DBManager 2.20\n"
4
- "POT-Creation-Date: \n"
5
- "PO-Revision-Date: 2007-09-30 16:04+0800\n"
6
- "Last-Translator: Lester 'GaMerZ' Chan <gamerz84@hotmail.com>\n"
 
7
  "Language-Team: Lester Chan <gamerz84@hotmail.com>\n"
8
  "MIME-Version: 1.0\n"
9
- "Content-Type: text/plain; charset=utf-8\n"
10
  "Content-Transfer-Encoding: 8bit\n"
11
  "X-Poedit-Language: English\n"
12
  "X-Poedit-Country: SINGAPORE\n"
@@ -15,132 +16,132 @@ msgstr ""
15
  "X-Poedit-SearchPath-0: .\n"
16
 
17
  #: database-backup.php:29
18
- #: database-backup.php:177
19
  #: database-manage.php:41
20
  #: database-manage.php:67
21
  #: database-manage.php:122
22
- #: database-manage.php:172
23
- #: dbmanager.php:66
24
- #: dbmanager.php:88
25
- #: dbmanager.php:419
26
- #: dbmanager.php:449
27
  #, php-format
28
  msgid "%s @ %s"
29
  msgstr ""
30
 
31
  #: database-backup.php:42
32
- #: database-backup.php:196
33
  msgid "Backup"
34
  msgstr ""
35
 
36
- #: database-backup.php:56
37
  #, php-format
38
  msgid "Database Failed To Backup On '%s'. Backup Folder Not Writable."
39
  msgstr ""
40
 
41
- #: database-backup.php:59
42
  #, php-format
43
  msgid "Database Failed To Backup On '%s'. Backup File Size Is 0KB."
44
  msgstr ""
45
 
46
- #: database-backup.php:61
47
  #, php-format
48
  msgid "Database Failed To Backup On '%s'. Invalid Backup File Path."
49
  msgstr ""
50
 
51
- #: database-backup.php:63
52
  #, php-format
53
  msgid "Database Failed To Backup On '%s'."
54
  msgstr ""
55
 
56
- #: database-backup.php:65
57
  #, php-format
58
  msgid "Database Backed Up Successfully On '%s'."
59
  msgstr ""
60
 
61
- #: database-backup.php:83
62
  msgid "Checking Backup Status"
63
  msgstr ""
64
 
65
- #: database-backup.php:85
66
  msgid "Checking Backup Folder"
67
  msgstr ""
68
 
69
- #: database-backup.php:88
70
  msgid "Backup folder exists"
71
  msgstr ""
72
 
73
- #: database-backup.php:91
74
  msgid "Backup folder does NOT exist. Please create 'backup-db' folder in 'wp-content' folder and CHMOD it to '777' or change the location of the backup folder under DB Option."
75
  msgstr ""
76
 
77
- #: database-backup.php:94
78
  msgid "Backup folder is writable"
79
  msgstr ""
80
 
81
- #: database-backup.php:97
82
  msgid "Backup folder is NOT writable. Please CHMOD it to '777'."
83
  msgstr ""
84
 
85
- #: database-backup.php:104
86
- #: database-backup.php:108
87
  msgid "Checking MYSQL Dump Path"
88
  msgstr ""
89
 
90
- #: database-backup.php:105
91
  msgid "MYSQL dump path exists."
92
  msgstr ""
93
 
94
- #: database-backup.php:109
95
  msgid "MYSQL dump path does NOT exist. Please check your mysqldump path under DB Options. If uncertain, contact your server administrator."
96
  msgstr ""
97
 
98
- #: database-backup.php:116
99
- #: database-backup.php:120
100
  msgid "Checking MYSQL Path"
101
  msgstr ""
102
 
103
- #: database-backup.php:117
104
  msgid "MYSQL path exists."
105
  msgstr ""
106
 
107
- #: database-backup.php:121
108
  msgid "MYSQL path does NOT exist. Please check your mysql path under DB Options. If uncertain, contact your server administrator."
109
  msgstr ""
110
 
111
- #: database-backup.php:126
112
  msgid "Checking PHP Functions"
113
  msgstr ""
114
 
115
- #: database-backup.php:126
116
  msgid "and"
117
  msgstr ""
118
 
119
- #: database-backup.php:129
120
- #: database-backup.php:136
121
- #: database-backup.php:142
122
  msgid "enabled"
123
  msgstr ""
124
 
125
- #: database-backup.php:132
126
- #: database-backup.php:138
127
- #: database-backup.php:144
128
  msgid "disabled"
129
  msgstr ""
130
 
131
- #: database-backup.php:152
132
  msgid "Excellent. You Are Good To Go."
133
  msgstr ""
134
 
135
- #: database-backup.php:154
136
  msgid "I'm sorry, your server administrator has disabled passthru(), system() and exec(), thus you cannot use this backup script. You may consider using the default WordPress database backup script instead."
137
  msgstr ""
138
 
139
- #: database-backup.php:156
140
  msgid "Please Rectify The Error Highlighted In Red Before Proceeding On."
141
  msgstr ""
142
 
143
- #: database-backup.php:160
144
  msgid "Note: The checking of backup status is still undergoing testing, it may not be accurate."
145
  msgstr ""
146
 
@@ -148,65 +149,73 @@ msgstr ""
148
  msgid "Backup Database"
149
  msgstr ""
150
 
151
- #: database-backup.php:168
 
 
 
 
 
 
 
 
 
152
  msgid "Database Name:"
153
  msgstr ""
154
 
155
- #: database-backup.php:172
156
  msgid "Database Backup To:"
157
  msgstr ""
158
 
159
- #: database-backup.php:176
160
  msgid "Database Backup Date:"
161
  msgstr ""
162
 
163
- #: database-backup.php:180
164
  msgid "Database Backup File Name:"
165
  msgstr ""
166
 
167
- #: database-backup.php:184
168
  msgid "Database Backup Type:"
169
  msgstr ""
170
 
171
- #: database-backup.php:185
172
  msgid "Full (Structure and Data)"
173
  msgstr ""
174
 
175
- #: database-backup.php:188
176
  msgid "MYSQL Dump Location:"
177
  msgstr ""
178
 
179
- #: database-backup.php:192
180
  msgid "GZIP Database Backup File?"
181
  msgstr ""
182
 
183
- #: database-backup.php:193
184
- #: database-optimize.php:83
185
- #: database-repair.php:79
186
- #: database-uninstall.php:122
187
- #: dbmanager.php:436
188
  msgid "Yes"
189
  msgstr ""
190
 
191
- #: database-backup.php:193
192
- #: database-optimize.php:83
193
- #: database-repair.php:79
194
- #: dbmanager.php:435
195
  msgid "No"
196
  msgstr ""
197
 
198
- #: database-backup.php:196
199
- #: database-empty.php:106
200
- #: database-manage.php:201
201
- #: database-optimize.php:90
202
- #: database-repair.php:83
203
- #: database-run.php:92
204
- #: dbmanager.php:468
205
  msgid "Cancel"
206
  msgstr ""
207
 
208
  #: database-empty.php:44
209
- #: database-empty.php:106
210
  msgid "Empty/Drop"
211
  msgstr ""
212
 
@@ -224,38 +233,46 @@ msgstr ""
224
  msgid "Table(s) '%s' Dropped"
225
  msgstr ""
226
 
227
- #: database-empty.php:79
228
- #: dbmanager.php:49
229
  msgid "Empty/Drop Tables"
230
  msgstr ""
231
 
232
- #: database-empty.php:83
233
- #: database-manager.php:76
234
- #: database-manager.php:108
235
- #: database-optimize.php:71
236
- #: database-repair.php:67
237
  msgid "Tables"
238
  msgstr ""
239
 
240
- #: database-empty.php:84
241
- #: database-empty.php:96
242
  msgid "Empty"
243
  msgstr ""
244
 
245
- #: database-empty.php:85
246
- #: database-empty.php:97
 
 
 
 
247
  msgid "Drop"
248
  msgstr ""
249
 
250
- #: database-empty.php:102
251
- msgid "1. DROPPING a table means deleting the table. This action is not REVERSIBLE."
 
 
 
 
252
  msgstr ""
253
 
254
- #: database-empty.php:103
255
- msgid "2. EMPTYING a table means all the rows in the table will be deleted. This action is not REVERSIBLE."
256
  msgstr ""
257
 
258
- #: database-empty.php:106
259
  msgid ""
260
  "You Are About To Empty Or Drop The Selected Databases.\\n"
261
  "This Action Is Not Reversible.\\n"
@@ -264,7 +281,7 @@ msgid ""
264
  msgstr ""
265
 
266
  #: database-manage.php:45
267
- #: database-manage.php:199
268
  msgid "Restore"
269
  msgstr ""
270
 
@@ -286,48 +303,48 @@ msgid "No Backup Database File Selected"
286
  msgstr ""
287
 
288
  #: database-manage.php:62
289
- #: database-manage.php:194
290
  msgid "E-Mail"
291
  msgstr ""
292
 
293
  #: database-manage.php:78
294
- #: dbmanager.php:94
295
  #, php-format
296
  msgid "%s Database Backup File For %s"
297
  msgstr ""
298
 
299
  #: database-manage.php:87
300
- #: dbmanager.php:103
301
  msgid "Website Name:"
302
  msgstr ""
303
 
304
  #: database-manage.php:88
305
- #: dbmanager.php:104
306
  msgid "Website URL:"
307
  msgstr ""
308
 
309
  #: database-manage.php:89
310
- #: dbmanager.php:105
311
  msgid "Backup File Name:"
312
  msgstr ""
313
 
314
  #: database-manage.php:90
315
- #: dbmanager.php:106
316
  msgid "Backup File Date:"
317
  msgstr ""
318
 
319
  #: database-manage.php:91
320
- #: dbmanager.php:107
321
  msgid "Backup File Size:"
322
  msgstr ""
323
 
324
  #: database-manage.php:92
325
- #: dbmanager.php:108
326
  msgid "With Regards,"
327
  msgstr ""
328
 
329
  #: database-manage.php:93
330
- #: dbmanager.php:109
331
  msgid "Administrator"
332
  msgstr ""
333
 
@@ -342,12 +359,12 @@ msgid "Unable To E-Mail Database Backup File For '%s' To '%s'"
342
  msgstr ""
343
 
344
  #: database-manage.php:115
345
- #: database-manage.php:198
346
  msgid "Download"
347
  msgstr ""
348
 
349
  #: database-manage.php:120
350
- #: database-manage.php:200
351
  msgid "Delete"
352
  msgstr ""
353
 
@@ -366,49 +383,49 @@ msgstr ""
366
  msgid "Invalid Database Backup File On '%s'"
367
  msgstr ""
368
 
369
- #: database-manage.php:142
370
  msgid "Manage Backup Database"
371
  msgstr ""
372
 
373
- #: database-manage.php:143
374
  msgid "Choose A Backup Date To E-Mail, Restore, Download Or Delete"
375
  msgstr ""
376
 
377
- #: database-manage.php:147
378
- #: database-manager.php:75
379
  msgid "No."
380
  msgstr ""
381
 
382
- #: database-manage.php:148
383
  msgid "Database File"
384
  msgstr ""
385
 
386
- #: database-manage.php:149
387
  msgid "Date/Time"
388
  msgstr ""
389
 
390
- #: database-manage.php:150
391
  msgid "Size"
392
  msgstr ""
393
 
394
- #: database-manage.php:151
395
  msgid "Select"
396
  msgstr ""
397
 
398
- #: database-manage.php:182
399
- #: database-manage.php:185
400
  msgid "There Are No Database Backup Files Available."
401
  msgstr ""
402
 
403
- #: database-manage.php:189
404
  msgid "Backup File(s)"
405
  msgstr ""
406
 
407
- #: database-manage.php:194
408
  msgid "E-mail database backup file to:"
409
  msgstr ""
410
 
411
- #: database-manage.php:199
412
  msgid ""
413
  "You Are About To Restore A Database.\\n"
414
  "This Action Is Not Reversible.\\n"
@@ -417,7 +434,7 @@ msgid ""
417
  " Choose [Cancel] to stop, [Ok] to restore."
418
  msgstr ""
419
 
420
- #: database-manage.php:200
421
  msgid ""
422
  "You Are About To Delete The Selected Database Backup Files.\\n"
423
  "This Action Is Not Reversible.\\n"
@@ -429,59 +446,55 @@ msgstr ""
429
  msgid "Database Information"
430
  msgstr ""
431
 
432
- #: database-manager.php:46
433
  msgid "Setting"
434
  msgstr ""
435
 
436
- #: database-manager.php:47
437
- msgid "Value"
438
- msgstr ""
439
-
440
- #: database-manager.php:50
441
  msgid "Database Host"
442
  msgstr ""
443
 
444
- #: database-manager.php:54
445
  msgid "Database Name"
446
  msgstr ""
447
 
448
- #: database-manager.php:58
449
  msgid "Database User"
450
  msgstr ""
451
 
452
- #: database-manager.php:62
453
  msgid "Database Type"
454
  msgstr ""
455
 
456
- #: database-manager.php:66
457
  msgid "Database Version"
458
  msgstr ""
459
 
460
- #: database-manager.php:72
461
  msgid "Tables Information"
462
  msgstr ""
463
 
464
- #: database-manager.php:77
465
  msgid "Records"
466
  msgstr ""
467
 
468
- #: database-manager.php:78
469
  msgid "Data Usage"
470
  msgstr ""
471
 
472
- #: database-manager.php:79
473
  msgid "Index Usage"
474
  msgstr ""
475
 
476
- #: database-manager.php:80
477
  msgid "Overhead"
478
  msgstr ""
479
 
480
- #: database-manager.php:107
481
  msgid "Total:"
482
  msgstr ""
483
 
484
- #: database-manager.php:115
485
  msgid "Could Not Show Table Status Due To Your MYSQL Version Is Lower Than 3.23."
486
  msgstr ""
487
 
@@ -500,20 +513,20 @@ msgstr ""
500
  msgid "Table(s) '%s' Optimized"
501
  msgstr ""
502
 
503
- #: database-optimize.php:67
504
  msgid "Optimize Database"
505
  msgstr ""
506
 
507
- #: database-optimize.php:72
508
- #: database-repair.php:68
509
  msgid "Options"
510
  msgstr ""
511
 
512
- #: database-optimize.php:87
513
  msgid "Database should be optimize once every month."
514
  msgstr ""
515
 
516
- #: database-optimize.php:90
517
  msgid "Optimize"
518
  msgstr ""
519
 
@@ -522,16 +535,16 @@ msgstr ""
522
  msgid "Table(s) '%s' Repaired"
523
  msgstr ""
524
 
525
- #: database-repair.php:63
526
  msgid "Repair Database"
527
  msgstr ""
528
 
529
- #: database-repair.php:83
530
  msgid "Repair"
531
  msgstr ""
532
 
533
  #: database-run.php:41
534
- #: database-run.php:92
535
  msgid "Run"
536
  msgstr ""
537
 
@@ -544,33 +557,33 @@ msgstr ""
544
  msgid "Empty Query"
545
  msgstr ""
546
 
547
- #: database-run.php:85
548
- #: dbmanager.php:50
549
  msgid "Run SQL Query"
550
  msgstr ""
551
 
552
- #: database-run.php:88
553
  msgid "Seperate Multiple Queries With A New Line"
554
  msgstr ""
555
 
556
- #: database-run.php:89
557
  msgid "Use Only INSERT, UPDATE, REPLACE, DELETE, CREATE and ALTER statements."
558
  msgstr ""
559
 
560
- #: database-run.php:94
561
  msgid "1. CREATE statement will return an error, which is perfectly normal due to the database class. To confirm that your table has been created check the Manage Database page."
562
  msgstr ""
563
 
564
- #: database-run.php:95
565
  msgid "2. UPDATE statement may return an error sometimes due to the newly updated value being the same as the previous value."
566
  msgstr ""
567
 
568
- #: database-run.php:96
569
  msgid "3. ALTER statement will return an error because there is no value returned."
570
  msgstr ""
571
 
572
  #: database-uninstall.php:39
573
- #: database-uninstall.php:123
574
  msgid "UNINSTALL WP-DBManager"
575
  msgstr ""
576
 
@@ -597,7 +610,7 @@ msgstr ""
597
 
598
  #: database-uninstall.php:78
599
  #: database-uninstall.php:88
600
- #: dbmanager.php:52
601
  msgid "Uninstall WP-DBManager"
602
  msgstr ""
603
 
@@ -626,11 +639,11 @@ msgstr ""
626
  msgid "The following WordPress Options will be DELETED:"
627
  msgstr ""
628
 
629
- #: database-uninstall.php:106
630
  msgid "WordPress Options"
631
  msgstr ""
632
 
633
- #: database-uninstall.php:123
634
  msgid ""
635
  "You Are About To Uninstall WP-DBManager From WordPress.\\n"
636
  "This Action Is Not Reversible.\\n"
@@ -638,199 +651,205 @@ msgid ""
638
  " Choose [Cancel] To Stop, [OK] To Uninstall."
639
  msgstr ""
640
 
641
- #: dbmanager.php:42
642
  msgid "Database"
643
  msgstr ""
644
 
645
- #: dbmanager.php:45
646
  msgid "Backup DB"
647
  msgstr ""
648
 
649
- #: dbmanager.php:46
650
  msgid "Manage Backup DB"
651
  msgstr ""
652
 
653
- #: dbmanager.php:47
654
  msgid "Optimize DB"
655
  msgstr ""
656
 
657
- #: dbmanager.php:48
658
  msgid "Repair DB"
659
  msgstr ""
660
 
661
- #: dbmanager.php:51
662
  msgid "DB Options"
663
  msgstr ""
664
 
665
- #: dbmanager.php:153
666
  msgid "WP-DBManager Backup Schedule"
667
  msgstr ""
668
 
669
- #: dbmanager.php:154
670
  msgid "WP-DBManager Optimize Schedule"
671
  msgstr ""
672
 
673
- #: dbmanager.php:327
674
  msgid "Database Options Updated"
675
  msgstr ""
676
 
677
- #: dbmanager.php:330
678
  msgid "No Database Option Updated"
679
  msgstr ""
680
 
681
- #: dbmanager.php:360
682
  msgid "Database Options"
683
  msgstr ""
684
 
685
- #: dbmanager.php:363
686
  msgid "Paths"
687
  msgstr ""
688
 
689
- #: dbmanager.php:366
690
  msgid "Path To mysqldump:"
691
  msgstr ""
692
 
693
- #: dbmanager.php:368
694
- #: dbmanager.php:375
695
  msgid "Auto Detect"
696
  msgstr ""
697
 
698
- #: dbmanager.php:369
699
  msgid "The absolute path to mysqldump without trailing slash. If unsure, please email your server administrator about this."
700
  msgstr ""
701
 
702
- #: dbmanager.php:373
703
  msgid "Path To mysql:"
704
  msgstr ""
705
 
706
- #: dbmanager.php:376
707
  msgid "The absolute path to mysql without trailing slash. If unsure, please email your server administrator about this."
708
  msgstr ""
709
 
710
- #: dbmanager.php:380
711
  msgid "Path To Backup:"
712
  msgstr ""
713
 
714
- #: dbmanager.php:383
715
  msgid "The absolute path to your database backup folder without trailing slash. Make sure the folder is writable."
716
  msgstr ""
717
 
718
- #: dbmanager.php:387
719
  msgid "Maximum Backup Files:"
720
  msgstr ""
721
 
722
- #: dbmanager.php:390
723
  msgid "The maximum number of database backup files that is allowed in the backup folder as stated above. The oldest database backup file is always deleted in order to maintain this value. This is to prevent the backup folder from getting too large."
724
  msgstr ""
725
 
726
- #: dbmanager.php:395
 
 
 
 
 
727
  msgid "Windows Server"
728
  msgstr ""
729
 
730
- #: dbmanager.php:396
731
  msgid "For mysqldump path, you can try '<strong>mysqldump.exe</strong>'."
732
  msgstr ""
733
 
734
- #: dbmanager.php:397
735
  msgid "For mysql path, you can try '<strong>mysql.exe</strong>'."
736
  msgstr ""
737
 
738
- #: dbmanager.php:400
739
  msgid "Linux Server"
740
  msgstr ""
741
 
742
- #: dbmanager.php:401
743
  msgid "For mysqldump path, normally is just '<strong>mysqldump</strong>'."
744
  msgstr ""
745
 
746
- #: dbmanager.php:402
747
  msgid "For mysql path, normally is just '<strong>mysql</strong>'."
748
  msgstr ""
749
 
750
- #: dbmanager.php:405
751
- msgid "Note"
752
- msgstr ""
753
-
754
- #: dbmanager.php:406
755
  msgid "The 'Auto Detect' function does not work for some servers. If it does not work for you, please contact your server administrator for the MYSQL and MYSQL DUMP paths."
756
  msgstr ""
757
 
758
- #: dbmanager.php:411
759
  msgid "Automatic Scheduling"
760
  msgstr ""
761
 
762
- #: dbmanager.php:414
763
  msgid "Automatic Backing Up Of DB:"
764
  msgstr ""
765
 
766
- #: dbmanager.php:417
767
  msgid "Next backup date: "
768
  msgstr ""
769
 
770
- #: dbmanager.php:421
771
- #: dbmanager.php:451
772
  msgid "N/A"
773
  msgstr ""
774
 
775
- #: dbmanager.php:425
776
- #: dbmanager.php:455
777
  msgid "Every"
778
  msgstr ""
779
 
780
- #: dbmanager.php:427
781
- #: dbmanager.php:457
782
  msgid "Disable"
783
  msgstr ""
784
 
785
- #: dbmanager.php:428
786
- #: dbmanager.php:458
 
 
 
 
 
787
  msgid "Hour(s)"
788
  msgstr ""
789
 
790
- #: dbmanager.php:429
791
- #: dbmanager.php:459
792
  msgid "Day(s)"
793
  msgstr ""
794
 
795
- #: dbmanager.php:430
796
- #: dbmanager.php:460
797
  msgid "Week(s)"
798
  msgstr ""
799
 
800
- #: dbmanager.php:431
801
- #: dbmanager.php:461
802
  msgid "Month(s)"
803
  msgstr ""
804
 
805
- #: dbmanager.php:433
806
  msgid "Gzip"
807
  msgstr ""
808
 
809
- #: dbmanager.php:439
810
  msgid "E-mail backup to:"
811
  msgstr ""
812
 
813
- #: dbmanager.php:439
814
  msgid "(Leave black to disable this feature)"
815
  msgstr ""
816
 
817
- #: dbmanager.php:440
818
  msgid "WP-DBManager can automatically backup your database after a certain period."
819
  msgstr ""
820
 
821
- #: dbmanager.php:444
822
  msgid "Automatic Optimizing Of DB:"
823
  msgstr ""
824
 
825
- #: dbmanager.php:447
826
  msgid "Next optimize date: "
827
  msgstr ""
828
 
829
- #: dbmanager.php:464
830
  msgid "WP-DBManager can automatically optimize your database after a certain period."
831
  msgstr ""
832
 
833
- #: dbmanager.php:468
834
- msgid "Update Options"
835
  msgstr ""
836
 
1
  msgid ""
2
  msgstr ""
3
+ "Project-Id-Version: WP-DBManager 2.30\n"
4
+ "Report-Msgid-Bugs-To: \n"
5
+ "POT-Creation-Date: 2008-05-16 19:44+0800\n"
6
+ "PO-Revision-Date: 2008-05-16 19:44+0800\n"
7
+ "Last-Translator: Lester Chan <lesterchan@gmail.com>\n"
8
  "Language-Team: Lester Chan <gamerz84@hotmail.com>\n"
9
  "MIME-Version: 1.0\n"
10
+ "Content-Type: text/plain; charset=UTF-8\n"
11
  "Content-Transfer-Encoding: 8bit\n"
12
  "X-Poedit-Language: English\n"
13
  "X-Poedit-Country: SINGAPORE\n"
16
  "X-Poedit-SearchPath-0: .\n"
17
 
18
  #: database-backup.php:29
19
+ #: database-backup.php:183
20
  #: database-manage.php:41
21
  #: database-manage.php:67
22
  #: database-manage.php:122
23
+ #: database-manage.php:174
24
+ #: wp-dbmanager.php:66
25
+ #: wp-dbmanager.php:87
26
+ #: wp-dbmanager.php:446
27
+ #: wp-dbmanager.php:477
28
  #, php-format
29
  msgid "%s @ %s"
30
  msgstr ""
31
 
32
  #: database-backup.php:42
33
+ #: database-backup.php:202
34
  msgid "Backup"
35
  msgstr ""
36
 
37
+ #: database-backup.php:55
38
  #, php-format
39
  msgid "Database Failed To Backup On '%s'. Backup Folder Not Writable."
40
  msgstr ""
41
 
42
+ #: database-backup.php:58
43
  #, php-format
44
  msgid "Database Failed To Backup On '%s'. Backup File Size Is 0KB."
45
  msgstr ""
46
 
47
+ #: database-backup.php:60
48
  #, php-format
49
  msgid "Database Failed To Backup On '%s'. Invalid Backup File Path."
50
  msgstr ""
51
 
52
+ #: database-backup.php:62
53
  #, php-format
54
  msgid "Database Failed To Backup On '%s'."
55
  msgstr ""
56
 
57
+ #: database-backup.php:64
58
  #, php-format
59
  msgid "Database Backed Up Successfully On '%s'."
60
  msgstr ""
61
 
62
+ #: database-backup.php:82
63
  msgid "Checking Backup Status"
64
  msgstr ""
65
 
66
+ #: database-backup.php:84
67
  msgid "Checking Backup Folder"
68
  msgstr ""
69
 
70
+ #: database-backup.php:87
71
  msgid "Backup folder exists"
72
  msgstr ""
73
 
74
+ #: database-backup.php:90
75
  msgid "Backup folder does NOT exist. Please create 'backup-db' folder in 'wp-content' folder and CHMOD it to '777' or change the location of the backup folder under DB Option."
76
  msgstr ""
77
 
78
+ #: database-backup.php:93
79
  msgid "Backup folder is writable"
80
  msgstr ""
81
 
82
+ #: database-backup.php:96
83
  msgid "Backup folder is NOT writable. Please CHMOD it to '777'."
84
  msgstr ""
85
 
86
+ #: database-backup.php:103
87
+ #: database-backup.php:107
88
  msgid "Checking MYSQL Dump Path"
89
  msgstr ""
90
 
91
+ #: database-backup.php:104
92
  msgid "MYSQL dump path exists."
93
  msgstr ""
94
 
95
+ #: database-backup.php:108
96
  msgid "MYSQL dump path does NOT exist. Please check your mysqldump path under DB Options. If uncertain, contact your server administrator."
97
  msgstr ""
98
 
99
+ #: database-backup.php:115
100
+ #: database-backup.php:119
101
  msgid "Checking MYSQL Path"
102
  msgstr ""
103
 
104
+ #: database-backup.php:116
105
  msgid "MYSQL path exists."
106
  msgstr ""
107
 
108
+ #: database-backup.php:120
109
  msgid "MYSQL path does NOT exist. Please check your mysql path under DB Options. If uncertain, contact your server administrator."
110
  msgstr ""
111
 
112
+ #: database-backup.php:125
113
  msgid "Checking PHP Functions"
114
  msgstr ""
115
 
116
+ #: database-backup.php:125
117
  msgid "and"
118
  msgstr ""
119
 
120
+ #: database-backup.php:128
121
+ #: database-backup.php:135
122
+ #: database-backup.php:141
123
  msgid "enabled"
124
  msgstr ""
125
 
126
+ #: database-backup.php:131
127
+ #: database-backup.php:137
128
+ #: database-backup.php:143
129
  msgid "disabled"
130
  msgstr ""
131
 
132
+ #: database-backup.php:151
133
  msgid "Excellent. You Are Good To Go."
134
  msgstr ""
135
 
136
+ #: database-backup.php:153
137
  msgid "I'm sorry, your server administrator has disabled passthru(), system() and exec(), thus you cannot use this backup script. You may consider using the default WordPress database backup script instead."
138
  msgstr ""
139
 
140
+ #: database-backup.php:155
141
  msgid "Please Rectify The Error Highlighted In Red Before Proceeding On."
142
  msgstr ""
143
 
144
+ #: database-backup.php:159
145
  msgid "Note: The checking of backup status is still undergoing testing, it may not be accurate."
146
  msgstr ""
147
 
149
  msgid "Backup Database"
150
  msgstr ""
151
 
152
+ #: database-backup.php:169
153
+ msgid "Option"
154
+ msgstr ""
155
+
156
+ #: database-backup.php:170
157
+ #: database-manager.php:49
158
+ msgid "Value"
159
+ msgstr ""
160
+
161
+ #: database-backup.php:174
162
  msgid "Database Name:"
163
  msgstr ""
164
 
165
+ #: database-backup.php:178
166
  msgid "Database Backup To:"
167
  msgstr ""
168
 
169
+ #: database-backup.php:182
170
  msgid "Database Backup Date:"
171
  msgstr ""
172
 
173
+ #: database-backup.php:186
174
  msgid "Database Backup File Name:"
175
  msgstr ""
176
 
177
+ #: database-backup.php:190
178
  msgid "Database Backup Type:"
179
  msgstr ""
180
 
181
+ #: database-backup.php:191
182
  msgid "Full (Structure and Data)"
183
  msgstr ""
184
 
185
+ #: database-backup.php:194
186
  msgid "MYSQL Dump Location:"
187
  msgstr ""
188
 
189
+ #: database-backup.php:198
190
  msgid "GZIP Database Backup File?"
191
  msgstr ""
192
 
193
+ #: database-backup.php:199
194
+ #: database-optimize.php:86
195
+ #: database-repair.php:82
196
+ #: database-uninstall.php:124
197
+ #: wp-dbmanager.php:464
198
  msgid "Yes"
199
  msgstr ""
200
 
201
+ #: database-backup.php:199
202
+ #: database-optimize.php:86
203
+ #: database-repair.php:82
204
+ #: wp-dbmanager.php:463
205
  msgid "No"
206
  msgstr ""
207
 
208
+ #: database-backup.php:202
209
+ #: database-empty.php:111
210
+ #: database-manage.php:205
211
+ #: database-optimize.php:93
212
+ #: database-repair.php:86
213
+ #: database-run.php:97
 
214
  msgid "Cancel"
215
  msgstr ""
216
 
217
  #: database-empty.php:44
218
+ #: database-empty.php:111
219
  msgid "Empty/Drop"
220
  msgstr ""
221
 
233
  msgid "Table(s) '%s' Dropped"
234
  msgstr ""
235
 
236
+ #: database-empty.php:80
237
+ #: wp-dbmanager.php:49
238
  msgid "Empty/Drop Tables"
239
  msgstr ""
240
 
241
+ #: database-empty.php:85
242
+ #: database-manager.php:83
243
+ #: database-manager.php:116
244
+ #: database-optimize.php:73
245
+ #: database-repair.php:69
246
  msgid "Tables"
247
  msgstr ""
248
 
249
+ #: database-empty.php:86
250
+ #: database-empty.php:99
251
  msgid "Empty"
252
  msgstr ""
253
 
254
+ #: database-empty.php:86
255
+ msgid "1"
256
+ msgstr ""
257
+
258
+ #: database-empty.php:87
259
+ #: database-empty.php:100
260
  msgid "Drop"
261
  msgstr ""
262
 
263
+ #: database-empty.php:87
264
+ msgid "2"
265
+ msgstr ""
266
+
267
+ #: database-empty.php:105
268
+ msgid "1. EMPTYING a table means all the rows in the table will be deleted. This action is not REVERSIBLE."
269
  msgstr ""
270
 
271
+ #: database-empty.php:107
272
+ msgid "2. DROPPING a table means deleting the table. This action is not REVERSIBLE."
273
  msgstr ""
274
 
275
+ #: database-empty.php:111
276
  msgid ""
277
  "You Are About To Empty Or Drop The Selected Databases.\\n"
278
  "This Action Is Not Reversible.\\n"
281
  msgstr ""
282
 
283
  #: database-manage.php:45
284
+ #: database-manage.php:203
285
  msgid "Restore"
286
  msgstr ""
287
 
303
  msgstr ""
304
 
305
  #: database-manage.php:62
306
+ #: database-manage.php:198
307
  msgid "E-Mail"
308
  msgstr ""
309
 
310
  #: database-manage.php:78
311
+ #: wp-dbmanager.php:93
312
  #, php-format
313
  msgid "%s Database Backup File For %s"
314
  msgstr ""
315
 
316
  #: database-manage.php:87
317
+ #: wp-dbmanager.php:102
318
  msgid "Website Name:"
319
  msgstr ""
320
 
321
  #: database-manage.php:88
322
+ #: wp-dbmanager.php:103
323
  msgid "Website URL:"
324
  msgstr ""
325
 
326
  #: database-manage.php:89
327
+ #: wp-dbmanager.php:104
328
  msgid "Backup File Name:"
329
  msgstr ""
330
 
331
  #: database-manage.php:90
332
+ #: wp-dbmanager.php:105
333
  msgid "Backup File Date:"
334
  msgstr ""
335
 
336
  #: database-manage.php:91
337
+ #: wp-dbmanager.php:106
338
  msgid "Backup File Size:"
339
  msgstr ""
340
 
341
  #: database-manage.php:92
342
+ #: wp-dbmanager.php:107
343
  msgid "With Regards,"
344
  msgstr ""
345
 
346
  #: database-manage.php:93
347
+ #: wp-dbmanager.php:108
348
  msgid "Administrator"
349
  msgstr ""
350
 
359
  msgstr ""
360
 
361
  #: database-manage.php:115
362
+ #: database-manage.php:202
363
  msgid "Download"
364
  msgstr ""
365
 
366
  #: database-manage.php:120
367
+ #: database-manage.php:204
368
  msgid "Delete"
369
  msgstr ""
370
 
383
  msgid "Invalid Database Backup File On '%s'"
384
  msgstr ""
385
 
386
+ #: database-manage.php:143
387
  msgid "Manage Backup Database"
388
  msgstr ""
389
 
390
+ #: database-manage.php:144
391
  msgid "Choose A Backup Date To E-Mail, Restore, Download Or Delete"
392
  msgstr ""
393
 
394
+ #: database-manage.php:148
395
+ #: database-manager.php:82
396
  msgid "No."
397
  msgstr ""
398
 
399
+ #: database-manage.php:149
400
  msgid "Database File"
401
  msgstr ""
402
 
403
+ #: database-manage.php:150
404
  msgid "Date/Time"
405
  msgstr ""
406
 
407
+ #: database-manage.php:151
408
  msgid "Size"
409
  msgstr ""
410
 
411
+ #: database-manage.php:152
412
  msgid "Select"
413
  msgstr ""
414
 
415
+ #: database-manage.php:184
416
+ #: database-manage.php:187
417
  msgid "There Are No Database Backup Files Available."
418
  msgstr ""
419
 
420
+ #: database-manage.php:191
421
  msgid "Backup File(s)"
422
  msgstr ""
423
 
424
+ #: database-manage.php:198
425
  msgid "E-mail database backup file to:"
426
  msgstr ""
427
 
428
+ #: database-manage.php:203
429
  msgid ""
430
  "You Are About To Restore A Database.\\n"
431
  "This Action Is Not Reversible.\\n"
434
  " Choose [Cancel] to stop, [Ok] to restore."
435
  msgstr ""
436
 
437
+ #: database-manage.php:204
438
  msgid ""
439
  "You Are About To Delete The Selected Database Backup Files.\\n"
440
  "This Action Is Not Reversible.\\n"
446
  msgid "Database Information"
447
  msgstr ""
448
 
449
+ #: database-manager.php:48
450
  msgid "Setting"
451
  msgstr ""
452
 
453
+ #: database-manager.php:53
 
 
 
 
454
  msgid "Database Host"
455
  msgstr ""
456
 
457
+ #: database-manager.php:57
458
  msgid "Database Name"
459
  msgstr ""
460
 
461
+ #: database-manager.php:61
462
  msgid "Database User"
463
  msgstr ""
464
 
465
+ #: database-manager.php:65
466
  msgid "Database Type"
467
  msgstr ""
468
 
469
+ #: database-manager.php:69
470
  msgid "Database Version"
471
  msgstr ""
472
 
473
+ #: database-manager.php:77
474
  msgid "Tables Information"
475
  msgstr ""
476
 
477
+ #: database-manager.php:84
478
  msgid "Records"
479
  msgstr ""
480
 
481
+ #: database-manager.php:85
482
  msgid "Data Usage"
483
  msgstr ""
484
 
485
+ #: database-manager.php:86
486
  msgid "Index Usage"
487
  msgstr ""
488
 
489
+ #: database-manager.php:87
490
  msgid "Overhead"
491
  msgstr ""
492
 
493
+ #: database-manager.php:115
494
  msgid "Total:"
495
  msgstr ""
496
 
497
+ #: database-manager.php:123
498
  msgid "Could Not Show Table Status Due To Your MYSQL Version Is Lower Than 3.23."
499
  msgstr ""
500
 
513
  msgid "Table(s) '%s' Optimized"
514
  msgstr ""
515
 
516
+ #: database-optimize.php:68
517
  msgid "Optimize Database"
518
  msgstr ""
519
 
520
+ #: database-optimize.php:74
521
+ #: database-repair.php:70
522
  msgid "Options"
523
  msgstr ""
524
 
525
+ #: database-optimize.php:90
526
  msgid "Database should be optimize once every month."
527
  msgstr ""
528
 
529
+ #: database-optimize.php:93
530
  msgid "Optimize"
531
  msgstr ""
532
 
535
  msgid "Table(s) '%s' Repaired"
536
  msgstr ""
537
 
538
+ #: database-repair.php:64
539
  msgid "Repair Database"
540
  msgstr ""
541
 
542
+ #: database-repair.php:86
543
  msgid "Repair"
544
  msgstr ""
545
 
546
  #: database-run.php:41
547
+ #: database-run.php:97
548
  msgid "Run"
549
  msgstr ""
550
 
557
  msgid "Empty Query"
558
  msgstr ""
559
 
560
+ #: database-run.php:86
561
+ #: wp-dbmanager.php:50
562
  msgid "Run SQL Query"
563
  msgstr ""
564
 
565
+ #: database-run.php:89
566
  msgid "Seperate Multiple Queries With A New Line"
567
  msgstr ""
568
 
569
+ #: database-run.php:90
570
  msgid "Use Only INSERT, UPDATE, REPLACE, DELETE, CREATE and ALTER statements."
571
  msgstr ""
572
 
573
+ #: database-run.php:101
574
  msgid "1. CREATE statement will return an error, which is perfectly normal due to the database class. To confirm that your table has been created check the Manage Database page."
575
  msgstr ""
576
 
577
+ #: database-run.php:102
578
  msgid "2. UPDATE statement may return an error sometimes due to the newly updated value being the same as the previous value."
579
  msgstr ""
580
 
581
+ #: database-run.php:103
582
  msgid "3. ALTER statement will return an error because there is no value returned."
583
  msgstr ""
584
 
585
  #: database-uninstall.php:39
586
+ #: database-uninstall.php:125
587
  msgid "UNINSTALL WP-DBManager"
588
  msgstr ""
589
 
610
 
611
  #: database-uninstall.php:78
612
  #: database-uninstall.php:88
613
+ #: wp-dbmanager.php:52
614
  msgid "Uninstall WP-DBManager"
615
  msgstr ""
616
 
639
  msgid "The following WordPress Options will be DELETED:"
640
  msgstr ""
641
 
642
+ #: database-uninstall.php:107
643
  msgid "WordPress Options"
644
  msgstr ""
645
 
646
+ #: database-uninstall.php:125
647
  msgid ""
648
  "You Are About To Uninstall WP-DBManager From WordPress.\\n"
649
  "This Action Is Not Reversible.\\n"
651
  " Choose [Cancel] To Stop, [OK] To Uninstall."
652
  msgstr ""
653
 
654
+ #: wp-dbmanager.php:42
655
  msgid "Database"
656
  msgstr ""
657
 
658
+ #: wp-dbmanager.php:45
659
  msgid "Backup DB"
660
  msgstr ""
661
 
662
+ #: wp-dbmanager.php:46
663
  msgid "Manage Backup DB"
664
  msgstr ""
665
 
666
+ #: wp-dbmanager.php:47
667
  msgid "Optimize DB"
668
  msgstr ""
669
 
670
+ #: wp-dbmanager.php:48
671
  msgid "Repair DB"
672
  msgstr ""
673
 
674
+ #: wp-dbmanager.php:51
675
  msgid "DB Options"
676
  msgstr ""
677
 
678
+ #: wp-dbmanager.php:152
679
  msgid "WP-DBManager Backup Schedule"
680
  msgstr ""
681
 
682
+ #: wp-dbmanager.php:153
683
  msgid "WP-DBManager Optimize Schedule"
684
  msgstr ""
685
 
686
+ #: wp-dbmanager.php:347
687
  msgid "Database Options Updated"
688
  msgstr ""
689
 
690
+ #: wp-dbmanager.php:350
691
  msgid "No Database Option Updated"
692
  msgstr ""
693
 
694
+ #: wp-dbmanager.php:381
695
  msgid "Database Options"
696
  msgstr ""
697
 
698
+ #: wp-dbmanager.php:382
699
  msgid "Paths"
700
  msgstr ""
701
 
702
+ #: wp-dbmanager.php:385
703
  msgid "Path To mysqldump:"
704
  msgstr ""
705
 
706
+ #: wp-dbmanager.php:387
707
+ #: wp-dbmanager.php:394
708
  msgid "Auto Detect"
709
  msgstr ""
710
 
711
+ #: wp-dbmanager.php:388
712
  msgid "The absolute path to mysqldump without trailing slash. If unsure, please email your server administrator about this."
713
  msgstr ""
714
 
715
+ #: wp-dbmanager.php:392
716
  msgid "Path To mysql:"
717
  msgstr ""
718
 
719
+ #: wp-dbmanager.php:395
720
  msgid "The absolute path to mysql without trailing slash. If unsure, please email your server administrator about this."
721
  msgstr ""
722
 
723
+ #: wp-dbmanager.php:399
724
  msgid "Path To Backup:"
725
  msgstr ""
726
 
727
+ #: wp-dbmanager.php:402
728
  msgid "The absolute path to your database backup folder without trailing slash. Make sure the folder is writable."
729
  msgstr ""
730
 
731
+ #: wp-dbmanager.php:406
732
  msgid "Maximum Backup Files:"
733
  msgstr ""
734
 
735
+ #: wp-dbmanager.php:409
736
  msgid "The maximum number of database backup files that is allowed in the backup folder as stated above. The oldest database backup file is always deleted in order to maintain this value. This is to prevent the backup folder from getting too large."
737
  msgstr ""
738
 
739
+ #: wp-dbmanager.php:414
740
+ #: wp-dbmanager.php:432
741
+ msgid "Note"
742
+ msgstr ""
743
+
744
+ #: wp-dbmanager.php:418
745
  msgid "Windows Server"
746
  msgstr ""
747
 
748
+ #: wp-dbmanager.php:419
749
  msgid "For mysqldump path, you can try '<strong>mysqldump.exe</strong>'."
750
  msgstr ""
751
 
752
+ #: wp-dbmanager.php:420
753
  msgid "For mysql path, you can try '<strong>mysql.exe</strong>'."
754
  msgstr ""
755
 
756
+ #: wp-dbmanager.php:425
757
  msgid "Linux Server"
758
  msgstr ""
759
 
760
+ #: wp-dbmanager.php:426
761
  msgid "For mysqldump path, normally is just '<strong>mysqldump</strong>'."
762
  msgstr ""
763
 
764
+ #: wp-dbmanager.php:427
765
  msgid "For mysql path, normally is just '<strong>mysql</strong>'."
766
  msgstr ""
767
 
768
+ #: wp-dbmanager.php:433
 
 
 
 
769
  msgid "The 'Auto Detect' function does not work for some servers. If it does not work for you, please contact your server administrator for the MYSQL and MYSQL DUMP paths."
770
  msgstr ""
771
 
772
+ #: wp-dbmanager.php:438
773
  msgid "Automatic Scheduling"
774
  msgstr ""
775
 
776
+ #: wp-dbmanager.php:441
777
  msgid "Automatic Backing Up Of DB:"
778
  msgstr ""
779
 
780
+ #: wp-dbmanager.php:444
781
  msgid "Next backup date: "
782
  msgstr ""
783
 
784
+ #: wp-dbmanager.php:448
785
+ #: wp-dbmanager.php:479
786
  msgid "N/A"
787
  msgstr ""
788
 
789
+ #: wp-dbmanager.php:452
790
+ #: wp-dbmanager.php:483
791
  msgid "Every"
792
  msgstr ""
793
 
794
+ #: wp-dbmanager.php:454
795
+ #: wp-dbmanager.php:485
796
  msgid "Disable"
797
  msgstr ""
798
 
799
+ #: wp-dbmanager.php:455
800
+ #: wp-dbmanager.php:486
801
+ msgid "Minutes(s)"
802
+ msgstr ""
803
+
804
+ #: wp-dbmanager.php:456
805
+ #: wp-dbmanager.php:487
806
  msgid "Hour(s)"
807
  msgstr ""
808
 
809
+ #: wp-dbmanager.php:457
810
+ #: wp-dbmanager.php:488
811
  msgid "Day(s)"
812
  msgstr ""
813
 
814
+ #: wp-dbmanager.php:458
815
+ #: wp-dbmanager.php:489
816
  msgid "Week(s)"
817
  msgstr ""
818
 
819
+ #: wp-dbmanager.php:459
820
+ #: wp-dbmanager.php:490
821
  msgid "Month(s)"
822
  msgstr ""
823
 
824
+ #: wp-dbmanager.php:461
825
  msgid "Gzip"
826
  msgstr ""
827
 
828
+ #: wp-dbmanager.php:467
829
  msgid "E-mail backup to:"
830
  msgstr ""
831
 
832
+ #: wp-dbmanager.php:467
833
  msgid "(Leave black to disable this feature)"
834
  msgstr ""
835
 
836
+ #: wp-dbmanager.php:468
837
  msgid "WP-DBManager can automatically backup your database after a certain period."
838
  msgstr ""
839
 
840
+ #: wp-dbmanager.php:472
841
  msgid "Automatic Optimizing Of DB:"
842
  msgstr ""
843
 
844
+ #: wp-dbmanager.php:475
845
  msgid "Next optimize date: "
846
  msgstr ""
847
 
848
+ #: wp-dbmanager.php:493
849
  msgid "WP-DBManager can automatically optimize your database after a certain period."
850
  msgstr ""
851
 
852
+ #: wp-dbmanager.php:498
853
+ msgid "Save Changes"
854
  msgstr ""
855