INCLUDE_ORDERING_ERROR

Please use the EVO Content Manager instead of accessing this file directly."); } if (!$modx->hasPermission('bk_manager')) { $modx->webAlertAndQuit($_lang["error_no_privileges"]); } require_once MODX_BASE_PATH.'assets/lib/Helpers/FS.php'; $dbase = trim($dbase, '`'); if (!isset($modx->config['snapshot_path'])) { if (is_dir(MODX_BASE_PATH . 'temp/backup/')) { $modx->config['snapshot_path'] = MODX_BASE_PATH . 'temp/backup/'; } else { $modx->config['snapshot_path'] = MODX_BASE_PATH . 'assets/backup/'; } } // Backup Manager by Raymond: $mode = isset($_POST['mode']) ? $_POST['mode'] : ''; if ($mode == 'restore1') { if (isset($_POST['textarea']) && !empty($_POST['textarea'])) { $source = trim($_POST['textarea']); $_SESSION['textarea'] = $source . "\n"; import_sql($source); } else { import_sql_from_file($_FILES['sqlfile']['tmp_name']); } header('Location: index.php?r=9&a=93'); exit; } elseif ($mode == 'restore2') { $path = $modx->config['snapshot_path'] . $_POST['filename']; if (file_exists($path)) { import_sql_from_file($path); if (headers_sent()) { echo "\n"; } else { header("Location: index.php?r=9&a=93"); } } exit; } elseif ($mode == 'backup') { $tables = isset($_POST['chk']) ? $_POST['chk'] : ''; if (!is_array($tables)) { $modx->webAlertAndQuit("Please select a valid table from the list below."); } /* * Code taken from Ralph A. Dahlgren MySQLdumper Snippet - Etomite 0.6 - 2004-09-27 * Modified by Raymond 3-Jan-2005 * Perform MySQLdumper data dump */ @set_time_limit(120); // set timeout limit to 2 minutes $dumper = new Mysqldumper($dbase); $dumper->setDBtables($tables); $dumper->setDroptables((isset($_POST['droptables']) ? true : false)); $dumpfinished = $dumper->createDump('dumpSql'); if ($dumpfinished) { exit; } else { $modx->webAlertAndQuit('Unable to Backup Database'); } // MySQLdumper class can be found below } elseif ($mode == 'snapshot') { if (!is_dir(rtrim($modx->config['snapshot_path'], '/'))) { mkdir(rtrim($modx->config['snapshot_path'], '/')); @chmod(rtrim($modx->config['snapshot_path'], '/'), 0777); } if (!is_file("{$modx->config['snapshot_path']}.htaccess")) { $htaccess = "order deny,allow\ndeny from all\n"; file_put_contents("{$modx->config['snapshot_path']}.htaccess", $htaccess); } if (!is_writable(rtrim($modx->config['snapshot_path'], '/'))) { $modx->webAlertAndQuit(parsePlaceholder($_lang["bkmgr_alert_mkdir"], array('snapshot_path' => $modx->config['snapshot_path']))); } $sql = "SHOW TABLE STATUS FROM `{$dbase}` LIKE '" . $modx->db->escape($modx->db->config['table_prefix']) . "%'"; $rs = $modx->db->query($sql); $tables = $modx->db->getColumn('Name', $rs); $today = date('Y-m-d_H-i-s'); global $path; $path = "{$modx->config['snapshot_path']}{$today}.sql"; @set_time_limit(120); // set timeout limit to 2 minutes $dumper = new Mysqldumper($dbase); $dumper->setDBtables($tables); $dumper->setDroptables(true); $dumpfinished = $dumper->createDump('snapshot'); $pattern = "{$modx->config['snapshot_path']}*.sql"; $files = glob($pattern, GLOB_NOCHECK); $total = ($files[0] !== $pattern) ? count($files) : 0; arsort($files); while (10 < $total && $limit < 50) { $del_file = array_pop($files); unlink($del_file); $total = count($files); $limit++; } if ($dumpfinished) { $_SESSION['result_msg'] = 'snapshot_ok'; header("Location: index.php?a=93"); exit; } else { $modx->webAlertAndQuit('Unable to Backup Database'); } } else { include_once MODX_MANAGER_PATH . "includes/header.inc.php"; // start normal header } if (isset($_SESSION['result_msg']) && $_SESSION['result_msg'] != '') { switch ($_SESSION['result_msg']) { case 'import_ok': $ph['result_msg_import'] = '
' . $_lang["bkmgr_import_ok"] . '
'; $ph['result_msg_snapshot'] = '
' . $_lang["bkmgr_import_ok"] . '
'; break; case 'snapshot_ok': $ph['result_msg_import'] = ''; $ph['result_msg_snapshot'] = '
' . $_lang["bkmgr_snapshot_ok"] . '
'; break; } $_SESSION['result_msg'] = ''; } else { $ph['result_msg_import'] = ''; $ph['result_msg_snapshot'] = ''; } ?>

