PageRenderTime 68ms CodeModel.GetById 21ms RepoModel.GetById 1ms app.codeStats 0ms

/vendor/sxd/index.php

https://code.google.com/p/dcloner/
PHP | 1956 lines | 1849 code | 39 blank | 68 comment | 357 complexity | 27335392d0ba2140b1559026d049fda7 MD5 | raw file
    

  1. <?php

    2. 

  2. /***************************************************************************\

    3. 

  3. | Sypex Dumper               version 2.0.7 RC                               |

    4. 

  4. | (c) 2003-2010 zapimir      zapimir@zapimir.net       http://sypex.net/    |

    5. 

  5. | (c) 2005-2010 BINOVATOR    info@sypex.net                                 |

    6. 

  6. |---------------------------------------------------------------------------|

    7. 

  7. |     created: 2003.09.02 19:07              modified: 2010.11.05 19:06     |

    8. 

  8. |---------------------------------------------------------------------------|

    9. 

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

    10. 

  10. |   http://sypex.net/bsd_license.txt                                        |

    11. 

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

    12. 

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

    13. 

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

    14. 

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

    15. 

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

    16. 

  16. //error_reporting(E_ALL);

    17. 

  17. @set_magic_quotes_runtime(0);

    18. 

  18. error_reporting(0);

    19. 

  19. set_error_handler('sxd_error_handler');

    20. 

  20. register_shutdown_function('sxd_shutdown');

    21. 

  21. $SXD = new Sypex_Dumper();

    22. 

  22. chdir(dirname(__FILE__));

    23. 

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

    24. 

  24.  

    25. 

  25. class Sypex_Dumper {

    26. 

  26. 	function Sypex_Dumper() {

    27. 

  27. 		define('C_DEFAULT', 1);

    28. 

  28. 		define('C_RESULT', 2);

    29. 

  29. 		define('C_ERROR', 3);

    30. 

  30. 		define('C_WARNING', 4);

    31. 

  31. 		define('SXD_DEBUG', false);

    32. 

  32. 		define('TIMER', array_sum(explode(' ', microtime()))); 

    33. 

  33. 		define('V_SXD', 20007);

    34. 

  34. 		define('V_PHP', sxd_ver2int(phpversion()));

    35. 

  35. 		$this->name = 'Sypex Dumper 2.0.7 RC';

    36. 

  36. 	}

    37. 

  37. 	function loadLang($lng_name = 'auto'){

    38. 

  38. 		if($lng_name == 'auto'){

    39. 

  39. 			include('lang/list.php');

    40. 

  40. 			$this->langs = &$langs;

    41. 

  41. 			$lng = 'en';

    42. 

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

    43. 

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

    44. 

  44. 					if(isset($langs[$l])){

    45. 

  45. 						$lng_name = $l;

    46. 

  46. 						break;

    47. 

  47. 					}

    48. 

  48. 				}

    49. 

  49. 			}

    50. 

  50. 		}

    51. 

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

    52. 

  52. 		else include("lang/lng_en.php");

    53. 

  53. 		$this->LNG = &$LNG;

    54. 

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

    55. 

  55. 		return true;

    56. 

  56. 	}

    57. 

  57. 	function init($args = false){

    58. 

  58. 		if (get_magic_quotes_gpc()) {

    59. 

  59. 			$_POST = sxd_antimagic($_POST);

    60. 

  60. 		}

    61. 

  61. 		include('cfg.php');

    62. 

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

    63. 

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

    64. 

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

    65. 

  65. 		$this->CFG = &$CFG;

    66. 

  66. 		$this->try = false;

    67. 

  67. 		$this->virtualize = false;

    68. 

  68. 		$this->cron_mode = false;

    69. 

  69. 		// ????????? ??????????? ? ?????? ??????? ? ????

    70. 

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

    71. 

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

    72. 

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

    73. 

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

    74. 

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

    75. 

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

    76. 

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

    77. 

  77. 		}

    78. 

  78. 		if ($args) { // ?????????? ?????

    79. 

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

    80. 

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

    81. 

  81. 		            switch ($m[1]) {

    82. 

  82. 		                case 'h': $this->CFG['my_host'] = $m[2]; break; // ????

    83. 

  83. 		                case 'o': $this->CFG['my_port'] = $m[2]; break; // ????

    84. 

  84. 		                case 'u': $this->CFG['my_user'] = $m[2]; break; // ?????

    85. 

  85. 		                case 'p': $this->CFG['my_pass'] = $m[2]; break; // ??????

    86. 

  86. 		                case 'j': $this->CFG['sjob'] = $m[2]; break; // job-????

    87. 

  87. 		            }

    88. 

  88. 		        }

    89. 

  89. 		    }

    90. 

  90. 		    set_time_limit($CFG['time_cron']);

    91. 

  91. 		    // ????????? ?????? ????, ???? ?????

    92. 

  92. 		    $auth = $this->connect();

    93. 

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

    94. 

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

    95. 

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

    96. 

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

    97. 

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

    98. 

  98. 		    }

    99. 

  99. 		    else echo 'Auth error';

    100. 

  100. 		    exit;

    101. 

  101. 		}

    102. 

  102. 		elseif(!empty($this->CFG['auth'])){ // ???????????

    103. 

  103. 			$auth = false;

    104. 

  104. 			$sfile = 'ses.php';

    105. 

  105. 			

    106. 

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

    107. 

  107. 				include($sfile);

    108. 

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

    109. 

  109. 					$auth = true;

    110. 

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

    111. 

  111. 					$this->SES = &$SES;

    112. 

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

    113. 

  113. 				}

    114. 

  114. 			}

    115. 

  115. 			if(!$auth) {

    116. 

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

    117. 

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

    118. 

  118. 				$host = !empty($_POST['host']) ? $_POST['host'] : 'localhost';

    119. 

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

    120. 

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

    121. 

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

    122. 

  122. 				foreach($temp AS $a){

    123. 

  123. 					switch($a) {

    124. 

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

    125. 

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

    126. 

  126. 										break;

    127. 

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

    128. 

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

    129. 

  129. 										break;

    130. 

  130. 						default:		$file = 'auth_' . $a . '.php';

    131. 

  131. 										if(!file_exists($file)) continue;

    132. 

  132. 										include	$file;

    133. 

  133. 					}

    134. 

  134. 					if($auth) break;

    135. 

  135. 				}

    136. 

  136. 				if($auth){

    137. 

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

    138. 

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

    139. 

  139. 					$_COOKIE['sxd'] = $key;

    140. 

  140. 					$this->saveCFG();

    141. 

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

    142. 

  142. 					header("Location: ./");

    143. 

  143. 					exit;

    144. 

  144. 				}

    145. 

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

    146. 

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

    147. 

  147. 				}

    148. 

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

    149. 

  149. 			}

    150. 

  150. 			if (!$auth) {

    151. 

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

    152. 

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

    153. 

  153. 					exit;

    154. 

  154. 				}

    155. 

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

    156. 

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

    157. 

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

    158. 

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

    159. 

  159. 				}

    160. 

  160. 				echo sxd_tpl_auth();

    161. 

  161. 				exit;

    162. 

  162. 			}

    163. 

  163. 		}

    164. 

  164. 		/*if(!empty($_SERVER['QUERY_STRING']) && $_SERVER['QUERY_STRING'] == 'exit') {

    165. 

  165. 			setcookie('sxd', '', 0);

    166. 

  166. 			header("Location: {$this->CFG['exitURL']}");

    167. 

  167. 			exit;

    168. 

  168. 		}*/

    169. 

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

    170. 

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

    171. 

  171. 		else $this->main();

    172. 

  172. 	}

    173. 

  173. 	function saveToFile($name, $content){

    174. 

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

    175. 

  175. 		fwrite($fp, $content);

    176. 

  176. 		fclose($fp);

    177. 

  177. 	}

    178. 

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

    179. 

  179. 		$this->error = '';

    180. 

  180. 		$this->try = true;

    181. 

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

    182. 

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

    183. 

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

    184. 

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

    185. 

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

    186. 

  186. 		}

    187. 

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

    188. 

  188. 			mysql_query('SET NAMES utf8') or sxd_my_error();

    189. 

  189. 			define('V_MYSQL', sxd_ver2int(mysql_get_server_info()));

    190. 

  190. 		}

    191. 

  191. 		else {

    192. 

  192. 			define('V_MYSQL', 0); 

    193. 

  193. 			$this->error = "sxd.actions.tab_connects();alert('{" . mysql_escape_string(mysql_error()) . "');";

    194. 

  194. 		}	

    195. 

  195. 		$this->try = false;

    196. 

  196. 		return V_MYSQL ? true: false;

    197. 

  197. 	}

    198. 

  198. 	function main(){

    199. 

  199.    		// ??????

    200. 

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

    201. 

  201. 			array(

    202. 

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

    203. 

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

    204. 

  204. 				array('|'),

    205. 

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

    206. 

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

    207. 

  207. 				array('|'),

    208. 

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

    209. 

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

    210. 

  210. 				array('|'),

    211. 

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

    212. 

  212. 				array('|'),

    213. 

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

    214. 

  214. 			)

    215. 

  215. 		);

    216. 

  216.   		$this->db = 'temp';

    217. 

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

    218. 

  218. 		if (function_exists("gzopen")) {

    219. 

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

    220. 

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

    221. 

  221. 			}

    222. 

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

    223. 

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

    224. 

  224. 		}

    225. 

  225. 		if (function_exists("bzopen")) {

    226. 

  226. 		    $zip[10] = "BZip";

    227. 

  227. 		}

    228. 

  228. 		end($zip);

    229. 

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

    230. 

  230. 		$this->VAR['combos'] =

    231. 

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

    232. 

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

    233. 

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

    234. 

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

    235. 

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

    236. 

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

    237. 

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

    238. 

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

    239. 

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

    240. 

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

    241. 

  241. 			//$this->addCombo('services_charset', 0, 9, 'collation', $this->getCollationList()) .

    242. 

  242. 			//$this->addCombo('services_charset_col', 0, 15, 'collation:services_charset').

    243. 

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

    244. 

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

    245. 

  245. 		;

    246. 

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

    247. 

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

    248. 

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

    249. 

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

    250. 

  250. 		

    251. 

  251. 		echo sxd_tpl_page();

    252. 

  252. 	}

    253. 

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

    254. 

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

    255. 

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

    256. 

  256. 	}

    257. 

  257. 	function ajax($req){

    258. 

  258. 		$res = '';

    259. 

  259. 		$act = $req['act'];

    260. 

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

    261. 

  261. 			$req = $this->loadJob($req);

    262. 

  262. 		}

    263. 

  263. 		switch($req['act']){

    264. 

  264. 			case 'load_db': 

    265. 

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

    266. 

  266. 				break;

    267. 

  267. 			case 'load_files': 

    268. 

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

    269. 

  269. 				break;

    270. 

  270. 			case 'filelist': 

    271. 

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

    272. 

  272. 				break;

    273. 

  273. 			case 'dblist':

    274. 

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

    275. 

  275. 				break;

    276. 

  276. 			case 'load_connect':

    277. 

  277. 				$CFG = $this->cfg2js($this->CFG); 

    278. 

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

    279. 

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

    280. 

  280. 				break;

    281. 

  281. 			case 'save_connect': 

    282. 

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

    283. 

  283. 				break;

    284. 

  284. 			case 'save_job': 

    285. 

  285. 				unset($req['act']);

    286. 

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

    287. 

  287. 				$res = $this->getSavedJobs();

    288. 

  288. 				break;

    289. 

  289. 			case 'add_db': 

    290. 

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

    291. 

  291. 				break;

    292. 

  292. 			case 'load_options':

    293. 

  293. 				$CFG = $this->cfg2js($this->CFG);

    294. 

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

    295. 

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

    296. 

  296. 				break;

    297. 

  297. 			case 'save_options': 

    298. 

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

    299. 

  299. 				break;

    300. 

  300. 			case 'delete_file':

    301. 

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

    302. 

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

    303. 

  303. 					if(file_exists($file)) unlink($file);

    304. 

  304. 				}

    305. 

  305. 				$res = $this->getFileListExtended();

    306. 

  306. 				break;

    307. 

  307. 			case 'delete_db':

    308. 

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

    309. 

  309. 				break;

    310. 

  310. 			case 'load_files_ext': 

    311. 

  311. 				$res .= $this->getFileListExtended();

    312. 

  312. 				break;

    313. 

  313. 			case 'services': 

    314. 

  314. 				$this->runServices($req);

    315. 

  315. 				break;	

    316. 

  316. 			case 'backup': 

    317. 

  317. 				$this->addBackupJob($req);

    318. 

  318. 				break;

    319. 

  319. 			case 'restore': 

    320. 

  320. 				$this->addRestoreJob($req);

    321. 

  321. 				break;

    322. 

  322. 			case 'resume': 

    323. 

  323. 				$this->resumeJob($req);

    324. 

  324. 				break;

    325. 

  325. 			case 'exit': 

    326. 

  326. 				setcookie('sxd', '', 0);

    327. 

  327. 				$res = "top.location.href = '" . mysql_escape_string($this->CFG['exitURL']) . "'"; 

    328. 

  328. 				break;

    329. 

  329. 		}	

    330. 

  330. 		echo $res;

    331. 

  331. 	}

    332. 

  332. 	function loadJob($job){

    333. 

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

    334. 

  334. 		if(!file_exists($file)) return;

    335. 

  335. 		include($file);

    336. 

  336. 		$JOB['act'] = $JOB['type'];

    337. 

  337. 		$JOB['type'] = 'run';

    338. 

  338. 		return $JOB;

    339. 

  339. 	}

    340. 

  340. 	function deleteDB($name){

    341. 

  341. 		$r = mysql_query('DROP DATABASE `' . mysql_escape_string($name) . '`') or sxd_my_error();

    342. 

  342. 		if($r){

    343. 

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

    344. 

  344. 		}

    345. 

  345.         else

    346. 

  346.         	echo "alert('" . mysql_escape_string(mysql_error()) . "')";

    347. 

  347. 	}

    348. 

  348. 	function cfg2js($cfg){

    349. 

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

    350. 

  350. 			$cfg[$k] = mysql_escape_string($v);

    351. 

  351. 		}

    352. 

  352. 		return $cfg;

    353. 

  353. 	}

    354. 

  354. 	function addDb($req){

    355. 

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

    356. 

  356.         if($r)

    357. 

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

    358. 

  358.         else

    359. 

  359.         	 sxd_my_error();

    360. 

  360. 	}

    361. 

  361. 	function saveConnect($req){

    362. 

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

    363. 

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

    364. 

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

    365. 

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

    366. 

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

    367. 

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

    368. 

  368. 		$this->saveCFG();

    369. 

  369.         $this->connect();

    370. 

  370.         if (V_MYSQL) {

    371. 

  371. 	        $tmp = array(

    372. 

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

    373. 

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

    374. 

  374.         		'collation' => $this->getCollationList()

    375. 

  375. 			);

    376. 

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

    377. 

  377. 		}

    378. 

  378. 		else {

    379. 

  379. 			 echo $this->error;

    380. 

  380. 		}

    381. 

  381. 	}

    382. 

  382. 	function saveOptions($req){

    383. 

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

    384. 

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

    385. 

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

    386. 

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

    387. 

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

    388. 

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

    389. 

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

    390. 

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

    391. 

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

    392. 

  392. 		$this->saveCFG();

    393. 

  393. 	}

    394. 

  394. 	function saveCFG(){

    395. 

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

    396. 

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

    397. 

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

    398. 

  398. 		}

    399. 

  399.         if (!$this->virtualize){

    400. 

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

    401. 

  401.         }

    402. 

  402. 	}

    403. 

  403. 	function runServices($job) {

    404. 

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

    405. 

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

    406. 

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

    407. 

  407. 			mysql_select_db($job['db']);

    408. 

  408. 			$filter = $object = array();

    409. 

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

    410. 

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

    411. 

  411. 			if (!$r) return;

    412. 

  412. 			$tables = array();

    413. 

  413. 			while($item = mysql_fetch_assoc($r)){

    414. 

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

    415. 

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

    416. 

  416. 			}

    417. 

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

    418. 

  418. 			

    419. 

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

    420. 

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

    421. 

  421. 			}

    422. 

  422. 			

    423. 

  423. 			$r = mysql_query($sql) or sxd_my_error();

    424. 

  424. 			if (!$r) return;

    425. 

  425. 			$res = array();

    426. 

  426. 			while($item = mysql_fetch_row($r)){

    427. 

  427. 				$res[] = $item;

    428. 

  428. 			}

    429. 

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

    430. 

  430. 		}

    431. 

  431. 	}

    432. 

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

    433. 

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

    434. 

  434. 		foreach($types AS $type){

    435. 

  435. 			$filter[$type] = array();

    436. 

  436. 			$object[$type] = array();

    437. 

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

    438. 

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

    439. 

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

    440. 

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

    441. 

  441. 					}

    442. 

  442. 					else {

    443. 

  443. 						$object[$type][$v] = true;

    444. 

  444. 					}

    445. 

  445. 				}

    446. 

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

    447. 

  447. 			}

    448. 

  448. 		}

    449. 

  449. 	}

    450. 

  450. 	function closeConnect(){

    451. 

  451. 		//return;

    452. 

  452. 		ignore_user_abort(1); 

    453. 

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

    454. 

  454. 		header("Connection: close"); 

    455. 

  455. 		header("Content-Length: 0"); 

    456. 

  456. 		ob_end_flush(); 

    457. 

  457. 		flush();

    458. 

  458. 	}

    459. 

  459. 	function resumeJob($job){

    460. 

  460. 		$this->closeConnect();

    461. 

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

    462. 

  462. 		$this->JOB = &$JOB;

    463. 

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

    464. 

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

    465. 

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

    466. 

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

    467. 

  467. 		if(!empty($t)){

    468. 

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

    469. 

  469. 		}

    470. 

  470. 		else {

    471. 

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

    472. 

  472. 			exit;

    473. 

  473. 		}

    474. 

  474. 		// TODO: ????????? ???????? ?????????

    475. 

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

    476. 

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

    477. 

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

    478. 

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

    479. 

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

    480. 

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

    481. 

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

    482. 

  482. 	}

    483. 

  483. 	function addRestoreJob($job) {

    484. 

  484. 		$this->closeConnect();

    485. 

  485. 		$this->JOB = $job;

    486. 

  486. 		// ??????? ?????? ???????? ? ??????

    487. 

  487. 		$filter = $object = array();

    488. 

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

    489. 

  489. 		

    490. 

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

    491. 

  491. 		$todo = array();

    492. 

  492. 		$rows = 0;

    493. 

  493. 		$this->tab_rows = array();

    494. 

  494. 		$todo = array();

    495. 

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

    496. 

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

    497. 

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

    498. 

  498. 			if (empty($list)) continue;

    499. 

  499. 			

    500. 

  500. 			foreach($list AS $item){

    501. 

  501. 				switch($t){

    502. 

  502. 					case 'TA':

    503. 

  503. 						$type = '';

    504. 

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

    505. 

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

    506. 

  506. 						}

    507. 

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

    508. 

  508. 							$type = 'TC';

    509. 

  509. 						}

    510. 

  510. 						else continue;

    511. 

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

    512. 

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

    513. 

  513. 					break;

    514. 

  514. 					default:

    515. 

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

    516. 

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

    517. 

  517. 						}

    518. 

  518. 				}

    519. 

  519. 			}

    520. 

  520. 		}

    521. 

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

    522. 

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

    523. 

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

    524. 

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

    525. 

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

    526. 

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

    527. 

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

    528. 

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

    529. 

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

    530. 

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

    531. 

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

    532. 

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

    533. 

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

    534. 

  534. 		$this->runRestoreJob();

    535. 

  535. 	}

    536. 

  536. 	function runRestoreJob($continue = false){

    537. 

  537. 		$ei = false;

    538. 

  538. 		if($continue){

    539. 

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

    540. 

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

    541. 

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

    542. 

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

    543. 

  543. 		}

    544. 

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

    545. 

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

    546. 

  546. 		//mysql_query("SET NAMES 'UTF8'");

    547. 

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

    548. 

  548. 		$fcache = '';

    549. 

  549. 		$writes = 0;

    550. 

  550. 		$old_charset = '';

    551. 

  551. 		$tab = '';

    552. 

  552. 		$seek = 0;

    553. 

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

    554. 

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

    555. 

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

    556. 

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

    557. 

  557. 		$c = 0;

    558. 

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

    559. 

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

    560. 

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

    561. 

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

    562. 

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

    563. 

  563. 		}

    564. 

  564. 		$tab_exists = array();

    565. 

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

    566. 

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

    567. 

  567. 			while($item = mysql_fetch_row($r)){

    568. 

  568. 				$tab_exists[$item[0]] = true;

    569. 

  569. 			}

    570. 

  570. 		}

    571. 

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

    572. 

  572. 		//$enable_index = array();

    573. 

  573. 		if(V_MYSQL > 40014) {

    574. 

  574. 			mysql_query("SET UNIQUE_CHECKS=0");

    575. 

  575. 			mysql_query("SET FOREIGN_KEY_CHECKS=0");

    576. 

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

    577. 

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

    578. 

  578. 		}

    579. 

  579. 		$log_sql = false;

    580. 

  580. 		$fields = '';

    581. 

  581. 		$time_old = time();

    582. 

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

    583. 

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

    584. 

  584. 			if($time_old < time()) {

    585. 

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

    586. 

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

    587. 

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

    588. 

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

    589. 

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

    590. 

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

    591. 

  591. 					/*if($type == 1) {

    592. 

  592. 						

    593. 

  593. 					}*/

    594. 

  594. 					unset($this->rtl);

    595. 

  595. 					exit;

    596. 

  596. 				}

    597. 

  597. 				$time_old = time();

    598. 

  598. 				if($time_old >= $exit_time){

    599. 

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

    600. 

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

    601. 

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

    602. 

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

    603. 

  603. 					unset($this->rtl);

    604. 

  604. 					exit;

    605. 

  605. 				}

    606. 

  606. 				clearstatcache(); 

    607. 

  607. 			}

    608. 

  608. 			switch($q{0}){

    609. 

  609. 				case '(':

    610. 

  610. 					if($continue) {

    611. 

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

    612. 

  612. 						$continue = false;

    613. 

  613. 					}

    614. 

  614. 					$q = $insert . $q;

    615. 

  615. 					$ex = 1;

    616. 

  616. 					$c = 1;

    617. 

  617. 					break;	

    618. 

  618. 				case 'I':

    619. 

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

    620. 

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

    621. 

  621. 						$tab = $m[2];

    622. 

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

    623. 

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

    624. 

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

    625. 

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

    626. 

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

    627. 

  627. 							}	

    628. 

  628. 						}

    629. 

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

    630. 

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

    631. 

  631. 						}

    632. 

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

    633. 

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

    634. 

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

    635. 

  635. 						$ex = 1;

    636. 

  636. 					}

    637. 

  637. 					break;

    638. 

  638. 				case 'C':

    639. 

  639. 					$ex = 1;

    640. 

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

    641. 

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

    642. 

  642. 						else {

    643. 

  643. 							$ex = 1;

    644. 

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

    645. 

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

    646. 

  646. 							}

    647. 

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

    648. 

  648. 						}

    649. 

  649. 						// ??????? ????? ????? ???????

    650. 

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

    651. 

  651. 					}

    652. 

  652. 					break;

    653. 

  653. 				case '#': // ??????? ??? ???????

    654. 

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

    655. 

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

    656. 

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

    657. 

  657. 						

    658. 

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

    659. 

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

    660. 

  660. 							$insert = '';

    661. 

  661. 							$tab = '';

    662. 

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

    663. 

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

    664. 

  664. 							$ei = 0;

    665. 

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

    666. 

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

    667. 

  667. 							}

    668. 

  668. 						}

    669. 

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

    670. 

  670. 							$ei = 1;

    671. 

  671. 						}

    672. 

  672. 						else {

    673. 

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

    674. 

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

    675. 

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

    676. 

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

    677. 

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

    678. 

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

    679. 

  679. 							$ei = 0;

    680. 

  680. 						}

    681. 

  681. 					}

    682. 

  682. 					$ex = 0;

    683. 

  683. 					break;

    684. 

  684. 				default: 

    685. 

  685. 					$insert = '';

    686. 

  686. 					$ex = 1;

    687. 

  687. 			}

    688. 

  688. 			if($ex) {

    689. 

  689. 				//error_log("[index.php]\n{$q}\n", 3, "error.log");

    690. 

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

    691. 

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

    692. 

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

    693. 

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

    694. 

  694. 				//error_log("\n---------------------\n{$q}", 3, "sql.log");	

    695. 

  695. 				if(mysql_query($q)) {

    696. 

  696. 					if($insert) {

    697. 

  697. 						$c = 1;

    698. 

  698. 					}

    699. 

  699. 				}

    700. 

  700. 				else {

    701. 

  701. 					error_log("[index.php]\n{$q}\n", 3, "error.log");

    702. 

  702. 					sxd_my_error();

    703. 

  703. 				}

    704. 

  704. 				

    705. 

  705. 				if($c){

    706. 

  706. 					$i = mysql_affected_rows();

    707. 

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

    708. 

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

    709. 

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

    710. 

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

    711. 

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

    712. 

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

    713. 

  713. 					$c = 1;

    714. 

  714. 				}

    715. 

  715. 			}

    716. 

  716. 			

    717. 

  717. 		}

    718. 

  718. 		// ???????? ?????

    719. 

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

    720. 

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

    721. 

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

    722. 

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

    723. 

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

    724. 

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

    725. 

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

    726. 

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

    727. 

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

    728. 

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

    729. 

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

    730. 

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

    731. 

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

    732. 

  732. 		}

    733. 

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

    734. 

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

    735. 

  735. 		

    736. 

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

    737. 

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

    738. 

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

    739. 

  739. 		fclose($this->fh_log);

    740. 

  740. 		fclose($this->fh_rtl);

    741. 

  741. 	}

    742. 

  742. 	function runRestoreJobForeign($continue = false){

    743. 

  743. 		$ei = false;

    744. 

  744. 		

    745. 

  745. 		$fcache = '';

    746. 

  746. 		$writes = 0;

    747. 

  747. 		$old_charset = '';

    748. 

  748. 		$tab = '';

    749. 

  749. 		$seek = 0;

    750. 

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

    751. 

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

    752. 

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

    753. 

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

    754. 

  754. 		$c = 0;

    755. 

  755. 		

    756. 

  756. 		$log_sql = false;

    757. 

  757. 		$fields = '';

    758. 

  758. 		$insert = '';

    759. 

  759. 		$last_tab = '';

    760. 

  760. 		$time_old = time();

    761. 

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

    762. 

  762. 		$delimiter = ";\n";

    763. 

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

    764. 

  764. 			$q = ltrim($q);

    765. 

  765. 			if(empty($q)) break;

    766. 

  766. 			if($time_old < time()) {

    767. 

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

    768. 

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

    769. 

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

    770. 

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

    771. 

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

    772. 

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

    773. 

  773. 					/*if($type == 1) {

    774. 

  774. 						

    775. 

  775. 					}*/

    776. 

  776. 					unset($this->rtl);

    777. 

  777. 					exit;

    778. 

  778. 				}

    779. 

  779. 				$time_old = time();

    780. 

  780. 				if($time_old >= $exit_time){

    781. 

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

    782. 

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

    783. 

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

    784. 

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

    785. 

  785. 					unset($this->rtl);

    786. 

  786. 					exit;

    787. 

  787. 				}

    788. 

  788. 				clearstatcache(); 

    789. 

  789. 			}

    790. 

  790. 			do {

    791. 

  791. 				$repeat = false;

    792. 

  792. 				switch($q{0}){

    793. 

  793. 					case '(':

    794. 

  794. 						if($continue) {

    795. 

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

    796. 

  796. 							$continue = false;

    797. 

  797. 						}

    798. 

  798. 						$q = $insert . $q;

    799. 

  799. 						$ex = 1;

    800. 

  800. 						$c = 1;

    801. 

  801. 						break;	

    802. 

  802. 					case 'I':

    803. 

  803. 					

    804. 

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

    805. 

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

    806. 

  806. 							$tab = $m[3];

    807. 

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

    808. 

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

    809. 

  809. 							$ex = 1;

    810. 

  810. 						}

    811. 

  811. 						break;

    812. 

  812. 					case 'C':

    813. 

  813. 						$ex = 1;

    814. 

  814. 						$ei = 1;

    815. 

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

    816. 

  816. 							$ex = 1;

    817. 

  817. 							$tab = $m[1];

    818. 

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

    819. 

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

    820. 

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

    821. 

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

    822. 

  822. 							}

    823. 

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

    824. 

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

    825. 

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

    826. 

  826. 								}

    827. 

  827. 							}

    828. 

  828. 						}

    829. 

  829. 						break;

    830. 

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

    831. 

  831. 					case '#':

    832. 

  832. 						$repeat = true;

    833. 

  833. 						$q = ltrim(substr($q, strpos($q, "\n")));

    834. 

  834. 						$ex = 0;

    835. 

  835. 						break;

    836. 

  836. 					case '/':

    837. 

  837. 					case 'S':

    838. 

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

    839. 

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

    840. 

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

    841. 

  841. 							$ex = 0;

    842. 

  842. 						}

    843. 

  843. 						else $ex = 1;

    844. 

  844. 					break;

    845. 

  845. 					default: 

    846. 

  846. 						$insert = '';

    847. 

  847. 						$ex = 1;

    848. 

  848. 						$ei = 0;

    849. 

  849. 				}

    850. 

  850. 			}  while ($repeat);

    851. 

  851. 			if($ex) {

    852. 

  852. 				//error_log("-----------------\n{$q}\n", 3, "sql.log");

    853. 

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

    854. 

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

    855. 

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

    856. 

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

    857. 

  857. 				if(mysql_query($q)) {

    858. 

  858. 					if($insert) {

    859. 

  859. 						$c = 1;

    860. 

  860. 					}

    861. 

  861. 				}

    862. 

  862. 				else {

    863. 

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

    864. 

  864. 					sxd_my_error();

    865. 

  865. 				}

    866. 

  866. 				

    867. 

  867. 				if($c){

    868. 

  868. 					$i = mysql_affected_rows();

    869. 

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

    870. 

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

    871. 

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

    872. 

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

    873. 

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

    874. 

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

    875. 

  875. 					$c = 1;

    876. 

  876. 				}

    877. 

  877. 			}

    878. 

  878. 			

    879. 

  879. 		}

    880. 

  880. 		

    881. 

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

    882. 

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

    883. 

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

    884. 

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

    885. 

  885. 		

    886. 

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

    887. 

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

    888. 

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

    889. 

  889. 		fclose($this->fh_log);

    890. 

  890. 		fclose($this->fh_rtl);

    891. 

  891. 	}

    892. 

  892. 	function addBackupJob($job) {

    893. 

  893. 		$this->closeConnect();

    894. 

  894. 		// ??????? ????? ???????

    895. 

  895. 		$this->JOB = $job;

    896. 

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

    897. 

  897. 		// ??????? ?????? ???????? ? ??????

    898. 

  898. 		$filter = $object = array();

    899. 

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

    900. 

  900. 		$queries = array(

    901. 

  901. 			array('TABLE STATUS', 'Name', 'TA')

    902. 

  902. 		);

    903. 

  903. 		if (V_MYSQL > 50014) {

    904. 

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

    905. 

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

    906. 

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

    907. 

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

    908. 

  908. 		}

    909. 

  909. 		$todo = $header = array();

    910. 

  910. 		$tabs = $rows = 0;

    911. 

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

    912. 

  912. 		foreach($queries AS $query){

    913. 

  913. 			$t = $query[2];

    914. 

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

    915. 

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

    916. 

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

    917. 

  917. 			if (!$r) continue;

    918. 

  918. 			$todo[$t] = array();

    919. 

  919. 			$header[$t] = array();

    920. 

  920. 			

    921. 

  921. 			while($item = mysql_fetch_assoc($r)){

    922. 

  922. 				$n = $item[$query[1]];

    923. 

  923. 				switch($t){

    924. 

  924. 					case 'TA':

    925. 

  925. 					case 'TC':

    926. 

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

    927. 

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

    928. 

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

    929. 

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

    930. 

  930. 							}

    931. 

  931. 							continue;

    932. 

  932. 						}

    933. 

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

    934. 

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

    935. 

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

    936. 

  936. 						}

    937. 

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

    938. 

  938. 							$t = 'TC';

    939. 

  939. 							$item['Rows'] = $item['Data_length'] = '';

    940. 

  940. 						}

    941. 

  941. 						else continue;

    942. 

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

    943. 

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

    944. 

  944. 						$tabs++;

    945. 

  945. 						$rows += $item['Rows'];

    946. 

  946. 					break;

    947. 

  947. 					default:

    948. 

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

    949. 

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

    950. 

  950. 							$header[$t][] = $n;

    951. 

  951. 						}

    952. 

  952. 				}

    953. 

  953. 			}

    954. 

  954. 			

    955. 

  955. 		}

    956. 

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

    957. 

  957. 			// ????? ???????, ????? ????????????? ?????????

    958. 

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

    959. 

  959. 			$views = $dumped = $views_collation = array();

    960. 

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

    961. 

  961. 			while($item = mysql_fetch_assoc($r)){

    962. 

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

    963. 

  963. 				$used = $m[1];	

    964. 

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

    965. 

  965. 				$views[$item['table_name']] = $used;

    966. 

  966. 			}

    967. 

  967. 			

    968. 

  968. 			while (count($views) > 0) {

    969. 

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

    970. 

  970. 					$can_dumped = true;

    971. 

  971. 					foreach($view AS $k) {

    972. 

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

    973. 

  973. 					}

    974. 

  974. 					if ($can_dumped) {

    975. 

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

    976. 

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

    977. 

  977. 							$header['VI'][] = $n;

    978. 

  978. 						}

    979. 

  979. 						$dumped[$n] = 1;

    980. 

  980. 						unset($views[$n]);

    981. 

  981. 					}

    982. 

  982. 				}

    983. 

  983. 			}

    984. 

  984. 			unset($dumped);

    985. 

  985. 			unset($views);

    986. 

  986. 			unset($views_collation);

    987. 

  987. 		}

    988. 

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

    989. 

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

    990. 

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

    991. 

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

    992. 

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

    993. 

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

    994. 

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

    995. 

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

    996. 

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

    997. 

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

    998. 

  998. 		$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, mysql_escape_string($this->JOB['comment']))) . "\n";

    999. 

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

    1000. 

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

    1001. 

  1001. 		}

    1002. 

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

    1003. 

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

    1004. 

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

    1005. 

  1005. 		$fcache .= "#EOH\n\n";

    1006. 

  1006. 		$this->write($fcache);

    1007. 

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

    1008. 

  1008. 		$this->runBackupJob();

    1009. 

  1009. 	}

    1010. 

  1010. 	function runBackupJob($continue = false){

    1011. 

  1011. 		if($continue){

    1012. 

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

    1013. 

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

    1014. 

  1014. 		}

    1015. 

  1015. 		mysql_query("SET SQL_QUOTE_SHOW_CREATE = 1");

    1016. 

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

    1017. 

  1017. 		$fcache = '';

    1018. 

  1018. 		$writes = 0;

    1019. 

  1019. 		

    1020. 

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

    1021. 

  1021. 		$time_old = time();

    1022. 

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

    1023. 

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

    1024. 

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

    1025. 

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

    1026. 

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

    1027. 

  1027. 			foreach($o AS $n){ 

    1028. 

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

    1029. 

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

    1030. 

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

    1031. 

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

    1032. 

  1032. 				}

    1033. 

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

    1034. 

  1034. 				// ?????? ?????

    1035. 

  1035. 				switch($n[0]){

    1036. 

  1036. 					case 'TC':

    1037. 

  1037. 					case 'TD': 				

    1038. 

  1038. 					case 'TA':

    1039. 

  1039. 						$from = '';

    1040. 

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

    1041. 

  1041. 							// ????? ????????? ???????

    1042. 

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

    1043. 

  1043. 							$item = mysql_fetch_assoc($r);

    1044. 

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

    1045. 

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

    1046. 

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

    1047. 

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

    1048. 

  1048. 						    // ??????? ?????? ???????

    1049. 

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

    1050. 

  1050. 						}

    1051. 

  1051. 						else {

    1052. 

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

    1053. 

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

    1054. 

  1054. 						}

    1055. 

  1055. 						// ?????????? ???? ?????

    1056. 

  1056. 						$notNum = array();

    1057. 

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

    1058. 

  1058. 			            $fields = 0;

    1059. 

  1059. 			            while($col = mysql_fetch_array($r)) {

    1060. 

  1060. 			            	// TODO: ????????? ???? SET, ENUM ? BIT

    1061. 

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

    1062. 

  1062.             				$fields++;

    1063. 

  1063. 			            }

    1064. 

  1064. 			            $time_old = time();

    1065. 

  1065. 			            $z = 0;

    1066. 

  1066. 			            // ??????? ??????

    1067. 

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

    1068. 

  1068. 			            while($row = mysql_fetch_row($r)) {

    1069. 

  1069. 			            	 if (strlen($fcache) >= 61440) {

    1070. 

  1070. 			            	 	$z = 0;

    1071. 

  1071. 								if($time_old < time()) {

    1072. 

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

    1073. 

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

    1074. 

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

    1075. 

  1075. 										$this->write($fcache);

    1076. 

  1076. 										if($type == 1) {

    1077. 

  1077. 											

    1078. 

  1078. 										}

    1079. 

  1079. 										unset($this->rtl);

    1080. 

  1080. 										exit;

    1081. 

  1081. 									}

    1082. 

  1082. 									$time_old = time();

    1083. 

  1083. 									if($time_old >= $exit_time){

    1084. 

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

    1085. 

  1085. 										$this->write($fcache);

    1086. 

  1086. 										unset($this->rtl);

    1087. 

  1087. 										exit;

    1088. 

  1088. 									}

    1089. 

  1089. 									clearstatcache(); 

    1090. 

  1090. 								}

    1091. 

  1091. 								$this->write($fcache); 

    1092. 

  1092. 							}

    1093. 

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

    1094. 

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

    1095. 

  1095. 								elseif($notNum[$k]) {$row[$k] =  '\'' . mysql_escape_string($row[$k]) . '\'';}

    1096. 

  1096. 							}

    1097. 

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

    1098. 

  1098. 							$this->rtl[7]++;  

    1099. 

  1099. 							$this->rtl[10]++;

    1100. 

  1100. 						}

    1101. 

  1101. 						unset($row);

    1102. 

  1102. 						mysql_free_result($r);

    1103. 

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

    1104. 

  1104. 					break;

    1105. 

  1105. 

    1106. 

  1106. 					/*case 'VI':

    1107. 

  1107. 					case 'PR': 

    1108. 

  1108. 					case 'FU':

    1109. 

  1109. 					case 'EV':

    1110. 

  1110. 					case 'TR':*/

    1111. 

  1111. 					default:

    1112. 

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

    1113. 

  1113. 							// SHOW CREATE TRIGGER ??????????? ?? MySQL 5.1.21

    1114. 

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

    1115. 

  1115. 							$item = mysql_fetch_assoc($r);

    1116. 

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

    1117. 

  1117. 						}

    1118. 

  1118. 						else {

    1119. 

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

    1120. 

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

    1121. 

  1121. 							$item = mysql_fetch_assoc($r);

    1122. 

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

    1123. 

  1123. 						}

    1124. 

  1124. 				}

    1125. 

  1125. 				

    1126. 

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

    1127. 

  1127. 			}

    1128. 

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

    1129. 

  1129. 		}

    1130. 

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

    1131. 

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

    1132. 

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

    1133. 

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

    1134. 

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

    1135. 

  1135. 		$this->write($fcache);

    1136. 

  1136. 		fclose($this->fh_tmp);

    1137. 

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

    1138. 

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

    1139. 

  1139. 		

    1140. 

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

    1141. 

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

    1142. 

  1142.             $deldate = '';

    1143. 

  1143.             if (!empty($this->JOB['del_time'])){ // ???????? ?? ????

    1144. 

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

    1145. 

  1145.             }

    1146. 

  1146.             $deleted = false;

    1147. 

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

    1148. 

  1148.                 $files = array();

    1149. 

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

    1150. 

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

    1151. 

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

    1152. 

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

    1153. 

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

    1154. 

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

    1155. 

  1155.                             $deleted = true;

    1156. 

  1156.                         }

    1157. 

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

    1158. 

  1158.                     }

    1159. 

  1159.                 }

    1160. 

  1160.                 closedir($dh);

    1161. 

  1161.                 // ????????? ????? ?? ???? ? ??????? ????? ??????

    1162. 

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

    1163. 

  1163.                     ksort($files);

    1164. 

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

    1165. 

  1165.                     foreach ($files AS $file){

    1166. 

  1166.                         if ($file_to_delete-- > 0){ 

    1167. 

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

    1168. 

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

    1169. 

  1169.                             $deleted = true;

    1170. 

  1170.                         }

    1171. 

  1171.                     }

    1172. 

  1172.                 }

    1173. 

  1173.             }

    1174. 

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

    1175. 

  1175. 		}

    1176. 

  1176. 		fclose($this->fh_log);

    1177. 

  1177. 		fclose($this->fh_rtl);

    1178. 

  1178. 	}

    1179. 

  1179. 	function setNames($collation){

    1180. 

  1180. 		if(empty($collation)) return;

    1181. 

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

    1182. 

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

    1183. 

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

    1184. 

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

    1185. 

  1185. 		}

    1186. 

  1186. 	}

    1187. 

  1187. 	function write(&$str){

    1188. 

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

    1189. 

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

    1190. 

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

    1191. 

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

    1192. 

  1192. 		$str = '';

    1193. 

  1193. 	}

    1194. 

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

    1195. 

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

    1196. 

  1196. 	}

    1197. 

  1197. 	function getDBList(){

    1198. 

  1198. 		$dbs = $items = array();

    1199. 

  1199.         if (!V_MYSQL) return $dbs; 

    1200. 

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

    1201. 

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

    1202. 

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

    1203. 

  1203. 			foreach($tmp AS $d){

    1204. 

  1204. 				$d = trim($d);

    1205. 

  1205. 				$items[] = $qq . mysql_escape_string($d) . $qq;

    1206. 

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

    1207. 

  1207. 			}

    1208. 

  1208. 		}

    1209. 

  1209. 		else{

    1210. 

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

    1211. 

  1211.     		while($item = mysql_fetch_row($result)){

    1212. 

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

    1213. 

  1213.     			$items[] = $qq . mysql_escape_string($item[0]) . $qq;

    1214. 

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

    1215. 

  1215.     		}	

    1216. 

  1216. 		}

    1217. 

  1217. 		if(V_MYSQL < 50000){

    1218. 

  1218. 			foreach($items AS $item){

    1219. 

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

    1220. 

  1220.     			if ($tables) {

    1221. 

  1221.     	  			$tabs = mysql_num_rows($tables);

    1222. 

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

    1223. 

  1223.     	  		}

    1224. 

  1224. 			}

    1225. 

  1225. 		}

    1226. 

  1226. 		else {

    1227. 

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

    1228. 

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

    1229. 

  1229. 			while($item = mysql_fetch_row($result)){

    1230. 

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

    1231. 

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

    1232. 

  1232.     		}

    1233. 

  1233. 		}

    1234. 

  1234. 	    return $dbs;

    1235. 

  1235. 	}

    1236. 

  1236. 	function getCharsetList(){

    1237. 

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

    1238. 

  1238. 		if (!V_MYSQL) return $tmp; 

    1239. 

  1239. 		if(V_MYSQL > 40101) {

    1240. 

  1240. 			$def_charsets = '';

    1241. 

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

    1242. 

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

    1243. 

  1243. 			}

    1244. 

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

    1245. 

  1245.     		if ($r) {

    1246. 

  1246.     			while($item = mysql_fetch_assoc($r)){

    1247. 

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

    1248. 

  1248.     			}

    1249. 

  1249. 			}

    1250. 

  1250. 		}

    1251. 

  1251. 	    return $tmp;

    1252. 

  1252. 	}

    1253. 

  1253. 	function getCollationList(){

    1254. 

  1254. 		$tmp = array(); 

    1255. 

  1255. 		if (!V_MYSQL) return $tmp; 

    1256. 

  1256. 		if(V_MYSQL > 40101) {

    1257. 

  1257. 			$def_charsets = '';

    1258. 

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

    1259. 

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

    1260. 

  1260. 			}

    1261. 

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

    1262. 

  1262.     		if ($r) {

    1263. 

  1263.     			while($item = mysql_fetch_assoc($r)){

    1264. 

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

    1265. 

  1265.     			}

    1266. 

  1266. 			}

    1267. 

  1267. 		}

    1268. 

  1268. 	    return $tmp;

    1269. 

  1269. 	}

    1270. 

  1270. 	function getObjects($tree, $db_name){

    1271. 

  1271. 		mysql_select_db($db_name);

    1272. 

  1272. 		// ??????? ???????

    1273. 

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

    1274. 

  1274. 		$tab_prefix_last = $tab_prefix = '*';

    1275. 

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

    1276. 

  1276. 		if($r){

    1277. 

  1277. 			while($item = mysql_fetch_assoc($r)){

    1278. 

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

    1279. 

  1279. 					$objects['VI'][]= $item['Name'];

    1280. 

  1280. 				}

    1281. 

  1281. 				else{

    1282. 

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

    1283. 

  1283. 				} 

    1284. 

  1284. 			}

    1285. 

  1285. 			

    1286. 

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

    1287. 

  1287. 				$shows = array(

    1288. 

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

    1289. 

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

    1290. 

  1290. 					'TRIGGERS'

    1291. 

  1291. 				);

    1292. 

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

    1293. 

  1293. 				// TODO: ????????? ???????? ??????? ? ?????????

    1294. 

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

    1295. 

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

    1296. 

  1296. 					if($r && mysql_num_rows($r) > 0) {

    1297. 

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

    1298. 

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

    1299. 

  1299. 						while($item = mysql_fetch_assoc($r)){

    1300. 

  1300. 							$objects[$type][] = $item[$col_name];	

    1301. 

  1301. 						}

    1302. 

  1302. 					}

    1303. 

  1303. 				}

    1304. 

  1304. 			}

    1305. 

  1305. 			else {

    1306. 

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

    1307. 

  1307. 			}

    1308. 

  1308. 		}

    1309. 

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

    1310. 

  1310. 	}

    1311. 

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

    1312. 

  1312. 		// ??????? ???????

    1313. 

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

    1314. 

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

    1315. 

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

    1316. 

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

    1317. 

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

    1318. 

  1318. 		$temp = fread($fp, 60000);

    1319. 

  1319. 		// ?????? ????? Sypex Dumper 2 - SXD20

    1320. 

  1320. 		//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;";

    1321. 

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

    1322. 

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

    1323. 

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

    1324. 

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

    1325. 

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

    1326. 

  1326. 			}

    1327. 

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

    1328. 

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

    1329. 

  1329. 			}

    1330. 

  1330. 		}

    1331. 

  1331. 		else {

    1332. 

  1332. 			$h[9] = '';

    1333. 

  1333. 		}

    1334. 

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

    1335. 

  1335. 	}

    1336. 

  1336. 	function formatTree($tree, &$objects){

    1337. 

  1337. 		$obj = '';

    1338. 

  1338. 		$pid = $row = 1;

    1339. 

  1339. 		$info = array(

    1340. 

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

    1341. 

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

    1342. 

  1342. 			'PR' => array($this->LNG['obj_procs'], 5), 

    1343. 

  1343. 			'FU' => array($this->LNG['obj_funcs'], 7), 

    1344. 

  1344. 			'TR' => array($this->LNG['obj_trigs'], 9), 

    1345. 

  1345. 			'EV' => array($this->LNG['obj_events'], 11)

    1346. 

  1346. 		);

    1347. 

  1347. 		// ??????? ??????? ? ??????????

    1348. 

  1348. 		$tab_prefix_last = $tab_prefix = '*';

    1349. 

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

    1350. 

  1350. 			$t = $objects['TA'][$i];

    1351. 

  1351. 			$tab_prefix = preg_match("/^([a-z0-9]+_)/", $t[0], $m) ? $m[1] : '*';

    1352. 

  1352. 			if ($tab_prefix != $tab_prefix_last) {

    1353. 

  1353. 				if ($tab_prefix != '*') $objects['TA']['*'][] = $tab_prefix;

    1354. 

  1354. 				$tab_prefix_last = $tab_prefix;

    1355. 

  1355. 			}

    1356. 

  1356. 			$objects['TA'][$tab_prefix][] = $t;

    1357. 

  1357. 			unset($objects['TA'][$i]);

    1358. 

  1358. 		}

    1359. 

  1359. 		foreach($objects AS $type => $o){

    1360. 

  1360. 			if(!count($o)) continue;

    1361. 

  1361. 			if($type == 'TA') {

    1362. 

  1362. 				$open_childs = count($o['*']) > 1 ? 0 : 1;

    1363. 

  1363. 				$obj .= "[{$row},0,'" . mysql_escape_string($info[$type][0]) . "',1,1,1],";

    1364. 

  1364. 				$row++;

    1365. 

  1365. 				foreach($o['*'] AS $value){

    1366. 

  1366. 					if(is_string($value)){

    1367. 

  1367. 						if(count($o[$value]) > 1)	{

    1368. 

  1368. 							$obj .= "[{$row},1,'{$value}*',1,1,{$open_childs}],";	

    1369. 

  1369. 							$pid = $row++; 

    1370. 

  1370. 							for($i = 0, $l = count($o[$value]); $i < $l; $i++){

    1371. 

  1371. 								$checked = ($o[$value][$i][1] == '' && $o[$value][$i][2] == '') ? 2 : 1;

    1372. 

  1372. 								$obj .= "[{$row},{$pid},'" . mysql_escape_string($o[$value][$i][0]) . "',2,{$checked},{$o[$value][$i][2]}],";

    1373. 

  1373. 								$row++;

    1374. 

  1374. 							}

    1375. 

  1375. 						}

    1376. 

  1376. 						else {

    1377. 

  1377. 							$value = $o[$value][0];	

    1378. 

  1378. 						}

    1379. 

  1379. 					}

    1380. 

  1380. 					//$pid = 1;

    1381. 

  1381. 					if (is_array($value)){

    1382. 

  1382. 						$checked = ($value[1] == '' && $value[2] == '') ? 2 : 1;

    1383. 

  1383. 						$obj .= "[{$row},1,'{$value[0]}',2,{$checked},{$value[2]}],";

    1384. 

  1384. 						$row++;	

    1385. 

  1385. 					}

    1386. 

  1386. 				}

    1387. 

  1387. 			}

    1388. 

  1388. 			else {

    1389. 

  1389. 				$obj .= "[{$row},0,'" . mysql_escape_string($info[$type][0]) . "',{$info[$type][1]},1,1],";

    1390. 

  1390. 				$pid = $row++;

    1391. 

  1391. 				$info[$type][1]++;

    1392. 

  1392. 				for($i = 0, $l = count($o); $i < $l; $i++){

    1393. 

  1393. 					$o[$i] = mysql_escape_string($o[$i]);

    1394. 

  1394. 					$obj .= "[{$row},{$pid},'{$o[$i]}',{$info[$type][1]},1,0],";

    1395. 

  1395. 					$row++;	

    1396. 

  1396. 				}

    1397. 

  1397. 			} 

    1398. 

  1398. 		}

    1399. 

  1399. 		$add = '';

    1400. 

  1400. 		if($tree == 'restore') $add = "z('autoinc').disabled = z('restore_type').disabled = " . ($obj ? 'false' : 'true') . ";";

    1401. 

  1401. 		return ($obj ? 'sxd.tree.' . $tree . '.drawTree([' . substr_replace($obj, ']',  -1) . ");" : "sxd.tree.{$tree}.error(sxd.lng('err_sxd2'));") . $add;	

    1402. 

  1402. 	}

    1403. 

  1403. 	function getFileList(){

    1404. 

  1404. 		$files = array();

    1405. 

  1405. 		if (is_dir($this->CFG['backup_path']) && false !== ($handle = opendir($this->CFG['backup_path']))) {

    1406. 

  1406.             while (false !== ($file = readdir($handle))) {

    1407. 

  1407.                 if (preg_match("/^.+?\.sql(\.(gz|bz2))?$/", $file)) {

    1408. 

  1408.                     $files[$file] = $file;

    1409. 

  1409.                 }

    1410. 

  1410.             }

    1411. 

  1411.             closedir($handle);

    1412. 

  1412.         }

    1413. 

  1413.         ksort($files);

    1414. 

  1414. 		return $files;

    1415. 

  1415. 	}

    1416. 

  1416. 	function getSavedJobs(){

    1417. 

  1417. 		$sj = array('sj_backup' => array(), 'sj_restore' => array(),);

    1418. 

  1418. 		if (is_dir($this->CFG['backup_path']) && false !== ($handle = opendir($this->CFG['backup_path']))) {

    1419. 

  1419.             while (false !== ($file = readdir($handle))) {

    1420. 

  1420.                 if (preg_match("/^sj_(.+?)\.job.php$/", $file)) {

    1421. 

  1421.                 	include($this->CFG['backup_path'] . $file);

    1422. 

  1422.                     $sj['sj_' . $JOB['type']][$JOB['job']] = "<b>{$JOB['job']}</b><br><i>{$JOB['title']}&nbsp;</i>";

    1423. 

  1423.                 }

    1424. 

  1424.             }

    1425. 

  1425.             closedir($handle);

    1426. 

  1426.         }

    1427. 

  1427.         if(count($sj['sj_backup']) > 0){

    1428. 

  1428.         	ksort($sj['sj_backup']);	

    1429. 

  1429. 		}

    1430. 

  1430.         else {

    1431. 

  1431.         	$sj['sj_backup'] = array(0 => '<b>No Saved Jobs</b><br>' . $this->LNG['no_saved']);	

    1432. 

  1432. 		}

    1433. 

  1433. 		if(count($sj['sj_restore']) > 0){

    1434. 

  1434.         	ksort($sj['sj_restore']);	

    1435. 

  1435. 		}

    1436. 

  1436.         else {

    1437. 

  1437.         	$sj['sj_restore'] = array(0 => '<b>No Saved Jobs</b><br>' . $this->LNG['no_saved']);	

    1438. 

  1438. 		}

    1439. 

  1439. 		return "sxd.clearOpt('sj_backup');sxd.clearOpt('sj_restore');sxd.addOpt(" . sxd_php2json($sj) . ");";

    1440. 

  1440. 	}

    1441. 

  1441. 	function getFileListExtended(){

    1442. 

  1442. 		$files = array();

    1443. 

  1443. 		if (is_dir($this->CFG['backup_path']) && false !== ($handle = opendir($this->CFG['backup_path']))) {

    1444. 

  1444.             while (false !== ($file = readdir($handle))) {

    1445. 

  1445.                 if (preg_match("/^.+?\.sql(\.(gz|bz2))?$/", $file, $m)) {

    1446. 

  1446.                     $fp   = $this->openFile($this->CFG['backup_path'] . $file, 'r');

    1447. 

  1447.                     $ext  = !empty($m[2]) ? $m[2] : 'sql';

    1448. 

  1448.                     $temp = fgets($fp);

    1449. 

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

    1450. 

  1450.                     	$h = explode('|', $m[1]);

    1451. 

  1451.                     	$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);	

    1452. 

  1452. 					}

    1453. 

  1453. 					elseif(preg_match('/^(#SKD101\|.+?)\n/s', $temp, $m)){

    1454. 

  1454.                     	$h = explode('|', $m[1]);

    1455. 

  1455.                     	$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);	

    1456. 

  1456. 					}

    1457. 

  1457. 					else {

    1458. 

  1458. 						$files[] = array($file, '-', $ext, '-', '-', filesize($this->CFG['backup_path'] . $file), '', $file);

    1459. 

  1459. 					}

    1460. 

  1460.                 }

    1461. 

  1461.             }

    1462. 

  1462.             closedir($handle);

    1463. 

  1463.         }

    1464. 

  1464.         function s($a, $b){

    1465. 

  1465. 		    return strcmp($b[1], $a[1]);

    1466. 

  1466. 		}

    1467. 

  1467.         usort($files, 's');

    1468. 

  1468. 		return 'sxd.files.clear();sxd.files.add(' . sxd_php2json($files) . ');';

    1469. 

  1469. 	}

    1470. 

  1470. 	function saveJob($job, $config){

    1471. 

  1471. 		$this->saveToFile($this->CFG['backup_path'] . $job . '.job.php', "<?php\n\$JOB = " . var_export($config, true) . ";\n" . "?>");

    1472. 

  1472. 	}

    1473. 

  1473. 	function openFile($name, $mode){

    1474. 

  1474. 		if($mode == 'r') {

    1475. 

  1475. 			if(preg_match('/\.(sql|sql\.bz2|sql\.gz)$/i', $name, $m)) $this->JOB['file_ext'] = strtolower($m[1]);

    1476. 

  1476. 		}

    1477. 

  1477. 		else{

    1478. 

  1478. 			switch($this->JOB['zip']) {

    1479. 

  1479. 				case 0 : $this->JOB['file_ext'] = 'sql'; break;

    1480. 

  1480. 				case 10: $this->JOB['file_ext'] = 'sql.bz2'; break;

    1481. 

  1481. 				default: $this->JOB['file_ext'] = 'sql.gz'; break; 

    1482. 

  1482. 			}

    1483. 

  1483. 		}

    1484. 

  1484. 		switch ($this->JOB['file_ext']){

    1485. 

  1485. 			case 'sql':

    1486. 

  1486. 				return fopen($name, "{$mode}b");

    1487. 

  1487. 				break;

    1488. 

  1488. 			case 'sql.bz2':

    1489. 

  1489. 				return bzopen($name, $mode);

    1490. 

  1490. 				break;

    1491. 

  1491. 			case 'sql.gz':

    1492. 

  1492. 				return gzopen($name, $mode . ($mode == 'w' ? $this->JOB['zip'] : ''));

    1493. 

  1493. 				break;

    1494. 

  1494. 			default: return false;

    1495. 

  1495. 		}

    1496. 

  1496. 	}

    1497. 

  1497. }

    1498. 

  1498. function sxd_read_sql($f, &$seek, $ei, $delimiter = "\t;\n"){

    1499. 

  1499. 	static $l = '';

    1500. 

  1500. 	static $r = 0;

    1501. 

  1501. 	$fs = ftell($f);

    1502. 

  1502. 	$delim_len = strlen($delimiter);

    1503. 

  1503. 	while($r || $s = fread($f, 61440)){

    1504. 

  1504. 		if(!$r) $l .= $s;

    1505. 

  1505. 		$pos = strpos($l, $delimiter);

    1506. 

  1506. 		if ($pos !== false) {

    1507. 

  1507. 			// ???? ????????? ???????

    1508. 

  1508. 			$q = substr($l, 0, $pos);

    1509. 

  1509. 			$l = substr($l, $pos+$delim_len);

    1510. 

  1510. 			$r = 1;

    1511. 

  1511. 			$seek = strlen($l);

    1512. 

  1512. 			return $q;

    1513. 

  1513. 		}

    1514. 

  1514. 		if($ei) {

    1515. 

  1515. 			$pos = strrpos($l, "\n");

    1516. 

  1516. 			if($pos > 0 && $l{$pos-1} === ',') {

    1517. 

  1517. 				// ????????? ?? ???????

    1518. 

  1518. 				$q = substr($l, 0, $pos-1);

    1519. 

  1519. 				$l = substr($l, $pos+1);

    1520. 

  1520. 				$seek = strlen($l);

    1521. 

  1521. 				$r = 0;

    1522. 

  1522. 				return $q;

    1523. 

  1523. 			}

    1524. 

  1524. 		}

    1525. 

  1525. 		$r = 0;	

    1526. 

  1526. 	}

    1527. 

  1527. 	if (!empty($l)) {

    1528. 

  1528. 		return $l;

    1529. 

  1529. 	}

    1530. 

  1530. 	return false;

    1531. 

  1531. }

    1532. 

  1532. function sxd_check($n, $obj, $filt){

    1533. 

  1533. 	return isset($obj[$n]) || ($filt && preg_match($filt, $n));

    1534. 

  1534. }

    1535. 

  1535. function sxd_php2json($obj){

    1536. 

  1536. 	if(count($obj) == 0) return '[]';

    1537. 

  1537. 	$is_obj = isset($obj[count($obj) - 1]) ? false : true;

    1538. 

  1538. 	$str = $is_obj ? '{' : '[';

    1539. 

  1539.     foreach ($obj AS $key  => $value) {

    1540. 

  1540.     	$str .= $is_obj ? "'" . addcslashes($key, "\n\r\t'\\/") . "'" . ':' : ''; 

    1541. 

  1541.         if     (is_array($value))   $str .= sxd_php2json($value);

    1542. 

  1542.         elseif (is_null($value))    $str .= 'null';

    1543. 

  1543.         elseif (is_bool($value))    $str .= $value ? 'true' : 'false';

    1544. 

  1544. 		elseif (is_numeric($value)) $str .= $value;

    1545. 

  1545. 		else                        $str .= "'" . addcslashes($value, "\n\r\t'\\/") . "'";

    1546. 

  1546. 		$str .= ',';

    1547. 

  1547.     }

    1548. 

  1548. 	return  substr_replace($str, $is_obj ? '}' : ']', -1);

    1549. 

  1549. }

    1550. 

  1550. function sxd_ver2int($ver){

    1551. 

  1551. 	return preg_match("/^(\d+)\.(\d+)\.(\d+)/", $ver, $m) ? sprintf("%d%02d%02d", $m[1], $m[2], $m[3]) : 0;

    1552. 

  1552. }

    1553. 

  1553. function sxd_error_handler($errno, $errmsg, $filename, $linenum, $vars){

    1554. 

  1554.     global $SXD;

    1555. 

  1555.     if($SXD->try) return;

    1556. 

  1556.     if(strpos($errmsg, 'timezone settings')) return;

    1557. 

  1557.     $errortype = array(1 => 'Error', 2 => 'Warning', 4 => 'Parsing Error', 8 => 'Notice', 16 => 'Core Error', 32 => 'Core Warning', 64 => 'Compile Error', 

    1558. 

  1558. 					   128 => 'Compile Warning', 256 => 'MySQL Error', 512 => 'Warning', 1024 => 'Notice');

    1559. 

  1559. 	$str = "{$errortype[$errno]}: {$errmsg} ({$filename}:{$linenum})";

    1560. 

  1560. 	if(SXD_DEBUG) error_log("[index.php]\n{$str}\n", 3, "error.log");

    1561. 

  1561. 	

    1562. 

  1562.     if($errno == 8 || $errno == 1024) {

    1563. 

  1563.     	if (!$SXD->fh_log && !$SXD->fh_rtl) echo isset($_POST['ajax']) ? "alert('" . mysql_escape_string($str) . "');" : $str;

    1564. 

  1564.     	else {

    1565. 

  1565.     		fwrite($SXD->fh_log, date('Y.m.d H:i:s') . "\t3\t{$str}\n");

    1566. 

  1566. 		}

    1567. 

  1567. 	}

    1568. 

  1568.     elseif($errno < 1024) {

    1569. 

  1569.     	$SXD->error = true;

    1570. 

  1570.     	if (!$SXD->fh_log && !$SXD->fh_rtl) echo isset($_POST['ajax']) ? "alert('" . mysql_escape_string($str) . "');" : $str;

    1571. 

  1571.     	else {

    1572. 

  1572.     		$SXD->rtl[1] = time();

    1573. 

  1573.     		$SXD->rtl[9] = 5;

    1574. 

  1574.     		fseek($SXD->fh_rtl, 0);

    1575. 

  1575. 			fwrite($SXD->fh_rtl, implode("\t", $SXD->rtl));

    1576. 

  1576.     		fwrite($SXD->fh_log, date('Y.m.d H:i:s') . "\t4\t{$str}\n");

    1577. 

  1577.     		unset($SXD->rtl);

    1578. 

  1578. 		}

    1579. 

  1579. 		

    1580. 

  1580.     	die;

    1581. 

  1581. 	}

    1582. 

  1582. }

    1583. 

  1583. function sxd_my_error(){

    1584. 

  1584. 	trigger_error(mysql_error(), E_USER_ERROR);	

    1585. 

  1585. }

    1586. 

  1586. function sxd_shutdown(){

    1587. 

  1587. 	global $SXD;

    1588. 

  1588. 	if(isset($SXD->fh_rtl) && is_resource($SXD->fh_rtl) && !empty($SXD->rtl) && empty($SXD->error)) {

    1589. 

  1589. 		$SXD->rtl[1] = time();

    1590. 

  1590. 		if(!empty($SXD->JOB['file_stp']) && file_exists(dirname(__FILE__) . '/' . $SXD->JOB['file_stp'])){

    1591. 

  1591. 			$type = file_get_contents(dirname(__FILE__) . '/' . $SXD->JOB['file_stp']);

    1592. 

  1592. 			$SXD->rtl[9] = !empty($type) ? $type : 2;

    1593. 

  1593. 		}

    1594. 

  1594. 		else $SXD->rtl[9] = 5;

    1595. 

  1595. 		fseek($SXD->fh_rtl, 0);

    1596. 

  1596. 		fwrite($SXD->fh_rtl, implode("\t", $SXD->rtl));

    1597. 

  1597. 	}

    1598. 

  1598. }

    1599. 

  1599. function sxd_antimagic($arr){

    1600. 

  1600. 	return is_array($arr) ? array_map('sxd_antimagic', $arr) : stripslashes($arr);

    1601. 

  1601. }

    1602. 

  1602. // Templates

    1603. 

  1603. function sxd_tpl_page(){

    1604. 

  1604. global $SXD;

    1605. 

  1605. return <<<HTML

    1606. 

  1606. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">

    1607. 

  1607. <html>

    1608. 

  1608. <head>

    1609. 

  1609. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">

    1610. 

  1610. <title>{$SXD->name}</title>

    1611. 

  1611. <link rel="stylesheet" type="text/css" href="load.php?sxd.v207.css">

    1612. 

  1612. <script type="text/javascript" src="load.php?sxd.v207.js"></script>

    1613. 

  1613. <script type="text/javascript" src="load.php?{$SXD->LNG['name']}.lng.js"></script>

    1614. 

  1614. <link rel="shortcut icon" href="load.php?favicon.v207.ico">

    1615. 

  1615. </head>

    1616. 

  1616. 

    1617. 

  1617. <body>

    1618. 

  1618. <div id="main_div">

    1619. 

  1619. 	<div id="header">{$SXD->name}</div>

    1620. 

  1620. 	<div id="sxdToolbar"></div>

    1621. 

  1621. 	<div id="name"><div id="loading"></div><b></b></div>

    1622. 

  1622. 	<div id="content" class="content">

    1623. 

  1623. 		<table cellspacing="0" id="tab_backup">

    1624. 

  1624. 			<tr>

    1625. 

  1625. 				<td width="242" valign="top">

    1626. 

  1626. 					<div class="caption">{$SXD->LNG['combo_db']}</div><div id="backup_db"></div>

    1627. 

  1627. 					<div class="caption">{$SXD->LNG['combo_charset']}</div><div id="backup_charset"></div>

    1628. 

  1628. 					<div class="caption">{$SXD->LNG['combo_zip']}</div><div id="backup_zip"></div>

    1629. 

  1629. 					<div class="caption">{$SXD->LNG['combo_comments']}</div>

    1630. 

  1630. 					<div class="border"><textarea cols="10" rows="3" id="backup_comment"></textarea></div>

    1631. 

  1631. 					<div class="caption" style="margin-top:12px;">

    1632. 

  1632. 						<fieldset><legend>{$SXD->LNG['del_legend']}</legend>

    1633. 

  1633. 						<div class="caption">&nbsp;– {$SXD->LNG['del_date']}</div>

    1634. 

  1634. 						<div class="caption">&nbsp;– {$SXD->LNG['del_count']}</div>

    1635. 

  1635. 						</fieldset>

    1636. 

  1636. 					</div>

    1637. 

  1637. 				</td>

    1638. 

  1638. 				<td width="308" valign="top">

    1639. 

  1639. 					<div class="caption">{$SXD->LNG['tree']}</div><div id=backup_tree class="zTree"></div>

    1640. 

  1640. 				</td>

    1641. 

  1641. 			</tr>

    1642. 

  1642. 			<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>

    1643. 

  1643. 		</table>

    1644. 

  1644. 		

    1645. 

  1645. 		<table cellspacing="0" id="tab_restore" style="display:none;">

    1646. 

  1646. 			<tr>

    1647. 

  1647. 				<td width="242" valign="top">

    1648. 

  1648. 					<div class="caption">{$SXD->LNG['combo_db']}</div><div id="restore_db"></div>

    1649. 

  1649. 					<div class="caption">{$SXD->LNG['combo_charset']}</div><div id="restore_charset"></div>

    1650. 

  1650. 					<div class="caption">{$SXD->LNG['combo_file']}</div><div id="restore_file"></div>

    1651. 

  1651. 					<div class="caption">{$SXD->LNG['combo_comments']}</div>

    1652. 

  1652. 					<div class="border"><textarea cols="10" rows="3" id="restore_comment" readonly></textarea></div>

    1653. 

  1653. 					<div class="caption">{$SXD->LNG['combo_strategy']}</div><div id="restore_type"></div>

    1654. 

  1654. 					<div class="caption" style="margin-top:17px;">

    1655. 

  1655. 						<fieldset><legend>{$SXD->LNG['ext_legend']}</legend>

    1656. 

  1656. 						<div class="caption"><label><input type="checkbox" id="correct"> {$SXD->LNG['correct']}</label></div>

    1657. 

  1657. 						<div class="caption"><label><input type="checkbox" id="autoinc"> {$SXD->LNG['autoinc']}</label></div>

    1658. 

  1658. 						</fieldset>

    1659. 

  1659. 					</div>

    1660. 

  1660. 				</td>

    1661. 

  1661. 				<td width="308" valign="top">

    1662. 

  1662. 					<div class="caption">{$SXD->LNG['tree']}</div><div id=restore_tree class="zTree"></div>

    1663. 

  1663. 				</td>

    1664. 

  1664. 			</tr>

    1665. 

  1665. 			<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>

    1666. 

  1666. 		</table>

    1667. 

  1667. 		

    1668. 

  1668. 		<table cellspacing="0" id="tab_log" style="display:none;">

    1669. 

  1669. 			<tr>

    1670. 

  1670. 				<td valign="top" colspan=2>

    1671. 

  1671. 					<div id=sxdGrid1></div> 

    1672. 

  1672. 				</td>

    1673. 

  1673. 			</tr>

    1674. 

  1674. 			<tr><td colspan=2>

    1675. 

  1675. 			<table class=progress>

    1676. 

  1676. 				<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>

    1677. 

  1677. 				<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>

    1678. 

  1678. 			</table>

    1679. 

  1679. 			</td></tr>

    1680. 

  1680. 			<tr><td width="152"><input type="button" value="{$SXD->LNG['btn_clear']}" onclick="sxd.log.clear();"></td><td width="380" align="right">

    1681. 

  1681. 			<input type="button" value="{$SXD->LNG['btn_download']}" id="btn_down" onclick="sxd.runFiles('download', this.file);" style="display:none;">

    1682. 

  1682. 			<input type="button" value="{$SXD->LNG['btn_again']}" id="btn_again" onclick="sxd.runAgain();" disabled>

    1683. 

  1683. 			<input type="button" value="{$SXD->LNG['btn_stop']}" id="btn_stop" onclick="sxd.stopJob();" disabled>

    1684. 

  1684. 			<input type="button" value="{$SXD->LNG['btn_pause']}" id="btn_pause" onclick="sxd.pauseJob();" disabled>

    1685. 

  1685. 			<input type="button" value="{$SXD->LNG['btn_resume']}" id="btn_resume" onclick="sxd.resumeJob();" style="display:none;">

    1686. 

  1686. 			</td></tr>

    1687. 

  1687. 		</table>

    1688. 

  1688. 		<table cellspacing="0" id="tab_result" style="display:none;">

    1689. 

  1689. 			<tr>

    1690. 

  1690. 				<td valign="top">

    1691. 

  1691. 					<div id=sxdGrid3></div> 

    1692. 

  1692. 				</td>

    1693. 

  1693. 			</tr>

    1694. 

  1694. 			<tr><td>

    1695. 

  1695. 			<input type="button" value="{$SXD->LNG['btn_clear']}" onclick="sxd.result.clear();">

    1696. 

  1696. 			</td></tr>

    1697. 

  1697. 		</table>

    1698. 

  1698. 		

    1699. 

  1699. 		<table cellspacing="0" id="tab_files" style="display:none;">

    1700. 

  1700. 			<tr>

    1701. 

  1701. 				<td valign="top" colspan=2>

    1702. 

  1702. 					<div id=sxdGrid2></div> 

    1703. 

  1703. 				</td>

    1704. 

  1704. 			</tr>

    1705. 

  1705. 			<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">

    1706. 

  1706. 			<input type="button" value="{$SXD->LNG['btn_download']}" onclick="sxd.runFiles('download')">

    1707. 

  1707. 			<input type="button" value="{$SXD->LNG['btn_open']}" onclick="sxd.runFiles('open')">

    1708. 

  1708. 			</td></tr>

    1709. 

  1709. 		</table>

    1710. 

  1710. 		

    1711. 

  1711. 		

    1712. 

  1712. 		<table cellspacing="0" id="tab_services" style="display:none;">

    1713. 

  1713. 			<tr>

    1714. 

  1714. 				<td width="242" valign="top">

    1715. 

  1715. 					<div class="caption">{$SXD->LNG['combo_db']}</div><div id="services_db"></div>

    1716. 

  1716. 					<br>

    1717. 

  1717. 					<div class="caption">{$SXD->LNG['opt_check']}</div><div id="services_check"></div>

    1718. 

  1718. 					<div class="caption">{$SXD->LNG['opt_repair']}</div><div id="services_repair"></div>

    1719. 

  1719. 				</td>

    1720. 

  1720. 				<td width="308" valign="top">

    1721. 

  1721. 					<div class="caption">{$SXD->LNG['tree']}</div><div id=services_tree class="zTree"></div>

    1722. 

  1722. 				</td>

    1723. 

  1723. 			</tr>

    1724. 

  1724. 			<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>

    1725. 

  1725. 		</table>

    1726. 

  1726. 		<table cellspacing="0" id="tab_options" style="display:none;">

    1727. 

  1727. 			<tr>

    1728. 

  1728. 				<td valign="top" colspan=2>

    1729. 

  1729. 					<div style="height: 341px;">

    1730. 

  1730. 					<fieldset>

    1731. 

  1731. 					<legend>{$SXD->LNG['cfg_legend']}</legend>

    1732. 

  1732. 						<table cellspacing="0">

    1733. 

  1733. 							<tr>

    1734. 

  1734. 								<td width=190>{$SXD->LNG['cfg_time_web']}</td>

    1735. 

  1735. 								<td width=45><input type="text" id="time_web" style="width:40px;"></td>

    1736. 

  1736. 								<td align="right">{$SXD->LNG['cfg_time_cron']}</td>

    1737. 

  1737. 								<td width=40 align="right"><input type="text" id="time_cron" style="width:40px;"></td>

    1738. 

  1738. 							</tr>

    1739. 

  1739. 							<tr>

    1740. 

  1740. 								<td>{$SXD->LNG['cfg_backup_path']}</td>

    1741. 

  1741. 								<td colspan=3><input type="text" id="backup_path" style="width:351px;"></td>

    1742. 

  1742. 							</tr>

    1743. 

  1743. 							<tr>

    1744. 

  1744. 								<td>{$SXD->LNG['cfg_backup_url']}</td>

    1745. 

  1745. 								<td colspan=3><input type="text" id="backup_url" style="width:351px;"></td>

    1746. 

  1746. 							</tr>

    1747. 

  1747. 							<tr>

    1748. 

  1748. 								<td>{$SXD->LNG['cfg_globstat']}</td>

    1749. 

  1749. 								<td colspan=3><input type="checkbox" id="globstat" value="1"></td>

    1750. 

  1750. 							</tr>

    1751. 

  1751. 						</table>

    1752. 

  1752. 					</fieldset>

    1753. 

  1753. 					<fieldset>

    1754. 

  1754. 					<legend>{$SXD->LNG['cfg_confirm']}</legend>

    1755. 

  1755. 						<table cellspacing="0">

    1756. 

  1756. 							<tr>

    1757. 

  1757. 								<td width="33%"><label><input type="checkbox" id="conf_import" value="1"> {$SXD->LNG['cfg_conf_import']}</label></td>

    1758. 

  1758. 								<td width="34%"><label><input type="checkbox" id="conf_file" value="1"> {$SXD->LNG['cfg_conf_file']}</label></td>

    1759. 

  1759. 								<td width="33%"><label><input type="checkbox" id="conf_db" value="1"> {$SXD->LNG['cfg_conf_db']}</label></td>

    1760. 

  1760. 							</tr>

    1761. 

  1761. 						</table>

    1762. 

  1762. 					</fieldset>

    1763. 

  1763. 					<fieldset>

    1764. 

  1764. 					<legend>{$SXD->LNG['cfg_extended']}</legend>

    1765. 

  1765. 						<table cellspacing="0">

    1766. 

  1766. 							<tr>

    1767. 

  1767. 								<td width=190>{$SXD->LNG['cfg_charsets']}</td>

    1768. 

  1768. 								<td><input type="text" id="charsets" value="" style="width:351px;"></td>

    1769. 

  1769. 							</tr>

    1770. 

  1770. 							<tr>

    1771. 

  1771. 								<td>{$SXD->LNG['cfg_only_create']}</td>

    1772. 

  1772. 								<td><input type="text" id="only_create" value="" style="width:351px;"></td>

    1773. 

  1773. 							</tr>

    1774. 

  1774. 							<tr>

    1775. 

  1775. 								<td>{$SXD->LNG['cfg_auth']}</td>

    1776. 

  1776. 								<td><input type="text" id="auth" value="" style="width:351px;"></td>

    1777. 

  1777. 							</tr>

    1778. 

  1778. 						</table>

    1779. 

  1779. 					</fieldset>

    1780. 

  1780. 					</div>

    1781. 

  1781. 				</td>

    1782. 

  1782. 			</tr>

    1783. 

  1783. 			<tr><td align="right" colspan=2><input type="button" value="{$SXD->LNG['btn_save']}" onclick="sxd.saveOptions();"></td></tr>

    1784. 

  1784. 		</table>

    1785. 

  1785. 	</div>

    1786. 

  1786. </div>

    1787. 

  1787. 

    1788. 

  1788. <div id="overlay"></div>

    1789. 

  1789. <div class="dialog" id ="dia_connect">

    1790. 

  1790. 	<div class="header">{$SXD->LNG['con_header']}</div>

    1791. 

  1791. 	<div class="content">

    1792. 

  1792. 		<table cellspacing="5">

    1793. 

  1793. 			<tr>

    1794. 

  1794. 				<td valign="top">

    1795. 

  1795. 				<fieldset>

    1796. 

  1796. 				<legend>{$SXD->LNG['connect']}</legend>

    1797. 

  1797. 					<table cellspacing="3">

    1798. 

  1798. 						<tr>

    1799. 

  1799. 							<td width="80">{$SXD->LNG['my_host']}</td>

    1800. 

  1800. 							<td width="126"><input type="text" id="con_host" style="width:120px;"></td>

    1801. 

  1801. 							<td width="40" align="right">{$SXD->LNG['my_port']}</td>

    1802. 

  1802. 							<td width="36"><input type="text" id="con_port" maxlength="5" style="width:30px;"></td>

    1803. 

  1803. 						</tr>

    1804. 

  1804. 						<tr>

    1805. 

  1805. 							<td>{$SXD->LNG['my_user']}</td>

    1806. 

  1806. 							<td colspan="3"><input type="text" id="con_user" name="user" style="width:202px;"></td>

    1807. 

  1807. 						</tr>

    1808. 

  1808. 						<tr>

    1809. 

  1809. 							<td>{$SXD->LNG['my_pass']}</td>

    1810. 

  1810. 							<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>

    1811. 

  1811. 						</tr>

    1812. 

  1812. 						<tr>

    1813. 

  1813. 							<td></td>

    1814. 

  1814. 							<td colspan="3"><label><input type="checkbox" id="con_comp" value="1"> {$SXD->LNG['my_comp']}</label></td>

    1815. 

  1815. 						</tr>

    1816. 

  1816. 						<tr>

    1817. 

  1817. 							<td>{$SXD->LNG['my_db']}</td>

    1818. 

  1818. 							<td colspan="3"><input type="text" id="con_db" style="width:202px;"></td>

    1819. 

  1819. 						</tr>

    1820. 

  1820. 					</table></fieldset>

    1821. 

  1821. 				</td>

    1822. 

  1822. 			</tr>

    1823. 

  1823. 			<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>

    1824. 

  1824. 		</table>

    1825. 

  1825. 	</div>

    1826. 

  1826. </div>

    1827. 

  1827. <div class="dialog" id ="dia_savejob">

    1828. 

  1828. 	<div class="header">{$SXD->LNG['sj_header']}</div>

    1829. 

  1829. 	<div class="content">

    1830. 

  1830. 		<table cellspacing="5">

    1831. 

  1831. 			<tr>

    1832. 

  1832. 				<td valign="top">

    1833. 

  1833. 				<fieldset>

    1834. 

  1834. 				<legend>{$SXD->LNG['sj_job']}</legend>

    1835. 

  1835. 					<table cellspacing="3">

    1836. 

  1836. 						<tr>

    1837. 

  1837. 							<td width="80">{$SXD->LNG['sj_name']}</td>

    1838. 

  1838. 							<td><input type="text" id="sj_name" style="width:202px;" maxlength="12" value=""></td>

    1839. 

  1839. 						</tr>

    1840. 

  1840. 						<tr>

    1841. 

  1841. 							<td>{$SXD->LNG['sj_title']}</td>

    1842. 

  1842. 							<td><input type="text" id="sj_title" maxlength="64" style="width:202px;"></td>

    1843. 

  1843. 						</tr>

    1844. 

  1844. 					</table></fieldset>

    1845. 

  1845. 				</td>

    1846. 

  1846. 			</tr>

    1847. 

  1847. 			<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>

    1848. 

  1848. 		</table>

    1849. 

  1849. 	</div>

    1850. 

  1850. </div>

    1851. 

  1851. <div class=dialog id="dia_createdb">

    1852. 

  1852. 	<div class="header">{$SXD->LNG['cdb_header']}</div>

    1853. 

  1853. 	<div class="content">

    1854. 

  1854. 		<table cellspacing="5">

    1855. 

  1855. 			<tr>

    1856. 

  1856. 				<td valign="top">

    1857. 

  1857. 				<fieldset>

    1858. 

  1858. 				<legend>{$SXD->LNG['cdb_detail']}</legend>

    1859. 

  1859. 					<table cellspacing="3">

    1860. 

  1860. 						<tr>

    1861. 

  1861. 							<td width="80">{$SXD->LNG['cdb_name']}</td>

    1862. 

  1862. 							<td width="202"><input type="text" id="db_name" value="my_db_1" style="width:202px;"></td>

    1863. 

  1863. 						</tr>

    1864. 

  1864. 						<tr>

    1865. 

  1865. 							<td>{$SXD->LNG['combo_charset']}</td>

    1866. 

  1866. 							<td><div id="db_charset"></div></td>

    1867. 

  1867. 						</tr>

    1868. 

  1868. 						<tr>

    1869. 

  1869. 							<td>{$SXD->LNG['combo_collate']}</td>

    1870. 

  1870. 							<td><div id="db_charset_col"></div></td>

    1871. 

  1871. 						</tr>

    1872. 

  1872. 					</table>

    1873. 

  1873. 				</fieldset>

    1874. 

  1874. 				</td>

    1875. 

  1875. 			</tr>

    1876. 

  1876. 			<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>

    1877. 

  1877. 		</table>

    1878. 

  1878. 	</div>

    1879. 

  1879. </div>

    1880. 

  1880. 

    1881. 

  1881. <div id=sxdMenu style="display:none;z-index:9999;"></div>

    1882. 

  1882. <script type="text/javascript">

    1883. 

  1883. sxd.init();

    1884. 

  1884. sxd.backupUrl = '{$SXD->CFG['backup_url']}';

    1885. 

  1885. sxd.tbar.init('sxdToolbar', {$SXD->VAR['toolbar']}); 

    1886. 

  1886. {$SXD->VAR['combos']}

    1887. 

  1887. sxd.actions.tab_backup();

    1888. 

  1888. </script>

    1889. 

  1889. </body>

    1890. 

  1890. </html>

    1891. 

  1891. HTML;

    1892. 

  1892. }

    1893. 

  1893. 

    1894. 

  1894. function sxd_tpl_auth($error = ''){

    1895. 

  1895. global $SXD;

    1896. 

  1896. return <<<HTML

    1897. 

  1897. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">  

    1898. 

  1898. <html>

    1899. 

  1899. <head>

    1900. 

  1900. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">

    1901. 

  1901. <title>{$SXD->name}</title>

    1902. 

  1902. <link rel="shortcut icon" href="load.php?favicon.v207.ico">

    1903. 

  1903. <link rel="stylesheet" type="text/css" href="load.php?sxd.v207.css">

    1904. 

  1904. </head>

    1905. 

  1905. <body>

    1906. 

  1906. <div class="dialog" id="dia_auth">

    1907. 

  1907. 	<div class="header"><a href="http://sypex.net/">{$SXD->name}</a></div>

    1908. 

  1908. 	<div class="content" id="div_1" style="line-height:50px;text-align:center;">{$SXD->LNG['js_required']}</div>

    1909. 

  1909. 	<div class="content" id="div_2" style="display:none;">

    1910. 

  1910. 		<form method="post">

    1911. 

  1911. 		<table cellspacing="5">

    1912. 

  1912. 			<tr>

    1913. 

  1913. 				<td valign="top" colspan="3">

    1914. 

  1914. 				<fieldset>

    1915. 

  1915. 				<legend>{$SXD->LNG['auth']}</legend>

    1916. 

  1916. 					<table cellspacing="3">

    1917. 

  1917. 						<tr>

    1918. 

  1918. 							<td width="90">{$SXD->LNG['auth_user']}</td>

    1919. 

  1919. 							<td width="192"><input type="text" name="user" value="{$_POST['user']}" class="i202"></td>

    1920. 

  1920. 						</tr>

    1921. 

  1921. 						<tr>

    1922. 

  1922. 							<td>{$SXD->LNG['my_pass']}</td>

    1923. 

  1923. 							<td><input type="password" name="pass" value="{$_POST['pass']}" class="i202"></td>

    1924. 

  1924. 						</tr>

    1925. 

  1925. 						<tr>

    1926. 

  1926. 							<td></td>

    1927. 

  1927. 							<td><label><input type="checkbox" name="save" value="1"{$_POST['save']}> {$SXD->LNG['auth_remember']}</label></td>

    1928. 

  1928. 						</tr>

    1929. 

  1929. 						<tr>

    1930. 

  1930. 							<td>Language:</td>

    1931. 

  1931. 							<td><select type="text" name="lang" style="width:198px;" onChange="this.form.submit();">{$SXD->lng_list}</select></td>

    1932. 

  1932. 						</tr>

    1933. 

  1933. 					</table>

    1934. 

  1934. 					<table cellspacing="3" id="hst" style="display:none;">

    1935. 

  1935. 						<tr>

    1936. 

  1936. 							<td width="90">{$SXD->LNG['my_host']}</td>

    1937. 

  1937. 							<td width="116"><input type="text" name="host" style="width:110px;" value="{$_POST['host']}"></td>

    1938. 

  1938. 							<td width="40" align="right">{$SXD->LNG['my_port']}</td>

    1939. 

  1939. 							<td width="36"><input type="text" name="port" maxlength="5" style="width:30px;" value="{$_POST['port']}"></td>

    1940. 

  1940. 						</tr>

    1941. 

  1941. 					</table>

    1942. 

  1942. 				</fieldset>

    1943. 

  1943. 				</td>

    1944. 

  1944. 			</tr>

    1945. 

  1945. 			<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>

    1946. 

  1946. 		</table>

    1947. 

  1947. 		</form>

    1948. 

  1948. 	</div>

    1949. 

  1949. 	<script type="text/javascript">document.getElementById('div_1').style.display = 'none';document.getElementById('div_2').style.display = 'block';</script>

    1950. 

  1950. </div>

    1951. 

  1951. </body>

    1952. 

  1952. </html>

    1953. 

  1953. HTML;

    1954. 

  1954. }

    1955. 

  1955. 

    1956. 

  1956. ?>

    1957. 

  1957.