From aa86640fdfef00e1394d4ea3a6febf7f3e7b775c Mon Sep 17 00:00:00 2001 From: megamage Date: Mon, 24 Aug 2009 20:23:54 -0500 Subject: [8408] Optimized guild_member loading during startup. Changed rank ids in guild_rank table. First start of mangos will take more time then usually, because of guild_rank change. If you want to speed first start up, execute command: UPDATE guild_rank SET rid = rid - 1; Signed-off-by: Triply --HG-- branch : trunk --- src/game/ObjectMgr.cpp | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'src/game/ObjectMgr.cpp') diff --git a/src/game/ObjectMgr.cpp b/src/game/ObjectMgr.cpp index 5e293c3c960..084c7fe0b8d 100644 --- a/src/game/ObjectMgr.cpp +++ b/src/game/ObjectMgr.cpp @@ -3230,6 +3230,11 @@ void ObjectMgr::LoadGuilds() delete result; + //delete unused LogGuid records in guild_eventlog and guild_bank_eventlog table + //you can comment these lines if you don't plan to change CONFIG_GUILD_EVENT_LOG_COUNT and CONFIG_GUILD_BANK_EVENT_LOG_COUNT + CharacterDatabase.PQuery("DELETE FROM guild_eventlog WHERE LogGuid > '%u'", sWorld.getConfig(CONFIG_GUILD_EVENT_LOG_COUNT)); + CharacterDatabase.PQuery("DELETE FROM guild_bank_eventlog WHERE LogGuid > '%u'", sWorld.getConfig(CONFIG_GUILD_BANK_EVENT_LOG_COUNT)); + sLog.outString(); sLog.outString( ">> Loaded %u guild definitions", count ); } -- cgit v1.2.3