public static void LoadTop8() { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT); cmd.Select("elitepk"); MySqlReader r = new MySqlReader(cmd); while (r.Read()) { Elite_client client = new Elite_client(r.ReadUInt32("UID"), r.ReadUInt16("Avatar"), r.ReadUInt16("Mesh"), r.ReadString("Name"), r.ReadUInt32("Points"), r.ReadUInt16("Postion"), r.ReadByte("MyTitle")); if (!Top8.ContainsKey(client.UID)) Top8.Add(client.UID, client); } r.Close(); r.Dispose(); }
public static void SaveTop8(Client.GameState client) { //Conquer.Database.Elitepk.Insert((int)client.Entity.UID, (int)client.Entity.Face, (string)client.Entity.Name, (int)client.Entity.Mesh, (int)client.Entity.Points, (int)client.Entity.Postion, (long)client.Entity.MyTitle); Elite_client clients = new Elite_client( (uint)client.Entity.UID , (ushort)client.Entity.Face , (ushort)client.Entity.Body , (string)client.Entity.Name , (uint)client.Entity.Points , (ushort)Program.EliteRank , (byte)client.Entity.MyTitle ); if (!Top8.ContainsKey(clients.UID)) Top8.Add(clients.UID, clients); MySqlCommand cmd = new MySqlCommand(MySqlCommandType.INSERT); cmd.Insert("elitepk") .Insert("UID", clients.UID).Insert("Avatar", clients.Avatar) .Insert("Mesh", clients.Mesh).Insert("Name", clients.Name) .Insert("Points", clients.Points).Insert("Postion", Program.EliteRank) .Insert("MyTitle", clients.MyTitle); cmd.Execute(); // Conquer.Database.Elitepk.Insert((int)clients.UID, (int)clients.Avatar, (string)clients.Name, (int)clients.Mesh, (int)clients.Points, (int)Program.EliteRank, (long)clients.MyTitle); }