GuildMgr.cpp

Go to the documentation of this file.

/*
 * This file is part of the TrinityCore Project. See AUTHORS file for Copyright information
 *
 * 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 "GuildMgr.h"
#include "AchievementMgr.h"
#include "DB2Stores.h"
#include "DatabaseEnv.h"
#include "Guild.h"
#include "Log.h"
#include "ObjectMgr.h"
#include "Util.h"
#include "World.h"
 
GuildMgr::GuildMgr() : NextGuildId(UI64LIT(1))
{
}
 
GuildMgr::~GuildMgr() = default;
 
void GuildMgr::AddGuild(Guild* guild)
{
 Trinity::unique_trackable_ptr<Guild>& ptr = GuildStore[guild->GetId()];
 ptr.reset(guild);
 guild->SetWeakPtr(ptr);
}
 
void GuildMgr::RemoveGuild(ObjectGuid::LowType guildId)
{
 GuildStore.erase(guildId);
}
 
void GuildMgr::SaveGuilds()
{
 for (GuildContainer::iterator itr = GuildStore.begin(); itr != GuildStore.end(); ++itr)
 itr->second->SaveToDB();
}
 
ObjectGuid::LowType GuildMgr::GenerateGuildId()
{
 if (NextGuildId >= 0xFFFFFFFE)
 {
 TC_LOG_ERROR("guild", "Guild ids overflow!! Can't continue, shutting down server. ");
 World::StopNow(ERROR_EXIT_CODE);
 }
 return NextGuildId++;
}
 
// Guild collection
Guild* GuildMgr::GetGuildById(ObjectGuid::LowType guildId) const
{
 GuildContainer::const_iterator itr = GuildStore.find(guildId);
 if (itr != GuildStore.end())
 return itr->second.get();
 
 return nullptr;
}
 
Guild* GuildMgr::GetGuildByGuid(ObjectGuid guid) const
{
 // Full guids are only used when receiving/sending data to client
 // everywhere else guild id is used
 if (guid.IsGuild())
 if (ObjectGuid::LowType guildId = guid.GetCounter())
 return GetGuildById(guildId);
 
 return nullptr;
}
 
Guild* GuildMgr::GetGuildByName(std::string_view guildName) const
{
 for (auto const& [id, guild] : GuildStore)
 if (StringEqualI(guild->GetName(), guildName))
 return guild.get();
 
 return nullptr;
}
 
std::string GuildMgr::GetGuildNameById(ObjectGuid::LowType guildId) const
{
 if (Guild* guild = GetGuildById(guildId))
 return guild->GetName();
 
 return "";
}
 
GuildMgr* GuildMgr::instance()
{
 static GuildMgr instance;
 return &instance;
}
 
Guild* GuildMgr::GetGuildByLeader(ObjectGuid guid) const
{
 for (GuildContainer::const_iterator itr = GuildStore.begin(); itr != GuildStore.end(); ++itr)
 if (itr->second->GetLeaderGUID() == guid)
 return itr->second.get();
 
 return nullptr;
}
 
void GuildMgr::LoadGuilds()
{
 // 1. Load all guilds
 TC_LOG_INFO("server.loading", "Loading guilds definitions...");
 {
 uint32 oldMSTime = getMSTime();
 
 // 0 1 2 3 4 5 6
 QueryResult result = CharacterDatabase.Query("SELECT g.guildid, g.name, g.leaderguid, g.EmblemStyle, g.EmblemColor, g.BorderStyle, g.BorderColor, "
 // 7 8 9 10 11 12
 "g.BackgroundColor, g.info, g.motd, g.createdate, g.BankMoney, COUNT(gbt.guildid) "
 "FROM guild g LEFT JOIN guild_bank_tab gbt ON g.guildid = gbt.guildid GROUP BY g.guildid ORDER BY g.guildid ASC");
 
 if (!result)
 {
 TC_LOG_INFO("server.loading", ">> Loaded 0 guild definitions. DB table `guild` is empty.");
 return;
 }
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 Guild* guild = new Guild();
 
 if (!guild->LoadFromDB(fields))
 {
 delete guild;
 continue;
 }
 
 AddGuild(guild);
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} guild definitions in {} ms", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 // 2. Load all guild ranks
 TC_LOG_INFO("server.loading", "Loading guild ranks...");
 {
 uint32 oldMSTime = getMSTime();
 
 // Delete orphaned guild rank entries before loading the valid ones
 CharacterDatabase.DirectExecute("DELETE gr FROM guild_rank gr LEFT JOIN guild g ON gr.guildId = g.guildId WHERE g.guildId IS NULL");
 
 // 0 1 2 3 4 5
 QueryResult result = CharacterDatabase.Query("SELECT guildid, rid, RankOrder, rname, rights, BankMoneyPerDay FROM guild_rank ORDER BY guildid ASC, rid ASC");
 
 if (!result)
 {
 TC_LOG_INFO("server.loading", ">> Loaded 0 guild ranks. DB table `guild_rank` is empty.");
 }
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 uint64 guildId = fields[0].GetUInt64();
 
 if (Guild* guild = GetGuildById(guildId))
 guild->LoadRankFromDB(fields);
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} guild ranks in {} ms", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 // 3. Load all guild members
 TC_LOG_INFO("server.loading", "Loading guild members...");
 {
 uint32 oldMSTime = getMSTime();
 
 // Delete orphaned guild member entries before loading the valid ones
 CharacterDatabase.DirectExecute("DELETE gm FROM guild_member gm LEFT JOIN guild g ON gm.guildId = g.guildId WHERE g.guildId IS NULL");
 CharacterDatabase.DirectExecute("DELETE gm FROM guild_member_withdraw gm LEFT JOIN guild_member g ON gm.guid = g.guid WHERE g.guid IS NULL");
 
 // 0 1 2 3 4 5 6 7 8 9 10
 QueryResult result = CharacterDatabase.Query("SELECT gm.guildid, gm.guid, `rank`, pnote, offnote, w.tab0, w.tab1, w.tab2, w.tab3, w.tab4, w.tab5, "
 // 11 12 13 14 15 16 17 18 19 20 21
 "w.tab6, w.tab7, w.money, c.name, c.level, c.race, c.class, c.gender, c.zone, c.account, c.logout_time "
 "FROM guild_member gm "
 "LEFT JOIN guild_member_withdraw w ON gm.guid = w.guid "
 "LEFT JOIN characters c ON c.guid = gm.guid ORDER BY gm.guildid ASC");
 
 if (!result)
 TC_LOG_INFO("server.loading", ">> Loaded 0 guild members. DB table `guild_member` is empty.");
 else
 {
 uint32 count = 0;
 
 do
 {
 Field* fields = result->Fetch();
 uint64 guildId = fields[0].GetUInt64();
 
 if (Guild* guild = GetGuildById(guildId))
 guild->LoadMemberFromDB(fields);
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} guild members in {} ms", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 // 4. Load all guild bank tab rights
 TC_LOG_INFO("server.loading", "Loading bank tab rights...");
 {
 uint32 oldMSTime = getMSTime();
 
 // Delete orphaned guild bank right entries before loading the valid ones
 CharacterDatabase.DirectExecute("DELETE gbr FROM guild_bank_right gbr LEFT JOIN guild g ON gbr.guildId = g.guildId WHERE g.guildId IS NULL");
 
 // 0 1 2 3 4
 QueryResult result = CharacterDatabase.Query("SELECT guildid, TabId, rid, gbright, SlotPerDay FROM guild_bank_right ORDER BY guildid ASC, TabId ASC");
 
 if (!result)
 {
 TC_LOG_INFO("server.loading", ">> Loaded 0 guild bank tab rights. DB table `guild_bank_right` is empty.");
 }
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 uint64 guildId = fields[0].GetUInt64();
 
 if (Guild* guild = GetGuildById(guildId))
 guild->LoadBankRightFromDB(fields);
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} bank tab rights in {} ms", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 // 5. Load all event logs
 TC_LOG_INFO("server.loading", "Loading guild event logs...");
 {
 uint32 oldMSTime = getMSTime();
 
 CharacterDatabase.DirectPExecute("DELETE FROM guild_eventlog WHERE LogGuid > {}", sWorld->getIntConfig(CONFIG_GUILD_EVENT_LOG_COUNT));
 
 // 0 1 2 3 4 5 6
 QueryResult result = CharacterDatabase.Query("SELECT guildid, LogGuid, EventType, PlayerGuid1, PlayerGuid2, NewRank, TimeStamp FROM guild_eventlog ORDER BY TimeStamp DESC, LogGuid DESC");
 
 if (!result)
 {
 TC_LOG_INFO("server.loading", ">> Loaded 0 guild event logs. DB table `guild_eventlog` is empty.");
 }
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 uint64 guildId = fields[0].GetUInt64();
 
 if (Guild* guild = GetGuildById(guildId))
 guild->LoadEventLogFromDB(fields);
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} guild event logs in {} ms", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 // 6. Load all bank event logs
 TC_LOG_INFO("server.loading", "Loading guild bank event logs...");
 {
 uint32 oldMSTime = getMSTime();
 
 // Remove log entries that exceed the number of allowed entries per guild
 CharacterDatabase.DirectPExecute("DELETE FROM guild_bank_eventlog WHERE LogGuid > {}", sWorld->getIntConfig(CONFIG_GUILD_BANK_EVENT_LOG_COUNT));
 
 // 0 1 2 3 4 5 6 7 8
 QueryResult result = CharacterDatabase.Query("SELECT guildid, TabId, LogGuid, EventType, PlayerGuid, ItemOrMoney, ItemStackCount, DestTabId, TimeStamp FROM guild_bank_eventlog ORDER BY TimeStamp DESC, LogGuid DESC");
 
 if (!result)
 {
 TC_LOG_INFO("server.loading", ">> Loaded 0 guild bank event logs. DB table `guild_bank_eventlog` is empty.");
 }
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 uint64 guildId = fields[0].GetUInt64();
 
 if (Guild* guild = GetGuildById(guildId))
 guild->LoadBankEventLogFromDB(fields);
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} guild bank event logs in {} ms", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 // 7. Load all news event logs
 TC_LOG_INFO("server.loading", "Loading Guild News...");
 {
 uint32 oldMSTime = getMSTime();
 
 CharacterDatabase.DirectPExecute("DELETE FROM guild_newslog WHERE LogGuid > {}", sWorld->getIntConfig(CONFIG_GUILD_NEWS_LOG_COUNT));
 
 // 0 1 2 3 4 5 6
 QueryResult result = CharacterDatabase.Query("SELECT guildid, LogGuid, EventType, PlayerGuid, Flags, Value, Timestamp FROM guild_newslog ORDER BY TimeStamp DESC, LogGuid DESC");
 
 if (!result)
 TC_LOG_INFO("server.loading", ">> Loaded 0 guild event logs. DB table `guild_newslog` is empty.");
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 uint64 guildId = fields[0].GetUInt64();
 
 if (Guild* guild = GetGuildById(guildId))
 guild->LoadGuildNewsLogFromDB(fields);
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} guild new logs in {} ms", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 // 8. Load all guild bank tabs
 TC_LOG_INFO("server.loading", "Loading guild bank tabs...");
 {
 uint32 oldMSTime = getMSTime();
 
 // Delete orphaned guild bank tab entries before loading the valid ones
 CharacterDatabase.DirectExecute("DELETE gbt FROM guild_bank_tab gbt LEFT JOIN guild g ON gbt.guildId = g.guildId WHERE g.guildId IS NULL");
 
 // 0 1 2 3 4
 QueryResult result = CharacterDatabase.Query("SELECT guildid, TabId, TabName, TabIcon, TabText FROM guild_bank_tab ORDER BY guildid ASC, TabId ASC");
 
 if (!result)
 {
 TC_LOG_INFO("server.loading", ">> Loaded 0 guild bank tabs. DB table `guild_bank_tab` is empty.");
 }
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 uint64 guildId = fields[0].GetUInt64();
 
 if (Guild* guild = GetGuildById(guildId))
 guild->LoadBankTabFromDB(fields);
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} guild bank tabs in {} ms", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 // 9. Fill all guild bank tabs
 TC_LOG_INFO("server.loading", "Filling bank tabs with items...");
 {
 uint32 oldMSTime = getMSTime();
 
 // Delete orphan guild bank items
 CharacterDatabase.DirectExecute("DELETE gbi FROM guild_bank_item gbi LEFT JOIN guild g ON gbi.guildId = g.guildId WHERE g.guildId IS NULL");
 
 // 0 1 2 3 4 5 6 7 8 9 10 11 12
 // SELECT guid, itemEntry, creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomBonusListId, durability, playedTime, text,
 // 13 14 15 16 17 18
 // battlePetSpeciesId, battlePetBreedData, battlePetLevel, battlePetDisplayId, context, bonusListIDs,
 // 19 20 21 22 23 24
 // itemModifiedAppearanceAllSpecs, itemModifiedAppearanceSpec1, itemModifiedAppearanceSpec2, itemModifiedAppearanceSpec3, itemModifiedAppearanceSpec4, itemModifiedAppearanceSpec5,
 // 25 26 27 28 29 30
 // spellItemEnchantmentAllSpecs, spellItemEnchantmentSpec1, spellItemEnchantmentSpec2, spellItemEnchantmentSpec3, spellItemEnchantmentSpec4, spellItemEnchantmentSpec5,
 // 31 32 33
 // secondaryItemModifiedAppearanceAllSpecs, secondaryItemModifiedAppearanceSpec1, secondaryItemModifiedAppearanceSpec2,
 // 34 35 36
 // secondaryItemModifiedAppearanceSpec3, secondaryItemModifiedAppearanceSpec4, secondaryItemModifiedAppearanceSpec5,
 // 37 38 39 40 41 42 43 44 45 46 47 48
 // gemItemId1, gemBonuses1, gemContext1, gemScalingLevel1, gemItemId2, gemBonuses2, gemContext2, gemScalingLevel2, gemItemId3, gemBonuses3, gemContext3, gemScalingLevel3
 // 49 50
 // fixedScalingLevel, artifactKnowledgeLevel
 // 51 52 53
 // guildid, TabId, SlotId FROM guild_bank_item gbi INNER JOIN item_instance ii ON gbi.item_guid = ii.guid
 
 PreparedQueryResult result = CharacterDatabase.Query(CharacterDatabase.GetPreparedStatement(CHAR_SEL_GUILD_BANK_ITEMS));
 if (!result)
 {
 TC_LOG_INFO("server.loading", ">> Loaded 0 guild bank tab items. DB table `guild_bank_item` or `item_instance` is empty.");
 }
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 uint64 guildId = fields[51].GetUInt64();
 
 if (Guild* guild = GetGuildById(guildId))
 guild->LoadBankItemFromDB(fields);
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} guild bank tab items in {} ms", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 // 10. Load guild achievements
 TC_LOG_INFO("server.loading", "Loading guild achievements...");
 {
 uint32 oldMSTime = getMSTime();
 
 uint64 achievementCount = 0;
 uint64 criteriaCount = 0;
 
 PreparedQueryResult achievementResult;
 PreparedQueryResult criteriaResult;
 for (GuildContainer::const_iterator itr = GuildStore.begin(); itr != GuildStore.end(); ++itr)
 {
 CharacterDatabasePreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_SEL_GUILD_ACHIEVEMENT);
 stmt->setUInt64(0, itr->first);
 achievementResult = CharacterDatabase.Query(stmt);
 stmt = CharacterDatabase.GetPreparedStatement(CHAR_SEL_GUILD_ACHIEVEMENT_CRITERIA);
 stmt->setUInt64(0, itr->first);
 criteriaResult = CharacterDatabase.Query(stmt);
 
 if (achievementResult)
 achievementCount += achievementResult->GetRowCount();
 if (criteriaResult)
 criteriaCount += criteriaResult->GetRowCount();
 
 itr->second->GetAchievementMgr().LoadFromDB(achievementResult, criteriaResult);
 }
 
 TC_LOG_INFO("server.loading", ">> Loaded {} guild achievements and {} criterias in {} ms", achievementCount, criteriaCount, GetMSTimeDiffToNow(oldMSTime));
 }
 
 // 11. Validate loaded guild data
 TC_LOG_INFO("misc", "Validating data of loaded guilds...");
 {
 uint32 oldMSTime = getMSTime();
 
 for (GuildContainer::iterator itr = GuildStore.begin(); itr != GuildStore.end();)
 {
 Guild* guild = itr->second.get();
 ++itr;
 if (guild)
 guild->Validate();
 }
 
 TC_LOG_INFO("server.loading", ">> Validated data of loaded guilds in {} ms", GetMSTimeDiffToNow(oldMSTime));
 }
}
 
void GuildMgr::LoadGuildRewards()
{
 uint32 oldMSTime = getMSTime();
 
 // 0 1 2 3
 QueryResult result = WorldDatabase.Query("SELECT ItemID, MinGuildRep, RaceMask, Cost FROM guild_rewards");
 
 if (!result)
 {
 TC_LOG_ERROR("server.loading", ">> Loaded 0 guild reward definitions. DB table `guild_rewards` is empty.");
 return;
 }
 
 uint32 count = 0;
 
 do
 {
 GuildReward reward;
 Field* fields = result->Fetch();
 reward.ItemID = fields[0].GetUInt32();
 reward.MinGuildRep = fields[1].GetUInt8();
 reward.RaceMask.RawValue = fields[2].GetUInt64();
 reward.Cost = fields[3].GetUInt64();
 
 if (!sObjectMgr->GetItemTemplate(reward.ItemID))
 {
 TC_LOG_ERROR("server.loading", "Guild rewards constains not existing item entry {}", reward.ItemID);
 continue;
 }
 
 if (reward.MinGuildRep >= MAX_REPUTATION_RANK)
 {
 TC_LOG_ERROR("server.loading", "Guild rewards contains wrong reputation standing {}, max is {}", uint32(reward.MinGuildRep), MAX_REPUTATION_RANK - 1);
 continue;
 }
 
 WorldDatabasePreparedStatement* stmt = WorldDatabase.GetPreparedStatement(WORLD_SEL_GUILD_REWARDS_REQ_ACHIEVEMENTS);
 stmt->setUInt32(0, reward.ItemID);
 PreparedQueryResult reqAchievementResult = WorldDatabase.Query(stmt);
 if (reqAchievementResult)
 {
 do
 {
 fields = reqAchievementResult->Fetch();
 
 uint32 requiredAchievementId = fields[0].GetUInt32();
 
 if (!sAchievementStore.LookupEntry(requiredAchievementId))
 {
 TC_LOG_ERROR("server.loading", "Guild rewards constains not existing achievement entry {}", requiredAchievementId);
 continue;
 }
 
 reward.AchievementsRequired.push_back(requiredAchievementId);
 } while (reqAchievementResult->NextRow());
 }
 
 GuildRewards.push_back(reward);
 ++count;
 } while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} guild reward definitions in {} ms", count, GetMSTimeDiffToNow(oldMSTime));
}
 
void GuildMgr::ResetTimes(bool week)
{
 CharacterDatabase.Execute(CharacterDatabase.GetPreparedStatement(CHAR_DEL_GUILD_MEMBER_WITHDRAW));
 
 for (GuildContainer::const_iterator itr = GuildStore.begin(); itr != GuildStore.end(); ++itr)
 if (Guild* guild = itr->second.get())
 guild->ResetTimes(week);
}