private void Load()
{
//members
DataTable MemberData = null;
using (var DBClient = Program.DatabaseManager.GetClient())
{
MemberData = DBClient.ReadDataTable("SELECT * FROM GuildMembers WHERE GuildID = " + ID + "");
}
foreach (DataRow row in MemberData.Rows)
{
//get character
WorldCharacter character;
if (!CharacterManager.Instance.GetCharacterByID(Convert.ToInt32(row["CharID"]), out character))
{
continue;
}
var member = new GuildMember(this,
character,
(GuildRank)GetDataTypes.GetByte(row["Rank"]),
GetDataTypes.GetUshort(row["Korp"]));
Members.Add(member);
}
//academy
Academy = new GuildAcademy(this);
}
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);
}
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);
}
