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