public static void LoadProficiencies(Client.GameState client)
{
if (client.Entity == null)
return;
client.Proficiencies = new System.SafeDictionary<ushort, Interfaces.ISkill>(100);
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("skills").Where("Type", "Proficiency").And("EntityID", client.Entity.UID);
MySqlReader r = new MySqlReader(cmd );
while (r.Read())
{
Interfaces.ISkill proficiency = new Network.GamePackets.Proficiency(true);
proficiency.ID = r.ReadUInt16("ID");
proficiency.Level = r.ReadByte("Level");
proficiency.PreviousLevel = r.ReadByte("PreviousLevel");
proficiency.Experience = r.ReadUInt32("Experience");
proficiency.Available = true;
if (!client.Proficiencies.ContainsKey(proficiency.ID))
client.Proficiencies.Add(proficiency.ID, proficiency);
}
r.Close();
}
public static void LoadProficiencies(Client.GameState client, MySql.Data.MySqlClient.MySqlConnection conn)
{
if (client.Entity == null)
return;
client.Proficiencies = new System.SafeDictionary<ushort, Interfaces.IProf>(100);
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("profs").Where("EntityID", client.Entity.UID);
PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd);
while (r.Read())
{
Interfaces.IProf proficiency = new Network.GamePackets.Proficiency(true);
proficiency.ID = r.ReadUInt16("ID");
proficiency.Level = r.ReadByte("Level");
proficiency.PreviousLevel = r.ReadByte("PreviousLevel");
proficiency.Experience = r.ReadUInt32("Experience");
proficiency.TempLevel = r.ReadByte("TempLevel");
proficiency.Available = true;
if (!client.Proficiencies.ContainsKey(proficiency.ID))
client.Proficiencies.Add(proficiency.ID, proficiency);
}
r.Close();
r.Dispose();
}