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);
}
