API tools faq
paste
Advertisement
AhmedSokr

Untitled

AhmedSokr
Nov 13th, 2019
306
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 64.90 KB | None | 0 0
raw download clone embed print report
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Drawing;
  4. using System.Linq;
  5. using System.Text.RegularExpressions;
  6. using System.Threading.Tasks;
  7. using Conquer_Online_Server.Client;
  8. using Conquer_Online_Server.Database;
  9. using Conquer_Online_Server.Game;
  10. using Conquer_Online_Server.Game.ConquerStructures;
  11. using Conquer_Online_Server.Game.ConquerStructures.Society;
  12. using Conquer_Online_Server.Interfaces;
  13. using Conquer_Online_Server.Network;
  14. using Conquer_Online_Server.Network.GamePackets;
  15. using MySql.Data.MySqlClient;
  16.  
  17. namespace Conquer_Online_Server
  18. {
  19. class Transfer
  20. {
  21. public static string server1;
  22. public static string server2;
  23. public static string server3;
  24. public static string server4;
  25. public static string db1;
  26. public static string db2;
  27. public static string db3;
  28. public static string db4;
  29. public void Server1(GameState client)
  30. {
  31. #region connection
  32. string ConnectionString = "datasource=localhost;port=3306;database='" + db1 + "';username=root;password=123456";
  33. MySqlConnection conn1 = new MySqlConnection(ConnectionString);
  34. #endregion
  35. #region server1
  36.  
  37. uint uid;
  38. uid = client.Entity.UID;
  39.  
  40.  
  41. #region accounts
  42. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("accounts").Where("EntityID", uid))
  43. using (var reader = new MySqlReader(cmd))
  44. {
  45. if (reader.Read())
  46. {
  47. client.Entity.email = reader.ReadString("Email");
  48. client.Entity.pass = reader.ReadString("Password");
  49. client.Entity.Username = reader.ReadString("Username");
  50. }
  51.  
  52. }
  53. // Mysql Info For Server 1
  54.  
  55. conn1.Open();
  56. MySql.Data.MySqlClient.MySqlCommand cmds;
  57. cmds = new MySql.Data.MySqlClient.MySqlCommand("Insert into accounts(Username,Password,Email,EntityID) values ('" + client.Entity.Name + "','" + client.Entity.pass + "','" + client.Entity.email + "'," + client.Entity.UID + ")", conn1);
  58. cmds.ExecuteNonQuery();
  59.  
  60.  
  61. conn1.Close();
  62. #endregion
  63. #region var entities
  64.  
  65. uint cps = client.Entity.ConquerPoints;
  66. uint level = client.Entity.Level;
  67. uint herstyel = client.Entity.HairStyle;
  68. uint herclor = client.Entity.HairColor;
  69. uint classs = client.Entity.Class;
  70. uint moeny = client.Entity.Money;
  71.  
  72. uint face = client.Entity.Face;
  73. uint pkpoint = client.Entity.PKPoints;
  74. uint strenth = client.Entity.Strength;
  75. uint agility = client.Entity.Agility;
  76. uint vitialty = client.Entity.Vitality;
  77. uint spirsit = client.Entity.Spirit;
  78. uint atrbyt = client.Entity.Atributes;
  79. uint Hitpoints = client.Entity.Hitpoints;
  80. uint Mana = client.Entity.Mana;
  81. uint MapID = client.Entity.MapID;
  82. ulong Experience = client.Entity.Experience;
  83. uint PreviousMapID = client.Entity.PreviousMapID;
  84. uint Reborn = client.Entity.Reborn;
  85. string Spouse = client.Entity.Spouse;
  86. uint WarehousePW = client.WarehousePW;
  87. uint MoneySave = client.MoneySave;
  88. uint FirstRebornClass = client.Entity.FirstRebornClass;
  89. uint SecondRebornLevel = client.Entity.SecondRebornLevel;
  90. uint EnlightenPoints = client.Entity.EnlightenPoints;
  91. uint GuildID = client.Entity.GuildID;
  92. uint GuildRankss = client.Entity.GuildRank;
  93. uint ClanId = client.Entity.ClanId;
  94. uint PreviousX = client.Entity.PrevX;
  95. uint PreviousY = client.Entity.PrevY;
  96. uint VIPLevel = client.Entity.VIPLevel;
  97. uint SubClassd = client.Entity.SubClass;
  98. uint SubClassLevel = client.Entity.SubClassLevel;
  99. uint ReincarnationLev = client.Entity.ReincarnationLev;
  100. uint VirtuePoints = client.Entity.VirtuePoints;
  101. uint xxx = client.Entity.X;
  102. uint yyy = client.Entity.Y;
  103. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("entities").Where("UID", uid))
  104. using (var reader = new MySqlReader(cmd))
  105.  
  106. if (reader.Read())
  107. {
  108. client.Entity.Bodys = reader.ReadUInt16("Body");
  109. }
  110.  
  111.  
  112. #endregion
  113. #region entities
  114.  
  115. conn1.Open();
  116.  
  117. cmds = new MySql.Data.MySqlClient.MySqlCommand("Insert into entities(SubClass,SubClassLevel,Donation,X,Y,SecondRebornLevel,FirstRebornLevel,VIPLevel,MoneySave,FirstRebornClass,SecondRebornClass,PKPoints,Face,Money,Class,Agility,Vitality,Spirit,Strength,Atributes,Body,Name,UID,Owner,ConquerPoints,LastLogin,Level,HairStyle,Hitpoints,Mana,MapID,Experience,PreviousMapID,Reborn,Spouse,WarehousePW,jail,BoundCPs) values (" + SubClassd + "," + SubClassLevel + "," + client.NobilityInformation.Donation + "," + xxx + "," + yyy + "," + client.Entity.SecondRebornLevel + "," + client.Entity.FirstRebornLevel + "," + client.Entity.VIPLevel + "," + MoneySave + "," + FirstRebornClass + "," + client.Entity.SecondRebornClass + "," + pkpoint + "," + face + "," + moeny + "," + classs + "," + atrbyt + "," + spirsit + "," + strenth + "," + vitialty + "," + agility + "," + client.Entity.Bodys + ",'" + client.Entity.Name + "'," + uid + ",'" + client.Entity.Name + "'," + cps + ",'" + client.Entity.LastLogin + "'," + level + "," + herstyel + "," + Hitpoints + "," + Mana + "," + MapID + "," + Experience + "," + PreviousMapID + "," + Reborn + ",'" + Spouse + "'," + WarehousePW + "," + client.Entity.Jail + "," + client.Entity.BoundCps + ")", conn1);
  118. cmds.ExecuteNonQuery();
  119.  
  120. conn1.Close();
  121.  
  122.  
  123. #endregion
  124. #region nobilty
  125.  
  126. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("nobility").Where("EntityUID", uid))
  127. using (var reader = new MySqlReader(cmd))
  128. {
  129. int count = reader.NumberOfRows;
  130. while (reader.Read())
  131. {
  132. for (int i = 0; i < count; i++)
  133. {
  134.  
  135. }
  136. }
  137.  
  138. if (reader.Read())
  139. {
  140. client.Entity.namedon = reader.ReadString("EntityName");
  141. client.Entity.Donation = reader.ReadUInt128("Donation");
  142. client.Entity.Gender = reader.ReadInt32("Gender");
  143. client.Entity.Mesho = reader.ReadUInt128("Mesh");
  144. }
  145. }
  146. conn1.Open();
  147. MySql.Data.MySqlClient.MySqlCommand cmd2;
  148. cmd2 = new MySql.Data.MySqlClient.MySqlCommand("Insert into nobility(EntityUID,EntityName,Donation,Gender,Mesh) values (" + client.Entity.UID + ",'" + client.Entity.Name + "'," + client.Entity.Donation + "," + client.Entity.Gender + "," + client.Entity.Mesh + ")", conn1);
  149. cmd2.ExecuteNonQuery();
  150. conn1.Close();
  151. //MySqlCommand2 cmdd = new MySqlCommand2(MySqlCommandType2.INSERT);
  152. // cmdd.Insert("nobility").Insert("EntityUID", uid)
  153. // .Insert("EntityName", client.Entity.namedon)
  154. // .Insert("Donation", client.Entity.Donation)
  155. // .Insert("Gender", client.Entity.Gender)
  156. // .Insert("Mesh", client.Entity.Mesh)
  157. // .Execute();
  158. #endregion
  159. #region chi
  160.  
  161. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("chi").Where("uid", uid))
  162. using (var reader = new MySqlReader(cmd))
  163. {
  164.  
  165.  
  166. if (reader.Read())
  167. {
  168. client.Entity.namechi = reader.ReadString("name");
  169. client.Entity.pointschi = reader.ReadUInt128("points");
  170.  
  171.  
  172.  
  173. conn1.Open();
  174. MySql.Data.MySqlClient.MySqlCommand cmd22;
  175. cmd22 = new MySql.Data.MySqlClient.MySqlCommand("Insert into chi(uid,name,points) values (" + client.Entity.UID + ",'" + client.Entity.namechi + "'," + client.Entity.pointschi + ")", conn1);
  176. cmd22.ExecuteNonQuery();
  177. conn1.Close();
  178. }
  179. }
  180. #endregion
  181. #region skills
  182.  
  183. #region var skills
  184.  
  185. int reuint;
  186.  
  187. int skillsid;
  188. int levelskill;
  189. int perlevel;
  190. int templevel;
  191. int hu1;
  192. int hu2;
  193. #endregion
  194.  
  195.  
  196.  
  197.  
  198. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("skills").Where("EntityID", uid))
  199. using (var reader33 = new MySqlReader(cmd))
  200. {
  201.  
  202. for (int i = 43345; i >= 0; i--)
  203. {
  204.  
  205. if (reader33.Read())
  206. {
  207. skillsid = reader33.ReadInt32("ID");
  208. levelskill = reader33.ReadInt32("Level");
  209. perlevel = reader33.ReadInt32("PreviousLevel");
  210. templevel = reader33.ReadInt32("TempLevel");
  211. hu1 = reader33.ReadInt32("LevelHu");
  212. hu2 = reader33.ReadInt32("LevelHu2");
  213. reuint = reader33.ReadInt32("EntityID");
  214.  
  215. if (client.Entity.UID == reuint)
  216. {
  217.  
  218. conn1.Open();
  219. cmds = new MySql.Data.MySqlClient.MySqlCommand("Insert into skills(ID,EntityID,Level,PreviousLevel,TempLevel,LevelHu,LevelHu2) values (" + skillsid + "," + uid + "," + levelskill + "," + perlevel + "," + templevel + "," + hu1 + "," + hu2 + ")", conn1);
  220. cmds.ExecuteNonQuery();
  221. conn1.Close();
  222. }
  223.  
  224. }
  225. }
  226.  
  227. }
  228. #endregion
  229. #region Items
  230.  
  231. #region var items
  232. int noff, reuint2;
  233. int noff2;
  234. int itemid;
  235. int uiditem;
  236. int plus;
  237. int bless;
  238. int Enchant;
  239. int SocketOne;
  240. int SocketTwo;
  241. int Durability;
  242. int MaximDurability;
  243. int SocketProgress;
  244. int PlusProgress;
  245. int Effect;
  246. int Bound;
  247. int Locked;
  248. int UnlockEnd;
  249. int Suspicious;
  250. int SuspiciousStart;
  251. int Color;
  252. int Position;
  253. int Warehouse;
  254. int StackSize, Inscribed, agate, RefineryStarted, RefineryPercent, RefineryLevel, RefineryItem, RefineryTime, NextSteedColor, DayStamp, Days;
  255.  
  256. #endregion
  257.  
  258. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("items").Where("EntityID", uid))
  259. using (var reader = new MySqlReader(cmd))
  260. {
  261.  
  262.  
  263. for (int i = 400000; i >= 0; i--)
  264. {
  265. if (reader.Read())
  266. {
  267. #region var items loop
  268. reuint2 = reader.ReadInt32("EntityID");
  269. itemid = reader.ReadInt32("ID");
  270. uiditem = reader.ReadInt32("UID");
  271. plus = reader.ReadInt32("Plus");
  272. bless = reader.ReadInt32("Bless");
  273. Enchant = reader.ReadInt32("Enchant");
  274. SocketOne = reader.ReadInt32("SocketOne");
  275. SocketTwo = reader.ReadInt32("SocketTwo");
  276. Durability = reader.ReadInt32("Durability");
  277. MaximDurability = reader.ReadInt32("MaximDurability");
  278. SocketProgress = reader.ReadInt32("SocketProgress");
  279. PlusProgress = reader.ReadInt32("PlusProgress");
  280. Effect = reader.ReadInt32("Effect");
  281. Bound = reader.ReadInt32("Bound");
  282. Locked = reader.ReadInt32("Locked");
  283. UnlockEnd = reader.ReadInt32("UnlockEnd");
  284. Suspicious = reader.ReadInt32("Suspicious");
  285. SuspiciousStart = reader.ReadInt32("SuspiciousStart");
  286. Color = reader.ReadInt32("Color");
  287. Position = reader.ReadInt32("Position");
  288. Warehouse = reader.ReadInt32("Warehouse");
  289. StackSize = reader.ReadInt32("StackSize");
  290. Inscribed = reader.ReadInt32("Inscribed");
  291. agate = reader.ReadInt32("agate");
  292. RefineryStarted = reader.ReadInt32("RefineryStarted");
  293. RefineryPercent = reader.ReadInt32("RefineryPercent");
  294. RefineryLevel = reader.ReadInt32("RefineryLevel");
  295. RefineryItem = reader.ReadInt32("RefineryItem");
  296. RefineryTime = reader.ReadInt32("RefineryTime");
  297. NextSteedColor = reader.ReadInt32("NextSteedColor");
  298. DayStamp = reader.ReadInt32("DayStamp");
  299. Days = reader.ReadInt32("Days");
  300. #endregion
  301.  
  302. if (client.Entity.UID == reuint2)
  303. {
  304. conn1.Open();
  305. cmds = new MySql.Data.MySqlClient.MySqlCommand("Insert into items(EntityID,ID,UID,Plus,Bless,Enchant,SocketOne,SocketTwo,Durability,MaximDurability,SocketProgress,PlusProgress,Effect,Bound,Locked,UnlockEnd,Suspicious,SuspiciousStart,Color,Position,Warehouse,StackSize,Inscribed,agate,RefineryStarted,RefineryPercent,RefineryLevel,RefineryItem,RefineryTime,NextSteedColor,DayStamp,Days) values (" + uid + "," + itemid + "," + uiditem + "," + plus + "," + bless + "," + Enchant + "," + SocketOne + "," + SocketTwo + "," + Durability + "," + MaximDurability + "," + SocketProgress + "," + PlusProgress + "," + Effect + "," + Bound + "," + Locked + "," + UnlockEnd + "," + Suspicious + "," + SuspiciousStart + "," + Color + "," + Position + "," + Warehouse + "," + StackSize + "," + Inscribed + "," + agate + "," + RefineryStarted + "," + RefineryPercent + "," + RefineryLevel + "," + RefineryItem + "," + RefineryTime + "," + NextSteedColor + "," + DayStamp + "," + Days + ")", conn1);
  306. cmds.ExecuteNonQuery();
  307. conn1.Close();
  308.  
  309. }
  310.  
  311. }
  312.  
  313. }
  314. }
  315. #endregion
  316. #region Delete Old DataBase Data
  317. string ConnectionString22 = "datasource=localhost;port=3306;database=mn;username=root;password=123456";
  318. MySqlConnection con = new MySqlConnection(ConnectionString22);
  319. con.Open();
  320.  
  321. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From accounts Where EntityID=" + uid + "", con);
  322. cmds.ExecuteNonQuery();
  323. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From entities Where UID=" + uid + "", con);
  324. cmds.ExecuteNonQuery();
  325. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From nobility Where EntityUID=" + uid + "", con);
  326. cmds.ExecuteNonQuery();
  327. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From skills Where EntityID=" + uid + "", con);
  328. cmds.ExecuteNonQuery();
  329. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From items Where EntityID=" + uid + "", con);
  330. cmds.ExecuteNonQuery();
  331. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From chi Where uid=" + uid + "", con);
  332. cmds.ExecuteNonQuery();
  333. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From profs Where EntityID=" + uid + "", con);
  334. cmds.ExecuteNonQuery();
  335. con.Close();
  336. #endregion
  337. #region disconnect and said good bay
  338. client.Disconnect();
  339. #endregion
  340.  
  341.  
  342.  
  343. #endregion
  344. }
  345. public void Server2(GameState client)
  346. {
  347. #region connection
  348. string ConnectionString = "datasource=localhost;port=3306;database='" + db2 + "';username=root;password=123456";
  349. MySqlConnection conn1 = new MySqlConnection(ConnectionString);
  350. #endregion
  351. #region server1
  352.  
  353. uint uid;
  354. uid = client.Entity.UID;
  355.  
  356.  
  357. #region accounts
  358. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("accounts").Where("EntityID", uid))
  359. using (var reader = new MySqlReader(cmd))
  360. {
  361. if (reader.Read())
  362. {
  363. client.Entity.email = reader.ReadString("Email");
  364. client.Entity.pass = reader.ReadString("Password");
  365. client.Entity.Username = reader.ReadString("Username");
  366. }
  367.  
  368. }
  369. // Mysql Info For Server 1
  370.  
  371. conn1.Open();
  372. MySql.Data.MySqlClient.MySqlCommand cmds;
  373. cmds = new MySql.Data.MySqlClient.MySqlCommand("Insert into accounts(Username,Password,Email,EntityID) values ('" + client.Entity.Name + "','" + client.Entity.pass + "','" + client.Entity.email + "'," + client.Entity.UID + ")", conn1);
  374. cmds.ExecuteNonQuery();
  375.  
  376.  
  377. conn1.Close();
  378. #endregion
  379. #region var entities
  380.  
  381. uint cps = client.Entity.ConquerPoints;
  382. uint level = client.Entity.Level;
  383. uint herstyel = client.Entity.HairStyle;
  384. uint herclor = client.Entity.HairColor;
  385. uint classs = client.Entity.Class;
  386. uint moeny = client.Entity.Money;
  387.  
  388. uint face = client.Entity.Face;
  389. uint pkpoint = client.Entity.PKPoints;
  390. uint strenth = client.Entity.Strength;
  391. uint agility = client.Entity.Agility;
  392. uint vitialty = client.Entity.Vitality;
  393. uint spirsit = client.Entity.Spirit;
  394. uint atrbyt = client.Entity.Atributes;
  395. uint Hitpoints = client.Entity.Hitpoints;
  396. uint Mana = client.Entity.Mana;
  397. uint MapID = client.Entity.MapID;
  398. ulong Experience = client.Entity.Experience;
  399. uint PreviousMapID = client.Entity.PreviousMapID;
  400. uint Reborn = client.Entity.Reborn;
  401. string Spouse = client.Entity.Spouse;
  402. uint WarehousePW = client.WarehousePW;
  403. uint MoneySave = client.MoneySave;
  404. uint FirstRebornClass = client.Entity.FirstRebornClass;
  405. uint SecondRebornLevel = client.Entity.SecondRebornLevel;
  406. uint EnlightenPoints = client.Entity.EnlightenPoints;
  407. uint GuildID = client.Entity.GuildID;
  408. uint GuildRankss = client.Entity.GuildRank;
  409. uint ClanId = client.Entity.ClanId;
  410. uint PreviousX = client.Entity.PrevX;
  411. uint PreviousY = client.Entity.PrevY;
  412. uint VIPLevel = client.Entity.VIPLevel;
  413. uint SubClassd = client.Entity.SubClass;
  414. uint SubClassLevel = client.Entity.SubClassLevel;
  415. uint ReincarnationLev = client.Entity.ReincarnationLev;
  416. uint VirtuePoints = client.Entity.VirtuePoints;
  417. uint xxx = client.Entity.X;
  418. uint yyy = client.Entity.Y;
  419. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("entities").Where("UID", uid))
  420. using (var reader = new MySqlReader(cmd))
  421.  
  422. if (reader.Read())
  423. {
  424. client.Entity.Bodys = reader.ReadUInt16("Body");
  425. }
  426.  
  427.  
  428. #endregion
  429. #region entities
  430.  
  431. conn1.Open();
  432.  
  433. cmds = new MySql.Data.MySqlClient.MySqlCommand("Insert into entities(SubClass,SubClassLevel,Donation,X,Y,SecondRebornLevel,FirstRebornLevel,VIPLevel,MoneySave,FirstRebornClass,SecondRebornClass,PKPoints,Face,Money,Class,Agility,Vitality,Spirit,Strength,Atributes,Body,Name,UID,Owner,ConquerPoints,LastLogin,Level,HairStyle,Hitpoints,Mana,MapID,Experience,PreviousMapID,Reborn,Spouse,WarehousePW,jail,BoundCPs) values (" + SubClassd + "," + SubClassLevel + "," + client.NobilityInformation.Donation + "," + xxx + "," + yyy + "," + client.Entity.SecondRebornLevel + "," + client.Entity.FirstRebornLevel + "," + client.Entity.VIPLevel + "," + MoneySave + "," + FirstRebornClass + "," + client.Entity.SecondRebornClass + "," + pkpoint + "," + face + "," + moeny + "," + classs + "," + atrbyt + "," + spirsit + "," + strenth + "," + vitialty + "," + agility + "," + client.Entity.Bodys + ",'" + client.Entity.Name + "'," + uid + ",'" + client.Entity.Name + "'," + cps + ",'" + client.Entity.LastLogin + "'," + level + "," + herstyel + "," + Hitpoints + "," + Mana + "," + MapID + "," + Experience + "," + PreviousMapID + "," + Reborn + ",'" + Spouse + "'," + WarehousePW + "," + client.Entity.Jail + "," + client.Entity.BoundCps + ")", conn1);
  434. cmds.ExecuteNonQuery();
  435.  
  436. conn1.Close();
  437.  
  438.  
  439. #endregion
  440. #region nobilty
  441.  
  442. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("nobility").Where("EntityUID", uid))
  443. using (var reader = new MySqlReader(cmd))
  444. {
  445. int count = reader.NumberOfRows;
  446. while (reader.Read())
  447. {
  448. for (int i = 0; i < count; i++)
  449. {
  450.  
  451. }
  452. }
  453.  
  454. if (reader.Read())
  455. {
  456. client.Entity.namedon = reader.ReadString("EntityName");
  457. client.Entity.Donation = reader.ReadUInt128("Donation");
  458. client.Entity.Gender = reader.ReadInt32("Gender");
  459. client.Entity.Mesho = reader.ReadUInt128("Mesh");
  460. }
  461. }
  462. conn1.Open();
  463. MySql.Data.MySqlClient.MySqlCommand cmd2;
  464. cmd2 = new MySql.Data.MySqlClient.MySqlCommand("Insert into nobility(EntityUID,EntityName,Donation,Gender,Mesh) values (" + client.Entity.UID + ",'" + client.Entity.Name + "'," + client.Entity.Donation + "," + client.Entity.Gender + "," + client.Entity.Mesh + ")", conn1);
  465. cmd2.ExecuteNonQuery();
  466. conn1.Close();
  467. //MySqlCommand2 cmdd = new MySqlCommand2(MySqlCommandType2.INSERT);
  468. // cmdd.Insert("nobility").Insert("EntityUID", uid)
  469. // .Insert("EntityName", client.Entity.namedon)
  470. // .Insert("Donation", client.Entity.Donation)
  471. // .Insert("Gender", client.Entity.Gender)
  472. // .Insert("Mesh", client.Entity.Mesh)
  473. // .Execute();
  474. #endregion
  475. #region chi
  476.  
  477. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("chi").Where("uid", uid))
  478. using (var reader = new MySqlReader(cmd))
  479. {
  480.  
  481.  
  482. if (reader.Read())
  483. {
  484. client.Entity.namechi = reader.ReadString("name");
  485. client.Entity.pointschi = reader.ReadUInt128("points");
  486.  
  487.  
  488.  
  489. conn1.Open();
  490. MySql.Data.MySqlClient.MySqlCommand cmd22;
  491. cmd22 = new MySql.Data.MySqlClient.MySqlCommand("Insert into chi(uid,name,points) values (" + client.Entity.UID + ",'" + client.Entity.namechi + "'," + client.Entity.pointschi + ")", conn1);
  492. cmd22.ExecuteNonQuery();
  493. conn1.Close();
  494. }
  495. }
  496. #endregion
  497. #region skills
  498.  
  499. #region var skills
  500.  
  501. int reuint;
  502.  
  503. int skillsid;
  504. int levelskill;
  505. int perlevel;
  506. int templevel;
  507. int hu1;
  508. int hu2;
  509. #endregion
  510.  
  511.  
  512.  
  513.  
  514. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("skills").Where("EntityID", uid))
  515. using (var reader33 = new MySqlReader(cmd))
  516. {
  517.  
  518. for (int i = 43345; i >= 0; i--)
  519. {
  520.  
  521. if (reader33.Read())
  522. {
  523. skillsid = reader33.ReadInt32("ID");
  524. levelskill = reader33.ReadInt32("Level");
  525. perlevel = reader33.ReadInt32("PreviousLevel");
  526. templevel = reader33.ReadInt32("TempLevel");
  527. hu1 = reader33.ReadInt32("LevelHu");
  528. hu2 = reader33.ReadInt32("LevelHu2");
  529. reuint = reader33.ReadInt32("EntityID");
  530.  
  531. if (client.Entity.UID == reuint)
  532. {
  533.  
  534. conn1.Open();
  535. cmds = new MySql.Data.MySqlClient.MySqlCommand("Insert into skills(ID,EntityID,Level,PreviousLevel,TempLevel,LevelHu,LevelHu2) values (" + skillsid + "," + uid + "," + levelskill + "," + perlevel + "," + templevel + "," + hu1 + "," + hu2 + ")", conn1);
  536. cmds.ExecuteNonQuery();
  537. conn1.Close();
  538. }
  539.  
  540. }
  541. }
  542.  
  543. }
  544. #endregion
  545. #region Items
  546.  
  547. #region var items
  548. int noff, reuint2;
  549. int noff2;
  550. int itemid;
  551. int uiditem;
  552. int plus;
  553. int bless;
  554. int Enchant;
  555. int SocketOne;
  556. int SocketTwo;
  557. int Durability;
  558. int MaximDurability;
  559. int SocketProgress;
  560. int PlusProgress;
  561. int Effect;
  562. int Bound;
  563. int Locked;
  564. int UnlockEnd;
  565. int Suspicious;
  566. int SuspiciousStart;
  567. int Color;
  568. int Position;
  569. int Warehouse;
  570. int StackSize, Inscribed, agate, RefineryStarted, RefineryPercent, RefineryLevel, RefineryItem, RefineryTime, NextSteedColor, DayStamp, Days;
  571.  
  572. #endregion
  573.  
  574. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("items").Where("EntityID", uid))
  575. using (var reader = new MySqlReader(cmd))
  576. {
  577.  
  578.  
  579. for (int i = 400000; i >= 0; i--)
  580. {
  581. if (reader.Read())
  582. {
  583. #region var items loop
  584. reuint2 = reader.ReadInt32("EntityID");
  585. itemid = reader.ReadInt32("ID");
  586. uiditem = reader.ReadInt32("UID");
  587. plus = reader.ReadInt32("Plus");
  588. bless = reader.ReadInt32("Bless");
  589. Enchant = reader.ReadInt32("Enchant");
  590. SocketOne = reader.ReadInt32("SocketOne");
  591. SocketTwo = reader.ReadInt32("SocketTwo");
  592. Durability = reader.ReadInt32("Durability");
  593. MaximDurability = reader.ReadInt32("MaximDurability");
  594. SocketProgress = reader.ReadInt32("SocketProgress");
  595. PlusProgress = reader.ReadInt32("PlusProgress");
  596. Effect = reader.ReadInt32("Effect");
  597. Bound = reader.ReadInt32("Bound");
  598. Locked = reader.ReadInt32("Locked");
  599. UnlockEnd = reader.ReadInt32("UnlockEnd");
  600. Suspicious = reader.ReadInt32("Suspicious");
  601. SuspiciousStart = reader.ReadInt32("SuspiciousStart");
  602. Color = reader.ReadInt32("Color");
  603. Position = reader.ReadInt32("Position");
  604. Warehouse = reader.ReadInt32("Warehouse");
  605. StackSize = reader.ReadInt32("StackSize");
  606. Inscribed = reader.ReadInt32("Inscribed");
  607. agate = reader.ReadInt32("agate");
  608. RefineryStarted = reader.ReadInt32("RefineryStarted");
  609. RefineryPercent = reader.ReadInt32("RefineryPercent");
  610. RefineryLevel = reader.ReadInt32("RefineryLevel");
  611. RefineryItem = reader.ReadInt32("RefineryItem");
  612. RefineryTime = reader.ReadInt32("RefineryTime");
  613. NextSteedColor = reader.ReadInt32("NextSteedColor");
  614. DayStamp = reader.ReadInt32("DayStamp");
  615. Days = reader.ReadInt32("Days");
  616. #endregion
  617.  
  618. if (client.Entity.UID == reuint2)
  619. {
  620. conn1.Open();
  621. cmds = new MySql.Data.MySqlClient.MySqlCommand("Insert into items(EntityID,ID,UID,Plus,Bless,Enchant,SocketOne,SocketTwo,Durability,MaximDurability,SocketProgress,PlusProgress,Effect,Bound,Locked,UnlockEnd,Suspicious,SuspiciousStart,Color,Position,Warehouse,StackSize,Inscribed,agate,RefineryStarted,RefineryPercent,RefineryLevel,RefineryItem,RefineryTime,NextSteedColor,DayStamp,Days) values (" + uid + "," + itemid + "," + uiditem + "," + plus + "," + bless + "," + Enchant + "," + SocketOne + "," + SocketTwo + "," + Durability + "," + MaximDurability + "," + SocketProgress + "," + PlusProgress + "," + Effect + "," + Bound + "," + Locked + "," + UnlockEnd + "," + Suspicious + "," + SuspiciousStart + "," + Color + "," + Position + "," + Warehouse + "," + StackSize + "," + Inscribed + "," + agate + "," + RefineryStarted + "," + RefineryPercent + "," + RefineryLevel + "," + RefineryItem + "," + RefineryTime + "," + NextSteedColor + "," + DayStamp + "," + Days + ")", conn1);
  622. cmds.ExecuteNonQuery();
  623. conn1.Close();
  624.  
  625. }
  626.  
  627. }
  628.  
  629. }
  630. }
  631. #endregion
  632. #region Delete Old DataBase Data
  633. string ConnectionString22 = "datasource=localhost;port=3306;database=mn;username=root;password=123456";
  634. MySqlConnection con = new MySqlConnection(ConnectionString22);
  635. con.Open();
  636.  
  637. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From accounts Where EntityID=" + uid + "", con);
  638. cmds.ExecuteNonQuery();
  639. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From entities Where UID=" + uid + "", con);
  640. cmds.ExecuteNonQuery();
  641. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From nobility Where EntityUID=" + uid + "", con);
  642. cmds.ExecuteNonQuery();
  643. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From skills Where EntityID=" + uid + "", con);
  644. cmds.ExecuteNonQuery();
  645. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From items Where EntityID=" + uid + "", con);
  646. cmds.ExecuteNonQuery();
  647. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From chi Where uid=" + uid + "", con);
  648. cmds.ExecuteNonQuery();
  649. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From profs Where EntityID=" + uid + "", con);
  650. cmds.ExecuteNonQuery();
  651. con.Close();
  652. #endregion
  653. #region disconnect and said good bay
  654. client.Disconnect();
  655. #endregion
  656.  
  657.  
  658.  
  659. #endregion
  660. }
  661. public void Server3(GameState client)
  662. {
  663. #region connection
  664. string ConnectionString = "datasource=localhost;port=3306;database='" + db3 + "';username=root;password=123456";
  665. MySqlConnection conn1 = new MySqlConnection(ConnectionString);
  666. #endregion
  667. #region server1
  668.  
  669. uint uid;
  670. uid = client.Entity.UID;
  671.  
  672.  
  673. #region accounts
  674. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("accounts").Where("EntityID", uid))
  675. using (var reader = new MySqlReader(cmd))
  676. {
  677. if (reader.Read())
  678. {
  679. client.Entity.email = reader.ReadString("Email");
  680. client.Entity.pass = reader.ReadString("Password");
  681. client.Entity.Username = reader.ReadString("Username");
  682. }
  683.  
  684. }
  685. // Mysql Info For Server 1
  686.  
  687. conn1.Open();
  688. MySql.Data.MySqlClient.MySqlCommand cmds;
  689. cmds = new MySql.Data.MySqlClient.MySqlCommand("Insert into accounts(Username,Password,Email,EntityID) values ('" + client.Entity.Name + "','" + client.Entity.pass + "','" + client.Entity.email + "'," + client.Entity.UID + ")", conn1);
  690. cmds.ExecuteNonQuery();
  691.  
  692.  
  693. conn1.Close();
  694. #endregion
  695. #region var entities
  696.  
  697. uint cps = client.Entity.ConquerPoints;
  698. uint level = client.Entity.Level;
  699. uint herstyel = client.Entity.HairStyle;
  700. uint herclor = client.Entity.HairColor;
  701. uint classs = client.Entity.Class;
  702. uint moeny = client.Entity.Money;
  703.  
  704. uint face = client.Entity.Face;
  705. uint pkpoint = client.Entity.PKPoints;
  706. uint strenth = client.Entity.Strength;
  707. uint agility = client.Entity.Agility;
  708. uint vitialty = client.Entity.Vitality;
  709. uint spirsit = client.Entity.Spirit;
  710. uint atrbyt = client.Entity.Atributes;
  711. uint Hitpoints = client.Entity.Hitpoints;
  712. uint Mana = client.Entity.Mana;
  713. uint MapID = client.Entity.MapID;
  714. ulong Experience = client.Entity.Experience;
  715. uint PreviousMapID = client.Entity.PreviousMapID;
  716. uint Reborn = client.Entity.Reborn;
  717. string Spouse = client.Entity.Spouse;
  718. uint WarehousePW = client.WarehousePW;
  719. uint MoneySave = client.MoneySave;
  720. uint FirstRebornClass = client.Entity.FirstRebornClass;
  721. uint SecondRebornLevel = client.Entity.SecondRebornLevel;
  722. uint EnlightenPoints = client.Entity.EnlightenPoints;
  723. uint GuildID = client.Entity.GuildID;
  724. uint GuildRankss = client.Entity.GuildRank;
  725. uint ClanId = client.Entity.ClanId;
  726. uint PreviousX = client.Entity.PrevX;
  727. uint PreviousY = client.Entity.PrevY;
  728. uint VIPLevel = client.Entity.VIPLevel;
  729. uint SubClassd = client.Entity.SubClass;
  730. uint SubClassLevel = client.Entity.SubClassLevel;
  731. uint ReincarnationLev = client.Entity.ReincarnationLev;
  732. uint VirtuePoints = client.Entity.VirtuePoints;
  733. uint xxx = client.Entity.X;
  734. uint yyy = client.Entity.Y;
  735. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("entities").Where("UID", uid))
  736. using (var reader = new MySqlReader(cmd))
  737.  
  738. if (reader.Read())
  739. {
  740. client.Entity.Bodys = reader.ReadUInt16("Body");
  741. }
  742.  
  743.  
  744. #endregion
  745. #region entities
  746.  
  747. conn1.Open();
  748.  
  749. cmds = new MySql.Data.MySqlClient.MySqlCommand("Insert into entities(SubClass,SubClassLevel,Donation,X,Y,SecondRebornLevel,FirstRebornLevel,VIPLevel,MoneySave,FirstRebornClass,SecondRebornClass,PKPoints,Face,Money,Class,Agility,Vitality,Spirit,Strength,Atributes,Body,Name,UID,Owner,ConquerPoints,LastLogin,Level,HairStyle,Hitpoints,Mana,MapID,Experience,PreviousMapID,Reborn,Spouse,WarehousePW,jail,BoundCPs) values (" + SubClassd + "," + SubClassLevel + "," + client.NobilityInformation.Donation + "," + xxx + "," + yyy + "," + client.Entity.SecondRebornLevel + "," + client.Entity.FirstRebornLevel + "," + client.Entity.VIPLevel + "," + MoneySave + "," + FirstRebornClass + "," + client.Entity.SecondRebornClass + "," + pkpoint + "," + face + "," + moeny + "," + classs + "," + atrbyt + "," + spirsit + "," + strenth + "," + vitialty + "," + agility + "," + client.Entity.Bodys + ",'" + client.Entity.Name + "'," + uid + ",'" + client.Entity.Name + "'," + cps + ",'" + client.Entity.LastLogin + "'," + level + "," + herstyel + "," + Hitpoints + "," + Mana + "," + MapID + "," + Experience + "," + PreviousMapID + "," + Reborn + ",'" + Spouse + "'," + WarehousePW + "," + client.Entity.Jail + "," + client.Entity.BoundCps + ")", conn1);
  750. cmds.ExecuteNonQuery();
  751.  
  752. conn1.Close();
  753.  
  754.  
  755. #endregion
  756. #region nobilty
  757.  
  758. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("nobility").Where("EntityUID", uid))
  759. using (var reader = new MySqlReader(cmd))
  760. {
  761. int count = reader.NumberOfRows;
  762. while (reader.Read())
  763. {
  764. for (int i = 0; i < count; i++)
  765. {
  766.  
  767. }
  768. }
  769.  
  770. if (reader.Read())
  771. {
  772. client.Entity.namedon = reader.ReadString("EntityName");
  773. client.Entity.Donation = reader.ReadUInt128("Donation");
  774. client.Entity.Gender = reader.ReadInt32("Gender");
  775. client.Entity.Mesho = reader.ReadUInt128("Mesh");
  776. }
  777. }
  778. conn1.Open();
  779. MySql.Data.MySqlClient.MySqlCommand cmd2;
  780. cmd2 = new MySql.Data.MySqlClient.MySqlCommand("Insert into nobility(EntityUID,EntityName,Donation,Gender,Mesh) values (" + client.Entity.UID + ",'" + client.Entity.Name + "'," + client.Entity.Donation + "," + client.Entity.Gender + "," + client.Entity.Mesh + ")", conn1);
  781. cmd2.ExecuteNonQuery();
  782. conn1.Close();
  783. //MySqlCommand2 cmdd = new MySqlCommand2(MySqlCommandType2.INSERT);
  784. // cmdd.Insert("nobility").Insert("EntityUID", uid)
  785. // .Insert("EntityName", client.Entity.namedon)
  786. // .Insert("Donation", client.Entity.Donation)
  787. // .Insert("Gender", client.Entity.Gender)
  788. // .Insert("Mesh", client.Entity.Mesh)
  789. // .Execute();
  790. #endregion
  791. #region chi
  792.  
  793. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("chi").Where("uid", uid))
  794. using (var reader = new MySqlReader(cmd))
  795. {
  796.  
  797.  
  798. if (reader.Read())
  799. {
  800. client.Entity.namechi = reader.ReadString("name");
  801. client.Entity.pointschi = reader.ReadUInt128("points");
  802.  
  803.  
  804.  
  805. conn1.Open();
  806. MySql.Data.MySqlClient.MySqlCommand cmd22;
  807. cmd22 = new MySql.Data.MySqlClient.MySqlCommand("Insert into chi(uid,name,points) values (" + client.Entity.UID + ",'" + client.Entity.namechi + "'," + client.Entity.pointschi + ")", conn1);
  808. cmd22.ExecuteNonQuery();
  809. conn1.Close();
  810. }
  811. }
  812. #endregion
  813. #region skills
  814.  
  815. #region var skills
  816.  
  817. int reuint;
  818.  
  819. int skillsid;
  820. int levelskill;
  821. int perlevel;
  822. int templevel;
  823. int hu1;
  824. int hu2;
  825. #endregion
  826.  
  827.  
  828.  
  829.  
  830. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("skills").Where("EntityID", uid))
  831. using (var reader33 = new MySqlReader(cmd))
  832. {
  833.  
  834. for (int i = 43345; i >= 0; i--)
  835. {
  836.  
  837. if (reader33.Read())
  838. {
  839. skillsid = reader33.ReadInt32("ID");
  840. levelskill = reader33.ReadInt32("Level");
  841. perlevel = reader33.ReadInt32("PreviousLevel");
  842. templevel = reader33.ReadInt32("TempLevel");
  843. hu1 = reader33.ReadInt32("LevelHu");
  844. hu2 = reader33.ReadInt32("LevelHu2");
  845. reuint = reader33.ReadInt32("EntityID");
  846.  
  847. if (client.Entity.UID == reuint)
  848. {
  849.  
  850. conn1.Open();
  851. cmds = new MySql.Data.MySqlClient.MySqlCommand("Insert into skills(ID,EntityID,Level,PreviousLevel,TempLevel,LevelHu,LevelHu2) values (" + skillsid + "," + uid + "," + levelskill + "," + perlevel + "," + templevel + "," + hu1 + "," + hu2 + ")", conn1);
  852. cmds.ExecuteNonQuery();
  853. conn1.Close();
  854. }
  855.  
  856. }
  857. }
  858.  
  859. }
  860. #endregion
  861. #region Items
  862.  
  863. #region var items
  864. int noff, reuint2;
  865. int noff2;
  866. int itemid;
  867. int uiditem;
  868. int plus;
  869. int bless;
  870. int Enchant;
  871. int SocketOne;
  872. int SocketTwo;
  873. int Durability;
  874. int MaximDurability;
  875. int SocketProgress;
  876. int PlusProgress;
  877. int Effect;
  878. int Bound;
  879. int Locked;
  880. int UnlockEnd;
  881. int Suspicious;
  882. int SuspiciousStart;
  883. int Color;
  884. int Position;
  885. int Warehouse;
  886. int StackSize, Inscribed, agate, RefineryStarted, RefineryPercent, RefineryLevel, RefineryItem, RefineryTime, NextSteedColor, DayStamp, Days;
  887.  
  888. #endregion
  889.  
  890. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("items").Where("EntityID", uid))
  891. using (var reader = new MySqlReader(cmd))
  892. {
  893.  
  894.  
  895. for (int i = 400000; i >= 0; i--)
  896. {
  897. if (reader.Read())
  898. {
  899. #region var items loop
  900. reuint2 = reader.ReadInt32("EntityID");
  901. itemid = reader.ReadInt32("ID");
  902. uiditem = reader.ReadInt32("UID");
  903. plus = reader.ReadInt32("Plus");
  904. bless = reader.ReadInt32("Bless");
  905. Enchant = reader.ReadInt32("Enchant");
  906. SocketOne = reader.ReadInt32("SocketOne");
  907. SocketTwo = reader.ReadInt32("SocketTwo");
  908. Durability = reader.ReadInt32("Durability");
  909. MaximDurability = reader.ReadInt32("MaximDurability");
  910. SocketProgress = reader.ReadInt32("SocketProgress");
  911. PlusProgress = reader.ReadInt32("PlusProgress");
  912. Effect = reader.ReadInt32("Effect");
  913. Bound = reader.ReadInt32("Bound");
  914. Locked = reader.ReadInt32("Locked");
  915. UnlockEnd = reader.ReadInt32("UnlockEnd");
  916. Suspicious = reader.ReadInt32("Suspicious");
  917. SuspiciousStart = reader.ReadInt32("SuspiciousStart");
  918. Color = reader.ReadInt32("Color");
  919. Position = reader.ReadInt32("Position");
  920. Warehouse = reader.ReadInt32("Warehouse");
  921. StackSize = reader.ReadInt32("StackSize");
  922. Inscribed = reader.ReadInt32("Inscribed");
  923. agate = reader.ReadInt32("agate");
  924. RefineryStarted = reader.ReadInt32("RefineryStarted");
  925. RefineryPercent = reader.ReadInt32("RefineryPercent");
  926. RefineryLevel = reader.ReadInt32("RefineryLevel");
  927. RefineryItem = reader.ReadInt32("RefineryItem");
  928. RefineryTime = reader.ReadInt32("RefineryTime");
  929. NextSteedColor = reader.ReadInt32("NextSteedColor");
  930. DayStamp = reader.ReadInt32("DayStamp");
  931. Days = reader.ReadInt32("Days");
  932. #endregion
  933.  
  934. if (client.Entity.UID == reuint2)
  935. {
  936. conn1.Open();
  937. cmds = new MySql.Data.MySqlClient.MySqlCommand("Insert into items(EntityID,ID,UID,Plus,Bless,Enchant,SocketOne,SocketTwo,Durability,MaximDurability,SocketProgress,PlusProgress,Effect,Bound,Locked,UnlockEnd,Suspicious,SuspiciousStart,Color,Position,Warehouse,StackSize,Inscribed,agate,RefineryStarted,RefineryPercent,RefineryLevel,RefineryItem,RefineryTime,NextSteedColor,DayStamp,Days) values (" + uid + "," + itemid + "," + uiditem + "," + plus + "," + bless + "," + Enchant + "," + SocketOne + "," + SocketTwo + "," + Durability + "," + MaximDurability + "," + SocketProgress + "," + PlusProgress + "," + Effect + "," + Bound + "," + Locked + "," + UnlockEnd + "," + Suspicious + "," + SuspiciousStart + "," + Color + "," + Position + "," + Warehouse + "," + StackSize + "," + Inscribed + "," + agate + "," + RefineryStarted + "," + RefineryPercent + "," + RefineryLevel + "," + RefineryItem + "," + RefineryTime + "," + NextSteedColor + "," + DayStamp + "," + Days + ")", conn1);
  938. cmds.ExecuteNonQuery();
  939. conn1.Close();
  940.  
  941. }
  942.  
  943. }
  944.  
  945. }
  946. }
  947. #endregion
  948. #region Delete Old DataBase Data
  949. string ConnectionString22 = "datasource=localhost;port=3306;database=mn;username=root;password=123456";
  950. MySqlConnection con = new MySqlConnection(ConnectionString22);
  951. con.Open();
  952.  
  953. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From accounts Where EntityID=" + uid + "", con);
  954. cmds.ExecuteNonQuery();
  955. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From entities Where UID=" + uid + "", con);
  956. cmds.ExecuteNonQuery();
  957. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From nobility Where EntityUID=" + uid + "", con);
  958. cmds.ExecuteNonQuery();
  959. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From skills Where EntityID=" + uid + "", con);
  960. cmds.ExecuteNonQuery();
  961. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From items Where EntityID=" + uid + "", con);
  962. cmds.ExecuteNonQuery();
  963. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From chi Where uid=" + uid + "", con);
  964. cmds.ExecuteNonQuery();
  965. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From profs Where EntityID=" + uid + "", con);
  966. cmds.ExecuteNonQuery();
  967. con.Close();
  968. #endregion
  969. #region disconnect and said good bay
  970. client.Disconnect();
  971. #endregion
  972.  
  973.  
  974.  
  975. #endregion
  976. }
  977. public void Server4(GameState client)
  978. {
  979. #region connection
  980. string ConnectionString = "datasource=localhost;port=3306;database='"+db4+"';username=root;password=123456";
  981. MySqlConnection conn1 = new MySqlConnection(ConnectionString);
  982. #endregion
  983. #region server1
  984.  
  985. uint uid;
  986. uid = client.Entity.UID;
  987.  
  988.  
  989. #region accounts
  990. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("accounts").Where("EntityID", uid))
  991. using (var reader = new MySqlReader(cmd))
  992. {
  993. if (reader.Read())
  994. {
  995. client.Entity.email = reader.ReadString("Email");
  996. client.Entity.pass = reader.ReadString("Password");
  997. client.Entity.Username = reader.ReadString("Username");
  998. }
  999.  
  1000. }
  1001. // Mysql Info For Server 1
  1002.  
  1003. conn1.Open();
  1004. MySql.Data.MySqlClient.MySqlCommand cmds;
  1005. cmds = new MySql.Data.MySqlClient.MySqlCommand("Insert into accounts(Username,Password,Email,EntityID) values ('" + client.Entity.Name + "','" + client.Entity.pass + "','" + client.Entity.email + "'," + client.Entity.UID + ")", conn1);
  1006. cmds.ExecuteNonQuery();
  1007.  
  1008.  
  1009. conn1.Close();
  1010. #endregion
  1011. #region var entities
  1012.  
  1013. uint cps = client.Entity.ConquerPoints;
  1014. uint level = client.Entity.Level;
  1015. uint herstyel = client.Entity.HairStyle;
  1016. uint herclor = client.Entity.HairColor;
  1017. uint classs = client.Entity.Class;
  1018. uint moeny = client.Entity.Money;
  1019.  
  1020. uint face = client.Entity.Face;
  1021. uint pkpoint = client.Entity.PKPoints;
  1022. uint strenth = client.Entity.Strength;
  1023. uint agility = client.Entity.Agility;
  1024. uint vitialty = client.Entity.Vitality;
  1025. uint spirsit = client.Entity.Spirit;
  1026. uint atrbyt = client.Entity.Atributes;
  1027. uint Hitpoints = client.Entity.Hitpoints;
  1028. uint Mana = client.Entity.Mana;
  1029. uint MapID = client.Entity.MapID;
  1030. ulong Experience = client.Entity.Experience;
  1031. uint PreviousMapID = client.Entity.PreviousMapID;
  1032. uint Reborn = client.Entity.Reborn;
  1033. string Spouse = client.Entity.Spouse;
  1034. uint WarehousePW = client.WarehousePW;
  1035. uint MoneySave = client.MoneySave;
  1036. uint FirstRebornClass = client.Entity.FirstRebornClass;
  1037. uint SecondRebornLevel = client.Entity.SecondRebornLevel;
  1038. uint EnlightenPoints = client.Entity.EnlightenPoints;
  1039. uint GuildID = client.Entity.GuildID;
  1040. uint GuildRankss = client.Entity.GuildRank;
  1041. uint ClanId = client.Entity.ClanId;
  1042. uint PreviousX = client.Entity.PrevX;
  1043. uint PreviousY = client.Entity.PrevY;
  1044. uint VIPLevel = client.Entity.VIPLevel;
  1045. uint SubClassd = client.Entity.SubClass;
  1046. uint SubClassLevel = client.Entity.SubClassLevel;
  1047. uint ReincarnationLev = client.Entity.ReincarnationLev;
  1048. uint VirtuePoints = client.Entity.VirtuePoints;
  1049. uint xxx = client.Entity.X;
  1050. uint yyy = client.Entity.Y;
  1051. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("entities").Where("UID", uid))
  1052. using (var reader = new MySqlReader(cmd))
  1053.  
  1054. if (reader.Read())
  1055. {
  1056. client.Entity.Bodys = reader.ReadUInt16("Body");
  1057. }
  1058.  
  1059.  
  1060. #endregion
  1061. #region entities
  1062.  
  1063. conn1.Open();
  1064.  
  1065. cmds = new MySql.Data.MySqlClient.MySqlCommand("Insert into entities(SubClass,SubClassLevel,Donation,X,Y,SecondRebornLevel,FirstRebornLevel,VIPLevel,MoneySave,FirstRebornClass,SecondRebornClass,PKPoints,Face,Money,Class,Agility,Vitality,Spirit,Strength,Atributes,Body,Name,UID,Owner,ConquerPoints,LastLogin,Level,HairStyle,Hitpoints,Mana,MapID,Experience,PreviousMapID,Reborn,Spouse,WarehousePW,jail,BoundCPs) values (" + SubClassd + "," + SubClassLevel + "," + client.NobilityInformation.Donation + "," + xxx + "," + yyy + "," + client.Entity.SecondRebornLevel + "," + client.Entity.FirstRebornLevel + "," + client.Entity.VIPLevel + "," + MoneySave + "," + FirstRebornClass + "," + client.Entity.SecondRebornClass + "," + pkpoint + "," + face + "," + moeny + "," + classs + "," + atrbyt + "," + spirsit + "," + strenth + "," + vitialty + "," + agility + "," + client.Entity.Bodys + ",'" + client.Entity.Name + "'," + uid + ",'" + client.Entity.Name + "'," + cps + ",'" + client.Entity.LastLogin + "'," + level + "," + herstyel + "," + Hitpoints + "," + Mana + "," + MapID + "," + Experience + "," + PreviousMapID + "," + Reborn + ",'" + Spouse + "'," + WarehousePW + "," + client.Entity.Jail + "," + client.Entity.BoundCps + ")", conn1);
  1066. cmds.ExecuteNonQuery();
  1067.  
  1068. conn1.Close();
  1069.  
  1070.  
  1071. #endregion
  1072. #region nobilty
  1073.  
  1074. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("nobility").Where("EntityUID", uid))
  1075. using (var reader = new MySqlReader(cmd))
  1076. {
  1077. int count = reader.NumberOfRows;
  1078. while (reader.Read())
  1079. {
  1080. for (int i = 0; i < count; i++)
  1081. {
  1082.  
  1083. }
  1084. }
  1085.  
  1086. if (reader.Read())
  1087. {
  1088. client.Entity.namedon = reader.ReadString("EntityName");
  1089. client.Entity.Donation = reader.ReadUInt128("Donation");
  1090. client.Entity.Gender = reader.ReadInt32("Gender");
  1091. client.Entity.Mesho = reader.ReadUInt128("Mesh");
  1092. }
  1093. }
  1094. conn1.Open();
  1095. MySql.Data.MySqlClient.MySqlCommand cmd2;
  1096. cmd2 = new MySql.Data.MySqlClient.MySqlCommand("Insert into nobility(EntityUID,EntityName,Donation,Gender,Mesh) values (" + client.Entity.UID + ",'" + client.Entity.Name + "'," + client.Entity.Donation + "," + client.Entity.Gender + "," + client.Entity.Mesh + ")", conn1);
  1097. cmd2.ExecuteNonQuery();
  1098. conn1.Close();
  1099. //MySqlCommand2 cmdd = new MySqlCommand2(MySqlCommandType2.INSERT);
  1100. // cmdd.Insert("nobility").Insert("EntityUID", uid)
  1101. // .Insert("EntityName", client.Entity.namedon)
  1102. // .Insert("Donation", client.Entity.Donation)
  1103. // .Insert("Gender", client.Entity.Gender)
  1104. // .Insert("Mesh", client.Entity.Mesh)
  1105. // .Execute();
  1106. #endregion
  1107. #region chi
  1108.  
  1109. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("chi").Where("uid", uid))
  1110. using (var reader = new MySqlReader(cmd))
  1111. {
  1112.  
  1113.  
  1114. if (reader.Read())
  1115. {
  1116. client.Entity.namechi = reader.ReadString("name");
  1117. client.Entity.pointschi = reader.ReadUInt128("points");
  1118.  
  1119.  
  1120.  
  1121. conn1.Open();
  1122. MySql.Data.MySqlClient.MySqlCommand cmd22;
  1123. cmd22 = new MySql.Data.MySqlClient.MySqlCommand("Insert into chi(uid,name,points) values (" + client.Entity.UID + ",'" + client.Entity.namechi + "'," + client.Entity.pointschi + ")", conn1);
  1124. cmd22.ExecuteNonQuery();
  1125. conn1.Close();
  1126. }
  1127. }
  1128. #endregion
  1129. #region skills
  1130.  
  1131. #region var skills
  1132.  
  1133. int reuint;
  1134.  
  1135. int skillsid;
  1136. int levelskill;
  1137. int perlevel;
  1138. int templevel;
  1139. int hu1;
  1140. int hu2;
  1141. #endregion
  1142.  
  1143.  
  1144.  
  1145.  
  1146. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("skills").Where("EntityID", uid))
  1147. using (var reader33 = new MySqlReader(cmd))
  1148. {
  1149.  
  1150. for (int i = 43345; i >= 0; i--)
  1151. {
  1152.  
  1153. if (reader33.Read())
  1154. {
  1155. skillsid = reader33.ReadInt32("ID");
  1156. levelskill = reader33.ReadInt32("Level");
  1157. perlevel = reader33.ReadInt32("PreviousLevel");
  1158. templevel = reader33.ReadInt32("TempLevel");
  1159. hu1 = reader33.ReadInt32("LevelHu");
  1160. hu2 = reader33.ReadInt32("LevelHu2");
  1161. reuint = reader33.ReadInt32("EntityID");
  1162.  
  1163. if (client.Entity.UID == reuint)
  1164. {
  1165.  
  1166. conn1.Open();
  1167. cmds = new MySql.Data.MySqlClient.MySqlCommand("Insert into skills(ID,EntityID,Level,PreviousLevel,TempLevel,LevelHu,LevelHu2) values (" + skillsid + "," + uid + "," + levelskill + "," + perlevel + "," + templevel + "," + hu1 + "," + hu2 + ")", conn1);
  1168. cmds.ExecuteNonQuery();
  1169. conn1.Close();
  1170. }
  1171.  
  1172. }
  1173. }
  1174.  
  1175. }
  1176. #endregion
  1177. #region Items
  1178.  
  1179. #region var items
  1180. int noff, reuint2;
  1181. int noff2;
  1182. int itemid;
  1183. int uiditem;
  1184. int plus;
  1185. int bless;
  1186. int Enchant;
  1187. int SocketOne;
  1188. int SocketTwo;
  1189. int Durability;
  1190. int MaximDurability;
  1191. int SocketProgress;
  1192. int PlusProgress;
  1193. int Effect;
  1194. int Bound;
  1195. int Locked;
  1196. int UnlockEnd;
  1197. int Suspicious;
  1198. int SuspiciousStart;
  1199. int Color;
  1200. int Position;
  1201. int Warehouse;
  1202. int StackSize, Inscribed, agate, RefineryStarted, RefineryPercent, RefineryLevel, RefineryItem, RefineryTime, NextSteedColor, DayStamp, Days;
  1203.  
  1204. #endregion
  1205.  
  1206. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("items").Where("EntityID", uid))
  1207. using (var reader = new MySqlReader(cmd))
  1208. {
  1209.  
  1210.  
  1211. for (int i = 400000; i >= 0; i--)
  1212. {
  1213. if (reader.Read())
  1214. {
  1215. #region var items loop
  1216. reuint2 = reader.ReadInt32("EntityID");
  1217. itemid = reader.ReadInt32("ID");
  1218. uiditem = reader.ReadInt32("UID");
  1219. plus = reader.ReadInt32("Plus");
  1220. bless = reader.ReadInt32("Bless");
  1221. Enchant = reader.ReadInt32("Enchant");
  1222. SocketOne = reader.ReadInt32("SocketOne");
  1223. SocketTwo = reader.ReadInt32("SocketTwo");
  1224. Durability = reader.ReadInt32("Durability");
  1225. MaximDurability = reader.ReadInt32("MaximDurability");
  1226. SocketProgress = reader.ReadInt32("SocketProgress");
  1227. PlusProgress = reader.ReadInt32("PlusProgress");
  1228. Effect = reader.ReadInt32("Effect");
  1229. Bound = reader.ReadInt32("Bound");
  1230. Locked = reader.ReadInt32("Locked");
  1231. UnlockEnd = reader.ReadInt32("UnlockEnd");
  1232. Suspicious = reader.ReadInt32("Suspicious");
  1233. SuspiciousStart = reader.ReadInt32("SuspiciousStart");
  1234. Color = reader.ReadInt32("Color");
  1235. Position = reader.ReadInt32("Position");
  1236. Warehouse = reader.ReadInt32("Warehouse");
  1237. StackSize = reader.ReadInt32("StackSize");
  1238. Inscribed = reader.ReadInt32("Inscribed");
  1239. agate = reader.ReadInt32("agate");
  1240. RefineryStarted = reader.ReadInt32("RefineryStarted");
  1241. RefineryPercent = reader.ReadInt32("RefineryPercent");
  1242. RefineryLevel = reader.ReadInt32("RefineryLevel");
  1243. RefineryItem = reader.ReadInt32("RefineryItem");
  1244. RefineryTime = reader.ReadInt32("RefineryTime");
  1245. NextSteedColor = reader.ReadInt32("NextSteedColor");
  1246. DayStamp = reader.ReadInt32("DayStamp");
  1247. Days = reader.ReadInt32("Days");
  1248. #endregion
  1249.  
  1250. if (client.Entity.UID == reuint2)
  1251. {
  1252. conn1.Open();
  1253. cmds = new MySql.Data.MySqlClient.MySqlCommand("Insert into items(EntityID,ID,UID,Plus,Bless,Enchant,SocketOne,SocketTwo,Durability,MaximDurability,SocketProgress,PlusProgress,Effect,Bound,Locked,UnlockEnd,Suspicious,SuspiciousStart,Color,Position,Warehouse,StackSize,Inscribed,agate,RefineryStarted,RefineryPercent,RefineryLevel,RefineryItem,RefineryTime,NextSteedColor,DayStamp,Days) values (" + uid + "," + itemid + "," + uiditem + "," + plus + "," + bless + "," + Enchant + "," + SocketOne + "," + SocketTwo + "," + Durability + "," + MaximDurability + "," + SocketProgress + "," + PlusProgress + "," + Effect + "," + Bound + "," + Locked + "," + UnlockEnd + "," + Suspicious + "," + SuspiciousStart + "," + Color + "," + Position + "," + Warehouse + "," + StackSize + "," + Inscribed + "," + agate + "," + RefineryStarted + "," + RefineryPercent + "," + RefineryLevel + "," + RefineryItem + "," + RefineryTime + "," + NextSteedColor + "," + DayStamp + "," + Days + ")", conn1);
  1254. cmds.ExecuteNonQuery();
  1255. conn1.Close();
  1256.  
  1257. }
  1258.  
  1259. }
  1260.  
  1261. }
  1262. }
  1263. #endregion
  1264. #region Delete Old DataBase Data
  1265. string ConnectionString22 = "datasource=localhost;port=3306;database=mn;username=root;password=123456";
  1266. MySqlConnection con = new MySqlConnection(ConnectionString22);
  1267. con.Open();
  1268.  
  1269. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From accounts Where EntityID=" + uid + "", con);
  1270. cmds.ExecuteNonQuery();
  1271. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From entities Where UID=" + uid + "", con);
  1272. cmds.ExecuteNonQuery();
  1273. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From nobility Where EntityUID=" + uid + "", con);
  1274. cmds.ExecuteNonQuery();
  1275. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From skills Where EntityID=" + uid + "", con);
  1276. cmds.ExecuteNonQuery();
  1277. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From items Where EntityID=" + uid + "", con);
  1278. cmds.ExecuteNonQuery();
  1279. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From chi Where uid=" + uid + "", con);
  1280. cmds.ExecuteNonQuery();
  1281. cmds = new MySql.Data.MySqlClient.MySqlCommand("Delete From profs Where EntityID=" + uid + "", con);
  1282. cmds.ExecuteNonQuery();
  1283. con.Close();
  1284. #endregion
  1285. #region disconnect and said good bay
  1286. client.Disconnect();
  1287. #endregion
  1288.  
  1289.  
  1290.  
  1291. #endregion
  1292. }
  1293. public void cheac()
  1294. {
  1295. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("transfer").Where("ID", 1))
  1296. using (var reader = new MySqlReader(cmd))
  1297. {
  1298. if (reader.Read())
  1299. {
  1300. server1 = reader.ReadString("ServerName");
  1301. db1 = reader.ReadString("DataBase");
  1302. }
  1303. }
  1304. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("transfer").Where("ID", 2))
  1305. using (var reader = new MySqlReader(cmd))
  1306. {
  1307. if (reader.Read())
  1308. {
  1309. server2 = reader.ReadString("ServerName");
  1310. db2 = reader.ReadString("DataBase");
  1311. }
  1312. }
  1313. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("transfer").Where("ID", 3))
  1314. using (var reader = new MySqlReader(cmd))
  1315. {
  1316. if (reader.Read())
  1317. {
  1318. server3 = reader.ReadString("ServerName");
  1319. db3 = reader.ReadString("DataBase");
  1320. }
  1321. }
  1322. using (var cmd = new Conquer_Online_Server.Database.MySqlCommand(MySqlCommandType.SELECT).Select("transfer").Where("ID", 4))
  1323. using (var reader = new MySqlReader(cmd))
  1324. {
  1325. if (reader.Read())
  1326. {
  1327. server4 = reader.ReadString("ServerName");
  1328. db4 = reader.ReadString("DataBase");
  1329. }
  1330. }
  1331. }
  1332. }
  1333. }
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!