Changeset 14477

Timestamp:

06/24/07 16:12:54 (1 year ago)

Author:

GamerZ

Message:

Added Uninstaller

Files:

• wp-dbmanager/trunk/dbmanager/database-backup.php (modified) (2 diffs)
• wp-dbmanager/trunk/dbmanager/database-empty.php (modified) (1 diff)
• wp-dbmanager/trunk/dbmanager/database-manage.php (modified) (1 diff)
• wp-dbmanager/trunk/dbmanager/database-manager.php (modified) (1 diff)
• wp-dbmanager/trunk/dbmanager/database-optimize.php (modified) (1 diff)
• wp-dbmanager/trunk/dbmanager/database-repair.php (modified) (1 diff)
• wp-dbmanager/trunk/dbmanager/database-run.php (modified) (1 diff)
• wp-dbmanager/trunk/dbmanager/database-uninstall.php (added)
• wp-dbmanager/trunk/dbmanager/dbmanager.php (modified) (8 diffs)
• wp-dbmanager/trunk/dbmanager/wp-dbmanager.mo (modified) (previous)
• wp-dbmanager/trunk/dbmanager/wp-dbmanager.pot (modified) (7 diffs)
• wp-dbmanager/trunk/readme.html (modified) (8 diffs)

wp-dbmanager/trunk/dbmanager/database-backup.php

