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);
}
void GuildFinderMgr::AddMembershipRequest(uint32 guildGuid, MembershipRequest const& request)
{
_membershipRequests[guildGuid].push_back(request);
SQLTransaction trans = CharacterDatabase.BeginTransaction();
PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_REP_GUILD_FINDER_APPLICANT);
stmt->setUInt32(0, request.GetGuildId());
stmt->setUInt32(1, request.GetPlayerGUID());
stmt->setUInt8(2, request.GetAvailability());
stmt->setUInt8(3, request.GetClassRoles());
stmt->setUInt8(4, request.GetInterests());
stmt->setString(5, request.GetComment());
stmt->setUInt32(6, request.GetSubmitTime());
trans->Append(stmt);
CharacterDatabase.CommitTransaction(trans);
// Notify the applicant his submittion has been added
if (Player* player = ObjectAccessor::FindPlayer(MAKE_NEW_GUID(request.GetPlayerGUID(), 0, HIGHGUID_PLAYER)))
SendMembershipRequestListUpdate(*player);
// Notify the guild master and officers the list changed
if (Guild* guild = sGuildMgr->GetGuildById(guildGuid))
SendApplicantListUpdate(*guild);
}
void GuildFinderMgr::AddMembershipRequest(uint32 guildGuid, MembershipRequest const& request)
{
_membershipRequests[guildGuid].push_back(request);
std::string comment = request.GetComment();
CharacterDatabase.escape_string(comment);
CharacterDatabase.PExecute("REPLACE INTO guild_finder_applicant (guildId, playerGuid, availability, classRole, interests, comment, submitTime) VALUES('%u', '%u', '%u', '%u', '%u', '%s', '%u')", request.GetGuildId(), request.GetPlayerGUID(), request.GetAvailability(), request.GetClassRoles(), request.GetInterests(), comment.c_str(), request.GetSubmitTime());
// 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);
}