Merge pull request #7693 from Warpten/guildFinder

Core/Guilds: Implemented guild finder.

1 files changed, 333 insertions, 0 deletions

diff --git a/src/server/game/Guilds/GuildFinderMgr.cpp b/src/server/game/Guilds/GuildFinderMgr.cpp
new file mode 100644
index 00000000000..c81abeec47a
--- /dev/null
+++ b/src/server/game/Guilds/GuildFinderMgr.cpp
@@ -0,0 +1,333 @@
+/*
+ * Copyright (C) 2008-2012 TrinityCore <http://www.trinitycore.org/>
+ *
+ * This program is free software; you can redistribute it and/or modify it
+ * under the terms of the GNU General Public License as published by the
+ * Free Software Foundation; either version 2 of the License, or (at your
+ * option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful, but WITHOUT
+ * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
+ * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
+ * more details.
+ *
+ * You should have received a copy of the GNU General Public License along
+ * with this program. If not, see <http://www.gnu.org/licenses/>.
+ */
+
+#include "ObjectMgr.h"
+#include "GuildFinderMgr.h"
+#include "GuildMgr.h"
+#include "World.h"
+
+GuildFinderMgr::GuildFinderMgr()
+{
+}
+
+GuildFinderMgr::~GuildFinderMgr()
+{
+}
+
+void GuildFinderMgr::LoadFromDB()
+{
+    LoadGuildSettings();
+    LoadMembershipRequests();
+}
+
+void GuildFinderMgr::LoadGuildSettings()
+{
+    sLog->outInfo(LOG_FILTER_SERVER_LOADING, "Loading guild finder guild-related settings...");
+    //                                                           0                1             2                  3             4           5             6         7
+    QueryResult result = CharacterDatabase.Query("SELECT gfgs.guildId, gfgs.availability, gfgs.classRoles, gfgs.interests, gfgs.level, gfgs.listed, gfgs.comment, c.race "
+                                                 "FROM guild_finder_guild_settings gfgs "
+                                                 "LEFT JOIN guild_member gm ON gm.guildid=gfgs.guildId "
+                                                 "LEFT JOIN characters c ON c.guid = gm.guid LIMIT 1");
+    
+    if (!result)
+    {
+        sLog->outInfo(LOG_FILTER_SERVER_LOADING, ">> Loaded 0 guild finder guild-related settings. Table `guild_finder_guild_settings` is empty.");
+        return;
+    }
+    
+    uint32 count = 0;
+    uint32 oldMSTime = getMSTime();
+    do
+    {
+        Field* fields = result->Fetch();
+        uint32 guildId      = fields[0].GetUInt32();
+        uint8  availability = fields[1].GetUInt8();
+        uint8  classRoles   = fields[2].GetUInt8();
+        uint8  interests    = fields[3].GetUInt8();
+        uint8  level        = fields[4].GetUInt8();
+        bool   listed       = (fields[5].GetUInt8() != 0);
+        std::string comment = fields[6].GetString();
+
+        TeamId guildTeam = TEAM_ALLIANCE;
+        if (ChrRacesEntry const* raceEntry = sChrRacesStore.LookupEntry(fields[7].GetUInt8()))
+            if (raceEntry->TeamID == 1)
+                guildTeam = TEAM_HORDE;
+
+        LFGuildSettings settings(listed, guildTeam, guildId, classRoles, availability, interests, level, comment);
+        _guildSettings[guildId] = settings;
+        
+        ++count;
+    } while (result->NextRow());
+
+    sLog->outInfo(LOG_FILTER_SERVER_LOADING, ">> Loaded %u guild finder guild-related settings in %u ms.", count, GetMSTimeDiffToNow(oldMSTime));
+}
+
+void GuildFinderMgr::LoadMembershipRequests()
+{
+    sLog->outInfo(LOG_FILTER_SERVER_LOADING, "Loading guild finder membership requests...");
+    //                                                      0         1           2            3           4         5         6
+    QueryResult result = CharacterDatabase.Query("SELECT guildId, playerGuid, availability, classRole, interests, comment, submitTime "
+                                                 "FROM guild_finder_applicant");
+    
+    if (!result)
+    {
+        sLog->outInfo(LOG_FILTER_SERVER_LOADING, ">> Loaded 0 guild finder membership requests. Table `guild_finder_applicant` is empty.");
+        return;
+    }
+    
+    uint32 count = 0;
+    uint32 oldMSTime = getMSTime();
+    do
+    {
+        Field* fields = result->Fetch();
+        uint32 guildId      = fields[0].GetUInt32();
+        uint32 playerId     = fields[1].GetUInt32();
+        uint8  availability = fields[2].GetUInt8();
+        uint8  classRoles   = fields[3].GetUInt8();
+        uint8  interests    = fields[4].GetUInt8();
+        std::string comment = fields[5].GetString();
+        uint32 submitTime   = fields[6].GetUInt32();
+        
+        MembershipRequest request(playerId, guildId, availability, classRoles, interests, comment, time_t(submitTime));
+
+        _membershipRequests[guildId].push_back(request);
+        
+        ++count;
+    } while (result->NextRow());
+
+    sLog->outInfo(LOG_FILTER_SERVER_LOADING, ">> Loaded %u guild finder membership requests in %u ms.", count, GetMSTimeDiffToNow(oldMSTime));
+}
+
+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::RemoveAllMembershipRequestsFromPlayer(uint32 playerId)
+{
+    for (MembershipRequestStore::iterator itr = _membershipRequests.begin(); itr != _membershipRequests.end(); ++itr)
+    {
+        std::vector<MembershipRequest>::iterator itr2 = itr->second.begin();
+        for(; itr2 != itr->second.end(); ++itr2)
+            if (itr2->GetPlayerGUID() == playerId)
+                break;
+
+        if (itr2 == itr->second.end())
+            return;
+
+        SQLTransaction trans = CharacterDatabase.BeginTransaction();
+
+        PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_DEL_GUILD_FINDER_APPLICANT);
+        stmt->setUInt32(0, itr2->GetGuildId());
+        stmt->setUInt32(1, itr2->GetPlayerGUID());
+        trans->Append(stmt);
+
+        CharacterDatabase.CommitTransaction(trans);
+        itr->second.erase(itr2);
+
+        // Notify the guild master and officers the list changed
+        if (Guild* guild = sGuildMgr->GetGuildById(itr->first))
+            SendApplicantListUpdate(*guild);
+    }
+}
+
+void GuildFinderMgr::RemoveMembershipRequest(uint32 playerId, uint32 guildId)
+{
+    std::vector<MembershipRequest>::iterator itr = _membershipRequests[guildId].begin();
+    for(; itr != _membershipRequests[guildId].end(); ++itr)
+        if (itr->GetPlayerGUID() == playerId)
+            break;
+
+    if (itr == _membershipRequests[guildId].end())
+        return;
+
+    SQLTransaction trans = CharacterDatabase.BeginTransaction();
+
+    PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_DEL_GUILD_FINDER_APPLICANT);
+    stmt->setUInt32(0, itr->GetGuildId());
+    stmt->setUInt32(1, itr->GetPlayerGUID());
+    trans->Append(stmt);
+
+    CharacterDatabase.CommitTransaction(trans);
+
+    _membershipRequests[guildId].erase(itr);
+
+    // Notify the applicant his submittion has been removed
+    if (Player* player = ObjectAccessor::FindPlayer(MAKE_NEW_GUID(playerId, 0, HIGHGUID_PLAYER)))
+        SendMembershipRequestListUpdate(*player);
+
+    // Notify the guild master and officers the list changed
+    if (Guild* guild = sGuildMgr->GetGuildById(guildId))
+        SendApplicantListUpdate(*guild);
+}
+
+std::list<MembershipRequest> GuildFinderMgr::GetAllMembershipRequestsForPlayer(uint32 playerGuid)
+{
+    std::list<MembershipRequest> resultSet;
+    for (MembershipRequestStore::const_iterator itr = _membershipRequests.begin(); itr != _membershipRequests.end(); ++itr)
+    {
+        std::vector<MembershipRequest> const& guildReqs = itr->second;
+        for (std::vector<MembershipRequest>::const_iterator itr2 = guildReqs.begin(); itr2 != guildReqs.end(); ++itr2)
+        {
+            if (itr2->GetPlayerGUID() == playerGuid)
+            {
+                resultSet.push_back(*itr2);
+                break;
+            }
+        }
+    }
+    return resultSet;
+}
+
+uint8 GuildFinderMgr::CountRequestsFromPlayer(uint32 playerId)
+{
+    uint8 result = 0;
+    for (MembershipRequestStore::const_iterator itr = _membershipRequests.begin(); itr != _membershipRequests.end(); ++itr)
+    {
+        for (std::vector<MembershipRequest>::const_iterator itr2 = itr->second.begin(); itr2 != itr->second.end(); ++itr2)
+        {
+            if (itr2->GetPlayerGUID() != playerId)
+                continue;
+            ++result;
+            break;
+        }
+    }
+    return result;
+}
+
+LFGuildStore GuildFinderMgr::GetGuildsMatchingSetting(LFGuildPlayer& settings, TeamId faction)
+{
+    LFGuildStore resultSet;
+    for (LFGuildStore::const_iterator itr = _guildSettings.begin(); itr != _guildSettings.end(); ++itr)
+    {
+        LFGuildSettings const& guildSettings = itr->second;
+
+        if (guildSettings.GetTeam() != faction)
+            continue;
+
+        if (!(guildSettings.GetAvailability() & settings.GetAvailability()))
+            continue;
+
+        if (!(guildSettings.GetClassRoles() & settings.GetClassRoles()))
+            continue;
+
+        if (!(guildSettings.GetInterests() & settings.GetInterests()))
+            continue;
+
+        if (!(guildSettings.GetLevel() & settings.GetLevel()))
+            continue;
+
+        resultSet.insert(std::make_pair(itr->first, guildSettings));
+    }
+
+    return resultSet;
+}
+
+bool GuildFinderMgr::HasRequest(uint32 playerId, uint32 guildId)
+{
+    for (std::vector<MembershipRequest>::const_iterator itr = _membershipRequests[guildId].begin(); itr != _membershipRequests[guildId].end(); ++itr)
+        if (itr->GetPlayerGUID() == playerId)
+            return true;
+    return false;
+}
+
+void GuildFinderMgr::SetGuildSettings(uint32 guildGuid, LFGuildSettings const& settings)
+{
+    _guildSettings[guildGuid] = settings;
+
+    SQLTransaction trans = CharacterDatabase.BeginTransaction();
+
+    PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_REP_GUILD_FINDER_GUILD_SETTINGS);
+    stmt->setUInt32(0, settings.GetGUID());
+    stmt->setUInt8(1, settings.GetAvailability());
+    stmt->setUInt8(2, settings.GetClassRoles());
+    stmt->setUInt8(3, settings.GetInterests());
+    stmt->setUInt8(4, settings.GetLevel());
+    stmt->setUInt8(5, settings.IsListed());
+    stmt->setString(6, settings.GetComment());
+    trans->Append(stmt);
+
+    CharacterDatabase.CommitTransaction(trans);
+}
+
+void GuildFinderMgr::DeleteGuild(uint32 guildId)
+{
+    std::vector<MembershipRequest>::iterator itr = _membershipRequests[guildId].begin();
+    while (itr != _membershipRequests[guildId].end())
+    {
+        SQLTransaction trans = CharacterDatabase.BeginTransaction();
+
+        uint32 applicant = itr->GetPlayerGUID();
+
+        PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_DEL_GUILD_FINDER_APPLICANT);
+        stmt->setUInt32(0, itr->GetGuildId());
+        stmt->setUInt32(1, applicant);
+        trans->Append(stmt);
+
+        stmt = CharacterDatabase.GetPreparedStatement(CHAR_DEL_GUILD_FINDER_GUILD_SETTINGS);
+        stmt->setUInt32(0, itr->GetGuildId());
+        trans->Append(stmt);
+            
+        CharacterDatabase.CommitTransaction(trans);
+        _membershipRequests[guildId].erase(itr);
+
+        // Notify the applicant his submition has been removed
+        if (Player* player = ObjectAccessor::FindPlayer(MAKE_NEW_GUID(applicant, 0, HIGHGUID_PLAYER)))
+            SendMembershipRequestListUpdate(*player);
+    }
+
+    _membershipRequests.erase(guildId);
+    _guildSettings.erase(guildId);
+
+    // Notify the guild master the list changed (even if he's not a GM any more, not sure if needed)
+    if (Guild* guild = sGuildMgr->GetGuildById(guildId))
+        SendApplicantListUpdate(*guild);
+}
+
+void GuildFinderMgr::SendApplicantListUpdate(Guild& guild)
+{
+    WorldPacket data(SMSG_LF_GUILD_APPLICANT_LIST_UPDATED, 0);
+    if (Player* player = ObjectAccessor::FindPlayer(guild.GetLeaderGUID()))
+        player->SendDirectMessage(&data);
+    guild.BroadcastPacketToRank(&data, GR_OFFICER);
+}
+
+void GuildFinderMgr::SendMembershipRequestListUpdate(Player& player)
+{
+    WorldPacket data(SMSG_LF_GUILD_APPLICATIONS_LIST_CHANGED, 0);
+    player.SendDirectMessage(&data);
+}