Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static void LoadJiangHu()
- {
- using (Read r = new Read("database\\JiangHu.txt"))
- {
- if (r.Reader())
- {
- int count = r.Count;
- for (uint x = 0; x < count; x++)
- {
- string data = r.ReadString("");
- if (data != null)
- {
- Game.JiangHu jiang = new Game.JiangHu(0);
- jiang.Load(data);
- Game.JiangHu.JiangHuClients.TryAdd(jiang.UID, jiang);
- Game.JiangHu.JiangHuRanking.UpdateRank(jiang);
- }
- }
- }
- }
- }
- public static void SaveJiangHu()
- {
- using (Write _wr = new Write("database\\JiangHu.txt"))
- {
- var dictionary = Game.JiangHu.JiangHuClients.Values.ToArray();
- string[] items = new string[Game.JiangHu.JiangHuClients.Count];
- for (uint x = 0; x < Game.JiangHu.JiangHuClients.Count; x++)
- items[x] = dictionary[x].ToString();
- _wr.Add(items, items.Length).Execute(Mode.Open);
- }
- }
- /*public static void LoadAllJiang()
- {
- using (var cmd = new MySqlCommand(MySqlCommandType.SELECT))
- {
- cmd.Select("jiang");
- using (MySqlReader rdr = new MySqlReader(cmd))
- {
- while (rdr.Read())
- {
- Game.JiangHu jiangData = new Game.JiangHu(0);
- jiangData.UID = rdr.ReadUInt32("uid");
- jiangData.OwnName = rdr.ReadString("name");
- jiangData.CustomizedName = rdr.ReadString("CustomizedName");
- byte[] data = rdr.ReadBlob("powers");
- if (data.Length > 0)
- {
- using (var stream = new MemoryStream(data))
- using (var reader = new BinaryReader(stream))
- {
- jiangData.Deserialize(reader);
- }
- }
- Game.JiangHu.JiangHuClients.TryAdd(jiangData.UID, jiangData);
- jiangData.CreateStatusAtributes(null);
- }
- }
- }
- }
- public static void Insert(Client.GameClient client)
- {
- if (client.Entity.MyJiang == null) return;
- using (var cmd = new MySqlCommand(MySqlCommandType.SELECT))
- {
- cmd.Select("jiang").Where("uid", client.Entity.UID);
- using (MySqlReader rdr = new MySqlReader(cmd))
- {
- using (var command = new MySqlCommand(MySqlCommandType.INSERT))
- {
- command.Insert("jiang").Insert("uid", client.Entity.UID).Insert("name", client.Entity.Name).Insert("CustomizedName", client.Entity.MyJiang.CustomizedName);
- command.Execute();
- }
- }
- }
- }
- public static void Save(Client.GameClient client)
- {
- MemoryStream stream = new MemoryStream();
- BinaryWriter writer = new BinaryWriter(stream);
- foreach (var jiangPower in Game.JiangHu.JiangHuClients.Values)
- (jiangPower as Game.JiangHu).Serialize(writer);
- string SQL = "UPDATE `jiang` SET powers=@Powers where UID = " + client.Entity.UID + " ;";
- byte[] rawData = stream.ToArray();
- using (var conn = DataHolder.MySqlConnection)
- {
- conn.Open();
- using (var cmd = new MySql.Data.MySqlClient.MySqlCommand())
- {
- cmd.Connection = conn;
- cmd.CommandText = SQL;
- cmd.Parameters.AddWithValue("@Powers", rawData);
- cmd.ExecuteNonQuery();
- }
- }
- }*/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement