src/realmd/RealmList.cpp

   1 /*
   2  * Copyright (C) 2005-2009 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 /** \file
  20     \ingroup realmd
  21 */
  22
  23 #include "Common.h"
  24 #include "RealmList.h"
  25 #include "Policies/SingletonImp.h"
  26 #include "Database/DatabaseEnv.h"
  27
  28 INSTANTIATE_SINGLETON_1( RealmList );
  29
  30 extern DatabaseType dbRealmServer;
  31
  32 RealmList::RealmList( ) : m_UpdateInterval(0), m_NextUpdateTime(time(NULL))
  33 {
  34 }
  35
  36 /// Load the realm list from the database
  37 void RealmList::Initialize(uint32 updateInterval)
  38 {
  39     m_UpdateInterval = updateInterval;
  40
  41     ///- Get the content of the realmlist table in the database
  42     UpdateRealms(true);
  43 }
  44
  45 void RealmList::UpdateRealm( uint32 ID, const std::string& name, const std::string& address, uint32 port, uint8 icon, uint8 color, uint8 timezone, AccountTypes allowedSecurityLevel, float popu)
  46 {
  47     ///- Create new if not exist or update existed
  48     Realm& realm = m_realms[name];
  49
  50     realm.m_ID      = ID;
  51     realm.icon      = icon;
  52     realm.color     = color;
  53     realm.timezone  = timezone;
  54     realm.allowedSecurityLevel = allowedSecurityLevel;
  55     realm.populationLevel        = popu;
  56
  57     ///- Append port to IP address.
  58     std::ostringstream ss;
  59     ss << address << ":" << port;
  60     realm.address   = ss.str();
  61 }
  62
  63 void RealmList::UpdateIfNeed()
  64 {
  65     // maybe disabled or updated recently
  66     if(!m_UpdateInterval || m_NextUpdateTime > time(NULL))
  67         return;
  68
  69     m_NextUpdateTime = time(NULL) + m_UpdateInterval;
  70
  71     // Clears Realm list
  72     m_realms.clear();
  73
  74     // Get the content of the realmlist table in the database
  75     UpdateRealms(false);
  76 }
  77
  78 void RealmList::UpdateRealms(bool init)
  79 {
  80     sLog.outDetail("Updating Realm List...");
  81
  82     QueryResult *result = dbRealmServer.Query( "SELECT id, name, address, port, icon, color, timezone, allowedSecurityLevel, population FROM realmlist WHERE color <> 3 ORDER BY name" );
  83
  84     ///- Circle through results and add them to the realm map
  85     if(result)
  86     {
  87         do
  88         {
  89             Field *fields = result->Fetch();
  90
  91             uint8 allowedSecurityLevel = fields[7].GetUInt8();
  92
  93             UpdateRealm(fields[0].GetUInt32(), fields[1].GetCppString(),fields[2].GetCppString(),fields[3].GetUInt32(),fields[4].GetUInt8(), fields[5].GetUInt8(), fields[6].GetUInt8(), (allowedSecurityLevel <= SEC_ADMINISTRATOR ? AccountTypes(allowedSecurityLevel) : SEC_ADMINISTRATOR), fields[8].GetFloat() );
  94             if(init)
  95                 sLog.outString("Added realm \"%s\".", fields[1].GetString());
  96         } while( result->NextRow() );
  97         delete result;
  98     }
  99 }