public void AddFriend(string name)
{
var friend = FriendMananger.Instance.GetFriendInfo(name);
if (friend == null || FriendsIdList.ContainsKey(friend.CharacterId))
{
return; // already add
}
var template = new FriendTemplate()
{
Id = FriendIdManager.Instance.GetNextId(),
FriendId = friend.CharacterId,
Owner = Owner.Id
};
FriendsIdList.Add(friend.CharacterId, template);
FriendMananger.Instance.AddToAllFriends(template);
Owner.SendPacket(new SCAddFriendPacket(friend, true, 0));
}
public void Load(MySqlConnection connection)
{
using (var command = connection.CreateCommand())
{
command.CommandText = "SELECT * FROM friends WHERE `owner` = @owner";
command.Parameters.AddWithValue("@owner", Owner.Id);
command.Prepare();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var template = new FriendTemplate()
{
Id = reader.GetUInt32("id"),
FriendId = reader.GetUInt32("friend_id"),
Owner = reader.GetUInt32("owner")
};
FriendsIdList.Add(template.FriendId, template);
}
}
}
}