public GuildAcademyMember(GuildAcademy Academy, int CharacterID, GuildAcademyRank Rank, DateTime RegisterTime)
{
this.Academy = Academy;
this.CharacterID = CharacterID;
this.Rank = Rank;
this.RegisterDate = RegisterDate;
}
public GuildAcademyMember(GuildAcademy Academy, MySqlDataReader reader)
{
this.Academy = Academy;
Load(reader);
}
private void Load()
{
//members
using (var cmd = Program.CharDBManager.GetClient().GetConnection().CreateCommand())
{
cmd.CommandText = "SELECT * FROM GuildMembers WHERE GuildID = @pGuildID";
cmd.Parameters.Add(new MySqlParameter("@pGuildID", ID));
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var member = new GuildMember(this, reader);
Members.Add(member);
}
}
}
//academy
Academy = new GuildAcademy(this);
}