PageRenderTime 65ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 1ms

/modules/sxd/index.php

https://bitbucket.org/ssimpledecision/simpledecision
PHP | 1976 lines | 1882 code | 39 blank | 55 comment | 381 complexity | de56fc1519f9837c0c8b44ee13ec4d75 MD5 | raw file
    

  1. <?php
    2. 

  2. session_start();
    3. 

  3. include '../../inc/connect_db.php';
    4. 

  4. function getUserType(){ 
    5. 

  5. 	if (isset($_SESSION['user_id'])){
    6. 

  6. 		global $pref;
    7. 

  7. 		$sql = "select * from {$pref}db_users where id='{$_SESSION['user_id']}' limit 1";
    8. 

  8. 		return mysql_result(mysql_query($sql),0, 'type');
    9. 

  9. 	}
    10. 

  10. }
    11. 

  11. /***************************************************************************\
    12. 

  12. | Sypex Dumper               version 2.0.10                                 |
    13. 

  13. | (c) 2003-2011 zapimir      zapimir@zapimir.net       http://sypex.net/    |
    14. 

  14. | (c) 2005-2011 BINOVATOR    info@sypex.net                                 |
    15. 

  15. |---------------------------------------------------------------------------|
    16. 

  16. |     created: 2003.09.02 19:07              modified: 2012.11.14 06:27     |
    17. 

  17. |---------------------------------------------------------------------------|
    18. 

  18. | Sypex Dumper is released under the terms of the BSD license               |
    19. 

  19. |   http://sypex.net/bsd_license.txt                                        |
    20. 

  20. \***************************************************************************/
    21. 

  21. header("Expires: Wed, 19 Nov 2008 19:19:19 GMT");
    22. 

  22. header("Cache-Control: no-store, no-cache, must-revalidate");
    23. 

  23. header("Content-Type: text/html; charset=utf-8");
    24. 

  24. //error_reporting(E_ALL);
    25. 

  25. error_reporting(0);
    26. 

  26. if (!ini_get('zlib.output_compression') && function_exists('ob_gzhandler')) ob_start('ob_gzhandler');
    27. 

  27. set_error_handler('sxd_error_handler');
    28. 

  28. register_shutdown_function('sxd_shutdown');
    29. 

  29. $SXD = new Sypex_Dumper();
    30. 

  30. chdir(dirname(__FILE__));
    31. 

  31. $SXD->init(!empty($argc) && $argc > 1 ? $argv : false);
    32. 

  32.  
    33. 

  33. class Sypex_Dumper {
    34. 

  34. 	function Sypex_Dumper() {
    35. 

  35. 		define('C_DEFAULT', 1);
    36. 

  36. 		define('C_RESULT', 2);
    37. 

  37. 		define('C_ERROR', 3);
    38. 

  38. 		define('C_WARNING', 4);
    39. 

  39. 		define('SXD_DEBUG', false);
    40. 

  40. 		define('TIMER', array_sum(explode(' ', microtime()))); 
    41. 

  41. 		define('V_SXD', 20010);
    42. 

  42. 		define('V_PHP', sxd_ver2int(phpversion()));
    43. 

  43. 		$this->name = 'Sypex Dumper 2.0.10';
    44. 

  44. 	}
    45. 

  45. 	function loadLang($lng_name = 'auto'){
    46. 

  46. 		if($lng_name == 'auto'){
    47. 

  47. 			include('lang/list.php');
    48. 

  48. 			$this->langs = &$langs;
    49. 

  49. 			$lng = 'en';
    50. 

  50. 			if(preg_match_all('/[a-z]{2}(-[a-z]{2})?/', $_SERVER['HTTP_ACCEPT_LANGUAGE'], $m)) {
    51. 

  51. 				foreach($m[0] AS $l){
    52. 

  52. 					if(isset($langs[$l])){
    53. 

  53. 						$lng_name = $l;
    54. 

  54. 						break;
    55. 

  55. 					}
    56. 

  56. 				}
    57. 

  57. 			}
    58. 

  58. 		}
    59. 

  59. 		if(file_exists("lang/lng_{$lng_name}.php")) include("lang/lng_{$lng_name}.php");
    60. 

  60. 		else include("lang/lng_en.php");
    61. 

  61. 		$this->LNG = &$LNG;
    62. 

  62. 		$this->LNG['name'] = $lng_name;
    63. 

  63. 		return true;
    64. 

  64. 	}
    65. 

  65. 	function init($args = false){
    66. 

  66. 		if (get_magic_quotes_gpc()) {
    67. 

  67. 			$_POST = sxd_antimagic($_POST);
    68. 

  68. 		}
    69. 

  69. 		include('cfg.php');
    70. 

  70. 		$this->loadLang($CFG['lang']);
    71. 

  71. 		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']);
    72. 

  72. 		elseif (ini_get('max_execution_time') < $CFG['time_web']) $CFG['time_web'] = ini_get('max_execution_time');
    73. 

  73. 		$this->CFG = &$CFG;
    74. 

  74. 		$this->try = false;
    75. 

  75. 		$this->virtualize = false;
    76. 

  76. 		$this->cron_mode = false;
    77. 

  77. 		// Проверяем авторизацию и делаем коннект к базе
    78. 

  78. 		if(empty($this->CFG['my_user'])){
    79. 

  79. 			$this->CFG['my_host'] = 'localhost';
    80. 

  80. 			$this->CFG['my_port'] = 3306;
    81. 

  81. 			$this->CFG['my_user'] = 'root';
    82. 

  82. 			$this->CFG['my_pass'] = '';
    83. 

  83. 			$this->CFG['my_comp'] = 0;
    84. 

  84. 			$this->CFG['my_db'] = '';
    85. 

  85. 		}
    86. 

  86. 		if ($args) { // консольный режим
    87. 

  87. 		    foreach($args AS $key => $arg){
    88. 

  88. 		        if (preg_match("/^-([hupoj])=(.*?)$/", $arg, $m)){
    89. 

  89. 		            switch ($m[1]) {
    90. 

  90. 		                case 'h': $this->CFG['my_host'] = $m[2]; break; // хост
    91. 

  91. 		                case 'o': $this->CFG['my_port'] = $m[2]; break; // порт
    92. 

  92. 		                case 'u': $this->CFG['my_user'] = $m[2]; break; // логин
    93. 

  93. 		                case 'p': $this->CFG['my_pass'] = $m[2]; break; // пароль
    94. 

  94. 		                case 'j': $this->CFG['sjob'] = $m[2]; break; // job-файл
    95. 

  95. 		            }
    96. 

  96. 		        }
    97. 

  97. 		    }
    98. 

  98. 		    $this->cron_mode = true;
    99. 

  99. 		    set_time_limit($CFG['time_cron']);
    100. 

  100. 		    // Загружаем конфиг файл, если нужно
    101. 

  101. 		    $auth = $this->connect();
    102. 

  102. 		    if($auth && !empty($this->CFG['sjob'])){
    103. 

  103. 				$this->ajax($this->loadJob($this->CFG['sjob']));
    104. 

  104. 				echo file_get_contents($this->JOB['file_log']);
    105. 

  105. 				if(file_exists($this->JOB['file_log'])) unlink($this->JOB['file_log']);
    106. 

  106. 				if(file_exists($this->JOB['file_rtl'])) unlink($this->JOB['file_rtl']);
    107. 

  107. 		    }
    108. 

  108. 		    else echo 'Auth error';
    109. 

  109. 		    exit;
    110. 

  110. 		}
    111. 

  111. 		elseif(!empty($this->CFG['auth'])){ // Авторизация
    112. 

  112. 			$auth = false;
    113. 

  113. 			$sfile = 'ses.php';
    114. 

  114. 			
    115. 

  115. 			if(!empty($_COOKIE['sxd']) && preg_match('/^[\da-f]{32}$/', $_COOKIE['sxd'])){
    116. 

  116. 				include($sfile);
    117. 

  117. 				if(isset($SES[$_COOKIE['sxd']])) {
    118. 

  118. 					$auth = true;
    119. 

  119. 					$this->CFG = $SES[$_COOKIE['sxd']]['cfg'];
    120. 

  120. 					$this->SES = &$SES;
    121. 

  121. 					$this->loadLang($this->CFG['lang']);
    122. 

  122. 				}
    123. 

  123. 			}
    124. 

  124. 			if(!$auth) {
    125. 

  125. 				if (!empty($_SESSION['user_id']) && getUserType()==2){
    126. 

  126. 					global $db_user,$db_pass,$db_host;
    127. 

  127. 					$user = $db_user;
    128. 

  128. 					$pass = $db_pass;
    129. 

  129. 					$host = $db_host;
    130. 

  130. 					$port = 3306;
    131. 

  131. 				} else{
    132. 

  132. 					$user = !empty($_POST['user']) ? $_POST['user'] : '';
    133. 

  133. 					$pass = !empty($_POST['pass']) ? $_POST['pass'] : '';
    134. 

  134. 					$host = !empty($_POST['host']) ? $_POST['host'] : (!empty($this->CFG['my_host']) ? $this->CFG['my_host'] : 'localhost');
    135. 

  135. 					$port = !empty($_POST['port']) && is_numeric($_POST['port']) ? $_POST['port'] : 3306;
    136. 

  136. 				}
    137. 

  137. 				$temp = preg_split('/\s+/', $this->CFG['auth']);
    138. 

  138. 				if(!empty($_REQUEST['lang']) && preg_match('/^[a-z]{2}(-[a-z]{2})?$/', $_REQUEST['lang'])) {$this->loadLang($_REQUEST['lang']);}
    139. 

  139. 				foreach($temp AS $a){
    140. 

  140. 					switch($a) {
    141. 

  141. 						case 'cfg': 	if(empty($user)) {continue;}
    142. 

  142. 										$auth = !empty($CFG['user']) && isset($CFG['pass']) && $CFG['user']== $user && $CFG['pass'] == $pass;
    143. 

  143. 										break;
    144. 

  144. 						case 'mysql':	if(empty($user)) {continue;}
    145. 

  145. 										if($host != 'localhost' && !empty($this->CFG['my_host']) && $this->CFG['my_host'] != $host) {continue;}
    146. 

  146. 										$auth = $this->connect($host, $port, $user, $pass);
    147. 

  147. 										break;
    148. 

  148. 						default:		$file = 'auth_' . $a . '.php';
    149. 

  149. 										if(!file_exists($file)) continue;
    150. 

  150. 										include	$file;
    151. 

  151. 					}
    152. 

  152. 					if($auth) break;
    153. 

  153. 				}
    154. 

  154. 				if($auth){
    155. 

  155. 					$key = md5(rand(1,100000) . $user . microtime());
    156. 

  156. 					$CFG['lang'] = $this->LNG['name'];
    157. 

  157. 					$_COOKIE['sxd'] = $key;
    158. 

  158. 					$this->saveCFG();
    159. 

  159. 					if(V_PHP > 50200) setcookie('sxd', $key, !empty($_POST['save']) ? time() + 31536000 : 0, '', '', false, true);
    160. 

  160. 					else setcookie('sxd', $key, !empty($_POST['save']) ? time() + 31536000 : 0, '', '', false);
    161. 

  161. 					header("Location: ./");
    162. 

  162. 					exit;
    163. 

  163. 				}
    164. 

  164. 				foreach(array('user', 'pass', 'host', 'port') AS $key){
    165. 

  165. 					$_POST[$key] = !empty($_POST[$key]) ? htmlspecialchars($_POST[$key], ENT_NOQUOTES) : '';
    166. 

  166. 				}
    167. 

  167. 				$_POST['save'] = !empty($_POST['save']) ? ' CHECKED' : '';
    168. 

  168. 			}
    169. 

  169. 			if (!$auth) {
    170. 

  170. 				if(!empty($_POST['ajax'])){
    171. 

  171. 					echo "sxd.hideLoading();alert('Session not found');";
    172. 

  172. 					exit;
    173. 

  173. 				}
    174. 

  174. 				$this->lng_list = '<option value="auto">- auto -</opinion>';
    175. 

  175. 				if(!isset($this->langs)) {include('lang/list.php');$this->langs = &$langs;}
    176. 

  176. 				foreach($this->langs AS $k => $v){
    177. 

  177. 					$this->lng_list .= "<option value=\"{$k}\"" . ($k == (!empty($_REQUEST['lang']) ? $this->LNG['name'] : $this->CFG['lang']) ? ' SELECTED' : '') . ">{$v}</opinion>";
    178. 

  178. 				}
    179. 

  179. 				echo sxd_tpl_auth();
    180. 

  180. 				exit;
    181. 

  181. 			}
    182. 

  182. 		}
    183. 

  183. 		if(empty($_POST['ajax']['act']) || $_POST['ajax']['act'] != 'save_connect') $this->connect();
    184. 

  184. 		if(isset($_POST['ajax'])) $this->ajax($_POST['ajax']);
    185. 

  185. 		else $this->main();exit;
    186. 

  186. 	}
    187. 

  187. 	function saveToFile($name, $content){
    188. 

  188. 		$fp = fopen($name, "w");
    189. 

  189. 		fwrite($fp, $content);
    190. 

  190. 		fclose($fp);
    191. 

  191. 	}
    192. 

  192. 	function connect($host = null, $port = null, $user = null, $pass = null){
    193. 

  193. 		$this->error = '';
    194. 

  194. 		$this->try = true;
    195. 

  195. 		if(!empty($user) && isset($pass)) {
    196. 

  196. 			$this->CFG['my_host'] = $host;
    197. 

  197. 			$this->CFG['my_port'] = $port;
    198. 

  198. 			$this->CFG['my_user'] = $user;
    199. 

  199. 			$this->CFG['my_pass'] = $pass;
    200. 

  200. 		}
    201. 

  201. 		if(mysql_connect($this->CFG['my_host'] . ($this->CFG['my_host']{0} != ':' ? ":{$this->CFG['my_port']}" : ''),  $this->CFG['my_user'], $this->CFG['my_pass'])) {
    202. 

  202. 			if(V_PHP > 50202) mysql_set_charset('utf8') or sxd_my_error();
    203. 

  203. 			else mysql_query('SET NAMES utf8') or sxd_my_error();
    204. 

  204. 			define('V_MYSQL', sxd_ver2int(mysql_get_server_info()));
    205. 

  205. 		}
    206. 

  206. 		else {
    207. 

  207. 			define('V_MYSQL', 0); 
    208. 

  208. 			$this->error = "sxd.actions.tab_connects();alert(" . sxd_esc(mysql_error()) . ");";
    209. 

  209. 		}	
    210. 

  210. 		$this->try = false;
    211. 

  211. 		return V_MYSQL ? true: false;
    212. 

  212. 	}
    213. 

  213. 	function main(){
    214. 

  214.    		// Тулбар
    215. 

  215. 		$this->VAR['toolbar'] = sxd_php2json(
    216. 

  216. 			array(
    217. 

  217. 				array('backup', $this->LNG['tbar_backup'], 1, 3),
    218. 

  218. 				array('restore', $this->LNG['tbar_restore'], 2, 3),
    219. 

  219. 				array('|'),
    220. 

  220. 				array('files', $this->LNG['tbar_files'], 3, 1), 
    221. 

  221. 				array('services', $this->LNG['tbar_services'], 5, 1),
    222. 

  222. 				array('|'),
    223. 

  223. 				array('createdb', $this->LNG['tbar_createdb'], 7, 0),
    224. 

  224. 				array('connects', $this->LNG['tbar_connects'], 6, 0),
    225. 

  225. 				array('|'),
    226. 

  226. 				array('options', $this->LNG['tbar_options'], 4, 1),
    227. 

  227. 				array('|'),
    228. 

  228. 				array('exit', $this->LNG['tbar_exit'], 8, 1),
    229. 

  229. 			)
    230. 

  230. 		);
    231. 

  231.   		$this->db = 'temp';
    232. 

  232. 		$zip = array($this->LNG['zip_none']);
    233. 

  233. 		if (function_exists("gzopen")) {
    234. 

  234. 			for($i = 1; $i <10; $i++){
    235. 

  235. 				$zip[] = "GZip: {$i}";
    236. 

  236. 			}
    237. 

  237. 			$zip[1] .= " ({$this->LNG['zip_min']})";
    238. 

  238. 			$zip[7] .= " ({$this->LNG['default']})";
    239. 

  239. 		}
    240. 

  240. 		if (function_exists("bzopen")) {
    241. 

  241. 		    $zip[10] = "BZip";
    242. 

  242. 		}
    243. 

  243. 		end($zip);
    244. 

  244. 		$zip[key($zip)] .=  " ({$this->LNG['zip_max']})";
    245. 

  245. 		$this->VAR['combos'] =
    246. 

  246. 			$this->addCombo('backup_db', $this->db, 11, 'db', array()/*$this->getDBList()*/) . 
    247. 

  247. 			$this->addCombo('backup_charset', 0, 9, 'charset', $this->getCharsetList()) .
    248. 

  248. 			$this->addCombo('backup_zip', 7, 10, 'zip', $zip) .
    249. 

  249. 			$this->addCombo('restore_db', $this->db, 11, 'db') . 
    250. 

  250. 			$this->addCombo('restore_charset', 0, 9, 'charset') . 
    251. 

  251. 			$this->addCombo('restore_file', 0, 12, 'files', $this->getFileList()) . 
    252. 

  252. 			$this->addCombo('restore_type', 0, 13, 'types', array("CREATE + INSERT ({$this->LNG['default']})", 'TRUNCATE + INSERT', 'REPLACE', 'INSERT IGNORE')) .
    253. 

  253. 			$this->addCombo('services_db', $this->db, 11, 'db') .
    254. 

  254. 			$this->addCombo('services_check', 0, 5, 'check', array("- {$this->LNG['default']} -", 'QUICK', 'FAST', 'CHANGED', 'MEDIUM', 'EXTENDED')) .
    255. 

  255. 			$this->addCombo('services_repair', 0, 5, 'repair', array("- {$this->LNG['default']} -", 'QUICK', 'EXTENDED')) .
    256. 

  256. 			$this->addCombo('db_charset', 0, 9, 'collation', $this->getCollationList()) .
    257. 

  257. 			$this->addCombo('db_charset_col', 0, 15, 'collation:db_charset')
    258. 

  258. 		;
    259. 

  259. 		if (!V_MYSQL) $this->VAR['combos'] .= $this->error;
    260. 

  260. 		$this->VAR['combos']   .= $this->getSavedJobs() . "sxd.confirms = {$this->CFG['confirm']};sxd.actions.dblist();";
    261. 

  261. 		$this->LNG['del_date']  = sprintf($this->LNG['del_date'], '<input type="text" id="del_time" class=txt style="width:24px;" maxlength="3">');
    262. 

  262. 		$this->LNG['del_count'] = sprintf($this->LNG['del_count'], '<input id="del_count" type="text" class=txt style="width:18px;" maxlength="2">');
    263. 

  263. 		
    264. 

  264. 		echo sxd_tpl_page();
    265. 

  265. 	}
    266. 

  266. 	function addCombo($name, $sel, $ico, $opt_name, $opts = ''){
    267. 

  267. 		$opts = !empty($opts) ? "{{$opt_name}:" . sxd_php2json($opts) . '}' : "'{$opt_name}'";
    268. 

  268. 		return "sxd.addCombo('{$name}', '{$sel}', {$ico}, {$opts});\n";
    269. 

  269. 	}
    270. 

  270. 	function ajax($req){
    271. 

  271. 		$res = '';
    272. 

  272. 		$act = $req['act'];
    273. 

  273. 		if($req['act'] == 'run_savedjob'){
    274. 

  274. 			$req = $this->loadJob($req);
    275. 

  275. 		}
    276. 

  276. 		switch($req['act']){
    277. 

  277. 			case 'load_db': 
    278. 

  278. 				$res = $this->getObjects(str_replace('_db', '', $req['name']), $req['value']);
    279. 

  279. 				break;
    280. 

  280. 			case 'load_files': 
    281. 

  281. 				$res = $this->getFileObjects('restore', $req['value']);
    282. 

  282. 				break;
    283. 

  283. 			case 'filelist': 
    284. 

  284. 				$res = "sxd.clearOpt('files');sxd.addOpt(" . sxd_php2json(array('files' => $this->getFileList())) . ");";
    285. 

  285. 				break;
    286. 

  286. 			case 'dblist':
    287. 

  287. 				$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,'-');";
    288. 

  288. 				break;
    289. 

  289. 			case 'load_connect':
    290. 

  290. 				$CFG = $this->cfg2js($this->CFG); 
    291. 

  291. 				$res = "z('con_host').value = '{$CFG['my_host']}', z('con_port').value = '{$CFG['my_port']}', z('con_user').value = '{$CFG['my_user']}',
    292. 

  292. 			z('con_pass').value = '', z('con_comp').checked = {$CFG['my_comp']}, z('con_db').value = '{$CFG['my_db']}', z('con_pass').changed = false;" ;
    293. 

  293. 				break;
    294. 

  294. 			case 'save_connect': 
    295. 

  295. 				$res = $this->saveConnect($req);
    296. 

  296. 				break;
    297. 

  297. 			case 'save_job': 
    298. 

  298. 				unset($req['act']);
    299. 

  299. 				$this->saveJob('sj_' . $req['job'] , $req);
    300. 

  300. 				$res = $this->getSavedJobs();
    301. 

  301. 				break;
    302. 

  302. 			case 'add_db': 
    303. 

  303. 				$res = $this->addDb($req);
    304. 

  304. 				break;
    305. 

  305. 			case 'load_options':
    306. 

  306. 				$CFG = $this->cfg2js($this->CFG);
    307. 

  307. 				$res = "z('time_web').value = '{$CFG['time_web']}', z('time_cron').value = '{$CFG['time_cron']}', z('backup_path').value = '{$CFG['backup_path']}',
    308. 

  308. 			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']};";
    309. 

  309. 				break;
    310. 

  310. 			case 'save_options': 
    311. 

  311. 				$res = $this->saveOptions($req);
    312. 

  312. 				break;
    313. 

  313. 			case 'delete_file':
    314. 

  314. 				if(preg_match('/^[^\/]+?\.sql(\.(gz|bz2))?$/', $req['name'])) {
    315. 

  315. 					$file = $this->CFG['backup_path'] . $req['name'];
    316. 

  316. 					if(file_exists($file)) unlink($file);
    317. 

  317. 				}
    318. 

  318. 				$res = $this->getFileListExtended();
    319. 

  319. 				break;
    320. 

  320. 			case 'delete_db':
    321. 

  321. 				$res = $this->deleteDB($req['name']);
    322. 

  322. 				break;
    323. 

  323. 			case 'load_files_ext': 
    324. 

  324. 				$res .= $this->getFileListExtended();
    325. 

  325. 				break;
    326. 

  326. 			case 'services': 
    327. 

  327. 				$this->runServices($req);
    328. 

  328. 				break;	
    329. 

  329. 			case 'backup': 
    330. 

  330. 				$this->addBackupJob($req);
    331. 

  331. 				break;
    332. 

  332. 			case 'restore': 
    333. 

  333. 				$this->addRestoreJob($req);
    334. 

  334. 				break;
    335. 

  335. 			case 'resume': 
    336. 

  336. 				$this->resumeJob($req);
    337. 

  337. 				break;
    338. 

  338. 			case 'exit': 
    339. 

  339. 				setcookie('sxd', '', 0);
    340. 

  340. 				$res = "top.location.href = " . sxd_esc($this->CFG['exitURL']) . ";";
    341. 

  341. 				break;
    342. 

  342. 		}	
    343. 

  343. 		echo $res;
    344. 

  344. 	}
    345. 

  345. 	function loadJob($job){
    346. 

  346. 		$file = $this->CFG['backup_path'] . 'sj_' . (is_array($job) ? $job['job'] : $job) . '.job.php';
    347. 

  347. 		if(!file_exists($file)) return;
    348. 

  348. 		include($file);
    349. 

  349. 		$JOB['act'] = $JOB['type'];
    350. 

  350. 		$JOB['type'] = 'run';
    351. 

  351. 		return $JOB;
    352. 

  352. 	}
    353. 

  353. 	function deleteDB($name){
    354. 

  354. 		$r = mysql_query('DROP DATABASE `' . sxd_esc($name, false) . '`') or sxd_my_error();
    355. 

  355. 		if($r){
    356. 

  356.         	echo "sxd.clearOpt('db');sxd.addOpt(" . sxd_php2json(array('db' => $this->getDBList())) . ");sxd.combos.services_db.select(0,'-');";
    357. 

  357. 		}
    358. 

  358.         else
    359. 

  359.         	echo "alert(" . sxd_esc(mysql_error()) . ");";
    360. 

  360. 	}
    361. 

  361. 	function cfg2js($cfg){
    362. 

  362. 		foreach($cfg AS $k => $v){
    363. 

  363. 			$cfg[$k] = sxd_esc($v, false);
    364. 

  364. 		}
    365. 

  365. 		return $cfg;
    366. 

  366. 	}
    367. 

  367. 	function addDb($req){
    368. 

  368.         $r = mysql_query('CREATE DATABASE `' . sxd_esc($req['name'], false) . '`' . (V_MYSQL > 40100 ? "CHARACTER SET {$req['charset']} COLLATE {$req['collate']}" : ''));
    369. 

  369.         if($r)
    370. 

  370.         	echo "sxd.addOpt(" . sxd_php2json(array('db' => array($req['name'] => "{$req['name']} (0)"))) . ");";
    371. 

  371.         else
    372. 

  372.         	 sxd_my_error();
    373. 

  373. 	}
    374. 

  374. 	function saveConnect($req){
    375. 

  375. 		$this->CFG['my_host'] = $req['host'];
    376. 

  376. 		$this->CFG['my_port'] = (int)$req['port'];
    377. 

  377. 		$this->CFG['my_user'] = $req['user'];
    378. 

  378. 		if(isset($req['pass'])) $this->CFG['my_pass'] = $req['pass'];
    379. 

  379. 		$this->CFG['my_comp'] = $req['comp'] ? 1 : 0;
    380. 

  380. 		$this->CFG['my_db']   = $req['db'];
    381. 

  381. 		$this->saveCFG();
    382. 

  382.         $this->connect();
    383. 

  383.         if (V_MYSQL) {
    384. 

  384. 	        $tmp = array(
    385. 

  385.         		'db' => $this->getDBList(),
    386. 

  386.         		'charset' => $this->getCharsetList(),
    387. 

  387.         		'collation' => $this->getCollationList()
    388. 

  388. 			);
    389. 

  389. 	        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,'-');";
    390. 

  390. 		}
    391. 

  391. 		else {
    392. 

  392. 			 echo $this->error;
    393. 

  393. 		}
    394. 

  394. 	}
    395. 

  395. 	function saveOptions($req){
    396. 

  396. 		$this->CFG['time_web']    = $req['time_web'];
    397. 

  397. 		$this->CFG['time_cron']   = $req['time_cron'];
    398. 

  398. 		$this->CFG['backup_path'] = $req['backup_path'];
    399. 

  399. 		$this->CFG['backup_url']  = $req['backup_url'];
    400. 

  400. 		$this->CFG['globstat']    = $req['globstat'] ? 1 : 0;
    401. 

  401. 		$this->CFG['charsets']    = $req['charsets'];
    402. 

  402. 		$this->CFG['only_create'] = $req['only_create'];
    403. 

  403. 		$this->CFG['auth']        = $req['auth'];
    404. 

  404. 		$this->CFG['confirm']     = $req['confirm'];
    405. 

  405. 		$this->saveCFG();
    406. 

  406. 	}
    407. 

  407. 	function saveCFG(){
    408. 

  408. 		if (isset($_COOKIE['sxd'])) {
    409. 

  409. 			$this->SES[$_COOKIE['sxd']] = array('cfg' => $this->CFG, 'time' => time(), 'lng' => $this->LNG['name']);
    410. 

  410. 			$this->saveToFile('ses.php', "<?php\n\$SES = " . var_export($this->SES, true) . ";\n" . "?>");
    411. 

  411. 		}
    412. 

  412.         if (!$this->virtualize){
    413. 

  413.         	$this->saveToFile('cfg.php', "<?php\n\$CFG = " . var_export($this->CFG, true) . ";\n" . "?>");
    414. 

  414.         }
    415. 

  415. 	}
    416. 

  416. 	function runServices($job) {
    417. 

  417. 		$serv = array('optimize' => 'OPTIMIZE', 'analyze' => 'ANALYZE', 'check' => 'CHECK', 'repair' => 'REPAIR');
    418. 

  418. 		$add = array('check'  => array('', 'QUICK', 'FAST', 'CHANGED', 'MEDIUM', 'EXTENDED'), 'repair' => array('', 'QUICK', 'EXTENDED'));
    419. 

  419. 		if(isset($serv[$job['type']])) {
    420. 

  420. 			mysql_select_db($job['db']);
    421. 

  421. 			$filter = $object = array();
    422. 

  422. 			$this->createFilters($job['obj'], $filter, $object);
    423. 

  423. 			$r = mysql_query('SHOW TABLE STATUS') or sxd_my_error();
    424. 

  424. 			if (!$r) return;
    425. 

  425. 			$tables = array();
    426. 

  426. 			while($item = mysql_fetch_assoc($r)){
    427. 

  427. 				if(V_MYSQL > 40101 && is_null($item['Engine']) && preg_match('/^VIEW/i', $item['Comment'])) continue;
    428. 

  428. 				if(sxd_check($item['Name'], $object['TA'], $filter['TA'])) $tables[] = "`{$item['Name']}`";
    429. 

  429. 			}
    430. 

  430. 			$sql = $serv[$job['type']] . ' TABLE ' . implode(',', $tables);
    431. 

  431. 			
    432. 

  432. 			if ($job['type'] == 'check' || $job['type'] == 'repair') {
    433. 

  433. 				$sql .= isset($add[$job['type']][$job[$job['type']]]) ? ' ' . $add[$job['type']][$job[$job['type']]] : '';
    434. 

  434. 			}
    435. 

  435. 			
    436. 

  436. 			$r = mysql_query($sql) or sxd_my_error();
    437. 

  437. 			if (!$r) return;
    438. 

  438. 			$res = array();
    439. 

  439. 			while($item = mysql_fetch_row($r)){
    440. 

  440. 				$res[] = $item;
    441. 

  441. 			}
    442. 

  442. 			echo 'sxd.result.add(' . sxd_php2json($res). ');';
    443. 

  443. 		}
    444. 

  444. 	}
    445. 

  445. 	function createFilters(&$obj, &$filter, &$object){
    446. 

  446. 		$types = array('TA', 'TC', 'VI', 'PR', 'FU', 'TR', 'EV');
    447. 

  447. 		foreach($types AS $type){
    448. 

  448. 			$filter[$type] = array();
    449. 

  449. 			$object[$type] = array();
    450. 

  450. 			if(!empty($obj[$type])){
    451. 

  451. 				foreach($obj[$type] AS $v){
    452. 

  452. 					if(strpos($v, '*') !== false) {
    453. 

  453. 						$filter[$type][] = str_replace('*', '.*?', $v); 
    454. 

  454. 					}
    455. 

  455. 					else {
    456. 

  456. 						$object[$type][$v] = true;
    457. 

  457. 					}
    458. 

  458. 				}
    459. 

  459. 				$filter[$type] = count($filter[$type]) > 0 ? '/^(' . implode('|', $filter[$type]) . ')$/i' : '';
    460. 

  460. 			}
    461. 

  461. 		}
    462. 

  462. 	}
    463. 

  463. 	function closeConnect(){
    464. 

  464. 		//return;
    465. 

  465. 		@ignore_user_abort(1); 
    466. 

  466. 		header("SXD: {$this->name}");
    467. 

  467. 		header("Connection: close"); 
    468. 

  468. 		header("Content-Length: 0"); 
    469. 

  469. 		@ob_end_flush(); 
    470. 

  470. 		@flush();
    471. 

  471. 	}
    472. 

  472. 	function resumeJob($job){
    473. 

  473. 		$this->closeConnect();
    474. 

  474. 		include($this->CFG['backup_path'] . $job['job'] . '.job.php');
    475. 

  475. 		$this->JOB = &$JOB;
    476. 

  476. 		if(file_exists($this->JOB['file_stp'])) unlink($this->JOB['file_stp']);
    477. 

  477. 		$this->fh_rtl = fopen($this->JOB['file_rtl'], 'r+b');
    478. 

  478. 		$this->fh_log = fopen($this->JOB['file_log'], 'ab');
    479. 

  479. 		$t = fgets($this->fh_rtl);
    480. 

  480. 		if(!empty($t)){
    481. 

  481. 			$this->rtl = explode("\t", $t);	
    482. 

  482. 		}
    483. 

  483. 		else {
    484. 

  484. 			$this->addLog($this->LNG['not_found_rtl']);
    485. 

  485. 			exit;
    486. 

  486. 		}
    487. 

  487. 		// TODO: проверить удаление кодировки
    488. 

  488. 		//$this->rtl[6] = '';
    489. 

  489. 		fseek($this->fh_rtl, 0);
    490. 

  490. 		$this->rtl[1] = time();
    491. 

  491. 		$this->rtl[9] = 0;
    492. 

  492. 		fwrite($this->fh_rtl, implode("\t", $this->rtl));
    493. 

  493. 		if ($this->JOB['act'] == 'backup') $this->runBackupJob(true);
    494. 

  494. 		elseif ($this->JOB['act'] == 'restore') $this->runRestoreJob(true);
    495. 

  495. 	}
    496. 

  496. 	function addRestoreJob($job) {
    497. 

  497. 		$this->closeConnect();
    498. 

  498. 		$this->JOB = $job;
    499. 

  499. 		// Создаем список объектов и фильтр
    500. 

  500. 		$filter = $object = array();
    501. 

  501.    		$this->createFilters($this->JOB['obj'], $filter, $object);
    502. 

  502. 		
    503. 

  503. 		$objects = $this->getFileObjects('restore', $this->JOB['file'], false);
    504. 

  504. 		$todo = array();
    505. 

  505. 		$rows = 0;
    506. 

  506. 		$this->tab_rows = array();
    507. 

  507. 		$todo = array();
    508. 

  508. 		foreach($objects AS $t => $list){
    509. 

  509. 			if($t == 'TA' && (!empty($object['TC']) || !empty($filter['TC']))) {}
    510. 

  510. 			elseif(empty($object[$t]) && empty($filter[$t])) {continue;}
    511. 

  511. 			if (empty($list)) continue;
    512. 

  512. 			
    513. 

  513. 			foreach($list AS $item){
    514. 

  514. 				switch($t){
    515. 

  515. 					case 'TA':
    516. 

  516. 						$type = '';
    517. 

  517. 						if(sxd_check($item[0], $object['TA'], $filter['TA'])){
    518. 

  518. 							$type = empty($item[1]) ? 'TC' : 'TA';
    519. 

  519. 						}
    520. 

  520. 						elseif(sxd_check($item[0], $object['TC'], $filter['TC'])) {
    521. 

  521. 							$type = 'TC';
    522. 

  522. 						}
    523. 

  523. 						else continue;
    524. 

  524. 						$todo['TA'][]   = array($type, $item[0], $item[1], $item[2]);
    525. 

  525. 						$rows += $type == 'TA' ? $item[1] : 0;
    526. 

  526. 					break;
    527. 

  527. 					default:
    528. 

  528. 						if(sxd_check($item, $object[$t], $filter[$t])) {
    529. 

  529. 							$todo[$t][] = array($t, $item);
    530. 

  530. 						}
    531. 

  531. 				}
    532. 

  532. 			}
    533. 

  533. 		}
    534. 

  534. 		$this->JOB['file_tmp'] = $this->JOB['file_name'] = $this->CFG['backup_path'] . $this->JOB['file'];
    535. 

  535. 		$this->JOB['file_rtl'] = $this->CFG['backup_path'] . $this->JOB['job'] . '.rtl';
    536. 

  536. 		$this->JOB['file_log'] = $this->CFG['backup_path'] . $this->JOB['job'] . '.log';
    537. 

  537. 		$this->JOB['file_stp'] = $this->CFG['backup_path'] . $this->JOB['job'] . '.stp';
    538. 

  538. 		if(file_exists($this->JOB['file_stp'])) unlink($this->JOB['file_stp']);
    539. 

  539. 		
    540. 

  540. 		$this->fh_tmp = $this->openFile($this->JOB['file_tmp'], 'r');
    541. 

  541. 		// Для чужих дампов определяем разделители строк
    542. 

  542. 		if(is_null($this->JOB['obj'])) {
    543. 

  543. 			$s = fread($this->fh_tmp, 2048);
    544. 

  544. 			if(strpos($s, "\r\n")) $this->JOB['eol'] = "\r\n";
    545. 

  545. 			elseif(strpos($s, "\n")) $this->JOB['eol'] = "\n";
    546. 

  546. 			else $this->JOB['eol'] = "\r";
    547. 

  547. 			$bom = strncmp($s, "\xEF\xBB\xBF", 3) == 0 ? 3 : ((strncmp($s, "\xFE\xFF", 2) == 0 || strncmp($s, "\xFF\xFE", 2) == 0) ? 2 : 0);
    548. 

  548. 			fseek($this->fh_tmp, $bom);
    549. 

  549. 		}
    550. 

  550. 		$this->JOB['todo'] = $todo;
    551. 

  551. 		$this->saveJob($this->JOB['job'], $this->JOB);
    552. 

  552. 		$this->fh_rtl = fopen($this->JOB['file_rtl'], 'wb');
    553. 

  553. 		$this->fh_log = fopen($this->JOB['file_log'], 'wb');
    554. 

  554. 		$this->rtl = array(time(), time(), $rows, 0, '', '', '', 0, 0, 0, 0, TIMER, "\n");
    555. 

  555. 		$this->addLog(sprintf($this->LNG['restore_begin'], $this->JOB['db']));
    556. 

  556. 		$this->addLog("{$this->LNG['combo_file']} {$this->JOB['file']}");
    557. 

  557. 		$this->runRestoreJob();
    558. 

  558. 	}
    559. 

  559. 	function runRestoreJob($continue = false){
    560. 

  560. 		$ei = false;
    561. 

  561. 		if($continue){
    562. 

  562. 			$this->fh_tmp = $this->openFile($this->JOB['file_tmp'], 'r');
    563. 

  563. 			fseek($this->fh_tmp, $this->rtl[3]);
    564. 

  564. 			if(!empty($this->rtl[6])) $this->setNames($this->JOB['correct'] == 1 && !empty($this->JOB['charset']) ? $this->JOB['charset'] : $this->rtl[6]);
    565. 

  565. 			if($this->rtl[7] < $this->rtl[10]) $ei = true; 
    566. 

  566. 		}
    567. 

  567. 		mysql_select_db($this->JOB['db']);
    568. 

  568. 		if(is_null($this->JOB['obj'])) $this->runRestoreJobForeign($continue);
    569. 

  569. 		//mysql_query("SET NAMES 'UTF8'");
    570. 

  570. 		$types = array('VI' => 'View', 'PR' => 'Procedure', 'FU' => 'Function', 'TR' => 'Trigger', 'EV' => 'Event');
    571. 

  571. 		$fcache = '';
    572. 

  572. 		$writes = 0;
    573. 

  573. 		$old_charset = '';
    574. 

  574. 		$tab = '';
    575. 

  575. 		$seek = 0;
    576. 

  576. 		$this->rtl[3] = ftell($this->fh_tmp);
    577. 

  577. 		fseek($this->fh_rtl, 0);
    578. 

  578. 		$this->rtl[1] = time();
    579. 

  579. 		fwrite($this->fh_rtl, implode("\t", $this->rtl));
    580. 

  580. 		$c = 0;
    581. 

  581. 		switch($this->JOB['strategy']){
    582. 

  582. 			case 1: $tc = 'TRUNCATE'; $td = 'INSERT'; break;
    583. 

  583. 			case 2: $tc = ''; $td = 'REPLACE'; break;
    584. 

  584. 			case 3: $tc = ''; $td = 'INSERT IGNORE'; break;
    585. 

  585. 			default: $tc = 'DROP TABLE IF EXISTS'; $td = 'INSERT';
    586. 

  586. 		}
    587. 

  587. 		$tab_exists = array();
    588. 

  588. 		if($this->JOB['strategy'] > 0){
    589. 

  589. 			$r = mysql_query("SHOW TABLES") or sxd_my_error();
    590. 

  590. 			while($item = mysql_fetch_row($r)){
    591. 

  591. 				$tab_exists[$item[0]] = true;
    592. 

  592. 			}
    593. 

  593. 		}
    594. 

  594. 		$insert = $continue && $this->rtl[7] < $this->rtl[10] ? "{$td} INTO `{$this->rtl[5]}` VALUES " : '';
    595. 

  595. 		//$enable_index = array();
    596. 

  596. 		if(V_MYSQL > 40014) {
    597. 

  597. 			mysql_query("SET UNIQUE_CHECKS=0");
    598. 

  598. 			mysql_query("SET FOREIGN_KEY_CHECKS=0");
    599. 

  599. 			if(V_MYSQL > 40101) mysql_query("SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO'");
    600. 

  600. 			if(V_MYSQL > 40111) mysql_query("SET SQL_NOTES=0");
    601. 

  601. 		}
    602. 

  602. 		$log_sql = false;
    603. 

  603. 		$fields = '';
    604. 

  604. 		$time_old = time();
    605. 

  605. 		$exit_time = $time_old + $this->CFG['time_web'] - 1;
    606. 

  606. 		while($q = sxd_read_sql($this->fh_tmp, $seek, $ei)){	
    607. 

  607. 			if($time_old < time()) {
    608. 

  608. 				if(file_exists($this->JOB['file_stp'])){
    609. 

  609. 					$type = file_get_contents($this->JOB['file_stp']);
    610. 

  610. 					$this->rtl[9] = !empty($type) ? $type : 2;
    611. 

  611. 					fseek($this->fh_rtl, 0);
    612. 

  612. 					$this->rtl[1] = time();
    613. 

  613. 					fwrite($this->fh_rtl, implode("\t", $this->rtl));
    614. 

  614. 					/*if($type == 1) {
    615. 

  615. 						
    616. 

  616. 					}*/
    617. 

  617. 					unset($this->rtl);
    618. 

  618. 					exit;
    619. 

  619. 				}
    620. 

  620. 				$time_old = time();
    621. 

  621. 				if($time_old >= $exit_time){
    622. 

  622. 					$this->rtl[9] = 3;
    623. 

  623. 					fseek($this->fh_rtl, 0);
    624. 

  624. 					$this->rtl[1] = time();
    625. 

  625. 					fwrite($this->fh_rtl, implode("\t", $this->rtl));
    626. 

  626. 					unset($this->rtl);
    627. 

  627. 					exit;
    628. 

  628. 				}
    629. 

  629. 				clearstatcache(); 
    630. 

  630. 			}
    631. 

  631. 			switch($q{0}){
    632. 

  632. 				case '(':
    633. 

  633. 					if($continue) {
    634. 

  634. 						$this->addLog(sprintf("{$this->LNG['restore_TC']} {$this->LNG['continue_from']}", $this->rtl[5], $this->rtl[3]));
    635. 

  635. 						$continue = false;
    636. 

  636. 					}
    637. 

  637. 					$q = $insert . $q;
    638. 

  638. 					$ex = 1;
    639. 

  639. 					$c = 1;
    640. 

  640. 					break;	
    641. 

  641. 				case 'I':
    642. 

  642. 					if (preg_match('/^INSERT( INTO `(.+?)`) VALUES/', $q, $m)) {
    643. 

  643. 						$insert = $td . $m[1] . $fields . " VALUES \n";
    644. 

  644. 						$tab = $m[2];
    645. 

  645. 						$this->rtl[7] = 0;
    646. 

  646. 						$this->rtl[8] = 0;
    647. 

  647. 						foreach($this->JOB['todo']['TA'] AS $t){
    648. 

  648. 							if($t[1] == $tab) {
    649. 

  649. 								$this->rtl[8] = $t[2];
    650. 

  650. 							}	
    651. 

  651. 						}
    652. 

  652. 						if($this->JOB['strategy']) {
    653. 

  653. 							$q = substr_replace($q, $insert, 0, strlen($m[0]));
    654. 

  654. 						}
    655. 

  655. 						//mysql_query("LOCK TABLES `{$tab}` WRITE") or die (mysql_error());
    656. 

  656. 						mysql_query("ALTER TABLE `{$tab}` DISABLE KEYS") or sxd_my_error();
    657. 

  657. 						//if(!empty($this->JOB['autoinc'])) mysql_query("ALTER TABLE `{$tab}` AUTO_INCREMENT = 1") or sxd_my_error();
    658. 

  658. 						$ex = 1;
    659. 

  659. 					}
    660. 

  660. 					break;
    661. 

  661. 				case 'C':
    662. 

  662. 					$ex = 1;
    663. 

  663. 					if (preg_match('/^CREATE TABLE `/', $q)) {
    664. 

  664. 						if($this->JOB['strategy'] != 0 && isset($tab_exists[$this->rtl[5]])) $ex = 0;
    665. 

  665. 						else {
    666. 

  666. 							$ex = 1;
    667. 

  667. 							if((!empty($this->JOB['correct']) && !empty($this->JOB['charset']))){
    668. 

  668. 								$q = preg_replace('/(DEFAULT)?\s*(CHARSET|CHARACTER SET|COLLATE)[=\s]+\w+/i', '', $q) . (V_MYSQL < 40100 ? '' : ' DEFAULT CHARSET=' . $this->JOB['charset']);
    669. 

  669. 							}
    670. 

  670. 							if(!empty($this->JOB['autoinc'])) $q = preg_replace("/AUTO_INCREMENT=\d+/", "AUTO_INCREMENT=1", $q);
    671. 

  671. 						}
    672. 

  672. 						// Достаем имена полей таблицы
    673. 

  673. 						$fields = $this->JOB['strategy'] > 0 && preg_match_all('/^\s+(`.+?`) /m', $q, $f, PREG_PATTERN_ORDER) ? '(' . implode(',', $f[1]) . ')' : '';
    674. 

  674. 					}
    675. 

  675. 					break;
    676. 

  676. 				case '#': // Команды для дампера
    677. 

  677. 					if (preg_match("/\#\t(TC|TD|VI|PR|FU|TR|EV)`(.+?)`(([^_]+?)_.+?)?$/", $q, $m)) {
    678. 

  678. 						//if(!empty($tab)) $enable_index[] = $tab;
    679. 

  679. //						$this->setNames($this->JOB['correct'] == 1 && !empty($this->JOB['charset']) ? $this->JOB['charset'] : empty($m[3]) ? '' : $m[3]);
    680. 

  680. 						$this->setNames('binary');
    681. 

  681. 						if($m[1] == 'TC') {
    682. 

  682. 							$this->addLog(sprintf($this->LNG['restore_TC'], $m[2]));
    683. 

  683. 							$insert = '';
    684. 

  684. 							$tab = '';
    685. 

  685. 							$this->rtl[4] = 'TD';
    686. 

  686. 							$this->rtl[5] = $m[2];
    687. 

  687. 							$ei = 0;
    688. 

  688. 							if($tc && ($this->JOB['strategy'] == 0 || isset($tab_exists[$m[2]]))) {
    689. 

  689. 								mysql_query("{$tc} `{$m[2]}`") or sxd_my_error();
    690. 

  690. 							}
    691. 

  691. 						}
    692. 

  692. 						elseif($m[1] == 'TD'){
    693. 

  693. 							$ei = 1;
    694. 

  694. 						}
    695. 

  695. 						else {
    696. 

  696. 							$this->rtl[4] = $m[1];
    697. 

  697. 							$this->rtl[5] = $m[2];
    698. 

  698. 							$this->rtl[7] = 0;
    699. 

  699. 							$this->rtl[8] = 0;
    700. 

  700. 							mysql_query("DROP {$types[$m[1]]} IF EXISTS `{$m[2]}`") or sxd_my_error();
    701. 

  701. 							$this->addLog(sprintf($this->LNG["restore_{$m[1]}"], $m[2]));
    702. 

  702. 							$ei = 0;
    703. 

  703. 						}
    704. 

  704. 					}
    705. 

  705. 					$ex = 0;
    706. 

  706. 					break;
    707. 

  707. 				default: 
    708. 

  708. 					$insert = '';
    709. 

  709. 					$ex = 1;
    710. 

  710. 			}
    711. 

  711. 			if($ex) {
    712. 

  712. 				$this->rtl[3] = ftell($this->fh_tmp) - $seek;
    713. 

  713. 				fseek($this->fh_rtl, 0);
    714. 

  714. 				$this->rtl[1] = time();
    715. 

  715. 				fwrite($this->fh_rtl, implode("\t", $this->rtl));
    716. 

  716. 				if(mysql_query($q)) {
    717. 

  717. 					if($insert) {
    718. 

  718. 						$c = 1;
    719. 

  719. 					}
    720. 

  720. 				}
    721. 

  721. 				else {
    722. 

  722. 					error_log(date('r') . "\n----------\n{$q}\n", 3, "backup/sql_error.log");
    723. 

  723. 					sxd_my_error();
    724. 

  724. 				}
    725. 

  725. 				
    726. 

  726. 				if($c){
    727. 

  727. 					$i = mysql_affected_rows();
    728. 

  728. 					$this->rtl[3] = ftell($this->fh_tmp) - $seek;
    729. 

  729. 					$this->rtl[7] += $i;
    730. 

  730. 					$this->rtl[10] += $i;
    731. 

  731. 					fseek($this->fh_rtl, 0);
    732. 

  732. 					$this->rtl[1] = time();
    733. 

  733. 					fwrite($this->fh_rtl, implode("\t", $this->rtl));
    734. 

  734. 					$c = 1;
    735. 

  735. 				}
    736. 

  736. 			}
    737. 

  737. 			
    738. 

  738. 		}
    739. 

  739. 		// Включаем ключи
    740. 

  740. 		$this->addLog($this->LNG['restore_keys']);
    741. 

  741. 		$this->rtl[4] = 'EK';
    742. 

  742. 		$this->rtl[5] = '';
    743. 

  743. 		$this->rtl[6] = '';
    744. 

  744. 		$this->rtl[7] = 0;
    745. 

  745. 		$this->rtl[8] = 0;
    746. 

  746. 		foreach($this->JOB['todo']['TA'] AS $tab){
    747. 

  747. 			if ($tab[0] == 'TC') continue;
    748. 

  748. 			mysql_query("ALTER TABLE `{$tab[1]}` ENABLE KEYS") or sxd_my_error();
    749. 

  749. 			$this->rtl[1] = time();
    750. 

  750. 			$this->rtl[5] = $tab[1];
    751. 

  751. 			fseek($this->fh_rtl, 0);
    752. 

  752. 			fwrite($this->fh_rtl, implode("\t", $this->rtl));
    753. 

  753. 		}
    754. 

  754. 		$this->rtl[4] = 'EOJ';
    755. 

  755. 		$this->rtl[5] = round(array_sum(explode(' ', microtime())) - $this->rtl[11], 4);
    756. 

  756. 		
    757. 

  757. 		fseek($this->fh_rtl, 0);
    758. 

  758. 		fwrite($this->fh_rtl, implode("\t", $this->rtl));
    759. 

  759. 		$this->addLog(sprintf($this->LNG['restore_end'], $this->JOB['db']));
    760. 

  760. 		fclose($this->fh_log);
    761. 

  761. 		fclose($this->fh_rtl);
    762. 

  762. 	}
    763. 

  763. 	function runRestoreJobForeign($continue = false){
    764. 

  764. 		$ei = false;
    765. 

  765. 		
    766. 

  766. 		$fcache = '';
    767. 

  767. 		$writes = 0;
    768. 

  768. 		$old_charset = '';
    769. 

  769. 		$tab = '';
    770. 

  770. 		$seek = 0;
    771. 

  771. 		$this->rtl[3] = ftell($this->fh_tmp);
    772. 

  772. 		fseek($this->fh_rtl, 0);
    773. 

  773. 		$this->rtl[1] = time();
    774. 

  774. 		fwrite($this->fh_rtl, implode("\t", $this->rtl));
    775. 

  775. 		$c = 0;
    776. 

  776. 		
    777. 

  777. 		$log_sql = false;
    778. 

  778. 		$fields = '';
    779. 

  779. 		$insert = '';
    780. 

  780. 		$last_tab = '';
    781. 

  781. 		$time_old = time();
    782. 

  782. 		$exit_time = $time_old + $this->CFG['time_web'] - 1;
    783. 

  783. 		$delimiter = ";";
    784. 

  784. 		while($q = sxd_read_sql($this->fh_tmp, $seek, $ei, $delimiter, $this->JOB['eol'])){
    785. 

  785. 			$q = ltrim($q);
    786. 

  786. 			if(empty($q)) break;
    787. 

  787. 			if($time_old < time()) {
    788. 

  788. 				if(file_exists($this->JOB['file_stp'])){
    789. 

  789. 					$type = file_get_contents($this->JOB['file_stp']);
    790. 

  790. 					$this->rtl[9] = !empty($type) ? $type : 2;
    791. 

  791. 					fseek($this->fh_rtl, 0);
    792. 

  792. 					$this->rtl[1] = time();
    793. 

  793. 					fwrite($this->fh_rtl, implode("\t", $this->rtl));
    794. 

  794. 					/*if($type == 1) {
    795. 

  795. 						
    796. 

  796. 					}*/
    797. 

  797. 					unset($this->rtl);
    798. 

  798. 					exit;
    799. 

  799. 				}
    800. 

  800. 				$time_old = time();
    801. 

  801. 				if($time_old >= $exit_time){
    802. 

  802. 					$this->rtl[9] = 3;
    803. 

  803. 					fseek($this->fh_rtl, 0);
    804. 

  804. 					$this->rtl[1] = time();
    805. 

  805. 					fwrite($this->fh_rtl, implode("\t", $this->rtl));
    806. 

  806. 					unset($this->rtl);
    807. 

  807. 					exit;
    808. 

  808. 				}
    809. 

  809. 				clearstatcache(); 
    810. 

  810. 			}
    811. 

  811. 			do {
    812. 

  812. 				$repeat = false;
    813. 

  813. 				switch($q{0}){
    814. 

  814. 					case '(':
    815. 

  815. 						if($continue) {
    816. 

  816. 							$this->addLog(sprintf("{$this->LNG['restore_TC']} {$this->LNG['continue_from']}", $this->rtl[5], $this->rtl[3]));
    817. 

  817. 							$continue = false;
    818. 

  818. 						}
    819. 

  819. 						$q = $insert . $q;
    820. 

  820. 						$ex = 1;
    821. 

  821. 						$c = 1;
    822. 

  822. 						break;	
    823. 

  823. 					case 'I':
    824. 

  824. 					
    825. 

  825. 						if (preg_match('/^(INSERT( INTO `?(.+?)`?).+?\sVALUES)/s', $q, $m)) {
    826. 

  826. 							$insert = trim($m[1]) . ' ';
    827. 

  827. 							$tab = $m[3];
    828. 

  828. 							$this->rtl[7] = 0;
    829. 

  829. 							$this->rtl[8] = 0;
    830. 

  830. 							$ex = 1;
    831. 

  831. 						}
    832. 

  832. 						break;
    833. 

  833. 					case 'C':
    834. 

  834. 						$ex = 1;
    835. 

  835. 						$ei = 1;
    836. 

  836. 						if (preg_match('/^CREATE TABLE.+?`(.+?)`/', $q, $m)) {
    837. 

  837. 							$ex = 1;
    838. 

  838. 							$tab = $m[1];
    839. 

  839. 							$this->addLog(sprintf($this->LNG['restore_TC'], $tab));
    840. 

  840. 							//mysql_query("DROP TABLE IF EXISTS `{$tab}`");
    841. 

  841. 							if((!empty($this->JOB['correct']) && !empty($this->JOB['charset']))){
    842. 

  842. 								$q = preg_replace('/(DEFAULT)?\s*(CHARSET|CHARACTER SET|COLLATE)[=\s]+\w+/i', '', $q) . (V_MYSQL < 40100 ? '' : ' DEFAULT CHARSET=' . $this->JOB['charset']);
    843. 

  843. 							}
    844. 

  844. 							elseif(empty($this->JOB['charset'])){
    845. 

  845. 								if(preg_match("/(CHARACTER SET|CHARSET)[=\s]+(\w+)/i", $q, $charset)){
    846. 

  846. 									$this->setNames($charset[2]);
    847. 

  847. 								}
    848. 

  848. 							}
    849. 

  849. 						}
    850. 

  850. 						break;
    851. 

  851. 					case '-' && $q{1} == '-':
    852. 

  852. 					case '#':
    853. 

  853. 						$repeat = true;
    854. 

  854. 						$q = ltrim(substr($q, strpos($q, $this->JOB['eol'])));
    855. 

  855. 						$ex = 0;
    856. 

  856. 						break;
    857. 

  857. 					case '/':
    858. 

  858. 					case 'S':
    859. 

  859. 						if (preg_match('/SET NAMES (\w+)/', $q, $m)) {
    860. 

  860. 							$this->JOB['charset'] = $m[1];
    861. 

  861. 							$this->setNames($this->JOB['charset']);
    862. 

  862. 							$ex = 0;
    863. 

  863. 						}
    864. 

  864. 						else $ex = 1;
    865. 

  865. 					break;
    866. 

  866. 					default: 
    867. 

  867. 						$insert = '';
    868. 

  868. 						$ex = 1;
    869. 

  869. 						$ei = 0;
    870. 

  870. 				}
    871. 

  871. 			}  while ($repeat);
    872. 

  872. 			if($ex) {
    873. 

  873. 				$this->rtl[3] = ftell($this->fh_tmp) - $seek;
    874. 

  874. 				fseek($this->fh_rtl, 0);
    875. 

  875. 				$this->rtl[1] = time();
    876. 

  876. 				fwrite($this->fh_rtl, implode("\t", $this->rtl));
    877. 

  877. 				if(mysql_query($q)) {
    878. 

  878. 					if($insert) {
    879. 

  879. 						$c = 1;
    880. 

  880. 					}
    881. 

  881. 				}
    882. 

  882. 				else {
    883. 

  883. 					error_log("-----------------\n{$q}\n", 3, "error.log");
    884. 

  884. 					sxd_my_error();
    885. 

  885. 				}
    886. 

  886. 				
    887. 

  887. 				if($c){
    888. 

  888. 					$i = mysql_affected_rows();
    889. 

  889. 					$this->rtl[3] = ftell($this->fh_tmp) - $seek;
    890. 

  890. 					$this->rtl[7] += $i;
    891. 

  891. 					$this->rtl[10] += $i;
    892. 

  892. 					fseek($this->fh_rtl, 0);
    893. 

  893. 					$this->rtl[1] = time();
    894. 

  894. 					fwrite($this->fh_rtl, implode("\t", $this->rtl));
    895. 

  895. 					$c = 1;
    896. 

  896. 				}
    897. 

  897. 			}
    898. 

  898. 			
    899. 

  899. 		}
    900. 

  900. 		
    901. 

  901. 		$this->rtl[4] = 'EOJ';
    902. 

  902. 		$this->rtl[5] = round(array_sum(explode(' ', microtime())) - $this->rtl[11], 4);
    903. 

  903. 		$this->rtl[7] = 0;
    904. 

  904. 		$this->rtl[8] = 0;
    905. 

  905. 		
    906. 

  906. 		fseek($this->fh_rtl, 0);
    907. 

  907. 		fwrite($this->fh_rtl, implode("\t", $this->rtl));
    908. 

  908. 		$this->addLog(sprintf($this->LNG['restore_end'], $this->JOB['db']));
    909. 

  909. 		fclose($this->fh_log);
    910. 

  910. 		fclose($this->fh_rtl);
    911. 

  911. 	}
    912. 

  912. 	function addBackupJob($job) {
    913. 

  913. 		$this->closeConnect();
    914. 

  914. 		// Создаем новое задание
    915. 

  915. 		$this->JOB = $job;
    916. 

  916. 		mysql_select_db($this->JOB['db']);
    917. 

  917. 		// Создаем список объектов и фильтр
    918. 

  918. 		$filter = $object = array();
    919. 

  919. 		$this->createFilters($this->JOB['obj'], $filter, $object);
    920. 

  920. 		$queries = array(
    921. 

  921. 			array('TABLE STATUS', 'Name', 'TA')
    922. 

  922. 		);
    923. 

  923. 		if (V_MYSQL > 50014) {
    924. 

  924. 			$queries[] = array("PROCEDURE STATUS WHERE db='{$this->JOB['db']}'", 'Name', 'PR');
    925. 

  925. 			$queries[] = array("FUNCTION STATUS WHERE db='{$this->JOB['db']}'", 'Name', 'FU');
    926. 

  926. 			$queries[] = array('TRIGGERS', 'Trigger', 'TR');
    927. 

  927. 			if(V_MYSQL > 50100) $queries[] = array('EVENTS', 'Name', 'EV');
    928. 

  928. 		}
    929. 

  929. 		$todo = $header = array();
    930. 

  930. 		$tabs = $rows = 0;
    931. 

  931. 		$only_create = explode(' ', $this->CFG['only_create']);
    932. 

  932. 		foreach($queries AS $query){
    933. 

  933. 			$t = $query[2];
    934. 

  934. 			if($t == 'TA' && (!empty($object['TC']) || !empty($filter['TC']))) {}
    935. 

  935. 			elseif(empty($object[$t]) && empty($filter[$t])) continue;
    936. 

  936. 			$r = mysql_query('SHOW ' . $query[0]) or sxd_my_error();
    937. 

  937. 			if (!$r) continue;
    938. 

  938. 			$todo[$t] = array();
    939. 

  939. 			$header[$t] = array();
    940. 

  940. 			
    941. 

  941. 			while($item = mysql_fetch_assoc($r)){
    942. 

  942. 				$n = $item[$query[1]];
    943. 

  943. 				switch($t){
    944. 

  944. 					case 'TA':
    945. 

  945. 					case 'TC':
    946. 

  946. 						if(V_MYSQL > 40101 && is_null($item['Engine']) && preg_match('/^VIEW/i', $item['Comment'])) {
    947. 

  947. 							if(sxd_check($n, $object['VI'], $filter['VI'])){
    948. 

  948. 								$todo['VI'] = array();
    949. 

  949. 								$header['VI']= array();
    950. 

  950. 							}
    951. 

  951. 							continue;
    952. 

  952. 						}
    953. 

  953. 						elseif(sxd_check($n, $object['TA'], $filter['TA'])){
    954. 

  954. 							$engine = V_MYSQL > 40101 ? $item['Engine'] : $item['Type'];
    955. 

  955. 							$t = in_array($engine, $only_create) ? 'TC' : 'TA';
    956. 

  956. 						}
    957. 

  957. 						elseif(sxd_check($n, $object['TC'], $filter['TC'])) {
    958. 

  958. 							$t = 'TC';
    959. 

  959. 							$item['Rows'] = $item['Data_length'] = '';
    960. 

  960. 						}
    961. 

  961. 						else continue;
    962. 

  962. 						$todo['TA'][]   = array($t, $n, !empty($item['Collation']) ? $item['Collation'] : '', $item['Auto_increment'], $item['Rows'], $item['Data_length']);
    963. 

  963. 						$header['TA'][] = "{$n}`{$item['Rows']}`{$item['Data_length']}";
    964. 

  964. 						$tabs++;
    965. 

  965. 						$rows += $item['Rows'];
    966. 

  966. 					break;
    967. 

  967. 					default:
    968. 

  968. 						if(sxd_check($n, $object[$t], $filter[$t])) {
    969. 

  969. 							$todo[$t][] = array($t, $n, !empty($item['collation_connection']) ? $item['collation_connection'] : '');
    970. 

  970. 							$header[$t][] = $n;
    971. 

  971. 						}
    972. 

  972. 				}
    973. 

  973. 			}
    974. 

  974. 			
    975. 

  975. 		}
    976. 

  976. 		if (V_MYSQL > 50014 && (!empty($object['VI']) || !empty($filter['VI']))) {
    977. 

  977. 			// Бэкап обзоров, нужно отсортировать зависимые
    978. 

  978. 			$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();
    979. 

  979. 			$views = $dumped = $views_collation = array();
    980. 

  980. 			$re = "/`{$this->JOB['db']}`.`(.+?)`/";
    981. 

  981. 			while($item = mysql_fetch_assoc($r)){
    982. 

  982. 				preg_match_all($re, preg_replace("/^select.+? from/i", '', $item['view_definition']), $m);
    983. 

  983. 				$used = $m[1];	
    984. 

  984. 				$views_collation[$item['table_name']] = !empty($item['collation_connection']) ? $item['collation_connection'] : '';
    985. 

  985. 				$views[$item['table_name']] = $used;
    986. 

  986. 			}
    987. 

  987. 			
    988. 

  988. 			while (count($views) > 0) {
    989. 

  989. 				foreach($views AS $n => $view) {
    990. 

  990. 					$can_dumped = true;
    991. 

  991. 					foreach($view AS $k) {
    992. 

  992. 						if (isset($views[$k]) && !isset($dumped[$k])) $can_dumped = false;	
    993. 

  993. 					}
    994. 

  994. 					if ($can_dumped) {
    995. 

  995. 						if(sxd_check($n, $object['VI'], $filter['VI'])){
    996. 

  996. 							$todo['VI'][] = array('VI', $n, $views_collation[$n]);
    997. 

  997. 							$header['VI'][] = $n;
    998. 

  998. 						}
    999. 

  999. 						$dumped[$n] = 1;
    1000. 

  1000. 						unset($views[$n]);
    1001. 

  1001. 					}
    1002. 

  1002. 				}
    1003. 

  1003. 			}
    1004. 

  1004. 			unset($dumped);
    1005. 

  1005. 			unset($views);
    1006. 

  1006. 			unset($views_collation);
    1007. 

  1007. 		}
    1008. 

  1008. 		$this->JOB['file_tmp'] = $this->CFG['backup_path'] . $this->JOB['job'] . '.tmp';
    1009. 

  1009. 		$this->JOB['file_rtl'] = $this->CFG['backup_path'] . $this->JOB['job'] . '.rtl';
    1010. 

  1010. 		$this->JOB['file_log'] = $this->CFG['backup_path'] . $this->JOB['job'] . '.log';
    1011. 

  1011. 		$this->JOB['file_stp'] = $this->CFG['backup_path'] . $this->JOB['job'] . '.stp';
    1012. 

  1012. 		if(file_exists($this->JOB['file_stp'])) unlink($this->JOB['file_stp']);
    1013. 

  1013. 		$this->fh_tmp = $this->openFile($this->JOB['file_tmp'], 'w');
    1014. 

  1014. 		$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']);
    1015. 

  1015. 		$this->JOB['file_name'] = $this->CFG['backup_path'] . $this->JOB['file'];
    1016. 

  1016. 		$this->JOB['todo'] = $todo;
    1017. 

  1017. 		$this->saveJob($this->JOB['job'], $this->JOB);
    1018. 

  1018. 		$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";
    1019. 

  1019. 		foreach($header AS $t => $o){
    1020. 

  1020. 			if (!empty($o)) $fcache .= "#{$t} " . implode('|', $o) . "\n";	
    1021. 

  1021. 		}
    1022. 

  1022. 		$this->fh_rtl = fopen($this->JOB['file_rtl'], 'wb');
    1023. 

  1023. 		$this->fh_log = fopen($this->JOB['file_log'], 'wb');
    1024. 

  1024. 		$this->rtl = array(time(), time(), $rows, 0, '', '', '', 0, 0, 0, 0, TIMER, "\n");
    1025. 

  1025. 		$fcache .= "#EOH\n\n";
    1026. 

  1026. 		$this->write($fcache);
    1027. 

  1027. 		$this->addLog(sprintf($this->LNG['backup_begin'], $this->JOB['db']));
    1028. 

  1028. 		$this->runBackupJob();
    1029. 

  1029. 	}
    1030. 

  1030. 	function runBackupJob($continue = false){
    1031. 

  1031. 		if($continue){
    1032. 

  1032. 			$this->fh_tmp = $this->openFile($this->JOB['file_tmp'], 'a');
    1033. 

  1033. 			mysql_select_db($this->JOB['db']);
    1034. 

  1034. 		}
    1035. 

  1035. 		mysql_query("SET SQL_QUOTE_SHOW_CREATE = 1");
    1036. 

  1036. 		$types = array('VI' => 'View', 'PR' => 'Procedure', 'FU' => 'Function', 'TR' => 'Trigger', 'EV' => 'Event');
    1037. 

  1037. 		$fcache = '';
    1038. 

  1038. 		$writes = 0;
    1039. 

  1039. 		
    1040. 

  1040. 		if(V_MYSQL > 40101) mysql_query("SET SESSION character_set_results = '" . ($this->JOB['charset'] ? $this->JOB['charset'] : 'binary') ."'") or sxd_my_error();
    1041. 

  1041. 		$time_old = time();
    1042. 

  1042. 		$exit_time = $time_old + $this->CFG['time_web'] - 1;
    1043. 

  1043. 		$no_cache = V_MYSQL < 40101 ? 'SQL_NO_CACHE ' : '';
    1044. 

  1044. 		foreach($this->JOB['todo'] AS $t => $o){
    1045. 

  1045. 			if (empty($this->rtl[4])) $this->rtl[4] = $t;
    1046. 

  1046. 			elseif ($this->rtl[4] != $t) continue;
    1047. 

  1047. 			foreach($o AS $n){ 
    1048. 

  1048. 				if (empty($this->rtl[5])) {
    1049. 

  1049. 					$this->rtl[5] = $n[1];
    1050. 

  1050. 					$this->rtl[7] = 0;
    1051. 

  1051. 					$this->rtl[8] = !empty($n[4]) ? $n[4] : 0;
    1052. 

  1052. 				}
    1053. 

  1053. 				elseif ($this->rtl[5] != $n[1]) continue;
    1054. 

  1054. 				// Делаем бэкап
    1055. 

  1055. 				switch($n[0]){
    1056. 

  1056. 					case 'TC':
    1057. 

  1057. 					case 'TD': 				
    1058. 

  1058. 					case 'TA':
    1059. 

  1059. 						$from = '';
    1060. 

  1060. 						if ($n[0] == 'TC' || $this->rtl[7] == 0){
    1061. 

  1061. 							// Бэкап структуры таблицы
    1062. 

  1062. 							$r = mysql_query("SHOW CREATE TABLE `{$n[1]}`") or sxd_my_error();
    1063. 

  1063. 							$item = mysql_fetch_assoc($r);
    1064. 

  1064. 						    $fcache .= "#\tTC`{$n[1]}`{$n[2]}\t;\n{$item['Create Table']}\t;\n";
    1065. 

  1065. 						    $this->addLog(sprintf($this->LNG['backup_TC'], $n[1]));
    1066. 

  1066. 			            	$this->rtl[7] = 0; 
    1067. 

  1067. 						    if($n[0] == 'TC' || !$n[4]) break;
    1068. 

  1068. 						    // Бэкапим данные таблицы
    1069. 

  1069. 							$fcache .= "#\tTD`{$n[1]}`{$n[2]}\t;\nINSERT INTO `{$n[1]}` VALUES \n";
    1070. 

  1070. 						}
    1071. 

  1071. 						else {
    1072. 

  1072. 							$from = " LIMIT {$this->rtl[7]}, {$this->rtl[8]}";
    1073. 

  1073. 							$this->addLog(sprintf("{$this->LNG['backup_TC']} {$this->LNG['continue_from']}", $n[1], $this->rtl[7]));
    1074. 

  1074. 						}
    1075. 

  1075. 						// Определяем типы полей
    1076. 

  1076. 						$notNum = array();
    1077. 

  1077. 						$r = mysql_query("SHOW COLUMNS FROM `{$n[1]}`") or sxd_my_error();
    1078. 

  1078. 			            $fields = 0;
    1079. 

  1079. 			            while($col = mysql_fetch_array($r)) {
    1080. 

  1080. 			            	// TODO: проверить типы SET, ENUM и BIT
    1081. 

  1081.             				$notNum[$fields] = preg_match("/^(tinyint|smallint|mediumint|bigint|int|float|double|real|decimal|numeric|year)/", $col['Type']) ? 0 : 1; 
    1082. 

  1082.             				$fields++;
    1083. 

  1083. 			            }
    1084. 

  1084. 			            $time_old = time();
    1085. 

  1085. 			            $z = 0;
    1086. 

  1086. 			            // Достаем данные
    1087. 

  1087. 			            $r = mysql_unbuffered_query("SELECT {$no_cache}* FROM `{$n[1]}`{$from}");
    1088. 

  1088. 			            while($row = mysql_fetch_row($r)) {
    1089. 

  1089. 			            	 if (strlen($fcache) >= 61440) {
    1090. 

  1090. 			            	 	$z = 0;
    1091. 

  1091. 								if($time_old < time()) {
    1092. 

  1092. 									if(file_exists($this->JOB['file_stp'])){
    1093. 

  1093. 										$type = file_get_contents($this->JOB['file_stp']);
    1094. 

  1094. 										$this->rtl[9] = !empty($type) ? $type : 2;
    1095. 

  1095. 										$this->write($fcache);
    1096. 

  1096. 										if($type == 1) {
    1097. 

  1097. 											
    1098. 

  1098. 										}
    1099. 

  1099. 										unset($this->rtl);
    1100. 

  1100. 										exit;
    1101. 

  1101. 									}
    1102. 

  1102. 									$time_old = time();
    1103. 

  1103. 									if($time_old >= $exit_time){
    1104. 

  1104. 										$this->rtl[9] = 3;
    1105. 

  1105. 										$this->write($fcache);
    1106. 

  1106. 										unset($this->rtl);
    1107. 

  1107. 										exit;
    1108. 

  1108. 									}
    1109. 

  1109. 									clearstatcache(); 
    1110. 

  1110. 								}
    1111. 

  1111. 								$this->write($fcache); 
    1112. 

  1112. 							}
    1113. 

  1113. 							for($k = 0; $k < $fields; $k++){
    1114. 

  1114. 								if(!isset($row[$k])) {$row[$k] = '\N';}
    1115. 

  1115. 								elseif($notNum[$k]) {$row[$k] =  '\'' . mysql_real_escape_string($row[$k]) . '\'';} // TODO: Потестить скорость эскэйпинга строк
    1116. 

  1116. 							}
    1117. 

  1117. 							$fcache .= '(' . implode(',', $row) . "),\n";
    1118. 

  1118. 							$this->rtl[7]++;  
    1119. 

  1119. 							$this->rtl[10]++;
    1120. 

  1120. 						}
    1121. 

  1121. 						unset($row);
    1122. 

  1122. 						mysql_free_result($r);
    1123. 

  1123. 						$fcache = substr_replace($fcache, "\t;\n",  -2, 2);
    1124. 

  1124. 					break;
    1125. 

  1125. 

  1126. 					default:
    1127. 

  1127. 						if(V_MYSQL < 50121 && $n[0] == 'TR'){
    1128. 

  1128. 							// SHOW CREATE TRIGGER отсутствует до MySQL 5.1.21
    1129. 

  1129. 							$r = mysql_query("SELECT * FROM `INFORMATION_SCHEMA`.`TRIGGERS` WHERE `TRIGGER_SCHEMA` = '{$this->JOB['db']}' AND `TRIGGER_NAME` = '{$n[1]}'") or sxd_my_error();
    1130. 

  1130. 							$item = mysql_fetch_assoc($r);
    1131. 

  1131. 							$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";
    1132. 

  1132. 						}
    1133. 

  1133. 						else {
    1134. 

  1134. 							$this->addLog(sprintf($this->LNG['backup_' . $n[0]], $n[1]));
    1135. 

  1135. 							$r = mysql_query("SHOW CREATE {$types[$n[0]]} `{$n[1]}`") or sxd_my_error();
    1136. 

  1136. 							$item = mysql_fetch_assoc($r);
    1137. 

  1137. 							$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";
    1138. 

  1138. 						}
    1139. 

  1139. 				}
    1140. 

  1140. 				
    1141. 

  1141. 				$this->rtl[5] = '';
    1142. 

  1142. 			}
    1143. 

  1143. 			$this->rtl[4] = '';
    1144. 

  1144. 		}
    1145. 

  1145. 		$this->rtl[4] = 'EOJ';
    1146. 

  1146. 		$this->rtl[5] = round(array_sum(explode(' ', microtime())) - $this->rtl[11], 4);
    1147. 

  1147. 		$this->rtl[6] = '';
    1148. 

  1148. 		$this->rtl[7] = 0;
    1149. 

  1149. 		$this->rtl[8] = 0;
    1150. 

  1150. 		$this->write($fcache);
    1151. 

  1151. 		fclose($this->fh_tmp);
    1152. 

  1152. 		rename($this->JOB['file_tmp'], $this->JOB['file_name']);
    1153. 

  1153. 		$this->addLog(sprintf($this->LNG['backup_end'], $this->JOB['db']));
    1154. 

  1154. 		
    1155. 

  1155. 		if ($this->JOB['del_time'] || $this->JOB['del_count']) {
    1156. 

  1156.             $this->addLog($this->LNG['autodelete']);
    1157. 

  1157.             $deldate = '';
    1158. 

  1158.             if (!empty($this->JOB['del_time'])){ // Удаление по дням
    1159. 

  1159.                 $deldate = date("Y-m-d_H-i-s", time() - intval($this->JOB['del_time']) * 86400);
    1160. 

  1160.             }
    1161. 

  1161.             $deleted = false;
    1162. 

  1162.             if ($dh = opendir($this->CFG['backup_path'])) {
    1163. 

  1163.                 $files = array();
    1164. 

  1164.                 $name = isset($this->JOB['title']) ? $this->JOB['job'] : $this->JOB['db'];
    1165. 

  1165.                 while (false !== ($file = readdir($dh))) { 
    1166. 

  1166.                     if (preg_match("/^{$name}_(\d{4}-\d{2}-\d{2}_\d{2}-\d{2}-\d{2})\.sql/", $file, $m)) { 
    1167. 

  1167.                         if ($deldate && $m[1] < $deldate) {
    1168. 

  1168.                             if(unlink($this->CFG['backup_path'] . $file)) $this->addLog(sprintf($this->LNG['del_by_date'], $file));
    1169. 

  1169.                             else  $this->addLog(sprintf($this->LNG['del_fail'], $file));
    1170. 

  1170.                             $deleted = true;
    1171. 

  1171.                         }
    1172. 

  1172.                         else {$files[$m[1]] = $file;}
    1173. 

  1173.                     }
    1174. 

  1174.                 }
    1175. 

  1175.                 closedir($dh);
    1176. 

  1176.                 // Сортируем файлы по дате и удаляем самые старые
    1177. 

  1177.                 if (!empty($this->JOB['del_count'])){
    1178. 

  1178.                     ksort($files);
    1179. 

  1179.                     $file_to_delete = count($files) - $this->JOB['del_count'];
    1180. 

  1180.                     foreach ($files AS $file){
    1181. 

  1181.                         if ($file_to_delete-- > 0){ 
    1182. 

  1182.                         	if(unlink($this->CFG['backup_path'] . $file)) $this->addLog(sprintf($this->LNG['del_by_count'], $file));
    1183. 

  1183.                             else  $this->addLog(sprintf($this->LNG['del_fail'], $file));
    1184. 

  1184.                             $deleted = true;
    1185. 

  1185.                         }
    1186. 

  1186.                     }
    1187. 

  1187.                 }
    1188. 

  1188.             }
    1189. 

  1189.             if(!$deleted) $this->addLog($this->LNG['del_nothing']);
    1190. 

  1190. 		}
    1191. 

  1191. 		fclose($this->fh_log);
    1192. 

  1192. 		fclose($this->fh_rtl);
    1193. 

  1193. 	}
    1194. 

  1194. 	function setNames($collation){
    1195. 

  1195. 		if(empty($collation)) return;
    1196. 

  1196. 		if($this->rtl[6] != $collation) {
    1197. 

  1197. 			mysql_query('SET NAMES \'' . preg_replace('/^(\w+?)_/', '\\1\' COLLATE \'\\1_', $collation) . '\'') or sxd_my_error();
    1198. 

  1198. 			/*if(!$this->rtl[7])*/ $this->addLog(sprintf($this->LNG['set_names'], $collation));
    1199. 

  1199. 			$this->rtl[6] = $collation;	
    1200. 

  1200. 		}
    1201. 

  1201. 	}
    1202. 

  1202. 	function write(&$str){
    1203. 

  1203. 		fseek($this->fh_rtl, 0);
    1204. 

  1204. 		$this->rtl[1] = time();
    1205. 

  1205. 		$this->rtl[3] += fwrite($this->fh_tmp, $str);
    1206. 

  1206. 		fwrite($this->fh_rtl, implode("\t", $this->rtl));
    1207. 

  1207. 		$str = '';
    1208. 

  1208. 	}
    1209. 

  1209. 	function addLog($str, $type = 1){
    1210. 

  1210. 		fwrite($this->fh_log, date('Y.m.d H:i:s') . "\t{$type}\t{$str}\n");
    1211. 

  1211. 	}
    1212. 

  1212. 	function getDBList(){
    1213. 

  1213. 		$dbs = $items = array();
    1214. 

  1214.         if (!V_MYSQL) return $dbs; 
    1215. 

  1215.         $qq = (V_MYSQL < 50000) ? '' : '\'';
    1216. 

  1216. 		if ($this->CFG['my_db']) {
    1217. 

  1217. 			$tmp = explode(',', $this->CFG['my_db']);
    1218. 

  1218. 			foreach($tmp AS $d){
    1219. 

  1219. 				$d = trim($d);
    1220. 

  1220. 				$items[] = $qq . sxd_esc($d, false) . $qq;
    1221. 

  1221. 				$dbs[$d] = "{$d} (0)";
    1222. 

  1222. 			}
    1223. 

  1223. 		}
    1224. 

  1224. 		else{
    1225. 

  1225. 			$result = mysql_query("SHOW DATABASES") or sxd_my_error();
    1226. 

  1226.     		while($item = mysql_fetch_row($result)){
    1227. 

  1227.     			if($item[0] == 'information_schema' || $item[0] == 'mysql' || $item[0] == 'performance_schema') continue;
    1228. 

  1228.     			$items[] = $qq . sxd_esc($item[0], false) . $qq;
    1229. 

  1229.     			$dbs[$item[0]] = "{$item[0]} (0)";
    1230. 

  1230.     		}	
    1231. 

  1231. 		}
    1232. 

  1232. 		if(V_MYSQL < 50000){
    1233. 

  1233. 			foreach($items AS $item){
    1234. 

  1234.     			$tables = mysql_query("SHOW TABLES FROM `{$item}`") or sxd_my_error();
    1235. 

  1235.     			if ($tables) {
    1236. 

  1236.     	  			$tabs = mysql_num_rows($tables);
    1237. 

  1237.     	  			$dbs[$item] = "{$item} ({$tabs})";
    1238. 

  1238.     	  		}
    1239. 

  1239. 			}
    1240. 

  1240. 		}
    1241. 

  1241. 		else {
    1242. 

  1242. 			$where = (count($items) > 0) ? 'WHERE `table_schema` IN (' . implode(',', $items) . ')' : '';
    1243. 

  1243. 			$result = mysql_query("SELECT `table_schema`, COUNT(*) FROM `information_schema`.`tables` {$where} GROUP BY `table_schema`") or sxd_my_error();
    1244. 

  1244. 			while($item = mysql_fetch_row($result)){
    1245. 

  1245.     			if($item[0] == 'information_schema' || $item[0] == 'mysql' || $item[0] == 'performance_schema') continue;
    1246. 

  1246.     			$dbs[$item[0]] = "{$item[0]} ({$item[1]})";
    1247. 

  1247.     		}
    1248. 

  1248. 		}
    1249. 

  1249. 	    return $dbs;
    1250. 

  1250. 	}
    1251. 

  1251. 	function getCharsetList(){
    1252. 

  1252. 		$tmp = array(0 => '- auto -');
    1253. 

  1253. 		if (!V_MYSQL) return $tmp; 
    1254. 

  1254. 		if(V_MYSQL > 40101) {
    1255. 

  1255. 			$def_charsets = '';
    1256. 

  1256. 			if(!empty($this->CFG['charsets'])){
    1257. 

  1257. 				$def_charsets = preg_match_all("/([\w*?]+)\s*/", $this->CFG['charsets'], $m, PREG_PATTERN_ORDER) ? '/^(' . str_replace(array('?','*'), array('.','\w+?'), implode('|', $m[1])) . ')$/i' : '';
    1258. 

  1258. 			}
    1259. 

  1259.     		$r = mysql_query("SHOW CHARACTER SET") or sxd_my_error(); 
    1260. 

  1260.     		if ($r) {
    1261. 

  1261.     			while($item = mysql_fetch_assoc($r)){
    1262. 

  1262.     	  			if (empty($def_charsets) || preg_match($def_charsets, $item['Charset'])) $tmp[$item['Charset']] = "{$item['Charset']}"; // ({$item['Description']})
    1263. 

  1263.     			}
    1264. 

  1264. 			}
    1265. 

  1265. 		}
    1266. 

  1266. 	    return $tmp;
    1267. 

  1267. 	}
    1268. 

  1268. 	function getCollationList(){
    1269. 

  1269. 		$tmp = array(); 
    1270. 

  1270. 		if (!V_MYSQL) return $tmp; 
    1271. 

  1271. 		if(V_MYSQL > 40101) {
    1272. 

  1272. 			$def_charsets = '';
    1273. 

  1273. 			if(!empty($this->CFG['charsets'])){
    1274. 

  1274. 				$def_charsets = preg_match_all("/([\w*?]+)\s*/", $this->CFG['charsets'], $m, PREG_PATTERN_ORDER) ? '/^(' . str_replace(array('?','*'), array('.','\w+?'), implode('|', $m[1])) . ')$/i' : '';
    1275. 

  1275. 			}
    1276. 

  1276.     		$r = mysql_query("SHOW COLLATION") or sxd_my_error(); 
    1277. 

  1277.     		if ($r) {
    1278. 

  1278.     			while($item = mysql_fetch_assoc($r)){
    1279. 

  1279.     	  			if (empty($def_charsets) || preg_match($def_charsets, $item['Charset'])) $tmp[$item['Charset']][$item['Collation']] = $item['Default'] == 'Yes' ? 1 : 0; 
    1280. 

  1280.     			}
    1281. 

  1281. 			}
    1282. 

  1282. 		}
    1283. 

  1283. 	    return $tmp;
    1284. 

  1284. 	}
    1285. 

  1285. 	function getObjects($tree, $db_name){
    1286. 

  1286. 		mysql_select_db($db_name);
    1287. 

  1287. 		// Достаем таблицы
    1288. 

  1288. 		$r = mysql_query('SHOW TABLE STATUS');
    1289. 

  1289. 		$tab_prefix_last = $tab_prefix = '*';
    1290. 

  1290. 		$objects = array('TA' => array(), 'VI' => array(), 'PR' => array(), 'FU' => array(), 'TR' => array(), 'EV' => array());
    1291. 

  1291. 		if($r){
    1292. 

  1292. 			while($item = mysql_fetch_assoc($r)){
    1293. 

  1293. 				if(V_MYSQL > 40101 && is_null($item['Engine']) && preg_match('/^VIEW/i', $item['Comment'])) {
    1294. 

  1294. 					$objects['VI'][]= $item['Name'];
    1295. 

  1295. 				}
    1296. 

  1296. 				else{
    1297. 

  1297. 					$objects['TA'][] = array($item['Name'], $item['Rows'], $item['Data_length']);
    1298. 

  1298. 				} 
    1299. 

  1299. 			}
    1300. 

  1300. 			
    1301. 

  1301. 			if (V_MYSQL > 50014 && $tree != 'services') {
    1302. 

  1302. 				$shows = array(
    1303. 

  1303. 					"PROCEDURE STATUS WHERE db='{$db_name}'", 
    1304. 

  1304. 					"FUNCTION STATUS WHERE db='{$db_name}'",
    1305. 

  1305. 					'TRIGGERS'
    1306. 

  1306. 				);
    1307. 

  1307. 				if(V_MYSQL > 50100) $shows[] = "EVENTS WHERE db='{$db_name}'";
    1308. 

  1308. 				// TODO: Поправить проверку событий и триггеров
    1309. 

  1309. 				for($i = 0, $l = count($shows); $i < $l; $i++){
    1310. 

  1310. 					$r = mysql_query('SHOW ' . $shows[$i]);
    1311. 

  1311. 					if($r && mysql_num_rows($r) > 0) {
    1312. 

  1312. 						$col_name = $shows[$i] == 'TRIGGERS' ? 'Trigger' : 'Name';
    1313. 

  1313. 						$type = substr($shows[$i], 0, 2);
    1314. 

  1314. 						while($item = mysql_fetch_assoc($r)){
    1315. 

  1315. 							$objects[$type][] = $item[$col_name];	
    1316. 

  1316. 						}
    1317. 

  1317. 					}
    1318. 

  1318. 				}
    1319. 

  1319. 			}
    1320. 

  1320. 			else {
    1321. 

  1321. 				$objects['VI'] = array();
    1322. 

  1322. 			}
    1323. 

  1323. 		}
    1324. 

  1324. 		return $this->formatTree($tree, $objects);
    1325. 

  1325. 	}
    1326. 

  1326. 	function getFileObjects($tree, $name, $formatTree = true){
    1327. 

  1327. 		// Достаем таблицы
    1328. 

  1328. 		$objects = array('TA' => array(), 'VI' => array(), 'PR' => array(), 'FU' => array(), 'TR' => array(), 'EV' => array());
    1329. 

  1329. 		if(!preg_match('/\.sql(\.(gz|bz2))?$/i', $name, $m)) return '';
    1330. 

  1330. 		$name = $this->CFG['backup_path'] . $name;
    1331. 

  1331. 		if(!is_readable($name)) {return "sxd.tree.{$tree}.error(sxd.lng('err_fopen'))";}
    1332. 

  1332. 		$fp   = $this->openFile($name, 'r');
    1333. 

  1333. 		$temp = fread($fp, 60000);
    1334. 

  1334. 		// Формат файла Sypex Dumper 2 - SXD20
    1335. 

  1335. 		//if(!preg_match('/^(#SXD20\|.+?)\n#EOH\n/s', $temp, $m)) return "sxd.tree.{$tree}.error(sxd.lng('err_sxd2'));z('restore_savejob').disabled = z('restore_runjob').disabled = true;";
    1336. 

  1336. 		if(preg_match('/^(#SXD20\|.+?)\n#EOH\n/s', $temp, $m)){
    1337. 

  1337. 			$head = explode("\n", $m[1]);
    1338. 

  1338. 			$h = explode('|', $head[0]);
    1339. 

  1339. 			for($i = 1, $c = count($head); $i < $c; $i++){
    1340. 

  1340. 				$objects[substr($head[$i], 1,2)] = explode('|', substr($head[$i], 4));
    1341. 

  1341. 			}
    1342. 

  1342. 			for($i = 0, $l = count($objects['TA']); $i < $l; $i++){
    1343. 

  1343. 				$objects['TA'][$i] = explode('`', $objects['TA'][$i]);
    1344. 

  1344. 			}
    1345. 

  1345. 		}
    1346. 

  1346. 		else {
    1347. 

  1347. 			$h[9] = '';
    1348. 

  1348. 		}
    1349. 

  1349. 		return $formatTree ? $this->formatTree($tree, $objects) .  "sxd.comment.restore.value = '{$h[9]}';z('restore_savejob').disabled = z('restore_runjob').disabled = false;" : $objects;
    1350. 

  1350. 	}
    1351. 

  1351. 	function formatTree($tree, &$objects){
    1352. 

  1352. 		$obj = '';
    1353. 

  1353. 		$pid = $row = 1;
    1354. 

  1354. 		$info = array(
    1355. 

  1355. 			'TA' => array($this->LNG['obj_tables'], 1),
    1356. 

  1356. 			'VI' => array($this->LNG['obj_views'], 3), 
    1357. 

  1357. 			'PR' => array($this->LNG['obj_procs'], 5), 
    1358. 

  1358. 			'FU' => array($this->LNG['obj_funcs'], 7), 
    1359. 

  1359. 			'TR' => array($this->LNG['obj_trigs'], 9), 
    1360. 

  1360. 			'EV' => array($this->LNG['obj_events'], 11)
    1361. 

  1361. 		);
    1362. 

  1362. 		// Находим таблицы с префиксами
    1363. 

  1363. 		$tab_prefix_last = $tab_prefix = '*';
    1364. 

  1364. 		for($i = 0, $l = count($objects['TA']); $i < $l; $i++){
    1365. 

  1365. 			$t = $objects['TA'][$i];
    1366. 

  1366. 			$tab_prefix = preg_match("/^([a-z0-9]+_)/", $t[0], $m) ? $m[1] : '*';
    1367. 

  1367. 			if ($tab_prefix != $tab_prefix_last) {
    1368. 

  1368. 				if ($tab_prefix != '*') $objects['TA']['*'][] = $tab_prefix;
    1369. 

  1369. 				$tab_prefix_last = $tab_prefix;
    1370. 

  1370. 			}
    1371. 

  1371. 			$objects['TA'][$tab_prefix][] = $t;
    1372. 

  1372. 			unset($objects['TA'][$i]);
    1373. 

  1373. 		}
    1374. 

  1374. 		foreach($objects AS $type => $o){
    1375. 

  1375. 			if(!count($o)) continue;
    1376. 

  1376. 			if($type == 'TA') {
    1377. 

  1377. 				$open_childs = count($o['*']) > 1 ? 0 : 1;
    1378. 

  1378. 				$obj .= "[{$row},0," . sxd_esc($info[$type][0]) . ",1,1,1],";
    1379. 

  1379. 				$row++;
    1380. 

  1380. 				foreach($o['*'] AS $value){
    1381. 

  1381. 					if(is_string($value)){
    1382. 

  1382. 						if(count($o[$value]) > 1)	{
    1383. 

  1383. 							$obj .= "[{$row},1,'{$value}*',1,1,{$open_childs}],";	
    1384. 

  1384. 							$pid = $row++; 
    1385. 

  1385. 							for($i = 0, $l = count($o[$value]); $i < $l; $i++){
    1386. 

  1386. 								$checked = ($o[$value][$i][1] == '' && $o[$value][$i][2] == '') ? 2 : 1;
    1387. 

  1387. 								$obj .= "[{$row},{$pid}," . sxd_esc($o[$value][$i][0]) . ",2,{$checked},{$o[$value][$i][2]}],";
    1388. 

  1388. 								$row++;
    1389. 

  1389. 							}
    1390. 

  1390. 						}
    1391. 

  1391. 						else {
    1392. 

  1392. 							$value = $o[$value][0];	
    1393. 

  1393. 						}
    1394. 

  1394. 					}
    1395. 

  1395. 					//$pid = 1;
    1396. 

  1396. 					if (is_array($value)){
    1397. 

  1397. 						$checked = ($value[1] == '' && $value[2] == '') ? 2 : 1;
    1398. 

  1398. 						$obj .= "[{$row},1,'{$value[0]}',2,{$checked},{$value[2]}],";
    1399. 

  1399. 						$row++;	
    1400. 

  1400. 					}
    1401. 

  1401. 				}
    1402. 

  1402. 			}
    1403. 

  1403. 			else {
    1404. 

  1404. 				$obj .= "[{$row},0," . sxd_esc($info[$type][0]) . ",{$info[$type][1]},1,1],";
    1405. 

  1405. 				$pid = $row++;
    1406. 

  1406. 				$info[$type][1]++;
    1407. 

  1407. 				for($i = 0, $l = count($o); $i < $l; $i++){
    1408. 

  1408. 					$o[$i] = sxd_esc($o[$i], false);
    1409. 

  1409. 					$obj .= "[{$row},{$pid},'{$o[$i]}',{$info[$type][1]},1,0],";
    1410. 

  1410. 					$row++;	
    1411. 

  1411. 				}
    1412. 

  1412. 			} 
    1413. 

  1413. 		}
    1414. 

  1414. 		$add = '';
    1415. 

  1415. 		if($tree == 'restore') $add = "z('autoinc').disabled = z('restore_type').disabled = " . ($obj ? 'false' : 'true') . ";";
    1416. 

  1416. 		return ($obj ? 'sxd.tree.' . $tree . '.drawTree([' . substr_replace($obj, ']',  -1) . ");" : "sxd.tree.{$tree}.error(sxd.lng('err_sxd2'));") . $add;	
    1417. 

  1417. 	}
    1418. 

  1418. 	function getFileList(){
    1419. 

  1419. 		$files = array();
    1420. 

  1420. 		if (is_dir($this->CFG['backup_path']) && false !== ($handle = opendir($this->CFG['backup_path']))) {
    1421. 

  1421.             while (false !== ($file = readdir($handle))) {
    1422. 

  1422.                 if (preg_match("/^.+?\.sql(\.(gz|bz2))?$/", $file)) {
    1423. 

  1423.                     $files[$file] = $file;
    1424. 

  1424.                 }
    1425. 

  1425.             }
    1426. 

  1426.             closedir($handle);
    1427. 

  1427.         }
    1428. 

  1428.         ksort($files);
    1429. 

  1429. 		return $files;
    1430. 

  1430. 	}
    1431. 

  1431. 	function getSavedJobs(){
    1432. 

  1432. 		$sj = array('sj_backup' => array(), 'sj_restore' => array(),);
    1433. 

  1433. 		if (is_dir($this->CFG['backup_path']) && false !== ($handle = opendir($this->CFG['backup_path']))) {
    1434. 

  1434.             while (false !== ($file = readdir($handle))) {
    1435. 

  1435.                 if (preg_match("/^sj_(.+?)\.job.php$/", $file)) {
    1436. 

  1436.                 	include($this->CFG['backup_path'] . $file);
    1437. 

  1437.                     $sj['sj_' . $JOB['type']][$JOB['job']] = "<b>{$JOB['job']}</b><br><i>{$JOB['title']}&nbsp;</i>";
    1438. 

  1438.                 }
    1439. 

  1439.             }
    1440. 

  1440.             closedir($handle);
    1441. 

  1441.         }
    1442. 

  1442.         if(count($sj['sj_backup']) > 0){
    1443. 

  1443.         	ksort($sj['sj_backup']);	
    1444. 

  1444. 		}
    1445. 

  1445.         else {
    1446. 

  1446.         	$sj['sj_backup'] = array(0 => '<b>No Saved Jobs</b><br>' . $this->LNG['no_saved']);	
    1447. 

  1447. 		}
    1448. 

  1448. 		if(count($sj['sj_restore']) > 0){
    1449. 

  1449.         	ksort($sj['sj_restore']);	
    1450. 

  1450. 		}
    1451. 

  1451.         else {
    1452. 

  1452.         	$sj['sj_restore'] = array(0 => '<b>No Saved Jobs</b><br>' . $this->LNG['no_saved']);	
    1453. 

  1453. 		}
    1454. 

  1454. 		return "sxd.clearOpt('sj_backup');sxd.clearOpt('sj_restore');sxd.addOpt(" . sxd_php2json($sj) . ");";
    1455. 

  1455. 	}
    1456. 

  1456. 	function getFileListExtended(){
    1457. 

  1457. 		$files = array();
    1458. 

  1458. 		if (is_dir($this->CFG['backup_path']) && false !== ($handle = opendir($this->CFG['backup_path']))) {
    1459. 

  1459.             while (false !== ($file = readdir($handle))) {
    1460. 

  1460.                 if (preg_match("/^.+?\.sql(\.(gz|bz2))?$/", $file, $m)) {
    1461. 

  1461.                     $fp   = $this->openFile($this->CFG['backup_path'] . $file, 'r');
    1462. 

  1462.                     $ext  = !empty($m[2]) ? $m[2] : 'sql';
    1463. 

  1463.                     $temp = fgets($fp);
    1464. 

  1464.                     if(preg_match('/^(#SXD20\|.+?)\n/s', $temp, $m)){
    1465. 

  1465.                     	$h = explode('|', $m[1]);
    1466. 

  1466.                     	$files[] = array($h[5], substr($h[4], 0, -3), $ext, $h[7], number_format($h[8], 0, '', ' '), filesize($this->CFG['backup_path'] . $file), $h[9], $file);	
    1467. 

  1467. 					}
    1468. 

  1468. 					elseif(preg_match('/^(#SKD101\|.+?)\n/s', $temp, $m)){
    1469. 

  1469.                     	$h = explode('|', $m[1]);
    1470. 

  1470.                     	$files[] = array($h[1], substr($h[3], 0, -3), $ext, $h[2], number_format($h[4], 0, '', ' '), filesize($this->CFG['backup_path'] . $file), 'SXD 1.0.x', $file);	
    1471. 

  1471. 					}
    1472. 

  1472. 					else {
    1473. 

  1473. 						$files[] = array($file, '-', $ext, '-', '-', filesize($this->CFG['backup_path'] . $file), '', $file);
    1474. 

  1474. 					}
    1475. 

  1475.                 }
    1476. 

  1476.             }
    1477. 

  1477.             closedir($handle);
    1478. 

  1478.         }
    1479. 

  1479.         function s($a, $b){
    1480. 

  1480. 		    return strcmp($b[1], $a[1]);
    1481. 

  1481. 		}
    1482. 

  1482.         usort($files, 's');
    1483. 

  1483. 		return 'sxd.files.clear();sxd.files.add(' . sxd_php2json($files) . ');';
    1484. 

  1484. 	}
    1485. 

  1485. 	function saveJob($job, $config){
    1486. 

  1486. 		$this->saveToFile($this->CFG['backup_path'] . $job . '.job.php', "<?php\n\$JOB = " . var_export($config, true) . ";\n" . "?>");
    1487. 

  1487. 	}
    1488. 

  1488. 	function openFile($name, $mode){
    1489. 

  1489. 		if($mode == 'r') {
    1490. 

  1490. 			if(preg_match('/\.(sql|sql\.bz2|sql\.gz)$/i', $name, $m)) $this->JOB['file_ext'] = strtolower($m[1]);
    1491. 

  1491. 		}
    1492. 

  1492. 		else{
    1493. 

  1493. 			switch($this->JOB['zip']) {
    1494. 

  1494. 				case 0 : $this->JOB['file_ext'] = 'sql'; break;
    1495. 

  1495. 				case 10: $this->JOB['file_ext'] = 'sql.bz2'; break;
    1496. 

  1496. 				default: $this->JOB['file_ext'] = 'sql.gz'; break; 
    1497. 

  1497. 			}
    1498. 

  1498. 		}
    1499. 

  1499. 		switch ($this->JOB['file_ext']){
    1500. 

  1500. 			case 'sql':
    1501. 

  1501. 				return fopen($name, "{$mode}b");
    1502. 

  1502. 				break;
    1503. 

  1503. 			case 'sql.bz2':
    1504. 

  1504. 				return bzopen($name, $mode);
    1505. 

  1505. 				break;
    1506. 

  1506. 			case 'sql.gz':
    1507. 

  1507. 				return gzopen($name, $mode . ($mode == 'w' ? $this->JOB['zip'] : ''));
    1508. 

  1508. 				break;
    1509. 

  1509. 			default: return false;
    1510. 

  1510. 		}
    1511. 

  1511. 	}
    1512. 

  1512. }
    1513. 

  1513. function sxd_read_sql($f, &$seek, $ei, $delimiter = "\t;", $eol = "\n"){
    1514. 

  1514. 	static $l = '';
    1515. 

  1515. 	static $r = 0;
    1516. 

  1516. 	$fs = ftell($f);
    1517. 

  1517. 	$delim_len = strlen($delimiter . $eol);
    1518. 

  1518. 	while($r || $s = fread($f, 61440)){
    1519. 

  1519. 		if(!$r) $l .= $s;
    1520. 

  1520. 		$pos = strpos($l, $delimiter . $eol);
    1521. 

  1521. 		if ($pos !== false) {
    1522. 

  1522. 			// Есть окончание запроса
    1523. 

  1523. 			$q = substr($l, 0, $pos);
    1524. 

  1524. 			$l = substr($l, $pos+$delim_len);
    1525. 

  1525. 			$r = 1;
    1526. 

  1526. 			$seek = strlen($l);
    1527. 

  1527. 			return $q;
    1528. 

  1528. 		}
    1529. 

  1529. 		if($ei) {
    1530. 

  1530. 			$pos = strrpos($l, $eol);
    1531. 

  1531. 			if($pos > 0 && $l{$pos-1} === ',') {
    1532. 

  1532. 				// Окончание не найдено
    1533. 

  1533. 				$q = substr($l, 0, $pos-1);
    1534. 

  1534. 				$l = substr($l, $pos+ strlen($eol));
    1535. 

  1535. 				$seek = strlen($l);
    1536. 

  1536. 				$r = 0;
    1537. 

  1537. 				return $q;
    1538. 

  1538. 			}
    1539. 

  1539. 		}
    1540. 

  1540. 		$r = 0;	
    1541. 

  1541. 	}
    1542. 

  1542. 	if (!empty($l)) {
    1543. 

  1543. 		return $l;
    1544. 

  1544. 	}
    1545. 

  1545. 	return false;
    1546. 

  1546. }
    1547. 

  1547. function sxd_check($n, $obj, $filt){
    1548. 

  1548. 	return isset($obj[$n]) || ($filt && preg_match($filt, $n));
    1549. 

  1549. }
    1550. 

  1550. function sxd_php2json($obj){
    1551. 

  1551. 	if(count($obj) == 0) return '[]';
    1552. 

  1552. 	$is_obj = isset($obj[0]) && isset($obj[count($obj) - 1]) ? false : true;
    1553. 

  1553. 	$str = $is_obj ? '{' : '[';
    1554. 

  1554.     foreach ($obj AS $key  => $value) {
    1555. 

  1555.     	$str .= $is_obj ? "'" . addcslashes($key, "\n\r\t'\\/") . "'" . ':' : ''; 
    1556. 

  1556.         if     (is_array($value))   $str .= sxd_php2json($value);
    1557. 

  1557.         elseif (is_null($value))    $str .= 'null';
    1558. 

  1558.         elseif (is_bool($value))    $str .= $value ? 'true' : 'false';
    1559. 

  1559. 		elseif (is_numeric($value)) $str .= $value;
    1560. 

  1560. 		else                        $str .= "'" . addcslashes($value, "\n\r\t'\\/") . "'";
    1561. 

  1561. 		$str .= ',';
    1562. 

  1562.     }
    1563. 

  1563. 	return  substr_replace($str, $is_obj ? '}' : ']', -1);
    1564. 

  1564. }
    1565. 

  1565. function sxd_ver2int($ver){
    1566. 

  1566. 	return preg_match("/^(\d+)\.(\d+)\.(\d+)/", $ver, $m) ? sprintf("%d%02d%02d", $m[1], $m[2], $m[3]) : 0;
    1567. 

  1567. }
    1568. 

  1568. function sxd_error_handler($errno, $errmsg, $filename, $linenum, $vars){
    1569. 

  1569.     global $SXD;
    1570. 

  1570.     if($SXD->try) return;
    1571. 

  1571. 	if($errno == 8192) return;
    1572. 

  1572.     if(strpos($errmsg, 'timezone settings')) return;
    1573. 

  1573.     $errortype = array(1 => 'Error', 2 => 'Warning', 4 => 'Parsing Error', 8 => 'Notice', 16 => 'Core Error', 32 => 'Core Warning', 64 => 'Compile Error',
    1574. 

  1574. 					   128 => 'Compile Warning', 256 => 'MySQL Error', 512 => 'Warning', 1024 => 'Notice',
    1575. 

  1575. 						2048 => 'Strict', 8192 => 'Deprecated', 16384 => 'Deprecated');
    1576. 

  1576. 	$str = sxd_esc("{$errortype[$errno]}: {$errmsg} ({$filename}:{$linenum})", false);
    1577. 

  1577. 	if(SXD_DEBUG) error_log("[index.php]\n{$str}\n", 3, "backup/error.log");
    1578. 

  1578. 	
    1579. 

  1579.     if($errno == 8 || $errno == 1024) {
    1580. 

  1580.     	if (!$SXD->fh_log && !$SXD->fh_rtl) echo isset($_POST['ajax']) ? "alert('" . ($str) . "');" : $str;
    1581. 

  1581.     	else {
    1582. 

  1582.     		fwrite($SXD->fh_log, date('Y.m.d H:i:s') . "\t3\t{$str}\n");
    1583. 

  1583. 		}
    1584. 

  1584. 	}
    1585. 

  1585.     elseif($errno < 1024) {
    1586. 

  1586.     	$SXD->error = true;
    1587. 

  1587.     	if (!$SXD->fh_log && !$SXD->fh_rtl) echo isset($_POST['ajax']) ? "alert('" . ($str) . "');" : $str;
    1588. 

  1588.     	else {
    1589. 

  1589.     		$SXD->rtl[1] = time();
    1590. 

  1590.     		$SXD->rtl[9] = 5;
    1591. 

  1591.     		fseek($SXD->fh_rtl, 0);
    1592. 

  1592. 			fwrite($SXD->fh_rtl, implode("\t", $SXD->rtl));
    1593. 

  1593.     		fwrite($SXD->fh_log, date('Y.m.d H:i:s') . "\t4\t{$str}\n");
    1594. 

  1594.     		unset($SXD->rtl);
    1595. 

  1595. 		}
    1596. 

  1596. 		
    1597. 

  1597.     	die;
    1598. 

  1598. 	}
    1599. 

  1599. }
    1600. 

  1600. function sxd_esc($str, $quoted = true){
    1601. 

  1601. 	return $quoted ? "'" . addcslashes($str, "\\\0\n\r\t\'") . "'" : addcslashes($str, "\\\0\n\r\t\'");
    1602. 

  1602. }
    1603. 

  1603. function sxd_my_error(){
    1604. 

  1604. 	trigger_error(mysql_error(), E_USER_ERROR);	
    1605. 

  1605. }
    1606. 

  1606. function sxd_shutdown(){
    1607. 

  1607. 	global $SXD;
    1608. 

  1608. 	if(isset($SXD->fh_rtl) && is_resource($SXD->fh_rtl) && !empty($SXD->rtl) && empty($SXD->error)) {
    1609. 

  1609. 		$SXD->rtl[1] = time();
    1610. 

  1610. 		if(!empty($SXD->JOB['file_stp']) && file_exists(dirname(__FILE__) . '/' . $SXD->JOB['file_stp'])){
    1611. 

  1611. 			$type = file_get_contents(dirname(__FILE__) . '/' . $SXD->JOB['file_stp']);
    1612. 

  1612. 			$SXD->rtl[9] = !empty($type) ? $type : 2;
    1613. 

  1613. 		}
    1614. 

  1614. 		else $SXD->rtl[9] = 5;
    1615. 

  1615. 		fseek($SXD->fh_rtl, 0);
    1616. 

  1616. 		fwrite($SXD->fh_rtl, implode("\t", $SXD->rtl));
    1617. 

  1617. 	}
    1618. 

  1618. }
    1619. 

  1619. function sxd_antimagic($arr){
    1620. 

  1620. 	return is_array($arr) ? array_map('sxd_antimagic', $arr) : stripslashes($arr);
    1621. 

  1621. }
    1622. 

  1622. // Templates
    1623. 

  1623. function sxd_tpl_page(){
    1624. 

  1624. global $SXD;
    1625. 

  1625. return <<<HTML
    1626. 

  1626. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
    1627. 

  1627. <html>
    1628. 

  1628. <head>
    1629. 

  1629. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    1630. 

  1630. <title>{$SXD->name}</title>
    1631. 

  1631. <link rel="stylesheet" type="text/css" href="load.php?sxd.v208.css">
    1632. 

  1632. <script type="text/javascript" src="load.php?sxd.v208.js"></script>
    1633. 

  1633. <script type="text/javascript" src="load.php?{$SXD->LNG['name']}.lng.js"></script>
    1634. 

  1634. <link rel="shortcut icon" href="load.php?favicon.v208.ico">
    1635. 

  1635. </head>
    1636. 

  1636. 

  1637. <body>
    1638. 

  1638. <div id="main_div">
    1639. 

  1639. 	<div id="header">{$SXD->name}</div>
    1640. 

  1640. 	<div id="sxdToolbar"></div>
    1641. 

  1641. 	<div id="name"><div id="loading"></div><b></b></div>
    1642. 

  1642. 	<div id="content" class="content">
    1643. 

  1643. 		<table cellspacing="0" id="tab_backup">
    1644. 

  1644. 			<tr>
    1645. 

  1645. 				<td width="242" valign="top">
    1646. 

  1646. 					<div class="caption">{$SXD->LNG['combo_db']}</div><div id="backup_db"></div>
    1647. 

  1647. 					<div class="caption">{$SXD->LNG['combo_charset']}</div><div id="backup_charset"></div>
    1648. 

  1648. 					<div class="caption">{$SXD->LNG['combo_zip']}</div><div id="backup_zip"></div>
    1649. 

  1649. 					<div class="caption">{$SXD->LNG['combo_comments']}</div>
    1650. 

  1650. 					<div class="border"><textarea cols="10" rows="3" id="backup_comment"></textarea></div>
    1651. 

  1651. 					<div class="caption" style="margin-top:12px;">
    1652. 

  1652. 						<fieldset><legend>{$SXD->LNG['del_legend']}</legend>
    1653. 

  1653. 						<div class="caption">&nbsp;– {$SXD->LNG['del_date']}</div>
    1654. 

  1654. 						<div class="caption">&nbsp;– {$SXD->LNG['del_count']}</div>
    1655. 

  1655. 						</fieldset>
    1656. 

  1656. 					</div>
    1657. 

  1657. 				</td>
    1658. 

  1658. 				<td width="308" valign="top">
    1659. 

  1659. 					<div class="caption">{$SXD->LNG['tree']}</div><div id=backup_tree class="zTree"></div>
    1660. 

  1660. 				</td>
    1661. 

  1661. 			</tr>
    1662. 

  1662. 			<tr><td></td><td align="right"><input type="button" value="{$SXD->LNG['btn_save']}" onclick="sxd.showDialog('savejob');z('sj_name').value = sxd.combos.backup_db.value;"> <input type="button" value="{$SXD->LNG['btn_exec']}" onclick="sxd.runBackup();"></td></tr>
    1663. 

  1663. 		</table>
    1664. 

  1664. 		
    1665. 

  1665. 		<table cellspacing="0" id="tab_restore" style="display:none;">
    1666. 

  1666. 			<tr>
    1667. 

  1667. 				<td width="242" valign="top">
    1668. 

  1668. 					<div class="caption">{$SXD->LNG['combo_db']}</div><div id="restore_db"></div>
    1669. 

  1669. 					<div class="caption">{$SXD->LNG['combo_charset']}</div><div id="restore_charset"></div>
    1670. 

  1670. 					<div class="caption">{$SXD->LNG['combo_file']}</div><div id="restore_file"></div>
    1671. 

  1671. 					<div class="caption">{$SXD->LNG['combo_comments']}</div>
    1672. 

  1672. 					<div class="border"><textarea cols="10" rows="3" id="restore_comment" readonly></textarea></div>
    1673. 

  1673. 					<div class="caption">{$SXD->LNG['combo_strategy']}</div><div id="restore_type"></div>
    1674. 

  1674. 					<div class="caption" style="margin-top:17px;">
    1675. 

  1675. 						<fieldset><legend>{$SXD->LNG['ext_legend']}</legend>
    1676. 

  1676. 						<div class="caption"><label><input type="checkbox" id="correct"> {$SXD->LNG['correct']}</label></div>
    1677. 

  1677. 						<div class="caption"><label><input type="checkbox" id="autoinc"> {$SXD->LNG['autoinc']}</label></div>
    1678. 

  1678. 						</fieldset>
    1679. 

  1679. 					</div>
    1680. 

  1680. 				</td>
    1681. 

  1681. 				<td width="308" valign="top">
    1682. 

  1682. 					<div class="caption">{$SXD->LNG['tree']}</div><div id=restore_tree class="zTree"></div>
    1683. 

  1683. 				</td>
    1684. 

  1684. 			</tr>
    1685. 

  1685. 			<tr><td></td><td align="right"><input type="button" value="{$SXD->LNG['btn_save']}" onclick="sxd.showDialog('savejob');z('sj_name').value = sxd.combos.restore_db.value;" id=restore_savejob> <input type="button" value="{$SXD->LNG['btn_exec']}" onclick="sxd.runRestore();" id=restore_runjob></td></tr>
    1686. 

  1686. 		</table>
    1687. 

  1687. 		
    1688. 

  1688. 		<table cellspacing="0" id="tab_log" style="display:none;">
    1689. 

  1689. 			<tr>
    1690. 

  1690. 				<td valign="top" colspan=2>
    1691. 

  1691. 					<div id=sxdGrid1></div> 
    1692. 

  1692. 				</td>
    1693. 

  1693. 			</tr>
    1694. 

  1694. 			<tr><td colspan=2>
    1695. 

  1695. 			<table class=progress>
    1696. 

  1696. 				<tr><td>{$SXD->LNG['status_current']}</td><td><div id="sxdProc1"></div></td><td width=60>{$SXD->LNG['time_elapsed']}</td><td width=40 align=right id="sxdTime1">00:00</td></tr>
    1697. 

  1697. 				<tr><td>{$SXD->LNG['status_total']}</td><td><div id="sxdProc2"></div></td><td>{$SXD->LNG['time_left']}</td><td align=right id="sxdTime2">00:00</td></tr>
    1698. 

  1698. 			</table>
    1699. 

  1699. 			</td></tr>
    1700. 

  1700. 			<tr><td width="152"><input type="button" value="{$SXD->LNG['btn_clear']}" onclick="sxd.log.clear();"></td><td width="380" align="right">
    1701. 

  1701. 			<input type="button" value="{$SXD->LNG['btn_download']}" id="btn_down" onclick="sxd.runFiles('download', this.file);" style="display:none;">
    1702. 

  1702. 			<input type="button" value="{$SXD->LNG['btn_again']}" id="btn_again" onclick="sxd.runAgain();" disabled>
    1703. 

  1703. 			<input type="button" value="{$SXD->LNG['btn_stop']}" id="btn_stop" onclick="sxd.stopJob();" disabled>
    1704. 

  1704. 			<input type="button" value="{$SXD->LNG['btn_pause']}" id="btn_pause" onclick="sxd.pauseJob();" disabled>
    1705. 

  1705. 			<input type="button" value="{$SXD->LNG['btn_resume']}" id="btn_resume" onclick="sxd.resumeJob();" style="display:none;">
    1706. 

  1706. 			</td></tr>
    1707. 

  1707. 		</table>
    1708. 

  1708. 		<table cellspacing="0" id="tab_result" style="display:none;">
    1709. 

  1709. 			<tr>
    1710. 

  1710. 				<td valign="top">
    1711. 

  1711. 					<div id=sxdGrid3></div> 
    1712. 

  1712. 				</td>
    1713. 

  1713. 			</tr>
    1714. 

  1714. 			<tr><td>
    1715. 

  1715. 			<input type="button" value="{$SXD->LNG['btn_clear']}" onclick="sxd.result.clear();">
    1716. 

  1716. 			</td></tr>
    1717. 

  1717. 		</table>
    1718. 

  1718. 		
    1719. 

  1719. 		<table cellspacing="0" id="tab_files" style="display:none;">
    1720. 

  1720. 			<tr>
    1721. 

  1721. 				<td valign="top" colspan=2>
    1722. 

  1722. 					<div id=sxdGrid2></div> 
    1723. 

  1723. 				</td>
    1724. 

  1724. 			</tr>
    1725. 

  1725. 			<tr><td width="242"><form id="save_file" method="GET" style="visibility:hidden;display:inline;" target=save></form><input type="button" value="{$SXD->LNG['btn_delete']}" onclick="sxd.runFiles('delete')"></td><td width="290" align="right">
    1726. 

  1726. 			<input type="button" value="{$SXD->LNG['btn_download']}" onclick="sxd.runFiles('download')">
    1727. 

  1727. 			<input type="button" value="{$SXD->LNG['btn_open']}" onclick="sxd.runFiles('open')">
    1728. 

  1728. 			</td></tr>
    1729. 

  1729. 		</table>
    1730. 

  1730. 		
    1731. 

  1731. 		
    1732. 

  1732. 		<table cellspacing="0" id="tab_services" style="display:none;">
    1733. 

  1733. 			<tr>
    1734. 

  1734. 				<td width="242" valign="top">
    1735. 

  1735. 					<div class="caption">{$SXD->LNG['combo_db']}</div><div id="services_db"></div>
    1736. 

  1736. 					<br>
    1737. 

  1737. 					<div class="caption">{$SXD->LNG['opt_check']}</div><div id="services_check"></div>
    1738. 

  1738. 					<div class="caption">{$SXD->LNG['opt_repair']}</div><div id="services_repair"></div>
    1739. 

  1739. 				</td>
    1740. 

  1740. 				<td width="308" valign="top">
    1741. 

  1741. 					<div class="caption">{$SXD->LNG['tree']}</div><div id=services_tree class="zTree"></div>
    1742. 

  1742. 				</td>
    1743. 

  1743. 			</tr>
    1744. 

  1744. 			<tr><td align="right" colspan=2><input type="button" value="{$SXD->LNG['btn_delete_db']}" onclick="sxd.runServices('delete')" style="float:left;"> <input type="button" value="{$SXD->LNG['btn_check']}" onclick="sxd.runServices('check')"> <input type="button" value="{$SXD->LNG['btn_repair']}" onclick="sxd.runServices('repair')"> <input type="button" value="{$SXD->LNG['btn_analyze']}" onclick="sxd.runServices('analyze')">  <input type="button" value="{$SXD->LNG['btn_optimize']}" onclick="sxd.runServices('optimize')"></td></tr>
    1745. 

  1745. 		</table>
    1746. 

  1746. 		<table cellspacing="0" id="tab_options" style="display:none;">
    1747. 

  1747. 			<tr>
    1748. 

  1748. 				<td valign="top" colspan=2>
    1749. 

  1749. 					<div style="height: 341px;">
    1750. 

  1750. 					<fieldset>
    1751. 

  1751. 					<legend>{$SXD->LNG['cfg_legend']}</legend>
    1752. 

  1752. 						<table cellspacing="0">
    1753. 

  1753. 							<tr>
    1754. 

  1754. 								<td width=190>{$SXD->LNG['cfg_time_web']}</td>
    1755. 

  1755. 								<td width=45><input type="text" id="time_web" style="width:40px;"></td>
    1756. 

  1756. 								<td align="right">{$SXD->LNG['cfg_time_cron']}</td>
    1757. 

  1757. 								<td width=40 align="right"><input type="text" id="time_cron" style="width:40px;"></td>
    1758. 

  1758. 							</tr>
    1759. 

  1759. 							<tr>
    1760. 

  1760. 								<td>{$SXD->LNG['cfg_backup_path']}</td>
    1761. 

  1761. 								<td colspan=3><input type="text" id="backup_path" style="width:351px;"></td>
    1762. 

  1762. 							</tr>
    1763. 

  1763. 							<tr>
    1764. 

  1764. 								<td>{$SXD->LNG['cfg_backup_url']}</td>
    1765. 

  1765. 								<td colspan=3><input type="text" id="backup_url" style="width:351px;"></td>
    1766. 

  1766. 							</tr>
    1767. 

  1767. 							<tr>
    1768. 

  1768. 								<td>{$SXD->LNG['cfg_globstat']}</td>
    1769. 

  1769. 								<td colspan=3><input type="checkbox" id="globstat" value="1"></td>
    1770. 

  1770. 							</tr>
    1771. 

  1771. 						</table>
    1772. 

  1772. 					</fieldset>
    1773. 

  1773. 					<fieldset>
    1774. 

  1774. 					<legend>{$SXD->LNG['cfg_confirm']}</legend>
    1775. 

  1775. 						<table cellspacing="0">
    1776. 

  1776. 							<tr>
    1777. 

  1777. 								<td width="33%"><label><input type="checkbox" id="conf_import" value="1"> {$SXD->LNG['cfg_conf_import']}</label></td>
    1778. 

  1778. 								<td width="34%"><label><input type="checkbox" id="conf_file" value="1"> {$SXD->LNG['cfg_conf_file']}</label></td>
    1779. 

  1779. 								<td width="33%"><label><input type="checkbox" id="conf_db" value="1"> {$SXD->LNG['cfg_conf_db']}</label></td>
    1780. 

  1780. 							</tr>
    1781. 

  1781. 						</table>
    1782. 

  1782. 					</fieldset>
    1783. 

  1783. 					<fieldset>
    1784. 

  1784. 					<legend>{$SXD->LNG['cfg_extended']}</legend>
    1785. 

  1785. 						<table cellspacing="0">
    1786. 

  1786. 							<tr>
    1787. 

  1787. 								<td width=190>{$SXD->LNG['cfg_charsets']}</td>
    1788. 

  1788. 								<td><input type="text" id="charsets" value="" style="width:351px;"></td>
    1789. 

  1789. 							</tr>
    1790. 

  1790. 							<tr>
    1791. 

  1791. 								<td>{$SXD->LNG['cfg_only_create']}</td>
    1792. 

  1792. 								<td><input type="text" id="only_create" value="" style="width:351px;"></td>
    1793. 

  1793. 							</tr>
    1794. 

  1794. 							<tr>
    1795. 

  1795. 								<td>{$SXD->LNG['cfg_auth']}</td>
    1796. 

  1796. 								<td><input type="text" id="auth" value="" style="width:351px;"></td>
    1797. 

  1797. 							</tr>
    1798. 

  1798. 						</table>
    1799. 

  1799. 					</fieldset>
    1800. 

  1800. 					</div>
    1801. 

  1801. 				</td>
    1802. 

  1802. 			</tr>
    1803. 

  1803. 			<tr><td align="right" colspan=2><input type="button" value="{$SXD->LNG['btn_save']}" onclick="sxd.saveOptions();"></td></tr>
    1804. 

  1804. 		</table>
    1805. 

  1805. 	</div>
    1806. 

  1806. </div>
    1807. 

  1807. 

  1808. <div id="overlay"></div>
    1809. 

  1809. <div class="dialog" id ="dia_connect">
    1810. 

  1810. 	<div class="header">{$SXD->LNG['con_header']}</div>
    1811. 

  1811. 	<div class="content">
    1812. 

  1812. 		<table cellspacing="5">
    1813. 

  1813. 			<tr>
    1814. 

  1814. 				<td valign="top">
    1815. 

  1815. 				<fieldset>
    1816. 

  1816. 				<legend>{$SXD->LNG['connect']}</legend>
    1817. 

  1817. 					<table cellspacing="3">
    1818. 

  1818. 						<tr>
    1819. 

  1819. 							<td width="80">{$SXD->LNG['my_host']}</td>
    1820. 

  1820. 							<td width="126"><input type="text" id="con_host" style="width:120px;"></td>
    1821. 

  1821. 							<td width="40" align="right">{$SXD->LNG['my_port']}</td>
    1822. 

  1822. 							<td width="36"><input type="text" id="con_port" maxlength="5" style="width:30px;"></td>
    1823. 

  1823. 						</tr>
    1824. 

  1824. 						<tr>
    1825. 

  1825. 							<td>{$SXD->LNG['my_user']}</td>
    1826. 

  1826. 							<td colspan="3"><input type="text" id="con_user" name="user" style="width:202px;"></td>
    1827. 

  1827. 						</tr>
    1828. 

  1828. 						<tr>
    1829. 

  1829. 							<td>{$SXD->LNG['my_pass']}</td>
    1830. 

  1830. 							<td colspan="3"><input type="password" id="con_pass" name="pass" title="{$SXD->LNG['my_pass_hidden']}" style="width:202px;" onchange="this.changed = true;"></td>
    1831. 

  1831. 						</tr>
    1832. 

  1832. 						<tr>
    1833. 

  1833. 							<td></td>
    1834. 

  1834. 							<td colspan="3"><label><input type="checkbox" id="con_comp" value="1"> {$SXD->LNG['my_comp']}</label></td>
    1835. 

  1835. 						</tr>
    1836. 

  1836. 						<tr>
    1837. 

  1837. 							<td>{$SXD->LNG['my_db']}</td>
    1838. 

  1838. 							<td colspan="3"><input type="text" id="con_db" style="width:202px;"></td>
    1839. 

  1839. 						</tr>
    1840. 

  1840. 					</table></fieldset>
    1841. 

  1841. 				</td>
    1842. 

  1842. 			</tr>
    1843. 

  1843. 			<tr class="buttons"><td align="right"><input type="button" value="{$SXD->LNG['btn_save']}" onclick="sxd.saveConnect();"><input type="button" value="{$SXD->LNG['btn_cancel']}" onclick="sxd.hideDialog('connect');"></td></tr>
    1844. 

  1844. 		</table>
    1845. 

  1845. 	</div>
    1846. 

  1846. </div>
    1847. 

  1847. <div class="dialog" id ="dia_savejob">
    1848. 

  1848. 	<div class="header">{$SXD->LNG['sj_header']}</div>
    1849. 

  1849. 	<div class="content">
    1850. 

  1850. 		<table cellspacing="5">
    1851. 

  1851. 			<tr>
    1852. 

  1852. 				<td valign="top">
    1853. 

  1853. 				<fieldset>
    1854. 

  1854. 				<legend>{$SXD->LNG['sj_job']}</legend>
    1855. 

  1855. 					<table cellspacing="3">
    1856. 

  1856. 						<tr>
    1857. 

  1857. 							<td width="80">{$SXD->LNG['sj_name']}</td>
    1858. 

  1858. 							<td><input type="text" id="sj_name" style="width:202px;" maxlength="12" value=""></td>
    1859. 

  1859. 						</tr>
    1860. 

  1860. 						<tr>
    1861. 

  1861. 							<td>{$SXD->LNG['sj_title']}</td>
    1862. 

  1862. 							<td><input type="text" id="sj_title" maxlength="64" style="width:202px;"></td>
    1863. 

  1863. 						</tr>
    1864. 

  1864. 					</table></fieldset>
    1865. 

  1865. 				</td>
    1866. 

  1866. 			</tr>
    1867. 

  1867. 			<tr class="buttons"><td align="right"><input type="button" value="{$SXD->LNG['btn_save']}" onclick="sxd.saveJob();"><input type="button" value="{$SXD->LNG['btn_cancel']}" onclick="sxd.hideDialog('savejob');"></td></tr>
    1868. 

  1868. 		</table>
    1869. 

  1869. 	</div>
    1870. 

  1870. </div>
    1871. 

  1871. <div class=dialog id="dia_createdb">
    1872. 

  1872. 	<div class="header">{$SXD->LNG['cdb_header']}</div>
    1873. 

  1873. 	<div class="content">
    1874. 

  1874. 		<table cellspacing="5">
    1875. 

  1875. 			<tr>
    1876. 

  1876. 				<td valign="top">
    1877. 

  1877. 				<fieldset>
    1878. 

  1878. 				<legend>{$SXD->LNG['cdb_detail']}</legend>
    1879. 

  1879. 					<table cellspacing="3">
    1880. 

  1880. 						<tr>
    1881. 

  1881. 							<td width="80">{$SXD->LNG['cdb_name']}</td>
    1882. 

  1882. 							<td width="202"><input type="text" id="db_name" value="my_db_1" style="width:202px;"></td>
    1883. 

  1883. 						</tr>
    1884. 

  1884. 						<tr>
    1885. 

  1885. 							<td>{$SXD->LNG['combo_charset']}</td>
    1886. 

  1886. 							<td><div id="db_charset"></div></td>
    1887. 

  1887. 						</tr>
    1888. 

  1888. 						<tr>
    1889. 

  1889. 							<td>{$SXD->LNG['combo_collate']}</td>
    1890. 

  1890. 							<td><div id="db_charset_col"></div></td>
    1891. 

  1891. 						</tr>
    1892. 

  1892. 					</table>
    1893. 

  1893. 				</fieldset>
    1894. 

  1894. 				</td>
    1895. 

  1895. 			</tr>
    1896. 

  1896. 			<tr class="buttons"><td align="right"><input type="button" value="{$SXD->LNG['btn_create']}" onclick="sxd.addDb();"><input type="button" value="{$SXD->LNG['btn_cancel']}" onclick="sxd.hideDialog('createdb');"></td></tr>
    1897. 

  1897. 		</table>
    1898. 

  1898. 	</div>
    1899. 

  1899. </div>
    1900. 

  1900. 

  1901. <div id=sxdMenu style="display:none;z-index:9999;"></div>
    1902. 

  1902. <script type="text/javascript">
    1903. 

  1903. sxd.init();
    1904. 

  1904. sxd.backupUrl = '{$SXD->CFG['backup_url']}';
    1905. 

  1905. sxd.tbar.init('sxdToolbar', {$SXD->VAR['toolbar']}); 
    1906. 

  1906. {$SXD->VAR['combos']}
    1907. 

  1907. sxd.actions.tab_backup();
    1908. 

  1908. </script>
    1909. 

  1909. </body>
    1910. 

  1910. </html>
    1911. 

  1911. HTML;
    1912. 

  1912. }
    1913. 

  1913. 

  1914. function sxd_tpl_auth($error = ''){
    1915. 

  1915. global $SXD;
    1916. 

  1916. return <<<HTML
    1917. 

  1917. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">  
    1918. 

  1918. <html>
    1919. 

  1919. <head>
    1920. 

  1920. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    1921. 

  1921. <title>{$SXD->name}</title>
    1922. 

  1922. <link rel="shortcut icon" href="load.php?favicon.v208.ico">
    1923. 

  1923. <link rel="stylesheet" type="text/css" href="load.php?sxd.v208.css">
    1924. 

  1924. </head>
    1925. 

  1925. <body>
    1926. 

  1926. <div class="dialog" id="dia_auth">
    1927. 

  1927. 	<div class="header"><a href="http://sypex.net/">{$SXD->name}</a></div>
    1928. 

  1928. 	<div class="content" id="div_1" style="line-height:50px;text-align:center;">{$SXD->LNG['js_required']}</div>
    1929. 

  1929. 	<div class="content" id="div_2" style="display:none;">
    1930. 

  1930. 		<form method="post">
    1931. 

  1931. 		<table cellspacing="5">
    1932. 

  1932. 			<tr>
    1933. 

  1933. 				<td valign="top" colspan="3">
    1934. 

  1934. 				<fieldset>
    1935. 

  1935. 				<legend>{$SXD->LNG['auth']}</legend>
    1936. 

  1936. 					<table cellspacing="3">
    1937. 

  1937. 						<tr>
    1938. 

  1938. 							<td width="90">{$SXD->LNG['auth_user']}</td>
    1939. 

  1939. 							<td width="192"><input type="text" name="user" value="{$_POST['user']}" class="i202"></td>
    1940. 

  1940. 						</tr>
    1941. 

  1941. 						<tr>
    1942. 

  1942. 							<td>{$SXD->LNG['my_pass']}</td>
    1943. 

  1943. 							<td><input type="password" name="pass" value="{$_POST['pass']}" class="i202"></td>
    1944. 

  1944. 						</tr>
    1945. 

  1945. 						<tr>
    1946. 

  1946. 							<td></td>
    1947. 

  1947. 							<td><label><input type="checkbox" name="save" value="1"{$_POST['save']}> {$SXD->LNG['auth_remember']}</label></td>
    1948. 

  1948. 						</tr>
    1949. 

  1949. 						<tr>
    1950. 

  1950. 							<td>Language:</td>
    1951. 

  1951. 							<td><select type="text" name="lang" style="width:198px;" onChange="this.form.submit();">{$SXD->lng_list}</select></td>
    1952. 

  1952. 						</tr>
    1953. 

  1953. 					</table>
    1954. 

  1954. 					<table cellspacing="3" id="hst" style="display:none;">
    1955. 

  1955. 						<tr>
    1956. 

  1956. 							<td width="90">{$SXD->LNG['my_host']}</td>
    1957. 

  1957. 							<td width="116"><input type="text" name="host" style="width:110px;" value="{$_POST['host']}"></td>
    1958. 

  1958. 							<td width="40" align="right">{$SXD->LNG['my_port']}</td>
    1959. 

  1959. 							<td width="36"><input type="text" name="port" maxlength="5" style="width:30px;" value="{$_POST['port']}"></td>
    1960. 

  1960. 						</tr>
    1961. 

  1961. 					</table>
    1962. 

  1962. 				</fieldset>
    1963. 

  1963. 				</td>
    1964. 

  1964. 			</tr>
    1965. 

  1965. 			<tr class="buttons"><td align="left"><input type="button" value="{$SXD->LNG['btn_details']}" onclick="var s = document.getElementById('hst').style; s.display = (s.display == 'block') ? 'none' : 'block';"></td><td align="right"><input type="submit" value="{$SXD->LNG['btn_enter']}"></td></tr>
    1966. 

  1966. 		</table>
    1967. 

  1967. 		</form>
    1968. 

  1968. 	</div>
    1969. 

  1969. 	<script type="text/javascript">document.getElementById('div_1').style.display = 'none';document.getElementById('div_2').style.display = 'block';</script>
    1970. 

  1970. </div>
    1971. 

  1971. </body>
    1972. 

  1972. </html>
    1973. 

  1973. HTML;
    1974. 

  1974. }
    1975. 

  1975. 

  1976. ?>
    1977. 

  1977.