File manager - Edit - /home/palg2351/public_html/klanaobsesiindonesia.com/wp-includes/Text/Diff/Engine/wp-dbmanager.tar
Back
wp-dbmanager.pot 0000644 00000043040 15172701316 0007640 0 ustar 00 msgid "" msgstr "" "Project-Id-Version: WP-DBManager\n" "POT-Creation-Date: 2014-02-19 09:48+0800\n" "PO-Revision-Date: 2014-02-19 09:49+0800\n" "Last-Translator: Lester Chan <lesterchan@gmail.com>\n" "Language-Team: Lester Chan <lesterchan@gmail.com>\n" "Language: en_US\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" "Content-Transfer-Encoding: 8bit\n" "X-Generator: Poedit 1.6.4\n" "X-Poedit-Basepath: ..\n" "X-Poedit-SourceCharset: UTF-8\n" "X-Poedit-KeywordsList: __;_e;_n:1,2;_x:1,2c;_ex:1,2c;_nx:4c,1,2;esc_attr__;" "esc_attr_e;esc_attr_x:1,2c;esc_html__;esc_html_e;esc_html_x:1,2c;_n_noop:1,2;" "_nx_noop:3c,1,2;__ngettext_noop:1,2\n" "Plural-Forms: nplurals=2; plural=(n != 1);\n" "X-Poedit-SearchPath-0: .\n" #: database-backup.php:11 database-backup.php:184 database-manage.php:26 #: database-manage.php:136 wp-dbmanager.php:77 wp-dbmanager.php:248 #: wp-dbmanager.php:627 wp-dbmanager.php:657 wp-dbmanager.php:682 #, php-format msgid "%s @ %s" msgstr "" #: database-backup.php:26 database-backup.php:203 msgid "Backup" msgstr "" #: database-backup.php:53 #, php-format msgid "Database Failed To Backup On '%s'. Backup Folder Not Writable." msgstr "" #: database-backup.php:56 #, php-format msgid "Database Failed To Backup On '%s'. Backup File Size Is 0KB." msgstr "" #: database-backup.php:58 #, php-format msgid "Database Failed To Backup On '%s'. Invalid Backup File Path." msgstr "" #: database-backup.php:60 #, php-format msgid "Database Failed To Backup On '%s'." msgstr "" #: database-backup.php:62 #, php-format msgid "Database Backed Up Successfully On '%s'." msgstr "" #: database-backup.php:81 database-backup.php:165 msgid "Backup Database" msgstr "" #: database-backup.php:82 msgid "Checking Backup Status" msgstr "" #: database-backup.php:84 msgid "Checking Backup Folder" msgstr "" #: database-backup.php:87 msgid "Backup folder exists" msgstr "" #: database-backup.php:90 #, php-format msgid "" "Backup folder does NOT exist. Please create 'backup-db' folder in '%s' " "folder and CHMOD it to '777' or change the location of the backup folder " "under DB Option." msgstr "" #: database-backup.php:93 msgid "Backup folder is writable" msgstr "" #: database-backup.php:96 msgid "Backup folder is NOT writable. Please CHMOD it to '777'." msgstr "" #: database-backup.php:103 database-backup.php:107 msgid "Checking MYSQL Dump Path" msgstr "" #: database-backup.php:104 msgid "MYSQL dump path exists." msgstr "" #: database-backup.php:108 msgid "" "MYSQL dump path does NOT exist. Please check your mysqldump path under DB " "Options. If uncertain, contact your server administrator." msgstr "" #: database-backup.php:115 database-backup.php:119 msgid "Checking MYSQL Path" msgstr "" #: database-backup.php:116 msgid "MYSQL path exists." msgstr "" #: database-backup.php:120 msgid "" "MYSQL path does NOT exist. Please check your mysql path under DB Options. If " "uncertain, contact your server administrator." msgstr "" #: database-backup.php:125 msgid "Checking PHP Functions" msgstr "" #: database-backup.php:125 msgid "and" msgstr "" #: database-backup.php:128 database-backup.php:135 database-backup.php:141 msgid "enabled" msgstr "" #: database-backup.php:131 database-backup.php:137 database-backup.php:143 msgid "disabled" msgstr "" #: database-backup.php:151 msgid "Excellent. You Are Good To Go." msgstr "" #: database-backup.php:153 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 "" #: database-backup.php:155 msgid "Please Rectify The Error Highlighted In Red Before Proceeding On." msgstr "" #: database-backup.php:159 msgid "" "Note: The checking of backup status is still undergoing testing, it may not " "be accurate." msgstr "" #: database-backup.php:170 msgid "Option" msgstr "" #: database-backup.php:171 database-manager.php:33 msgid "Value" msgstr "" #: database-backup.php:175 msgid "Database Name:" msgstr "" #: database-backup.php:179 msgid "Database Backup To:" msgstr "" #: database-backup.php:183 msgid "Database Backup Date:" msgstr "" #: database-backup.php:187 msgid "Database Backup File Name:" msgstr "" #: database-backup.php:191 msgid "Database Backup Type:" msgstr "" #: database-backup.php:192 msgid "Full (Structure and Data)" msgstr "" #: database-backup.php:195 msgid "MYSQL Dump Location:" msgstr "" #: database-backup.php:199 msgid "GZIP Database Backup File?" msgstr "" #: database-backup.php:200 database-optimize.php:74 database-repair.php:75 #: wp-dbmanager.php:645 wp-dbmanager.php:741 msgid "Yes" msgstr "" #: database-backup.php:200 database-optimize.php:74 database-repair.php:75 #: wp-dbmanager.php:644 wp-dbmanager.php:742 msgid "No" msgstr "" #: database-backup.php:203 database-empty.php:99 database-manage.php:168 #: database-optimize.php:81 database-repair.php:79 database-run.php:83 msgid "Cancel" msgstr "" #: database-empty.php:27 database-empty.php:99 msgid "Empty/Drop" msgstr "" #: database-empty.php:40 msgid "No Tables Selected." msgstr "" #: database-empty.php:46 #, php-format msgid "Table '%s' Emptied" msgstr "" #: database-empty.php:51 #, php-format msgid "Table(s) '%s' Dropped" msgstr "" #: database-empty.php:67 wp-dbmanager.php:50 msgid "Empty/Drop Tables" msgstr "" #: database-empty.php:72 database-manager.php:67 database-optimize.php:60 #: database-repair.php:61 msgid "Tables" msgstr "" #: database-empty.php:73 database-empty.php:87 msgid "Empty" msgstr "" #: database-empty.php:73 msgid "1" msgstr "" #: database-empty.php:74 database-empty.php:88 msgid "Drop" msgstr "" #: database-empty.php:74 msgid "2" msgstr "" #: database-empty.php:93 msgid "" "1. EMPTYING a table means all the rows in the table will be deleted. This " "action is not REVERSIBLE." msgstr "" #: database-empty.php:95 msgid "" "2. DROPPING a table means deleting the table. This action is not REVERSIBLE." msgstr "" #: database-empty.php:99 msgid "" "You Are About To Empty Or Drop The Selected Databases.\\nThis Action Is Not " "Reversible.\\n\\n Choose [Cancel] to stop, [Ok] to delete." msgstr "" #: database-manage.php:31 database-manage.php:166 msgid "Restore" msgstr "" #: database-manage.php:53 #, php-format msgid "Database On '%s' Failed To Restore" msgstr "" #: database-manage.php:55 #, php-format msgid "Database On '%s' Restored Successfully" msgstr "" #: database-manage.php:58 database-manage.php:71 database-manage.php:76 #: database-manage.php:91 msgid "No Backup Database File Selected" msgstr "" #: database-manage.php:61 database-manage.php:161 msgid "E-Mail" msgstr "" #: database-manage.php:66 #, php-format msgid "Database Backup File For '%s' Successfully E-Mailed To '%s'" msgstr "" #: database-manage.php:68 #, php-format msgid "Unable To E-Mail Database Backup File For '%s' To '%s'" msgstr "" #: database-manage.php:74 database-manage.php:165 wp-dbmanager.php:451 msgid "Download" msgstr "" #: database-manage.php:79 database-manage.php:167 msgid "Delete" msgstr "" #: database-manage.php:83 #, php-format msgid "Unable To Delete Database Backup File On '%s'" msgstr "" #: database-manage.php:85 #, php-format msgid "Database Backup File On '%s' Deleted Successfully" msgstr "" #: database-manage.php:88 #, php-format msgid "Invalid Database Backup File On '%s'" msgstr "" #: database-manage.php:103 msgid "Manage Backup Database" msgstr "" #: database-manage.php:104 msgid "Choose A Backup Date To E-Mail, Restore, Download Or Delete" msgstr "" #: database-manage.php:108 database-manager.php:66 msgid "No." msgstr "" #: database-manage.php:109 msgid "Database File" msgstr "" #: database-manage.php:110 msgid "Date/Time" msgstr "" #: database-manage.php:111 msgid "Size" msgstr "" #: database-manage.php:112 msgid "Select" msgstr "" #: database-manage.php:147 database-manage.php:150 msgid "There Are No Database Backup Files Available." msgstr "" #: database-manage.php:154 #, php-format msgid "%s Backup File" msgid_plural "%s Backup Files" msgstr[0] "" msgstr[1] "" #: database-manage.php:161 msgid "E-mail database backup file to:" msgstr "" #: database-manage.php:166 msgid "" "You Are About To Restore A Database.\\nThis Action Is Not Reversible.\\nAny " "Data Inserted After The Backup Date Will Be Gone.\\n\\n Choose [Cancel] to " "stop, [Ok] to restore." msgstr "" #: database-manage.php:167 msgid "" "You Are About To Delete The Selected Database Backup Files.\\nThis Action Is " "Not Reversible.\\n\\n Choose [Cancel] to stop, [Ok] to delete." msgstr "" #: database-manager.php:26 wp-dbmanager.php:43 msgid "Database" msgstr "" #: database-manager.php:27 msgid "Database Information" msgstr "" #: database-manager.php:32 msgid "Setting" msgstr "" #: database-manager.php:37 msgid "Database Host" msgstr "" #: database-manager.php:41 msgid "Database Name" msgstr "" #: database-manager.php:45 msgid "Database User" msgstr "" #: database-manager.php:49 msgid "Database Type" msgstr "" #: database-manager.php:53 msgid "Database Version" msgstr "" #: database-manager.php:61 msgid "Tables Information" msgstr "" #: database-manager.php:68 msgid "Records" msgstr "" #: database-manager.php:69 msgid "Data Usage" msgstr "" #: database-manager.php:70 msgid "Index Usage" msgstr "" #: database-manager.php:71 msgid "Overhead" msgstr "" #: database-manager.php:104 msgid "Total:" msgstr "" #: database-manager.php:105 #, php-format msgid "%s Table" msgid_plural "%s Tables" msgstr[0] "" msgstr[1] "" #: database-manager.php:106 #, php-format msgid "%s Record" msgid_plural "%s Records" msgstr[0] "" msgstr[1] "" #: database-manager.php:112 msgid "" "Could Not Show Table Status Due To Your MYSQL Version Is Lower Than 3.23." msgstr "" #: database-optimize.php:19 database-optimize.php:81 msgid "Optimize" msgstr "" #: database-optimize.php:29 database-repair.php:30 msgid "No Tables Selected" msgstr "" #: database-optimize.php:36 #, php-format msgid "Table(s) '%s' NOT Optimized" msgstr "" #: database-optimize.php:38 #, php-format msgid "Table(s) '%s' Optimized" msgstr "" #: database-optimize.php:55 msgid "Optimize Database" msgstr "" #: database-optimize.php:61 database-repair.php:62 msgid "Options" msgstr "" #: database-optimize.php:78 msgid "Database should be optimize once every month." msgstr "" #: database-repair.php:20 database-repair.php:79 msgid "Repair" msgstr "" #: database-repair.php:37 #, php-format msgid "Table(s) '%s' NOT Repaired" msgstr "" #: database-repair.php:39 #, php-format msgid "Table(s) '%s' Repaired" msgstr "" #: database-repair.php:56 msgid "Repair Database" msgstr "" #: database-run.php:24 database-run.php:83 msgid "Run" msgstr "" #: database-run.php:55 msgid "Query(s) Executed Successfully" msgstr "" #: database-run.php:57 database-run.php:60 msgid "Empty Query" msgstr "" #: database-run.php:72 wp-dbmanager.php:51 msgid "Run SQL Query" msgstr "" #: database-run.php:75 msgid "Seperate Multiple Queries With A New Line" msgstr "" #: database-run.php:76 msgid "Use Only INSERT, UPDATE, REPLACE, DELETE, CREATE and ALTER statements." msgstr "" #: database-run.php:87 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." msgstr "" #: database-run.php:88 msgid "" "2. UPDATE statement may return an error sometimes due to the newly updated " "value being the same as the previous value." msgstr "" #: database-run.php:89 msgid "" "3. ALTER statement will return an error because there is no value returned." msgstr "" #: wp-dbmanager.php:46 msgid "Backup DB" msgstr "" #: wp-dbmanager.php:47 msgid "Manage Backup DB" msgstr "" #: wp-dbmanager.php:48 msgid "Optimize DB" msgstr "" #: wp-dbmanager.php:49 msgid "Repair DB" msgstr "" #: wp-dbmanager.php:52 msgid "DB Options" msgstr "" #: wp-dbmanager.php:159 msgid "WP-DBManager Backup Schedule" msgstr "" #: wp-dbmanager.php:160 msgid "WP-DBManager Optimize Schedule" msgstr "" #: wp-dbmanager.php:161 msgid "WP-DBManager Repair Schedule" msgstr "" #: wp-dbmanager.php:179 msgid "Your backup folder is NOT writable" msgstr "" #: wp-dbmanager.php:180 #, php-format msgid "To correct this issue, make the folder <strong>%s</strong> writable." msgstr "" #: wp-dbmanager.php:183 msgid "Your backup folder MIGHT be visible to the public" msgstr "" #: wp-dbmanager.php:184 #, php-format msgid "" "To correct this issue, move the file from <strong>%s</strong> to <strong>%s</" "strong>" msgstr "" #: wp-dbmanager.php:266 msgid "Website Name:" msgstr "" #: wp-dbmanager.php:267 msgid "Website URL:" msgstr "" #: wp-dbmanager.php:268 msgid "Backup File Name:" msgstr "" #: wp-dbmanager.php:269 msgid "Backup File Date:" msgstr "" #: wp-dbmanager.php:270 msgid "Backup File Size:" msgstr "" #: wp-dbmanager.php:271 msgid "With Regards," msgstr "" #: wp-dbmanager.php:272 wp-dbmanager.php:365 msgid "Administrator" msgstr "" #: wp-dbmanager.php:290 msgid "GiB" msgstr "" #: wp-dbmanager.php:292 msgid "MiB" msgstr "" #: wp-dbmanager.php:294 msgid "KiB" msgstr "" #: wp-dbmanager.php:296 msgid "bytes" msgstr "" #: wp-dbmanager.php:368 msgid "%SITE_NAME% Database Backup File For %POST_DATE% @ %POST_TIME%" msgstr "" #: wp-dbmanager.php:501 msgid "Database Options Updated" msgstr "" #: wp-dbmanager.php:504 msgid "No Database Option Updated" msgstr "" #: wp-dbmanager.php:562 msgid "Database Options" msgstr "" #: wp-dbmanager.php:563 msgid "Paths" msgstr "" #: wp-dbmanager.php:566 msgid "Path To mysqldump:" msgstr "" #: wp-dbmanager.php:568 wp-dbmanager.php:575 msgid "Auto Detect" msgstr "" #: wp-dbmanager.php:569 msgid "" "The absolute path to mysqldump without trailing slash. If unsure, please " "email your server administrator about this." msgstr "" #: wp-dbmanager.php:573 msgid "Path To mysql:" msgstr "" #: wp-dbmanager.php:576 msgid "" "The absolute path to mysql without trailing slash. If unsure, please email " "your server administrator about this." msgstr "" #: wp-dbmanager.php:580 msgid "Path To Backup:" msgstr "" #: wp-dbmanager.php:583 msgid "" "The absolute path to your database backup folder without trailing slash. " "Make sure the folder is writable." msgstr "" #: wp-dbmanager.php:587 msgid "Maximum Backup Files:" msgstr "" #: wp-dbmanager.php:590 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." msgstr "" #: wp-dbmanager.php:595 wp-dbmanager.php:613 msgid "Note" msgstr "" #: wp-dbmanager.php:599 msgid "Windows Server" msgstr "" #: wp-dbmanager.php:600 msgid "For mysqldump path, you can try '<strong>mysqldump.exe</strong>'." msgstr "" #: wp-dbmanager.php:601 msgid "For mysql path, you can try '<strong>mysql.exe</strong>'." msgstr "" #: wp-dbmanager.php:606 msgid "Linux Server" msgstr "" #: wp-dbmanager.php:607 msgid "For mysqldump path, normally is just '<strong>mysqldump</strong>'." msgstr "" #: wp-dbmanager.php:608 msgid "For mysql path, normally is just '<strong>mysql</strong>'." msgstr "" #: wp-dbmanager.php:614 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 "" #: wp-dbmanager.php:619 msgid "Automatic Scheduling" msgstr "" #: wp-dbmanager.php:622 msgid "Automatic Backing Up Of DB:" msgstr "" #: wp-dbmanager.php:625 msgid "Next backup date: " msgstr "" #: wp-dbmanager.php:629 wp-dbmanager.php:659 wp-dbmanager.php:684 msgid "N/A" msgstr "" #: wp-dbmanager.php:633 wp-dbmanager.php:663 wp-dbmanager.php:688 msgid "Every" msgstr "" #: wp-dbmanager.php:635 wp-dbmanager.php:665 wp-dbmanager.php:690 msgid "Disable" msgstr "" #: wp-dbmanager.php:636 wp-dbmanager.php:666 wp-dbmanager.php:691 msgid "Minutes(s)" msgstr "" #: wp-dbmanager.php:637 wp-dbmanager.php:667 wp-dbmanager.php:692 msgid "Hour(s)" msgstr "" #: wp-dbmanager.php:638 wp-dbmanager.php:668 wp-dbmanager.php:693 msgid "Day(s)" msgstr "" #: wp-dbmanager.php:639 wp-dbmanager.php:669 wp-dbmanager.php:694 msgid "Week(s)" msgstr "" #: wp-dbmanager.php:640 wp-dbmanager.php:670 wp-dbmanager.php:695 msgid "Month(s)" msgstr "" #: wp-dbmanager.php:642 msgid "Gzip" msgstr "" #: wp-dbmanager.php:648 msgid "" "WP-DBManager can automatically backup your database after a certain period." msgstr "" #: wp-dbmanager.php:652 msgid "Automatic Optimizing Of DB:" msgstr "" #: wp-dbmanager.php:655 msgid "Next optimize date: " msgstr "" #: wp-dbmanager.php:673 msgid "" "WP-DBManager can automatically optimize your database after a certain period." msgstr "" #: wp-dbmanager.php:677 msgid "Automatic Repairing Of DB:" msgstr "" #: wp-dbmanager.php:680 msgid "Next repair date: " msgstr "" #: wp-dbmanager.php:698 msgid "" "WP-DBManager can automatically repair your database after a certain period." msgstr "" #: wp-dbmanager.php:703 msgid "Backup Email Options" msgstr "" #: wp-dbmanager.php:706 msgid "To" msgstr "" #: wp-dbmanager.php:709 msgid "To E-mail" msgstr "" #: wp-dbmanager.php:711 msgid "(Leave blank to disable this feature)" msgstr "" #: wp-dbmanager.php:715 msgid "From" msgstr "" #: wp-dbmanager.php:718 msgid "From Name" msgstr "" #: wp-dbmanager.php:719 msgid "From E-mail" msgstr "" #: wp-dbmanager.php:721 wp-dbmanager.php:730 msgid "(Leave blank to use the default)" msgstr "" #: wp-dbmanager.php:725 msgid "Subject:" msgstr "" #: wp-dbmanager.php:728 msgid "Subject" msgstr "" #: wp-dbmanager.php:735 msgid "Miscellaneous Options" msgstr "" #: wp-dbmanager.php:738 msgid "Hide Admin Notices" msgstr "" #: wp-dbmanager.php:749 msgid "Save Changes" msgstr "" uninstall.php 0000644 00000001462 15172701316 0007274 0 ustar 00 <?php /* * Uninstall plugin */ if ( ! defined( 'WP_UNINSTALL_PLUGIN' ) ) { exit; } if ( is_multisite() ) { $ms_sites = function_exists( 'get_sites' ) ? get_sites() : wp_get_sites(); if ( 0 < sizeof( $ms_sites ) ) { foreach ( $ms_sites as $ms_site ) { $blog_id = class_exists( 'WP_Site' ) ? $ms_site->blog_id : $ms_site['blog_id']; switch_to_blog( $blog_id ); plugin_uninstalled(); } } restore_current_blog(); } else { plugin_uninstalled(); } /** * Delete plugin data when uninstalled * * @access public * @return void */ function plugin_uninstalled() { $option_name = 'dbmanager_options'; delete_option( $option_name ); wp_clear_scheduled_hook( 'dbmanager_cron_backup' ); wp_clear_scheduled_hook( 'dbmanager_cron_optimize' ); wp_clear_scheduled_hook( 'dbmanager_cron_repair' ); } database-run.php 0000644 00000007550 15172701316 0007635 0 ustar 00 <?php ### Check Whether User Can Manage Database if ( ! current_user_can( 'install_plugins' ) ) { die( 'Access Denied' ); } ### Variables Variables Variables $base_name = plugin_basename('wp-dbmanager/database-manager.php'); $base_page = 'admin.php?page='.$base_name; $backup = array(); $backup_options = get_option('dbmanager_options'); $backup['date'] = current_time('timestamp'); $backup['mysqldumppath'] = $backup_options['mysqldumppath']; $backup['mysqlpath'] = $backup_options['mysqlpath']; $backup['path'] = $backup_options['path']; ### Form Processing if(!empty($_POST['do'])) { $text = ''; // Decide What To Do switch($_POST['do']) { case __('Run', 'wp-dbmanager'): check_admin_referer('wp-dbmanager_run'); $sql_queries2 = trim($_POST['sql_query']); $totalquerycount = 0; $successquery = 0; if($sql_queries2) { $sql_queries = array(); $sql_queries2 = explode("\n", $sql_queries2); foreach($sql_queries2 as $sql_query2) { $sql_query2 = trim(stripslashes($sql_query2)); $sql_query2 = preg_replace("/[\r\n]+/", '', $sql_query2); if(!empty($sql_query2)) { $sql_queries[] = $sql_query2; } } if($sql_queries) { foreach( $sql_queries as $sql_query ) { if ( preg_match( "/LOAD_FILE/i", $sql_query ) ) { $text .= "<p style=\"color: red;\">$sql_query</p>"; $totalquerycount++; } elseif( preg_match( "/^\\s*(select|drop|show|grant) /i", $sql_query ) ) { $text .= "<p style=\"color: red;\">$sql_query</p>"; $totalquerycount++; } else if ( preg_match( "/^\\s*(insert|update|replace|delete|create|alter) /i", $sql_query ) ) { $run_query = $wpdb->query( $sql_query ); if( ! $run_query ) { $text .= "<p style=\"color: red;\">$sql_query</p>"; } else { $successquery++; $text .= "<p style=\"color: green;\">$sql_query</p>"; } $totalquerycount++; } } $text .= '<p style="color: blue;">'.number_format_i18n($successquery).'/'.number_format_i18n($totalquerycount).' '.__('Query(s) Executed Successfully', 'wp-dbmanager').'</p>'; } else { $text = '<p style="color: red;">'.__('Empty Query', 'wp-dbmanager').'</p>'; } } else { $text = '<p style="color: red;">'.__('Empty Query', 'wp-dbmanager').'</p>'; } break; } } ?> <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?> <!-- Run SQL Query --> <form method="post" action="<?php echo admin_url('admin.php?page='.plugin_basename(__FILE__)); ?>"> <?php wp_nonce_field('wp-dbmanager_run'); ?> <div class="wrap"> <h2><?php _e('Run SQL Query', 'wp-dbmanager'); ?></h2> <br style="clear" /> <div> <strong><?php _e('Separate Multiple Queries With A New Line', 'wp-dbmanager'); ?></strong><br /> <p style="color: green;"><?php _e('Use Only INSERT, UPDATE, REPLACE, DELETE, CREATE and ALTER statements.', 'wp-dbmanager'); ?></p> </div> <table class="form-table"> <tr> <td align="center"><textarea cols="120" rows="30" name="sql_query" style="width: 99%;" dir="ltr" ></textarea></td> </tr> <tr> <td align="center"><input type="submit" name="do" value="<?php _e('Run', 'wp-dbmanager'); ?>" class="button" /> <input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td> </tr> </table> <p> <?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 /> <?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 /> <?php _e('3. ALTER statement will return an error because there is no value returned.', 'wp-dbmanager'); ?> </p> </div> </form> database-repair.php 0000644 00000005612 15172701316 0010310 0 ustar 00 <?php ### Check Whether User Can Manage Database if ( ! current_user_can( 'install_plugins' ) ) { die( 'Access Denied' ); } ### Variables Variables Variables $base_name = plugin_basename('wp-dbmanager/database-manager.php'); $base_page = 'admin.php?page='.$base_name; ### Form Processing if(!empty($_POST['do'])) { // Lets Prepare The Variables $repair = $_POST['repair']; $text = ''; // Decide What To Do switch($_POST['do']) { case __('Repair', 'wp-dbmanager'): check_admin_referer('wp-dbmanager_repair'); if(!empty($repair)) { $tables_string = ''; foreach($repair as $key => $value) { if($value == 'yes') { $tables_string .= '`, `'.$key; } } } else { $text = '<p style="color: red;">'.__('No Tables Selected', 'wp-dbmanager').'</p>'; } $selected_tables = substr($tables_string, 2); $selected_tables .= '`'; if(!empty($selected_tables)) { $repair2 = $wpdb->query("REPAIR TABLE $selected_tables"); if(!$repair2) { $text = '<p style="color: red;">'.sprintf(__('Table(s) \'%s\' NOT Repaired', 'wp-dbmanager'), str_replace('`', '', $selected_tables)).'</p>'; } else { $text = '<p style="color: green;">'.sprintf(__('Table(s) \'%s\' Repaired', 'wp-dbmanager'), str_replace('`', '', $selected_tables)).'</p>'; } } break; } } ### Show Tables $tables = $wpdb->get_col("SHOW TABLES"); ?> <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?> <!-- Repair Database --> <form method="post" action="<?php echo admin_url('admin.php?page='.plugin_basename(__FILE__)); ?>"> <?php wp_nonce_field('wp-dbmanager_repair'); ?> <div class="wrap"> <h2><?php _e('Repair Database', 'wp-dbmanager'); ?></h2> <br style="clear" /> <table class="widefat"> <thead> <tr> <th><?php _e('Tables', 'wp-dbmanager'); ?></th> <th><?php _e('Options', 'wp-dbmanager'); ?></th> </tr> </thead> <?php $no = 0; foreach($tables as $table_name) { if($no%2 == 0) { $style = ''; } else { $style = ' class="alternate"'; } $no++; echo "<tr $style><th align=\"left\" scope=\"row\">$table_name</th>\n"; echo "<td><input type=\"radio\" id=\"$table_name-no\" name=\"repair[$table_name]\" value=\"no\" /> <label for=\"$table_name-no\">".__('No', 'wp-dbmanager')."</label> <input type=\"radio\" id=\"$table_name-yes\" name=\"repair[$table_name]\" value=\"yes\" checked=\"checked\" /> <label for=\"$table_name-yes\">".__('Yes', 'wp-dbmanager').'</label></td></tr>'; } ?> <tr> <td colspan="2" align="center"><input type="submit" name="do" value="<?php _e('Repair', 'wp-dbmanager'); ?>" class="button" /> <input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td> </tr> </table> </div> </form> htaccess.txt 0000644 00000000072 15172701316 0007104 0 ustar 00 <Files ~ ".*\..*"> order allow,deny deny from all </Files> database-manager.php 0000644 00000007077 15172701316 0010447 0 ustar 00 <?php ### Check Whether User Can Manage Database if ( ! current_user_can( 'install_plugins' ) ) { die( 'Access Denied' ); } ### Variables Variables Variables $base_name = plugin_basename('wp-dbmanager/database-manager.php'); $base_page = 'admin.php?page='.$base_name; $backup = array(); $backup_options = get_option('dbmanager_options'); $backup['date'] = current_time('timestamp'); $backup['mysqldumppath'] = $backup_options['mysqldumppath']; $backup['mysqlpath'] = $backup_options['mysqlpath']; $backup['path'] = $backup_options['path']; ### Get MYSQL Version $sqlversion = $wpdb->get_var("SELECT VERSION() AS version"); ?> <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?> <!-- Database Information --> <div class="wrap"> <h2><?php _e('Database', 'wp-dbmanager'); ?></h2> <h3><?php _e('Database Information', 'wp-dbmanager'); ?></h3> <br style="clear" /> <table class="widefat"> <thead> <tr> <th><?php _e('Setting', 'wp-dbmanager'); ?></th> <th><?php _e('Value', 'wp-dbmanager'); ?></th> </tr> </thead> <tr> <td><?php _e('Database Host', 'wp-dbmanager'); ?></td> <td><?php echo DB_HOST; ?></td> </tr> <tr class="alternate"> <td><?php _e('Database Name', 'wp-dbmanager'); ?></td> <td><?php echo DB_NAME; ?></td> </tr> <tr> <td><?php _e('Database User', 'wp-dbmanager'); ?></td> <td><?php echo DB_USER; ?></td> </tr> <tr class="alternate"> <td><?php _e('Database Type', 'wp-dbmanager'); ?></td> <td>MYSQL</td> </tr> <tr> <td><?php _e('Database Version', 'wp-dbmanager'); ?></td> <td>v<?php echo $sqlversion; ?></td> </tr> </table> </div> <p> </p> <div class="wrap"> <h3><?php _e('Tables Information', 'wp-dbmanager'); ?></h3> <br style="clear" /> <table class="widefat"> <thead> <tr> <th><?php _e('No.', 'wp-dbmanager'); ?></th> <th><?php _e('Tables', 'wp-dbmanager'); ?></th> <th><?php _e('Records', 'wp-dbmanager'); ?></th> <th><?php _e('Data Usage', 'wp-dbmanager'); ?></th> <th><?php _e('Index Usage', 'wp-dbmanager'); ?></th> <th><?php _e('Overhead', 'wp-dbmanager'); ?></th> </tr> </thead> <?php $no = 0; $row_usage = 0; $data_usage = 0; $index_usage = 0; $overhead_usage = 0; $tablesstatus = $wpdb->get_results("SHOW TABLE STATUS"); foreach($tablesstatus as $tablestatus) { if($no%2 == 0) { $style = ''; } else { $style = ' class="alternate"'; } $no++; echo "<tr$style>\n"; echo '<td>'.number_format_i18n($no).'</td>'."\n"; echo "<td>$tablestatus->Name</td>\n"; echo '<td>'.number_format_i18n($tablestatus->Rows).'</td>'."\n"; echo '<td>'.format_size($tablestatus->Data_length).'</td>'."\n"; echo '<td>'.format_size($tablestatus->Index_length).'</td>'."\n";; echo '<td>'.format_size($tablestatus->Data_free).'</td>'."\n"; $row_usage += $tablestatus->Rows; $data_usage += $tablestatus->Data_length; $index_usage += $tablestatus->Index_length; $overhead_usage += $tablestatus->Data_free; echo '</tr>'."\n"; } echo '<tr class="thead">'."\n"; echo '<th>'.__('Total:', 'wp-dbmanager').'</th>'."\n"; echo '<th>'.sprintf(_n('%s Table', '%s Tables', $no, 'wp-dbmanager'), number_format_i18n($no)).'</th>'."\n"; echo '<th>'.sprintf(_n('%s Record', '%s Records', $row_usage, 'wp-dbmanager'), number_format_i18n($row_usage)).'</th>'."\n"; echo '<th>'.format_size($data_usage).'</th>'."\n"; echo '<th>'.format_size($index_usage).'</th>'."\n"; echo '<th>'.format_size($overhead_usage).'</th>'."\n"; echo '</tr>'; ?> </table> </div> readme.txt 0000644 00000021016 15172701316 0006545 0 ustar 00 # WP-DBManager Contributors: GamerZ Donate link: http://lesterchan.net/site/donation/ Tags: database, manage, wp-dbmanager, manager, table, optimize, backup, queries, query, drop, empty, tables, table, run, repair, cron, schedule, scheduling, automatic Requires at least: 4.0 Tested up to: 6.7 Stable tag: 2.80.10 Manages your WordPress database. ## Description 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, optimizing and repairing of database. ## General Usage 1. Activate `WP-DBManager` Plugin 1. The script will automatically create a folder called `backup-db` in the wp-content folder if that folder is writable. If it is not created, please create the folder and ensure that the folder is writable 1. Open `Folder: wp-content/backup-db` 1. If you are on Apache, move the `htaccess.txt` file from `Folder: wp-content/plugins/wp-dbmanager` to `Folder: wp-content/backup-db/.htaccess` if it is not there already 1. If you are on IIS, move the `Web.config.txt` file from `Folder: wp-content/plugins/wp-dbmanager` to `Folder: wp-content/backup-db/Web.config` if it is not there already 1. Move `index.php` file from `Folder: wp-content/plugins/wp-dbmanager` to `Folder: wp-content/backup-db/index.php` if it is not there already 1. Go to `WP-Admin -> Database -> DB Options` to configure the database options ### Build Status [](https://travis-ci.org/lesterchan/wp-dbmanager) ### Development * [https://github.com/lesterchan/wp-dbmanager](https://github.com/lesterchan/wp-dbmanager "https://github.com/lesterchan/wp-dbmanager") ### Translations * [http://dev.wp-plugins.org/browser/wp-dbmanager/i18n/](http://dev.wp-plugins.org/browser/wp-dbmanager/i18n/ "http://dev.wp-plugins.org/browser/wp-dbmanager/i18n/") ### Credits * Plugin icon by [Freepik](http://www.freepik.com) from [Flaticon](http://www.flaticon.com) ### Donations * 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, I will really appreciate it. If not feel free to use it without any obligations. ### Disclaimer * Note that this plugin passes your datababase password via --password in the command line of mysqldump. This is convenient but as a trade off, it is insecure. * On some systems, your password becomes visible to system status programs such as ps that may be invoked by other users to display command lines. MySQL clients typically overwrite the command-line password argument with zeros during their initialization sequence. However, there is still a brief interval during which the value is visible. Also, on some systems this overwriting strategy is ineffective and the password remains visible to ps. Source: [End-User Guidelines for Password Security](http://dev.mysql.com/doc/refman/5.5/en/password-security-user.html) * If this is a concern to you, I recommend another database backup plugin called [WP-DB-Backup](https://wordpress.org/plugins/wp-db-backup/) * To know about the difference between WP-DBManager and WP-DB-backup, checkout __What is the difference between WP-DBManager and WP-DB-Backup?__ in the [FAQ section](https://wordpress.org/plugins/wp-dbmanager/faq/). ## Changelog ### Version 2.80.10 * FIXED: Don't throw fatal error if unknown .sql files are inside the database backup folder. ### Version 2.80.9 * FIXED: Handle folder permissions properly ### Version 2.80.8 * FIXED: Miss out database-backup.php. ### Version 2.80.7 * FIXED: Changed 'edit_files' capability to 'install_plugins' instead. ### Version 2.80.6 * FIXED: Remove 'manage_database' and use 'edit_files' to check for capability instead. ### Version 2.80.5 * FIXED: Changed utf8 to utf8mb4 for backing up ### Version 2.80.4 * FIXED: Clear WP-DBManager cron jobs on uninstall ### Version 2.80.3 * FIXED: Poly fill array_key_first() for PHP < 7.3 ### Version 2.80.2 * FIXED: Newer backup is being replaced instead of older backup ### Version 2.80.1 * FIXED: 1970 date issues. * FIXED: Sorting order of backup files. ### Version 2.80 * NEW: Prefix MD5 checksum to the database backup file to prevent user from guessing the filename. ### Version 2.79.2 * FIXED: Arbitrary file delete bug by sanitizing filename. Props [RIPS Technologies](https://www.ripstech.com). ### Version 2.79.1 * FIXED: Added default utf8 charset ### Version 2.79 * FIXED: Proper check for disabled functions ### Version 2.78.1 * NEW: Bump WordPress 4.7 * FIXED: Undefined index: repair and repair_period ### Version 2.78 * FIXED: escapeshellcmd on Windows. Props Gregory Karpinsky. * FIXED: Move wp_mkdir_p() up before if check. Props Scott Allen. ### Version 2.77 * FIXED: Blank screen downloading backup * FIXED: Remove MySQL Version check to display tables stats ### Version 2.76 * NEW: Add wp_dbmanager_before_escapeshellcmd action just before escapeshellcmd() * FIXED: Missing / for Windows ### Version 2.75 * FIXED: When activating the plugin, copy index.php to the backup folder * FIXED: If you are on Apache, .htaccess will be copied to the backup folder, if you are on IIS, Web.config will be copied to the backup folder * FIXED: When choosing 1 Month(s) for Backup/Optimize/Repair, the next date calculation is wrong ### Version 2.74 * FIXED: escapeshellarg() already escape $, no need to double escape it ### Version 2.73 * FIXED: Unable to backup/restore database if user database password has certain special characters in them ### Version 2.72 * FIXED: Use escapeshellcmd() to escape shell commands. Props Larry W. Cashdollari. * FIXED: Do not allow LOAD_FILE to be run. Props Larry W. Cashdollari. * FIXED: Uses dbmanager_is_valid_path() to check for mysql and mysqldump path. Fixes arbitrary command injection using backup path. Props Larry W. Cashdollari. * FIXED: Uses realpath() to check for backup path. Fixes arbitrary command injection using backup path. Props Larry W. Cashdollari. ### Version 2.71 * NEW: Bump to 4.0 ### Version 2.70 * New: Uses WordPress 3.9 Dashicons * NEW: Allow you to hide admin notices in the DB Options page * NEW: Allow Multisite Network Activate * NEW: Uses WordPress uninstall.php file to uninstall the plugin * NEW: Uses wp_mail() to send email instead of PHP mail() * NEW: New From E-mail, From Name & Subject template * FIXED: Issues with email from field if site title contains , (comma) * FIXED: Notices ### Version 2.65 * FIXED: Set default character set to UTF-8. Props Karsonito ### Version 2.64 * FIXED: Use intval() instead of is_int() when checking for port number. Props [Webby Scots](http://webbyscots.com/ "Webby Scots") ### Version 2.63 (03-05-2011) * NEW: Added Auto Repair Functionality * NEW: Added nonce To All Forms For Added Security ## Screenshots 1. Admin - Backup DB 2. Admin - Empty/Drop Tables In DB 3. Admin - DB Information 4. Admin - Manage DB 5. Admin - Optimize DB 6. Admin - DB Options 7. Admin - DB Options 8. Admin - Repair DB 9. Admin - Run Query in DB ## Frequently Asked Questions ### My database is not backed up / My backup file is 0Kb * Ensure that your host allows you to access mysqldump. You can try to narrow the problem by Debugging via SSH: 1. In `wp-dbmanager.php` 2. Find `check_backup_files();` on line 246 3. Add below it `echo $command;` 4. Go to `WP-Admin -> Database -> Backup` 5. Click `Backup` 6. It should print some debugging statements 7. Copy that line than run it in SSH 8. If you need help on SSH contact your host or google for more info ### What is the difference between WP-DBManager and WP-DB-Backup? * WP-DBManager uses `mysqldump` application to generate the backup and `mysql` application to restore them via shell. * WP-DB-Backup uses PHP to generate the backup. In some cases WP-DB-Backup will work better for you because it requires less permissions. Not all host allows you to access mysqldump/mysql directly via shell. * WP-DBManager allows you to have automatic optimizing and repairing of database on top of backing up of database. ### Why do I get the message "Warning: Your backup folder MIGHT be visible to the public!"? * Ensure that you have renamed `htaccess.txt` to `.htaccess` and placed it in your backup folder (defaults to `wp-content/backup-db/`) * If you are 100% sure you have did that and have verfied that the folder no longer is accessible to the public by visiting the URL `http://yousite.com/wp-content/backup-db/`, you can safely disable the notice by going to `WP-Admin -> Database -> DB Options` and set `Hide Admin Notices` to `Yes`. database-backup.php 0000644 00000031646 15172701316 0010301 0 ustar 00 <?php ### Check Whether User Can Manage Database if ( ! current_user_can( 'install_plugins' ) ) { die( 'Access Denied' ); } ### Variables Variables Variables $base_name = plugin_basename('wp-dbmanager/database-manager.php'); $base_page = 'admin.php?page='.$base_name; $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'))); $backup = array(); $backup_options = get_option('dbmanager_options'); $backup['date'] = current_time('timestamp'); $backup['mysqldumppath'] = $backup_options['mysqldumppath']; $backup['mysqlpath'] = $backup_options['mysqlpath']; $backup['path'] = $backup_options['path']; $backup['charset'] = ' --default-character-set="utf8mb4"'; ### Form Processing if(!empty($_POST['do'])) { $text = ''; // Decide What To Do switch($_POST['do']) { case __('Backup', 'wp-dbmanager'): check_admin_referer('wp-dbmanager_backup'); $brace = 0 === strpos( PHP_OS, 'WIN' ) ? '"' : ''; $backup['host'] = DB_HOST; $backup['port'] = ''; $backup['sock'] = ''; if ( strpos( DB_HOST, ':' ) !== false ) { $db_host = explode(':', DB_HOST); $backup['host'] = $db_host[0]; if ( (int) $db_host[1] !== 0) { $backup['port'] = ' --port=' . escapeshellarg( (int) $db_host[1] ); } else { $backup['sock'] = ' --socket=' . escapeshellarg( $db_host[1] ); } } $gzip = isset( $_POST['gzip'] ) ? (int) $_POST['gzip'] : 0; $backup['filename'] = $backup['date'] . '_-_' . DB_NAME . '.sql'; if ( $gzip === 1 ) { $backup['filename'] .= '.gz'; $backup['filepath'] = $backup['path'] . '/' . $backup['filename']; do_action( 'wp_dbmanager_before_escapeshellcmd' ); $backup['command'] = $brace . escapeshellcmd( $backup['mysqldumppath'] ) . $brace . ' --force --host=' . escapeshellarg( $backup['host'] ) . ' --user=' . escapeshellarg( DB_USER ) . ' --password=' . escapeshellarg( DB_PASSWORD ) . $backup['port'] . $backup['sock'] . $backup['charset'] . ' --add-drop-table --skip-lock-tables ' . DB_NAME . ' | gzip > ' . $brace . escapeshellcmd( $backup['filepath'] ) . $brace; } else { $backup['filepath'] = $backup['path'] . '/' . $backup['filename']; do_action( 'wp_dbmanager_before_escapeshellcmd' ); $backup['command'] = $brace . escapeshellcmd( $backup['mysqldumppath'] ) . $brace . ' --force --host=' . escapeshellarg( $backup['host'] ) . ' --user=' . escapeshellarg( DB_USER ) . ' --password=' . escapeshellarg( DB_PASSWORD ) . $backup['port'] . $backup['sock'] . $backup['charset'] . ' --add-drop-table --skip-lock-tables ' . DB_NAME . ' > ' . $brace . escapeshellcmd( $backup['filepath'] ) . $brace; } $error = execute_backup( $backup['command'] ); if ( ! is_writable( $backup['path'] ) ) { $text = '<p style="color: red;">'.sprintf(__('Database Failed To Backup On \'%s\'. Backup Folder Not Writable.', 'wp-dbmanager'), $current_date).'</p>'; } elseif ( is_file( $backup['filepath'] ) && filesize( $backup['filepath'] ) === 0 ) { $text = '<p style="color: red;">'.sprintf(__('Database Failed To Backup On \'%s\'. Backup File Size Is 0KB.', 'wp-dbmanager'), $current_date).'</p>'; } elseif ( ! is_file( $backup['filepath'] ) ) { $text = '<p style="color: red;">'.sprintf(__('Database Failed To Backup On \'%s\'. Invalid Backup File Path.', 'wp-dbmanager'), $current_date).'</p>'; } elseif ( $error ) { $text = '<p style="color: red;">'.sprintf(__('Database Failed To Backup On \'%s\'.', 'wp-dbmanager'), $current_date).'</p>'; } else { rename( $backup['filepath'], $backup['path'] . '/' . md5_file( $backup['filepath'] ) . '_-_' . $backup['filename'] ); $text = '<p style="color: green;">'.sprintf(__('Database Backed Up Successfully On \'%s\'.', 'wp-dbmanager'), $current_date).'</p>'; } break; } } ### Backup File Name $backup['filename'] = $backup['date'].'_-_'.DB_NAME.'.sql'; $backup_path = stripslashes( $backup['path'] ); ### MYSQL Base Dir $has_error = false; $disabled_function = false; ?> <?php if( ! empty( $text ) ) { echo '<div id="message" class="updated">'.$text.'</div>'; } ?> <!-- Checking Backup Status --> <div class="wrap"> <h2><?php _e('Backup Database', 'wp-dbmanager'); ?></h2> <h3><?php _e('Checking Security Status', 'wp-dbmanager'); ?></h3> <p> <?php if( is_iis() ) { if ( ! is_file( $backup_path . '/Web.config' ) ) { echo '<p style="color: red;">' . sprintf( __( 'Web.config is missing from %s', 'wp-dbmanager' ), $backup_path ) . '</p>'; $has_error = true; } else { echo '<p style="color: green;">' . sprintf( __( 'Web.config is present in %s', 'wp-dbmanager' ), $backup_path ) . '</p>'; } } else { if( ! is_file( $backup_path . '/.htaccess' ) ) { echo '<p style="color: red;">' . sprintf( __( '.htaccess is missing from %s', 'wp-dbmanager' ), $backup_path ) . '</p>'; $has_error = true; } else { echo '<p style="color: green;">' . sprintf( __( '.htaccess is present in %s', 'wp-dbmanager' ), $backup_path ) . '</p>'; } } if( ! is_file( $backup_path . '/index.php' ) ) { echo '<p style="color: red;">' . sprintf( __( 'index.php is missing from %s', 'wp-dbmanager' ), $backup_path ) . '</p>'; $has_error = true; } else { echo '<p style="color: green;">' . sprintf( __( 'index.php is present in %s', 'wp-dbmanager' ), $backup_path ) . '</p>'; } ?> </p> <h3><?php _e('Checking Backup Status', 'wp-dbmanager'); ?></h3> <p> <?php _e('Checking Backup Folder', 'wp-dbmanager'); ?> <span dir="ltr">(<strong><?php echo $backup_path; ?></strong>)</span> ...<br /> <?php if( realpath( $backup_path ) === false ) { echo '<p style="color: red;">' . sprintf( __( '%s is not a valid backup path', 'wp-dbmanager' ), $backup_path ) . '</p>'; $has_error = true; } else { if ( @is_dir( $backup_path ) ) { echo '<p style="color: green;">' . __('Backup folder exists', 'wp-dbmanager') . '</p>'; } else { echo '<p style="color: red;">' . sprintf(__('Backup folder does NOT exist. Please create \'backup-db\' folder in \'%s\' folder and CHMOD it to \'777\' or change the location of the backup folder under DB Option.', 'wp-dbmanager'), WP_CONTENT_DIR) . '</p>'; $has_error = true; } if ( @is_writable( $backup_path ) ) { echo '<p style="color: green;">' . __('Backup folder is writable', 'wp-dbmanager') . '</p>'; } else { echo '<p style="color: red;">' . __('Backup folder is NOT writable. Please CHMOD it to \'777\'.', 'wp-dbmanager') . '</p>'; $has_error = true; } } ?> </p> <p> <?php if( dbmanager_is_valid_path( $backup['mysqldumppath'] ) === 0 ) { echo '<p style="color: red;">' . sprintf( __( '%s is not a valid backup mysqldump path', 'wp-dbmanager' ), stripslashes( $backup['mysqldumppath'] ) ) . '</p>'; $has_error = true; } else { if ( @file_exists( stripslashes( $backup['mysqldumppath'] ) ) ) { echo __('Checking MYSQL Dump Path', 'wp-dbmanager') . ' <span dir="ltr">(<strong>' . stripslashes( $backup['mysqldumppath'] ) . '</strong>)</span> ...<br />'; echo '<p style="color: green;">' . __('MYSQL dump path exists.', 'wp-dbmanager') . '</p>'; } else { echo __('Checking MYSQL Dump Path', 'wp-dbmanager') . ' ...<br />'; echo '<p style="color: red;">' . __('MYSQL dump path does NOT exist. Please check your mysqldump path under DB Options. If uncertain, contact your server administrator.', 'wp-dbmanager') . '</p>'; $has_error = true; } } ?> </p> <p> <?php if( dbmanager_is_valid_path( $backup['mysqlpath'] ) === 0 ) { echo '<p style="color: red;">' . sprintf( __( '%s is not a valid backup mysql path', 'wp-dbmanager' ), stripslashes( $backup['mysqlpath'] ) ) . '</p>'; $has_error = true; } else { if ( @file_exists( stripslashes($backup['mysqlpath'] ) ) ) { echo __('Checking MYSQL Path', 'wp-dbmanager') . ' <span dir="ltr">(<strong>' . stripslashes($backup['mysqlpath']) . '</strong>)</span> ...<br />'; echo '<p style="color: green;">' . __('MYSQL path exists.', 'wp-dbmanager') . '</p>'; } else { echo __('Checking MYSQL Path', 'wp-dbmanager') . ' ...<br />'; echo '<p style="color: red;">' . __('MYSQL path does NOT exist. Please check your mysql path under DB Options. If uncertain, contact your server administrator.', 'wp-dbmanager') . '</p>'; $has_error = true; } } ?> </p> <p> <?php _e('Checking PHP Functions', 'wp-dbmanager'); ?> <span dir="ltr">(<strong>passthru()</strong>, <strong>system()</strong> <?php _e('and', 'wp-dbmanager'); ?> <strong>exec()</strong>)</span> ...<br /> <?php if( dbmanager_is_function_disabled( 'passthru' ) ) { echo '<p style="color: red;"><span dir="ltr">passthru()</span> '.__('disabled', 'wp-dbmanager').'.</p>'; $disabled_function = true; } else if( ! function_exists( 'passthru' ) ) { echo '<p style="color: red;"><span dir="ltr">passthru()</span> '.__('missing', 'wp-dbmanager').'.</p>'; $disabled_function = true; } else { echo '<p style="color: green;"><span dir="ltr">passthru()</span> '.__('enabled', 'wp-dbmanager').'.</p>'; } if( dbmanager_is_function_disabled( 'system' ) ) { echo '<p style="color: red;"><span dir="ltr">system()</span> '.__('disabled', 'wp-dbmanager').'.</p>'; $disabled_function = true; } else if( ! function_exists( 'system' ) ) { echo '<p style="color: red;"><span dir="ltr">system()</span> '.__('missing', 'wp-dbmanager').'.</p>'; $disabled_function = true; } else { echo '<p style="color: green;"><span dir="ltr">system()</span> '.__('enabled', 'wp-dbmanager').'.</p>'; } if( dbmanager_is_function_disabled( 'exec' ) ) { echo '<p style="color: red;"><span dir="ltr">exec()</span> '.__('disabled', 'wp-dbmanager').'.</p>'; $disabled_function = true; } else if( ! function_exists( 'exec' ) ) { echo '<p style="color: red;"><span dir="ltr">exec()</span> '.__('missing', 'wp-dbmanager').'.</p>'; $disabled_function = true; } else { echo '<p style="color: green;"><span dir="ltr">exec()</span> '.__('enabled', 'wp-dbmanager').'.</p>'; } ?> </p> <p> <?php if( $disabled_function ) { echo '<strong><p style="color: red;">' . __( 'I\'m sorry, your server administrator has disabled passthru(), system() and/or exec(), thus you cannot use this plugin. Please find an alternative plugin.', 'wp-dbmanager' ) . '</p></strong>'; } else if( ! $has_error ) { echo '<strong><p style="color: green;">'.__('Excellent. You Are Good To Go.', 'wp-dbmanager').'</p></strong>'; } else { echo '<strong><p style="color: red;">'.__('Please Rectify The Error Highlighted In Red Before Proceeding On.', 'wp-dbmanager').'</p></strong>'; } ?> </p> <p><i><?php _e('Note: The checking of backup status is still undergoing testing, it may not be accurate.', 'wp-dbmanager'); ?></i></p> </div> <!-- Backup Database --> <form method="post" action="<?php echo admin_url('admin.php?page='.plugin_basename(__FILE__)); ?>"> <?php wp_nonce_field('wp-dbmanager_backup'); ?> <div class="wrap"> <h3><?php _e('Backup Database', 'wp-dbmanager'); ?></h3> <br style="clear" /> <table class="widefat"> <thead> <tr> <th><?php _e('Option', 'wp-dbmanager'); ?></th> <th><?php _e('Value', 'wp-dbmanager'); ?></th> </tr> </thead> <tr> <th><?php _e('Database Name:', 'wp-dbmanager'); ?></th> <td><?php echo DB_NAME; ?></td> </tr> <tr style="background-color: #eee;"> <th><?php _e('Database Backup To:', 'wp-dbmanager'); ?></th> <td><span dir="ltr"><?php echo $backup_path; ?></span></td> </tr> <tr> <th><?php _e('Database Backup Date:', 'wp-dbmanager'); ?></th> <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> </tr> <tr style="background-color: #eee;"> <th><?php _e('Database Backup File Name:', 'wp-dbmanager'); ?></th> <td><span dir="ltr"><?php echo $backup['filename']; ?></span></td> </tr> <tr> <th><?php _e('Database Backup Type:', 'wp-dbmanager'); ?></th> <td><?php _e('Full (Structure and Data)', 'wp-dbmanager'); ?></td> </tr> <tr style="background-color: #eee;"> <th><?php _e('MYSQL Dump Location:', 'wp-dbmanager'); ?></th> <td><span dir="ltr"><?php echo stripslashes($backup['mysqldumppath']); ?></span></td> </tr> <tr> <th><?php _e('GZIP Database Backup File?', 'wp-dbmanager'); ?></th> <td><input type="radio" id="gzip-yes" name="gzip" value="1" /> <label for="gzip-yes"><?php _e('Yes', 'wp-dbmanager'); ?></label> <input type="radio" id="gzip-no" name="gzip" value="0" checked="checked" /> <label for="gzip-no"><?php _e('No', 'wp-dbmanager'); ?></label></td> </tr> <tr> <td colspan="2" align="center"><input type="submit" name="do" value="<?php _e('Backup', 'wp-dbmanager'); ?>" class="button" /> <input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td> </tr> </table> </div> </form> index.php 0000644 00000000034 15172701316 0006364 0 ustar 00 <?php // Silence is golden. database-manage.php 0000644 00000021734 15172701316 0010261 0 ustar 00 <?php ### Check Whether User Can Manage Database if ( ! current_user_can( 'install_plugins' ) ) { die( 'Access Denied' ); } ### Variables Variables Variables $base_name = plugin_basename('wp-dbmanager/database-manager.php'); $base_page = 'admin.php?page='.$base_name; $backup = array(); $backup_options = get_option('dbmanager_options'); $backup['date'] = current_time('timestamp'); $backup['mysqldumppath'] = $backup_options['mysqldumppath']; $backup['mysqlpath'] = $backup_options['mysqlpath']; $backup['path'] = $backup_options['path']; $backup['charset'] = ' --default-character-set="utf8mb4"'; ### Form Processing if( !empty( $_POST['do'] ) ) { check_admin_referer('wp-dbmanager_manage'); // Lets Prepare The Variables $database_file = ! empty ( $_POST['database_file'] ) ? sanitize_file_name( $_POST['database_file'] ) : ''; $file = dbmanager_parse_filename( $database_file ); $text = ''; // Decide What To Do switch($_POST['do']) { case __('Restore', 'wp-dbmanager'): if(!empty($database_file)) { $brace = substr(PHP_OS, 0, 3) === 'WIN' ? '"' : ''; $backup['host'] = DB_HOST; $backup['port'] = ''; $backup['sock'] = ''; if(strpos(DB_HOST, ':') !== false) { $db_host = explode(':', DB_HOST); $backup['host'] = $db_host[0]; if ( (int) $db_host[1] !== 0 ) { $backup['port'] = ' --port=' . escapeshellarg( (int) $db_host[1] ); } else { $backup['sock'] = ' --socket=' . escapeshellarg( $db_host[1] ); } } if ( false !== stripos( $database_file, '.gz' ) ) { do_action( 'wp_dbmanager_before_escapeshellcmd' ); $backup['command'] = 'gunzip < ' . $brace . escapeshellcmd( $backup['path'] . '/' . $database_file ) . $brace . ' | ' . $brace . escapeshellcmd( $backup['mysqlpath'] ) . $brace . ' --host=' . escapeshellarg( $backup['host'] ) . ' --user=' . escapeshellarg( DB_USER ) . ' --password=' . escapeshellarg( DB_PASSWORD ) . $backup['port'] . $backup['sock'] . $backup['charset'] . ' ' . DB_NAME; } else { do_action( 'wp_dbmanager_before_escapeshellcmd' ); $backup['command'] = $brace . escapeshellcmd( $backup['mysqlpath'] ) . $brace . ' --host=' . escapeshellarg( $backup['host'] ) . ' --user=' . escapeshellarg( DB_USER ) . ' --password=' . escapeshellarg( DB_PASSWORD ) . $backup['port'] . $backup['sock'] . $backup['charset'] . ' ' . DB_NAME . ' < ' . $brace . escapeshellcmd( $backup['path'] . '/' . $database_file ) . $brace; } if( realpath( $backup['path'] ) === false ) { $text = '<p style="color: red;">' . sprintf(__('%s is not a valid backup path', 'wp-dbmanager'), stripslashes( $backup['path'] ) ) . '</p>'; } else if( dbmanager_is_valid_path( $backup['mysqlpath'] ) === 0 ) { $text = '<p style="color: red;">' . sprintf(__('%s is not a valid mysql path', 'wp-dbmanager'), stripslashes( $backup['mysqlpath'] ) ) . '</p>'; } else { passthru( $backup['command'], $error ); } if($error) { $text = '<p style="color: red;">' . sprintf( __( 'Database On \'%s\' Failed To Restore', 'wp-dbmanager' ), $file['formatted_date'] ) . '</p>'; } else { $text = '<p style="color: green;">' . sprintf( __( 'Database On \'%s\' Restored Successfully', 'wp-dbmanager' ), $file['formatted_date'] ) . '</p>'; } } else { $text = '<p style="color: red;">' . __('No Backup Database File Selected', 'wp-dbmanager' ) . '</p>'; } break; case __('E-Mail', 'wp-dbmanager'): if(!empty($database_file)) { $to = ( !empty( $_POST['email_to'] ) ? sanitize_email( $_POST['email_to'] ) : get_option( 'admin_email' ) ); if( dbmanager_email_backup( $to, $backup['path'] . '/' . $database_file ) ) { $text .= '<p style="color: green;">' . sprintf( __( 'Database Backup File For \'%s\' Successfully E-Mailed To \'%s\'', 'wp-dbmanager' ), $file['formatted_date'], $to) . '</p>'; } else { $text = '<p style="color: red;">' . sprintf( __( 'Unable To E-Mail Database Backup File For \'%s\' To \'%s\'', 'wp-dbmanager' ), $file['formatted_date'], $to ) . '</p>'; } } else { $text = '<p style="color: red;">' . __('No Backup Database File Selected', 'wp-dbmanager' ) . '</p>'; } break; case __('Download', 'wp-dbmanager'): if(empty($database_file)) { $text = '<p style="color: red;">' . __( 'No Backup Database File Selected', 'wp-dbmanager' ) . '</p>'; } break; case __('Delete', 'wp-dbmanager'): if ( ! empty( $database_file ) ) { if ( is_file( $backup['path'] . '/' . $database_file ) ) { if ( ! unlink( $backup['path'] . '/' . $database_file ) ) { $text .= '<p style="color: red;">' . sprintf( __( 'Unable To Delete Database Backup File On \'%s\'', 'wp-dbmanager' ), $file['formatted_date'] ) . '</p>'; } else { $text .= '<p style="color: green;">' . sprintf( __( 'Database Backup File On \'%s\' Deleted Successfully', 'wp-dbmanager' ), $file['formatted_date'] ) . '</p>'; } } else { $text = '<p style="color: red;">' . sprintf( __( 'Invalid Database Backup File On \'%s\'', 'wp-dbmanager' ), $file['formatted_date'] ) . '</p>'; } } else { $text = '<p style="color: red;">' . __( 'No Backup Database File Selected', 'wp-dbmanager' ) . '</p>'; } break; } } ?> <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated">'.$text.'</div>'; } ?> <!-- Manage Backup Database --> <form method="post" action="<?php echo admin_url('admin.php?page='.plugin_basename(__FILE__)); ?>"> <?php wp_nonce_field('wp-dbmanager_manage'); ?> <div class="wrap"> <h2><?php _e('Manage Backup Database', 'wp-dbmanager'); ?></h2> <p><?php _e('Choose A Backup Date To E-Mail, Restore, Download Or Delete', 'wp-dbmanager'); ?></p> <table class="widefat"> <thead> <tr> <th><?php _e('No.', 'wp-dbmanager'); ?></th> <th><?php _e('MD5 Checksum', 'wp-dbmanager'); ?></th> <th><?php _e('Database File', 'wp-dbmanager'); ?></th> <th><?php _e('Date/Time', 'wp-dbmanager'); ?></th> <th><?php _e('Size', 'wp-dbmanager'); ?></th> <th><?php _e('Select', 'wp-dbmanager'); ?></th> </tr> </thead> <?php $no = 0; $totalsize = 0; if ( dbmanager_is_folder_valid( $backup['path'] ) && $handle = opendir( $backup['path'] ) ) { $database_files = array(); while ( false !== ( $file = readdir( $handle ) ) ) { if ( $file !== '.' && $file !== '..' && $file !== '.htaccess' && ( file_ext( $file ) === 'sql' || file_ext( $file ) === 'gz' ) ) { $database_files[filemtime( $backup['path'] . '/' . $file )] = $file; } } closedir( $handle ); krsort( $database_files ); foreach( $database_files as $database_file_mtime => $database_file ) { if ( $no % 2 === 0 ) { $style = ''; } else { $style = ' class="alternate"'; } $no++; $file = dbmanager_parse_file( $backup['path'] . '/'. $database_file ); echo '<tr'. $style .'>'; echo '<td>' . number_format_i18n( $no ) . '</td>'; echo '<td>' . $file['checksum'] . '</td>'; echo '<td>' . $file['database'] . '</td>'; echo '<td>' . $file['formatted_date'] . '</td>'; echo '<td>' . $file['formatted_size'] . '</td>'; echo '<td><input type="radio" name="database_file" value="'. esc_attr( $database_file ) .'" /></td></tr>'; $totalsize += $file['size']; } } else { echo '<tr><td align="center" colspan="6">'.__('There Are No Database Backup Files Available.', 'wp-dbmanager').'</td></tr>'; } ?> <tr class="thead"> <th colspan="4"><?php printf(_n('%s Backup File', '%s Backup Files', $no, 'wp-dbmanager'), number_format_i18n($no)); ?></th> <th><?php echo format_size($totalsize); ?></th> <th> </th> </tr> </table> <table class="form-table"> <tr> <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'); ?>" dir="ltr" /> <input type="submit" name="do" value="<?php _e('E-Mail', 'wp-dbmanager'); ?>" class="button" /></td> </tr> <tr> <td colspan="5" align="center"> <input type="submit" name="do" value="<?php _e('Download', 'wp-dbmanager'); ?>" class="button" /> <input type="submit" name="do" value="<?php _e('Restore', 'wp-dbmanager'); ?>" onclick="return confirm('<?php _e('You Are About To Restore A Database.\nThis Action Is Not Reversible.\nAny Data Inserted After The Backup Date Will Be Gone.\n\n Choose [Cancel] to stop, [Ok] to restore.', 'wp-dbmanager'); ?>')" class="button" /> <input type="submit" class="button" name="do" value="<?php _e('Delete', 'wp-dbmanager'); ?>" onclick="return confirm('<?php _e('You Are About To Delete The Selected Database Backup Files.\nThis Action Is Not Reversible.\n\n Choose [Cancel] to stop, [Ok] to delete.', 'wp-dbmanager'); ?>')" /> <input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="history.go(-1)" /></td> </tr> </table> </div> </form> database-optimize.php 0000644 00000006045 15172701316 0010667 0 ustar 00 <?php ### Check Whether User Can Manage Database if ( ! current_user_can( 'install_plugins' ) ) { die( 'Access Denied' ); } ### Variables Variables Variables $base_name = plugin_basename('wp-dbmanager/database-manager.php'); $base_page = 'admin.php?page='.$base_name; ### Form Processing if(!empty($_POST['do'])) { // Lets Prepare The Variables $optimize = $_POST['optimize']; // Decide What To Do switch($_POST['do']) { case __('Optimize', 'wp-dbmanager'): check_admin_referer('wp-dbmanager_optimize'); if(!empty($optimize)) { $tables_string = ''; foreach($optimize as $key => $value) { if($value == 'yes') { $tables_string .= '`, `'.$key; } } } else { $text = '<p style="color: red;">'.__('No Tables Selected', 'wp-dbmanager').'</p>'; } $selected_tables = substr($tables_string, 3); $selected_tables .= '`'; if(!empty($selected_tables)) { $optimize2 = $wpdb->query("OPTIMIZE TABLE $selected_tables"); if(!$optimize2) { $text = '<p style="color: red;">'.sprintf(__('Table(s) \'%s\' NOT Optimized', 'wp-dbmanager'), str_replace('`', '', $selected_tables)).'</p>'; } else { $text = '<p style="color: green;">'.sprintf(__('Table(s) \'%s\' Optimized', 'wp-dbmanager'), str_replace('`', '', $selected_tables)).'</p>'; } } break; } } ### Show Tables $tables = $wpdb->get_col("SHOW TABLES"); ?> <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?> <!-- Optimize Database --> <form method="post" action="<?php echo admin_url('admin.php?page='.plugin_basename(__FILE__)); ?>"> <?php wp_nonce_field('wp-dbmanager_optimize'); ?> <div class="wrap"> <h2><?php _e('Optimize Database', 'wp-dbmanager'); ?></h2> <br style="clear" /> <table class="widefat"> <thead> <tr> <th><?php _e('Tables', 'wp-dbmanager'); ?></th> <th><?php _e('Options', 'wp-dbmanager'); ?></th> </tr> </thead> <?php $no = 0; foreach($tables as $table_name) { if($no%2 == 0) { $style = ''; } else { $style = ' class="alternate"'; } $no++; echo "<tr$style><th align=\"left\" scope=\"row\">$table_name</th>\n"; echo "<td><input type=\"radio\" id=\"$table_name-no\" name=\"optimize[$table_name]\" value=\"no\" /> <label for=\"$table_name-no\">".__('No', 'wp-dbmanager')."</label> <input type=\"radio\" id=\"$table_name-yes\" name=\"optimize[$table_name]\" value=\"yes\" checked=\"checked\" /> <label for=\"$table_name-yes\">".__('Yes', 'wp-dbmanager').'</label></td></tr>'; } ?> <tr> <td colspan="2" align="center"><?php _e('Database should be optimized once every month.', 'wp-dbmanager'); ?></td> </tr> <tr> <td colspan="2" align="center"><input type="submit" name="do" value="<?php _e('Optimize', 'wp-dbmanager'); ?>" class="button" /> <input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td> </tr> </table> </div> </form> wp-dbmanager.php 0000644 00000120125 15172701316 0007625 0 ustar 00 <?php /* Plugin Name: WP-DBManager Plugin URI: https://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, optimizing and repairing of database. Version: 2.80.10 Author: Lester 'GaMerZ' Chan Author URI: https://lesterchan.net Text Domain: wp-dbmanager */ /* Copyright 2024 Lester Chan (email : lesterchan@gmail.com) This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ ### Create Text Domain For Translations add_action( 'plugins_loaded', 'dbmanager_textdomain' ); function dbmanager_textdomain() { load_plugin_textdomain( 'wp-dbmanager', false, dirname( plugin_basename( __FILE__ ) ) ); } ### Function: Database Manager Menu add_action('admin_menu', 'dbmanager_menu'); function dbmanager_menu() { if (function_exists('add_menu_page')) { add_menu_page(__('Database', 'wp-dbmanager'), __('Database', 'wp-dbmanager'), 'install_plugins', 'wp-dbmanager/database-manager.php', '', 'dashicons-archive'); } if (function_exists('add_submenu_page')) { add_submenu_page('wp-dbmanager/database-manager.php', __('Backup DB', 'wp-dbmanager'), __('Backup DB', 'wp-dbmanager'), 'install_plugins', 'wp-dbmanager/database-backup.php'); add_submenu_page('wp-dbmanager/database-manager.php', __('Manage Backup DB', 'wp-dbmanager'), __('Manage Backup DB', 'wp-dbmanager'), 'install_plugins', 'wp-dbmanager/database-manage.php'); add_submenu_page('wp-dbmanager/database-manager.php', __('Optimize DB', 'wp-dbmanager'), __('Optimize DB', 'wp-dbmanager'), 'install_plugins', 'wp-dbmanager/database-optimize.php'); add_submenu_page('wp-dbmanager/database-manager.php', __('Repair DB', 'wp-dbmanager'), __('Repair DB', 'wp-dbmanager'), 'install_plugins', 'wp-dbmanager/database-repair.php'); add_submenu_page('wp-dbmanager/database-manager.php', __('Empty/Drop Tables', 'wp-dbmanager'), __('Empty/Drop Tables', 'wp-dbmanager'), 'install_plugins', 'wp-dbmanager/database-empty.php'); add_submenu_page('wp-dbmanager/database-manager.php', __('Run SQL Query', 'wp-dbmanager'), __('Run SQL Query', 'wp-dbmanager'), 'install_plugins', 'wp-dbmanager/database-run.php'); add_submenu_page('wp-dbmanager/database-manager.php', __('DB Options', 'wp-dbmanager'), __('DB Options', 'wp-dbmanager'), 'install_plugins', 'wp-dbmanager/wp-dbmanager.php', 'dbmanager_options'); } } ### Function: Append get_allowed_mime_types() add_filter( 'upload_mimes', 'dbmanager_upload_mimes' ); function dbmanager_upload_mimes( $mime_types ) { $mime_types['sql'] = 'application/sql'; return $mime_types; } ### Function: Database Manager Cron add_filter('cron_schedules', 'cron_dbmanager_reccurences'); add_action('dbmanager_cron_backup', 'cron_dbmanager_backup'); add_action('dbmanager_cron_optimize', 'cron_dbmanager_optimize'); add_action('dbmanager_cron_repair', 'cron_dbmanager_repair'); function cron_dbmanager_backup() { $backup_options = get_option('dbmanager_options'); // Enesure that backup path is valid before proceeding if ( empty( $backup_options['path'] ) || ! dbmanager_is_folder_valid( $backup_options['path'] ) ) { return; } if ( (int) $backup_options['backup_period'] > 0 ) { $backup = array(); $backup['date'] = current_time('timestamp'); $backup['mysqldumppath'] = $backup_options['mysqldumppath']; $backup['mysqlpath'] = $backup_options['mysqlpath']; $backup['path'] = $backup_options['path']; $backup['charset'] = ' --default-character-set="utf8mb4"'; $backup['host'] = DB_HOST; $backup['port'] = ''; $backup['sock'] = ''; if ( strpos( DB_HOST, ':' ) !== false ) { $db_host = explode(':', DB_HOST); $backup['host'] = $db_host[0]; if ( (int) $db_host[1] !== 0 ) { $backup['port'] = ' --port=' . escapeshellarg( (int) $db_host[1] ); } else { $backup['sock'] = ' --socket=' . escapeshellarg( $db_host[1] ); } } $backup['command'] = ''; $backup['filename'] = $backup['date'] . '_-_' . DB_NAME . '.sql'; $brace = 0 === strpos( PHP_OS, 'WIN' ) ? '"' : ''; if ( (int) $backup_options['backup_gzip'] === 1 ) { $backup['filename'] .= '.gz'; $backup['filepath'] = $backup['path'] . '/'. $backup['filename']; do_action( 'wp_dbmanager_before_escapeshellcmd' ); $backup['command'] = $brace . escapeshellcmd( $backup['mysqldumppath'] ) . $brace . ' --force --host=' . escapeshellarg( $backup['host'] ).' --user=' . escapeshellarg( DB_USER ) . ' --password=' . escapeshellarg( DB_PASSWORD ) . $backup['port'] . $backup['sock'] . $backup['charset'] . ' --add-drop-table --skip-lock-tables ' . DB_NAME . ' | gzip > '. $brace . escapeshellcmd( $backup['filepath'] ) . $brace; } else { $backup['filepath'] = $backup['path'] . '/'. $backup['filename']; do_action( 'wp_dbmanager_before_escapeshellcmd' ); $backup['command'] = $brace . escapeshellcmd( $backup['mysqldumppath'] ) . $brace . ' --force --host=' . escapeshellarg( $backup['host'] ).' --user=' . escapeshellarg( DB_USER ). ' --password=' . escapeshellarg( DB_PASSWORD ) . $backup['port'] . $backup['sock'] . $backup['charset'] . ' --add-drop-table --skip-lock-tables ' . DB_NAME . ' > ' . $brace . escapeshellcmd( $backup['filepath'] ) . $brace; } execute_backup( $backup['command'] ); $new_filepath = $backup['path'] . '/' . md5_file( $backup['filepath'] ) . '_-_' . $backup['filename']; rename( $backup['filepath'], $new_filepath ); $backup_email = stripslashes( $backup_options['backup_email'] ); if ( ! empty( $backup_email ) ) { dbmanager_email_backup( $backup_email, $new_filepath ); } } } function cron_dbmanager_optimize() { global $wpdb; $backup_options = get_option('dbmanager_options'); $optimize_period = (int) $backup_options['optimize_period']; if($optimize_period > 0) { $optimize_tables = array(); $tables = $wpdb->get_col("SHOW TABLES"); foreach($tables as $table_name) { $optimize_tables[] = '`'.$table_name.'`'; } $wpdb->query('OPTIMIZE TABLE '.implode(',', $optimize_tables)); } } function cron_dbmanager_repair() { global $wpdb; $backup_options = get_option('dbmanager_options'); $repair_period = (int) $backup_options['repair_period']; if($repair_period > 0) { $repair_tables = array(); $tables = $wpdb->get_col("SHOW TABLES"); foreach($tables as $table_name) { $repair_tables[] = '`'.$table_name.'`'; } $wpdb->query('REPAIR TABLE '.implode(',', $repair_tables)); } } function cron_dbmanager_reccurences($schedules) { $backup_options = get_option( 'dbmanager_options' ); if( isset( $backup_options['backup'] ) && isset( $backup_options['backup_period'] ) ) { $backup = (int) $backup_options['backup'] * (int) $backup_options['backup_period']; } else { $backup = 0; } if( isset( $backup_options['optimize'] ) && isset( $backup_options['optimize_period'] ) ) { $optimize = (int) $backup_options['optimize'] * (int) $backup_options['optimize_period']; } else { $optimize = 0; } if( isset( $backup_options['repair'] ) && isset( $backup_options['repair_period'] ) ) { $repair = (int) $backup_options['repair'] * (int) $backup_options['repair_period']; } else { $repair = 0; } if( $backup === 0 ) { $backup = 31536000; } if( $optimize === 0 ) { $optimize = 31536000; } if( $repair === 0 ) { $repair = 31536000; } $schedules['dbmanager_backup'] = array( 'interval' => $backup, 'display' => __( 'WP-DBManager Backup Schedule', 'wp-dbmanager' ) ); $schedules['dbmanager_optimize'] = array( 'interval' => $optimize, 'display' => __( 'WP-DBManager Optimize Schedule', 'wp-dbmanager' ) ); $schedules['dbmanager_repair'] = array( 'interval' => $repair, 'display' => __( 'WP-DBManager Repair Schedule', 'wp-dbmanager' ) ); return $schedules; } ### Function: Ensure .htaccess Is In The Backup Folder add_action( 'admin_notices', 'dbmanager_admin_notices' ); function dbmanager_admin_notices() { $backup_options = get_option( 'dbmanager_options' ); $backup_folder_writable = ( is_dir( $backup_options['path'] ) && wp_is_writable( $backup_options['path'] ) ); $htaccess_exists = file_exists( $backup_options['path'] . '/.htaccess' ); $webconfig_exists = file_exists( $backup_options['path'] . '/Web.config' ); $index_exists = file_exists( $backup_options['path'] . '/index.php' ); if( ! isset( $backup_options['hide_admin_notices'] ) || (int) $backup_options['hide_admin_notices'] === 0 ) { if( ! $backup_folder_writable || ! $index_exists || ( is_iis() && ! $webconfig_exists ) || ( ! is_iis() && ! $htaccess_exists ) ) { echo '<div class="error">'; if( !$backup_folder_writable ) { echo '<p style="font-weight: bold;">' . __( 'Your backup folder is NOT writable', 'wp-postratings') . '</p>'; echo '<p>'.sprintf( __( 'To correct this issue, make the folder <strong>%s</strong> writable.', 'wp-dbmanager' ), $backup_options['path'] ).'</p>'; } if( ! $index_exists || ( is_iis() && ! $webconfig_exists ) || ( ! is_iis() && ! $htaccess_exists ) ) { echo '<p style="font-weight: bold;">'.__( 'Your backup folder MIGHT be visible to the public', 'wp-dbmanager' ).'</p>'; } if( is_iis() ) { if( ! $webconfig_exists ) { echo '<p>'.sprintf( __( 'To correct this issue, move the file from <strong>%s</strong> to <strong>%s</strong>', 'wp-dbmanager'), plugin_dir_path( __FILE__ ) . 'Web.config.txt', $backup_options['path'] .'/Web.config' ).'</p>'; } } else { if( ! $htaccess_exists ) { echo '<p>'.sprintf( __( 'To correct this issue, move the file from <strong>%s</strong> to <strong>%s</strong>', 'wp-dbmanager'), plugin_dir_path( __FILE__ ) . 'htaccess.txt', $backup_options['path'] .'/.htaccess' ).'</p>'; } } if( ! $index_exists ) { echo '<p>'.sprintf( __( 'To correct this issue, move the file from <strong>%s</strong> to <strong>%s</strong>', 'wp-dbmanager'), plugin_dir_path( __FILE__ ) . 'index.php', $backup_options['path'] .'/index.php' ).'</p>'; } echo '<p>' . sprintf( __( '<a href="%s">Click here</a> to let WP-DBManager try to fix it', 'wp-dbmanager' ), wp_nonce_url( admin_url( 'admin.php?page=wp-dbmanager/database-backup.php&try_fix=1' ), 'wp-dbmanager_fix' ) ) . '</a></p>'; echo '</div>'; } } } ### Function: Auto Detect MYSQL and MYSQL Dump Paths function detect_mysql() { global $wpdb; $paths = array('mysq' => '', 'mysqldump' => ''); if ( substr( PHP_OS,0,3 ) === 'WIN' ) { $mysql_install = $wpdb->get_row("SHOW VARIABLES LIKE 'basedir'"); if($mysql_install) { $install_path = trailingslashit( str_replace('\\', '/', $mysql_install->Value) ); $paths['mysql'] = $install_path.'bin/mysql.exe'; $paths['mysqldump'] = $install_path.'bin/mysqldump.exe'; } else { $paths['mysql'] = 'mysql.exe'; $paths['mysqldump'] = 'mysqldump.exe'; } } else { if(function_exists('exec')) { $paths['mysql'] = @exec('which mysql'); $paths['mysqldump'] = @exec('which mysqldump'); } else { $paths['mysql'] = 'mysql'; $paths['mysqldump'] = 'mysqldump'; } } return $paths; } ### Function: Check if WordPress is installed on IIS function is_iis() { $server_software = strtolower( $_SERVER['SERVER_SOFTWARE'] ); if ( strpos( $server_software, 'microsoft-iis') !== false ) { return true; } return false; } ### Executes OS-Dependent mysqldump Command (By: Vlad Sharanhovich) function execute_backup($command) { $backup_options = get_option('dbmanager_options'); check_backup_files(); if( realpath( $backup_options['path'] ) === false ) { return sprintf( __( '%s is not a valid backup path', 'wp-dbmanager' ), stripslashes( $backup_options['path'] ) ); } else if( dbmanager_is_valid_path( $backup_options['mysqldumppath'] ) === 0 ) { return sprintf( __( '%s is not a valid mysqldump path', 'wp-dbmanager' ), stripslashes( $backup_options['mysqldumppath'] ) ); } else if( dbmanager_is_valid_path( $backup_options['mysqlpath'] ) === 0 ) { return sprintf( __( '%s is not a valid mysql path', 'wp-dbmanager' ), stripslashes( $backup_options['mysqlpath'] ) ); } if( substr( PHP_OS, 0, 3 ) === 'WIN' ) { $writable_dir = $backup_options['path']; $tmpnam = $writable_dir.'/wp-dbmanager.bat'; $fp = fopen( $tmpnam, 'w' ); fwrite ($fp, $command ); fclose( $fp ); system( $tmpnam.' > NUL', $error ); unlink( $tmpnam ); } else { passthru( $command, $error ); } return $error; } ### Function: Check for valid file path function dbmanager_is_valid_path( $path ) { return preg_match( '/^[^*?"<>|;]*$/', $path ); } ### Functionn : Breakdown the file name into array function dbmanager_parse_filename( $filename ) { $file_parts = explode( '_-_', $filename ); if ( count( $file_parts ) > 2 ) { $file = array( 'checksum' => $file_parts[0], 'timestamp' => $file_parts[1], 'database' => $file_parts[2], ); } else { $file = array( 'checksum' => '-', 'timestamp' => $file_parts[0], 'database' => ! empty( $file_parts[1] ) ? $file_parts[1] : $filename, ); } $file['name'] = $filename; if ( is_numeric( $file['timestamp'] ) ) { $file['formatted_date'] = mysql2date( sprintf( __( '%s @ %s', 'wp-dbmanager' ), get_option( 'date_format' ), get_option( 'time_format' ) ), gmdate( 'Y-m-d H:i:s', $file['timestamp'] ) ); } else { $file['formatted_date'] = '-'; } return $file; } ### Functionn : Return extra information like file size and nice date of the file function dbmanager_parse_file( $filepath ) { $filename = basename( $filepath ); $file_parts = dbmanager_parse_filename( $filename ); $file_parts['path'] = dirname( $filepath ); $file_parts['size'] = filesize( $filepath ); $file_parts['formatted_size'] = format_size( $file_parts['size'] ); return $file_parts; } ### Function: Email database backup function dbmanager_email_backup( $to, $backup_file_path ) { $to = ( !empty( $to ) ? $to : get_option( 'admin_email' ) ); if( is_email( $to ) && file_exists( $backup_file_path ) ) { $backup_options = get_option( 'dbmanager_options' ); $file = dbmanager_parse_file( $backup_file_path ); $file_gmt_date = gmdate( 'Y-m-d H:i:s', $file['timestamp'] ); $subject = ( ! empty( $backup_options['backup_email_subject'] ) ? $backup_options['backup_email_subject'] : dbmanager_default_options( 'backup_email_subject' ) ); $subject = str_replace( array( '%SITE_NAME%', '%POST_DATE%', '%POST_TIME%' ), array( wp_specialchars_decode( get_bloginfo( 'name' ), ENT_QUOTES ), mysql2date( get_option( 'date_format' ), $file_gmt_date ), mysql2date( get_option( 'time_format' ), $file_gmt_date ) ) , $subject ); $message = __( 'Website Name:', 'wp-dbmanager' ) . ' ' . wp_specialchars_decode( get_bloginfo( 'name' ), ENT_QUOTES ) . "\n" . __( 'Website URL:', 'wp-dbmanager' ) . ' '. get_bloginfo( 'url' ) . "\n\n" . __( 'Backup File Name:', 'wp-dbmanager' ) . ' ' . $file['name'] . "\n" . __( 'Backup File MD5 Checksum:', 'wp-dbmanager' ) . ' ' . $file['checksum'] . "\n" . __( 'Backup File Date:', 'wp-dbmanager' ) . ' ' . $file['formatted_date'] . "\n" . __( 'Backup File Size:', 'wp-dbmanager' ) . ' ' . $file['formatted_size'] . "\n\n" . __( 'With Regards,', 'wp-dbmanager' )."\n". wp_specialchars_decode( get_bloginfo( 'name' ), ENT_QUOTES ) . ' ' . __('Administrator', 'wp-dbmanager' ) . "\n" . get_bloginfo( 'url' ); $from = ( ! empty( $backup_options['backup_email_from'] ) ? $backup_options['backup_email_from'] : dbmanager_default_options( 'backup_email_from' ) ); $from_name = ( ! empty( $backup_options['backup_email_from_name'] ) ? $backup_options['backup_email_from_name'] : dbmanager_default_options( 'backup_email_from_name' ) ); $headers[] = 'From: "' . wp_specialchars_decode( stripslashes_deep( $from_name ), ENT_QUOTES ) . '" <' . $from . '>'; return wp_mail( $to, $subject, $message, $headers, $backup_file_path ); } return false; } ### Function: Format Bytes Into KB/MB if(!function_exists('format_size')) { function format_size($rawSize) { if($rawSize / 1073741824 > 1) return number_format_i18n($rawSize/1048576, 1) . ' '.__('GiB', 'wp-dbmanager'); else if ($rawSize / 1048576 > 1) return number_format_i18n($rawSize/1048576, 1) . ' '.__('MiB', 'wp-dbmanager'); else if ($rawSize / 1024 > 1) return number_format_i18n($rawSize/1024, 1) . ' '.__('KiB', 'wp-dbmanager'); else return number_format_i18n($rawSize, 0) . ' '.__('bytes', 'wp-dbmanager'); } } ### Function: Get File Extension if(!function_exists('file_ext')) { function file_ext($file_name) { return substr(strrchr($file_name, '.'), 1); } } ### Function: Check Folder Whether There Are Any Files Inside function dbmanager_is_folder_valid( $folder ){ // Check folder whether it is readable if ( ! is_readable( $folder ) ) { return false; } // Ensure folder is a directory if ( ! is_dir( $folder ) ) { return false; } // Ensure folder is not empty. 2 because it includes '.' and '..' if ( scandir( $folder ) <= 2 ) { return false; } return true; } ### 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 ( dbmanager_is_folder_valid( $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[ filemtime( $backup_options['path'] . '/' . $file ) ] = $file; } } closedir( $handle ); ksort( $database_files ); } } if ( sizeof( $database_files ) >= $backup_options['max_backup'] ) { @unlink( $backup_options['path'] . '/' . $database_files[ array_key_first( $database_files ) ] ); } } ### Function: DBManager Default Options function dbmanager_default_options( $option_name ) { switch( $option_name ) { case 'backup_email_from': return get_option( 'admin_email' ); break; case 'backup_email_from_name': return wp_specialchars_decode( get_bloginfo( 'name' ), ENT_QUOTES ) .' '.__( 'Administrator', 'wp-dbmanager' ); break; case 'backup_email_subject': return __( '%SITE_NAME% Database Backup File For %POST_DATE% @ %POST_TIME%', 'wp-dbmanager' ); break; case 'hide_admin_notices': return 0; break; } } ### Function: Acticate Plugin register_activation_hook( __FILE__, 'dbmanager_activation' ); function dbmanager_activation( $network_wide ) { $auto = detect_mysql(); // Add Options $option_name = 'dbmanager_options'; $option = array( 'mysqldumppath' => $auto['mysqldump'] , 'mysqlpath' => $auto['mysql'] , 'path' => str_replace( '\\', '/', WP_CONTENT_DIR ).'/backup-db' , 'max_backup' => 10 , 'backup' => 1 , 'backup_gzip' => 0 , 'backup_period' => 604800 , 'backup_email' => get_option( 'admin_email' ) , 'backup_email_from' => dbmanager_default_options( 'backup_email_from' ) , 'backup_email_from_name' => dbmanager_default_options( 'backup_email_from_name' ) , 'backup_email_subject' => dbmanager_default_options( 'backup_email_subject' ) , 'optimize' => 3 , 'optimize_period' => 86400 , 'repair' => 2 , 'repair_period' => 604800 , 'hide_admin_notices' => 0 ); if ( is_multisite() && $network_wide ) { $ms_sites = function_exists( 'get_sites' ) ? get_sites() : wp_get_sites(); if( 0 < sizeof( $ms_sites ) ) { foreach ( $ms_sites as $ms_site ) { $blog_id = class_exists( 'WP_Site' ) ? $ms_site->blog_id : $ms_site['blog_id']; switch_to_blog( $blog_id ); add_option( $option_name, $option ); dbmanager_activate(); } } restore_current_blog(); } else { add_option( $option_name, $option ); dbmanager_activate(); } } function dbmanager_activate() { dbmanager_create_backup_folder(); // Remove 'manage_database', we use 'install_plugins' from 2.80.6 $role = get_role( 'administrator' ); if( $role->has_cap( 'manage_database') ) { $role->remove_cap( 'manage_database' ); } } function dbmanager_create_backup_folder() { $plugin_path = plugin_dir_path( __FILE__ ); $backup_path = WP_CONTENT_DIR . '/backup-db'; $backup_options = get_option( 'dbmanager_options' ); if( ! empty( $backup_options['path'] ) ) { $backup_path = $backup_options['path']; } // Create Backup Folder wp_mkdir_p( $backup_path ); if( is_dir( $backup_path ) && wp_is_writable( $backup_path ) ) { if( is_iis() ) { if ( ! is_file( $backup_path . '/Web.config' ) ) { @copy( $plugin_path . 'Web.config.txt', $backup_path . '/Web.config' ); } } else { if( ! is_file( $backup_path . '/.htaccess' ) ) { @copy( $plugin_path . 'htaccess.txt', $backup_path . '/.htaccess' ); } } if( ! is_file( $backup_path . '/index.php' ) ) { @copy( $plugin_path . 'index.php', $backup_path . '/index.php' ); } @chmod( $backup_path, 0750 ); } } add_action( 'init', 'dbmanager_try_fix' ); function dbmanager_try_fix() { if ( ! empty( $_GET['try_fix'] ) && (int) $_GET['try_fix'] === 1 ) { check_admin_referer( 'wp-dbmanager_fix' ); dbmanager_create_backup_folder(); } } ### Function: Download Database add_action( 'init', 'download_database' ); function download_database() { if( isset( $_POST['do'] ) && $_POST['do'] === __( 'Download', 'wp-dbmanager' ) && ! empty( $_POST['database_file'] ) ) { check_admin_referer( 'wp-dbmanager_manage' ); $database_file = trim( $_POST['database_file'] ); if( substr( $database_file, strlen( $database_file ) -4, 4 ) === '.sql' || substr( $database_file, strlen( $database_file ) -7, 7 ) === '.sql.gz' ) { $backup_options = get_option( 'dbmanager_options' ); $clean_file_name = sanitize_file_name( $database_file ); $clean_file_name = str_replace( 'sql_.gz', 'sql.gz', $clean_file_name ); $file_path = $backup_options['path'] . '/' . $clean_file_name; header( 'Pragma: public' ); header( 'Expires: 0' ); header( 'Cache-Control: must-revalidate, post-check=0, pre-check=0' ); header( 'Content-Type: application/force-download' ); header( 'Content-Type: application/octet-stream' ); header( 'Content-Type: application/download' ); header( 'Content-Disposition: attachment; filename=' . basename( $file_path ) . ';' ); header( 'Content-Transfer-Encoding: binary' ); header( 'Content-Length: ' . filesize( $file_path ) ); @readfile( $file_path ); } exit(); } } ### Function: Check whether a function is disabled. function dbmanager_is_function_disabled( $function_name ) { return in_array( $function_name, array_map( 'trim', explode( ',', ini_get( 'disable_functions' ) ) ), true ); } ### Function: Polyfill array_key_first() for PHP < 7.3 if ( ! function_exists( 'array_key_first' ) ) { function array_key_first( $arr ) { foreach( $arr as $key => $unused ) { return $key; } return null; } } ### Function: Database Options function dbmanager_options() { $text = ''; $backup_options = get_option('dbmanager_options'); $old_backup_options = $backup_options; if(!empty($_POST['Submit'])) { check_admin_referer('wp-dbmanager_options'); $backup_options['mysqldumppath'] = ! empty( $_POST['db_mysqldumppath'] ) ? sanitize_text_field( $_POST['db_mysqldumppath'] ) : ''; $backup_options['mysqlpath'] = ! empty ( $_POST['db_mysqlpath'] ) ? sanitize_text_field( $_POST['db_mysqlpath'] ) : ''; $backup_options['path'] = ! empty ( $_POST['db_path'] ) ? sanitize_text_field( $_POST['db_path'] ) : ''; $backup_options['max_backup'] = ! empty( $_POST['db_max_backup'] ) ? (int) $_POST['db_max_backup'] : 0; $backup_options['backup'] = ! empty ( $_POST['db_backup'] ) ? (int) $_POST['db_backup'] : 0; $backup_options['backup_gzip'] = ! empty( $_POST['db_backup_gzip'] ) ? (int) $_POST['db_backup_gzip'] : 0; $backup_options['backup_period'] = ! empty( $_POST['db_backup_period'] ) ? (int) $_POST['db_backup_period'] : 0; $backup_options['backup_email'] = ! empty( $_POST['db_backup_email'] ) ? sanitize_email( $_POST['db_backup_email'] ) : ''; $backup_options['backup_email_from'] = ! empty( $_POST['db_backup_email_from'] ) ? sanitize_email( $_POST['db_backup_email_from'] ) : ''; $backup_options['backup_email_from_name'] = ! empty( $_POST['db_backup_email_from_name'] ) ? sanitize_text_field( $_POST['db_backup_email_from_name'] ) : ''; $backup_options['backup_email_subject'] = ! empty( $_POST['db_backup_email_subject'] ) ? sanitize_text_field( $_POST['db_backup_email_subject'] ) : ''; $backup_options['optimize'] = ! empty( $_POST['db_optimize'] ) ? (int) $_POST['db_optimize'] : 0; $backup_options['optimize_period'] = ! empty( $_POST['db_optimize_period'] ) ? (int) $_POST['db_optimize_period'] : 0; $backup_options['repair'] = ! empty( $_POST['db_repair'] ) ? (int) $_POST['db_repair'] : 0; $backup_options['repair_period'] = ! empty( $_POST['db_repair_period'] ) ? (int) $_POST['db_repair_period'] : 0; $backup_options['hide_admin_notices'] = ! empty( $_POST['db_hide_admin_notices'] ) ? (int) $_POST['db_hide_admin_notices'] : 0; if( realpath( $backup_options['path'] ) === false ) { $text = '<div id="message" class="error"><p>' . sprintf( __( '%s is not a valid backup path', 'wp-dbmanager' ), stripslashes( $backup_options['path'] ) ) . '</p></div>'; $backup_options['path'] = $old_backup_options['path']; } else if( dbmanager_is_valid_path( $backup_options['mysqldumppath'] ) === 0 ) { $text = '<div id="message" class="error"><p>' . sprintf( __( '%s is not a valid mysqldump path', 'wp-dbmanager' ), stripslashes( $backup_options['mysqldumppath'] ) ) . '</p></div>'; $backup_options['mysqldumppath'] = $old_backup_options['mysqldumppath']; } else if( dbmanager_is_valid_path( $backup_options['mysqlpath'] ) === 0 ) { $text = '<div id="message" class="error"><p>' . sprintf( __( '%s is not a valid mysql path', 'wp-dbmanager' ), stripslashes( $backup_options['mysqlpath'] ) ) . '</p></div>'; $backup_options['mysqlpath'] = $old_backup_options['mysqlpath']; } $update_db_options = update_option( 'dbmanager_options', $backup_options ); if( $update_db_options ) { $text = '<div id="message" class="updated"><p>' . __( 'Database Options Updated', 'wp-dbmanager' ) . '</p></div>'; } if( empty( $text ) ) { $text = '<div id="message" class="error"><p>' . __( 'No Database Option Updated', 'wp-dbmanager' ) . '</p></div>'; } wp_clear_scheduled_hook( 'dbmanager_cron_backup' ); if( $backup_options['backup_period'] > 0 ) { if ( ! wp_next_scheduled( 'dbmanager_cron_backup' ) ) { wp_schedule_event( time(), 'dbmanager_backup', 'dbmanager_cron_backup' ); } } wp_clear_scheduled_hook( 'dbmanager_cron_optimize' ); if( $backup_options['optimize_period'] > 0 ) { if ( ! wp_next_scheduled('dbmanager_cron_optimize' ) ) { wp_schedule_event( time(), 'dbmanager_optimize', 'dbmanager_cron_optimize' ); } } wp_clear_scheduled_hook( 'dbmanager_cron_repair' ); if( $backup_options['repair_period'] > 0 ) { if ( ! wp_next_scheduled( 'dbmanager_cron_repair' ) ) { wp_schedule_event( time(), 'dbmanager_repair', 'dbmanager_cron_repair' ); } } } $path = detect_mysql(); // Default Options if( !isset( $backup_options['backup_email_from'] ) ) { $backup_options['backup_email_from'] = dbmanager_default_options( 'backup_email_from' ); } if( !isset( $backup_options['backup_email_from_name'] ) ) { $backup_options['backup_email_from_name'] = dbmanager_default_options( 'backup_email_from_name' ); } if( !isset( $backup_options['backup_email_subject'] ) ) { $backup_options['backup_email_subject'] = dbmanager_default_options( 'backup_email_subject' ); } if( !isset( $backup_options['hide_admin_notices'] ) ) { $backup_options['hide_admin_notices'] = dbmanager_default_options( 'hide_admin_notices' ); } ?> <script type="text/javascript"> /* <![CDATA[*/ function mysqlpath() { jQuery("#db_mysqlpath").val("<?php echo $path['mysql']; ?>"); } function mysqldumppath() { jQuery("#db_mysqldumppath").val("<?php echo $path['mysqldump']; ?>"); } /* ]]> */ </script> <?php if( ! empty( $text ) ) { echo $text; } ?> <!-- Database Options --> <form method="post" action="<?php echo admin_url('admin.php?page='.plugin_basename(__FILE__)); ?>"> <?php wp_nonce_field('wp-dbmanager_options'); ?> <div class="wrap"> <h2><?php _e('Database Options', 'wp-dbmanager'); ?></h2> <h3><?php _e('Paths', 'wp-dbmanager'); ?></h3> <table class="form-table"> <tr> <td width="20%" valign="top"><strong><?php _e('Path To mysqldump:', 'wp-dbmanager'); ?></strong></td> <td width="80%"> <input type="text" id="db_mysqldumppath" name="db_mysqldumppath" size="60" maxlength="100" value="<?php echo stripslashes($backup_options['mysqldumppath']); ?>" dir="ltr" /> <input type="button" value="<?php _e('Auto Detect', 'wp-dbmanager'); ?>" 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> </td> </tr> <tr> <td valign="top"><strong><?php _e('Path To mysql:', 'wp-dbmanager'); ?></strong></td> <td> <input type="text" id="db_mysqlpath" name="db_mysqlpath" size="60" maxlength="100" value="<?php echo stripslashes($backup_options['mysqlpath']); ?>" dir="ltr" /> <input type="button" value="<?php _e('Auto Detect', 'wp-dbmanager'); ?>" onclick="mysqlpath();" /> <p><?php _e('The absolute path to mysql without trailing slash. If unsure, please email your server administrator about this.', 'wp-dbmanager'); ?></p> </td> </tr> <tr> <td valign="top"><strong><?php _e('Path To Backup:', 'wp-dbmanager'); ?></strong></td> <td> <input type="text" name="db_path" size="60" maxlength="200" value="<?php echo stripslashes($backup_options['path']); ?>" dir="ltr" /> <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> </table> <h3><?php _e('Note', 'wp-dbmanager'); ?></h3> <table class="form-table"> <tr> <td> <strong><?php _e('Windows Server', 'wp-dbmanager'); ?></strong><br /> <?php _e('For mysqldump path, you can try \'<strong>mysqldump.exe</strong>\'.', 'wp-dbmanager'); ?><br /> <?php _e('For mysql path, you can try \'<strong>mysql.exe</strong>\'.', 'wp-dbmanager'); ?> </td> </tr> <tr> <td> <strong><?php _e('Linux Server', 'wp-dbmanager'); ?></strong><br /> <?php _e('For mysqldump path, normally is just \'<strong>mysqldump</strong>\'.', 'wp-dbmanager'); ?><br /> <?php _e('For mysql path, normally is just \'<strong>mysql</strong>\'.', 'wp-dbmanager'); ?> </td> </tr> <tr> <td> <strong><?php _e('Note', 'wp-dbmanager'); ?></strong><br /> <?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'); ?> </td> </tr> </table> <h3><?php _e('Automatic Scheduling', 'wp-dbmanager'); ?></h3> <table class="form-table"> <tr> <td valign="top"><strong><?php _e('Automatic Backing Up Of DB:', 'wp-dbmanager'); ?></strong></td> <td> <?php _e('Next backup date: ', 'wp-dbmanager'); if(wp_next_scheduled('dbmanager_cron_backup')) { 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>'; } else { _e('N/A', 'wp-dbmanager'); } ?> <p> <?php _e('Every', 'wp-dbmanager'); ?> <input type="text" name="db_backup" size="3" maxlength="5" value="<?php echo esc_attr( $backup_options['backup'] ); ?>" /> <select name="db_backup_period" size="1"> <option value="0"<?php selected('0', $backup_options['backup_period']); ?>><?php _e('Disable', 'wp-dbmanager'); ?></option> <option value="60"<?php selected('60', $backup_options['backup_period']); ?>><?php _e('Minutes(s)', 'wp-dbmanager'); ?></option> <option value="3600"<?php selected('3600', $backup_options['backup_period']); ?>><?php _e('Hour(s)', 'wp-dbmanager'); ?></option> <option value="86400"<?php selected('86400', $backup_options['backup_period']); ?>><?php _e('Day(s)', 'wp-dbmanager'); ?></option> <option value="604800"<?php selected('604800', $backup_options['backup_period']); ?>><?php _e('Week(s)', 'wp-dbmanager'); ?></option> <option value="2592000"<?php selected('2592000', $backup_options['backup_period']); ?>><?php _e('Month(s)', 'wp-dbmanager'); ?></option> </select> <?php _e('Gzip', 'wp-dbmanager'); ?> <select name="db_backup_gzip" size="1"> <option value="0"<?php selected('0', $backup_options['backup_gzip']); ?>><?php _e('No', 'wp-dbmanager'); ?></option> <option value="1"<?php selected('1', $backup_options['backup_gzip']); ?>><?php _e('Yes', 'wp-dbmanager'); ?></option> </select> </p> <p><?php _e('WP-DBManager can automatically backup your database after a certain period.', 'wp-dbmanager'); ?></p> </td> </tr> <tr> <td valign="top"><strong><?php _e('Automatic Optimizing Of DB:', 'wp-dbmanager'); ?></strong></td> <td> <?php _e('Next optimize date: ', 'wp-dbmanager'); if(wp_next_scheduled('dbmanager_cron_optimize')) { 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>'; } else { _e('N/A', 'wp-dbmanager'); } ?> <p> <?php _e('Every', 'wp-dbmanager'); ?> <input type="text" name="db_optimize" size="3" maxlength="5" value="<?php echo esc_attr( $backup_options['optimize'] ); ?>" /> <select name="db_optimize_period" size="1"> <option value="0"<?php selected('0', $backup_options['optimize_period']); ?>><?php _e('Disable', 'wp-dbmanager'); ?></option> <option value="60"<?php selected('60', $backup_options['optimize_period']); ?>><?php _e('Minutes(s)', 'wp-dbmanager'); ?></option> <option value="3600"<?php selected('3600', $backup_options['optimize_period']); ?>><?php _e('Hour(s)', 'wp-dbmanager'); ?></option> <option value="86400"<?php selected('86400', $backup_options['optimize_period']); ?>><?php _e('Day(s)', 'wp-dbmanager'); ?></option> <option value="604800"<?php selected('604800', $backup_options['optimize_period']); ?>><?php _e('Week(s)', 'wp-dbmanager'); ?></option> <option value="2592000"<?php selected('2592000', $backup_options['optimize_period']); ?>><?php _e('Month(s)', 'wp-dbmanager'); ?></option> </select> </p> <p><?php _e('WP-DBManager can automatically optimize your database after a certain period.', 'wp-dbmanager'); ?></p> </td> </tr> <tr> <td valign="top"><strong><?php _e('Automatic Repairing Of DB:', 'wp-dbmanager'); ?></strong></td> <td> <?php _e('Next repair date: ', 'wp-dbmanager'); if(wp_next_scheduled('dbmanager_cron_repair')) { 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_repair') + (get_option('gmt_offset') * 3600)))).'</strong>'; } else { _e('N/A', 'wp-dbmanager'); } ?> <p> <?php _e('Every', 'wp-dbmanager'); ?> <input type="text" name="db_repair" size="3" maxlength="5" value="<?php echo esc_attr( $backup_options['repair'] ); ?>" /> <select name="db_repair_period" size="1"> <option value="0"<?php selected('0', $backup_options['repair_period']); ?>><?php _e('Disable', 'wp-dbmanager'); ?></option> <option value="60"<?php selected('60', $backup_options['repair_period']); ?>><?php _e('Minutes(s)', 'wp-dbmanager'); ?></option> <option value="3600"<?php selected('3600', $backup_options['repair_period']); ?>><?php _e('Hour(s)', 'wp-dbmanager'); ?></option> <option value="86400"<?php selected('86400', $backup_options['repair_period']); ?>><?php _e('Day(s)', 'wp-dbmanager'); ?></option> <option value="604800"<?php selected('604800', $backup_options['repair_period']); ?>><?php _e('Week(s)', 'wp-dbmanager'); ?></option> <option value="2592000"<?php selected('2592000', $backup_options['repair_period']); ?>><?php _e('Month(s)', 'wp-dbmanager'); ?></option> </select> </p> <p><?php _e('WP-DBManager can automatically repair your database after a certain period.', 'wp-dbmanager'); ?></p> </td> </tr> </table> <h3><?php _e('Backup Email Options', 'wp-dbmanager'); ?></h3> <table class="form-table"> <tr> <td valign="top"><strong><?php _e('To', 'wp-dbmanager'); ?></strong></td> <td> <p> <input type="text" name="db_backup_email" size="30" maxlength="250" placeholder="<?php _e ( 'To E-mail', 'wp-dbmanager' ); ?>" value="<?php echo esc_attr( stripslashes( $backup_options['backup_email'] ) ) ?>" dir="ltr" /> </p> <p><?php _e('(Leave blank to disable this feature)', 'wp-dbmanager'); ?></p> </td> </tr> <tr> <td valign="top"><strong><?php _e('From', 'wp-dbmanager'); ?></strong></td> <td> <p> <input type="text" name="db_backup_email_from_name" size="60" maxlength="250" placeholder="<?php _e ( 'From Name', 'wp-dbmanager' ); ?>" value="<?php echo esc_attr( stripslashes( $backup_options['backup_email_from_name'] ) ) ?>" dir="ltr" /> <<input type="text" name="db_backup_email_from" size="30" maxlength="250" placeholder="<?php _e ( 'From E-mail', 'wp-dbmanager' ); ?>" value="<?php echo esc_attr( stripslashes( $backup_options['backup_email_from'] ) ) ?>" dir="ltr" />> </p> <p><?php _e('(Leave blank to use the default)', 'wp-dbmanager'); ?></p> </td> </tr> <tr> <td valign="top"><strong><?php _e('Subject:', 'wp-dbmanager'); ?></strong></td> <td> <p> <input type="text" name="db_backup_email_subject" size="90" maxlength="255" placeholder="<?php _e ( 'Subject', 'wp-dbmanager' ); ?>" value="<?php echo esc_attr( stripslashes( $backup_options['backup_email_subject'] ) ) ?>" dir="ltr" /> </p> <p><?php _e('(Leave blank to use the default)', 'wp-dbmanager'); ?></p> </td> </tr> </table> <h3><?php _e('Miscellaneous Options', 'wp-dbmanager'); ?></h3> <table class="form-table"> <tr> <td valign="top"><strong><?php _e('Hide Admin Notices', 'wp-dbmanager'); ?></strong></td> <td> <p> <input type="radio" name="db_hide_admin_notices" value="1"<?php echo (int) $backup_options['hide_admin_notices'] === 1 ? ' checked="checked"' : ''; ?> /> <?php _e('Yes', 'wp-dbmanager'); ?> <input type="radio" name="db_hide_admin_notices" value="0"<?php echo (int) $backup_options['hide_admin_notices'] === 0 ? ' checked="checked"' : ''; ?> /> <?php _e('No', 'wp-dbmanager'); ?> </p> </td> </tr> </table> <p class="submit"> <input type="submit" name="Submit" class="button" value="<?php _e('Save Changes', 'wp-dbmanager'); ?>" /> </p> </div> </form> <?php } ?> database-empty.php 0000644 00000007670 15172701316 0010172 0 ustar 00 <?php ### Check Whether User Can Manage Database if ( ! current_user_can( 'install_plugins' ) ) { die( 'Access Denied' ); } ### Variables Variables Variables $base_name = plugin_basename('wp-dbmanager/database-manager.php'); $base_page = 'admin.php?page='.$base_name; $backup = array(); $backup_options = get_option('dbmanager_options'); $backup['date'] = current_time('timestamp'); $backup['mysqldumppath'] = $backup_options['mysqldumppath']; $backup['mysqlpath'] = $backup_options['mysqlpath']; $backup['path'] = $backup_options['path']; ### Form Processing if(!empty($_POST['do'])) { // Lets Prepare The Variables $emptydrop = (!empty($_POST['emptydrop']) ? $_POST['emptydrop'] : array()); $text = ''; // Decide What To Do switch($_POST['do']) { case __('Empty/Drop', 'wp-dbmanager'): check_admin_referer('wp-dbmanager_empty'); $empty_tables = array(); $drop_tables = ''; if(!empty($emptydrop)) { foreach($emptydrop as $key => $value) { if($value == 'empty') { $empty_tables[] = $key; } elseif($value == 'drop') { $drop_tables .= ', '.$key; } } } else { $text = '<p style="color: red;">'.__('No Tables Selected.', 'wp-dbmanager').'</p>'; } $drop_tables = substr($drop_tables, 2); if(!empty($empty_tables)) { foreach($empty_tables as $empty_table) { $empty_query = $wpdb->query("TRUNCATE $empty_table"); $text .= '<p style="color: green;">'.sprintf(__('Table \'%s\' Emptied', 'wp-dbmanager'), $empty_table).'</p>'; } } if(!empty($drop_tables)) { $drop_query = $wpdb->query("DROP TABLE $drop_tables"); $text = '<p style="color: green;">'.sprintf(__('Table(s) \'%s\' Dropped', 'wp-dbmanager'), $drop_tables).'</p>'; } break; } } ### Show Tables $tables = $wpdb->get_col("SHOW TABLES"); ?> <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?> <!-- Empty/Drop Tables --> <form method="post" action="<?php echo admin_url('admin.php?page='.plugin_basename(__FILE__)); ?>"> <?php wp_nonce_field('wp-dbmanager_empty'); ?> <div class="wrap"> <h2><?php _e('Empty/Drop Tables', 'wp-dbmanager'); ?></h2> <br style="clear" /> <table class="widefat"> <thead> <tr> <th><?php _e('Tables', 'wp-dbmanager'); ?></th> <th><?php _e('Empty', 'wp-dbmanager'); ?> <sup><?php _e('1', 'wp-dbmanager'); ?></sup></th> <th><?php _e('Drop', 'wp-dbmanager'); ?> <sup><?php _e('2', 'wp-dbmanager'); ?></sup></th> </tr> </thead> <?php $no = 0; foreach($tables as $table_name) { if($no%2 == 0) { $style = ''; } else { $style = ' class="alternate"'; } $no++; echo "<tr $style><th align=\"left\" scope=\"row\">$table_name</th>\n"; echo "<td><input type=\"radio\" id=\"$table_name-empty\" name=\"emptydrop[$table_name]\" value=\"empty\" /> <label for=\"$table_name-empty\">".__('Empty', 'wp-dbmanager').'</label></td>'; echo "<td><input type=\"radio\" id=\"$table_name-drop\" name=\"emptydrop[$table_name]\" value=\"drop\" /> <label for=\"$table_name-drop\">".__('Drop', 'wp-dbmanager').'</label></td></tr>'; } ?> <tr> <td colspan="3"> <?php _e('1. EMPTYING a table means all the rows in the table will be deleted. This action is not REVERSIBLE.', 'wp-dbmanager'); ?> <br /> <?php _e('2. DROPPING a table means deleting the table. This action is not REVERSIBLE.', 'wp-dbmanager'); ?> </td> </tr> <tr> <td colspan="3" align="center"><input type="submit" name="do" value="<?php _e('Empty/Drop', 'wp-dbmanager'); ?>" class="button" onclick="return confirm('<?php _e('You Are About To Empty Or Drop The Selected Databases.\nThis Action Is Not Reversible.\n\n Choose [Cancel] to stop, [Ok] to delete.', 'wp-dbmanager'); ?>')" /> <input type="button" name="cancel" value="<?php _e('Cancel', 'wp-dbmanager'); ?>" class="button" onclick="javascript:history.go(-1)" /></td> </tr> </table> </div> </form> Web.config.txt 0000644 00000000426 15172701316 0007273 0 ustar 00 <configuration> <system.webServer> <security> <requestFiltering> <hiddenSegments> <add segment="." /> </hiddenSegments> </requestFiltering> </security> </system.webServer> </configuration>
| ver. 1.4 |
Github
|
.
| PHP 8.3.30 | Generation time: 1.16 |
proxy
|
phpinfo
|
Settings