GameEventMgr.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 "GameEventMgr.h"
#include "BattlegroundMgr.h"
#include "Creature.h"
#include "CreatureAI.h"
#include "DatabaseEnv.h"
#include "DB2Stores.h"
#include "GameObject.h"
#include "GameObjectAI.h"
#include "GameTime.h"
#include "Language.h"
#include "Log.h"
#include "Map.h"
#include "MapManager.h"
#include "ObjectMgr.h"
#include "Player.h"
#include "PoolMgr.h"
#include "StringConvert.h"
#include "World.h"
#include "WorldStateMgr.h"
 
GameEventMgr* GameEventMgr::instance()
{
 static GameEventMgr instance;
 return &instance;
}
 
bool GameEventMgr::CheckOneGameEvent(uint16 entry) const
{
 switch (mGameEvent[entry].state)
 {
 default:
 case GAMEEVENT_NORMAL:
 {
 time_t currenttime = GameTime::GetGameTime();
 // Get the event information
 return mGameEvent[entry].start < currenttime
 && currenttime < mGameEvent[entry].end
 && (currenttime - mGameEvent[entry].start) % (mGameEvent[entry].occurence * MINUTE) < mGameEvent[entry].length * MINUTE;
 }
 // if the state is conditions or nextphase, then the event should be active
 case GAMEEVENT_WORLD_CONDITIONS:
 case GAMEEVENT_WORLD_NEXTPHASE:
 return true;
 // finished world events are inactive
 case GAMEEVENT_WORLD_FINISHED:
 case GAMEEVENT_INTERNAL:
 return false;
 // if inactive world event, check the prerequisite events
 case GAMEEVENT_WORLD_INACTIVE:
 {
 time_t currenttime = GameTime::GetGameTime();
 for (std::set<uint16>::const_iterator itr = mGameEvent[entry].prerequisite_events.begin(); itr != mGameEvent[entry].prerequisite_events.end(); ++itr)
 {
 if ((mGameEvent[*itr].state != GAMEEVENT_WORLD_NEXTPHASE && mGameEvent[*itr].state != GAMEEVENT_WORLD_FINISHED) || // if prereq not in nextphase or finished state, then can't start this one
 mGameEvent[*itr].nextstart > currenttime) // if not in nextphase state for long enough, can't start this one
 return false;
 }
 // all prerequisite events are met
 // but if there are no prerequisites, this can be only activated through gm command
 return !(mGameEvent[entry].prerequisite_events.empty());
 }
 }
}
 
uint32 GameEventMgr::NextCheck(uint16 entry) const
{
 time_t currenttime = GameTime::GetGameTime();
 
 // for NEXTPHASE state world events, return the delay to start the next event, so the followup event will be checked correctly
 if ((mGameEvent[entry].state == GAMEEVENT_WORLD_NEXTPHASE || mGameEvent[entry].state == GAMEEVENT_WORLD_FINISHED) && mGameEvent[entry].nextstart >= currenttime)
 return uint32(mGameEvent[entry].nextstart - currenttime);
 
 // for CONDITIONS state world events, return the length of the wait period, so if the conditions are met, this check will be called again to set the timer as NEXTPHASE event
 if (mGameEvent[entry].state == GAMEEVENT_WORLD_CONDITIONS)
 {
 if (mGameEvent[entry].length)
 return mGameEvent[entry].length * 60;
 else
 return max_ge_check_delay;
 }
 
 // outdated event: we return max
 if (currenttime > mGameEvent[entry].end)
 return max_ge_check_delay;
 
 // never started event, we return delay before start
 if (mGameEvent[entry].start > currenttime)
 return uint32(mGameEvent[entry].start - currenttime);
 
 uint32 delay;
 // in event, we return the end of it
 if ((((currenttime - mGameEvent[entry].start) % (mGameEvent[entry].occurence * 60)) < (mGameEvent[entry].length * 60)))
 // we return the delay before it ends
 delay = (mGameEvent[entry].length * MINUTE) - ((currenttime - mGameEvent[entry].start) % (mGameEvent[entry].occurence * MINUTE));
 else // not in window, we return the delay before next start
 delay = (mGameEvent[entry].occurence * MINUTE) - ((currenttime - mGameEvent[entry].start) % (mGameEvent[entry].occurence * MINUTE));
 // In case the end is before next check
 if (mGameEvent[entry].end < time_t(currenttime + delay))
 return uint32(mGameEvent[entry].end - currenttime);
 else
 return delay;
}
 
void GameEventMgr::StartInternalEvent(uint16 event_id)
{
 if (event_id < 1 || event_id >= mGameEvent.size())
 return;
 
 if (!mGameEvent[event_id].isValid())
 return;
 
 if (m_ActiveEvents.find(event_id) != m_ActiveEvents.end())
 return;
 
 StartEvent(event_id);
}
 
bool GameEventMgr::StartEvent(uint16 event_id, bool overwrite)
{
 GameEventData &data = mGameEvent[event_id];
 if (data.state == GAMEEVENT_NORMAL || data.state == GAMEEVENT_INTERNAL)
 {
 AddActiveEvent(event_id);
 ApplyNewEvent(event_id);
 if (overwrite)
 {
 mGameEvent[event_id].start = GameTime::GetGameTime();
 if (data.end <= data.start)
 data.end = data.start + data.length;
 }
 return false;
 }
 else
 {
 if (data.state == GAMEEVENT_WORLD_INACTIVE)
 // set to conditions phase
 data.state = GAMEEVENT_WORLD_CONDITIONS;
 
 // add to active events
 AddActiveEvent(event_id);
 // add spawns
 ApplyNewEvent(event_id);
 
 // check if can go to next state
 bool conditions_met = CheckOneGameEventConditions(event_id);
 // save to db
 SaveWorldEventStateToDB(event_id);
 // force game event update to set the update timer if conditions were met from a command
 // this update is needed to possibly start events dependent on the started one
 // or to scedule another update where the next event will be started
 if (overwrite && conditions_met)
 sWorld->ForceGameEventUpdate();
 
 return conditions_met;
 }
}
 
void GameEventMgr::StopEvent(uint16 event_id, bool overwrite)
{
 GameEventData &data = mGameEvent[event_id];
 bool serverwide_evt = data.state != GAMEEVENT_NORMAL && data.state != GAMEEVENT_INTERNAL;
 
 RemoveActiveEvent(event_id);
 UnApplyEvent(event_id);
 
 if (overwrite && !serverwide_evt)
 {
 data.start = GameTime::GetGameTime() - data.length * MINUTE;
 if (data.end <= data.start)
 data.end = data.start + data.length;
 }
 else if (serverwide_evt)
 {
 // if finished world event, then only gm command can stop it
 if (overwrite || data.state != GAMEEVENT_WORLD_FINISHED)
 {
 // reset conditions
 data.nextstart = 0;
 data.state = GAMEEVENT_WORLD_INACTIVE;
 GameEventConditionMap::iterator itr;
 for (itr = data.conditions.begin(); itr != data.conditions.end(); ++itr)
 itr->second.done = 0;
 
 CharacterDatabaseTransaction trans = CharacterDatabase.BeginTransaction();
 CharacterDatabasePreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_DEL_ALL_GAME_EVENT_CONDITION_SAVE);
 stmt->setUInt8(0, uint8(event_id));
 trans->Append(stmt);
 
 stmt = CharacterDatabase.GetPreparedStatement(CHAR_DEL_GAME_EVENT_SAVE);
 stmt->setUInt8(0, uint8(event_id));
 trans->Append(stmt);
 
 CharacterDatabase.CommitTransaction(trans);
 }
 }
}
 
