public void AddMembershipRequest(ObjectGuid guildGuid, MembershipRequest request)
{
_membershipRequestsByGuild[guildGuid][request.GetPlayerGUID()] = request;
_membershipRequestsByPlayer[request.GetPlayerGUID()][guildGuid] = request;
SQLTransaction trans = new SQLTransaction();
PreparedStatement stmt = DB.Characters.GetPreparedStatement(CharStatements.REP_GUILD_FINDER_APPLICANT);
stmt.AddValue(0, request.GetGuildGuid());
stmt.AddValue(1, request.GetPlayerGUID());
stmt.AddValue(2, request.GetAvailability());
stmt.AddValue(3, request.GetClassRoles());
stmt.AddValue(4, request.GetInterests());
stmt.AddValue(5, request.GetComment());
stmt.AddValue(6, request.GetSubmitTime());
trans.Append(stmt);
DB.Characters.CommitTransaction(trans);
// Notify the applicant his submittion has been added
Player player = Global.ObjAccessor.FindPlayer(request.GetPlayerGUID());
if (player)
{
SendMembershipRequestListUpdate(player);
}
// Notify the guild master and officers the list changed
Guild guild = Global.GuildMgr.GetGuildById(guildGuid.GetCounter());
if (guild)
{
SendApplicantListUpdate(guild);
}
}
public MembershipRequest(MembershipRequest settings)
{
_comment = settings.GetComment();
_availability = settings.GetAvailability();
_classRoles = settings.GetClassRoles();
_interests = settings.GetInterests();
_guildId = settings.GetGuildGuid();
_playerGUID = settings.GetPlayerGUID();
_time = settings.GetSubmitTime();
}