public static void SaveJiangHu(Client.GameState client)
public static void SaveJiangHu(Client.GameState client) { try { MemoryStream stream = new MemoryStream(); BinaryWriter writer = new BinaryWriter(stream); client.Entity.MyJiang.Serialize(writer); /////////// string SQL = "UPDATE `jiang` SET Powers=@Powers,OwnName=@OwnName,CustomizedName=@CustomizedName 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.Parameters.AddWithValue("@OwnName", client.Entity.MyJiang.OwnName); cmd.Parameters.AddWithValue("@CustomizedName", client.Entity.MyJiang.CustomizedName); cmd.ExecuteNonQuery(); } } } catch (Exception e) { Console.WriteLine(e); } }