void GameEventMgr::LoadFromDB()
{
 {
 uint32 oldMSTime = getMSTime();
 // 0 1 2 3 4 5 6 7 8 9
 QueryResult result = WorldDatabase.Query("SELECT eventEntry, UNIX_TIMESTAMP(start_time), UNIX_TIMESTAMP(end_time), occurence, length, holiday, holidayStage, description, world_event, announce FROM game_event");
 if (!result)
 {
 mGameEvent.clear();
 TC_LOG_INFO("server.loading", ">> Loaded 0 game events. DB table `game_event` is empty.");
 return;
 }
 
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 
 uint8 event_id = fields[0].GetUInt8();
 if (event_id == 0)
 {
 TC_LOG_ERROR("sql.sql", "`game_event`: game event entry 0 is reserved and can't be used.");
 continue;
 }
 
 GameEventData& pGameEvent = mGameEvent[event_id];
 uint64 starttime = fields[1].GetUInt64();
 pGameEvent.start = time_t(starttime);
 uint64 endtime = fields[2].GetUInt64();
 pGameEvent.end = time_t(endtime);
 pGameEvent.occurence = fields[3].GetUInt64();
 pGameEvent.length = fields[4].GetUInt64();
 pGameEvent.holiday_id = HolidayIds(fields[5].GetUInt32());
 pGameEvent.holidayStage = fields[6].GetUInt8();
 pGameEvent.description = fields[7].GetString();
 pGameEvent.state = (GameEventState)(fields[8].GetUInt8());
 pGameEvent.announce = fields[9].GetUInt8();
 pGameEvent.nextstart = 0;
 
 ++count;
 
 if (pGameEvent.length == 0 && pGameEvent.state == GAMEEVENT_NORMAL) // length>0 is validity check
 {
 TC_LOG_ERROR("sql.sql", "`game_event`: game event id ({}) is not a world event and has length = 0, thus cannot be used.", event_id);
 continue;
 }
 
 if (pGameEvent.holiday_id != HOLIDAY_NONE)
 {
 if (!sHolidaysStore.LookupEntry(pGameEvent.holiday_id))
 {
 TC_LOG_ERROR("sql.sql", "`game_event`: game event id ({}) contains nonexisting holiday id {}.", event_id, pGameEvent.holiday_id);
 pGameEvent.holiday_id = HOLIDAY_NONE;
 continue;
 }
 if (pGameEvent.holidayStage > MAX_HOLIDAY_DURATIONS)
 {
 TC_LOG_ERROR("sql.sql", "`game_event` game event id ({}) has out of range holidayStage {}.", event_id, pGameEvent.holidayStage);
 pGameEvent.holidayStage = 0;
 continue;
 }
 
 SetHolidayEventTime(pGameEvent);
 }
 
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} game events in {} ms.", count, GetMSTimeDiffToNow(oldMSTime));
 
 }
 
 TC_LOG_INFO("server.loading", "Loading Game Event Saves Data...");
 {
 uint32 oldMSTime = getMSTime();
 
 // 0 1 2
 QueryResult result = CharacterDatabase.Query("SELECT eventEntry, state, next_start FROM game_event_save");
 
 if (!result)
 TC_LOG_INFO("server.loading", ">> Loaded 0 game event saves in game events. DB table `game_event_save` is empty.");
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 
 uint8 event_id = fields[0].GetUInt8();
 
 if (event_id >= mGameEvent.size())
 {
 TC_LOG_ERROR("sql.sql", "`game_event_save`: game event entry ({}) is out of range compared to max event entry in `game_event`.", event_id);
 continue;
 }
 
 if (mGameEvent[event_id].state != GAMEEVENT_NORMAL && mGameEvent[event_id].state != GAMEEVENT_INTERNAL)
 {
 mGameEvent[event_id].state = (GameEventState)(fields[1].GetUInt8());
 mGameEvent[event_id].nextstart = time_t(fields[2].GetUInt32());
 }
 else
 {
 TC_LOG_ERROR("sql.sql", "game_event_save includes event save for non-worldevent id {}.", event_id);
 continue;
 }
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} game event saves in game events in {} ms.", count, GetMSTimeDiffToNow(oldMSTime));
 
 }
 }
 
 TC_LOG_INFO("server.loading", "Loading Game Event Prerequisite Data...");
 {
 uint32 oldMSTime = getMSTime();
 
 // 0 1
 QueryResult result = WorldDatabase.Query("SELECT eventEntry, prerequisite_event FROM game_event_prerequisite");
 if (!result)
 TC_LOG_INFO("server.loading", ">> Loaded 0 game event prerequisites in game events. DB table `game_event_prerequisite` is empty.");
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 
 uint16 event_id = fields[0].GetUInt8();
 
 if (event_id >= mGameEvent.size())
 {
 TC_LOG_ERROR("sql.sql", "`game_event_prerequisite`: game event id ({}) is out of range compared to max event id in `game_event`.", event_id);
 continue;
 }
 
 if (mGameEvent[event_id].state != GAMEEVENT_NORMAL && mGameEvent[event_id].state != GAMEEVENT_INTERNAL)
 {
 uint16 prerequisite_event = fields[1].GetUInt32();
 if (prerequisite_event >= mGameEvent.size())
 {
 TC_LOG_ERROR("sql.sql", "`game_event_prerequisite`: game event prerequisite id ({}) is out of range compared to max event id in `game_event`.", prerequisite_event);
 continue;
 }
 mGameEvent[event_id].prerequisite_events.insert(prerequisite_event);
 }
 else
 {
 TC_LOG_ERROR("sql.sql", "game_event_prerequisiste includes event entry for non-worldevent id {}.", event_id);
 continue;
 }
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} game event prerequisites in game events in {} ms.", count, GetMSTimeDiffToNow(oldMSTime));
 
 }
 }
 
 TC_LOG_INFO("server.loading", "Loading Game Event Creature Data...");
 {
 uint32 oldMSTime = getMSTime();
 
 // 0 1
 QueryResult result = WorldDatabase.Query("SELECT guid, eventEntry FROM game_event_creature");
 
 if (!result)
 TC_LOG_INFO("server.loading", ">> Loaded 0 creatures in game events. DB table `game_event_creature` is empty.");
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 
 ObjectGuid::LowType guid = fields[0].GetUInt64();
 int16 event_id = fields[1].GetInt8();
 
 int32 internal_event_id = mGameEvent.size() + event_id - 1;
 
 CreatureData const* data = sObjectMgr->GetCreatureData(guid);
 if (!data)
 {
 TC_LOG_ERROR("sql.sql", "`game_event_creature` contains creature (GUID: {}) not found in `creature` table.", guid);
 continue;
 }
 
 if (internal_event_id < 0 || internal_event_id >= int32(mGameEventCreatureGuids.size()))
 {
 TC_LOG_ERROR("sql.sql", "`game_event_creature`: game event id ({}) is out of range compared to max event id in `game_event`.", event_id);
 continue;
 }
 
 // Log error for pooled object, but still spawn it
 if (data->poolId)
 TC_LOG_ERROR("sql.sql", "`game_event_creature`: game event id ({}) contains creature ({}) which is part of a pool ({}). This should be spawned in game_event_pool", event_id, guid, data->poolId);
 
 GuidList& crelist = mGameEventCreatureGuids[internal_event_id];
 crelist.push_back(guid);
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} creatures in game events in {} ms.", count, GetMSTimeDiffToNow(oldMSTime));
 
 }
 }
 
 TC_LOG_INFO("server.loading", "Loading Game Event GO Data...");
 {
 uint32 oldMSTime = getMSTime();
 
 // 0 1
 QueryResult result = WorldDatabase.Query("SELECT guid, eventEntry FROM game_event_gameobject");
 
 if (!result)
 TC_LOG_INFO("server.loading", ">> Loaded 0 gameobjects in game events. DB table `game_event_gameobject` is empty.");
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 
 ObjectGuid::LowType guid = fields[0].GetUInt64();
 int16 event_id = fields[1].GetInt8();
 
 int32 internal_event_id = mGameEvent.size() + event_id - 1;
 
 GameObjectData const* data = sObjectMgr->GetGameObjectData(guid);
 if (!data)
 {
 TC_LOG_ERROR("sql.sql", "`game_event_gameobject` contains gameobject (GUID: {}) not found in `gameobject` table.", guid);
 continue;
 }
 
 if (internal_event_id < 0 || internal_event_id >= int32(mGameEventGameobjectGuids.size()))
 {
 TC_LOG_ERROR("sql.sql", "`game_event_gameobject`: game event id ({}) is out of range compared to max event id in `game_event`.", event_id);
 continue;
 }
 
 // Log error for pooled object, but still spawn it
 if (data->poolId)
 TC_LOG_ERROR("sql.sql", "`game_event_gameobject`: game event id ({}) contains game object ({}) which is part of a pool ({}). This should be spawned in game_event_pool", event_id, guid, data->poolId);
 
 GuidList& golist = mGameEventGameobjectGuids[internal_event_id];
 golist.push_back(guid);
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} gameobjects in game events in {} ms.", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 TC_LOG_INFO("server.loading", "Loading Game Event Model/Equipment Change Data...");
 {
 uint32 oldMSTime = getMSTime();
 
 // 0 1 2 3 4
 QueryResult result = WorldDatabase.Query("SELECT creature.guid, creature.id, game_event_model_equip.eventEntry, game_event_model_equip.modelid, game_event_model_equip.equipment_id "
 "FROM creature JOIN game_event_model_equip ON creature.guid = game_event_model_equip.guid");
 
 if (!result)
 TC_LOG_INFO("server.loading", ">> Loaded 0 model/equipment changes in game events. DB table `game_event_model_equip` is empty.");
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 
 ObjectGuid::LowType guid = fields[0].GetUInt64();
 uint32 entry = fields[1].GetUInt32();
 uint16 event_id = fields[2].GetUInt8();
 
 if (event_id >= mGameEventModelEquip.size())
 {
 TC_LOG_ERROR("sql.sql", "`game_event_model_equip`: game event id ({}) is out of range compared to max event id in `game_event`.", event_id);
 continue;
 }
 
 ModelEquipList& equiplist = mGameEventModelEquip[event_id];
 ModelEquip newModelEquipSet;
 newModelEquipSet.modelid = fields[3].GetUInt32();
 newModelEquipSet.equipment_id = fields[4].GetUInt8();
 newModelEquipSet.equipement_id_prev = 0;
 newModelEquipSet.modelid_prev = 0;
 
 if (newModelEquipSet.equipment_id > 0)
 {
 int8 equipId = static_cast<int8>(newModelEquipSet.equipment_id);
 if (!sObjectMgr->GetEquipmentInfo(entry, equipId))
 {
 TC_LOG_ERROR("sql.sql", "Table `game_event_model_equip` contains creature (Guid: {}, entry: {}) with equipment_id {} not found in table `creature_equip_template`. Setting entry to no equipment.",
 guid, entry, newModelEquipSet.equipment_id);
 continue;
 }
 }
 
 equiplist.push_back(std::pair<ObjectGuid::LowType, ModelEquip>(guid, newModelEquipSet));
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} model/equipment changes in game events in {} ms.", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 TC_LOG_INFO("server.loading", "Loading Game Event Quest Data...");
 {
 uint32 oldMSTime = getMSTime();
 
 // 0 1 2
 QueryResult result = WorldDatabase.Query("SELECT id, quest, eventEntry FROM game_event_creature_quest");
 
 if (!result)
 TC_LOG_INFO("server.loading", ">> Loaded 0 quests additions in game events. DB table `game_event_creature_quest` is empty.");
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 
 uint32 id = fields[0].GetUInt32();
 uint32 quest = fields[1].GetUInt32();
 uint16 event_id = fields[2].GetUInt8();
 
 if (event_id >= mGameEventCreatureQuests.size())
 {
 TC_LOG_ERROR("sql.sql", "`game_event_creature_quest`: game event id ({}) is out of range compared to max event id in `game_event`.", event_id);
 continue;
 }
 
 QuestRelList& questlist = mGameEventCreatureQuests[event_id];
 questlist.push_back(QuestRelation(id, quest));
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} quests additions in game events in {} ms.", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 TC_LOG_INFO("server.loading", "Loading Game Event GO Quest Data...");
 {
 uint32 oldMSTime = getMSTime();
 
 // 0 1 2
 QueryResult result = WorldDatabase.Query("SELECT id, quest, eventEntry FROM game_event_gameobject_quest");
 
 if (!result)
 TC_LOG_INFO("server.loading", ">> Loaded 0 go quests additions in game events. DB table `game_event_gameobject_quest` is empty.");
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 
 uint32 id = fields[0].GetUInt32();
 uint32 quest = fields[1].GetUInt32();
 uint16 event_id = fields[2].GetUInt8();
 
 if (event_id >= mGameEventGameObjectQuests.size())
 {
 TC_LOG_ERROR("sql.sql", "`game_event_gameobject_quest`: game event id ({}) is out of range compared to max event id in `game_event`.", event_id);
 continue;
 }
 
 QuestRelList& questlist = mGameEventGameObjectQuests[event_id];
 questlist.push_back(QuestRelation(id, quest));
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} quests additions in game events in {} ms.", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 TC_LOG_INFO("server.loading", "Loading Game Event Quest Condition Data...");
 {
 uint32 oldMSTime = getMSTime();
 
 // 0 1 2 3
 QueryResult result = WorldDatabase.Query("SELECT quest, eventEntry, condition_id, num FROM game_event_quest_condition");
 
 if (!result)
 TC_LOG_INFO("server.loading", ">> Loaded 0 quest event conditions in game events. DB table `game_event_quest_condition` is empty.");
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 
 uint32 quest = fields[0].GetUInt32();
 uint16 event_id = fields[1].GetUInt8();
 uint32 condition = fields[2].GetUInt32();
 float num = fields[3].GetFloat();
 
 if (event_id >= mGameEvent.size())
 {
 TC_LOG_ERROR("sql.sql", "`game_event_quest_condition`: game event id ({}) is out of range compared to max event id in `game_event`.", event_id);
 continue;
 }
 
 mQuestToEventConditions[quest].event_id = event_id;
 mQuestToEventConditions[quest].condition = condition;
 mQuestToEventConditions[quest].num = num;
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} quest event conditions in game events in {} ms.", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 TC_LOG_INFO("server.loading", "Loading Game Event Condition Data...");
 {
 uint32 oldMSTime = getMSTime();
 
 // 0 1 2 3 4
 QueryResult result = WorldDatabase.Query("SELECT eventEntry, condition_id, req_num, max_world_state_field, done_world_state_field FROM game_event_condition");
 
 if (!result)
 TC_LOG_INFO("server.loading", ">> Loaded 0 conditions in game events. DB table `game_event_condition` is empty.");
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 
 uint16 event_id = fields[0].GetUInt8();
 uint32 condition = fields[1].GetUInt32();
 
 if (event_id >= mGameEvent.size())
 {
 TC_LOG_ERROR("sql.sql", "`game_event_condition`: game event id ({}) is out of range compared to max event id in `game_event`.", event_id);
 continue;
 }
 
 mGameEvent[event_id].conditions[condition].reqNum = fields[2].GetFloat();
 mGameEvent[event_id].conditions[condition].done = 0;
 mGameEvent[event_id].conditions[condition].max_world_state = fields[3].GetUInt16();
 mGameEvent[event_id].conditions[condition].done_world_state = fields[4].GetUInt16();
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} conditions in game events in {} ms.", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 TC_LOG_INFO("server.loading", "Loading Game Event Condition Save Data...");
 {
 uint32 oldMSTime = getMSTime();
 
 // 0 1 2
 QueryResult result = CharacterDatabase.Query("SELECT eventEntry, condition_id, done FROM game_event_condition_save");
 
 if (!result)
 TC_LOG_INFO("server.loading", ">> Loaded 0 condition saves in game events. DB table `game_event_condition_save` is empty.");
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 
 uint16 event_id = fields[0].GetUInt8();
 uint32 condition = fields[1].GetUInt32();
 
 if (event_id >= mGameEvent.size())
 {
 TC_LOG_ERROR("sql.sql", "`game_event_condition_save`: game event id ({}) is out of range compared to max event id in `game_event`.", event_id);
 continue;
 }
 
 GameEventConditionMap::iterator itr = mGameEvent[event_id].conditions.find(condition);
 if (itr != mGameEvent[event_id].conditions.end())
 {
 itr->second.done = fields[2].GetFloat();
 }
 else
 {
 TC_LOG_ERROR("sql.sql", "game_event_condition_save contains not present condition event id {} condition id {}.", event_id, condition);
 continue;
 }
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} condition saves in game events in {} ms.", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 TC_LOG_INFO("server.loading", "Loading Game Event NPCflag Data...");
 {
 uint32 oldMSTime = getMSTime();
 
 // 0 1 2
 QueryResult result = WorldDatabase.Query("SELECT guid, eventEntry, npcflag FROM game_event_npcflag");
 
 if (!result)
 TC_LOG_INFO("server.loading", ">> Loaded 0 npcflags in game events. DB table `game_event_npcflag` is empty.");
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 
 ObjectGuid::LowType guid = fields[0].GetUInt64();
 uint16 event_id = fields[1].GetUInt8();
 uint64 npcflag = fields[2].GetUInt64();
 
 if (event_id >= mGameEvent.size())
 {
 TC_LOG_ERROR("sql.sql", "`game_event_npcflag`: game event id ({}) is out of range compared to max event id in `game_event`.", event_id);
 continue;
 }
 
 mGameEventNPCFlags[event_id].push_back(GuidNPCFlagPair(guid, npcflag));
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} npcflags in game events in {} ms.", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 TC_LOG_INFO("server.loading", "Loading Game Event Seasonal Quest Relations...");
 {
 uint32 oldMSTime = getMSTime();
 
 // 0 1
 QueryResult result = WorldDatabase.Query("SELECT questId, eventEntry FROM game_event_seasonal_questrelation");
 
 if (!result)
 TC_LOG_INFO("server.loading", ">> Loaded 0 seasonal quests additions in game events. DB table `game_event_seasonal_questrelation` is empty.");
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 
 uint32 questId = fields[0].GetUInt32();
 uint32 eventEntry = fields[1].GetUInt32(); 
 
 Quest* questTemplate = const_cast<Quest*>(sObjectMgr->GetQuestTemplate(questId));
 if (!questTemplate)
 {
 TC_LOG_ERROR("sql.sql", "`game_event_seasonal_questrelation`: quest id ({}) does not exist in `quest_template`.", questId);
 continue;
 }
 
 if (eventEntry >= mGameEvent.size())
 {
 TC_LOG_ERROR("sql.sql", "`game_event_seasonal_questrelation`: event id ({}) is out of range compared to max event in `game_event`.", eventEntry);
 continue;
 }
 
 questTemplate->SetEventIdForQuest(static_cast<uint16>(eventEntry));
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} quests additions in game events in {} ms.", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 TC_LOG_INFO("server.loading", "Loading Game Event Vendor Additions Data...");
 {
 uint32 oldMSTime = getMSTime();
 
 // 0 1 2 3 4 5 6 7 8 9
 QueryResult result = WorldDatabase.Query("SELECT eventEntry, guid, item, maxcount, incrtime, ExtendedCost, type, BonusListIDs, PlayerConditionId, IgnoreFiltering FROM game_event_npc_vendor ORDER BY guid, slot ASC");
 
 if (!result)
 TC_LOG_INFO("server.loading", ">> Loaded 0 vendor additions in game events. DB table `game_event_npc_vendor` is empty.");
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 
 uint8 event_id = fields[0].GetUInt8();
 ObjectGuid::LowType guid = fields[1].GetUInt64();
 
 if (event_id >= mGameEventVendors.size())
 {
 TC_LOG_ERROR("sql.sql", "`game_event_npc_vendor`: game event id ({}) is out of range compared to max event id in `game_event`.", event_id);
 continue;
 }
 
 // get the event npc flag for checking if the npc will be vendor during the event or not
 uint32 event_npc_flag = 0;
 NPCFlagList& flist = mGameEventNPCFlags[event_id];
 for (NPCFlagList::const_iterator itr = flist.begin(); itr != flist.end(); ++itr)
 {
 if (itr->first == guid)
 {
 event_npc_flag = itr->second;
 break;
 }
 }
 
 uint32 entry = 0;
 if (CreatureData const* data = sObjectMgr->GetCreatureData(guid))
 entry = data->id;
 
 VendorItem vItem;
 vItem.item = fields[2].GetUInt32();
 vItem.maxcount = fields[3].GetUInt32();
 vItem.incrtime = fields[4].GetUInt32();
 vItem.ExtendedCost = fields[5].GetUInt32();
 vItem.Type = fields[6].GetUInt8();
 vItem.PlayerConditionId = fields[8].GetUInt32();
 vItem.IgnoreFiltering = fields[9].GetBool();
 
 for (std::string_view token : Trinity::Tokenize(fields[7].GetStringView(), ' ', false))
 if (Optional<int32> bonusListID = Trinity::StringTo<int32>(token))
 vItem.BonusListIDs.push_back(*bonusListID);
 
 // check validity with event's npcflag
 if (!sObjectMgr->IsVendorItemValid(entry, vItem, nullptr, nullptr, event_npc_flag))
 continue;
 
 NPCVendorMap& vendors = mGameEventVendors[event_id];
 vendors[entry].emplace_back(std::move(vItem));
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} vendor additions in game events in {} ms.", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
 
 TC_LOG_INFO("server.loading", "Loading Game Event Pool Data...");
 {
 uint32 oldMSTime = getMSTime();
 
 // 0 1
 QueryResult result = WorldDatabase.Query("SELECT pool_template.entry, game_event_pool.eventEntry FROM pool_template"
 " JOIN game_event_pool ON pool_template.entry = game_event_pool.pool_entry");
 
 if (!result)
 TC_LOG_INFO("server.loading", ">> Loaded 0 pools for game events. DB table `game_event_pool` is empty.");
 else
 {
 uint32 count = 0;
 do
 {
 Field* fields = result->Fetch();
 
 uint32 entry = fields[0].GetUInt32();
 int16 event_id = fields[1].GetInt8();
 
 int32 internal_event_id = mGameEvent.size() + event_id - 1;
 
 if (internal_event_id < 0 || internal_event_id >= int32(mGameEventPoolIds.size()))
 {
 TC_LOG_ERROR("sql.sql", "`game_event_pool`: game event id ({}) is out of range compared to max event id in `game_event`.", event_id);
 continue;
 }
 
 if (!sPoolMgr->CheckPool(entry))
 {
 TC_LOG_ERROR("sql.sql", "Pool Id ({}) has all creatures or gameobjects with explicit chance sum <> 100 and no equal chance defined. The pool system cannot pick one to spawn.", entry);
 continue;
 }
 
 IdList& poollist = mGameEventPoolIds[internal_event_id];
 poollist.push_back(entry);
 
 ++count;
 }
 while (result->NextRow());
 
 TC_LOG_INFO("server.loading", ">> Loaded {} pools for game events in {} ms.", count, GetMSTimeDiffToNow(oldMSTime));
 }
 }
}
 
