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);
}
