public async Task <IEnumerable <Character> > GetAllAsync() => await Characters.AsQueryable().ToListAsync();
public async Task <Character> GetCharacterAsync(Guid id) => await Characters.AsQueryable().FirstOrDefaultAsync(x => x.UserId == id);
private void OnCharCreate(WorldSession session, PCCharCreate packet)
{
byte[] playerBytes = { packet.Skin, packet.Face, packet.HairStyle, packet.HairColor };
byte[] playerBytes2 = { packet.Accessory };
playercreateinfo info = CreateInfo.SingleOrDefault(ci => ci.race == packet.Race && ci.@class == packet.Class);
var charGuid = Characters.AsQueryable().Any() ? Characters.AsQueryable().Max(c => c.guid) + 1 : 1;
character character = new character()
{
guid = charGuid,
account = session.Account.id,
name = Utils.NormalizeText(packet.Name),
race = packet.Race,
@class = packet.Class,
gender = packet.Gender,
level = 1,
xp = 0,
money = 100000,
playerBytes = BitConverter.ToInt32(playerBytes, 0),
playerBytes2 = 0,
playerFlags = 0,
position_x = info.position_x,
position_y = info.position_y,
position_z = info.position_z,
map = info.map,
orientation = info.orientation,
taximask = "",
online = 0,
cinematic = 0,
totaltime = 0,
leveltime = 0,
logout_time = 0,
is_logout_resting = 0,
rest_bonus = 0,
resettalents_cost = 0,
resettalents_time = 0,
trans_x = 0,
trans_y = 0,
trans_z = 0,
trans_o = 0,
transguid = 0,
extra_flags = 0,
at_login = 0,
zone = info.zone,
death_expire_time = 0,
taxi_path = "",
honor_highest_rank = 0,
honor_standing = 0,
stored_honor_rating = 0,
stored_dishonorable_kills = 0,
stored_honorable_kills = 0,
watchedFaction = 0,
drunk = 0,
health = 100,
power1 = 0,
power2 = 0,
power3 = 0,
power4 = 0,
power5 = 0,
exploredZones = "",
equipmentCache = GetStartingEquipment(packet.Race, packet.Class, packet.Gender),
ammoId = 0,
actionBars = 0,
deleteInfos_Account = session.Account.id,
deleteInfos_Name = Utils.NormalizeText(packet.Name),
deleteDate = 0
};
Characters.Add(character);
Core.CharacterDatabase.SaveChanges();
session.SendPacket(new PSCharCreate(LoginErrorCode.CHAR_CREATE_SUCCESS));
}