uint64 GameEventMgr::GetNPCFlag(Creature* cr)
{
 uint64 mask = 0;
 ObjectGuid::LowType guid = cr->GetSpawnId();
 
 for (ActiveEvents::iterator e_itr = m_ActiveEvents.begin(); e_itr != m_ActiveEvents.end(); ++e_itr)
 {
 for (NPCFlagList::iterator itr = mGameEventNPCFlags[*e_itr].begin();
 itr != mGameEventNPCFlags[*e_itr].end();
 ++ itr)
 if (itr->first == guid)
 mask |= itr->second;
 }
 
 return mask;
}
 
void GameEventMgr::Initialize()
{
 QueryResult result = WorldDatabase.Query("SELECT MAX(eventEntry) FROM game_event");
 if (result)
 {
 Field* fields = result->Fetch();
 
 uint32 maxEventId = fields[0].GetUInt8();
 
 // Id starts with 1 and vector with 0, thus increment
 maxEventId++;
 
 mGameEvent.resize(maxEventId);
 mGameEventCreatureGuids.resize(maxEventId * 2 - 1);
 mGameEventGameobjectGuids.resize(maxEventId * 2 - 1);
 mGameEventCreatureQuests.resize(maxEventId);
 mGameEventGameObjectQuests.resize(maxEventId);
 mGameEventVendors.resize(maxEventId);
 mGameEventPoolIds.resize(maxEventId * 2 - 1);
 mGameEventNPCFlags.resize(maxEventId);
 mGameEventModelEquip.resize(maxEventId);
 }
}
 
