src/game/GuildMgr.cpp

   1 /*
   2  * Copyright (C) 2005-2013 MaNGOS <http://getmangos.com/>
   3  *
   4  * This program is free software; you can redistribute it and/or modify
   5  * it under the terms of the GNU General Public License as published by
   6  * the Free Software Foundation; either version 2 of the License, or
   7  * (at your option) any later version.
   8  *
   9  * This program is distributed in the hope that it will be useful,
  10  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  * GNU General Public License for more details.
  13  *
  14  * You should have received a copy of the GNU General Public License
  15  * along with this program; if not, write to the Free Software
  16  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  17  */
  18
  19 #include "GuildMgr.h"
  20 #include "Guild.h"
  21 #include "Log.h"
  22 #include "ObjectGuid.h"
  23 #include "Database/DatabaseEnv.h"
  24 #include "Policies/SingletonImp.h"
  25 #include "ProgressBar.h"
  26 #include "World.h"
  27
  28 INSTANTIATE_SINGLETON_1(GuildMgr);
  29
  30 GuildMgr::GuildMgr()
  31 {
  32 }
  33
  34 GuildMgr::~GuildMgr()
  35 {
  36     for (GuildMap::iterator itr = m_GuildMap.begin(); itr != m_GuildMap.end(); ++itr)
  37         delete itr->second;
  38 }
  39
  40 void GuildMgr::AddGuild(Guild* guild)
  41 {
  42     m_GuildMap[guild->GetId()] = guild;
  43 }
  44
  45 void GuildMgr::RemoveGuild(uint32 guildId)
  46 {
  47     m_GuildMap.erase(guildId);
  48 }
  49
  50 void GuildMgr::RemoveGuild(ObjectGuid guildGuid)
  51 {
  52     if (!guildGuid.IsGuild())
  53         return;
  54
  55     RemoveGuild(guildGuid.GetCounter());
  56 }
  57
  58 Guild* GuildMgr::GetGuildById(uint32 guildId) const
  59 {
  60     GuildMap::const_iterator itr = m_GuildMap.find(guildId);
  61     if (itr != m_GuildMap.end())
  62         return itr->second;
  63
  64     return NULL;
  65 }
  66
  67 Guild* GuildMgr::GetGuildByGuid(ObjectGuid guildGuid) const
  68 {
  69     if (!guildGuid.IsGuild())
  70         return NULL;
  71
  72     return GetGuildById(guildGuid.GetCounter());
  73 }
  74
  75 Guild* GuildMgr::GetGuildByName(std::string const& name) const
  76 {
  77     for (GuildMap::const_iterator itr = m_GuildMap.begin(); itr != m_GuildMap.end(); ++itr)
  78         if (itr->second->GetName() == name)
  79             return itr->second;
  80
  81     return NULL;
  82 }
  83
  84 Guild* GuildMgr::GetGuildByLeader(ObjectGuid const& guid) const
  85 {
  86     for (GuildMap::const_iterator itr = m_GuildMap.begin(); itr != m_GuildMap.end(); ++itr)
  87         if (itr->second->GetLeaderGuid() == guid)
  88             return itr->second;
  89
  90     return NULL;
  91 }
  92
  93 std::string GuildMgr::GetGuildNameById(uint32 guildId) const
  94 {
  95     GuildMap::const_iterator itr = m_GuildMap.find(guildId);
  96     if (itr != m_GuildMap.end())
  97         return itr->second->GetName();
  98
  99     return "";
 100 }
 101
 102 std::string GuildMgr::GetGuildNameByGuid(ObjectGuid guildGuid) const
 103 {
 104     if (!guildGuid.IsGuild())
 105         return "";
 106
 107     return GetGuildNameById(guildGuid.GetCounter());
 108 }
 109
 110 void GuildMgr::LoadGuilds()
 111 {
 112     uint32 count = 0;
 113
 114     //                                                    0             1          2          3           4           5           6
 115     QueryResult* result = CharacterDatabase.Query("SELECT guild.guildid,guild.name,leaderguid,EmblemStyle,EmblemColor,BorderStyle,BorderColor,"
 116                           //   7               8    9    10         11        12
 117                           "BackgroundColor,info,motd,createdate,BankMoney,(SELECT COUNT(guild_bank_tab.guildid) FROM guild_bank_tab WHERE guild_bank_tab.guildid = guild.guildid) "
 118                           "FROM guild ORDER BY guildid ASC");
 119
 120     if (!result)
 121     {
 122         BarGoLink bar(1);
 123
 124         bar.step();
 125
 126         sLog.outString();
 127         sLog.outString(">> Loaded %u guild definitions", count);
 128         return;
 129     }
 130
 131     // load guild ranks
 132     //                                                                0       1   2     3      4
 133     QueryResult* guildRanksResult   = CharacterDatabase.Query("SELECT guildid,rid,rname,rights,BankMoneyPerDay FROM guild_rank ORDER BY guildid ASC, rid ASC");
 134
 135     // load guild members
 136     //                                                                0       1                 2    3     4       5                  6
 137     QueryResult* guildMembersResult = CharacterDatabase.Query("SELECT guildid,guild_member.guid,rank,pnote,offnote,BankResetTimeMoney,BankRemMoney,"
 138                                       //   7                 8                9                 10               11                12
 139                                       "BankResetTimeTab0,BankRemSlotsTab0,BankResetTimeTab1,BankRemSlotsTab1,BankResetTimeTab2,BankRemSlotsTab2,"
 140                                       //   13                14               15                16               17                18
 141                                       "BankResetTimeTab3,BankRemSlotsTab3,BankResetTimeTab4,BankRemSlotsTab4,BankResetTimeTab5,BankRemSlotsTab5,"
 142                                       //   19               20                21                22               23                      24
 143                                       "characters.name, characters.level, characters.class, characters.zone, characters.logout_time, characters.account "
 144                                       "FROM guild_member LEFT JOIN characters ON characters.guid = guild_member.guid ORDER BY guildid ASC");
 145
 146     // load guild bank tab rights
 147     //                                                                      0       1     2   3       4
 148     QueryResult* guildBankTabRightsResult = CharacterDatabase.Query("SELECT guildid,TabId,rid,gbright,SlotPerDay FROM guild_bank_right ORDER BY guildid ASC, TabId ASC");
 149
 150     BarGoLink bar(result->GetRowCount());
 151
 152     do
 153     {
 154         // Field *fields = result->Fetch();
 155
 156         bar.step();
 157         ++count;
 158
 159         Guild* newGuild = new Guild;
 160         if (!newGuild->LoadGuildFromDB(result) ||
 161                 !newGuild->LoadRanksFromDB(guildRanksResult) ||
 162                 !newGuild->LoadMembersFromDB(guildMembersResult) ||
 163                 !newGuild->LoadBankRightsFromDB(guildBankTabRightsResult) ||
 164                 !newGuild->CheckGuildStructure()
 165            )
 166         {
 167             newGuild->Disband();
 168             delete newGuild;
 169             continue;
 170         }
 171
 172         newGuild->LoadGuildEventLogFromDB();
 173         newGuild->LoadGuildBankEventLogFromDB();
 174         newGuild->LoadGuildBankFromDB();
 175         AddGuild(newGuild);
 176     }
 177     while (result->NextRow());
 178
 179     delete result;
 180     delete guildRanksResult;
 181     delete guildMembersResult;
 182     delete guildBankTabRightsResult;
 183
 184     // delete unused LogGuid records in guild_eventlog and guild_bank_eventlog table
 185     // you can comment these lines if you don't plan to change CONFIG_UINT32_GUILD_EVENT_LOG_COUNT and CONFIG_UINT32_GUILD_BANK_EVENT_LOG_COUNT
 186     CharacterDatabase.PExecute("DELETE FROM guild_eventlog WHERE LogGuid > '%u'", sWorld.getConfig(CONFIG_UINT32_GUILD_EVENT_LOG_COUNT));
 187     CharacterDatabase.PExecute("DELETE FROM guild_bank_eventlog WHERE LogGuid > '%u'", sWorld.getConfig(CONFIG_UINT32_GUILD_BANK_EVENT_LOG_COUNT));
 188
 189     sLog.outString();
 190     sLog.outString(">> Loaded %u guild definitions", count);
 191 }