void GuildFinderMgr::AddMembershipRequest(uint32 guildGuid, MembershipRequest const& request)
{
m_membershipRequests[guildGuid].push_back(request);
static SqlStatementID insertFinderApplicant;
CharacterDatabase.BeginTransaction();
SqlStatement stmt = CharacterDatabase.CreateStatement(insertFinderApplicant, "REPLACE INTO guild_finder_applicant (guildId, playerGuid, availability, classRole, interests, comment, submitTime) VALUES(?, ?, ?, ?, ?, ?, ?)");
stmt.addUInt32(request.GetGuildId());
stmt.addUInt32(request.GetPlayerGuid());
stmt.addUInt8(request.GetAvailability());
stmt.addUInt8(request.GetClassRoles());
stmt.addUInt8(request.GetInterests());
stmt.addString(request.GetComment());
stmt.addUInt32(request.GetSubmitTime());
stmt.Execute();
CharacterDatabase.CommitTransaction();
// Notify the applicant his submittion has been added
if (Player* player = sObjectAccessor.FindPlayer(ObjectGuid(HIGHGUID_PLAYER, request.GetPlayerGuid())))
SendMembershipRequestListUpdate(*player);
// Notify the guild master and officers the list changed
if (Guild* guild = sGuildMgr.GetGuildById(guildGuid))
SendApplicantListUpdate(*guild);
}