uint32 GameEventMgr::StartSystem() // return the next event delay in ms
{
 m_ActiveEvents.clear();
 uint32 delay = Update();
 isSystemInit = true;
 return delay;
}
 
void GameEventMgr::StartArenaSeason()
{
 uint8 season = sWorld->getIntConfig(CONFIG_ARENA_SEASON_ID);
 QueryResult result = WorldDatabase.PQuery("SELECT eventEntry FROM game_event_arena_seasons WHERE season = '{}'", season);
 
 if (!result)
 {
 TC_LOG_ERROR("gameevent", "ArenaSeason ({}) must be an existing Arena Season.", season);
 return;
 }
 
 Field* fields = result->Fetch();
 uint16 eventId = fields[0].GetUInt8();
 
 if (eventId >= mGameEvent.size())
 {
 TC_LOG_ERROR("gameevent", "EventEntry {} for ArenaSeason ({}) does not exist.", eventId, season);
 return;
 }
 
 StartEvent(eventId, true);
 TC_LOG_INFO("gameevent", "Arena Season {} started...", season);
 
}
 
uint32 GameEventMgr::Update() // return the next event delay in ms
{
 time_t currenttime = GameTime::GetGameTime();
 uint32 nextEventDelay = max_ge_check_delay; // 1 day
 uint32 calcDelay;
 std::set<uint16> activate, deactivate;
 for (uint16 itr = 1; itr < mGameEvent.size(); ++itr)
 {
 // must do the activating first, and after that the deactivating
 // so first queue it
 //TC_LOG_ERROR("sql.sql", "Checking event {}", itr);
 if (CheckOneGameEvent(itr))
 {
 // if the world event is in NEXTPHASE state, and the time has passed to finish this event, then do so
 if (mGameEvent[itr].state == GAMEEVENT_WORLD_NEXTPHASE && mGameEvent[itr].nextstart <= currenttime)
 {
 // set this event to finished, null the nextstart time
 mGameEvent[itr].state = GAMEEVENT_WORLD_FINISHED;
 mGameEvent[itr].nextstart = 0;
 // save the state of this gameevent
 SaveWorldEventStateToDB(itr);
 // queue for deactivation
 if (IsActiveEvent(itr))
 deactivate.insert(itr);
 // go to next event, this no longer needs an event update timer
 continue;
 }
 else if (mGameEvent[itr].state == GAMEEVENT_WORLD_CONDITIONS && CheckOneGameEventConditions(itr))
 // changed, save to DB the gameevent state, will be updated in next update cycle
 SaveWorldEventStateToDB(itr);
 
 //TC_LOG_DEBUG("misc", "GameEvent {} is active", itr->first);
 // queue for activation
 if (!IsActiveEvent(itr))
 activate.insert(itr);
 }
 else
 {
 //TC_LOG_DEBUG("misc", "GameEvent {} is not active", itr->first);
 if (IsActiveEvent(itr))
 deactivate.insert(itr);
 else
 {
 if (!isSystemInit)
 {
 int16 event_nid = (-1) * (itr);
 // spawn all negative ones for this event
 GameEventSpawn(event_nid);
 }
 }
 }
 calcDelay = NextCheck(itr);
 if (calcDelay < nextEventDelay)
 nextEventDelay = calcDelay;
 }
 // now activate the queue
 // a now activated event can contain a spawn of a to-be-deactivated one
 // following the activate - deactivate order, deactivating the first event later will leave the spawn in (wont disappear then reappear clientside)
 for (std::set<uint16>::iterator itr = activate.begin(); itr != activate.end(); ++itr)
 // start the event
 // returns true the started event completed
 // in that case, initiate next update in 1 second
 if (StartEvent(*itr))
 nextEventDelay = 0;
 for (std::set<uint16>::iterator itr = deactivate.begin(); itr != deactivate.end(); ++itr)
 StopEvent(*itr);
 TC_LOG_INFO("gameevent", "Next game event check in {} seconds.", nextEventDelay + 1);
 return (nextEventDelay + 1) * IN_MILLISECONDS; // Add 1 second to be sure event has started/stopped at next call
}
 
