PageRenderTime 44ms CodeModel.GetById 17ms RepoModel.GetById 1ms app.codeStats 0ms

/lib/SypexDumpLib.php

https://code.google.com/p/dcloner/
PHP | 1344 lines | 1272 code | 25 blank | 47 comment | 325 complexity | 7bc1dca5d5e6d414f4ce81409f25abb7 MD5 | raw file

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

    

  1. <?php 

    2. 

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

    3. 

  3. //error_reporting(E_ALL);

    4. 

  4. error_reporting(0);

    5. 

  5. set_error_handler('sxd_error_handler');

    6. 

  6. register_shutdown_function('sxd_shutdown');

    7. 

  7. set_magic_quotes_runtime(0);

    8. 

  8. $SXD = new Sypex_Dumper();

    9. 

  9. chdir(dirname(__FILE__));

    10. 

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

    11. 

  11.  

    12. 

  12. class Sypex_Dumper {

    13. 

  13.     function Sypex_Dumper() {

    14. 

  14.         define('C_DEFAULT', 1);

    15. 

  15.         define('C_RESULT', 2);

    16. 

  16.         define('C_ERROR', 3);

    17. 

  17.         define('C_WARNING', 4);

    18. 

  18.         define('SXD_DEBUG', false);

    19. 

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

    20. 

  20.         define('V_SXD', 20006);

    21. 

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

    22. 

  22.         $this->name = 'Sypex Dumper 2.0.6 Beta';

    23. 

  23.     }

    24. 

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

    25. 

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

    26. 

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

    27. 

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

    28. 

  28.             $lng = 'en';

    29. 

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

    30. 

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

    31. 

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

    32. 

  32.                         $lng_name = $l;

    33. 

  33.                         break;

    34. 

  34.                     }

    35. 

  35.                 }

    36. 

  36.             }

    37. 

  37.         }

    38. 

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

    39. 

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

    40. 

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

    41. 

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

    42. 

  42.         return true;

    43. 

  43.     }

    44. 

  44.     function init($args = false){

    45. 

  45.         if (get_magic_quotes_gpc()) {

    46. 

  46.             $_POST = sxd_antimagic($_POST);

    47. 

  47.         }

    48. 

  48. 

    49. 

  49.         include('cfg.php');

    50. 

  50. 

    51. 

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

    52. 

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

    53. 

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

    54. 

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

    55. 

  55.         $this->try = false;

    56. 

  56.         $this->virtualize = false;

    57. 

  57.         $this->cron_mode = false;

    58. 

  58.         // ????????? ??????????? ? ?????? ??????? ? ????

    59. 

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

    60. 

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

    61. 

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

    62. 

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

    63. 

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

    64. 

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

    65. 

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

    66. 

  66.         }

    67. 

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

    68. 

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

    69. 

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

    70. 

  70.                     switch ($m[1]) {

    71. 

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

    72. 

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

    73. 

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

    74. 

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

    75. 

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

    76. 

  76.                     }

    77. 

  77.                 }

    78. 

  78.             }

    79. 

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

    80. 

  80.             // ????????? ?????? ????, ???? ?????

    81. 

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

    82. 

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

    83. 

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

    84. 

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

    85. 

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

    86. 

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

    87. 

  87.             }

    88. 

  88.             else echo 'Auth error';

    89. 

  89.             exit;

    90. 

  90.         }

    91. 

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

    92. 

  92.             $auth = false;

    93. 

  93.             $sfile = 'ses.php';

    94. 

  94.             

    95. 

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

    96. 

  96.                 include($sfile);

    97. 

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

    98. 

  98.                     $auth = true;

    99. 

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

    100. 

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

    101. 

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

    102. 

  102.                 }

    103. 

  103.             }

    104. 

  104.             if(!$auth) {

    105. 

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

    106. 

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

    107. 

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

    108. 

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

    109. 

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

    110. 

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

    111. 

  111.                 foreach($temp AS $a){

    112. 

  112.                     switch($a) {

    113. 

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

    114. 

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

    115. 

  115.                                         break;

    116. 

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

    117. 

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

    118. 

  118.                                         break;

    119. 

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

    120. 

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

    121. 

  121.                                         include $file;

    122. 

  122.                     }

    123. 

  123.                     if($auth) break;

    124. 

  124.                 }

    125. 

  125.                 if($auth){

    126. 

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

    127. 

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

    128. 

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

    129. 

  129.                     $this->saveCFG();

    130. 

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

    131. 

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

    132. 

  132.                     exit;

    133. 

  133.                 }

    134. 

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

    135. 

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

    136. 

  136.                 }

    137. 

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

    138. 

  138.             }

    139. 

  139.             if (!$auth) {

    140. 

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

    141. 

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

    142. 

  142.                     exit;

    143. 

  143.                 }

    144. 

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

    145. 

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

    146. 

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

    147. 

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

    148. 

  148.                 }

    149. 

  149.                 echo sxd_tpl_auth();

    150. 

  150.                 exit;

    151. 

  151.             }

    152. 

  152.         }

    153. 

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

    154. 

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

    155. 

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

    156. 

  156.             exit;

    157. 

  157.         }*/

    158. 

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

    159. 

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

    160. 

  160.         else $this->main();

    161. 

  161.     }

    162. 

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

    163. 

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

    164. 

  164.         fwrite($fp, $content);

    165. 

  165.         fclose($fp);

    166. 

  166.     }

    167. 

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

    168. 

  168.         $this->error = '';

    169. 

  169.         $this->try = true;

    170. 

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

    171. 

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

    172. 

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

    173. 

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

    174. 

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

    175. 

  175.         }

    176. 

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

    177. 

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

    178. 

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

    179. 

  179.         }

    180. 

  180.         else {

    181. 

  181.             define('V_MYSQL', 0); 

    182. 

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

    183. 

  183.         }   

    184. 

  184.         $this->try = false;

    185. 

  185.         return V_MYSQL ? true: false;

    186. 

  186.     }

    187. 

  187.     function main(){

    188. 

  188.         // ??????

    189. 

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

    190. 

  190.             array(

    191. 

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

    192. 

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

    193. 

  193.                 array('|'),

    194. 

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

    195. 

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

    196. 

  196.                 array('|'),

    197. 

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

    198. 

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

    199. 

  199.                 array('|'),

    200. 

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

    201. 

  201.                 array('|'),

    202. 

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

    203. 

  203.             )

    204. 

  204.         );

    205. 

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

    206. 

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

    207. 

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

    208. 

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

    209. 

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

    210. 

  210.             }

    211. 

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

    212. 

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

    213. 

  213.         }

    214. 

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

    215. 

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

    216. 

  216.         }

    217. 

  217.         end($zip);

    218. 

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

    219. 

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

    220. 

  220.             $this->addCombo('backup_db', $this->db, 11, 'db', $this->getDBList()) . 

    221. 

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

    222. 

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

    223. 

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

    224. 

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

    225. 

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

    226. 

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

    227. 

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

    228. 

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

    229. 

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

    230. 

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

    231. 

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

    232. 

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

    233. 

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

    234. 

  234.         ;

    235. 

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

    236. 

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

    237. 

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

    238. 

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

    239. 

  239.         

    240. 

  240.         echo sxd_tpl_page();

    241. 

  241.     }

    242. 

  242. 

    243. 

  243.     function loadJob($job){

    244. 

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

    245. 

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

    246. 

  246.         include($file);

    247. 

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

    248. 

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

    249. 

  249.         return $JOB;

    250. 

  250.     }

    251. 

  251.     function deleteDB($name){

    252. 

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

    253. 

  253.         if($r){

    254. 

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

    255. 

  255.         }

    256. 

  256.         else

    257. 

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

    258. 

  258.     }

    259. 

  259.     function cfg2js($cfg){

    260. 

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

    261. 

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

    262. 

  262.         }

    263. 

  263.         return $cfg;

    264. 

  264.     }

    265. 

  265.     function addDb($req){

    266. 

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

    267. 

  267.         if($r)

    268. 

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

    269. 

  269.         else

    270. 

  270.              sxd_my_error();

    271. 

  271.     }

    272. 

  272.     function saveConnect($req){

    273. 

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

    274. 

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

    275. 

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

    276. 

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

    277. 

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

    278. 

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

    279. 

  279.         $this->saveCFG();

    280. 

  280.         $this->connect();

    281. 

  281.         if (V_MYSQL) {

    282. 

  282.             $tmp = array(

    283. 

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

    284. 

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

    285. 

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

    286. 

  286.             );

    287. 

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

    288. 

  288.         }

    289. 

  289.         else {

    290. 

  290.              echo $this->error;

    291. 

  291.         }

    292. 

  292.     }

    293. 

  293.     function saveOptions($req){

    294. 

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

    295. 

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

    296. 

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

    297. 

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

    298. 

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

    299. 

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

    300. 

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

    301. 

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

    302. 

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

    303. 

  303.         $this->saveCFG();

    304. 

  304.     }

    305. 

  305.     function saveCFG(){

    306. 

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

    307. 

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

    308. 

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

    309. 

  309.         }

    310. 

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

    311. 

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

    312. 

  312.         }

    313. 

  313.     }

    314. 

  314.     function runServices($job) {

    315. 

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

    316. 

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

    317. 

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

    318. 

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

    319. 

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

    320. 

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

    321. 

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

    322. 

  322.             if (!$r) return;

    323. 

  323.             $tables = array();

    324. 

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

    325. 

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

    326. 

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

    327. 

  327.             }

    328. 

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

    329. 

  329.             

    330. 

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

    331. 

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

    332. 

  332.             }

    333. 

  333.             

    334. 

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

    335. 

  335.             if (!$r) return;

    336. 

  336.             $res = array();

    337. 

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

    338. 

  338.                 $res[] = $item;

    339. 

  339.             }

    340. 

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

    341. 

  341.         }

    342. 

  342.     }

    343. 

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

    344. 

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

    345. 

  345.         foreach($types AS $type){

    346. 

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

    347. 

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

    348. 

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

    349. 

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

    350. 

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

    351. 

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

    352. 

  352.                     }

    353. 

  353.                     else {

    354. 

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

    355. 

  355.                     }

    356. 

  356.                 }

    357. 

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

    358. 

  358.             }

    359. 

  359.         }

    360. 

  360.     }

    361. 

  361.     function closeConnect(){

    362. 

  362.         //return;

    363. 

  363.         ignore_user_abort(1); 

    364. 

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

    365. 

  365.         header("Connection: close"); 

    366. 

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

    367. 

  367.         ob_end_flush(); 

    368. 

  368.         flush();

    369. 

  369.     }

    370. 

  370.     function resumeJob($job){

    371. 

  371.         $this->closeConnect();

    372. 

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

    373. 

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

    374. 

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

    375. 

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

    376. 

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

    377. 

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

    378. 

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

    379. 

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

    380. 

  380.         }

    381. 

  381.         else {

    382. 

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

    383. 

  383.             exit;

    384. 

  384.         }

    385. 

  385.         // TODO: ????????? ???????? ?????????

    386. 

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

    387. 

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

    388. 

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

    389. 

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

    390. 

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

    391. 

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

    392. 

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

    393. 

  393.     }

    394. 

  394.     function addRestoreJob($job) {

    395. 

  395.         $this->closeConnect();

    396. 

  396.         $this->JOB = $job;

    397. 

  397.         // ??????? ?????? ???????? ? ??????

    398. 

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

    399. 

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

    400. 

  400.         

    401. 

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

    402. 

  402.         $todo = array();

    403. 

  403.         $rows = 0;

    404. 

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

    405. 

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

    406. 

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

    407. 

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

    408. 

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

    409. 

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

    410. 

  410.             foreach($list AS $item){

    411. 

  411.                 switch($t){

    412. 

  412.                     case 'TA':

    413. 

  413.                         $type = '';

    414. 

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

    415. 

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

    416. 

  416.                         }

    417. 

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

    418. 

  418.                             $type = 'TC';

    419. 

  419.                         }

    420. 

  420.                         else continue;

    421. 

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

    422. 

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

    423. 

  423.                     break;

    424. 

  424.                     default:

    425. 

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

    426. 

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

    427. 

  427.                         }

    428. 

  428.                 }

    429. 

  429.             }

    430. 

  430.         }

    431. 

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

    432. 

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

    433. 

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

    434. 

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

    435. 

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

    436. 

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

    437. 

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

    438. 

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

    439. 

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

    440. 

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

    441. 

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

    442. 

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

    443. 

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

    444. 

  444.         $this->runRestoreJob();

    445. 

  445.     }

    446. 

  446.     function runRestoreJob($continue = false){

    447. 

  447.         $ei = false;

    448. 

  448.         if($continue){

    449. 

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

    450. 

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

    451. 

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

    452. 

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

    453. 

  453.         }

    454. 

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

    455. 

  455.         

    456. 

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

    457. 

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

    458. 

  458.         $fcache = '';

    459. 

  459.         $writes = 0;

    460. 

  460.         $old_charset = '';

    461. 

  461.         $tab = '';

    462. 

  462.         $seek = 0;

    463. 

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

    464. 

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

    465. 

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

    466. 

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

    467. 

  467.         $c = 0;

    468. 

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

    469. 

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

    470. 

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

    471. 

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

    472. 

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

    473. 

  473.         }

    474. 

  474.         $tab_exists = array();

    475. 

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

    476. 

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

    477. 

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

    478. 

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

    479. 

  479.             }

    480. 

  480.         }

    481. 

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

    482. 

  482.         //$enable_index = array();

    483. 

  483.         if(V_MYSQL > 40014) {

    484. 

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

    485. 

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

    486. 

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

    487. 

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

    488. 

  488.         }

    489. 

  489.         $log_sql = false;

    490. 

  490.         $fields = '';

    491. 

  491.         $time_old = time();

    492. 

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

    493. 

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

    494. 

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

    495. 

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

    496. 

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

    497. 

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

    498. 

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

    499. 

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

    500. 

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

    501. 

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

    502. 

  502.                         

    503. 

  503.                     }*/

    504. 

  504.                     unset($this->rtl);

    505. 

  505.                     exit;

    506. 

  506.                 }

    507. 

  507.                 $time_old = time();

    508. 

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

    509. 

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

    510. 

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

    511. 

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

    512. 

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

    513. 

  513.                     unset($this->rtl);

    514. 

  514.                     exit;

    515. 

  515.                 }

    516. 

  516.                 clearstatcache(); 

    517. 

  517.             }

    518. 

  518.             switch($q{0}){

    519. 

  519.                 case '(':

    520. 

  520.                     if($continue) {

    521. 

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

    522. 

  522.                         $continue = false;

    523. 

  523.                     }

    524. 

  524.                     $q = $insert . $q;

    525. 

  525.                     $ex = 1;

    526. 

  526.                     $c = 1;

    527. 

  527.                     break;  

    528. 

  528.                 case 'I':

    529. 

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

    530. 

  530.                         $insert = $td . $m[1] . $fields . ' VALUES ';

    531. 

  531.                         $tab = $m[2];

    532. 

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

    533. 

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

    534. 

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

    535. 

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

    536. 

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

    537. 

  537.                             }   

    538. 

  538.                         }

    539. 

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

    540. 

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

    541. 

  541.                         }

    542. 

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

    543. 

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

    544. 

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

    545. 

  545.                         $ex = 1;

    546. 

  546.                     }

    547. 

  547.                     break;

    548. 

  548.                 case 'C':

    549. 

  549.                     $ex = 1;

    550. 

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

    551. 

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

    552. 

  552.                         else {

    553. 

  553.                             $ex = 1;

    554. 

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

    555. 

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

    556. 

  556.                             }

    557. 

  557.                         }

    558. 

  558.                         // ??????? ????? ????? ???????

    559. 

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

    560. 

  560.                     }

    561. 

  561.                     break;

    562. 

  562.                 case '#': // ??????? ??? ???????

    563. 

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

    564. 

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

    565. 

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

    566. 

  566.                         

    567. 

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

    568. 

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

    569. 

  569.                             $insert = '';

    570. 

  570.                             $tab = '';

    571. 

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

    572. 

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

    573. 

  573.                             $ei = 0;

    574. 

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

    575. 

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

    576. 

  576.                             }

    577. 

  577.                         }

    578. 

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

    579. 

  579.                             $ei = 1;

    580. 

  580.                         }

    581. 

  581.                         else {

    582. 

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

    583. 

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

    584. 

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

    585. 

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

    586. 

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

    587. 

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

    588. 

  588.                             $ei = 0;

    589. 

  589.                         }

    590. 

  590.                     }

    591. 

  591.                     $ex = 0;

    592. 

  592.                     break;

    593. 

  593.                 default: 

    594. 

  594.                     $insert = '';

    595. 

  595.                     $ex = 1;

    596. 

  596.             }

    597. 

  597.             if($ex) {

    598. 

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

    599. 

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

    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.                 if(mysql_query($q)) {

    604. 

  604.                     if($insert) {

    605. 

  605.                         $c = 1;

    606. 

  606.                     }

    607. 

  607.                 }

    608. 

  608.                 else {

    609. 

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

    610. 

  610.                     sxd_my_error();

    611. 

  611.                 }

    612. 

  612.                 

    613. 

  613.                 if($c){

    614. 

  614.                     $i = mysql_affected_rows();

    615. 

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

    616. 

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

    617. 

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

    618. 

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

    619. 

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

    620. 

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

    621. 

  621.                     $c = 1;

    622. 

  622.                 }

    623. 

  623.             }

    624. 

  624.             

    625. 

  625.         }

    626. 

  626.         // ???????? ?????

    627. 

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

    628. 

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

    629. 

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

    630. 

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

    631. 

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

    632. 

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

    633. 

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

    634. 

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

    635. 

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

    636. 

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

    637. 

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

    638. 

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

    639. 

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

    640. 

  640.         }

    641. 

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

    642. 

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

    643. 

  643.         

    644. 

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

    645. 

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

    646. 

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

    647. 

  647.         fclose($this->fh_log);

    648. 

  648.         fclose($this->fh_rtl);

    649. 

  649.     }

    650. 

  650.     function addBackupJob($job) {

    651. 

  651.         $this->closeConnect();

    652. 

  652.         // ??????? ????? ???????

    653. 

  653.         $this->JOB = $job;

    654. 

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

    655. 

  655.         // ??????? ?????? ???????? ? ??????

    656. 

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

    657. 

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

    658. 

  658.         $queries = array(

    659. 

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

    660. 

  660.         );

    661. 

  661.         if (V_MYSQL > 50014) {

    662. 

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

    663. 

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

    664. 

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

    665. 

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

    666. 

  666.         }

    667. 

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

    668. 

  668.         $tabs = $rows = 0;

    669. 

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

    670. 

  670.         foreach($queries AS $query){

    671. 

  671.             $t = $query[2];

    672. 

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

    673. 

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

    674. 

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

    675. 

  675.             if (!$r) continue;

    676. 

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

    677. 

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

    678. 

  678.             

    679. 

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

    680. 

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

    681. 

  681.                 switch($t){

    682. 

  682.                     case 'TA':

    683. 

  683.                     case 'TC':

    684. 

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

    685. 

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

    686. 

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

    687. 

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

    688. 

  688.                             }

    689. 

  689.                             continue;

    690. 

  690.                         }

    691. 

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

    692. 

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

    693. 

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

    694. 

  694.                         }

    695. 

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

    696. 

  696.                             $t = 'TC';

    697. 

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

    698. 

  698.                         }

    699. 

  699.                         else continue;

    700. 

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

    701. 

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

    702. 

  702.                         $tabs++;

    703. 

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

    704. 

  704.                     break;

    705. 

  705.                     default:

    706. 

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

    707. 

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

    708. 

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

    709. 

  709.                         }

    710. 

  710.                 }

    711. 

  711.             }

    712. 

  712.             

    713. 

  713.         }

    714. 

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

    715. 

  715.             // ????? ???????, ????? ????????????? ?????????

    716. 

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

    717. 

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

    718. 

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

    719. 

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

    720. 

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

    721. 

  721.                 $used = $m[1];  

    722. 

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

    723. 

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

    724. 

  724.             }

    725. 

  725.             

    726. 

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

    727. 

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

    728. 

  728.                     $can_dumped = true;

    729. 

  729.                     foreach($view AS $k) {

    730. 

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

    731. 

  731.                     }

    732. 

  732.                     if ($can_dumped) {

    733. 

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

    734. 

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

    735. 

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

    736. 

  736.                         }

    737. 

  737.                         $dumped[$n] = 1;

    738. 

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

    739. 

  739.                     }

    740. 

  740.                 }

    741. 

  741.             }

    742. 

  742.             unset($dumped);

    743. 

  743.             unset($views);

    744. 

  744.             unset($views_collation);

    745. 

  745.         }

    746. 

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

    747. 

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

    748. 

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

    749. 

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

    750. 

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

    751. 

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

    752. 

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

    753. 

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

    754. 

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

    755. 

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

    756. 

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

    757. 

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

    758. 

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

    759. 

  759.         }

    760. 

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

    761. 

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

    762. 

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

    763. 

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

    764. 

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

    765. 

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

    766. 

  766.         $this->runBackupJob();

    767. 

  767.     }

    768. 

  768.     function runBackupJob($continue = false){

    769. 

  769.         if($continue){

    770. 

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

    771. 

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

    772. 

  772.         }

    773. 

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

    774. 

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

    775. 

  775.         $fcache = '';

    776. 

  776.         $writes = 0;

    777. 

  777.         

    778. 

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

    779. 

  779.         $time_old = time();

    780. 

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

    781. 

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

    782. 

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

    783. 

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

    784. 

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

    785. 

  785.             foreach($o AS $n){ 

    786. 

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

    787. 

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

    788. 

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

    789. 

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

    790. 

  790.                 }

    791. 

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

    792. 

  792.                 // ?????? ?????

    793. 

  793.                 switch($n[0]){

    794. 

  794.                     case 'TC':

    795. 

  795.                     case 'TD':              

    796. 

  796.                     case 'TA':

    797. 

  797.                         $from = '';

    798. 

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

    799. 

  799.                             // ????? ????????? ???????

    800. 

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

    801. 

  801.                             $item = mysql_fetch_assoc($r);

    802. 

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

    803. 

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

    804. 

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

    805. 

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

    806. 

  806.                             // ??????? ?????? ???????

    807. 

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

    808. 

  808.                         }

    809. 

  809.                         else {

    810. 

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

    811. 

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

    812. 

  812.                         }

    813. 

  813.                         // ?????????? ???? ?????

    814. 

  814.                         $notNum = array();

    815. 

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

    816. 

  816.                         $fields = 0;

    817. 

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

    818. 

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

    819. 

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

    820. 

  820.                             $fields++;

    821. 

  821.                         }

    822. 

  822.                         $time_old = time();

    823. 

  823.                         $z = 0;

    824. 

  824.                         // ??????? ??????

    825. 

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

    826. 

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

    827. 

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

    828. 

  828.                                 $z = 0;

    829. 

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

    830. 

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

    831. 

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

    832. 

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

    833. 

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

    834. 

  834.                                         if($type == 1) {

    835. 

  835.                                             

    836. 

  836.                                         }

    837. 

  837.                                         unset($this->rtl);

    838. 

  838.                                         exit;

    839. 

  839.                                     }

    840. 

  840.                                     $time_old = time();

    841. 

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

    842. 

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

    843. 

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

    844. 

  844.                                         unset($this->rtl);

    845. 

  845.                                         exit;

    846. 

  846.                                     }

    847. 

  847.                                     clearstatcache(); 

    848. 

  848.                                 }

    849. 

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

    850. 

  850.                             }

    851. 

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

    852. 

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

    853. 

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

    854. 

  854.                             }

    855. 

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

    856. 

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

    857. 

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

    858. 

  858.                         }

    859. 

  859.                         unset($row);

    860. 

  860.                         mysql_free_result($r);

    861. 

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

    862. 

  862.                     break;

    863. 

  863. 

    864. 

  864.                     /*case 'VI':

    865. 

  865.                     case 'PR': 

    866. 

  866.                     case 'FU':

    867. 

  867.                     case 'EV':

    868. 

  868.                     case 'TR':*/

    869. 

  869.                     default:

    870. 

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

    871. 

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

    872. 

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

    873. 

  873.                             $item = mysql_fetch_assoc($r);

    874. 

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

    875. 

  875.                         }

    876. 

  876.                         else {

    877. 

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

    878. 

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

    879. 

  879.                             $item = mysql_fetch_assoc($r);

    880. 

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

    881. 

  881.                         }

    882. 

  882.                 }

    883. 

  883.                 

    884. 

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

    885. 

  885.             }

    886. 

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

    887. 

  887.         }

    888. 

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

    889. 

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

    890. 

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

    891. 

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

    892. 

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

    893. 

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

    894. 

  894.         fclose($this->fh_tmp);

    895. 

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

    896. 

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

    897. 

  897.         

    898. 

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

    899. 

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

    900. 

  900.             $deldate = '';

    901. 

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

    902. 

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

    903. 

  903.             }

    904. 

  904.             $deleted = false;

    905. 

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

    906. 

  906.                 $files = array();

    907. 

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

    908. 

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

    909. 

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

    910. 

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

    911. 

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

    912. 

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

    913. 

  913.                             $deleted = true;

    914. 

  914.                         }

    915. 

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

    916. 

  916.                     }

    917. 

  917.                 }

    918. 

  918.                 closedir($dh);

    919. 

  919.                 // ????????? ????? ?? ???? ? ??????? ????? ??????

    920. 

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

    921. 

  921.                     ksort($files);

    922. 

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

    923. 

  923.                     foreach ($files AS $file){

    924. 

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

    925. 

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

    926. 

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

    927. 

  927.                             $deleted = true;

    928. 

  928.                         }

    929. 

  929.                     }

    930. 

  930.                 }

    931. 

  931.             }

    932. 

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

    933. 

  933.         }

    934. 

  934.         fclose($this->fh_log);

    935. 

  935.         fclose($this->fh_rtl);

    936. 

  936.     }

    937. 

  937.     function setNames($collation){

    938. 

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

    939. 

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

    940. 

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

    941. 

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

    942. 

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

    943. 

  943.         }

    944. 

  944.     }

    945. 

  945.     function write(&$str){

    946. 

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

    947. 

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

    948. 

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

    949. 

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

    950. 

  950.         $str = '';

    951. 

  951.     }

    952. 

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

    953. 

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

    954. 

  954.     }

    955. 

  955.     function getDBList(){

    956. 

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

    957. 

  957.         if (!V_MYSQL) return $dbs; 

    958. 

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

    959. 

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

    960. 

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

    961. 

  961.             foreach($tmp AS $d){

    962. 

  962.                 $d = trim($d);

    963. 

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

    964. 

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

    965. 

  965.             }

    966. 

  966.         }

    967. 

  967.         else{

    968. 

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

    969. 

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

    970. 

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

    971. 

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

    972. 

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

    973. 

  973.             }   

    974. 

  974.         }

    975. 

  975.         if(V_MYSQL < 50000){

    976. 

  976.             foreach($items AS $item){

    977. 

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

    978. 

  978.                 if ($tables) {

    979. 

  979.                     $tabs = mysql_num_rows($tables);

    980. 

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

    981. 

  981.                 }

    982. 

  982.             }

    983. 

  983.         }

    984. 

  984.         else {

    985. 

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

    986. 

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

    987. 

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

    988. 

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

    989. 

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

    990. 

  990.             }

    991. 

  991.         }

    992. 

  992.         return $dbs;

    993. 

  993.     }

    994. 

  994.     function getCharsetList(){

    995. 

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

    996. 

  996.         if (!V_MYSQL) return $tmp; 

    997. 

  997.         if(V_MYSQL > 40101) {

    998. 

  998.             $def_charsets = '';

    999. 

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

    1000. 

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

    1001. 

  1001.             }

    1002. 

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

    1003. 

  1003.             if ($r) {

    1004. 

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

    1005. 

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

    1006. 

  1006.                 }

    1007. 

  1007.             }

    1008. 

  1008.         }

    1009. 

  1009.         return $tmp;

    1010. 

  1010.     }

    1011. 

  1011.     function getCollationList(){

    1012. 

  1012.         $tmp = array(); 

    1013. 

  1013.         if (!V_MYSQL) return $tmp; 

    1014. 

  1014.         if(V_MYSQL > 40101) {

    1015. 

  1015.             $def_charsets = '';

    1016. 

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

    1017. 

  1017.                 $def_charsets = …
    1018.

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