} } if ($_POST['savetype'] == 'restore') { if (is_file($dir['root'] . 'backup/' . $_POST['dump_file'])) { $oNewBackup = new BxDolDatabaseBackup(); $oNewBackup->_restoreFromDumpFile($dir['root'] . 'backup/' . $_POST['dump_file']); $status_text .= "<hr size=1 /><font color='green'><center>Data succefully restored from server dump</center></font>\n"; } else { $status_text .= "<hr size=1 /><font color='red'><center>Please select dump file <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 .= "<hr size=1 /><font color='green'><center>Data succefully restored from your PS </center></font>\n"; } else { $status_text .= "<hr size=1 /><font color='red'><center>Please select correct dump file (only *.sql)</center></font>\n"; } } TopCodeAdmin(); ContentBlockHead('Tables backup tools'); ?> <center> <form style="padding: 0px; margin: 0px;" method="post" action="<?php echo $_SERVER['PHP_SELF'];
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); }