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);
}
public bool GetMember(int CharacterID, out GuildMember Member)
{
lock (ThreadLocker)
{
Member = Members.Find(m => m.CharacterID.Equals(CharacterID));
}
return (Member != null);
}
public void Broadcast(Packet Packet, GuildMember Exclude = null)
{
lock (ThreadLocker)
{
foreach (var member in Members)
{
if (Exclude != null
&& member == Exclude)
continue;
if (member.IsOnline)
{
try
{
member.Character.Client.SendPacket(Packet);
}
catch (Exception)
{
continue;
}
}
}
}
}
