.
***********************************************************************/
$page_security = 15;
$path_to_root="..";
include_once($path_to_root . "/includes/session.inc");
include_once($path_to_root . "/includes/ui.inc");
include_once($path_to_root . "/admin/db/maintenance_db.inc");
if (get_post('view')) {
$filename = BACKUP_PATH . get_post('cmb_backups');
if (in_ajax())
$Ajax->popup( $filename );
else {
header('Content-type: application/octet-stream');
header('Content-Length: '.filesize($filename));
header("Content-Disposition: inline; filename=$filename");
readfile($filename);
exit();
}
};
if (get_post('download')) {
download_file(BACKUP_PATH . get_post('cmb_backups'));
exit;
}
page(_("Backup and Restore Database"), false, false, '', '');
check_paths();
function check_paths()
{
if (!file_exists(BACKUP_PATH)) {
display_error (_("Backup paths have not been set correctly.")
._("Please contact System Administrator.")."
"
. _("cannot find backup directory") . " - " . BACKUP_PATH . "
");
end_page();
exit;
}
}
function generate_backup($conn, $ext='no', $comm='')
{
$filename = db_backup($conn, $ext, $comm);
if ($filename)
display_notification(_("Backup successfully generated."). ' '
. _("Filename") . ": " . $filename);
else
display_error(_("Database backup failed."));
return $filename;
}
function get_backup_file_combo()
{
global $path_to_root, $Ajax;
$ar_files = array();
default_focus('cmb_backups');
$dh = opendir(BACKUP_PATH);
while (($file = readdir($dh)) !== false)
$ar_files[] = $file;
closedir($dh);
rsort($ar_files);
$opt_files = "";
foreach ($ar_files as $file)
if (preg_match("/.sql(.zip|.gz)?$/", $file))
$opt_files .= "";
$selector = "";
$Ajax->addUpdate('cmd_backups', "_cmd_backups_sel", $selector);
$selector = "".$selector."\n";
return $selector;
}
function compress_list_row($label, $name, $value=null)
{
$ar_comps = array('no'=>_("No"));
if (function_exists("gzcompress"))
$ar_comps['zip'] = "zip";
if (function_exists("gzopen"))
$ar_comps['gzip'] = "gzip";
echo "
$label | ";
array_selector('comp', $value, $ar_comps);
echo " |
";
}
function download_file($filename)
{
if (empty($filename) || !file_exists($filename))
{
return false;
}
$saveasname = basename($filename);
header('Content-type: application/octet-stream');
header('Content-Length: '.filesize($filename));
header('Content-Disposition: attachment; filename="'.$saveasname.'"');
readfile($filename);
return true;
}
$db_name = $_SESSION["wa_current_user"]->company;
$conn = $db_connections[$db_name];
if (get_post('creat')) {
generate_backup($conn, get_post('comp'), get_post('comments'));
$Ajax->activate('cmd_backups');
};
if (get_post('restore')) {
if (db_import(BACKUP_PATH . get_post('cmb_backups'), $conn))
display_notification(_("Restore backup completed."));
}
if (get_post('delete')) {
if (unlink(BACKUP_PATH . get_post('cmb_backups'))) {
display_notification(_("File successfully deleted.")." "
. _("Filename") . ": " . get_post('cmb_backups'));
$Ajax->activate('cmd_backups');
}
else
display_error(_("Can't delete backup file."));
};
if (get_post('upload'))
{
$tmpname = $_FILES['uploadfile']['tmp_name'];
$fname = $_FILES['uploadfile']['name'];
if (!preg_match("/.sql(.zip|.gz)?$/", $fname))
display_error(_("You can only upload *.sql backup files"));
elseif (is_uploaded_file($tmpname)) {
rename($tmpname, BACKUP_PATH . $fname);
display_notification( "File uploaded to backup directory");
$Ajax->activate('cmd_backups');
} else
display_error(_("File was not uploaded into the system."));
}
//-------------------------------------------------------------------------------
start_form(true, true);
start_outer_table($table_style2);
table_section(1);
table_section_title(_("Create backup"));
textarea_row(_("Comments:"), 'comments', null, 30, 8);
compress_list_row(_("Compression:"),'comp');
vertical_space("height='20px'");
submit_row('creat',_("Create Backup"), false, "colspan=2 align='center'", '', 'process');
table_section(2);
table_section_title(_("Backup scripts maintenance"));
start_row();
echo "".get_backup_file_combo()." | ";
echo "";
start_table();
submit_row('view',_("View Backup"), false, '', '', true);
submit_row('download',_("Download Backup"), false, '', '', false);
submit_row('restore',_("Restore Backup"), false, '','', 'process');
$js = "if(confirm(\""
.sprintf(_('You are about to remove %s backup file. Do you want to continue ?'),
get_post('cmb_backups'))
."\")) { JsHttpRequest.request(\"delete\"); }";
submit_row('delete', _("Delete Backup"), false, '','', 'dialog');
end_table();
echo " | ";
end_row();
start_row();
echo " | ";
submit_cells('upload',_("Upload file"),'', '', true);
end_row();
end_outer_table();
end_form();
end_page();
?>