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