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); }