/modules/sxd/index.php
PHP | 1976 lines | 1882 code | 39 blank | 55 comment | 381 complexity | de56fc1519f9837c0c8b44ee13ec4d75 MD5 | raw file
Large files files are truncated, but you can click here to view the full file
- <?php
- session_start();
- include '../../inc/connect_db.php';
- function getUserType(){
- if (isset($_SESSION['user_id'])){
- global $pref;
- $sql = "select * from {$pref}db_users where id='{$_SESSION['user_id']}' limit 1";
- return mysql_result(mysql_query($sql),0, 'type');
- }
- }
- /***************************************************************************\
- | Sypex Dumper version 2.0.10 |
- | (c) 2003-2011 zapimir zapimir@zapimir.net http://sypex.net/ |
- | (c) 2005-2011 BINOVATOR info@sypex.net |
- |---------------------------------------------------------------------------|
- | created: 2003.09.02 19:07 modified: 2012.11.14 06:27 |
- |---------------------------------------------------------------------------|
- | Sypex Dumper is released under the terms of the BSD license |
- | http://sypex.net/bsd_license.txt |
- \***************************************************************************/
- header("Expires: Wed, 19 Nov 2008 19:19:19 GMT");
- header("Cache-Control: no-store, no-cache, must-revalidate");
- header("Content-Type: text/html; charset=utf-8");
- //error_reporting(E_ALL);
- error_reporting(0);
- if (!ini_get('zlib.output_compression') && function_exists('ob_gzhandler')) ob_start('ob_gzhandler');
- set_error_handler('sxd_error_handler');
- register_shutdown_function('sxd_shutdown');
- $SXD = new Sypex_Dumper();
- chdir(dirname(__FILE__));
- $SXD->init(!empty($argc) && $argc > 1 ? $argv : false);
-
- class Sypex_Dumper {
- function Sypex_Dumper() {
- define('C_DEFAULT', 1);
- define('C_RESULT', 2);
- define('C_ERROR', 3);
- define('C_WARNING', 4);
- define('SXD_DEBUG', false);
- define('TIMER', array_sum(explode(' ', microtime())));
- define('V_SXD', 20010);
- define('V_PHP', sxd_ver2int(phpversion()));
- $this->name = 'Sypex Dumper 2.0.10';
- }
- function loadLang($lng_name = 'auto'){
- if($lng_name == 'auto'){
- include('lang/list.php');
- $this->langs = &$langs;
- $lng = 'en';
- if(preg_match_all('/[a-z]{2}(-[a-z]{2})?/', $_SERVER['HTTP_ACCEPT_LANGUAGE'], $m)) {
- foreach($m[0] AS $l){
- if(isset($langs[$l])){
- $lng_name = $l;
- break;
- }
- }
- }
- }
- if(file_exists("lang/lng_{$lng_name}.php")) include("lang/lng_{$lng_name}.php");
- else include("lang/lng_en.php");
- $this->LNG = &$LNG;
- $this->LNG['name'] = $lng_name;
- return true;
- }
- function init($args = false){
- if (get_magic_quotes_gpc()) {
- $_POST = sxd_antimagic($_POST);
- }
- include('cfg.php');
- $this->loadLang($CFG['lang']);
- if (!ini_get('safe_mode') && function_exists('set_time_limit') && strpos(ini_get('disable_functions'), 'set_time_limit') === false) @set_time_limit($CFG['time_web']);
- elseif (ini_get('max_execution_time') < $CFG['time_web']) $CFG['time_web'] = ini_get('max_execution_time');
- $this->CFG = &$CFG;
- $this->try = false;
- $this->virtualize = false;
- $this->cron_mode = false;
- // Проверяем авторизацию и делаем коннект к базе
- if(empty($this->CFG['my_user'])){
- $this->CFG['my_host'] = 'localhost';
- $this->CFG['my_port'] = 3306;
- $this->CFG['my_user'] = 'root';
- $this->CFG['my_pass'] = '';
- $this->CFG['my_comp'] = 0;
- $this->CFG['my_db'] = '';
- }
- if ($args) { // консольный режим
- foreach($args AS $key => $arg){
- if (preg_match("/^-([hupoj])=(.*?)$/", $arg, $m)){
- switch ($m[1]) {
- case 'h': $this->CFG['my_host'] = $m[2]; break; // хост
- case 'o': $this->CFG['my_port'] = $m[2]; break; // порт
- case 'u': $this->CFG['my_user'] = $m[2]; break; // логин
- case 'p': $this->CFG['my_pass'] = $m[2]; break; // пароль
- case 'j': $this->CFG['sjob'] = $m[2]; break; // job-файл
- }
- }
- }
- $this->cron_mode = true;
- set_time_limit($CFG['time_cron']);
- // Загружаем конфиг файл, если нужно
- $auth = $this->connect();
- if($auth && !empty($this->CFG['sjob'])){
- $this->ajax($this->loadJob($this->CFG['sjob']));
- echo file_get_contents($this->JOB['file_log']);
- if(file_exists($this->JOB['file_log'])) unlink($this->JOB['file_log']);
- if(file_exists($this->JOB['file_rtl'])) unlink($this->JOB['file_rtl']);
- }
- else echo 'Auth error';
- exit;
- }
- elseif(!empty($this->CFG['auth'])){ // Авторизация
- $auth = false;
- $sfile = 'ses.php';
-
- if(!empty($_COOKIE['sxd']) && preg_match('/^[\da-f]{32}$/', $_COOKIE['sxd'])){
- include($sfile);
- if(isset($SES[$_COOKIE['sxd']])) {
- $auth = true;
- $this->CFG = $SES[$_COOKIE['sxd']]['cfg'];
- $this->SES = &$SES;
- $this->loadLang($this->CFG['lang']);
- }
- }
- if(!$auth) {
- if (!empty($_SESSION['user_id']) && getUserType()==2){
- global $db_user,$db_pass,$db_host;
- $user = $db_user;
- $pass = $db_pass;
- $host = $db_host;
- $port = 3306;
- } else{
- $user = !empty($_POST['user']) ? $_POST['user'] : '';
- $pass = !empty($_POST['pass']) ? $_POST['pass'] : '';
- $host = !empty($_POST['host']) ? $_POST['host'] : (!empty($this->CFG['my_host']) ? $this->CFG['my_host'] : 'localhost');
- $port = !empty($_POST['port']) && is_numeric($_POST['port']) ? $_POST['port'] : 3306;
- }
- $temp = preg_split('/\s+/', $this->CFG['auth']);
- if(!empty($_REQUEST['lang']) && preg_match('/^[a-z]{2}(-[a-z]{2})?$/', $_REQUEST['lang'])) {$this->loadLang($_REQUEST['lang']);}
- foreach($temp AS $a){
- switch($a) {
- case 'cfg': if(empty($user)) {continue;}
- $auth = !empty($CFG['user']) && isset($CFG['pass']) && $CFG['user']== $user && $CFG['pass'] == $pass;
- break;
- case 'mysql': if(empty($user)) {continue;}
- if($host != 'localhost' && !empty($this->CFG['my_host']) && $this->CFG['my_host'] != $host) {continue;}
- $auth = $this->connect($host, $port, $user, $pass);
- break;
- default: $file = 'auth_' . $a . '.php';
- if(!file_exists($file)) continue;
- include $file;
- }
- if($auth) break;
- }
- if($auth){
- $key = md5(rand(1,100000) . $user . microtime());
- $CFG['lang'] = $this->LNG['name'];
- $_COOKIE['sxd'] = $key;
- $this->saveCFG();
- if(V_PHP > 50200) setcookie('sxd', $key, !empty($_POST['save']) ? time() + 31536000 : 0, '', '', false, true);
- else setcookie('sxd', $key, !empty($_POST['save']) ? time() + 31536000 : 0, '', '', false);
- header("Location: ./");
- exit;
- }
- foreach(array('user', 'pass', 'host', 'port') AS $key){
- $_POST[$key] = !empty($_POST[$key]) ? htmlspecialchars($_POST[$key], ENT_NOQUOTES) : '';
- }
- $_POST['save'] = !empty($_POST['save']) ? ' CHECKED' : '';
- }
- if (!$auth) {
- if(!empty($_POST['ajax'])){
- echo "sxd.hideLoading();alert('Session not found');";
- exit;
- }
- $this->lng_list = '<option value="auto">- auto -</opinion>';
- if(!isset($this->langs)) {include('lang/list.php');$this->langs = &$langs;}
- foreach($this->langs AS $k => $v){
- $this->lng_list .= "<option value=\"{$k}\"" . ($k == (!empty($_REQUEST['lang']) ? $this->LNG['name'] : $this->CFG['lang']) ? ' SELECTED' : '') . ">{$v}</opinion>";
- }
- echo sxd_tpl_auth();
- exit;
- }
- }
- if(empty($_POST['ajax']['act']) || $_POST['ajax']['act'] != 'save_connect') $this->connect();
- if(isset($_POST['ajax'])) $this->ajax($_POST['ajax']);
- else $this->main();exit;
- }
- function saveToFile($name, $content){
- $fp = fopen($name, "w");
- fwrite($fp, $content);
- fclose($fp);
- }
- function connect($host = null, $port = null, $user = null, $pass = null){
- $this->error = '';
- $this->try = true;
- if(!empty($user) && isset($pass)) {
- $this->CFG['my_host'] = $host;
- $this->CFG['my_port'] = $port;
- $this->CFG['my_user'] = $user;
- $this->CFG['my_pass'] = $pass;
- }
- if(mysql_connect($this->CFG['my_host'] . ($this->CFG['my_host']{0} != ':' ? ":{$this->CFG['my_port']}" : ''), $this->CFG['my_user'], $this->CFG['my_pass'])) {
- if(V_PHP > 50202) mysql_set_charset('utf8') or sxd_my_error();
- else mysql_query('SET NAMES utf8') or sxd_my_error();
- define('V_MYSQL', sxd_ver2int(mysql_get_server_info()));
- }
- else {
- define('V_MYSQL', 0);
- $this->error = "sxd.actions.tab_connects();alert(" . sxd_esc(mysql_error()) . ");";
- }
- $this->try = false;
- return V_MYSQL ? true: false;
- }
- function main(){
- // Тулбар
- $this->VAR['toolbar'] = sxd_php2json(
- array(
- array('backup', $this->LNG['tbar_backup'], 1, 3),
- array('restore', $this->LNG['tbar_restore'], 2, 3),
- array('|'),
- array('files', $this->LNG['tbar_files'], 3, 1),
- array('services', $this->LNG['tbar_services'], 5, 1),
- array('|'),
- array('createdb', $this->LNG['tbar_createdb'], 7, 0),
- array('connects', $this->LNG['tbar_connects'], 6, 0),
- array('|'),
- array('options', $this->LNG['tbar_options'], 4, 1),
- array('|'),
- array('exit', $this->LNG['tbar_exit'], 8, 1),
- )
- );
- $this->db = 'temp';
- $zip = array($this->LNG['zip_none']);
- if (function_exists("gzopen")) {
- for($i = 1; $i <10; $i++){
- $zip[] = "GZip: {$i}";
- }
- $zip[1] .= " ({$this->LNG['zip_min']})";
- $zip[7] .= " ({$this->LNG['default']})";
- }
- if (function_exists("bzopen")) {
- $zip[10] = "BZip";
- }
- end($zip);
- $zip[key($zip)] .= " ({$this->LNG['zip_max']})";
- $this->VAR['combos'] =
- $this->addCombo('backup_db', $this->db, 11, 'db', array()/*$this->getDBList()*/) .
- $this->addCombo('backup_charset', 0, 9, 'charset', $this->getCharsetList()) .
- $this->addCombo('backup_zip', 7, 10, 'zip', $zip) .
- $this->addCombo('restore_db', $this->db, 11, 'db') .
- $this->addCombo('restore_charset', 0, 9, 'charset') .
- $this->addCombo('restore_file', 0, 12, 'files', $this->getFileList()) .
- $this->addCombo('restore_type', 0, 13, 'types', array("CREATE + INSERT ({$this->LNG['default']})", 'TRUNCATE + INSERT', 'REPLACE', 'INSERT IGNORE')) .
- $this->addCombo('services_db', $this->db, 11, 'db') .
- $this->addCombo('services_check', 0, 5, 'check', array("- {$this->LNG['default']} -", 'QUICK', 'FAST', 'CHANGED', 'MEDIUM', 'EXTENDED')) .
- $this->addCombo('services_repair', 0, 5, 'repair', array("- {$this->LNG['default']} -", 'QUICK', 'EXTENDED')) .
- $this->addCombo('db_charset', 0, 9, 'collation', $this->getCollationList()) .
- $this->addCombo('db_charset_col', 0, 15, 'collation:db_charset')
- ;
- if (!V_MYSQL) $this->VAR['combos'] .= $this->error;
- $this->VAR['combos'] .= $this->getSavedJobs() . "sxd.confirms = {$this->CFG['confirm']};sxd.actions.dblist();";
- $this->LNG['del_date'] = sprintf($this->LNG['del_date'], '<input type="text" id="del_time" class=txt style="width:24px;" maxlength="3">');
- $this->LNG['del_count'] = sprintf($this->LNG['del_count'], '<input id="del_count" type="text" class=txt style="width:18px;" maxlength="2">');
-
- echo sxd_tpl_page();
- }
- function addCombo($name, $sel, $ico, $opt_name, $opts = ''){
- $opts = !empty($opts) ? "{{$opt_name}:" . sxd_php2json($opts) . '}' : "'{$opt_name}'";
- return "sxd.addCombo('{$name}', '{$sel}', {$ico}, {$opts});\n";
- }
- function ajax($req){
- $res = '';
- $act = $req['act'];
- if($req['act'] == 'run_savedjob'){
- $req = $this->loadJob($req);
- }
- switch($req['act']){
- case 'load_db':
- $res = $this->getObjects(str_replace('_db', '', $req['name']), $req['value']);
- break;
- case 'load_files':
- $res = $this->getFileObjects('restore', $req['value']);
- break;
- case 'filelist':
- $res = "sxd.clearOpt('files');sxd.addOpt(" . sxd_php2json(array('files' => $this->getFileList())) . ");";
- break;
- case 'dblist':
- $res = "sxd.clearOpt('db');sxd.addOpt(" . sxd_php2json(array('db' => $this->getDBList())) . ");sxd.combos.restore_db.select(0,'-');sxd.combos.services_db.select(0,'-');sxd.combos.backup_db.select(0,'-');";
- break;
- case 'load_connect':
- $CFG = $this->cfg2js($this->CFG);
- $res = "z('con_host').value = '{$CFG['my_host']}', z('con_port').value = '{$CFG['my_port']}', z('con_user').value = '{$CFG['my_user']}',
- z('con_pass').value = '', z('con_comp').checked = {$CFG['my_comp']}, z('con_db').value = '{$CFG['my_db']}', z('con_pass').changed = false;" ;
- break;
- case 'save_connect':
- $res = $this->saveConnect($req);
- break;
- case 'save_job':
- unset($req['act']);
- $this->saveJob('sj_' . $req['job'] , $req);
- $res = $this->getSavedJobs();
- break;
- case 'add_db':
- $res = $this->addDb($req);
- break;
- case 'load_options':
- $CFG = $this->cfg2js($this->CFG);
- $res = "z('time_web').value = '{$CFG['time_web']}', z('time_cron').value = '{$CFG['time_cron']}', z('backup_path').value = '{$CFG['backup_path']}',
- z('backup_url').value = '{$CFG['backup_url']}', z('globstat').checked = {$CFG['globstat']}, z('charsets').value = '{$CFG['charsets']}', z('only_create').value = '{$CFG['only_create']}', z('auth').value = '{$CFG['auth']}', z('conf_import').checked = {$CFG['confirm']} & 1, z('conf_file').checked = {$CFG['confirm']} & 2, z('conf_db').checked = {$CFG['confirm']} & 4;sxd.confirms = {$this->CFG['confirm']};";
- break;
- case 'save_options':
- $res = $this->saveOptions($req);
- break;
- case 'delete_file':
- if(preg_match('/^[^\/]+?\.sql(\.(gz|bz2))?$/', $req['name'])) {
- $file = $this->CFG['backup_path'] . $req['name'];
- if(file_exists($file)) unlink($file);
- }
- $res = $this->getFileListExtended();
- break;
- case 'delete_db':
- $res = $this->deleteDB($req['name']);
- break;
- case 'load_files_ext':
- $res .= $this->getFileListExtended();
- break;
- case 'services':
- $this->runServices($req);
- break;
- case 'backup':
- $this->addBackupJob($req);
- break;
- case 'restore':
- $this->addRestoreJob($req);
- break;
- case 'resume':
- $this->resumeJob($req);
- break;
- case 'exit':
- setcookie('sxd', '', 0);
- $res = "top.location.href = " . sxd_esc($this->CFG['exitURL']) . ";";
- break;
- }
- echo $res;
- }
- function loadJob($job){
- $file = $this->CFG['backup_path'] . 'sj_' . (is_array($job) ? $job['job'] : $job) . '.job.php';
- if(!file_exists($file)) return;
- include($file);
- $JOB['act'] = $JOB['type'];
- $JOB['type'] = 'run';
- return $JOB;
- }
- function deleteDB($name){
- $r = mysql_query('DROP DATABASE `' . sxd_esc($name, false) . '`') or sxd_my_error();
- if($r){
- echo "sxd.clearOpt('db');sxd.addOpt(" . sxd_php2json(array('db' => $this->getDBList())) . ");sxd.combos.services_db.select(0,'-');";
- }
- else
- echo "alert(" . sxd_esc(mysql_error()) . ");";
- }
- function cfg2js($cfg){
- foreach($cfg AS $k => $v){
- $cfg[$k] = sxd_esc($v, false);
- }
- return $cfg;
- }
- function addDb($req){
- $r = mysql_query('CREATE DATABASE `' . sxd_esc($req['name'], false) . '`' . (V_MYSQL > 40100 ? "CHARACTER SET {$req['charset']} COLLATE {$req['collate']}" : ''));
- if($r)
- echo "sxd.addOpt(" . sxd_php2json(array('db' => array($req['name'] => "{$req['name']} (0)"))) . ");";
- else
- sxd_my_error();
- }
- function saveConnect($req){
- $this->CFG['my_host'] = $req['host'];
- $this->CFG['my_port'] = (int)$req['port'];
- $this->CFG['my_user'] = $req['user'];
- if(isset($req['pass'])) $this->CFG['my_pass'] = $req['pass'];
- $this->CFG['my_comp'] = $req['comp'] ? 1 : 0;
- $this->CFG['my_db'] = $req['db'];
- $this->saveCFG();
- $this->connect();
- if (V_MYSQL) {
- $tmp = array(
- 'db' => $this->getDBList(),
- 'charset' => $this->getCharsetList(),
- 'collation' => $this->getCollationList()
- );
- echo "sxd.clearOpt('db');sxd.clearOpt('charset');sxd.clearOpt('collation');sxd.addOpt(" . sxd_php2json($tmp) . ");sxd.combos.backup_db.select(0,'-');sxd.combos.restore_db.select(0,'-');sxd.combos.services_db.select(0,'-');sxd.combos.backup_charset.select(0,'-');sxd.combos.services_db.select(0,'-');sxd.combos.db_charset.select(0,'-');";
- }
- else {
- echo $this->error;
- }
- }
- function saveOptions($req){
- $this->CFG['time_web'] = $req['time_web'];
- $this->CFG['time_cron'] = $req['time_cron'];
- $this->CFG['backup_path'] = $req['backup_path'];
- $this->CFG['backup_url'] = $req['backup_url'];
- $this->CFG['globstat'] = $req['globstat'] ? 1 : 0;
- $this->CFG['charsets'] = $req['charsets'];
- $this->CFG['only_create'] = $req['only_create'];
- $this->CFG['auth'] = $req['auth'];
- $this->CFG['confirm'] = $req['confirm'];
- $this->saveCFG();
- }
- function saveCFG(){
- if (isset($_COOKIE['sxd'])) {
- $this->SES[$_COOKIE['sxd']] = array('cfg' => $this->CFG, 'time' => time(), 'lng' => $this->LNG['name']);
- $this->saveToFile('ses.php', "<?php\n\$SES = " . var_export($this->SES, true) . ";\n" . "?>");
- }
- if (!$this->virtualize){
- $this->saveToFile('cfg.php', "<?php\n\$CFG = " . var_export($this->CFG, true) . ";\n" . "?>");
- }
- }
- function runServices($job) {
- $serv = array('optimize' => 'OPTIMIZE', 'analyze' => 'ANALYZE', 'check' => 'CHECK', 'repair' => 'REPAIR');
- $add = array('check' => array('', 'QUICK', 'FAST', 'CHANGED', 'MEDIUM', 'EXTENDED'), 'repair' => array('', 'QUICK', 'EXTENDED'));
- if(isset($serv[$job['type']])) {
- mysql_select_db($job['db']);
- $filter = $object = array();
- $this->createFilters($job['obj'], $filter, $object);
- $r = mysql_query('SHOW TABLE STATUS') or sxd_my_error();
- if (!$r) return;
- $tables = array();
- while($item = mysql_fetch_assoc($r)){
- if(V_MYSQL > 40101 && is_null($item['Engine']) && preg_match('/^VIEW/i', $item['Comment'])) continue;
- if(sxd_check($item['Name'], $object['TA'], $filter['TA'])) $tables[] = "`{$item['Name']}`";
- }
- $sql = $serv[$job['type']] . ' TABLE ' . implode(',', $tables);
-
- if ($job['type'] == 'check' || $job['type'] == 'repair') {
- $sql .= isset($add[$job['type']][$job[$job['type']]]) ? ' ' . $add[$job['type']][$job[$job['type']]] : '';
- }
-
- $r = mysql_query($sql) or sxd_my_error();
- if (!$r) return;
- $res = array();
- while($item = mysql_fetch_row($r)){
- $res[] = $item;
- }
- echo 'sxd.result.add(' . sxd_php2json($res). ');';
- }
- }
- function createFilters(&$obj, &$filter, &$object){
- $types = array('TA', 'TC', 'VI', 'PR', 'FU', 'TR', 'EV');
- foreach($types AS $type){
- $filter[$type] = array();
- $object[$type] = array();
- if(!empty($obj[$type])){
- foreach($obj[$type] AS $v){
- if(strpos($v, '*') !== false) {
- $filter[$type][] = str_replace('*', '.*?', $v);
- }
- else {
- $object[$type][$v] = true;
- }
- }
- $filter[$type] = count($filter[$type]) > 0 ? '/^(' . implode('|', $filter[$type]) . ')$/i' : '';
- }
- }
- }
- function closeConnect(){
- //return;
- @ignore_user_abort(1);
- header("SXD: {$this->name}");
- header("Connection: close");
- header("Content-Length: 0");
- @ob_end_flush();
- @flush();
- }
- function resumeJob($job){
- $this->closeConnect();
- include($this->CFG['backup_path'] . $job['job'] . '.job.php');
- $this->JOB = &$JOB;
- if(file_exists($this->JOB['file_stp'])) unlink($this->JOB['file_stp']);
- $this->fh_rtl = fopen($this->JOB['file_rtl'], 'r+b');
- $this->fh_log = fopen($this->JOB['file_log'], 'ab');
- $t = fgets($this->fh_rtl);
- if(!empty($t)){
- $this->rtl = explode("\t", $t);
- }
- else {
- $this->addLog($this->LNG['not_found_rtl']);
- exit;
- }
- // TODO: проверить удаление кодировки
- //$this->rtl[6] = '';
- fseek($this->fh_rtl, 0);
- $this->rtl[1] = time();
- $this->rtl[9] = 0;
- fwrite($this->fh_rtl, implode("\t", $this->rtl));
- if ($this->JOB['act'] == 'backup') $this->runBackupJob(true);
- elseif ($this->JOB['act'] == 'restore') $this->runRestoreJob(true);
- }
- function addRestoreJob($job) {
- $this->closeConnect();
- $this->JOB = $job;
- // Создаем список объектов и фильтр
- $filter = $object = array();
- $this->createFilters($this->JOB['obj'], $filter, $object);
-
- $objects = $this->getFileObjects('restore', $this->JOB['file'], false);
- $todo = array();
- $rows = 0;
- $this->tab_rows = array();
- $todo = array();
- foreach($objects AS $t => $list){
- if($t == 'TA' && (!empty($object['TC']) || !empty($filter['TC']))) {}
- elseif(empty($object[$t]) && empty($filter[$t])) {continue;}
- if (empty($list)) continue;
-
- foreach($list AS $item){
- switch($t){
- case 'TA':
- $type = '';
- if(sxd_check($item[0], $object['TA'], $filter['TA'])){
- $type = empty($item[1]) ? 'TC' : 'TA';
- }
- elseif(sxd_check($item[0], $object['TC'], $filter['TC'])) {
- $type = 'TC';
- }
- else continue;
- $todo['TA'][] = array($type, $item[0], $item[1], $item[2]);
- $rows += $type == 'TA' ? $item[1] : 0;
- break;
- default:
- if(sxd_check($item, $object[$t], $filter[$t])) {
- $todo[$t][] = array($t, $item);
- }
- }
- }
- }
- $this->JOB['file_tmp'] = $this->JOB['file_name'] = $this->CFG['backup_path'] . $this->JOB['file'];
- $this->JOB['file_rtl'] = $this->CFG['backup_path'] . $this->JOB['job'] . '.rtl';
- $this->JOB['file_log'] = $this->CFG['backup_path'] . $this->JOB['job'] . '.log';
- $this->JOB['file_stp'] = $this->CFG['backup_path'] . $this->JOB['job'] . '.stp';
- if(file_exists($this->JOB['file_stp'])) unlink($this->JOB['file_stp']);
-
- $this->fh_tmp = $this->openFile($this->JOB['file_tmp'], 'r');
- // Для чужих дампов определяем разделители строк
- if(is_null($this->JOB['obj'])) {
- $s = fread($this->fh_tmp, 2048);
- if(strpos($s, "\r\n")) $this->JOB['eol'] = "\r\n";
- elseif(strpos($s, "\n")) $this->JOB['eol'] = "\n";
- else $this->JOB['eol'] = "\r";
- $bom = strncmp($s, "\xEF\xBB\xBF", 3) == 0 ? 3 : ((strncmp($s, "\xFE\xFF", 2) == 0 || strncmp($s, "\xFF\xFE", 2) == 0) ? 2 : 0);
- fseek($this->fh_tmp, $bom);
- }
- $this->JOB['todo'] = $todo;
- $this->saveJob($this->JOB['job'], $this->JOB);
- $this->fh_rtl = fopen($this->JOB['file_rtl'], 'wb');
- $this->fh_log = fopen($this->JOB['file_log'], 'wb');
- $this->rtl = array(time(), time(), $rows, 0, '', '', '', 0, 0, 0, 0, TIMER, "\n");
- $this->addLog(sprintf($this->LNG['restore_begin'], $this->JOB['db']));
- $this->addLog("{$this->LNG['combo_file']} {$this->JOB['file']}");
- $this->runRestoreJob();
- }
- function runRestoreJob($continue = false){
- $ei = false;
- if($continue){
- $this->fh_tmp = $this->openFile($this->JOB['file_tmp'], 'r');
- fseek($this->fh_tmp, $this->rtl[3]);
- if(!empty($this->rtl[6])) $this->setNames($this->JOB['correct'] == 1 && !empty($this->JOB['charset']) ? $this->JOB['charset'] : $this->rtl[6]);
- if($this->rtl[7] < $this->rtl[10]) $ei = true;
- }
- mysql_select_db($this->JOB['db']);
- if(is_null($this->JOB['obj'])) $this->runRestoreJobForeign($continue);
- //mysql_query("SET NAMES 'UTF8'");
- $types = array('VI' => 'View', 'PR' => 'Procedure', 'FU' => 'Function', 'TR' => 'Trigger', 'EV' => 'Event');
- $fcache = '';
- $writes = 0;
- $old_charset = '';
- $tab = '';
- $seek = 0;
- $this->rtl[3] = ftell($this->fh_tmp);
- fseek($this->fh_rtl, 0);
- $this->rtl[1] = time();
- fwrite($this->fh_rtl, implode("\t", $this->rtl));
- $c = 0;
- switch($this->JOB['strategy']){
- case 1: $tc = 'TRUNCATE'; $td = 'INSERT'; break;
- case 2: $tc = ''; $td = 'REPLACE'; break;
- case 3: $tc = ''; $td = 'INSERT IGNORE'; break;
- default: $tc = 'DROP TABLE IF EXISTS'; $td = 'INSERT';
- }
- $tab_exists = array();
- if($this->JOB['strategy'] > 0){
- $r = mysql_query("SHOW TABLES") or sxd_my_error();
- while($item = mysql_fetch_row($r)){
- $tab_exists[$item[0]] = true;
- }
- }
- $insert = $continue && $this->rtl[7] < $this->rtl[10] ? "{$td} INTO `{$this->rtl[5]}` VALUES " : '';
- //$enable_index = array();
- if(V_MYSQL > 40014) {
- mysql_query("SET UNIQUE_CHECKS=0");
- mysql_query("SET FOREIGN_KEY_CHECKS=0");
- if(V_MYSQL > 40101) mysql_query("SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO'");
- if(V_MYSQL > 40111) mysql_query("SET SQL_NOTES=0");
- }
- $log_sql = false;
- $fields = '';
- $time_old = time();
- $exit_time = $time_old + $this->CFG['time_web'] - 1;
- while($q = sxd_read_sql($this->fh_tmp, $seek, $ei)){
- if($time_old < time()) {
- if(file_exists($this->JOB['file_stp'])){
- $type = file_get_contents($this->JOB['file_stp']);
- $this->rtl[9] = !empty($type) ? $type : 2;
- fseek($this->fh_rtl, 0);
- $this->rtl[1] = time();
- fwrite($this->fh_rtl, implode("\t", $this->rtl));
- /*if($type == 1) {
-
- }*/
- unset($this->rtl);
- exit;
- }
- $time_old = time();
- if($time_old >= $exit_time){
- $this->rtl[9] = 3;
- fseek($this->fh_rtl, 0);
- $this->rtl[1] = time();
- fwrite($this->fh_rtl, implode("\t", $this->rtl));
- unset($this->rtl);
- exit;
- }
- clearstatcache();
- }
- switch($q{0}){
- case '(':
- if($continue) {
- $this->addLog(sprintf("{$this->LNG['restore_TC']} {$this->LNG['continue_from']}", $this->rtl[5], $this->rtl[3]));
- $continue = false;
- }
- $q = $insert . $q;
- $ex = 1;
- $c = 1;
- break;
- case 'I':
- if (preg_match('/^INSERT( INTO `(.+?)`) VALUES/', $q, $m)) {
- $insert = $td . $m[1] . $fields . " VALUES \n";
- $tab = $m[2];
- $this->rtl[7] = 0;
- $this->rtl[8] = 0;
- foreach($this->JOB['todo']['TA'] AS $t){
- if($t[1] == $tab) {
- $this->rtl[8] = $t[2];
- }
- }
- if($this->JOB['strategy']) {
- $q = substr_replace($q, $insert, 0, strlen($m[0]));
- }
- //mysql_query("LOCK TABLES `{$tab}` WRITE") or die (mysql_error());
- mysql_query("ALTER TABLE `{$tab}` DISABLE KEYS") or sxd_my_error();
- //if(!empty($this->JOB['autoinc'])) mysql_query("ALTER TABLE `{$tab}` AUTO_INCREMENT = 1") or sxd_my_error();
- $ex = 1;
- }
- break;
- case 'C':
- $ex = 1;
- if (preg_match('/^CREATE TABLE `/', $q)) {
- if($this->JOB['strategy'] != 0 && isset($tab_exists[$this->rtl[5]])) $ex = 0;
- else {
- $ex = 1;
- if((!empty($this->JOB['correct']) && !empty($this->JOB['charset']))){
- $q = preg_replace('/(DEFAULT)?\s*(CHARSET|CHARACTER SET|COLLATE)[=\s]+\w+/i', '', $q) . (V_MYSQL < 40100 ? '' : ' DEFAULT CHARSET=' . $this->JOB['charset']);
- }
- if(!empty($this->JOB['autoinc'])) $q = preg_replace("/AUTO_INCREMENT=\d+/", "AUTO_INCREMENT=1", $q);
- }
- // Достаем имена полей таблицы
- $fields = $this->JOB['strategy'] > 0 && preg_match_all('/^\s+(`.+?`) /m', $q, $f, PREG_PATTERN_ORDER) ? '(' . implode(',', $f[1]) . ')' : '';
- }
- break;
- case '#': // Команды для дампера
- if (preg_match("/\#\t(TC|TD|VI|PR|FU|TR|EV)`(.+?)`(([^_]+?)_.+?)?$/", $q, $m)) {
- //if(!empty($tab)) $enable_index[] = $tab;
- // $this->setNames($this->JOB['correct'] == 1 && !empty($this->JOB['charset']) ? $this->JOB['charset'] : empty($m[3]) ? '' : $m[3]);
- $this->setNames('binary');
- if($m[1] == 'TC') {
- $this->addLog(sprintf($this->LNG['restore_TC'], $m[2]));
- $insert = '';
- $tab = '';
- $this->rtl[4] = 'TD';
- $this->rtl[5] = $m[2];
- $ei = 0;
- if($tc && ($this->JOB['strategy'] == 0 || isset($tab_exists[$m[2]]))) {
- mysql_query("{$tc} `{$m[2]}`") or sxd_my_error();
- }
- }
- elseif($m[1] == 'TD'){
- $ei = 1;
- }
- else {
- $this->rtl[4] = $m[1];
- $this->rtl[5] = $m[2];
- $this->rtl[7] = 0;
- $this->rtl[8] = 0;
- mysql_query("DROP {$types[$m[1]]} IF EXISTS `{$m[2]}`") or sxd_my_error();
- $this->addLog(sprintf($this->LNG["restore_{$m[1]}"], $m[2]));
- $ei = 0;
- }
- }
- $ex = 0;
- break;
- default:
- $insert = '';
- $ex = 1;
- }
- if($ex) {
- $this->rtl[3] = ftell($this->fh_tmp) - $seek;
- fseek($this->fh_rtl, 0);
- $this->rtl[1] = time();
- fwrite($this->fh_rtl, implode("\t", $this->rtl));
- if(mysql_query($q)) {
- if($insert) {
- $c = 1;
- }
- }
- else {
- error_log(date('r') . "\n----------\n{$q}\n", 3, "backup/sql_error.log");
- sxd_my_error();
- }
-
- if($c){
- $i = mysql_affected_rows();
- $this->rtl[3] = ftell($this->fh_tmp) - $seek;
- $this->rtl[7] += $i;
- $this->rtl[10] += $i;
- fseek($this->fh_rtl, 0);
- $this->rtl[1] = time();
- fwrite($this->fh_rtl, implode("\t", $this->rtl));
- $c = 1;
- }
- }
-
- }
- // Включаем ключи
- $this->addLog($this->LNG['restore_keys']);
- $this->rtl[4] = 'EK';
- $this->rtl[5] = '';
- $this->rtl[6] = '';
- $this->rtl[7] = 0;
- $this->rtl[8] = 0;
- foreach($this->JOB['todo']['TA'] AS $tab){
- if ($tab[0] == 'TC') continue;
- mysql_query("ALTER TABLE `{$tab[1]}` ENABLE KEYS") or sxd_my_error();
- $this->rtl[1] = time();
- $this->rtl[5] = $tab[1];
- fseek($this->fh_rtl, 0);
- fwrite($this->fh_rtl, implode("\t", $this->rtl));
- }
- $this->rtl[4] = 'EOJ';
- $this->rtl[5] = round(array_sum(explode(' ', microtime())) - $this->rtl[11], 4);
-
- fseek($this->fh_rtl, 0);
- fwrite($this->fh_rtl, implode("\t", $this->rtl));
- $this->addLog(sprintf($this->LNG['restore_end'], $this->JOB['db']));
- fclose($this->fh_log);
- fclose($this->fh_rtl);
- }
- function runRestoreJobForeign($continue = false){
- $ei = false;
-
- $fcache = '';
- $writes = 0;
- $old_charset = '';
- $tab = '';
- $seek = 0;
- $this->rtl[3] = ftell($this->fh_tmp);
- fseek($this->fh_rtl, 0);
- $this->rtl[1] = time();
- fwrite($this->fh_rtl, implode("\t", $this->rtl));
- $c = 0;
-
- $log_sql = false;
- $fields = '';
- $insert = '';
- $last_tab = '';
- $time_old = time();
- $exit_time = $time_old + $this->CFG['time_web'] - 1;
- $delimiter = ";";
- while($q = sxd_read_sql($this->fh_tmp, $seek, $ei, $delimiter, $this->JOB['eol'])){
- $q = ltrim($q);
- if(empty($q)) break;
- if($time_old < time()) {
- if(file_exists($this->JOB['file_stp'])){
- $type = file_get_contents($this->JOB['file_stp']);
- $this->rtl[9] = !empty($type) ? $type : 2;
- fseek($this->fh_rtl, 0);
- $this->rtl[1] = time();
- fwrite($this->fh_rtl, implode("\t", $this->rtl));
- /*if($type == 1) {
-
- }*/
- unset($this->rtl);
- exit;
- }
- $time_old = time();
- if($time_old >= $exit_time){
- $this->rtl[9] = 3;
- fseek($this->fh_rtl, 0);
- $this->rtl[1] = time();
- fwrite($this->fh_rtl, implode("\t", $this->rtl));
- unset($this->rtl);
- exit;
- }
- clearstatcache();
- }
- do {
- $repeat = false;
- switch($q{0}){
- case '(':
- if($continue) {
- $this->addLog(sprintf("{$this->LNG['restore_TC']} {$this->LNG['continue_from']}", $this->rtl[5], $this->rtl[3]));
- $continue = false;
- }
- $q = $insert . $q;
- $ex = 1;
- $c = 1;
- break;
- case 'I':
-
- if (preg_match('/^(INSERT( INTO `?(.+?)`?).+?\sVALUES)/s', $q, $m)) {
- $insert = trim($m[1]) . ' ';
- $tab = $m[3];
- $this->rtl[7] = 0;
- $this->rtl[8] = 0;
- $ex = 1;
- }
- break;
- case 'C':
- $ex = 1;
- $ei = 1;
- if (preg_match('/^CREATE TABLE.+?`(.+?)`/', $q, $m)) {
- $ex = 1;
- $tab = $m[1];
- $this->addLog(sprintf($this->LNG['restore_TC'], $tab));
- //mysql_query("DROP TABLE IF EXISTS `{$tab}`");
- if((!empty($this->JOB['correct']) && !empty($this->JOB['charset']))){
- $q = preg_replace('/(DEFAULT)?\s*(CHARSET|CHARACTER SET|COLLATE)[=\s]+\w+/i', '', $q) . (V_MYSQL < 40100 ? '' : ' DEFAULT CHARSET=' . $this->JOB['charset']);
- }
- elseif(empty($this->JOB['charset'])){
- if(preg_match("/(CHARACTER SET|CHARSET)[=\s]+(\w+)/i", $q, $charset)){
- $this->setNames($charset[2]);
- }
- }
- }
- break;
- case '-' && $q{1} == '-':
- case '#':
- $repeat = true;
- $q = ltrim(substr($q, strpos($q, $this->JOB['eol'])));
- $ex = 0;
- break;
- case '/':
- case 'S':
- if (preg_match('/SET NAMES (\w+)/', $q, $m)) {
- $this->JOB['charset'] = $m[1];
- $this->setNames($this->JOB['charset']);
- $ex = 0;
- }
- else $ex = 1;
- break;
- default:
- $insert = '';
- $ex = 1;
- $ei = 0;
- }
- } while ($repeat);
- if($ex) {
- $this->rtl[3] = ftell($this->fh_tmp) - $seek;
- fseek($this->fh_rtl, 0);
- $this->rtl[1] = time();
- fwrite($this->fh_rtl, implode("\t", $this->rtl));
- if(mysql_query($q)) {
- if($insert) {
- $c = 1;
- }
- }
- else {
- error_log("-----------------\n{$q}\n", 3, "error.log");
- sxd_my_error();
- }
-
- if($c){
- $i = mysql_affected_rows();
- $this->rtl[3] = ftell($this->fh_tmp) - $seek;
- $this->rtl[7] += $i;
- $this->rtl[10] += $i;
- fseek($this->fh_rtl, 0);
- $this->rtl[1] = time();
- fwrite($this->fh_rtl, implode("\t", $this->rtl));
- $c = 1;
- }
- }
-
- }
-
- $this->rtl[4] = 'EOJ';
- $this->rtl[5] = round(array_sum(explode(' ', microtime())) - $this->rtl[11], 4);
- $this->rtl[7] = 0;
- $this->rtl[8] = 0;
-
- fseek($this->fh_rtl, 0);
- fwrite($this->fh_rtl, implode("\t", $this->rtl));
- $this->addLog(sprintf($this->LNG['restore_end'], $this->JOB['db']));
- fclose($this->fh_log);
- fclose($this->fh_rtl);
- }
- function addBackupJob($job) {
- $this->closeConnect();
- // Создаем новое задание
- $this->JOB = $job;
- mysql_select_db($this->JOB['db']);
- // Создаем список объектов и фильтр
- $filter = $object = array();
- $this->createFilters($this->JOB['obj'], $filter, $object);
- $queries = array(
- array('TABLE STATUS', 'Name', 'TA')
- );
- if (V_MYSQL > 50014) {
- $queries[] = array("PROCEDURE STATUS WHERE db='{$this->JOB['db']}'", 'Name', 'PR');
- $queries[] = array("FUNCTION STATUS WHERE db='{$this->JOB['db']}'", 'Name', 'FU');
- $queries[] = array('TRIGGERS', 'Trigger', 'TR');
- if(V_MYSQL > 50100) $queries[] = array('EVENTS', 'Name', 'EV');
- }
- $todo = $header = array();
- $tabs = $rows = 0;
- $only_create = explode(' ', $this->CFG['only_create']);
- foreach($queries AS $query){
- $t = $query[2];
- if($t == 'TA' && (!empty($object['TC']) || !empty($filter['TC']))) {}
- elseif(empty($object[$t]) && empty($filter[$t])) continue;
- $r = mysql_query('SHOW ' . $query[0]) or sxd_my_error();
- if (!$r) continue;
- $todo[$t] = array();
- $header[$t] = array();
-
- while($item = mysql_fetch_assoc($r)){
- $n = $item[$query[1]];
- switch($t){
- case 'TA':
- case 'TC':
- if(V_MYSQL > 40101 && is_null($item['Engine']) && preg_match('/^VIEW/i', $item['Comment'])) {
- if(sxd_check($n, $object['VI'], $filter['VI'])){
- $todo['VI'] = array();
- $header['VI']= array();
- }
- continue;
- }
- elseif(sxd_check($n, $object['TA'], $filter['TA'])){
- $engine = V_MYSQL > 40101 ? $item['Engine'] : $item['Type'];
- $t = in_array($engine, $only_create) ? 'TC' : 'TA';
- }
- elseif(sxd_check($n, $object['TC'], $filter['TC'])) {
- $t = 'TC';
- $item['Rows'] = $item['Data_length'] = '';
- }
- else continue;
- $todo['TA'][] = array($t, $n, !empty($item['Collation']) ? $item['Collation'] : '', $item['Auto_increment'], $item['Rows'], $item['Data_length']);
- $header['TA'][] = "{$n}`{$item['Rows']}`{$item['Data_length']}";
- $tabs++;
- $rows += $item['Rows'];
- break;
- default:
- if(sxd_check($n, $object[$t], $filter[$t])) {
- $todo[$t][] = array($t, $n, !empty($item['collation_connection']) ? $item['collation_connection'] : '');
- $header[$t][] = $n;
- }
- }
- }
-
- }
- if (V_MYSQL > 50014 && (!empty($object['VI']) || !empty($filter['VI']))) {
- // Бэкап обзоров, нужно отсортировать зависимые
- $r = mysql_query("SELECT table_name, view_definition /*!50121 , collation_connection */ FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = '{$this->JOB['db']}'") or sxd_my_error();
- $views = $dumped = $views_collation = array();
- $re = "/`{$this->JOB['db']}`.`(.+?)`/";
- while($item = mysql_fetch_assoc($r)){
- preg_match_all($re, preg_replace("/^select.+? from/i", '', $item['view_definition']), $m);
- $used = $m[1];
- $views_collation[$item['table_name']] = !empty($item['collation_connection']) ? $item['collation_connection'] : '';
- $views[$item['table_name']] = $used;
- }
-
- while (count($views) > 0) {
- foreach($views AS $n => $view) {
- $can_dumped = true;
- foreach($view AS $k) {
- if (isset($views[$k]) && !isset($dumped[$k])) $can_dumped = false;
- }
- if ($can_dumped) {
- if(sxd_check($n, $object['VI'], $filter['VI'])){
- $todo['VI'][] = array('VI', $n, $views_collation[$n]);
- $header['VI'][] = $n;
- }
- $dumped[$n] = 1;
- unset($views[$n]);
- }
- }
- }
- unset($dumped);
- unset($views);
- unset($views_collation);
- }
- $this->JOB['file_tmp'] = $this->CFG['backup_path'] . $this->JOB['job'] . '.tmp';
- $this->JOB['file_rtl'] = $this->CFG['backup_path'] . $this->JOB['job'] . '.rtl';
- $this->JOB['file_log'] = $this->CFG['backup_path'] . $this->JOB['job'] . '.log';
- $this->JOB['file_stp'] = $this->CFG['backup_path'] . $this->JOB['job'] . '.stp';
- if(file_exists($this->JOB['file_stp'])) unlink($this->JOB['file_stp']);
- $this->fh_tmp = $this->openFile($this->JOB['file_tmp'], 'w');
- $this->JOB['file'] = sprintf('%s_%s.%s', (isset($this->JOB['title']) ? $this->JOB['job'] : $this->JOB['db']), date('Y-m-d_H-i-s'), $this->JOB['file_ext']);
- $this->JOB['file_name'] = $this->CFG['backup_path'] . $this->JOB['file'];
- $this->JOB['todo'] = $todo;
- $this->saveJob($this->JOB['job'], $this->JOB);
- $fcache = implode('|', array('#SXD20', V_SXD, V_MYSQL, V_PHP, date('Y.m.d H:i:s'), $this->JOB['db'], $this->JOB['charset'], $tabs, $rows, sxd_esc($this->JOB['comment'], false))) . "\n";
- foreach($header AS $t => $o){
- if (!empty($o)) $fcache .= "#{$t} " . implode('|', $o) . "\n";
- }
- $this->fh_rtl = fopen($this->JOB['file_rtl'], 'wb');
- $this->fh_log = fopen($this->JOB['file_log'], 'wb');
- $this->rtl = array(time(), time(), $rows, 0, '', '', '', 0, 0, 0, 0, TIMER, "\n");
- $fcache .= "#EOH\n\n";
- $this->write($fcache);
- $this->addLog(sprintf($this->LNG['backup_begin'], $this->JOB['db']));
- $this->runBackupJob();
- }
- function runBackupJob($continue = false){
- if($continue){
- $this->fh_tmp = $this->openFile($this->JOB['file_tmp'], 'a');
- mysql_select_db($this->JOB['db']);
- }
- mysql_query("SET SQL_QUOTE_SHOW_CREATE = 1");
- $types = array('VI' => 'View', 'PR' => 'Procedure', 'FU' => 'Function', 'TR' => 'Trigger', 'EV' => 'Event');
- $fcache = '';
- $writes = 0;
-
- if(V_MYSQL > 40101) mysql_query("SET SESSION character_set_results = '" . ($this->JOB['charset'] ? $this->JOB['charset'] : 'binary') ."'") or sxd_my_error();
- $time_old = time();
- $exit_time = $time_old + $this->CFG['time_web'] - 1;
- $no_cache = V_MYSQL < 40101 ? 'SQL_NO_CACHE ' : '';
- foreach($this->JOB['todo'] AS $t => $o){
- if (empty($this->rtl[4])) $this->rtl[4] = $t;
- elseif ($this->rtl[4] != $t) continue;
- foreach($o AS $n){
- if (empty($this->rtl[5])) {
- $this->rtl[5] = $n[1];
- $this->rtl[7] = 0;
- $this->rtl[8] = !empty($n[4]) ? $n[4] : 0;
- }
- elseif ($this->rtl[5] != $n[1]) continue;
- // Делаем бэкап
- switch($n[0]){
- case 'TC':
- case 'TD':
- case 'TA':
- $from = '';
- if ($n[0] == 'TC' || $this->rtl[7] == 0){
- // Бэкап структуры таблицы
- $r = mysql_query("SHOW CREATE TABLE `{$n[1]}`") or sxd_my_error();
- $item = mysql_fetch_assoc($r);
- $fcache .= "#\tTC`{$n[1]}`{$n[2]}\t;\n{$item['Create Table']}\t;\n";
- $this->addLog(sprintf($this->LNG['backup_TC'], $n[1]));
- $this->rtl[7] = 0;
- if($n[0] == 'TC' || !$n[4]) break;
- // Бэкапим данные таблицы
- $fcache .= "#\tTD`{$n[1]}`{$n[2]}\t;\nINSERT INTO `{$n[1]}` VALUES \n";
- }
- else {
- $from = " LIMIT {$this->rtl[7]}, {$this->rtl[8]}";
- $this->addLog(sprintf("{$this->LNG['backup_TC']} {$this->LNG['continue_from']}", $n[1], $this->rtl[7]));
- }
- // Определяем типы полей
- $notNum = array();
- $r = mysql_query("SHOW COLUMNS FROM `{$n[1]}`") or sxd_my_error();
- $fields = 0;
- while($col = mysql_fetch_array($r)) {
- // TODO: проверить типы SET, ENUM и BIT
- $notNum[$fields] = preg_match("/^(tinyint|smallint|mediumint|bigint|int|float|double|real|decimal|numeric|year)/", $col['Type']) ? 0 : 1;
- $fields++;
- }
- $time_old = time();
- $z = 0;
- // Достаем данные
- $r = mysql_unbuffered_query("SELECT {$no_cache}* FROM `{$n[1]}`{$from}");
- while($row = mysql_fetch_row($r)) {
- if (strlen($fcache) >= 61440) {
- $z = 0;
- if($time_old < time()) {
- if(file_exists($this->JOB['file_stp'])){
- $type = file_get_contents($this->JOB['file_stp']);
- $this->rtl[9] = !empty($type) ? $type : 2;
- $this->write($fcache);
- if($type == 1) {
-
- }
- unset($this->rtl);
- exit;
- }
- $time_old = time();
- if($time_old >= $exit_time){
- $this->rtl[9] = 3;
- $this->write($fcache);
- unset($this->rtl);
- exit;
- }
- clearstatcache();
- }
- $this->write($fcache);
- }
- for($k = 0; $k < $fields; $k++){
- if(!isset($row[$k])) {$row[$k] = '\N';}
- elseif($notNum[$k]) {$row[$k] = '\'' . mysql_real_escape_string($row[$k]) . '\'';} // TODO: Потестить скорость эскэйпинга строк
- }
- $fcache .= '(' . implode(',', $row) . "),\n";
- $this->rtl[7]++;
- $this->rtl[10]++;
- }
- unset($row);
- mysql_free_result($r);
- $fcache = substr_replace($fcache, "\t;\n", -2, 2);
- break;
- default:
- if(V_MYSQL < 50121 && $n[0] == 'TR'){
- // SHOW CREATE TRIGGER отсутствует до MySQL 5.1.21
- $r = mysql_query("SELECT * FROM `INFORMATION_SCHEMA`.`TRIGGERS` WHERE `TRIGGER_SCHEMA` = '{$this->JOB['db']}' AND `TRIGGER_NAME` = '{$n[1]}'") or sxd_my_error();
- $item = mysql_fetch_assoc($r);
- $fcache .= "#\tTR`{$n[1]}`{$n[2]}\t;\nCREATE TRIGGER `{$item['TRIGGER_NAME']}` {$item['ACTION_TIMING']} {$item['EVENT_MANIPULATION']} ON `{$item['EVENT_OBJECT_TABLE']}` FOR EACH ROW {$item['ACTION_STATEMENT']}\t;\n";
- }
- else {
- $this->addLog(sprintf($this->LNG['backup_' . $n[0]], $n[1]));
- $r = mysql_query("SHOW CREATE {$types[$n[0]]} `{$n[1]}`") or sxd_my_error();
- $item = mysql_fetch_assoc($r);
- $fcache .= "#\t{$n[0]}`{$n[1]}`{$n[2]}\t;\n" . preg_replace("/DEFINER=`.+?`@`.+?` /", '', ($n[0] == 'TR' ? $item['SQL Original Statement'] : $item['Create ' . $types[$n[0]]])) . "\t;\n";
- }
- }
-
- $this->rtl[5] = '';
- }
- $this->rtl[4] = '';
- }
- $this->rtl[4] = 'EOJ';
- $this->rtl[5] = round(array_sum(explode(' ', microtime())) - $this->rtl[11], 4);
- $this->rtl[6] = '';
- $this->rtl[7] = 0;
- $this->rtl[8] = 0;
- $this->write($fcache);
- fclose($this->fh_tmp);
- rename($this->JOB['file_tmp'], $this->JOB['file_name']);
- $this->addLog(sprintf($this->LNG['backup_end'], $this->JOB['db']));
-
- if ($this->JOB['del_time'] || $this->JOB['del_count']) {
- $this->addLog($this->LNG['autodelete']);
- $deldate = '';
- if (!empty($this->JOB['del_time'])){ // Удаление по дням
- $deldate = date("Y-m-d_H-i-s", time() - intval($this->JOB['del_time']) * 86400);
- }
- $deleted = false;
- if ($dh = opendir($this->CFG['backup_path'])) {
- $files = array();
- $name = isset($this->JOB['title']) ? $this->JOB['job'] : $this->JOB['db'];
- while (false !== ($file = readdir($dh))) {
- if (preg_match("/^{$name}_(\d{4}-\d{2}-\d{2}_\d{2}-\d{2}-\d{2})\.sql/", $file, $m)) {
- if ($deldate && $m[1] < $deldate) {
- if(unlink($this->CFG['backup_path'] . $file)) $this->addLog(sprintf($this->LNG['del_by_date'], $file));
- else $this->addLog(sprintf($this->LNG['del_fail'], $file));
- $deleted = true;
- }
- else {$files[$m[1]] = $file;}
- }
- }
- closedir($dh);
- // Сортируем файлы по дате и удаляем самые старые
- if (!empty($this->JOB['del_count'])){
- ksort($files);
- $file_to_delete = count($files) - $this->JOB['del_count'];
- foreach ($files AS $file){
- if ($file_to_delete-- > 0){
- if(unlink($this->CFG['backup_path'] . $file)) $this->addLog(sprintf($this->LNG['del_by_count'], $file));
- else $this->addLog(sprintf($this->LNG['del_fail'], $file));
- $deleted = true;
- }
- }
- }
- }
- if(!$deleted) $this->addLog($this->LNG['del_nothing']);
- }
- fclose($this->fh_log);
- fclose($this->fh_rtl);
- }
- function setNames($collation){
- if(empty($collation)) return;
- if($this->rtl[6] != $collation) {
- mysql_query('SET NAMES \'' . preg_replace('/^(\w+?)_/', '\\1\' COLLATE \'\\1_', $collation) . '\'') or sxd_my_error();
- /*if(!$this->rtl[7])*/ $this->addLog(sprintf($this->LNG['set_names'], $collation));
- $this->rtl[6] = $collation;
- }
- }
- function write(&$str){
- fseek($this->fh_rtl, 0);
- $this->rtl[1] = time();
- $this->rtl[3] += fwrite($this->fh_tmp, $str);
- fwrite($this->fh_rtl, implode("\t", $this->rtl));
- $str = '';
- }
- function addLog($str, $type = 1){
- fwrite($this->fh_log, date('Y.m.d H:i:s') . "\t{$type}\t{$str}\n");
- }
- function getDBList(){
- $dbs = $items = array();
- if (!V_MYSQL) return $dbs;
- $qq = (V_MYSQL < 50000) ? '' : '\'';
- if ($this->CFG['my_db']) {
- $tmp = explode(',', $this->CFG['my_db']);
- foreach($tmp AS $d){
- $d = trim($d);
- $items[] = $qq . sxd_esc($d, false) . $qq;
- $dbs[$d] = "{$d} (0)";
- }
- }
- else{
- $result = mysql_query("SHOW DATABASES") or sxd_my_error();
- while($item = mysql_fetch_row($result)){
- if($item[0] == 'information_schema' || $item[0] == 'mysql' || $item[0] == 'performance_schema') continue;
- $items[] = $qq . sxd_esc($item[0], false) . $qq;
- $dbs[$item[0]] = "{$item[0]} (0)";
- }
- }
- if(V_MYSQL < 50000){
- foreach($items AS $item){
- $tables = mysql_query("SHOW TABLES FROM `{$item}`") or sxd_my_error();
- if ($tables) {
- $tabs = mysql_num_rows($tables);
- $dbs[$item] = "{$item} ({$tabs})";
- }
- }
- }
- else {
- $where = (count($items) > 0) ? 'WHERE `table_schema` IN (' . implode(',', $items) . ')' : '';
- $result = mysql_query("SELECT `table_schema`, COUNT(*) FROM `information_schema`.`tables` {$where} GROUP BY `table_schema`") or sxd_my_error();
- while($item = mysql_fetch_row($result)){
- if($item[0] == 'information_schema' || $item[0] == 'mysql' || $item[0] == 'performance_schema') continue;
- $dbs[$item[0]] = "{$item[0]} ({$item[1]})";
- }
- }
- return $dbs;
- }
- function getCharsetList(){
- $tmp = array(0 => '- auto -');
- if (!V_MYSQL) return $tmp;
- if(V_MYSQL > 40101) {
- $def_charsets = '';
- if(!empty($this->CFG['charsets'])){
- $def_charsets = preg_match_all("/([\w*?]+)\s*/", $this->CFG['charsets'], $m, PREG_PATTERN_ORDER) ? '/^(' . str_replace(array('?','*'), array('.','\w+?'), implode('|', $m[1])) . ')$/i' : '';
- }
- $r = mysql_query("SHOW CHARACTER SET") or sxd_my_error();
- if ($r) {
- while($item = mysql_fetch_assoc($r)){
- if (empty($def_charsets) || preg_match($def_charsets, $item['Charset'])) $tmp[$item['Charset']] = "{$item['Charset']}"; // ({$item['Description']})
- }
- }
- }
- return $tmp;
- }
- function getCollationList(){
- $tmp = array();
- if (!V_MYSQL) return $tmp;
- if(V_MYSQL > 40101) {
- $def_charsets = '';
- if(!empty($this->CFG['charsets'])){
- $def_charsets = preg_match_all("/([\w*?]+)\s*/", $this->CFG['charsets'], $m, PREG_PATTERN_ORDER) ? '/^(' . str_replace(array('?','*'), array('.','\w+?'), implode('|', $m[1])) . ')$/i' : '';
- }
- $r = mysql_query("SHOW COLLATION") or sxd_my_error();
- if ($r) {
- while($item = mysql_fetch_assoc($r)){
- if (empty($def_charsets) || preg_match($def_charsets, $item['Charset'])) $tmp[$item['Charset']][$item['Collation']] = $item['Default'] == 'Yes' ? 1 : 0;
- }
- }
- }
- return $tmp;
- }
- function getObjects($tree, $db_name){
- mysql_select_db($db_name);
- // Достаем таблицы
- $r = mysql_query('SHOW TABLE STATUS');
- $tab_prefix_last = $tab_prefix = '*';
- $objects = array('TA' => array(), 'VI' => array(), 'PR' => array(), 'FU' => array(), 'TR' => array(), 'EV' => array());
- if($r){
- while($item = mysql_fetch_assoc($r)){
- if(V_MYSQL > 40101 && is_null($item['Engine']) && preg_match('/^VIEW/i', $item['Comment'])) {
- $objects['VI'][]= $item['Name'];
- }
- else{
- $objects['TA'][] = array($item['Name'], $item['Rows'], $item['Data_length']);
- }
- }
-
- if (V_MYSQL > 50014 && $tree != 'services') {
- $shows = array(
- "PROCEDURE STATUS WHERE db='{$db_name}'",
- "FUNCTION STATUS WHERE db='{$db_name}'",
- 'TRIGGERS'
- );
- if(V_MYSQL > 50100) $shows[] = "EVENTS WHERE db='{$db_name}'";
- // TODO: Поправить проверку событий и триггеров
- for($i = 0,…
Large files files are truncated, but you can click here to view the full file