public Tables.Account GetAccount(string accountName) { DataTable dt = m_Query_GetSingleAccount.Process(accountName); if (dt.Rows.Count > 0) { return(new Tables.Account(dt.Rows[0])); } return(null); }
public Tables.Character GetCharacter(uint id) { DataTable dt = m_Query_GetSingleCharacter.Process(id); if (dt != null && dt.Rows.Count > 0) { return(new Tables.Character(dt.Rows[0])); } return(null); }
public Tables.CharacterSlot GetSingleCharacterSlotForAccount(uint accountId, uint slotId) { DataTable dt = m_Query_GetSingleCharacterSlotForAccount.Process(accountId, slotId); if (dt != null && dt.Rows.Count > 0) { return(new Tables.CharacterSlot(dt.Rows[0])); } return(null); }
public List <Tables.Account> GetAllAccounts() { List <Tables.Account> accountList = new List <Tables.Account>(); DataTable dt = m_Query_GetAllAccounts.Process(); foreach (DataRow row in dt.Rows) { accountList.Add(new Tables.Account(row)); } return(accountList); }
public List <Tables.Character> GetAllCharacters() { List <Tables.Character> clusterList = new List <Tables.Character>(); DataTable dt = m_Query_GetAllCharacters.Process(); foreach (DataRow row in dt.Rows) { clusterList.Add(new Tables.Character(row)); } return(clusterList); }
public List <Tables.CharacterSlot> GetAllCharacterSlotsForAccount(uint accountId) { List <Tables.CharacterSlot> slotList = new List <Tables.CharacterSlot>(); DataTable dt = m_Query_GetAllCharacterSlotsForAccount.Process(accountId); if (dt != null) { foreach (DataRow row in dt.Rows) { slotList.Add(new Tables.CharacterSlot(row)); } } return(slotList); }
public int GetNewCharacterId() { DataTable dt = m_Query_GetHighestCharacterId.Process(); if (dt != null && dt.Rows.Count > 0) { object value = dt.Rows[0]["highestCharId"]; if (!Convert.IsDBNull(value)) { return(Convert.ToInt32(value) + 1); } } return(1); }
public void DeleteCharacterSlot(Tables.CharacterSlot slot) { m_Query_DeleteCharacterSlot.Process(slot.CharacterId, slot.AccountId); }
public void AddCharacterSlot(Tables.CharacterSlot slot) { m_Query_InsertCharacterSlot.Process(slot.CharacterId, slot.SlotId, slot.AccountId); }
public void AddCharacter(Tables.Character character) { m_Query_InsertCharacter.Process(character.Name, character.ClusterId, character.ClassId, character.Skinset, character.HairStyle, character.HairColor, character.HeadMesh, character.Face, character.Gender, character.Strength, character.Stamina, character.Dexterity, character.Intelligence, character.SkillPoints, character.StatPoints, character.Level, character.Experience, character.Map, character.Position.X, character.Position.Y, character.Position.Z, character.Position.O, character.Penya, character.FlyingLevel, character.FlyingExp, character.HP, character.MP, character.Size, character.PvPPoints, character.PKPoints, character.GuildId, character.Bag1TimeLeft, character.Bag2TimeLeft, character.MsgState, character.MotionFlags, character.MovementFlags, character.PlayerFlags); }