PageRenderTime 76ms CodeModel.GetById 23ms RepoModel.GetById 0ms app.codeStats 1ms

/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

Large files files are truncated, but you can click here to view the full 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. 						$…
    1298.

Large files files are truncated, but you can click here to view the full file