public static void AddFriend(Client.GameState client, Friend friend) { MySqlCommand cmd = new MySqlCommand(MySqlCommandType.INSERT); cmd.Insert("friends").Insert("entityid", client.Entity.UID).Insert("friendid", friend.ID) .Insert("friendname", friend.Name).Execute(); cmd = new MySqlCommand(MySqlCommandType.INSERT); cmd.Insert("friends").Insert("entityid", friend.ID).Insert("friendid", client.Entity.UID) .Insert("friendname", client.Entity.Name).Execute(); }
/* public static void LoadKnownPersons(Client.GameState client) { client.Friends = new SafeDictionary<uint, Friend>(50); client.Enemy = new SafeDictionary<uint, PhoenixProject.Game.ConquerStructures.Society.Enemy>(10); client.Partners = new SafeDictionary<uint, TradePartner>(40); client.Apprentices = new SafeDictionary<uint, PhoenixProject.Game.ConquerStructures.Society.Apprentice>(10); FriendXCollection entities = new FriendXCollection(); entities.LoadAndCloseReader(FriendX.FetchByParameter("EntityID", client.Entity.UID)); for (int x = 0; x < entities.Count; x++) { Friend friend = new Friend(); friend.ID = (uint)entities[x].FriendID; friend.Name = entities[x].FriendName; friend.Message = entities[x].Message; client.Friends.Add(friend.ID, friend); } EnemyCollection entities2 = new EnemyCollection(); entities2.LoadAndCloseReader(Conquer.Database.Enemy.FetchByParameter("EntityID", client.Entity.UID)); for (int x = 0; x < entities2.Count; x++) { PhoenixProject.Game.ConquerStructures.Society.Enemy enemy = new PhoenixProject.Game.ConquerStructures.Society.Enemy(); enemy.ID = (uint)entities2[x].EnemyID; enemy.Name = entities2[x].EnemyName; client.Enemy.Add(enemy.ID, enemy); } PartnerCollection entities3 = new PartnerCollection(); entities3.LoadAndCloseReader(Conquer.Database.Partner.FetchByParameter("EntityID", client.Entity.UID)); for (int x = 0; x < entities3.Count; x++) { TradePartner partner = new TradePartner(); partner.ID = (uint)entities3[x].PartnerID; partner.Name = entities3[x].PartnerName; partner.ProbationStartedOn = DateTime.FromBinary(entities3[x].ProbationStartedOn); client.Partners.Add(partner.ID, partner); } ApprenticeCollection entities4 = new ApprenticeCollection(); entities4.LoadAndCloseReader(Conquer.Database.Apprentice.FetchByParameter("MentorID", client.Entity.UID)); for (int x = 0; x < entities4.Count; x++) { PhoenixProject.Game.ConquerStructures.Society.Apprentice app = new PhoenixProject.Game.ConquerStructures.Society.Apprentice(); app.ID = (uint)entities4[x].ApprenticeID; app.Name = entities4[x].ApprenticeName; app.EnroleDate = (uint)entities4[x].EnroleDate; app.Actual_Experience = (ulong)entities4[x].ActualExperience; app.Total_Experience = (ulong)entities4[x].TotalExperience; app.Actual_Plus = (ushort)entities4[x].ActualPlus; app.Total_Plus = (ushort)entities4[x].TotalPlus; app.Actual_HeavenBlessing = (ushort)entities4[x].ActualHeavenBlessing; app.Total_HeavenBlessing = (ushort)entities4[x].TotalHeavenBlessing; client.PrizeExperience += app.Actual_Experience; client.PrizePlusStone += app.Actual_Plus; client.PrizeHeavenBlessing += app.Actual_HeavenBlessing; client.Apprentices.Add(app.ID, app); client.apprtnum += 1; if (client.PrizeExperience > 50 * 606) client.PrizeExperience = 50 * 606; } ApprenticeCollection entities5 = new ApprenticeCollection(); entities5.LoadAndCloseReader(Conquer.Database.Apprentice.FetchByParameter("ApprenticeID", client.Entity.UID)); for (int x = 0; x < entities5.Count; x++) { client.Mentor = new Mentor(); client.Mentor.ID = (uint)entities5[x].MentorID; client.Mentor.Name = entities5[x].MentorName; client.Mentor.EnroleDate = (uint)entities5[x].EnroleDate; client.AsApprentice = new PhoenixProject.Game.ConquerStructures.Society.Apprentice(); client.AsApprentice.ID = client.Entity.UID; client.AsApprentice.Name = client.Entity.Name; client.AsApprentice.EnroleDate = client.Mentor.EnroleDate; client.AsApprentice.Actual_Experience = (ulong)entities5[x].ActualExperience; client.AsApprentice.Total_Experience = (ulong)entities5[x].TotalExperience; client.AsApprentice.Actual_Plus = (ushort)entities5[x].ActualPlus; client.AsApprentice.Total_Plus = (ushort)entities5[x].TotalPlus; client.AsApprentice.Actual_HeavenBlessing = (ushort)entities5[x].ActualHeavenBlessing; client.AsApprentice.Total_HeavenBlessing = (ushort)entities5[x].TotalHeavenBlessing; } }*/ public static void LoaderFriends(Client.GameState client) { client.Friends = new SafeDictionary<uint, Friend>(50); 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(); reader.Dispose(); }