API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 2nd, 2019
390
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.01 KB | None | 0 0
raw download clone embed print report
  1. <?
  2.  
  3. if($memb___id == 'PHPCore'){
  4. //$memb___id = 'adminfmu';
  5. //$memb___mail = 'keepvotingfmu@gmail.com';
  6. //$config['debug'] = 1;
  7. }
  8.  
  9.  
  10.  
  11. if(isset($_GET['verification'])){
  12. $transfer_error = 0;
  13.  
  14.  
  15. $i = $db->prepare("Use ".$config['mssql']['db_me_muonline']);
  16. $i->execute();
  17.  
  18. $memb_stat_select = $db->prepare("SELECT ConnectStat from MEMB_STAT where memb___id=?");
  19. $memb_stat_select->execute(array($memb___id));
  20. $memb_stat = $memb_stat_select->fetch();
  21. $memb_stat_select->closeCursor();
  22.  
  23. $memb_stat[0] = 0;
  24.  
  25. if($memb_stat[0] == 1){
  26. echo alert('Your account is connected in game! Please disconnect.',0,'',1);
  27. }else{
  28.  
  29.  
  30. $memb_info_select = $db->prepare("SELECT memb___id,memb__pwd,memb_name,sno__numb,mail_addr,addr_info,appl_days,modi_days,out__days,true_days,mail_chek,bloc_code,ctl1_code,JF,cspoints,VipStamp,MasterKey,AccountLock,Remark,TempCredits,LuckyCoin from MEMB_INFO where memb___id=?");
  31. $memb_info_select->execute(array($memb___id));
  32. $memb_info = $memb_info_select->fetch();
  33. $memb_info_select->closeCursor();
  34.  
  35.  
  36. $account_data['Me_MuOnline']['MEMB_INFO'] = $memb_info;
  37.  
  38.  
  39.  
  40. $memb_credits_select = $db->prepare("SELECT memb___id,credits,TempCredits,vippoints from MEMB_CREDITS where memb___id=?");
  41. $memb_credits_select->execute(array($memb___id));
  42. $memb_credits = $memb_credits_select->fetch();
  43. $memb_credits_select->closeCursor();
  44.  
  45. if(empty($memb_credits[2])){
  46. $memb_credits[2] = 0;
  47. }
  48.  
  49.  
  50. $account_data['Me_MuOnline']['MEMB_CREDITS'] = $memb_credits;
  51.  
  52. $i = $db->prepare("Use ".$config['mssql']['db_muonline']);
  53. $i->execute();
  54.  
  55. $accountcharacter_select = $db->prepare("SELECT Id,GameID1,GameID2,GameID3,GameID4,GameID5,GameIDC,MoveCnt,Summoner,ExtVault,Ragefighter from AccountCharacter where Id=?");
  56. $accountcharacter_select->execute(array($memb___id));
  57. $accountcharacter = $accountcharacter_select->fetch();
  58. $accountcharacter_select->closeCursor();
  59.  
  60. $accountcharacter_insert_script = 0;
  61.  
  62. if($accountcharacter){
  63.  
  64. $accountcharacter_insert_script = 1;
  65.  
  66. $accountcharacter_list = array(1=>$accountcharacter[1],2=>$accountcharacter[2],3=>$accountcharacter[3],4=>$accountcharacter[4],5=>$accountcharacter[5]);
  67. $accountcharacter_list_new = array(1=>$accountcharacter[1],2=>$accountcharacter[2],3=>$accountcharacter[3],4=>$accountcharacter[4],5=>$accountcharacter[5]);
  68.  
  69. $account_data['MuOnline']['AccountCharacter'] = $accountcharacter;
  70.  
  71. $start_char_list_from = 0;
  72.  
  73.  
  74. $make_array_character_search = array();
  75. foreach($accountcharacter_list as $char_id => $char_var){
  76. $start_char_list_from++;
  77. $character_search = $char_var;
  78.  
  79.  
  80. if(!empty($char_id) && !empty($char_var)){
  81.  
  82. if(isset($_POST['newcharacter'][$char_id])){
  83. $character_post[$char_id] = safe2($_POST['newcharacter'][$char_id],'\_',8);
  84. if(!empty($character_post[$char_id]) && !in_array($character_post[$char_id],$make_array_character_search)){
  85. $character_search = $character_post[$char_id];
  86. }
  87. }
  88.  
  89. $check_character = $db2->prepare("Select Name from Character where Name=?");
  90. $check_character->execute(array($character_search));
  91. if($check_character_results = $check_character->fetch() || preg_match('/[^A-Za-z0-9\_]/',$character_search) || strlen($character_search) < 4){
  92. $transfer_error = 1;
  93. $character_exist_list[$char_id] = $char_var;
  94. $character_exist_error[$char_id] = 'input_error';
  95.  
  96. }else{
  97. if(!empty($character_post[$char_id])){
  98. $character_exist_list[$char_id] = $char_var;
  99. $character_exist_error[$char_id] = 'input_success';
  100.  
  101. }
  102. }
  103. $check_character->closeCursor();
  104.  
  105. $make_array_character_search[] = $character_search;
  106.  
  107. $accountcharacter_list_new[$char_id] = $character_search;
  108.  
  109. $account_data['MuOnline']['AccountCharacter'][$start_char_list_from] = $character_search;
  110.  
  111.  
  112. }
  113. }
  114.  
  115.  
  116.  
  117. $account_data['MuOnline']['AccountCharacter'][6] = null;
  118. }
  119.  
  120.  
  121.  
  122.  
  123.  
  124. $i = $db2->prepare("Use ".$config['mssql2']['db_me_muonline']);
  125. $i->execute();
  126.  
  127.  
  128. $memb___id_search = $memb___id;
  129. if(isset($_POST['newusername'])){
  130. $memb___id_post = safe2($_POST['newusername'],'',10);
  131. if(!empty($memb___id_post)){
  132. $memb___id_search = $memb___id_post;
  133. $post_set_account = 1;
  134. }
  135. }
  136.  
  137. $check_account = $db2->prepare("Select memb___id,cspoints from MEMB_INFO where memb___id=?");
  138. $check_account->execute(array($memb___id_search));
  139. if($check_account_results = $check_account->fetch() || preg_match('/[^A-Za-z0-9]/',$memb___id_search) || strlen($memb___id_search) < 4){
  140. $transfer_error = 1;
  141. $account_exist = 1;
  142. $account_exist_error = 'input_error';
  143. }else{
  144. $account_exist_error = 'input_success';
  145. if($post_set_account == 1){
  146. $account_data['Me_MuOnline']['MEMB_INFO'][0] = $memb___id_post;
  147. $account_data['Me_MuOnline']['MEMB_INFO'][2] = $memb___id_post;
  148. $account_data['Me_MuOnline']['MEMB_INFO'][5] = $memb___id_post;
  149.  
  150. $account_data['Me_MuOnline']['MEMB_CREDITS'][0] = $memb___id_post;
  151.  
  152. $account_data['MuOnline']['AccountCharacter'][0] = $memb___id_post;
  153.  
  154. }
  155. }
  156. $check_account->closeCursor();
  157.  
  158. if($account_exist == 1 || $post_set_account == 1){
  159.  
  160. $memb___pwd_post = safe2($_POST['newpass'],'\@\-',10);
  161. $memb___repwd_post = safe2($_POST['newrepass'],'\@\-',10);
  162. if(empty($memb___pwd_post) || empty($memb___repwd_post) || $memb___pwd_post != $memb___repwd_post || strlen($memb___pwd_post) < 4){
  163. unset($memb___pwd_post);
  164. unset($memb___repwd_post);
  165.  
  166. $pwd_error = 'input_error';
  167. $repwd_error = 'input_error';
  168.  
  169. $transfer_error = 1;
  170.  
  171. }else{
  172. $pwd_error = 'input_success';
  173. $repwd_error = 'input_success';
  174.  
  175. $set_new_pass = 1;
  176. }
  177. }
  178.  
  179.  
  180.  
  181.  
  182. /*CHECK MAIL*/
  183. $memb___mail_search = $memb___mail;
  184. if(isset($_POST['newmail'])){
  185. $memb___mail_post = filter_var($_POST['newmail'], FILTER_VALIDATE_EMAIL);
  186. if(!empty($memb___mail_post)){
  187. $memb___mail_search = $memb___mail_post;
  188. $post_set_mail = 1;
  189. }
  190. }
  191. $check_mail = $db2->prepare("Select mail_addr from MEMB_INFO where mail_addr=?");
  192. $check_mail->execute(array($memb___mail_search));
  193. if($check_mail_results = $check_mail->fetch()){
  194. $transfer_error = 1;
  195. $mail_exist = 1;
  196. $mail_exist_error = 'input_error';
  197. }else{
  198. $mail_exist_error = 'input_success';
  199. if($post_set_mail == 1){
  200. $account_data['Me_MuOnline']['MEMB_INFO'][4] = $memb___mail_post;
  201. }
  202. }
  203. $check_mail->closeCursor();
  204.  
  205.  
  206.  
  207.  
  208. if($transfer_error == 0){
  209. $post_set_good_transfer = 1;
  210. if(isset($_POST['transfer_done'])){
  211. $go_transfer = 1;
  212. }
  213. }
  214.  
  215.  
  216.  
  217.  
  218.  
  219.  
  220.  
  221.  
  222. if($go_transfer == 1){
  223.  
  224.  
  225.  
  226.  
  227.  
  228.  
  229.  
  230. foreach($accountcharacter_list as $char_id => $char_var){
  231.  
  232.  
  233. if(!empty($char_var)){
  234. $char_info_select = $db->prepare("Select AccountID,Name,cLevel,LevelUpPoint,Class,Experience,Strength,Dexterity,Vitality,Energy,Inventory,MagicList,Money,Life,MaxLife,Mana,MaxMana,MapNumber,MapPosX,MapPosY,MapDir,PkCount,PkLevel,PkTime,MDate,LDate,CtlCode,DbVersion,Quest,Leadership,ChatLimitTime,FruitPoint,JHDX,JHtype,Grand_Resets,Resets,EDSPostCmd,CirePkRank,EDSPostBanTime,GensRank,GensContribution,GensType,GensLastLeave,GensKnight,PCPoints,TempPcPoints,PvPLastStandWin,MasterResetCount,ExtInventory,S6EP3_PS_FIX from Character where Name=?");
  235. $char_info_select->execute(array($char_var));
  236. if($character[$char_id] = $char_info_select->fetch()){
  237.  
  238. /*
  239. $character_inventory_get = preg_replace('/[^A-Z0-9]/', '',$character[$char_id][10]);
  240.  
  241.  
  242. if(is_int(strlen($character_inventory_get)/32) == false){
  243. $count_data = 0;
  244. $count_data = strlen($character_inventory_get);
  245. $count_data = $count_data-1;
  246. $character_inventory_get = substr($character_inventory_get,0,$count_data);
  247. }
  248. $count_data = 0;
  249. $count_data = strlen($character_inventory_get);
  250. $count_data = $count_data-3;
  251. $character_Inventory[$char_id] = substr($character_inventory_get,0,$count_data).str_repeat('F',3);
  252. $character_MagicList[$char_id] = preg_replace('/[^A-Z0-9]/', '',$character[$char_id][11]);
  253. $character_Quest[$char_id] = preg_replace('/[^A-Z0-9]/', '',$character[$char_id][28]);
  254.  
  255. $character[$char_id][1] = $accountcharacter_list_new[$char_id];
  256. */
  257.  
  258.  
  259.  
  260.  
  261. if(empty($character[$char_id])){
  262. unset($character[$char_id]);
  263. }
  264.  
  265. }else{
  266. unset($character[$char_id]);
  267. }
  268. $char_info_select->closeCursor();
  269.  
  270.  
  271. }
  272. }
  273.  
  274.  
  275.  
  276. if(isset($character[1])){
  277. //unset($character[1][10]);
  278. //unset($character[1][11]);
  279. //unset($character[1][28]);
  280. $character[1] = array_values($character[1]);
  281. }
  282.  
  283. if(isset($character[2])){
  284. //unset($character[2][10]);
  285. //unset($character[2][11]);
  286. //unset($character[2][28]);
  287. $character[2] = array_values($character[2]);
  288. }
  289.  
  290. if(isset($character[3])){
  291. //unset($character[3][10]);
  292. //unset($character[3][11]);
  293. //unset($character[3][28]);
  294. $character[3] = array_values($character[3]);
  295. }
  296.  
  297. if(isset($character[4])){
  298. //unset($character[4][10]);
  299. //unset($character[4][11]);
  300. //unset($character[4][28]);
  301. $character[4] = array_values($character[4]);
  302. }
  303.  
  304. if(isset($character[5])){
  305. //unset($character[5][10]);
  306. //unset($character[5][11]);
  307. //unset($character[5][28]);
  308. $character[5] = array_values($character[5]);
  309. }
  310.  
  311. $account_data['MuOnline']['Character'] = $character;
  312.  
  313.  
  314.  
  315.  
  316. if($post_set_account == 1){
  317.  
  318. if(isset($account_data['MuOnline']['Character'][1])){
  319. $account_data['MuOnline']['Character'][1][0] = $memb___id_post;
  320. }
  321.  
  322. if(isset($account_data['MuOnline']['Character'][2])){
  323. $account_data['MuOnline']['Character'][2][0] = $memb___id_post;
  324. }
  325.  
  326. if(isset($account_data['MuOnline']['Character'][3])){
  327. $account_data['MuOnline']['Character'][3][0] = $memb___id_post;
  328. }
  329.  
  330. if(isset($account_data['MuOnline']['Character'][4])){
  331. $account_data['MuOnline']['Character'][4][0] = $memb___id_post;
  332. }
  333.  
  334. if(isset($account_data['MuOnline']['Character'][5])){
  335. $account_data['MuOnline']['Character'][5][0] = $memb___id_post;
  336. }
  337.  
  338.  
  339. }
  340.  
  341.  
  342.  
  343. foreach($accountcharacter_list as $char_id => $char_var){
  344. if(!empty($char_var)){
  345. $char_OptionData = $db->prepare("Select Name,SkillKey,GameOption,Qkey,Wkey,Ekey,ChatWindow,RKey,QWERLevel from OptionData where Name=?");
  346. $char_OptionData->execute(array($char_var));
  347. if($character_OptionData[$char_id] = $char_OptionData->fetch()){
  348. $character_OptionData[$char_id][0] = $accountcharacter_list_new[$char_id];
  349. if(empty($character_OptionData[$char_id])){
  350. unset($character_OptionData[$char_id]);
  351. }
  352. }else{
  353. unset($character_OptionData[$char_id]);
  354. }
  355. $char_OptionData->closeCursor();
  356.  
  357. }
  358. }
  359.  
  360. $account_data['MuOnline']['OptionData'] = $character_OptionData;
  361.  
  362.  
  363. foreach($accountcharacter_list as $char_id => $char_var){
  364. if(!empty($char_var)){
  365. $char_T_MasterLevelSystem = $db->prepare("SELECT CHAR_NAME,MASTER_LEVEL,ML_EXP,ML_NEXTEXP,ML_POINT from T_MasterLevelSystem where CHAR_NAME=?");
  366. $char_T_MasterLevelSystem->execute(array($char_var));
  367. if($character_T_MasterLevelSystem[$char_id] = $char_T_MasterLevelSystem->fetch()){
  368. $character_T_MasterLevelSystem[$char_id][0] = $accountcharacter_list_new[$char_id];
  369. if(empty($character_T_MasterLevelSystem[$char_id])){
  370. unset($character_T_MasterLevelSystem[$char_id]);
  371. }
  372. }else{
  373. unset($character_T_MasterLevelSystem[$char_id]);
  374. }
  375. $char_T_MasterLevelSystem->closeCursor();
  376. }
  377. }
  378.  
  379. $account_data['MuOnline']['T_MasterLevelSystem'] = $character_T_MasterLevelSystem;
  380.  
  381. $warehouse_select = $db->prepare("SELECT AccountID,Items,Money,EndUseDate,DbVersion,pw,ExtCKNum,NeedExtCK from warehouse where AccountID=?");
  382. $warehouse_select->execute(array($memb___id));
  383. $warehouse = $warehouse_select->fetch();
  384. $warehouse_select->closeCursor();
  385.  
  386. /*
  387. $account_Items_get = preg_replace('/[^A-Z0-9]/','',$warehouse[1]);
  388. if(is_int(strlen($account_Items_get)/32) == false){
  389. $count_data = 0;
  390. $count_data = strlen($account_Items_get);
  391. $count_data = $count_data-1;
  392. $account_Items_get = substr($account_Items_get,0,$count_data);
  393. }
  394. $count_data = 0;
  395. $count_data = strlen($account_Items_get);
  396. $count_data = $count_data-32;
  397. $account_Items = substr($account_Items_get,0,$count_data).str_repeat('F',32);
  398.  
  399. unset($warehouse[1]);
  400. */
  401. $warehouse = array_values($warehouse);
  402. $account_data['MuOnline']['warehouse'] = $warehouse;
  403. if($post_set_account == 1 && isset($account_data['MuOnline']['warehouse'][0])){
  404. $account_data['MuOnline']['warehouse'][0] = $memb___id_post;
  405. }
  406.  
  407.  
  408. $i = $db->prepare("Use ".$config['mssql']['db_me_muonline']);
  409. $i->execute();
  410.  
  411. if($set_new_pass == 1){
  412. //$fn_check = $db->prepare("Select [dbo].[fn_md5](?,?)");
  413. //$fn_check->execute(array($memb___pwd_post,$memb___id_search));
  414. //$ipwd = $fn_check->fetch();
  415. //$fn_check->closeCursor();
  416. $account_data['Me_MuOnline']['MEMB_INFO'][1] = $memb___pwd_post;//$ipwd[0];
  417. }
  418.  
  419. //$config['debug'] = 1;
  420.  
  421. $db2->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  422. $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  423. try{
  424. $db2->beginTransaction();
  425.  
  426.  
  427. $password_set = $account_data['Me_MuOnline']['MEMB_INFO'][1];
  428. unset($account_data['Me_MuOnline']['MEMB_INFO'][1]);
  429. $account_data['Me_MuOnline']['MEMB_INFO'] = array_values($account_data['Me_MuOnline']['MEMB_INFO']);
  430.  
  431. if($account_data['Me_MuOnline']['MEMB_INFO'][12] == ''){
  432. $account_data['Me_MuOnline']['MEMB_INFO'][12] = 0;
  433. }
  434.  
  435.  
  436. $memb_info_insert = $db2->prepare("insert into MEMB_INFO(memb___id,memb__pwd,memb_name,sno__numb,mail_addr,addr_info,appl_days,modi_days,out__days,true_days,mail_chek,bloc_code,ctl1_code,JF,cspoints,VipStamp,MasterKey,AccountLock,Remark,TempCredits,LuckyCoin,transfer_server)values(?,'".$password_set."',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,2)");
  437. $memb_info_insert->execute($account_data['Me_MuOnline']['MEMB_INFO']);
  438.  
  439. if(isset($account_data['Me_MuOnline']['MEMB_CREDITS'][0])){
  440. if($account_data['Me_MuOnline']['MEMB_CREDITS'][1] == '' ){$account_data['Me_MuOnline']['MEMB_CREDITS'][1] = 0;}
  441. if($account_data['Me_MuOnline']['MEMB_CREDITS'][2] == '' ){$account_data['Me_MuOnline']['MEMB_CREDITS'][2] = 0;}
  442. if($account_data['Me_MuOnline']['MEMB_CREDITS'][3] == '' ){$account_data['Me_MuOnline']['MEMB_CREDITS'][3] = 0;}
  443. $memb_credits_insert = $db2->prepare("insert into MEMB_CREDITS(memb___id,credits,TempCredits,vippoints)values(?,?,?,?)");
  444. $memb_credits_insert->execute($account_data['Me_MuOnline']['MEMB_CREDITS']);
  445. }
  446.  
  447.  
  448.  
  449. $i = $db2->prepare("Use ".$config['mssql2']['db_muonline']);
  450. $i->execute();
  451.  
  452. $insert_log = $db2->prepare("Insert into MUCore_Admin_Logs(username,game_master,ip,date,action,module,server_id)values(?,?,?,?,?,?,?)");
  453. $insert_log->execute(array($memb___id,'',$_SERVER['REMOTE_ADDR'],time(),'Transfered his account. Original Account Name: '.$memb___id.' / New Account Name: '.o($memb___id_post).'','PMU_TRANSFERED_ACCOUNTS',1));
  454.  
  455.  
  456. if($accountcharacter_insert_script == 1){
  457. $accountcharacter_insert = $db2->prepare("Insert into AccountCharacter (Id,GameID1,GameID2,GameID3,GameID4,GameID5,GameIDC,MoveCnt,Summoner,ExtVault,Ragefighter)values(?,?,?,?,?,?,?,?,?,?,?)");
  458. $accountcharacter_insert->execute(array(
  459. $account_data['MuOnline']['AccountCharacter'][0],$accountcharacter_list_new[1],$accountcharacter_list_new[2],$accountcharacter_list_new[3],$accountcharacter_list_new[4],$accountcharacter_list_new[5],$account_data['MuOnline']['AccountCharacter'][6],$account_data['MuOnline']['AccountCharacter'][7],$account_data['MuOnline']['AccountCharacter'][8],$account_data['MuOnline']['AccountCharacter'][9],$account_data['MuOnline']['AccountCharacter'][10]
  460. ));
  461.  
  462.  
  463. foreach($accountcharacter_list as $char_id => $char_var){
  464. if(!empty($char_var) && isset($account_data['MuOnline']['Character'][$char_id])){
  465.  
  466. if($account_data['MuOnline']['Character'][$char_id][5] < 0){
  467. $account_data['MuOnline']['Character'][$char_id][5] = 0;
  468. }
  469.  
  470. if($account_data['MuOnline']['Character'][$char_id][6] > 32767){
  471. $account_data['MuOnline']['Character'][$char_id][6] = 32767;
  472. }
  473.  
  474.  
  475. if($account_data['MuOnline']['Character'][$char_id][7] > 32767){
  476. $account_data['MuOnline']['Character'][$char_id][7] = 32767;
  477. }
  478.  
  479. if($account_data['MuOnline']['Character'][$char_id][8] > 32767){
  480. $account_data['MuOnline']['Character'][$char_id][8] = 32767;
  481. }
  482.  
  483. if($account_data['MuOnline']['Character'][$char_id][9] > 32767){
  484. $account_data['MuOnline']['Character'][$char_id][9] = 32767;
  485. }
  486.  
  487. if($account_data['MuOnline']['Character'][$char_id][26] > 32767){
  488. $account_data['MuOnline']['Character'][$char_id][26] = 32767;
  489. }
  490.  
  491. /*$Inventory = $character_Inventory[$char_id];
  492. $MagicList = $character_MagicList[$char_id];
  493. $Quest = $character_Quest[$char_id];
  494.  
  495. $insert_character = $db2->prepare("Insert Into Character (AccountID,Name,cLevel,LevelUpPoint,Class,Experience,Strength,Dexterity,Vitality,Energy,Inventory,Money,Life,MaxLife,Mana,MaxMana,MapNumber,MapPosX,MapPosY,MapDir,PkCount,PkLevel,PkTime,MDate,LDate,CtlCode,DbVersion,Quest,Leadership,ChatLimitTime,FruitPoint,JHDX,JHtype,Grand_Resets,Resets,EDSPostCmd,CirePkRank,EDSPostBanTime,GensRank,GensContribution,GensType,GensLastLeave,GensKnight,PCPoints,TempPcPoints,PvPLastStandWin,MasterResetCount,ExtInventory,S6EP3_PS_FIX)values(?,?,?,?,?,?,?,?,?,?,0x".$Inventory.",?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,0x".$Quest.",?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");*/
  496.  
  497. $insert_character = $db2->prepare("Insert Into Character (AccountID,Name,cLevel,LevelUpPoint,Class,Experience,Strength,Dexterity,Vitality,Energy,Inventory,Money,Life,MaxLife,Mana,MaxMana,MapNumber,MapPosX,MapPosY,MapDir,PkCount,PkLevel,PkTime,MDate,LDate,CtlCode,DbVersion,Quest,Leadership,ChatLimitTime,FruitPoint,JHDX,JHtype,Grand_Resets,Resets,EDSPostCmd,CirePkRank,EDSPostBanTime,GensRank,GensContribution,GensType,GensLastLeave,GensKnight,PCPoints,TempPcPoints,PvPLastStandWin,MasterResetCount,ExtInventory,S6EP3_PS_FIX)values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
  498.  
  499. $insert_character->execute($account_data['MuOnline']['Character'][$char_id]);
  500.  
  501. }
  502. }
  503.  
  504. foreach($accountcharacter_list as $char_id => $char_var){
  505. if(!empty($char_var) && isset($account_data['MuOnline']['OptionData'][$char_id])){
  506. $column_1 = $account_data['MuOnline']['OptionData'][$char_id][1];
  507. unset($account_data['MuOnline']['OptionData'][$char_id][1]);
  508. $account_data['MuOnline']['OptionData'][$char_id] = array_values($account_data['MuOnline']['OptionData'][$char_id]);
  509.  
  510.  
  511.  
  512.  
  513.  
  514. $check_opt_data = $db2->prepare("Select Name from OptionData where Name=?");
  515. $check_opt_data->execute(array($char_var));
  516. if($check_opt_data_res = $check_opt_data->fetch()){
  517. $delete_character_OptionData = $db2->prepare("Delete from OptionData where name=?");
  518. $delete_character_OptionData->execute(array($char_var));
  519.  
  520. $insert_character_OptionData = $db2->prepare("Insert Into OptionData (Name,SkillKey,GameOption,Qkey,Wkey,Ekey,ChatWindow,RKey,QWERLevel)values(?,0x".$column_1.",?,?,?,?,?,?,?)");
  521. $insert_character_OptionData->execute($account_data['MuOnline']['OptionData'][$char_id]);
  522.  
  523.  
  524.  
  525. }else{
  526. $insert_character_OptionData = $db2->prepare("Insert Into OptionData (Name,SkillKey,GameOption,Qkey,Wkey,Ekey,ChatWindow,RKey,QWERLevel)values(?,0x".$column_1.",?,?,?,?,?,?,?)");
  527. $insert_character_OptionData->execute($account_data['MuOnline']['OptionData'][$char_id]);
  528.  
  529. }
  530.  
  531. }
  532. }
  533.  
  534. foreach($accountcharacter_list as $char_id => $char_var){
  535. if(!empty($char_var) && isset($account_data['MuOnline']['T_MasterLevelSystem'][$char_id])){
  536.  
  537. $insert_character_T_MasterLevelSystem = $db2->prepare("Insert Into T_MasterLevelSystem (CHAR_NAME,MASTER_LEVEL,ML_EXP,ML_NEXTEXP,ML_POINT)values(?,?,?,?,?)");
  538. $insert_character_T_MasterLevelSystem->execute($account_data['MuOnline']['T_MasterLevelSystem'][$char_id]);
  539. }
  540. }
  541.  
  542.  
  543.  
  544. }
  545.  
  546.  
  547.  
  548. if(isset($account_data['MuOnline']['warehouse'][0])){
  549. $Items = $account_Items;
  550.  
  551. $warehouse_insert = $db2->prepare("Insert Into warehouse (AccountID,Items,Money,EndUseDate,DbVersion,pw,ExtCKNum,NeedExtCK)values(?,?,?,?,?,?,?,?)");
  552. $warehouse_insert->execute($account_data['MuOnline']['warehouse']);
  553. }
  554.  
  555.  
  556.  
  557. $update_transfer = $db->prepare("Update MEMB_INFO set transfer=? where memb___id=?");
  558. $update_transfer->execute(array(1,$memb___id));
  559.  
  560.  
  561.  
  562.  
  563.  
  564. $db2->commit();
  565.  
  566.  
  567.  
  568.  
  569. echo alert('Your account have been successfully transfered!',1);
  570.  
  571.  
  572.  
  573.  
  574. }catch(Exception $e){
  575. $db2->rollBack();
  576. echo alert(MSSQL_ERROR,0);
  577. if($config['debug'] == 1){
  578. print_r($e);
  579. }
  580.  
  581. }
  582.  
  583.  
  584.  
  585.  
  586.  
  587.  
  588. }else{
  589.  
  590. if($transfer_error == 1){
  591. echo alert('In order to complete your transfer you have to update the following info! <br>Note: Symbols will not be accepted anymore on Username or Character\'s name!',0);
  592. }
  593.  
  594.  
  595. echo '
  596.  
  597. <div align="left">
  598. <form method="post" name="lgnform" id="lgnform" action="'.$config['web_address'].'?verification=1">
  599.  
  600. <div style="margin-top: 20px;"><h3>Account Info</h3></div>
  601. ';
  602.  
  603. if($account_exist == 1 || $post_set_account == 1){
  604. echo '
  605. <div style="margin-bottom: 10px;">
  606. <div style="float:left; width: 100px; line-height: 20px;">Old Username:</div>
  607. <div style="float:left; width: 150px; line-height: 20px;">'.o($memb___id).'</div>
  608. <div style="float:left;"><input type="text" value="'.o($memb___id_post).'" name="newusername" style="width: 150px;" maxlength="10" placeholder="enter your new username" class="'.$account_exist_error.'"> <small>letters/numbers, length: 4 - 10</small></div>
  609. <div style="clear:both;"></div>
  610. </div>';
  611. }else{
  612. echo '
  613. <div style="margin-bottom: 10px;">
  614. <div style="float:left; width: 100px; line-height: 20px;">Username:</div>
  615. <div style="float:left; width: 150px; line-height: 20px;">'.o($memb___id).'</div>
  616. <div style="clear:both;"></div>
  617. </div>';
  618. }
  619.  
  620.  
  621. if($account_exist == 1 || $post_set_account == 1 || $set_new_pass == 1){
  622. echo '
  623. <div style="margin-bottom: 10px;">
  624. <div style="float:left; width: 100px; line-height: 20px;">Old Password:</div>
  625. <div style="float:left; width: 150px; line-height: 20px;">******</div>
  626. <div style="float:left;"><input type="password" value="'.o($memb___pwd_post).'" name="newpass" style="width: 150px;" maxlength="10" placeholder="enter your new password" class="'.$pwd_error.'"> <small>letters/numbers, length: 4 - 10</small></div>
  627. <div style="clear:both;"></div>
  628. </div>';
  629.  
  630. echo '
  631. <div style="margin-bottom: 10px;">
  632. <div style="float:left; width: 100px; line-height: 20px;">&nbsp;</div>
  633. <div style="float:left; width: 150px; line-height: 20px;">&nbsp;</div>
  634. <div style="float:left;"><input type="password" value="'.o($memb___repwd_post).'" name="newrepass" style="width: 150px;" maxlength="10" placeholder="confirm your new password" class="'.$repwd_error.'"></div>
  635. <div style="clear:both;"></div>
  636. </div>';
  637.  
  638. }
  639.  
  640. if($mail_exist == 1 || $post_set_mail == 1){
  641. echo '
  642. <div style="margin-bottom: 10px;">
  643. <div style="float:left; width: 100px; line-height: 20px;">Old E-mail:</div>
  644. <div style="float:left; width: 150px; line-height: 20px;">'.o($memb___mail).'</div>
  645. <div style="float:left;"><input type="text" value="'.o($memb___mail_post).'" name="newmail" style="width: 280px;" maxlength="100" placeholder="enter your new e-mail" class="'.$mail_exist_error.'"></div>
  646. <div style="clear:both;"></div>
  647. </div>';
  648. }else{
  649. echo '
  650. <div style="margin-bottom: 10px;">
  651. <div style="float:left; width: 100px; line-height: 20px;">E-mail:</div>
  652. <div style="float:left; width: 150px; line-height: 20px;">'.o($memb___mail).'</div>
  653. <div style="clear:both;"></div>
  654. </div>';
  655. }
  656.  
  657.  
  658. echo '<div style="margin-top: 20px;"><h3>Characters Info</h3></div>';
  659.  
  660. foreach($accountcharacter_list as $cel_id => $cel_var){
  661.  
  662. if(isset($character_exist_list[$cel_id])){
  663. echo '
  664. <div style="margin-bottom: 10px;">
  665. <div style="float:left; width: 150px; line-height: 20px;">Old Character Name '.$cel_id.':</div>
  666. <div style="float:left; width: 100px; line-height: 20px;">'.o($cel_var).'</div>
  667. <div style="float:left;"><input type="text" value="'.o($character_post[$cel_id]).'" name="newcharacter['.$cel_id.']" style="width: 140px;" maxlength="8" placeholder="enter your new name" class="'.$character_exist_error[$cel_id].'"> <small>letters/numbers, length: 4 - 8</small></div>
  668. <div style="clear:both;"></div>
  669. </div>';
  670.  
  671. }else{
  672. if(empty($cel_var)){
  673. $chr_name_html = '- empty -';
  674. }else{
  675. $chr_name_html = o($cel_var);
  676. }
  677. echo '
  678. <div style="margin-bottom: 10px;">
  679. <div style="float:left; width: 150px; line-height: 20px;">Character Name '.$cel_id.':</div>
  680. <div style="float:left; width: 100px; line-height: 20px;">'.$chr_name_html.'</div>
  681. <div style="clear:both;"></div>
  682. </div>';
  683. }
  684.  
  685.  
  686.  
  687.  
  688. }
  689.  
  690.  
  691.  
  692.  
  693. echo '<div style="margin-top: 20px;"><h3>Points Info</h3></div>
  694.  
  695. <div style="margin-bottom: 10px;">
  696. <div style="float:left; width: 150px; line-height: 20px;">VIP Points:</div>
  697. <div style="float:left; width: 100px; line-height: 20px;">'.number_format($memb_credits[3]).'</div>
  698. <div style="clear:both;"></div>
  699. </div>
  700.  
  701. <div style="margin-bottom: 10px;">
  702. <div style="float:left; width: 150px; line-height: 20px;">Cash Points:</div>
  703. <div style="float:left; width: 100px; line-height: 20px;">'.number_format($memb_info[14]).'</div>
  704. <div style="clear:both;"></div>
  705. </div>
  706.  
  707. <div style="margin-bottom: 10px;">
  708. <div style="float:left; width: 150px; line-height: 20px;">Credit Points:</div>
  709. <div style="float:left; width: 100px; line-height: 20px;">'.number_format($memb_credits[1]).'</div>
  710. <div style="clear:both;"></div>
  711. </div>
  712.  
  713. ';
  714.  
  715.  
  716. if($post_set_good_transfer == 1){
  717. echo '<div align="center" style="margin-top: 40px; margin-bottom: 20px;">
  718. <input type="button" value="Proceed Transfer Account Information!" id="submit_btn">
  719. <input type="hidden" name="transfer_done">
  720. </div>';
  721. }else{
  722. echo '<div align="center" style="margin-top: 40px; margin-bottom: 20px;">
  723. <input type="submit" value="Verify Again!" id="submit_btn2">
  724. <input type="hidden" name="transfer">
  725. </div>';
  726. }
  727. echo '
  728.  
  729. </form>
  730. </div>
  731.  
  732. ';
  733.  
  734. }
  735. }
  736.  
  737.  
  738.  
  739. }else{
  740. echo alert('In order to transfer all your account information to the new server, we have to verify your info!',2);
  741. echo '<div><input type="button" onclick="location.href=\''.$config['web_address'].'?verification=1\';" value="Proceed Verificaiton!" ></div>';
  742. }
  743.  
  744. unset($account_data);
  745. unset($character_Inventory);
  746. unset($character_MagicList);
  747. unset($character_Quest);
  748. unset($memb_info);
  749. unset($memb_credits);
  750. unset($accountcharacter);
  751. unset($check_character_results);
  752. unset($check_account_results);
  753. unset($check_mail_results);
  754. unset($character);
  755. unset($character_OptionData);
  756. unset($character_T_MasterLevelSystem);
  757. unset($warehouse);
  758.  
  759. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!