public static void AddMentor(Mentor mentor, Apprentice appr)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.INSERT);
cmd.Insert("apprentice").Insert("mentorid", mentor.ID).Insert("apprenticeid", appr.ID)
.Insert("mentorname", mentor.Name).Insert("apprenticename", appr.Name).Insert("enroledate", appr.EnroleDate).Execute();
}
public static void LoadKnownPersons(Client.GameState client)
{
client.Friends = new SafeDictionary<uint,Friend>(50);
client.Enemy = new SafeDictionary<uint, Enemy>(10);
client.Partners = new SafeDictionary<uint, TradePartner>(40);
client.Apprentices = new SafeDictionary<uint, Apprentice>(10);
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT);
cmd.Select("friends").Where("EntityID", client.Entity.UID);
MySqlReader reader = new MySqlReader(cmd);
while(reader.Read())
{
Friend friend = new Friend();
friend.ID = reader.ReadUInt32("FriendID");
friend.Name = reader.ReadString("FriendName");
friend.Message = reader.ReadString("Message");
client.Friends.Add(friend.ID, friend);
}
reader.Close();
cmd = new MySqlCommand(MySqlCommandType.SELECT);
cmd.Select("enemy").Where("EntityID", client.Entity.UID);
reader = new MySqlReader(cmd);
while (reader.Read())
{
Enemy enemy = new Enemy();
enemy.ID = reader.ReadUInt32("EnemyID");
enemy.Name = reader.ReadString("EnemyName");
client.Enemy.Add(enemy.ID, enemy);
}
reader.Close();
cmd = new MySqlCommand(MySqlCommandType.SELECT);
cmd.Select("partners").Where("EntityID", client.Entity.UID);
reader = new MySqlReader(cmd);
while (reader.Read())
{
TradePartner partner = new TradePartner();
partner.ID = reader.ReadUInt32("PartnerID");
partner.Name = reader.ReadString("PartnerName");
partner.ProbationStartedOn = DateTime.FromBinary(reader.ReadInt64("ProbationStartedOn"));
client.Partners.Add(partner.ID, partner);
}
reader.Close();
cmd = new MySqlCommand(MySqlCommandType.SELECT);
cmd.Select("apprentice").Where("MentorID", client.Entity.UID);
reader = new MySqlReader(cmd);
while (reader.Read())
{
Apprentice app = new Apprentice();
app.ID = reader.ReadUInt32("ApprenticeID");
app.Name = reader.ReadString("ApprenticeName");
app.EnroleDate = reader.ReadUInt32("EnroleDate");
app.Actual_Experience = reader.ReadUInt64("Actual_Experience");
app.Total_Experience = reader.ReadUInt64("Total_Experience");
app.Actual_Plus = reader.ReadUInt16("Actual_Plus");
app.Total_Plus = reader.ReadUInt16("Total_Plus");
app.Actual_HeavenBlessing = reader.ReadUInt16("Actual_HeavenBlessing");
app.Total_HeavenBlessing = reader.ReadUInt16("Total_HeavenBlessing");
client.PrizeExperience += app.Actual_Experience;
client.PrizePlusStone += app.Actual_Plus;
client.PrizeHeavenBlessing += app.Actual_HeavenBlessing;
client.Apprentices.Add(app.ID, app);
if (client.PrizeExperience > 50 * 606)
client.PrizeExperience = 50 * 606;
}
reader.Close();
cmd = new MySqlCommand(MySqlCommandType.SELECT);
cmd.Select("apprentice").Where("ApprenticeID", client.Entity.UID);
reader = new MySqlReader(cmd);
while (reader.Read())
{
client.Mentor = new Mentor();
client.Mentor.ID = reader.ReadUInt32("MentorID");
client.Mentor.Name = reader.ReadString("MentorName");
client.Mentor.EnroleDate = reader.ReadUInt32("EnroleDate");
client.AsApprentice = new Apprentice();
client.AsApprentice.ID = client.Entity.UID;
client.AsApprentice.Name = client.Entity.Name;
client.AsApprentice.EnroleDate = client.Mentor.EnroleDate;
client.AsApprentice.Actual_Experience = reader.ReadUInt64("Actual_Experience");
client.AsApprentice.Total_Experience = reader.ReadUInt64("Total_Experience");
client.AsApprentice.Actual_Plus = reader.ReadUInt16("Actual_Plus");
client.AsApprentice.Total_Plus = reader.ReadUInt16("Total_Plus");
client.AsApprentice.Actual_HeavenBlessing = reader.ReadUInt16("Actual_HeavenBlessing");
client.AsApprentice.Total_HeavenBlessing = reader.ReadUInt16("Total_HeavenBlessing");
}
reader.Close();
}
public static void SaveApprenticeInfo(Apprentice app)
{
if (app != null)
{
MySqlCommand mysqlcmd = new MySqlCommand(MySqlCommandType.UPDATE);
mysqlcmd.Update("apprentice")
.Set("Actual_Experience", app.Actual_Experience.ToString())
.Set("Total_Experience", app.Total_Experience.ToString())
.Set("Actual_Plus", app.Actual_Plus.ToString())
.Set("Total_Plus", app.Total_Plus.ToString())
.Set("Actual_HeavenBlessing", app.Actual_HeavenBlessing.ToString())
.Set("Total_HeavenBlessing", app.Total_HeavenBlessing.ToString()).Where("ApprenticeID", app.ID).Execute();
}
}
