/// <summary>
/// </summary>
/// <param name="accountName">
/// </param>
/// <returns>
/// </returns>
public static List<CharacterEntry> LoadCharacters(string accountName)
{
var characters = new List<CharacterEntry>();
foreach (DBCharacter ch in CharacterDao.Instance.GetAllForUser(accountName))
{
var charentry = new CharacterEntry();
charentry.Id = ch.Id;
charentry.Name = ch.Name;
charentry.Playfield = ch.Playfield;
charentry.Level = StatDao.Instance.GetById(50000, ch.Id, 54).StatValue; // 54 = Level
charentry.Breed = StatDao.Instance.GetById(50000, ch.Id, 4).StatValue; // 4 = Breed
charentry.Gender = StatDao.Instance.GetById(50000, ch.Id, 59).StatValue; // 59 = Sex
charentry.Profession = StatDao.Instance.GetById(50000, ch.Id, 60).StatValue; // 60 = Profession
characters.Add(charentry);
}
return characters;
}
/// <summary>
///
/// </summary>
/// <param name="accountName"></param>
/// <returns></returns>
public static List<CharacterEntry> LoadCharacters(string accountName)
{
List<CharacterEntry> characters = new List<CharacterEntry>();
SqlWrapper ms = new SqlWrapper();
string SqlQuery = "SELECT `characters`.`ID`, `characters`.`Name`, `characters`.`playfield`, (SELECT `Value` FROM `characters_stats` WHERE `characters`.`ID` = `characters_stats`.`ID` AND `Stat` = 54) as level, (SELECT `Value` FROM `characters_stats` WHERE `characters`.`ID` = `characters_stats`.`ID` AND `Stat` = 4) as breed, (SELECT `Value` FROM `characters_stats` WHERE `characters`.`ID` = `characters_stats`.`ID` AND `Stat` = 59) as gender, (SELECT `Value` FROM `characters_stats` WHERE `characters`.`ID` = `characters_stats`.`ID` AND `Stat` = 60) as profession FROM `characters` WHERE `characters`.Username = '******'";
DataTable dt = ms.ReadDT(SqlQuery);
foreach (DataRow row in dt.Rows)
{
CharacterEntry charentry = new CharacterEntry();
charentry.ID = (Int32)row["ID"];
charentry.Name = ((string)row["Name"]).PadRight(11, '\u0000');
charentry.playfield = (Int32)row["playfield"];
charentry.Level = (Int32)row["level"];
charentry.Breed = (Int32)row["breed"];
charentry.Gender = (Int32)row["gender"];
charentry.Profession = (Int32)row["profession"];
characters.Add(charentry);
}
return characters;
}
