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