public static List<Mobile> CharacterList(int AID) { List<Mobile> Characters = new List<Mobile>(); MySqlDataReader query = Database.Query("select * from character where aid = " + AID + ""); if (!query.HasRows) return null; do { Mobile charobj = new Mobile(); charobj.CID = (int)query["id"]; charobj.Name = (string)query["Name"]; charobj.Class = (int)query["Class"]; charobj.Level = (int)query["Level"]; charobj.EXP = (int)query["Exp"]; charobj.Stage = (int)query["Stage"]; charobj.PvpLevel = (int)query["PvpLevel"]; charobj.PvpExp = (int)query["PvpExp"]; charobj.WarLevel = (int)query["WarLevel"]; charobj.WarExp = (int)query["WarExp"]; int CID = (int)query["id"]; MySqlDataReader sqlr = Database.Query("select * from equip where cid = " + CID); if (sqlr.HasRows) { do { Item nItem = new Item(Convert.ToUInt32(sqlr["ItemID"])); charobj.AddItem(nItem); } while (sqlr.Read()); } Characters.Add(charobj); } while (query.Read()); return Characters; }