***************************************************************************/
require_once '../inc/header.inc.php';
require_once BX_DIRECTORY_PATH_INC . 'design.inc.php';
require_once BX_DIRECTORY_PATH_INC . 'admin_design.inc.php';
require_once BX_DIRECTORY_PATH_CLASSES . 'BxDolDatabaseBackup.php';
$logged['admin'] = member_auth(1, true, true);
$_page['header'] = "Database tools";
$_page['header_text'] = "Manage Database";
set_time_limit(36000);
$status_text .= '';
if (isset($_POST['TablesBackup'])) {
##Block of table backup create
//echo "For: Tables Tools". $_POST['tbl_op'] . ' Table - ' . $_POST['tbl'] . ' Show param - ' . $_POST['savetype'] ;
$OutPutType = preg_replace("/[^0-9]/", '', $_POST['tbl_op']);
$oNewBackup = new BxDolDatabaseBackup();
$oNewBackup->_getTableStruct($_POST['tbl'], $OutPutType);
if ($_POST['savetype'] == 'client') {
$sqlfile = date("Y-m-d_H:i:s") . '_' . $_POST['tbl'] . '.sql';
header("Content-Type: text/plain");
header("Content-Disposition: attachment;filename=\"" . $sqlfile . "\"");
echo $oNewBackup->sInputs;
exit;
}
if ($_POST['savetype'] == 'server') {
$sqlfile = $dir['root'] . 'backup/' . date("Y-m-d_H-i-s") . '_' . $_POST['tbl'] . '.sql';
$file = fopen($sqlfile, 'w');
fputs($file, $oNewBackup->sInputs);
$status_text .= "<hr size=1 /><font color='green'><center>Data succefully dumped into file <b>{$sqlfile}</b></center></font>\n";
fclose($file);
}
if ($_POST['savetype'] == 'show') {
function getActionResultBlock()
{
$sSuccDumpedIntoFileC = _t('_adm_dbtools_succ_dumped_into_file');
$sDumpFileSuccDeletedC = _t('_adm_dbtools_Dump_file_succefully_deleted');
$sPleaseSelectDumpFileC = _t('_adm_dbtools_Please_select_dump_file');
$sDateRestoredFromDumpC = _t('_adm_dbtools_Data_succefully_restored_from_dump');
$sPleaseSelectCorrectDumpFileC = _t('_adm_dbtools_Please_select_correct_dump_file');
$sDateRestoredFromPcC = _t('_adm_dbtools_Data_succefully_restored_from_PC');
$status_text = $status_text_restore = '';
if (isset($_POST['TablesBackup'])) {
##Block of table backup create
//echo "For: Tables Tools". $_POST['tbl_op'] . ' Table - ' . $_POST['tbl'] . ' Show param - ' . $_POST['savetype'] ;
$OutPutType = preg_replace("/[^0-9]/", '', $_POST['tbl_op']);
$oNewBackup = new BxDolDatabaseBackup();
$oNewBackup->_getTableStruct($_POST['tbl'], $OutPutType);
if ($_POST['savetype'] == 'client') {
$sqlfile = date("Y-m-d_H:i:s") . '_' . $_POST['tbl'] . '.sql';
header("Content-Type: text/plain");
header("Content-Disposition: attachment;filename=\"" . $sqlfile . "\"");
echo $oNewBackup->sInputs;
exit;
}
if ($_POST['savetype'] == 'server') {
$sqlfile = BX_DIRECTORY_PATH_ROOT . 'backup/' . date("Y-m-d_H-i-s") . '_' . $_POST['tbl'] . '.sql';
$file = fopen($sqlfile, 'w');
fputs($file, $oNewBackup->sInputs);
$status_text .= "<hr size=1 /><font color='green'><center>{$sSuccDumpedIntoFileC} <b>{$sqlfile}</b></center></font>\n";
fclose($file);
}
if ($_POST['savetype'] == 'show') {
$status_text = "<center><textarea cols='100' rows='30' name='content' style='font-family: Arial; font-size: 11px' readonly='readonly'>" . $oNewBackup->sInputs . "</textarea></center>";
}
}
if (isset($_POST['DatabasesBackup'])) {
$OutPutType = preg_replace("/[^0-9]/", '', $_POST['db_op']);
$oNewBackup = new BxDolDatabaseBackup();
$oNewBackup->_getAllTables($OutPutType);
if ($_POST['savetype'] == 'show') {
$status_text = "<center><textarea cols='100' rows='30' name='content' style='font-family: Arial; font-size: 11px' readonly='readonly'>" . $oNewBackup->sInputs . "</textarea></center>";
}
if ($_POST['savetype'] == 'server') {
$sqlfile = BX_DIRECTORY_PATH_ROOT . 'backup/' . date("Y-m-d_H-i-s") . '_all.sql';
$file = fopen($sqlfile, 'w');
fputs($file, $oNewBackup->sInputs);
$status_text .= "<hr size=1 /><font color='green'><center>{$sSuccDumpedIntoFileC} <b>{$sqlfile}</b></center></font>\n";
fclose($file);
}
if ($_POST['savetype'] == 'client') {
$sqlfile = date("Y-m-d_H:i:s") . '_all.sql';
header("Content-Type: text/plain");
header("Content-Disposition: attachment;filename=\"" . $sqlfile . "\"");
echo $oNewBackup->sInputs;
exit;
}
}
if (isset($_POST['DatabasesRestore'])) {
if ($_POST['savetype'] == 'delete') {
if (is_file(BX_DIRECTORY_PATH_ROOT . 'backup/' . $_POST['dump_file'])) {
@unlink(BX_DIRECTORY_PATH_ROOT . 'backup/' . $_POST['dump_file']);
$status_text_restore .= "<hr size=1 /><font color='green'><center>{$sDumpFileSuccDeletedC} <b>{$sqlfile}</b></center></font>\n";
} else {
$status_text_restore .= "<hr size=1 /><font color='red'><center>{$sPleaseSelectDumpFileC} <b>{$sqlfile}</b></center></font>\n";
}
}
if ($_POST['savetype'] == 'restore') {
if (is_file(BX_DIRECTORY_PATH_ROOT . 'backup/' . $_POST['dump_file'])) {
$oNewBackup = new BxDolDatabaseBackup();
$oNewBackup->_restoreFromDumpFile(BX_DIRECTORY_PATH_ROOT . 'backup/' . $_POST['dump_file']);
$status_text_restore .= "<hr size=1 /><font color='green'><center>{$sDateRestoredFromDumpC}</center></font>\n";
} else {
$status_text_restore .= "<hr size=1 /><font color='red'><center>{$sPleaseSelectDumpFileC} <b>{$sqlfile}</b></center></font>\n";
}
}
}
if (isset($_FILES['sqlfile'])) {
if (preg_match("/.sql/", $_FILES['sqlfile']['name'])) {
#it is correct
$oNewBackup = new BxDolDatabaseBackup();
$oNewBackup->_restoreFromDumpFile($_FILES['sqlfile']['tmp_name']);
@unlink($_FILES['sqlfile']['tmp_name']);
$status_text_restore .= "<hr size=1 /><font color='green'><center>{$sDateRestoredFromPcC} </center></font>\n";
} else {
$status_text_restore .= "<hr size=1 /><font color='red'><center>{$sPleaseSelectCorrectDumpFileC}</center></font>\n";
}
}
return array($status_text, $status_text_restore);
}