***************************************************************************/ 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); }