void GameEventMgr::UnApplyEvent(uint16 event_id)
{
 TC_LOG_INFO("gameevent", "GameEvent {} \"{}\" removed.", event_id, mGameEvent[event_id].description);
 RunSmartAIScripts(event_id, false);
 // un-spawn positive event tagged objects
 GameEventUnspawn(event_id);
 // spawn negative event tagget objects
 int16 event_nid = (-1) * event_id;
 GameEventSpawn(event_nid);
 // restore equipment or model
 ChangeEquipOrModel(event_id, false);
 // Remove quests that are events only to non event npc
 UpdateEventQuests(event_id, false);
 UpdateWorldStates(event_id, false);
 // update npcflags in this event
 UpdateEventNPCFlags(event_id);
 // remove vendor items
 UpdateEventNPCVendor(event_id, false);
}
 
void GameEventMgr::ApplyNewEvent(uint16 event_id)
{
 uint8 announce = mGameEvent[event_id].announce;
 if (announce == 1 || (announce == 2 && sWorld->getBoolConfig(CONFIG_EVENT_ANNOUNCE)))
 sWorld->SendWorldText(LANG_EVENTMESSAGE, mGameEvent[event_id].description.c_str());
 
 TC_LOG_INFO("gameevent", "GameEvent {} \"{}\" started.", event_id, mGameEvent[event_id].description);
 
 // spawn positive event tagget objects
 GameEventSpawn(event_id);
 // un-spawn negative event tagged objects
 int16 event_nid = (-1) * event_id;
 GameEventUnspawn(event_nid);
 // Change equipement or model
 ChangeEquipOrModel(event_id, true);
 // Add quests that are events only to non event npc
 UpdateEventQuests(event_id, true);
 UpdateWorldStates(event_id, true);
 // update npcflags in this event
 UpdateEventNPCFlags(event_id);
 // add vendor items
 UpdateEventNPCVendor(event_id, true);
 
 RunSmartAIScripts(event_id, true);
 
 // check for seasonal quest reset.
 sWorld->ResetEventSeasonalQuests(event_id, GetLastStartTime(event_id));
}
 
void GameEventMgr::UpdateEventNPCFlags(uint16 event_id)
{
 std::unordered_map<uint32, std::unordered_set<ObjectGuid::LowType>> creaturesByMap;
 
 // go through the creatures whose npcflags are changed in the event
 for (NPCFlagList::iterator itr = mGameEventNPCFlags[event_id].begin(); itr != mGameEventNPCFlags[event_id].end(); ++itr)
 // get the creature data from the low guid to get the entry, to be able to find out the whole guid
 if (CreatureData const* data = sObjectMgr->GetCreatureData(itr->first))
 creaturesByMap[data->mapId].insert(itr->first);
 
 for (auto const& p : creaturesByMap)
 {
 sMapMgr->DoForAllMapsWithMapId(p.first, [this, &p](Map* map)
 {
 for (auto& spawnId : p.second)
 {
 auto creatureBounds = map->GetCreatureBySpawnIdStore().equal_range(spawnId);
 for (auto itr = creatureBounds.first; itr != creatureBounds.second; ++itr)
 {
 Creature* creature = itr->second;
 uint64 npcflag = GetNPCFlag(creature);
 if (CreatureTemplate const* creatureTemplate = creature->GetCreatureTemplate())
 npcflag |= creatureTemplate->npcflag;
 
 creature->ReplaceAllNpcFlags(NPCFlags(npcflag & 0xFFFFFFFF));
 creature->ReplaceAllNpcFlags2(NPCFlags2(npcflag >> 32));
 // reset gossip options, since the flag change might have added / removed some
 //cr->ResetGossipOptions();
 }
 }
 });
 }
}
 
void GameEventMgr::UpdateEventNPCVendor(uint16 event_id, bool activate)
{
 for (NPCVendorMap::iterator itr = mGameEventVendors[event_id].begin(); itr != mGameEventVendors[event_id].end(); ++itr)
 {
 for (VendorItem const& vItem : itr->second)
 {
 if (activate)
 sObjectMgr->AddVendorItem(itr->first, vItem, false);
 else
 sObjectMgr->RemoveVendorItem(itr->first, vItem.item, vItem.Type, false);
 }
 }
}
 
