PageRenderTime 52ms CodeModel.GetById 19ms RepoModel.GetById 0ms app.codeStats 0ms

/wp-content/plugins/wp-dbmanager/wp-dbmanager.php

https://github.com/sharpmachine/wakeupmedia.com
PHP | 603 lines | 540 code | 22 blank | 41 comment | 51 complexity | 018c49d1ddbe175adb4796b983800294 MD5 | raw file
    

  1. <?php
    2. 

  2. /*
    3. 

  3. Plugin Name: WP-DBManager
    4. 

  4. Plugin URI: http://lesterchan.net/portfolio/programming/php/
    5. 

  5. Description: Manages your WordPress database. Allows you to optimize database, repair database, backup database, restore database, delete backup database , drop/empty tables and run selected queries. Supports automatic scheduling of backing up, optimizing and repairing of database.
    6. 

  6. Version: 2.63
    7. 

  7. Author: Lester 'GaMerZ' Chan
    8. 

  8. Author URI: http://lesterchan.net
    9. 

  9. */
    10. 

  10. 

  11. 

  12. /*  
    13. 

  13. 	Copyright 2011  Lester Chan  (email : lesterchan@gmail.com)
    14. 

    15. 

  15.     This program is free software; you can redistribute it and/or modify
    16. 

  16.     it under the terms of the GNU General Public License as published by
    17. 

  17.     the Free Software Foundation; either version 2 of the License, or
    18. 

  18.     (at your option) any later version.
    19. 

    20. 

  20.     This program is distributed in the hope that it will be useful,
    21. 

  21.     but WITHOUT ANY WARRANTY; without even the implied warranty of
    22. 

  22.     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    23. 

  23.     GNU General Public License for more details.
    24. 

    25. 

  25.     You should have received a copy of the GNU General Public License
    26. 

  26.     along with this program; if not, write to the Free Software
    27. 

  27.     Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
    28. 

  28. */
    29. 

  29. 

  30. 

  31. ### Create Text Domain For Translations
    32. 

  32. add_action('init', 'dbmanager_textdomain');
    33. 

  33. function dbmanager_textdomain() {
    34. 

  34. 	load_plugin_textdomain('wp-dbmanager', false, 'wp-dbmanager');
    35. 

  35. }
    36. 

  36. 

  37. 

  38. ### Function: Database Manager Menu
    39. 

  39. add_action('admin_menu', 'dbmanager_menu');
    40. 

  40. function dbmanager_menu() {
    41. 

  41. 	if (function_exists('add_menu_page')) {
    42. 

  42. 		add_menu_page(__('Database', 'wp-dbmanager'), __('Database', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/database-manager.php', '', plugins_url('wp-dbmanager/images/database.png'));
    43. 

  43. 	}
    44. 

  44. 	if (function_exists('add_submenu_page')) {
    45. 

  45. 		add_submenu_page('wp-dbmanager/database-manager.php', __('Backup DB', 'wp-dbmanager'), __('Backup DB', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/database-backup.php');
    46. 

  46. 		add_submenu_page('wp-dbmanager/database-manager.php', __('Manage Backup DB', 'wp-dbmanager'), __('Manage Backup DB', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/database-manage.php');
    47. 

  47. 		add_submenu_page('wp-dbmanager/database-manager.php', __('Optimize DB', 'wp-dbmanager'), __('Optimize DB', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/database-optimize.php');
    48. 

  48. 		add_submenu_page('wp-dbmanager/database-manager.php', __('Repair DB', 'wp-dbmanager'), __('Repair DB', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/database-repair.php');
    49. 

  49. 		add_submenu_page('wp-dbmanager/database-manager.php', __('Empty/Drop Tables', 'wp-dbmanager'), __('Empty/Drop Tables', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/database-empty.php');
    50. 

  50. 		add_submenu_page('wp-dbmanager/database-manager.php', __('Run SQL Query', 'wp-dbmanager'), __('Run SQL Query', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/database-run.php');
    51. 

  51. 		add_submenu_page('wp-dbmanager/database-manager.php', __('DB Options', 'wp-dbmanager'),  __('DB Options', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/wp-dbmanager.php', 'dbmanager_options');
    52. 

  52. 		add_submenu_page('wp-dbmanager/database-manager.php', __('Uninstall WP-DBManager', 'wp-dbmanager'), __('Uninstall WP-DBManager', 'wp-dbmanager'), 'manage_database', 'wp-dbmanager/database-uninstall.php');
    53. 

  53. 	}
    54. 

  54. }
    55. 

  55. 

  56. 

  57. ### Function: Displays DBManager Header In WP-Admin
    58. 

  58. add_action('admin_enqueue_scripts', 'dbmanager_stylesheets_admin');
    59. 

  59. function dbmanager_stylesheets_admin($hook_suffix) {
    60. 

  60. 	$dbmanager_admin_pages = array('wp-dbmanager/database-manager.php', 'wp-dbmanager/database-backup.php', 'wp-dbmanager/database-manage.php', 'wp-dbmanager/database-optimize.php', 'wp-dbmanager/database-repair.php', 'wp-dbmanager/database-empty.php', 'wp-dbmanager/database-run.php', 'database_page_wp-dbmanager/wp-dbmanager', 'wp-dbmanager/database-uninstall.php');
    61. 

  61. 	if(in_array($hook_suffix, $dbmanager_admin_pages)) {
    62. 

  62. 		wp_enqueue_style('wp-dbmanager-admin', plugins_url('wp-dbmanager/database-admin-css.css'), false, '2.63', 'all');
    63. 

  63. 	}
    64. 

  64. }
    65. 

  65. 

  66. 

  67. ### Funcion: Database Manager Cron
    68. 

  68. add_filter('cron_schedules', 'cron_dbmanager_reccurences');
    69. 

  69. add_action('dbmanager_cron_backup', 'cron_dbmanager_backup');
    70. 

  70. add_action('dbmanager_cron_optimize', 'cron_dbmanager_optimize');
    71. 

  71. add_action('dbmanager_cron_repair', 'cron_dbmanager_repair');
    72. 

  72. function cron_dbmanager_backup() {
    73. 

  73. 	global $wpdb;
    74. 

  74. 	$backup_options = get_option('dbmanager_options');
    75. 

  75. 	$backup_email = stripslashes($backup_options['backup_email']);
    76. 

  76. 	if(intval($backup_options['backup_period']) > 0) {
    77. 

  77. 		$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')));
    78. 

  78. 		$backup = array();
    79. 

  79. 		$backup['date'] = current_time('timestamp');
    80. 

  80. 		$backup['mysqldumppath'] = $backup_options['mysqldumppath'];
    81. 

  81. 		$backup['mysqlpath'] = $backup_options['mysqlpath'];
    82. 

  82. 		$backup['path'] = $backup_options['path'];
    83. 

  83. 		$backup['password'] = str_replace('$', '\$', DB_PASSWORD);
    84. 

  84. 		$backup['host'] = DB_HOST;
    85. 

  85. 		$backup['port'] = '';
    86. 

  86. 		$backup['sock'] = '';	
    87. 

  87. 		if(strpos(DB_HOST, ':') !== false) {
    88. 

  88. 			$db_host = explode(':', DB_HOST);
    89. 

  89. 			$backup['host'] = $db_host[0];
    90. 

  90. 			if(is_int($db_host[1])) {
    91. 

  91. 				$backup['port'] = ' --port="'.intval($db_host[1]).'"';
    92. 

  92. 			} else {
    93. 

  93. 				$backup['sock'] = ' --socket="'.$db_host[1].'"';
    94. 

  94. 			}
    95. 

  95. 		}
    96. 

  96. 		$backup['command'] = '';
    97. 

  97. 		$brace = (substr(PHP_OS, 0, 3) == 'WIN') ? '"' : '';
    98. 

  98. 		if(intval($backup_options['backup_gzip']) == 1) {
    99. 

  99. 			$backup['filename'] = $backup['date'].'_-_'.DB_NAME.'.sql.gz';
    100. 

  100. 			$backup['filepath'] = $backup['path'].'/'.$backup['filename'];
    101. 

  101. 			$backup['command'] = $brace.$backup['mysqldumppath'].$brace.' --host="'.$backup['host'].'" --user="'.DB_USER.'" --password="'.$backup['password'].'"'.$backup['port'].$backup['sock'].' --add-drop-table --skip-lock-tables '.DB_NAME.' | gzip > '.$brace.$backup['filepath'].$brace;
    102. 

  102. 		} else {
    103. 

  103. 			$backup['filename'] = $backup['date'].'_-_'.DB_NAME.'.sql';
    104. 

  104. 			$backup['filepath'] = $backup['path'].'/'.$backup['filename'];
    105. 

  105. 			$backup['command'] = $brace.$backup['mysqldumppath'].$brace.' --host="'.$backup['host'].'" --user="'.DB_USER.'" --password="'.$backup['password'].'"'.$backup['port'].$backup['sock'].' --add-drop-table --skip-lock-tables '.DB_NAME.' > '.$brace.$backup['filepath'].$brace;
    106. 

  106. 		}
    107. 

  107. 		execute_backup($backup['command']);
    108. 

  108. 		if(!empty($backup_email)) {
    109. 

  109. 				// Get And Read The Database Backup File
    110. 

  110. 				$file_path = $backup['filepath'];
    111. 

  111. 				$file_size = format_size(filesize($file_path));
    112. 

  112. 				$file_date = mysql2date(sprintf(__('%s @ %s', 'wp-dbmanager'), get_option('date_format'), get_option('time_format')), gmdate('Y-m-d H:i:s', substr($backup['filename'], 0, 10)));
    113. 

  113. 				$file = fopen($file_path,'rb');
    114. 

  114. 				$file_data = fread($file,filesize($file_path));
    115. 

  115. 				fclose($file);
    116. 

  116. 				$file_data = chunk_split(base64_encode($file_data));
    117. 

  117. 				// Create Mail To, Mail Subject And Mail Header
    118. 

  118. 				$mail_subject = sprintf(__('%s Database Backup File For %s', 'wp-dbmanager'), wp_specialchars_decode(get_option('blogname')), $file_date);
    119. 

  119. 				$mail_header = 'From: '.wp_specialchars_decode(get_option('blogname')).' Administrator <'.get_option('admin_email').'>';
    120. 

  120. 				// MIME Boundary
    121. 

  121. 				$random_time = md5(time());
    122. 

  122. 				$mime_boundary = "==WP-DBManager- $random_time";
    123. 

  123. 				// Create Mail Header And Mail Message
    124. 

  124. 				$mail_header .= "\nMIME-Version: 1.0\n" .
    125. 

  125. 										"Content-Type: multipart/mixed;\n" .
    126. 

  126. 										" boundary=\"{$mime_boundary}\"";
    127. 

  127. 				$mail_message = __('Website Name:', 'wp-dbmanager').' '.wp_specialchars_decode(get_option('blogname'))."\n".
    128. 

  128. 										__('Website URL:', 'wp-dbmanager').' '.get_bloginfo('siteurl')."\n".
    129. 

  129. 										__('Backup File Name:', 'wp-dbmanager').' '.$backup['filename']."\n".
    130. 

  130. 										__('Backup File Date:', 'wp-dbmanager').' '.$file_date."\n".
    131. 

  131. 										__('Backup File Size:', 'wp-dbmanager').' '.$file_size."\n\n".
    132. 

  132. 										__('With Regards,', 'wp-dbmanager')."\n".
    133. 

  133. 										wp_specialchars_decode(get_option('blogname')).' '. __('Administrator', 'wp-dbmanager')."\n".
    134. 

  134. 										get_bloginfo('siteurl');
    135. 

  135. 				$mail_message = "This is a multi-part message in MIME format.\n\n" .
    136. 

  136. 										"--{$mime_boundary}\n" .
    137. 

  137. 										"Content-Type: text/plain; charset=\"utf-8\"\n" .
    138. 

  138. 										"Content-Transfer-Encoding: 7bit\n\n".$mail_message."\n\n";				
    139. 

  139. 				$mail_message .= "--{$mime_boundary}\n" .
    140. 

  140. 										"Content-Type: application/octet-stream;\n" .
    141. 

  141. 										" name=\"{$backup['filename']}\"\n" .
    142. 

  142. 										"Content-Disposition: attachment;\n" .
    143. 

  143. 										" filename=\"{$backup['filename']}\"\n" .
    144. 

  144. 										"Content-Transfer-Encoding: base64\n\n" .
    145. 

  145. 										$file_data."\n\n--{$mime_boundary}--\n";
    146. 

  146. 			mail($backup_email, $mail_subject, $mail_message, $mail_header);
    147. 

  147. 		}
    148. 

  148. 	}
    149. 

  149. 	return;
    150. 

  150. }
    151. 

  151. function cron_dbmanager_optimize() {
    152. 

  152. 	global $wpdb;
    153. 

  153. 	$backup_options = get_option('dbmanager_options');
    154. 

  154. 	$optimize = intval($backup_options['optimize']);
    155. 

  155. 	$optimize_period = intval($backup_options['optimize_period']);
    156. 

  156. 	if($optimize_period > 0) {
    157. 

  157. 		$optimize_tables = array();
    158. 

  158. 		$tables = $wpdb->get_col("SHOW TABLES");
    159. 

  159. 			foreach($tables as $table_name) {
    160. 

  160. 				$optimize_tables[] = '`'.$table_name.'`';
    161. 

  161. 		}
    162. 

  162. 		$wpdb->query('OPTIMIZE TABLE '.implode(',', $optimize_tables));
    163. 

  163. 	}
    164. 

  164. 	return;
    165. 

  165. }
    166. 

  166. function cron_dbmanager_repair() {
    167. 

  167. 	global $wpdb;
    168. 

  168. 	$backup_options = get_option('dbmanager_options');
    169. 

  169. 	$repair = intval($backup_options['repair']);
    170. 

  170. 	$repair_period = intval($backup_options['repair_period']);
    171. 

  171. 	if($repair_period > 0) {
    172. 

  172. 		$repair_tables = array();
    173. 

  173. 		$tables = $wpdb->get_col("SHOW TABLES");
    174. 

  174. 			foreach($tables as $table_name) {
    175. 

  175. 				$repair_tables[] = '`'.$table_name.'`';
    176. 

  176. 		}
    177. 

  177. 		$wpdb->query('REPAIR TABLE '.implode(',', $repair_tables));
    178. 

  178. 	}
    179. 

  179. 	return;
    180. 

  180. }
    181. 

  181. function cron_dbmanager_reccurences($schedules) {
    182. 

  182. 	$backup_options = get_option('dbmanager_options');
    183. 

  183. 	$backup = intval($backup_options['backup'])*intval($backup_options['backup_period']);
    184. 

  184. 	$optimize = intval($backup_options['optimize'])*intval($backup_options['optimize_period']);
    185. 

  185. 	$repair = intval($backup_options['repair'])*intval($backup_options['repair_period']);
    186. 

  186. 	if($backup == 0) {
    187. 

  187. 		$backup = 31536000;
    188. 

  188. 	}
    189. 

  189. 	if($optimize == 0) {
    190. 

  190. 		$optimize = 31536000;
    191. 

  191. 	}
    192. 

  192. 	if($repair == 0) {
    193. 

  193. 		$repair = 31536000;
    194. 

  194. 	}
    195. 

  195.    $schedules['dbmanager_backup'] = array('interval' => $backup, 'display' => __('WP-DBManager Backup Schedule', 'wp-dbmanager'));
    196. 

  196.    $schedules['dbmanager_optimize'] = array('interval' => $optimize, 'display' => __('WP-DBManager Optimize Schedule', 'wp-dbmanager'));
    197. 

  197.    $schedules['dbmanager_repair'] = array('interval' => $repair, 'display' => __('WP-DBManager Repair Schedule', 'wp-dbmanager'));
    198. 

  198.    return $schedules;
    199. 

  199. }
    200. 

  200. 

  201. 

  202. ### Function: Ensure .htaccess Is In The Backup Folder
    203. 

  203. add_action('admin_notices', 'dbmanager_admin_notices');
    204. 

  204. function dbmanager_admin_notices() {
    205. 

  205. 	$backup_options = get_option('dbmanager_options');
    206. 

  206. 	if(!@file_exists($backup_options['path'].'/.htaccess')) {
    207. 

  207. 		echo '<div class="error" style="text-align: center;"><p style="color: red; font-size: 14px; font-weight: bold;">'.__('Your backup folder MIGHT be visible to the public', 'wp-postratings').'</p><p>'.sprintf(__('To correct this issue, move the <strong>.htaccess</strong> file from <strong>wp-content/plugins/wp-dbmanager</strong> to <strong>%s</strong>', 'wp-postratings'), $backup_options['path']).'</p></div>';
    208. 

  208. 	}
    209. 

  209. }
    210. 

  210. 

  211. 

  212. ### Function: Auto Detect MYSQL and MYSQL Dump Paths
    213. 

  213. function detect_mysql() {
    214. 

  214. 	global $wpdb;
    215. 

  215. 	$paths = array('mysq' => '', 'mysqldump' => '');
    216. 

  216. 	if(substr(PHP_OS,0,3) == 'WIN') {
    217. 

  217. 		$mysql_install = $wpdb->get_row("SHOW VARIABLES LIKE 'basedir'");
    218. 

  218. 		if($mysql_install) {
    219. 

  219. 			$install_path = str_replace('\\', '/', $mysql_install->Value);
    220. 

  220. 			$paths['mysql'] = $install_path.'bin/mysql.exe';
    221. 

  221. 			$paths['mysqldump'] = $install_path.'bin/mysqldump.exe';
    222. 

  222. 		} else {
    223. 

  223. 			$paths['mysql'] = 'mysql.exe';
    224. 

  224. 			$paths['mysqldump'] = 'mysqldump.exe';
    225. 

  225. 		}
    226. 

  226. 	} else {
    227. 

  227. 		if(function_exists('exec')) {
    228. 

  228. 			$paths['mysql'] = @exec('which mysql');
    229. 

  229. 			$paths['mysqldump'] = @exec('which mysqldump');
    230. 

  230. 		} else {
    231. 

  231. 			$paths['mysql'] = 'mysql';
    232. 

  232. 			$paths['mysqldump'] = 'mysqldump';
    233. 

  233. 		}
    234. 

  234. 	}
    235. 

  235. 	return $paths;
    236. 

  236. }
    237. 

  237. 

  238. 

  239. ### Executes OS-Dependent mysqldump Command (By: Vlad Sharanhovich)
    240. 

  240. function execute_backup($command) {
    241. 

  241. 	$backup_options = get_option('dbmanager_options');
    242. 

  242. 	check_backup_files();
    243. 

  243. 	if(substr(PHP_OS, 0, 3) == 'WIN') {
    244. 

  244. 		$writable_dir = $backup_options['path'];
    245. 

  245. 		$tmpnam = $writable_dir.'/wp-dbmanager.bat';
    246. 

  246. 		$fp = fopen($tmpnam, 'w');
    247. 

  247. 		fwrite($fp, $command);
    248. 

  248. 		fclose($fp);
    249. 

  249. 		system($tmpnam.' > NUL', $error);
    250. 

  250. 		unlink($tmpnam);
    251. 

  251. 	} else {
    252. 

  252. 		passthru($command, $error);
    253. 

  253. 	}
    254. 

  254. 	return $error;
    255. 

  255. }
    256. 

  256. 

  257. 

  258. ### Function: Format Bytes Into KB/MB
    259. 

  259. if(!function_exists('format_size')) {
    260. 

  260. 	function format_size($rawSize) {
    261. 

  261. 		if($rawSize / 1073741824 > 1) 
    262. 

  262. 			return number_format_i18n($rawSize/1048576, 1) . ' '.__('GiB', 'wp-dbmanager');
    263. 

  263. 		else if ($rawSize / 1048576 > 1)
    264. 

  264. 			return number_format_i18n($rawSize/1048576, 1) . ' '.__('MiB', 'wp-dbmanager');
    265. 

  265. 		else if ($rawSize / 1024 > 1)
    266. 

  266. 			return number_format_i18n($rawSize/1024, 1) . ' '.__('KiB', 'wp-dbmanager');
    267. 

  267. 		else
    268. 

  268. 			return number_format_i18n($rawSize, 0) . ' '.__('bytes', 'wp-dbmanager');
    269. 

  269. 	}
    270. 

  270. }
    271. 

  271. 

  272. 

  273. ### Function: Get File Extension
    274. 

  274. if(!function_exists('file_ext')) {
    275. 

  275. 	function file_ext($file_name) {
    276. 

  276. 		return substr(strrchr($file_name, '.'), 1);
    277. 

  277. 	}
    278. 

  278. }
    279. 

  279. 

  280. 

  281. ### Function: Check Folder Whether There Is Any File Inside
    282. 

  282. if(!function_exists('is_emtpy_folder')) {
    283. 

  283. 	function is_emtpy_folder($folder){
    284. 

  284. 	   if(is_dir($folder) ){
    285. 

  285. 		   $handle = opendir($folder);
    286. 

  286. 		   while( (gettype( $name = readdir($handle)) != 'boolean')){
    287. 

  287. 				if($name != '.htaccess') {
    288. 

  288. 					$name_array[] = $name;
    289. 

  289. 				}
    290. 

  290. 		   }
    291. 

  291. 		   foreach($name_array as $temp)
    292. 

  292. 			   $folder_content .= $temp;
    293. 

  293. 

  294. 		   if($folder_content == '...')
    295. 

  295. 			   return true;
    296. 

  296. 		   else
    297. 

  297. 			   return false;
    298. 

  298. 		   closedir($handle);
    299. 

  299. 	   }
    300. 

  300. 	   else
    301. 

  301. 		   return true;
    302. 

  302. 	}
    303. 

  303. }
    304. 

  304. 

  305. 

  306. ### Function: Make Sure Maximum Number Of Database Backup Files Does Not Exceed
    307. 

  307. function check_backup_files() {
    308. 

  308. 	$backup_options = get_option('dbmanager_options');
    309. 

  309. 	$database_files = array();
    310. 

  310. 	if(!is_emtpy_folder($backup_options['path'])) {
    311. 

  311. 		if ($handle = opendir($backup_options['path'])) {			
    312. 

  312. 			while (false !== ($file = readdir($handle))) { 
    313. 

  313. 				if ($file != '.' && $file != '..' && (file_ext($file) == 'sql' || file_ext($file) == 'gz')) {
    314. 

  314. 					$database_files[] = $file;
    315. 

  315. 				} 
    316. 

  316. 			}
    317. 

  317. 			closedir($handle);
    318. 

  318. 			sort($database_files);
    319. 

  319. 		}
    320. 

  320. 	}
    321. 

  321. 	if(sizeof($database_files) >= $backup_options['max_backup']) {
    322. 

  322. 		@unlink($backup_options['path'].'/'.$database_files[0]);
    323. 

  323. 	}
    324. 

  324. }
    325. 

  325. 

  326. 

  327. ### Function: Database Manager Role
    328. 

  328. add_action('activate_wp-dbmanager/wp-dbmanager.php', 'dbmanager_init');
    329. 

  329. function dbmanager_init() {
    330. 

  330. 	global $wpdb;
    331. 

  331. 	$auto = detect_mysql();
    332. 

  332. 	// Add Options
    333. 

  333. 	$backup_options = array();
    334. 

  334. 	$backup_options['mysqldumppath'] = $auto['mysqldump'];
    335. 

  335. 	$backup_options['mysqlpath'] = $auto['mysql'];
    336. 

  336. 	$backup_options['path'] = str_replace('\\', '/', WP_CONTENT_DIR).'/backup-db';
    337. 

  337. 	$backup_options['max_backup'] = 10;
    338. 

  338. 	$backup_options['backup'] = 1;
    339. 

  339. 	$backup_options['backup_gzip'] = 0;
    340. 

  340. 	$backup_options['backup_period'] = 604800;
    341. 

  341. 	$backup_options['backup_email'] = get_option('admin_email');
    342. 

  342. 	$backup_options['optimize'] = 3;
    343. 

  343. 	$backup_options['optimize_period'] = 86400;
    344. 

  344. 	$backup_options['repair'] = 2;
    345. 

  345. 	$backup_options['repair_period'] = 604800;
    346. 

  346. 	add_option('dbmanager_options', $backup_options, 'WP-DBManager Options');
    347. 

  347. 

  348. 	// Create Backup Folder
    349. 

  349. 	if(!is_dir(WP_CONTENT_DIR.'/backup-db')) {
    350. 

  350. 		mkdir(WP_CONTENT_DIR.'/backup-db');
    351. 

  351. 		chmod(WP_CONTENT_DIR.'/backup-db', 0750);
    352. 

  352. 	}
    353. 

  353. 

  354. 	// Set 'manage_database' Capabilities To Administrator	
    355. 

  355. 	$role = get_role('administrator');
    356. 

  356. 	if(!$role->has_cap('manage_database')) {
    357. 

  357. 		$role->add_cap('manage_database');
    358. 

  358. 	}
    359. 

  359. }
    360. 

  360. 

  361. 

  362. ### Function: Download Database
    363. 

  363. add_action('init', 'download_database');
    364. 

  364. function download_database() {
    365. 

  365. 	if(isset($_POST['do']) && $_POST['do'] == __('Download', 'wp-dbmanager') && !empty($_POST['database_file'])) {
    366. 

  366. 		if(strpos($_SERVER['HTTP_REFERER'], admin_url('admin.php?page=wp-dbmanager/database-manage.php')) !== false) {
    367. 

  367. 			$database_file = trim($_POST['database_file']);
    368. 

  368. 			if(substr($database_file, strlen($database_file) - 4, 4) == '.sql' || substr($database_file, strlen($database_file) - 7, 7) == '.sql.gz') {
    369. 

  369. 				check_admin_referer('wp-dbmanager_manage');
    370. 

  370. 				$backup_options = get_option('dbmanager_options');
    371. 

  371. 				$clean_file_name = sanitize_file_name($database_file);
    372. 

  372. 				$clean_file_name = str_replace('sql_.gz', 'sql.gz', $clean_file_name);
    373. 

  373. 				$file_path = $backup_options['path'].'/'.$clean_file_name;
    374. 

  374. 				header("Pragma: public");
    375. 

  375. 				header("Expires: 0");
    376. 

  376. 				header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); 
    377. 

  377. 				header("Content-Type: application/force-download");
    378. 

  378. 				header("Content-Type: application/octet-stream");
    379. 

  379. 				header("Content-Type: application/download");
    380. 

  380. 				header("Content-Disposition: attachment; filename=".basename($file_path).";");
    381. 

  381. 				header("Content-Transfer-Encoding: binary");
    382. 

  382. 				header("Content-Length: ".filesize($file_path));
    383. 

  383. 				@readfile($file_path);
    384. 

  384. 			}
    385. 

  385. 		}
    386. 

  386. 		exit();
    387. 

  387. 	}
    388. 

  388. }
    389. 

  389. 

  390. 

  391. ### Function: Database Options
    392. 

  392. function dbmanager_options() {
    393. 

  393. 	global $wpdb;
    394. 

  394. 	$text = '';
    395. 

  395. 	$backup_options = array();
    396. 

  396. 	$backup_options = get_option('dbmanager_options');
    397. 

  397. 	if($_POST['Submit']) {
    398. 

  398. 		check_admin_referer('wp-dbmanager_options');
    399. 

  399. 		$backup_options['mysqldumppath'] = trim($_POST['db_mysqldumppath']);
    400. 

  400. 		$backup_options['mysqlpath'] = trim($_POST['db_mysqlpath']);
    401. 

  401. 		$backup_options['path'] = trim($_POST['db_path']);
    402. 

  402. 		$backup_options['max_backup'] = intval($_POST['db_max_backup']);
    403. 

  403. 		$backup_options['backup'] = intval($_POST['db_backup']);
    404. 

  404. 		$backup_options['backup_gzip'] = intval($_POST['db_backup_gzip']);
    405. 

  405. 		$backup_options['backup_period'] = intval($_POST['db_backup_period']);
    406. 

  406. 		$backup_options['backup_email'] = trim(addslashes($_POST['db_backup_email']));
    407. 

  407. 		$backup_options['optimize'] = intval($_POST['db_optimize']);
    408. 

  408. 		$backup_options['optimize_period'] = intval($_POST['db_optimize_period']);
    409. 

  409. 		$backup_options['repair'] = intval($_POST['db_repair']);
    410. 

  410. 		$backup_options['repair_period'] = intval($_POST['db_repair_period']);
    411. 

  411. 		$update_db_options = update_option('dbmanager_options', $backup_options);
    412. 

  412. 		if($update_db_options) {
    413. 

  413. 			$text = '<font color="green">'.__('Database Options Updated', 'wp-dbmanager').'</font>';
    414. 

  414. 		}
    415. 

  415. 		if(empty($text)) {
    416. 

  416. 			$text = '<font color="red">'.__('No Database Option Updated', 'wp-dbmanager').'</font>';
    417. 

  417. 		}
    418. 

  418. 		wp_clear_scheduled_hook('dbmanager_cron_backup');
    419. 

  419. 		if($backup_options['backup_period'] > 0) {
    420. 

  420. 			if (!wp_next_scheduled('dbmanager_cron_backup')) {
    421. 

  421. 				wp_schedule_event(time(), 'dbmanager_backup', 'dbmanager_cron_backup');
    422. 

  422. 			}
    423. 

  423. 		}
    424. 

  424. 		wp_clear_scheduled_hook('dbmanager_cron_optimize');
    425. 

  425. 		if($backup_options['optimize_period'] > 0) {
    426. 

  426. 			if (!wp_next_scheduled('dbmanager_cron_optimize')) {
    427. 

  427. 				wp_schedule_event(time(), 'dbmanager_optimize', 'dbmanager_cron_optimize');
    428. 

  428. 			}
    429. 

  429. 		}
    430. 

  430. 		wp_clear_scheduled_hook('dbmanager_cron_repair');
    431. 

  431. 		if($backup_options['repair_period'] > 0) {
    432. 

  432. 			if (!wp_next_scheduled('dbmanager_cron_repair')) {
    433. 

  433. 				wp_schedule_event(time(), 'dbmanager_repair', 'dbmanager_cron_repair');
    434. 

  434. 			}
    435. 

  435. 		}
    436. 

  436. 	}
    437. 

  437. 	$path = detect_mysql();
    438. 

  438. ?>
    439. 

  439. <script type="text/javascript">
    440. 

  440. /* <![CDATA[*/
    441. 

  441. 	function mysqlpath() {
    442. 

  442. 		jQuery("#db_mysqlpath").val("<?php echo $path['mysql']; ?>");
    443. 

  443. 	}
    444. 

  444. 	function mysqldumppath() {
    445. 

  445. 		jQuery("#db_mysqldumppath").val("<?php echo $path['mysqldump']; ?>");
    446. 

  446. 	}
    447. 

  447. /* ]]> */
    448. 

  448. </script>
    449. 

  449. <?php if(!empty($text)) { echo '<!-- Last Action --><div id="message" class="updated fade"><p>'.$text.'</p></div>'; } ?>
    450. 

  450. <!-- Database Options -->
    451. 

  451. <form method="post" action="<?php echo admin_url('admin.php?page='.plugin_basename(__FILE__)); ?>">
    452. 

  452. 	<?php wp_nonce_field('wp-dbmanager_options'); ?>
    453. 

  453. 	<div class="wrap">
    454. 

  454. 		<div id="icon-wp-dbmanager" class="icon32"><br /></div>
    455. 

  455. 		<h2><?php _e('Database Options', 'wp-dbmanager'); ?></h2>
    456. 

  456. 		<h3><?php _e('Paths', 'wp-dbmanager'); ?></h3> 
    457. 

  457. 		<table class="form-table">
    458. 

  458. 			<tr>
    459. 

  459. 				<td width="20%" valign="top"><strong><?php _e('Path To mysqldump:', 'wp-dbmanager'); ?></strong></td>
    460. 

  460. 				<td width="80%">
    461. 

  461. 					<input type="text" id="db_mysqldumppath" name="db_mysqldumppath" size="60" maxlength="100" value="<?php echo stripslashes($backup_options['mysqldumppath']); ?>" dir="ltr" />&nbsp;&nbsp;<input type="button" value="<?php _e('Auto Detect', 'wp-dbmanager'); ?>" onclick="mysqldumppath();" />
    462. 

  462. 					<p><?php _e('The absolute path to mysqldump without trailing slash. If unsure, please email your server administrator about this.', 'wp-dbmanager'); ?></p>
    463. 

  463. 				</td>
    464. 

  464. 			</tr>
    465. 

  465. 			<tr>
    466. 

  466. 				<td valign="top"><strong><?php _e('Path To mysql:', 'wp-dbmanager'); ?></strong></td>
    467. 

  467. 				<td>
    468. 

  468. 					<input type="text" id="db_mysqlpath" name="db_mysqlpath" size="60" maxlength="100" value="<?php echo stripslashes($backup_options['mysqlpath']); ?>" dir="ltr" />&nbsp;&nbsp;<input type="button" value="<?php _e('Auto Detect', 'wp-dbmanager'); ?>" onclick="mysqlpath();" />
    469. 

  469. 					<p><?php _e('The absolute path to mysql without trailing slash. If unsure, please email your server administrator about this.', 'wp-dbmanager'); ?></p>
    470. 

  470. 				</td>
    471. 

  471. 			</tr>
    472. 

  472. 			<tr>
    473. 

  473. 				<td valign="top"><strong><?php _e('Path To Backup:', 'wp-dbmanager'); ?></strong></td>
    474. 

  474. 				<td>
    475. 

  475. 					<input type="text" name="db_path" size="60" maxlength="100" value="<?php echo stripslashes($backup_options['path']); ?>" dir="ltr" />
    476. 

  476. 					<p><?php _e('The absolute path to your database backup folder without trailing slash. Make sure the folder is writable.', 'wp-dbmanager'); ?></p>
    477. 

  477. 				</td>
    478. 

  478. 			</tr>
    479. 

  479. 			<tr>
    480. 

  480. 				<td valign="top"><strong><?php _e('Maximum Backup Files:', 'wp-dbmanager'); ?></strong></td>
    481. 

  481. 				<td>
    482. 

  482. 					<input type="text" name="db_max_backup" size="5" maxlength="5" value="<?php echo stripslashes($backup_options['max_backup']); ?>" />
    483. 

  483. 					<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>
    484. 

  484. 				</td>
    485. 

  485. 			</tr>
    486. 

  486. 		</table>
    487. 

  487. 

  488. 		<h3><?php _e('Note', 'wp-dbmanager'); ?></h3>
    489. 

  489. 		<table class="form-table">
    490. 

  490. 			<tr>
    491. 

  491. 				<td>
    492. 

  492. 					<strong><?php _e('Windows Server', 'wp-dbmanager'); ?></strong><br />
    493. 

  493. 					<?php _e('For mysqldump path, you can try \'<strong>mysqldump.exe</strong>\'.', 'wp-dbmanager'); ?><br />
    494. 

  494. 					<?php _e('For mysql path, you can try \'<strong>mysql.exe</strong>\'.', 'wp-dbmanager'); ?>
    495. 

  495. 				</td>
    496. 

  496. 			</tr>
    497. 

  497. 			<tr>
    498. 

  498. 				<td>
    499. 

  499. 					<strong><?php _e('Linux Server', 'wp-dbmanager'); ?></strong><br />
    500. 

  500. 					<?php _e('For mysqldump path, normally is just \'<strong>mysqldump</strong>\'.', 'wp-dbmanager'); ?><br />
    501. 

  501. 					<?php _e('For mysql path, normally is just \'<strong>mysql</strong>\'.', 'wp-dbmanager'); ?>
    502. 

  502. 				</td>
    503. 

  503. 			</tr>
    504. 

  504. 			<tr>
    505. 

  505. 				<td>
    506. 

  506. 					<strong><?php _e('Note', 'wp-dbmanager'); ?></strong><br />
    507. 

  507. 					<?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'); ?>
    508. 

  508. 				</td>
    509. 

  509. 			</tr>
    510. 

  510. 		</table>
    511. 

  511. 

  512. 		<h3><?php _e('Automatic Scheduling', 'wp-dbmanager'); ?></h3> 
    513. 

  513. 		<table class="form-table"> 
    514. 

  514. 			<tr>
    515. 

  515. 				<td valign="top"><strong><?php _e('Automatic Backing Up Of DB:', 'wp-dbmanager'); ?></strong></td>
    516. 

  516. 				<td>
    517. 

  517. 					<?php
    518. 

  518. 						_e('Next backup date: ', 'wp-dbmanager');
    519. 

  519. 						if(wp_next_scheduled('dbmanager_cron_backup')) {
    520. 

  520. 							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>';
    521. 

  521. 						} else {
    522. 

  522. 							_e('N/A', 'wp-dbmanager');
    523. 

  523. 						}
    524. 

  524. 					?>
    525. 

  525. 					<p>
    526. 

  526. 						<?php _e('Every', 'wp-dbmanager'); ?>&nbsp;<input type="text" name="db_backup" size="3" maxlength="5" value="<?php echo intval($backup_options['backup']); ?>" />&nbsp;
    527. 

  527. 					<select name="db_backup_period" size="1">
    528. 

  528. 						<option value="0"<?php selected('0', $backup_options['backup_period']); ?>><?php _e('Disable', 'wp-dbmanager'); ?></option>
    529. 

  529. 						<option value="60"<?php selected('60', $backup_options['backup_period']); ?>><?php _e('Minutes(s)', 'wp-dbmanager'); ?></option>
    530. 

  530. 						<option value="3600"<?php selected('3600', $backup_options['backup_period']); ?>><?php _e('Hour(s)', 'wp-dbmanager'); ?></option>
    531. 

  531. 						<option value="86400"<?php selected('86400', $backup_options['backup_period']); ?>><?php _e('Day(s)', 'wp-dbmanager'); ?></option>
    532. 

  532. 						<option value="604800"<?php selected('604800', $backup_options['backup_period']); ?>><?php _e('Week(s)', 'wp-dbmanager'); ?></option>
    533. 

  533. 						<option value="18144000"<?php selected('18144000', $backup_options['backup_period']); ?>><?php _e('Month(s)', 'wp-dbmanager'); ?></option>
    534. 

  534. 					</select>&nbsp;&nbsp;&nbsp;
    535. 

  535. 					<?php _e('Gzip', 'wp-dbmanager'); ?>
    536. 

  536. 					<select name="db_backup_gzip" size="1">
    537. 

  537. 						<option value="0"<?php selected('0', $backup_options['backup_gzip']); ?>><?php _e('No', 'wp-dbmanager'); ?></option>
    538. 

  538. 						<option value="1"<?php selected('1', $backup_options['backup_gzip']); ?>><?php _e('Yes', 'wp-dbmanager'); ?></option>
    539. 

  539. 					</select>
    540. 

  540. 					</p>
    541. 

  541. 					<p><?php _e('E-mail backup to:', 'wp-dbmanager'); ?> <input type="text" name="db_backup_email" size="30" maxlength="50" value="<?php echo stripslashes($backup_options['backup_email']) ?>" dir="ltr" />&nbsp;&nbsp;&nbsp;<?php _e('(Leave blank to disable this feature)', 'wp-dbmanager'); ?></p>
    542. 

  542. 					<p><?php _e('WP-DBManager can automatically backup your database after a certain period.', 'wp-dbmanager'); ?></p>
    543. 

  543. 				</td>
    544. 

  544. 			</tr>
    545. 

  545. 			<tr>
    546. 

  546. 				<td valign="top"><strong><?php _e('Automatic Optimizing Of DB:', 'wp-dbmanager'); ?></strong></td>
    547. 

  547. 				<td>
    548. 

  548. 					<?php
    549. 

  549. 						_e('Next optimize date: ', 'wp-dbmanager');
    550. 

  550. 						if(wp_next_scheduled('dbmanager_cron_optimize')) {
    551. 

  551. 							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>';
    552. 

  552. 						} else {
    553. 

  553. 							_e('N/A', 'wp-dbmanager');
    554. 

  554. 						}
    555. 

  555. 					?>
    556. 

  556. 					<p>
    557. 

  557. 					<?php _e('Every', 'wp-dbmanager'); ?>&nbsp;<input type="text" name="db_optimize" size="3" maxlength="5" value="<?php echo intval($backup_options['optimize']); ?>" />&nbsp;
    558. 

  558. 					<select name="db_optimize_period" size="1">
    559. 

  559. 						<option value="0"<?php selected('0', $backup_options['optimize_period']); ?>><?php _e('Disable', 'wp-dbmanager'); ?></option>
    560. 

  560. 						<option value="60"<?php selected('60', $backup_options['optimize_period']); ?>><?php _e('Minutes(s)', 'wp-dbmanager'); ?></option>
    561. 

  561. 						<option value="3600"<?php selected('3600', $backup_options['optimize_period']); ?>><?php _e('Hour(s)', 'wp-dbmanager'); ?></option>
    562. 

  562. 						<option value="86400"<?php selected('86400', $backup_options['optimize_period']); ?>><?php _e('Day(s)', 'wp-dbmanager'); ?></option>
    563. 

  563. 						<option value="604800"<?php selected('604800', $backup_options['optimize_period']); ?>><?php _e('Week(s)', 'wp-dbmanager'); ?></option>
    564. 

  564. 						<option value="18144000"<?php selected('18144000', $backup_options['optimize_period']); ?>><?php _e('Month(s)', 'wp-dbmanager'); ?></option>
    565. 

  565. 					</select>
    566. 

  566. 					</p>
    567. 

  567. 					<p><?php _e('WP-DBManager can automatically optimize your database after a certain period.', 'wp-dbmanager'); ?></p>
    568. 

  568. 				</td>
    569. 

  569. 			</tr>
    570. 

  570. 			<tr>
    571. 

  571. 				<td valign="top"><strong><?php _e('Automatic Repairing Of DB:', 'wp-dbmanager'); ?></strong></td>
    572. 

  572. 				<td>
    573. 

  573. 					<?php
    574. 

  574. 						_e('Next repair date: ', 'wp-dbmanager');
    575. 

  575. 						if(wp_next_scheduled('dbmanager_cron_repair')) {
    576. 

  576. 							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>';
    577. 

  577. 						} else {
    578. 

  578. 							_e('N/A', 'wp-dbmanager');
    579. 

  579. 						}
    580. 

  580. 					?>
    581. 

  581. 					<p>
    582. 

  582. 					<?php _e('Every', 'wp-dbmanager'); ?>&nbsp;<input type="text" name="db_repair" size="3" maxlength="5" value="<?php echo intval($backup_options['repair']); ?>" />&nbsp;
    583. 

  583. 					<select name="db_repair_period" size="1">
    584. 

  584. 						<option value="0"<?php selected('0', $backup_options['repair_period']); ?>><?php _e('Disable', 'wp-dbmanager'); ?></option>
    585. 

  585. 						<option value="60"<?php selected('60', $backup_options['repair_period']); ?>><?php _e('Minutes(s)', 'wp-dbmanager'); ?></option>
    586. 

  586. 						<option value="3600"<?php selected('3600', $backup_options['repair_period']); ?>><?php _e('Hour(s)', 'wp-dbmanager'); ?></option>
    587. 

  587. 						<option value="86400"<?php selected('86400', $backup_options['repair_period']); ?>><?php _e('Day(s)', 'wp-dbmanager'); ?></option>
    588. 

  588. 						<option value="604800"<?php selected('604800', $backup_options['repair_period']); ?>><?php _e('Week(s)', 'wp-dbmanager'); ?></option>
    589. 

  589. 						<option value="18144000"<?php selected('18144000', $backup_options['repair_period']); ?>><?php _e('Month(s)', 'wp-dbmanager'); ?></option>
    590. 

  590. 					</select>
    591. 

  591. 					</p>
    592. 

  592. 					<p><?php _e('WP-DBManager can automatically repair your database after a certain period.', 'wp-dbmanager'); ?></p>
    593. 

  593. 				</td>
    594. 

  594. 			</tr>
    595. 

  595. 		</table>
    596. 

  596. 		<p class="submit">
    597. 

  597. 			<input type="submit" name="Submit" class="button" value="<?php _e('Save Changes', 'wp-dbmanager'); ?>" />
    598. 

  598. 		</p>
    599. 

  599. 	</div>
    600. 

  600. </form>
    601. 

  601. <?php
    602. 

  602. }
    603. 

  603. ?>
    604.