public GuildMember(Guild Guild, int CharacterID, GuildRank Rank, ushort Corp)
{
this.Guild = Guild;
this.CharacterID = CharacterID;
this.Rank = Rank;
this.Corp = Corp;
}
public static bool GetGuildByID(int GuildID, out Guild Guild)
{
lock (ThreadLocker)
{
if ((Guild = LoadedGuilds.Find(g => g.ID.Equals(GuildID))) == null)
{
//load from db
using (var con = Program.CharDBManager.GetClient().GetConnection())
{
using (var cmd = con.CreateCommand())
{
cmd.CommandText = "SELECT * FROM Guilds WHERE ID = @pID";
cmd.Parameters.Add(new MySqlParameter("@pID", GuildID));
using (var reader = cmd.ExecuteReader())
{
if (!reader.Read())
return false;
//create new guild
Guild = new Guild(reader, con);
//add to cache
LoadedGuilds.Add(Guild);
reader.Close();
}
}
}
}
}
return (Guild != null);
}
public GuildMember(Guild Guild, MySqlDataReader reader)
{
this.Guild = Guild;
CharacterID = reader.GetInt32(1);
Rank = (GuildRank)reader.GetByte(2);
Corp = (ushort)reader.GetInt16(3);
}