void GameEventMgr::GameEventSpawn(int16 event_id)
{
 int32 internal_event_id = mGameEvent.size() + event_id - 1;
 
 if (internal_event_id < 0 || internal_event_id >= int32(mGameEventCreatureGuids.size()))
 {
 TC_LOG_ERROR("gameevent", "GameEventMgr::GameEventSpawn attempted access to out of range mGameEventCreatureGuids element {} (size: {}).",
 internal_event_id, mGameEventCreatureGuids.size());
 return;
 }
 
 for (GuidList::iterator itr = mGameEventCreatureGuids[internal_event_id].begin(); itr != mGameEventCreatureGuids[internal_event_id].end(); ++itr)
 {
 // Add to correct cell
 if (CreatureData const* data = sObjectMgr->GetCreatureData(*itr))
 {
 sObjectMgr->AddCreatureToGrid(data);
 
 // Spawn if necessary (loaded grids only)
 sMapMgr->DoForAllMapsWithMapId(data->mapId, [&itr, data](Map* map)
 {
 map->RemoveRespawnTime(SPAWN_TYPE_CREATURE, *itr);
 // We use spawn coords to spawn
 if (map->IsGridLoaded(data->spawnPoint))
 Creature::CreateCreatureFromDB(*itr, map);
 });
 }
 }
 
 if (internal_event_id >= int32(mGameEventGameobjectGuids.size()))
 {
 TC_LOG_ERROR("gameevent", "GameEventMgr::GameEventSpawn attempted access to out of range mGameEventGameobjectGuids element {} (size: {}).",
 internal_event_id, mGameEventGameobjectGuids.size());
 return;
 }
 
 for (GuidList::iterator itr = mGameEventGameobjectGuids[internal_event_id].begin(); itr != mGameEventGameobjectGuids[internal_event_id].end(); ++itr)
 {
 // Add to correct cell
 if (GameObjectData const* data = sObjectMgr->GetGameObjectData(*itr))
 {
 sObjectMgr->AddGameobjectToGrid(data);
 // Spawn if necessary (loaded grids only)
 // this base map checked as non-instanced and then only existed
 sMapMgr->DoForAllMapsWithMapId(data->mapId, [&itr, data](Map* map)
 {
 map->RemoveRespawnTime(SPAWN_TYPE_GAMEOBJECT, *itr);
 // We use current coords to unspawn, not spawn coords since creature can have changed grid
 if (map->IsGridLoaded(data->spawnPoint))
 {
 if (GameObject* go = GameObject::CreateGameObjectFromDB(*itr, map, false))
 {
 if (go->isSpawnedByDefault())
 {
 if (!map->AddToMap(go))
 delete go;
 }
 }
 }
 });
 }
 }
 
 if (internal_event_id >= int32(mGameEventPoolIds.size()))
 {
 TC_LOG_ERROR("gameevent", "GameEventMgr::GameEventSpawn attempted access to out of range mGameEventPoolIds element {} (size: {}).",
 internal_event_id, mGameEventPoolIds.size());
 return;
 }
 
 for (IdList::iterator itr = mGameEventPoolIds[internal_event_id].begin(); itr != mGameEventPoolIds[internal_event_id].end(); ++itr)
 {
 if (PoolTemplateData const* poolTemplate = sPoolMgr->GetPoolTemplate(*itr))
 {
 sMapMgr->DoForAllMapsWithMapId(poolTemplate->MapId, [&itr](Map* map)
 {
 sPoolMgr->SpawnPool(map->GetPoolData(), *itr);
 });
 }
 }
}
 
void GameEventMgr::GameEventUnspawn(int16 event_id)
{
 int32 internal_event_id = mGameEvent.size() + event_id - 1;
 
 if (internal_event_id < 0 || internal_event_id >= int32(mGameEventCreatureGuids.size()))
 {
 TC_LOG_ERROR("gameevent", "GameEventMgr::GameEventUnspawn attempted access to out of range mGameEventCreatureGuids element {} (size: {}).",
 internal_event_id, mGameEventCreatureGuids.size());
 return;
 }
 
 for (GuidList::iterator itr = mGameEventCreatureGuids[internal_event_id].begin(); itr != mGameEventCreatureGuids[internal_event_id].end(); ++itr)
 {
 // check if it's needed by another event, if so, don't remove
 if (event_id > 0 && hasCreatureActiveEventExcept(*itr, event_id))
 continue;
 // Remove the creature from grid
 if (CreatureData const* data = sObjectMgr->GetCreatureData(*itr))
 {
 sObjectMgr->RemoveCreatureFromGrid(data);
 
 sMapMgr->DoForAllMapsWithMapId(data->mapId, [&itr](Map* map)
 {
 map->RemoveRespawnTime(SPAWN_TYPE_CREATURE, *itr);
 auto creatureBounds = map->GetCreatureBySpawnIdStore().equal_range(*itr);
 for (auto itr2 = creatureBounds.first; itr2 != creatureBounds.second;)
 {
 Creature* creature = itr2->second;
 ++itr2;
 creature->AddObjectToRemoveList();
 }
 });
 }
 }
 
 if (internal_event_id < 0 || internal_event_id >= int32(mGameEventGameobjectGuids.size()))
 {
 TC_LOG_ERROR("gameevent", "GameEventMgr::GameEventUnspawn attempted access to out of range mGameEventGameobjectGuids element {} (size: {}).",
 internal_event_id, mGameEventGameobjectGuids.size());
 return;
 }
 
 for (GuidList::iterator itr = mGameEventGameobjectGuids[internal_event_id].begin(); itr != mGameEventGameobjectGuids[internal_event_id].end(); ++itr)
 {
 // check if it's needed by another event, if so, don't remove
 if (event_id >0 && hasGameObjectActiveEventExcept(*itr, event_id))
 continue;
 // Remove the gameobject from grid
 if (GameObjectData const* data = sObjectMgr->GetGameObjectData(*itr))
 {
 sObjectMgr->RemoveGameobjectFromGrid(data);
 
 sMapMgr->DoForAllMapsWithMapId(data->mapId, [&itr](Map* map)
 {
 map->RemoveRespawnTime(SPAWN_TYPE_GAMEOBJECT, *itr);
 auto gameobjectBounds = map->GetGameObjectBySpawnIdStore().equal_range(*itr);
 for (auto itr2 = gameobjectBounds.first; itr2 != gameobjectBounds.second;)
 {
 GameObject* go = itr2->second;
 ++itr2;
 go->AddObjectToRemoveList();
 }
 });
 }
 }
 
 if (internal_event_id < 0 || internal_event_id >= int32(mGameEventPoolIds.size()))
 {
 TC_LOG_ERROR("gameevent", "GameEventMgr::GameEventUnspawn attempted access to out of range mGameEventPoolIds element {} (size: {}).", internal_event_id, mGameEventPoolIds.size());
 return;
 }
 
 for (IdList::iterator itr = mGameEventPoolIds[internal_event_id].begin(); itr != mGameEventPoolIds[internal_event_id].end(); ++itr)
 {
 if (PoolTemplateData const* poolTemplate = sPoolMgr->GetPoolTemplate(*itr))
 {
 sMapMgr->DoForAllMapsWithMapId(poolTemplate->MapId, [&itr](Map* map)
 {
 sPoolMgr->DespawnPool(map->GetPoolData(), *itr, true);
 });
 }
 }
}
 
void GameEventMgr::ChangeEquipOrModel(int16 event_id, bool activate)
{
 for (ModelEquipList::iterator itr = mGameEventModelEquip[event_id].begin(); itr != mGameEventModelEquip[event_id].end(); ++itr)
 {
 // Remove the creature from grid
 CreatureData const* data = sObjectMgr->GetCreatureData(itr->first);
 if (!data)
 continue;
 
 // Update if spawned
 sMapMgr->DoForAllMapsWithMapId(data->mapId, [&itr, activate](Map* map)
 {
 auto creatureBounds = map->GetCreatureBySpawnIdStore().equal_range(itr->first);
 for (auto itr2 = creatureBounds.first; itr2 != creatureBounds.second; ++itr2)
 {
 Creature* creature = itr2->second;
 if (activate)
 {
 itr->second.equipement_id_prev = creature->GetCurrentEquipmentId();
 itr->second.modelid_prev = creature->GetDisplayId();
 creature->LoadEquipment(itr->second.equipment_id, true);
 if (itr->second.modelid > 0 && itr->second.modelid_prev != itr->second.modelid && sObjectMgr->GetCreatureModelInfo(itr->second.modelid))
 creature->SetDisplayId(itr->second.modelid, true);
 }
 else
 {
 creature->LoadEquipment(itr->second.equipement_id_prev, true);
 if (itr->second.modelid_prev > 0 && itr->second.modelid_prev != itr->second.modelid && sObjectMgr->GetCreatureModelInfo(itr->second.modelid_prev))
 creature->SetDisplayId(itr->second.modelid_prev, true);
 }
 }
 });
 
 // now last step: put in data
 CreatureData& data2 = sObjectMgr->NewOrExistCreatureData(itr->first);
 if (activate)
 {
 itr->second.modelid_prev = data2.display ? data2.display->CreatureDisplayID : 0;
 itr->second.equipement_id_prev = data2.equipmentId;
 if (itr->second.modelid)
 data2.display.emplace(itr->second.modelid, DEFAULT_PLAYER_DISPLAY_SCALE, 1.0f);
 else
 data2.display.reset();
 data2.equipmentId = itr->second.equipment_id;
 }
 else
 {
 if (itr->second.modelid_prev)
 data2.display.emplace(itr->second.modelid_prev, DEFAULT_PLAYER_DISPLAY_SCALE, 1.0f);
 else
 data2.display.reset();
 data2.equipmentId = itr->second.equipement_id_prev;
 }
 }
}
 