@@ -3 +3 @@
-+----------------------------------------------------------------+
-|                                                                                                                                         |
-11
+20
-|     Copyright (c) 2007 Lester "GaMerZ" Chan                                                   |
-|                                                                                                                                         |
@@ -51 +51 @@
-                        $backup['command'] = $backup['mysqldumppath'].' --host="'.DB_HOST.'" --user="'.DB_USER.'" --password="'.DB_PASSWORD.'" --add-drop-table '.DB_NAME.' > '.$backup['filepath'];
-                  }
+                  check_backup_files();
-                  passthru($backup['command'], $error);
-                  if(!is_writable($backup['path'])) {

wp-dbmanager/trunk/dbmanager/database-empty.php

@@ -3 +3 @@
-+----------------------------------------------------------------+
-|                                                                                                                                         |
-11
+20
-|     Copyright (c) 2007 Lester "GaMerZ" Chan                                                   |
-|                                                                                                                                         |

wp-dbmanager/trunk/dbmanager/database-manage.php

@@ -3 +3 @@
-+----------------------------------------------------------------+
-|                                                                                                                                         |
-11
+20
-|     Copyright (c) 2007 Lester "GaMerZ" Chan                                                   |
-|                                                                                                                                         |

wp-dbmanager/trunk/dbmanager/database-manager.php

@@ -3 +3 @@
-+----------------------------------------------------------------+
-|                                                                                                                                         |
-11
+20
-|     Copyright (c) 2007 Lester "GaMerZ" Chan                                                   |
-|                                                                                                                                         |

wp-dbmanager/trunk/dbmanager/database-optimize.php

@@ -3 +3 @@
-+----------------------------------------------------------------+
-|                                                                                                                                         |
-11
+20
-|     Copyright (c) 2007 Lester "GaMerZ" Chan                                                   |
-|                                                                                                                                         |

wp-dbmanager/trunk/dbmanager/database-repair.php

@@ -3 +3 @@
-+----------------------------------------------------------------+
-|                                                                                                                                         |
-11
+20
-|     Copyright (c) 2007 Lester "GaMerZ" Chan                                                   |
-|                                                                                                                                         |

wp-dbmanager/trunk/dbmanager/database-run.php

@@ -3 +3 @@
-+----------------------------------------------------------------+
-|                                                                                                                                         |
-11
+20
-|     Copyright (c) 2007 Lester "GaMerZ" Chan                                                   |
-|                                                                                                                                         |

wp-dbmanager/trunk/dbmanager/dbmanager.php

@@ -4 +4 @@
-Plugin URI: http://www.lesterchan.net/portfolio/programming.php
-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.
-11
+20
-Author: Lester 'GaMerZ' Chan
-Author URI: http://www.lesterchan.net
@@ -47 +47 @@
-            add_submenu_page('dbmanager/database-manager.php', __('Run SQL Query', 'wp-dbmanager'), __('Run SQL Query', 'wp-dbmanager'), 'manage_database', 'dbmanager/database-run.php');
-            add_submenu_page('dbmanager/database-manager.php',  __('DB Options', 'wp-dbmanager'),  __('DB Options', 'wp-dbmanager'), 'manage_database', 'dbmanager/dbmanager.php', 'dbmanager_options');
+            add_submenu_page('dbmanager/database-manager.php', __('Uninstall WP-DBManager', 'wp-dbmanager'), __('Uninstall WP-DBManager', 'wp-dbmanager'), 'manage_database', 'dbmanager/database-uninstall.php');
-      }
-}
@@ -76 +77 @@
-                  $backup['command'] = $backup['mysqldumppath'].' --host="'.DB_HOST.'" --user="'.DB_USER.'" --password="'.DB_PASSWORD.'" --add-drop-table '.DB_NAME.' > '.$backup['filepath'];
-            }
+            check_backup_files();
-            passthru($backup['command']);
-            if(!empty($backup_email)) {
@@ -225 +227 @@
-
-
+### Function: Make Sure Maximum Number Of Database Backup Files Does Not Exceed
+function check_backup_files() {
+      $backup_options = get_option('dbmanager_options');
+      $database_files = array();
+      if(!is_emtpy_folder($backup_options['path'])) {
+            if ($handle = opendir($backup_options['path'])) {                 
+                  while (false !== ($file = readdir($handle))) { 
+                        if ($file != '.' && $file != '..' && (file_ext($file) == 'sql' || file_ext($file) == 'gz')) {
+                              $database_files[] = $file;
+                        } 
+                  }
+                  closedir($handle);
+                  sort($database_files);
+            }
+      }
+      if(sizeof($database_files) >= $backup_options['max_backup']) {
+            @unlink($backup_options['path'].'/'.$database_files[0]);
+      }
+}
+
+
-### Function: Database Manager Role
-add_action('activate_dbmanager/dbmanager.php', 'dbmanager_init');
@@ -235 +258 @@
-      $backup_options['mysqlpath'] = $auto['mysql'];
-      $backup_options['path'] = str_replace('\\', '/', ABSPATH).'wp-content/backup-db';
+      $backup_options['max_backup'] = 10;
-      $backup_options['backup'] = 1;
-      $backup_options['backup_gzip'] = 0;
@@ -289 +313 @@
-            $backup_options['mysqlpath'] = trim($_POST['db_mysqlpath']);
-            $backup_options['path'] = trim($_POST['db_path']);
+            $backup_options['max_backup'] = intval($_POST['db_max_backup']);
-            $backup_options['backup'] = intval($_POST['db_backup']);
-            $backup_options['backup_gzip'] = intval($_POST['db_backup_gzip']);
@@ -336 +361 @@
-                  <table class="optiontable">
-                        <tr>
-
-
+width="20%" 
+ width="80%"
-                                    <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="Auto Detect" onclick="mysqldumppath();" />
-                                    <p><?php _e('The absolute path to mysqldump without trailing slash. If unsure, please email your server administrator about this.', 'wp-dbmanager'); ?></p>
@@ -354 +379 @@
-                                    <input type="text" name="db_path" size="60" maxlength="100" value="<?php echo stripslashes($backup_options['path']); ?>" />
-                                    <p><?php _e('The absolute path to your database backup folder without trailing slash. Make sure the folder is writable.', 'wp-dbmanager'); ?></p>
+                              </td>
+                        </tr>
+                        <tr>
+                              <td valign="top"><strong><?php _e('Maximum Backup Files:', 'wp-dbmanager'); ?></strong></td>
+                              <td>
+                                    <input type="text" name="db_max_backup" size="5" maxlength="5" value="<?php echo stripslashes($backup_options['max_backup']); ?>" />
+                                    <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>
-                              </td>
-                        </tr>

wp-dbmanager/trunk/dbmanager/wp-dbmanager.pot

@@ -1 +1 @@
-msgid ""
-msgstr ""
-
+ 2.20
-"POT-Creation-Date: \n"
-5-31 19:2
+6-25 00:0
-"Last-Translator: Lester 'GaMerZ' Chan <gamerz84@hotmail.com>\n"
-"Language-Team: Lester Chan <gamerz84@hotmail.com>\n"
@@ -16 +16 @@
-
-#: database-backup.php:42
-5
+6
-msgid "Backup"
-msgstr ""
-
-5
+6
-#, php-format
-msgid "Database Failed To Backup On '%s'. Backup Folder Not Writable."
-msgstr ""
-
-8
+9
-#, php-format
-msgid "Database Failed To Backup On '%s'. Backup File Size Is 0KB."
-msgstr ""
-
-0
+1
-#, php-format
-msgid "Database Failed To Backup On '%s'. Invalid Backup File Path."
-msgstr ""
-
-2
+3
-#, php-format
-msgid "Database Failed To Backup On '%s'."
-msgstr ""
-
-4
+5
-#, php-format
-msgid "Database Backed Up Successfully On '%s'."
-msgstr ""
-
-2
+3
-msgid "Checking Backup Status"
-msgstr ""
-
-4
+5
-msgid "Checking Backup Folder"
-msgstr ""
-
-7
+8
-msgid "Backup folder exists"
-msgstr ""
-
-0
+1
-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."
-msgstr ""
-
-3
+4
-msgid "Backup folder is writable"
-msgstr ""
-
-6
+7
-msgid "Backup folder is NOT writable. Please CHMOD it to '777'."
-msgstr ""
-
-3
-7
+4
+8
-msgid "Checking MYSQL Dump Path"
-msgstr ""
-
-4
+5
-msgid "MYSQL dump path exists."
-msgstr ""
-
-8
+9
-msgid "MYSQL dump path does NOT exist. Please check your mysqldump path under DB Options. If uncertain, contact your server administrator."
-msgstr ""
-
-5
-19
+6
+20
-msgid "Checking MYSQL Path"
-msgstr ""
-
-6
+7
-msgid "MYSQL path exists."
-msgstr ""
-
-0
+1
-msgid "MYSQL path does NOT exist. Please check your mysql path under DB Options. If uncertain, contact your server administrator."
-msgstr ""
-
-5
+6
-msgid "Checking PHP Functions"
-msgstr ""
-
-5
+6
-msgid "and"
-msgstr ""
-
-8
-5
-1
+9
+6
+2
-msgid "enabled"
-msgstr ""
-
-1
-7
-3
+2
+8
+4
-msgid "disabled"
-msgstr ""
-
-1
+2
-msgid "Excellent. You Are Good To Go."
-msgstr ""
-
-3
+4
-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."
-msgstr ""
-
-5
+6
-msgid "Please Rectify The Error Highlighted In Red Before Proceeding On."
-msgstr ""
-
-59
+60
-msgid "Note: The checking of backup status is still undergoing testing, it may not be accurate."
-msgstr ""
-
-3
+4
-msgid "Backup Database"
-msgstr ""
-
-7
+8
-msgid "Database Name:"
-msgstr ""
-
-1
+2
-msgid "Database Backup To:"
-msgstr ""
-
-5
+6
-msgid "Database Backup Date:"
-msgstr ""
-
-79
+80
-msgid "Database Backup File Name:"
-msgstr ""
-
-3
+4
-msgid "Database Backup Type:"
-msgstr ""
-
-4
+5
-msgid "Full (Structure and Data)"
-msgstr ""
-
-7
+8
-msgid "MYSQL Dump Location:"
-msgstr ""
-
-1
+2
-msgid "GZIP Database Backup File?"
-msgstr ""
-
-2
+3
-#: database-optimize.php:83
-#: database-repair.php:79
-
+
+
-msgid "Yes"
-msgstr ""
-
-2
+3
-#: database-optimize.php:83
-#: database-repair.php:79
-00
+32
-msgid "No"
-msgstr ""
-
-5
+6
-#: database-empty.php:107
-#: database-manage.php:202
@@ -187 +188 @@
-#: database-repair.php:83
-#: database-run.php:93
-33
+65
-msgid "Cancel"
-msgstr ""
@@ -277 +278 @@
-
-#: database-manage.php:79
-89
+91
-#, php-format
-msgid "%s Database Backup File For %s"
@@ -283 +284 @@
-
-#: database-manage.php:88
-98
+100
-msgid "Website Name:"
-msgstr ""
-
-#: database-manage.php:89
-99
+101
-msgid "Website URL:"
-msgstr ""
-
-#: database-manage.php:90
-0
+2
-msgid "Backup File Name:"
-msgstr ""
-
-#: database-manage.php:91
-1
+3
-msgid "Backup File Date:"
-msgstr ""
-
-#: database-manage.php:92
-2
+4
-msgid "Backup File Size:"
-msgstr ""
-
-#: database-manage.php:93
-3
+5
-msgid "With Regards,"
-msgstr ""
-
-#: database-manage.php:94
-4
+6
-msgid "Administrator"
-msgstr ""
@@ -555 +556 @@
-msgstr ""
-
+#: database-uninstall.php:39
+#: database-uninstall.php:123
+msgid "UNINSTALL WP-DBManager"
+msgstr ""
+
+#: database-uninstall.php:47
+#, php-format
+msgid "Setting Key '%s' has been deleted."
+msgstr ""
+
+#: database-uninstall.php:51
+#, php-format
+msgid "Error deleting Setting Key '%s'."
+msgstr ""
+
+#: database-uninstall.php:57
+#: database-uninstall.php:98
+msgid "The database backup files generated by WP-DBManager <strong>WILL NOT</strong> be deleted. You will have to delete it manually."
+msgstr ""
+
+#: database-uninstall.php:59
+#: database-uninstall.php:99
+#, php-format
+msgid "The path to the backup folder is <strong>'%s'</strong>."
+msgstr ""
+
+#: database-uninstall.php:78
+#: database-uninstall.php:88
+#: dbmanager.php:49
+msgid "Uninstall WP-DBManager"
+msgstr ""
+
+#: database-uninstall.php:79
+#, php-format
+msgid "<a href=\"%s\">Click Here</a> To Finish The Uninstallation And WP-DBManager Will Be Deactivated Automatically."
+msgstr ""
+
+#: database-uninstall.php:90
+msgid "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."
+msgstr ""
+
+#: database-uninstall.php:93
+msgid "WARNING:"
+msgstr ""
+
+#: database-uninstall.php:94
+msgid "Once uninstalled, this cannot be undone. You should use a Database Backup plugin of WordPress to back up all the data first."
+msgstr ""
+
+#: database-uninstall.php:97
+msgid "NOTE:"
+msgstr ""
+
+#: database-uninstall.php:102
+msgid "The following WordPress Options will be DELETED:"
+msgstr ""
+
+#: database-uninstall.php:106
+msgid "WordPress Options"
+msgstr ""
+
+#: database-uninstall.php:123
+msgid ""
+"You Are About To Uninstall WP-DBManager From WordPress.\\n"
+"This Action Is Not Reversible.\\n"
+"\\n"
+" Choose [Cancel] To Stop, [OK] To Uninstall."
+msgstr ""
+
-#: dbmanager.php:39
-msgid "Database"
@@ -579 +649 @@
-msgstr ""
-
-299
+324
-msgid "Database Options Updated"
-msgstr ""
-
-02
+27
-msgid "No Database Option Updated"
-msgstr ""
-
-32
+57
-msgid "Database Options"
-msgstr ""
-
-35
+60
-msgid "Paths"
-msgstr ""
-
-38
+63
-msgid "Path To mysqldump:"
-msgstr ""
-
-41
+66
-msgid "The absolute path to mysqldump without trailing slash. If unsure, please email your server administrator about this."
-msgstr ""
-
-45
+70
-msgid "Path To mysql:"
-msgstr ""
-
-48
+73
-msgid "The absolute path to mysql without trailing slash. If unsure, please email your server administrator about this."
-msgstr ""
-
-52
+77
-msgid "Path To Backup:"
-msgstr ""
-
-55
+80
-msgid "The absolute path to your database backup folder without trailing slash. Make sure the folder is writable."
-msgstr ""
-
-
+
+
+
+
+
+
+
+
+
-msgid "Windows Server"
-msgstr ""
-
-61
+93
-msgid "For mysqldump path, you can try '<strong>mysqldump.exe</strong>'."
-msgstr ""
-
-62
+94
-msgid "For mysql path, you can try '<strong>mysql.exe</strong>'."
-msgstr ""
-
-65
+97
-msgid "Linux Server"
-msgstr ""
-
-66
+98
-msgid "For mysqldump path, normally is just '<strong>mysqldump</strong>'."
-msgstr ""
-
-67
+99
-msgid "For mysql path, normally is just '<strong>mysql</strong>'."
-msgstr ""
-
-370
+402
-msgid "Note"
-msgstr ""
-
-371
+403
-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."
-msgstr ""
-
-376
+408
-msgid "Automatic Scheduling"
-msgstr ""
-
-379
+411
-msgid "Automatic Backing Up Of DB:"
-msgstr ""
-
-382
+414
-msgid "Next backup date: "
-msgstr ""
-
-386
-16
+418
+48
-msgid "N/A"
-msgstr ""
-
-390
-20
+422
+52
-msgid "Every"
-msgstr ""
-
-392
-22
+424
+54
-msgid "Disable"
-msgstr ""
-
-393
-23
+425
+55
-msgid "Hour(s)"
-msgstr ""
-
-394
-24
+426
+56
-msgid "Day(s)"
-msgstr ""
-
-395
-25
+427
+57
-msgid "Week(s)"
-msgstr ""
-
-396
-26
+428
+58
-msgid "Month(s)"
-msgstr ""
-
-398
+430
-msgid "Gzip"
-msgstr ""
-
-04
+36
-msgid "E-mail backup to:"
-msgstr ""
-
-04
+36
-msgid "(Leave black to disable this feature)"
-msgstr ""
-
-05
+37
-msgid "WP-DBManager can automatically backup your database after a certain period."
-msgstr ""
-
-09
+41
-msgid "Automatic Optimizing Of DB:"
-msgstr ""
-
-12
+44
-msgid "Next optimize date: "
-msgstr ""
-
-29
+61
-msgid "WP-DBManager can automatically optimize your database after a certain period."
-msgstr ""
-
-33
+65
-msgid "Update Options"
-msgstr ""

wp-dbmanager/trunk/readme.html

@@ -3 +3 @@
-<head>      
-      <meta http-equiv="content-type" content="text/html; charset=utf-8" />
-11
+20
-      <style type="text/css" media="screen">
-            /* Default Style */
@@ -204 +204 @@
-<div id="Container">
-      <!-- Title -->
-11
+20
-
-      <!-- Tabs -->
@@ -230 +230 @@
-                        <script type="text/javascript">
-                              /* <![CDATA[*/
-11
+20
-                              /* ]]> */
-                        </script>
@@ -244 +244 @@
-                  <p>
-                        <strong>Download:</strong><br />
-11
+20
-                        <strong>&raquo;</strong> <a href="http://www.lesterchan.net/others/downloads/wp-dbmanager205.zip" title="http://www.lesterchan.net/others/downloads/wp-dbmanager205.zip">WP-DBManager 2.05 For WordPress 2.0.x</a><br />
-                        <strong>&raquo;</strong> <a href="http://www.lesterchan.net/others/downloads/wp-dbmanager.zip" title="http://www.lesterchan.net/others/downloads/wp-dbmanager.zip">WP-DBManager 1.00 For WordPress 1.5.2</a>
@@ -266 +266 @@
-                  <p>
-                        <strong>Updated:</strong><br />
-June
+October
-                  </p>
-                  <p>
@@ -287 +287 @@
-                  <div class="SubTitle">&raquo; Changelog</div>
-                  <ul>
+                        <li>
+                              <strong>Version 2.20 (01-10-2007)</strong>
+                              <ul>
+                                    <li>NEW: Limit The Maximum Number Of Backup Files In The Backup Folder</li>
+                                    <li>NEW: Ability To Uninstall WP-DBManager</li>
+                              </ul>
-                        <li>
-                              <strong>Version 2.11 (01-06-2007)</strong>
@@ -391 +397 @@
-            <div id="Upgrade" style="display: none;">
-                  <div class="SubTitle">&raquo; Upgrade Instructions</div>
-11
+20
-                  <ol>
-                        <li>
@@ -431 +437 @@
-      </div>
-</div>
-11
+20
-</body>
-</html>