db->escape($modx->db->config['table_prefix']) . "%'"; $rs = $modx->db->query($sql); $i = 0; while ($db_status = $modx->db->getRow($rs)) { if (isset($tables)) { $table_string = implode(',', $table); } else { $table_string = ''; } echo '' . "\n" . '' . "\n"; echo '' . "\n"; echo '' . "\n"; echo '' . "\n"; // Enable record deletion for certain tables (TRUNCATE TABLE) if they're not already empty $truncateable = array( $modx->db->config['table_prefix'] . 'event_log', $modx->db->config['table_prefix'] . 'manager_log', ); if ($modx->hasPermission('settings') && in_array($db_status['Name'], $truncateable) && $db_status['Rows'] > 0) { echo '' . "\n"; } else { echo '' . "\n"; } if ($modx->hasPermission('settings')) { echo '' . "\n"; } else { echo '' . "\n"; } echo '' . "\n" . '' . "\n" . '' . "\n" . ""; $total = $total + $db_status['Index_length'] + $db_status['Data_length']; $totaloverhead = $totaloverhead + $db_status['Data_free']; } ?>
' . (!empty($db_status['Comment']) ? '' : '') . '' . $db_status['Rows'] . '' . $db_status['Collation'] . '' . $modx->nicesize($db_status['Data_length'] + $db_status['Data_free']) . '' . '' . $modx->nicesize($db_status['Data_length'] + $db_status['Data_free']) . '' . ($db_status['Data_free'] > 0 ? '' . $modx->nicesize($db_status['Data_free']) . '' : '-') . '' . ($db_status['Data_free'] > 0 ? $modx->nicesize($db_status['Data_free']) : '-') . '' . $modx->nicesize($db_status['Data_length'] - $db_status['Data_free']) . '' . $modx->nicesize($db_status['Index_length']) . '' . $modx->nicesize($db_status['Index_length'] + $db_status['Data_length'] + $db_status['Data_free']) . '
  0 ? '' . $modx->nicesize($totaloverhead) . '
(' . number_format($totaloverhead) . ' B)' : '-' ?>		   " . $modx->nicesize($total) . "
(" . number_format($total) . " B)" ?>
0) { ?>

$v) { $title[] = $k; } $result = '' . implode('', $title) . ''; $result .= ''; foreach ($last_result as $row) { $result_value = array(); if ($row) { foreach ($row as $k => $v) { $result_value[] = $v; } $result .= '' . implode('', $result_value) . ''; } } $result .= ''; $result = '' . $result . '
'; } } function checked($cond) { if ($cond) { return ' checked'; } } ?>