bool GameEventMgr::hasCreatureQuestActiveEventExcept(uint32 quest_id, uint16 event_id)
{
 for (ActiveEvents::iterator e_itr = m_ActiveEvents.begin(); e_itr != m_ActiveEvents.end(); ++e_itr)
 {
 if ((*e_itr) != event_id)
 for (QuestRelList::iterator itr = mGameEventCreatureQuests[*e_itr].begin();
 itr != mGameEventCreatureQuests[*e_itr].end();
 ++ itr)
 if (itr->second == quest_id)
 return true;
 }
 return false;
}
 
bool GameEventMgr::hasGameObjectQuestActiveEventExcept(uint32 quest_id, uint16 event_id)
{
 for (ActiveEvents::iterator e_itr = m_ActiveEvents.begin(); e_itr != m_ActiveEvents.end(); ++e_itr)
 {
 if ((*e_itr) != event_id)
 for (QuestRelList::iterator itr = mGameEventGameObjectQuests[*e_itr].begin();
 itr != mGameEventGameObjectQuests[*e_itr].end();
 ++ itr)
 if (itr->second == quest_id)
 return true;
 }
 return false;
}
bool GameEventMgr::hasCreatureActiveEventExcept(ObjectGuid::LowType creature_id, uint16 event_id)
{
 for (ActiveEvents::iterator e_itr = m_ActiveEvents.begin(); e_itr != m_ActiveEvents.end(); ++e_itr)
 {
 if ((*e_itr) != event_id)
 {
 int32 internal_event_id = mGameEvent.size() + (*e_itr) - 1;
 for (GuidList::iterator itr = mGameEventCreatureGuids[internal_event_id].begin();
 itr != mGameEventCreatureGuids[internal_event_id].end();
 ++ itr)
 if (*itr == creature_id)
 return true;
 }
 }
 return false;
}
bool GameEventMgr::hasGameObjectActiveEventExcept(ObjectGuid::LowType go_id, uint16 event_id)
{
 for (ActiveEvents::iterator e_itr = m_ActiveEvents.begin(); e_itr != m_ActiveEvents.end(); ++e_itr)
 {
 if ((*e_itr) != event_id)
 {
 int32 internal_event_id = mGameEvent.size() + (*e_itr) - 1;
 for (GuidList::iterator itr = mGameEventGameobjectGuids[internal_event_id].begin();
 itr != mGameEventGameobjectGuids[internal_event_id].end();
 ++ itr)
 if (*itr == go_id)
 return true;
 }
 }
 return false;
}
 
void GameEventMgr::UpdateEventQuests(uint16 event_id, bool activate)
{
 QuestRelList::iterator itr;
 for (itr = mGameEventCreatureQuests[event_id].begin(); itr != mGameEventCreatureQuests[event_id].end(); ++itr)
 {
 QuestRelations* CreatureQuestMap = sObjectMgr->GetCreatureQuestRelationMapHACK();
 if (activate) // Add the pair(id, quest) to the multimap
 CreatureQuestMap->insert(QuestRelations::value_type(itr->first, itr->second));
 else
 {
 if (!hasCreatureQuestActiveEventExcept(itr->second, event_id))
 {
 // Remove the pair(id, quest) from the multimap
 QuestRelations::iterator qitr = CreatureQuestMap->find(itr->first);
 if (qitr == CreatureQuestMap->end())
 continue;
 QuestRelations::iterator lastElement = CreatureQuestMap->upper_bound(itr->first);
 for (; qitr != lastElement; ++qitr)
 {
 if (qitr->second == itr->second)
 {
 CreatureQuestMap->erase(qitr); // iterator is now no more valid
 break; // but we can exit loop since the element is found
 }
 }
 }
 }
 }
 for (itr = mGameEventGameObjectQuests[event_id].begin(); itr != mGameEventGameObjectQuests[event_id].end(); ++itr)
 {
 QuestRelations* GameObjectQuestMap = sObjectMgr->GetGOQuestRelationMapHACK();
 if (activate) // Add the pair(id, quest) to the multimap
 GameObjectQuestMap->insert(QuestRelations::value_type(itr->first, itr->second));
 else
 {
 if (!hasGameObjectQuestActiveEventExcept(itr->second, event_id))
 {
 // Remove the pair(id, quest) from the multimap
 QuestRelations::iterator qitr = GameObjectQuestMap->find(itr->first);
 if (qitr == GameObjectQuestMap->end())
 continue;
 QuestRelations::iterator lastElement = GameObjectQuestMap->upper_bound(itr->first);
 for (; qitr != lastElement; ++qitr)
 {
 if (qitr->second == itr->second)
 {
 GameObjectQuestMap->erase(qitr); // iterator is now no more valid
 break; // but we can exit loop since the element is found
 }
 }
 }
 }
 }
}
 
void GameEventMgr::UpdateWorldStates(uint16 event_id, bool Activate)
{
 GameEventData const& event = mGameEvent[event_id];
 if (event.holiday_id != HOLIDAY_NONE)
 if (BattlemasterListEntry const* bl = sBattlemasterListStore.LookupEntry(BattlegroundMgr::WeekendHolidayIdToBGType(event.holiday_id)))
 if (bl->HolidayWorldState)
 sWorldStateMgr->SetValue(bl->HolidayWorldState, Activate ? 1 : 0, false, nullptr);
}
 
GameEventMgr::GameEventMgr() : isSystemInit(false)
{
}
 
GameEventMgr::~GameEventMgr()
{
}
 
void GameEventMgr::HandleQuestComplete(uint32 quest_id)
{
 // translate the quest to event and condition
 QuestIdToEventConditionMap::iterator itr = mQuestToEventConditions.find(quest_id);
 // quest is registered
 if (itr != mQuestToEventConditions.end())
 {
 uint16 event_id = itr->second.event_id;
 uint32 condition = itr->second.condition;
 float num = itr->second.num;
 
 // the event is not active, so return, don't increase condition finishes
 if (!IsActiveEvent(event_id))
 return;
 // not in correct phase, return
 if (mGameEvent[event_id].state != GAMEEVENT_WORLD_CONDITIONS)
 return;
 GameEventConditionMap::iterator citr = mGameEvent[event_id].conditions.find(condition);
 // condition is registered
 if (citr != mGameEvent[event_id].conditions.end())
 {
 // increase the done count, only if less then the req
 if (citr->second.done < citr->second.reqNum)
 {
 citr->second.done += num;
 // check max limit
 if (citr->second.done > citr->second.reqNum)
 citr->second.done = citr->second.reqNum;
 // save the change to db
 CharacterDatabaseTransaction trans = CharacterDatabase.BeginTransaction();
 
 CharacterDatabasePreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_DEL_GAME_EVENT_CONDITION_SAVE);
 stmt->setUInt8(0, uint8(event_id));
 stmt->setUInt32(1, condition);
 trans->Append(stmt);
 
 stmt = CharacterDatabase.GetPreparedStatement(CHAR_INS_GAME_EVENT_CONDITION_SAVE);
 stmt->setUInt8(0, uint8(event_id));
 stmt->setUInt32(1, condition);
 stmt->setFloat(2, citr->second.done);
 trans->Append(stmt);
 CharacterDatabase.CommitTransaction(trans);
 // check if all conditions are met, if so, update the event state
 if (CheckOneGameEventConditions(event_id))
 {
 // changed, save to DB the gameevent state
 SaveWorldEventStateToDB(event_id);
 // force update events to set timer
 sWorld->ForceGameEventUpdate();
 }
 }
 }
 }
}
 
