Пример #1
0
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'] = sanitize_text_field($_POST['db_mysqldumppath']);
        $backup_options['mysqlpath'] = sanitize_text_field($_POST['db_mysqlpath']);
        $backup_options['path'] = sanitize_text_field($_POST['db_path']);
        $backup_options['max_backup'] = intval($_POST['db_max_backup']);
        $backup_options['backup'] = intval($_POST['db_backup']);
        $backup_options['backup_gzip'] = intval($_POST['db_backup_gzip']);
        $backup_options['backup_period'] = intval($_POST['db_backup_period']);
        $backup_options['backup_email'] = sanitize_email($_POST['db_backup_email']);
        $backup_options['backup_email_from'] = sanitize_email($_POST['db_backup_email_from']);
        $backup_options['backup_email_from_name'] = sanitize_text_field($_POST['db_backup_email_from_name']);
        $backup_options['backup_email_subject'] = sanitize_text_field($_POST['db_backup_email_subject']);
        $backup_options['optimize'] = intval($_POST['db_optimize']);
        $backup_options['optimize_period'] = intval($_POST['db_optimize_period']);
        $backup_options['repair'] = intval($_POST['db_repair']);
        $backup_options['repair_period'] = intval($_POST['db_repair_period']);
        $backup_options['hide_admin_notices'] = intval($_POST['db_hide_admin_notices']);
        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" />&nbsp;&nbsp;<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" />&nbsp;&nbsp;<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="100" 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');
    ?>
&nbsp;<input type="text" name="db_backup" size="3" maxlength="5" value="<?php 
    echo intval($backup_options['backup']);
    ?>
" />&nbsp;
						<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>&nbsp;&nbsp;&nbsp;
						<?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');
    ?>
&nbsp;<input type="text" name="db_optimize" size="3" maxlength="5" value="<?php 
    echo intval($backup_options['optimize']);
    ?>
" />&nbsp;
					<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');
    ?>
&nbsp;<input type="text" name="db_repair" size="3" maxlength="5" value="<?php 
    echo intval($backup_options['repair']);
    ?>
" />&nbsp;
					<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" />&nbsp;
						&lt;<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" />&gt;
					</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 intval($backup_options['hide_admin_notices']) === 1 ? ' checked="checked"' : '';
    ?>
 />&nbsp;<?php 
    _e('Yes', 'wp-dbmanager');
    ?>
						<input type="radio" name="db_hide_admin_notices" value="0"<?php 
    echo intval($backup_options['hide_admin_notices']) === 0 ? ' checked="checked"' : '';
    ?>
 />&nbsp;<?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 
}
Пример #2
0
function dbmanager_options()
{
    global $wpdb;
    $text = '';
    $backup_options = array();
    $backup_options = get_option('dbmanager_options');
    if ($_POST['Submit']) {
        $backup_options['mysqldumppath'] = trim($_POST['db_mysqldumppath']);
        $backup_options['mysqlpath'] = trim($_POST['db_mysqlpath']);
        $backup_options['path'] = trim($_POST['db_path']);
        $backup_options['max_backup'] = intval($_POST['db_max_backup']);
        $backup_options['backup'] = intval($_POST['db_backup']);
        $backup_options['backup_gzip'] = intval($_POST['db_backup_gzip']);
        $backup_options['backup_period'] = intval($_POST['db_backup_period']);
        $backup_options['backup_email'] = trim(addslashes($_POST['db_backup_email']));
        $backup_options['optimize'] = intval($_POST['db_optimize']);
        $backup_options['optimize_period'] = intval($_POST['db_optimize_period']);
        $update_db_options = update_option('dbmanager_options', $backup_options);
        if ($update_db_options) {
            $text = '<font color="green">' . __('Database Options Updated', 'wp-dbmanager') . '</font>';
        }
        if (empty($text)) {
            $text = '<font color="red">' . __('No Database Option Updated', 'wp-dbmanager') . '</font>';
        }
        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');
            }
        }
    }
    $path = detect_mysql();
    ?>
<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 '<!-- Last Action --><div id="message" class="updated fade"><p>' . $text . '</p></div>';
    }
    ?>
<!-- Database Options -->
<form method="post" action="<?php 
    echo admin_url('admin.php?page=' . plugin_basename(__FILE__));
    ?>
">
	<div class="wrap">
		<div id="icon-wp-dbmanager" class="icon32"><br /></div>
		<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" />&nbsp;&nbsp;<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" />&nbsp;&nbsp;<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="100" 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');
    ?>
&nbsp;<input type="text" name="db_backup" size="3" maxlength="5" value="<?php 
    echo intval($backup_options['backup']);
    ?>
" />&nbsp;
					<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="18144000"<?php 
    selected('18144000', $backup_options['backup_period']);
    ?>
><?php 
    _e('Month(s)', 'wp-dbmanager');
    ?>
</option>
					</select>&nbsp;&nbsp;&nbsp;
					<?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('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>
					<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');
    ?>
&nbsp;<input type="text" name="db_optimize" size="3" maxlength="5" value="<?php 
    echo intval($backup_options['optimize']);
    ?>
" />&nbsp;
					<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="18144000"<?php 
    selected('18144000', $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>
		</table>
		<p class="submit">
			<input type="submit" name="Submit" class="button" value="<?php 
    _e('Save Changes', 'wp-dbmanager');
    ?>
" />
		</p>
	</div>
</form>
<?php 
}