"snapshot_path={$modx->config['snapshot_path']}")) ?>
config['snapshot_path']}*.sql"; $files = glob($pattern, GLOB_NOCHECK); $total = ($files[0] !== $pattern) ? count($files) : 0; $detailFields = array( 'MODX Version', 'Host', 'Generation Time', 'Server version', 'PHP Version', 'Database', 'Description' ); if (is_array($files) && 0 < $total) { ?>
nicesize(filesize($file)); $file = fopen($file, "r"); $count = 0; $details = array(); while ($count < 11) { $line = fgets($file); foreach ($detailFields as $label) { $fileLabel = '# ' . $label; if (strpos($line, $fileLabel) !== false) { $details[$label] = htmlentities(trim(str_replace(array( $fileLabel, ':', '`' ), '', $line)), ENT_QUOTES, $modx_manager_charset); } } $count++; }; fclose($file); $tooltip = "Generation Time: " . $details["Generation Time"] . "\n"; $tooltip .= "Server version: " . $details["Server version"] . "\n"; $tooltip .= "PHP Version: " . $details["PHP Version"] . "\n"; $tooltip .= "Host: " . $details["Host"] . "\n"; ?>
tpDBM.setSelectedIndex( ' . $_GET['tab'] . ' );'; } include_once "footer.inc.php"; // send footer ?> * @url http://www.mosix.nl/mysqldumper * @since PHP 4.0 * @copyright Dennis Mozes * @license GNU/LGPL License: http://www.gnu.org/copyleft/lgpl.html * * Modified by Raymond for use with this module * **/ class Mysqldumper { /** * @var array */ public $_dbtables; /** * @var bool */ public $_isDroptables; /** * @var string */ public $dbname; /** * @var string */ public $database_server; /** * Mysqldumper constructor. * @param string $dbname */ public function __construct($dbname) { // Don't drop tables by default. $this->dbname = $dbname; $this->setDroptables(false); } /** * If set to true, it will generate 'DROP TABLE IF EXISTS'-statements for each table. * * @param bool $state */ public function setDroptables($state) { $this->_isDroptables = $state; } /** * @param array $dbtables */ public function setDBtables($dbtables) { $this->_dbtables = $dbtables; } /** * @param string $callBack * @return bool */ public function createDump($callBack) { $modx = evolutionCMS(); $createtable = array(); $FS = \Helpers\FS::getInstance(); // Set line feed $lf = "\n"; $tempfile_path = $modx->config['base_path'] . 'assets/backup/temp.php'; //если предедущая выгрузка завершылась не верно if($FS->checkFile($tempfile_path)){ unlink($tempfile_path); } $result = $modx->db->query('SHOW TABLES'); $tables = $this->result2Array(0, $result); foreach ($tables as $tblval) { $result = $modx->db->query("SHOW CREATE TABLE `{$tblval}`"); $createtable[$tblval] = $this->result2Array(1, $result); } $version = $modx->getVersionData(); // Set header $output = "#{$lf}"; $output .= "# " . addslashes($modx->config['site_name']) . " Database Dump{$lf}"; $output .= "# MODX Version:{$version['version']}{$lf}"; $output .= "# {$lf}"; $output .= "# Host: {$this->database_server}{$lf}"; $output .= "# Generation Time: " . $modx->toDateFormat(time()) . $lf; $output .= "# Server version: " . $modx->db->getVersion() . $lf; $output .= "# PHP Version: " . phpversion() . $lf; $output .= "# Database: `{$this->dbname}`{$lf}"; $output .= "# Description: " . trim($_REQUEST['backup_title']) . "{$lf}"; $output .= "#"; file_put_contents($tempfile_path, $output, FILE_APPEND | LOCK_EX); $output = ''; // Generate dumptext for the tables. if (isset($this->_dbtables) && count($this->_dbtables)) { $this->_dbtables = implode(',', $this->_dbtables); } else { unset($this->_dbtables); } foreach ($tables as $tblval) { // check for selected table if (isset($this->_dbtables)) { if (strstr(",{$this->_dbtables},", ",{$tblval},") === false) { continue; } } if ($callBack === 'snapshot') { if (!preg_match('@^' . $modx->db->config['table_prefix'] . '@', $tblval)) { continue; } } $output .= "{$lf}{$lf}# --------------------------------------------------------{$lf}{$lf}"; $output .= "#{$lf}# Table structure for table `{$tblval}`{$lf}"; $output .= "#{$lf}{$lf}"; // Generate DROP TABLE statement when client wants it to. if ($this->isDroptables()) { $output .= "SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;{$lf}"; $output .= "DROP TABLE IF EXISTS `{$tblval}`;{$lf}"; $output .= "SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;{$lf}{$lf}"; } $output .= "{$createtable[$tblval][0]};{$lf}"; $output .= $lf; $output .= "#{$lf}# Dumping data for table `{$tblval}`{$lf}#{$lf}"; file_put_contents($tempfile_path, $output, FILE_APPEND | LOCK_EX); $output = ''; //количество строк за запрос $rowByOneQuery = 10000; //делим на части $rowCount = $modx->db->getValue($modx->db->select("COUNT(*)",$tblval)); // Находим общее число страниц $total = intval(($rowCount - 1) / $rowByOneQuery) + 1; $queryCounts = 0; for ($page = 1; $page <= $total; $page++) { $start = $page * $rowByOneQuery - $rowByOneQuery; $result = $modx->db->select('*', $tblval, '', '', "$start, $rowByOneQuery"); while ($arr = $modx->db->getRow($result)) { //формируем блок значений $insertdump = "("; if (!is_array($arr)) $arr = array(); foreach ($arr as $key => $value) { if (is_null($value)) { $value = 'NULL'; } else { $value = addslashes($value); $value = str_replace(array( "\r\n", "\r", "\n" ), '\\n', $value); $value = "'{$value}'"; } $insertdump .= $value . ','; } $insertdump = rtrim($insertdump, ',') . ")"; //если еще небыло значен if($queryCounts === 0){ $output .= $lf."INSERT INTO `{$tblval}` VALUES"; } else{ $output .= ","; } $output .= $lf." ".$insertdump; $queryCounts++; //если записали больше 30 строк з запрос ставим ; и сбрасивыем счетчик if($queryCounts>30){ $output .= ";".$lf; $queryCounts = 0; } //если большая строрки пишем в файл чтоб не перегрузить память if (5040000 < strlen($output)) { file_put_contents($tempfile_path, $output, FILE_APPEND | LOCK_EX); $output = ''; } } } //если данные есть, и записано больше 0 строк данных ставим ; в конце if(!empty($output) && $queryCounts >0){ $output .= ";".$lf; } //пишем блок в файл file_put_contents($tempfile_path, $output, FILE_APPEND | LOCK_EX); $output = ''; } switch ($callBack) { case 'dumpSql': dumpSql($tempfile_path); break; case 'snapshot': snapshot($tempfile_path); break; } return true; } /** * @param int $numinarray * @param mysqli_result $resource * @return array */ public function result2Array($numinarray = 0, $resource) { $modx = evolutionCMS(); $array = array(); while ($row = $modx->db->getRow($resource, 'num')) { $array[] = $row[$numinarray]; } $modx->db->freeResult($resource); return $array; } /** * @return bool */ public function isDroptables() { return $this->_isDroptables; } /** * @param string $key * @param mysqli_result $resource * @return array */ public function loadObjectList($key = '', $resource) { $modx = evolutionCMS(); $array = array(); while ($row = $modx->db->getRow($resource, 'object')) { if ($key) { $array[$row->$key] = $row; } else { $array[] = $row; } } $modx->db->freeResult($resource); return $array; } /** * @param stdClass $obj * @return array|null */ public function object2Array($obj) { $array = null; if (is_object($obj)) { $array = array(); foreach (get_object_vars($obj) as $key => $value) { if (is_object($value)) { $array[$key] = $this->object2Array($value); } else { $array[$key] = $value; } } } return $array; } } /** * @param string $source * @param string $result_code */ function import_sql_from_file($path, $result_code = 'import_ok') { $modx = evolutionCMS(); $FS = \Helpers\FS::getInstance(); if(!$FS->checkFile($path)){ return false; } $fp = fopen($path,'r'); $output = ''; $inStructure = false; while (($buffer = fgets($fp)) !== false) { $output .= $buffer ."\n"; if(strlen($output) > 5040000 && $buffer === "\n"){ import_sql($output); $output = ''; } } import_sql($output); } /** * @param string $source * @param string $result_code */ function import_sql($source, $result_code = 'import_ok') { $modx = evolutionCMS(); global $e; $rs = null; if ($modx->getLockedElements() !== array()) { $modx->webAlertAndQuit("At least one Resource is still locked or edited right now by any user. Remove locks or ask users to log out before proceeding."); } $settings = getSettings(); if (strpos($source, "\r") !== false) { $source = str_replace(array( "\r\n", "\n", "\r" ), "\n", $source); } $sql_array = preg_split('@;[ \t]*\n@', $source); foreach ($sql_array as $sql_entry) { $sql_entry = trim($sql_entry, "\r\n; "); if (empty($sql_entry)) { continue; } $rs = $modx->db->query($sql_entry); } restoreSettings($settings); $modx->clearCache(); $_SESSION['last_result'] = ($rs !== null) ? null : $modx->db->makeArray($rs); $_SESSION['result_msg'] = $result_code; } /** * @param string $dumpTempFilePath * @return bool */ function dumpSql($dumpTempFilePath) { $modx = evolutionCMS(); $dumpstring = file_get_contents($dumpTempFilePath); $today = $modx->toDateFormat(time(), 'dateOnly'); $today = str_replace('/', '-', $today); $today = strtolower($today); $size = strlen($dumpstring); if (!headers_sent()) { header('Expires: 0'); header('Cache-Control: private'); header('Pragma: cache'); header('Content-type: application/download'); header("Content-Length: {$size}"); header("Content-Disposition: attachment; filename={$today}_database_backup.sql"); } echo $dumpstring; return true; } /** * @param string $dumpTempFilePath * @return bool */ function snapshot($dumpTempFilePath) { global $path; rename($dumpTempFilePath, $path); return true; } /** * @return array */ function getSettings() { $modx = evolutionCMS(); $tbl_system_settings = $modx->getFullTableName('system_settings'); $rs = $modx->db->select('setting_name, setting_value', $tbl_system_settings); $settings = array(); while ($row = $modx->db->getRow($rs)) { switch ($row['setting_name']) { case 'rb_base_dir': case 'filemanager_path': case 'site_url': case 'base_url': $settings[$row['setting_name']] = $row['setting_value']; break; } } return $settings; } /** * @param array $settings */ function restoreSettings($settings) { $modx = evolutionCMS(); $tbl_system_settings = $modx->getFullTableName('system_settings'); foreach ($settings as $k => $v) { $modx->db->update(array('setting_value' => $v), $tbl_system_settings, "setting_name='{$k}'"); } } /** * @param string $tpl * @param array $ph * @return string */ function parsePlaceholder($tpl = '', $ph = array()) { if (empty($ph) || empty($tpl)) { return $tpl; } foreach ($ph as $k => $v) { $k = "[+{$k}+]"; $tpl = str_replace($k, $v, $tpl); } return $tpl; }