bool GameEventMgr::CheckOneGameEventConditions(uint16 event_id)
{
 for (GameEventConditionMap::const_iterator itr = mGameEvent[event_id].conditions.begin(); itr != mGameEvent[event_id].conditions.end(); ++itr)
 if (itr->second.done < itr->second.reqNum)
 // return false if a condition doesn't match
 return false;
 // set the phase
 mGameEvent[event_id].state = GAMEEVENT_WORLD_NEXTPHASE;
 // set the followup events' start time
 if (!mGameEvent[event_id].nextstart)
 {
 time_t currenttime = GameTime::GetGameTime();
 mGameEvent[event_id].nextstart = currenttime + mGameEvent[event_id].length * 60;
 }
 return true;
}
 
void GameEventMgr::SaveWorldEventStateToDB(uint16 event_id)
{
 CharacterDatabaseTransaction trans = CharacterDatabase.BeginTransaction();
 
 CharacterDatabasePreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_DEL_GAME_EVENT_SAVE);
 stmt->setUInt8(0, uint8(event_id));
 trans->Append(stmt);
 
 stmt = CharacterDatabase.GetPreparedStatement(CHAR_INS_GAME_EVENT_SAVE);
 stmt->setUInt8(0, uint8(event_id));
 stmt->setUInt8(1, mGameEvent[event_id].state);
 stmt->setInt64(2, mGameEvent[event_id].nextstart ? mGameEvent[event_id].nextstart : SI64LIT(0));
 trans->Append(stmt);
 CharacterDatabase.CommitTransaction(trans);
}
 
void GameEventMgr::SendWorldStateUpdate(Player* player, uint16 event_id)
{
 GameEventConditionMap::const_iterator itr;
 for (itr = mGameEvent[event_id].conditions.begin(); itr !=mGameEvent[event_id].conditions.end(); ++itr)
 {
 if (itr->second.done_world_state)
 player->SendUpdateWorldState(itr->second.done_world_state, (uint32)(itr->second.done));
 if (itr->second.max_world_state)
 player->SendUpdateWorldState(itr->second.max_world_state, (uint32)(itr->second.reqNum));
 }
}
 
class GameEventAIHookWorker
{
public:
 GameEventAIHookWorker(uint16 eventId, bool activate) : _eventId(eventId), _activate(activate) { }
 
 void Visit(std::unordered_map<ObjectGuid, Creature*>& creatureMap)
 {
 for (auto const& p : creatureMap)
 if (p.second->IsInWorld() && p.second->IsAIEnabled())
 p.second->AI()->OnGameEvent(_activate, _eventId);
 }
 
 void Visit(std::unordered_map<ObjectGuid, GameObject*>& gameObjectMap)
 {
 for (auto const& p : gameObjectMap)
 if (p.second->IsInWorld())
 p.second->AI()->OnGameEvent(_activate, _eventId);
 }
 
 template<class T>
 void Visit(std::unordered_map<ObjectGuid, T*>&) { }
 
private:
 uint16 _eventId;
 bool _activate;
};
 
void GameEventMgr::RunSmartAIScripts(uint16 event_id, bool activate)
{
 sMapMgr->DoForAllMaps([event_id, activate](Map* map)
 {
 GameEventAIHookWorker worker(event_id, activate);
 TypeContainerVisitor<GameEventAIHookWorker, MapStoredObjectTypesContainer> visitor(worker);
 visitor.Visit(map->GetObjectsStore());
 });
}
 
void GameEventMgr::SetHolidayEventTime(GameEventData& event)
{
 if (!event.holidayStage) // Ignore holiday
 return;
 
 HolidaysEntry const* holiday = sHolidaysStore.LookupEntry(event.holiday_id);
 if (!holiday->Date[0] || !holiday->Duration[0]) // Invalid definitions
 {
 TC_LOG_ERROR("sql.sql", "Missing date or duration for holiday {}.", event.holiday_id);
 return;
 }
 
 uint8 stageIndex = event.holidayStage - 1;
 event.length = holiday->Duration[stageIndex] * HOUR / MINUTE;
 
 time_t stageOffset = 0;
 for (uint8 i = 0; i < stageIndex; ++i)
 stageOffset += holiday->Duration[i] * HOUR;
 
 switch (holiday->CalendarFilterType)
 {
 case -1: // Yearly
 event.occurence = YEAR / MINUTE; // Not all too useful
 break;
 case 0: // Weekly
 event.occurence = WEEK / MINUTE;
 break;
 case 1: // Defined dates only (Darkmoon Faire)
 break;
 case 2: // Only used for looping events (Call to Arms)
 break;
 }
 
 if (holiday->Looping)
 {
 event.occurence = 0;
 for (uint8 i = 0; i < MAX_HOLIDAY_DURATIONS && holiday->Duration[i]; ++i)
 event.occurence += holiday->Duration[i] * HOUR / MINUTE;
 }
 
 bool singleDate = ((holiday->Date[0] >> 24) & 0x1F) == 31; // Events with fixed date within year have - 1
 
 time_t curTime = GameTime::GetGameTime();
 for (uint8 i = 0; i < MAX_HOLIDAY_DATES && holiday->Date[i]; ++i)
 {
 uint32 date = holiday->Date[i];
 
 tm timeInfo;
 if (singleDate)
 {
 localtime_r(&curTime, &timeInfo);
 timeInfo.tm_year -= 1; // First try last year (event active through New Year)
 }
 else
 timeInfo.tm_year = ((date >> 24) & 0x1F) + 100;
 
 timeInfo.tm_mon = (date >> 20) & 0xF;
 timeInfo.tm_mday = ((date >> 14) & 0x3F) + 1;
 timeInfo.tm_hour = (date >> 6) & 0x1F;
 timeInfo.tm_min = date & 0x3F;
 timeInfo.tm_sec = 0;
 timeInfo.tm_wday = 0;
 timeInfo.tm_yday = 0;
 timeInfo.tm_isdst = -1;
 
 // try to get next start time (skip past dates)
 time_t startTime = mktime(&timeInfo);
 if (curTime < startTime + event.length * MINUTE)
 {
 event.start = startTime + stageOffset;
 break;
 }
 else if (singleDate)
 {
 tm tmCopy;
 localtime_r(&curTime, &tmCopy);
 int year = tmCopy.tm_year; // This year
 tmCopy = timeInfo;
 tmCopy.tm_year = year;
 
 event.start = mktime(&tmCopy) + stageOffset;
 break;
 }
 else
 {
 // date is due and not a singleDate event, try with next DBC date (modified by holiday_dates)
 // if none is found we don't modify start date and use the one in game_event
 }
 }
}
 
time_t GameEventMgr::GetLastStartTime(uint16 event_id) const
{
 if (event_id >= mGameEvent.size())
 return 0;
 
 if (mGameEvent[event_id].state != GAMEEVENT_NORMAL)
 return 0;
 
 SystemTimePoint now = GameTime::GetSystemTime();
 SystemTimePoint eventInitialStart = std::chrono::system_clock::from_time_t(mGameEvent[event_id].start);
 Minutes occurence(mGameEvent[event_id].occurence);
 SystemTimePoint::duration durationSinceLastStart = (now - eventInitialStart) % occurence;
 return std::chrono::system_clock::to_time_t(now - durationSinceLastStart);
}
 
bool IsHolidayActive(HolidayIds id)
{
 if (id == HOLIDAY_NONE)
 return false;
 
 GameEventMgr::GameEventDataMap const& events = sGameEventMgr->GetEventMap();
 GameEventMgr::ActiveEvents const& ae = sGameEventMgr->GetActiveEventList();
 
 for (GameEventMgr::ActiveEvents::const_iterator itr = ae.begin(); itr != ae.end(); ++itr)
 if (events[*itr].holiday_id == id)
 return true;
 
 return false;
}
 
bool IsEventActive(uint16 eventId)
{
 GameEventMgr::ActiveEvents const& ae = sGameEventMgr->GetActiveEventList();
 return ae.find(eventId) != ae.end();
}