display_error(_("Select backup file first."));
}
}
//-------------------------------------------------------------------------------
start_form(true, true);
start_outer_table(TABLESTYLE2);
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 "<td style='padding-left:20px' align='left'>" . get_backup_file_combo() . "</td>";
echo "<td style='padding-left:20px' valign='top'>";
start_table();
submit_row('view', _("View Backup"), false, '', '', false);
submit_row('download', _("Download Backup"), false, '', '', false);
submit_row('restore', _("Restore Backup"), false, '', '', 'process');
submit_js_confirm('restore', _("You are about to restore database from backup file.\nDo you want to continue?"));
submit_row('deldump', _("Delete Backup"), false, '', '', true);
// don't use 'delete' name or IE js errors appear
submit_js_confirm('deldump', sprintf(_("You are about to remove selected backup file.\nDo you want to continue ?")));
end_table();
echo "</td>";
end_row();
start_row();
echo "<td style='padding-left:20px' align='left'><input name='uploadfile' type='file'></td>";
submit_cells('upload', _("Upload file"), "style='padding-left:20px'", '', true);
include_once $path_to_root . "/includes/ui.inc";
include_once $path_to_root . "/admin/db/maintenance_db.inc";
$valid_paths = valid_paths();
//$valid_paths = '';
if ($valid_paths != "") {
page(tr("Backup and Restore Database - Error"));
display_error(tr("Backup paths have not been set correctly.") . " " . tr("Please contact System Administrator.") . "<br>" . $valid_paths);
end_page();
exit;
}
$db_name = $_SESSION["wa_current_user"]->company;
$msg = handle_form($db_connections[$db_name]);
page(tr("Backup and Restore Database"));
//-------------------------------------------------------------------------------
start_form(true, true);
$cmb = get_backup_file_combo();
$compr = get_compr_combo();
echo "\n\t<script language='javascript'>\n\tfunction createBackup() {\n\t\text = document.forms[0].cmb_comp.options[document.forms[0].cmb_comp.selectedIndex].value\n\t\tcomm = document.forms[0].comments.value\n\t\tdocument.location.replace('backups.php?c=g&comp='+ext+'&comm='+comm)\n\t}\n\tfunction restoreBackup() {\n\t\tpFilename = document.forms[0].cmb_backups.options[document.forms[0].cmb_backups.selectedIndex].value\n\t\tdocument.location.replace('backups.php?c=r&fn='+pFilename)\n\t}\n\tfunction viewBackup() {\n\t\tpFilename = document.forms[0].cmb_backups.options[document.forms[0].cmb_backups.selectedIndex].value\n\t\tvar ext = pFilename.substr(pFilename.lastIndexOf('.') + 1)\n\t\tif (ext != 'sql') {\n\t\t\talert('" . tr('This extension can not be be viewed: ') . "' + ext)\n\t\t\treturn\n\t\t}\t\n\t\twindow.open('" . BACKUP_PATH . "'+pFilename, '', 'toolbar=no,scrollbars=yes')\n\t}\n\tfunction deleteBackup() {\n\t\tpFilename = document.forms[0].cmb_backups.options[document.forms[0].cmb_backups.selectedIndex].value\n\t\tif (!confirm('" . tr("Are you sure you want to delete the backup file - ") . "'+pFilename+'?'))\n\t\t\treturn\n\t\tdocument.location.replace('backups.php?c=df&fn='+pFilename)\n\t}\n\tfunction downloadBackup() {\n\t\tpFilename = document.forms[0].cmb_backups.options[document.forms[0].cmb_backups.selectedIndex].value\n\t\tdocument.location.replace('backups.php?c=ds&fn='+pFilename)\n\t}\n\tfunction uploadBackup() {\n\t\tif (document.forms[0].uploadfile.value=='') {\n\t\t\talert('" . tr("Please select a file to upload.") . "')\n\t\t\treturn\n\t\t}\n\t\tdocument.forms[0].action='backups.php?c=u&fn=' + document.forms[0].uploadfile.value\n\t\tdocument.forms[0].submit()\n\t}\n\t</script>\n\t<center>\n\t<table cellpadding=2 cellspacing=2 border=0>\n\t<tr><td colspan=2 style='color:darkred'><b>{$msg}</b> </td></tr>\n\t<tr>\n\t\t<td style='padding-right:30'>" . tr("Backup scripts") . "</td>\n\t</tr>\n\t<tr>\n\t\t<td style='padding-right:30'>{$cmb}</td>\n\t\t<script language='javascript'>\n\t\t\tif (document.forms[0].cmb_backups.options.length!=0) document.forms[0].cmb_backups.selectedIndex=0\n\t\t</script>\n\t\t<td>\n\t\t\t<table height=160 cellpadding=0 cellspacing=0 border=0>\n\t\t\t<tr><td><input onclick='javascript:createBackup()' type='button' style='width:150' value='" . tr("Create Backup") . "'></td><td style='padding-left:20'>" . tr("Compression") . " {$compr}</td></tr>\n\t\t\t<tr><td><input onclick='javascript:restoreBackup()' type='button' style='width:150' value='" . tr("Restore Backup") . "'></td><td> </td></tr>\n\t\t\t<tr><td><input onclick='javascript:viewBackup()' type='button' style='width:150' value='" . tr("View Backup") . "'></td><td> </td></tr>\n\t\t\t<tr><td><input onclick='javascript:deleteBackup()' type='button' style='width:150' value='" . tr("Delete Backup") . "'></td><td> </td></tr>\n\t\t\t<tr><td><input onclick='javascript:downloadBackup()' type='button' style='width:150' value='" . tr("Download Backup") . "'></td><td> </td></tr>\n\t\t\t<tr><td><input onclick='javascript:uploadBackup()' type='button' style='width:150' value='" . tr("Upload Backup") . "'></td>\n\t\t\t\t<td style='padding-left:20'><input name='uploadfile' type='file'></td>\n\t\t\t</tr>\n\t\t\t</table>\n\t\t</td>\n\t</tr>\n\t<tr>\n\t\t<td style='padding-right:30'>" . tr("Comments") . " (" . tr("Create Backup") . ")</td>\n\t</tr>\n\t<tr>\n\t\t<td style='padding-right:30'><textarea rows=4 cols=30 name='comments'></textarea></td>\n\t</tr>\n\t</table></center>";
end_form();
//-------------------------------------------------------------------------------------------------
end_page();
function handle_form($conn)
{
global $path_to_root;
//Generate Only
if (isset($_GET['c'])) {
if ($_GET['c'] == 'g') {
$filename = generate_backup($conn, $_GET['comp'], $_GET['comm']);
header("Location: backups.php?c=gs&fn=" . urlencode($filename));
return "";
}
