Merge [SD2]

r1313 Implement new class SystemMgr for storage and management of script data.
      Move database load to new class and instead use functions in class to retrieve data from storage.

--HG--
branch : trunk

2 files changed, 303 insertions, 0 deletions

diff --git a/src/bindings/scripts/system/system.cpp b/src/bindings/scripts/system/system.cpp
index ab62e530681..4ed51825262 100644
--- a/src/bindings/scripts/system/system.cpp
+++ b/src/bindings/scripts/system/system.cpp
@@ -19,4 +19,237 @@
  */
 
 #include "precompiled.h"
+#include "system.h"
+#include "ProgressBar.h"
+#include "ObjectMgr.h"
+#include "Database/DatabaseEnv.h"
 
+DatabaseType TScriptDB;
+
+SystemMgr::SystemMgr()
+{
+}
+
+SystemMgr& SystemMgr::Instance()
+{
+    static SystemMgr pSysMgr;
+    return pSysMgr;
+}
+
+void SystemMgr::LoadVersion()
+{
+    //Get Version information
+    QueryResult* pResult = TScriptDB.PQuery("SELECT script_version FROM version LIMIT 1");
+
+    if (pResult)
+    {
+        Field* pFields = pResult->Fetch();
+
+        outstring_log("TSCR: Database version is: %s", pFields[0].GetString());
+        outstring_log("");
+    }
+    else
+    {
+        error_log("TSCR: Missing `version`.`script_version` information.");
+        outstring_log("");
+    }
+}
+
+void SystemMgr::LoadScriptTexts()
+{
+    outstring_log("TSCR: Loading Script Texts...");
+    LoadTrinityStrings(TScriptDB,"script_texts",TEXT_SOURCE_RANGE,1+(TEXT_SOURCE_RANGE*2));
+
+    QueryResult* pResult = TScriptDB.PQuery("SELECT entry, sound, type, language, emote FROM script_texts");
+
+    outstring_log("TSCR: Loading Script Texts additional data...");
+
+    if (pResult)
+    {
+        barGoLink bar(pResult->GetRowCount());
+        uint32 uiCount = 0;
+
+        do
+        {
+            bar.step();
+            Field* pFields = pResult->Fetch();
+            StringTextData pTemp;
+
+            int32 iId           = pFields[0].GetInt32();
+            pTemp.uiSoundId     = pFields[1].GetUInt32();
+            pTemp.uiType        = pFields[2].GetUInt32();
+            pTemp.uiLanguage    = pFields[3].GetUInt32();
+            pTemp.uiEmote       = pFields[4].GetUInt32();
+
+            if (iId >= 0)
+            {
+                error_db_log("TSCR: Entry %i in table `script_texts` is not a negative value.", iId);
+                continue;
+            }
+
+            if (iId > TEXT_SOURCE_RANGE || iId <= TEXT_SOURCE_RANGE*2)
+            {
+                error_db_log("TSCR: Entry %i in table `script_texts` is out of accepted entry range for table.", iId);
+                continue;
+            }
+
+            if (pTemp.uiSoundId)
+            {
+                if (!GetSoundEntriesStore()->LookupEntry(pTemp.uiSoundId))
+                    error_db_log("TSCR: Entry %i in table `script_texts` has soundId %u but sound does not exist.", iId, pTemp.uiSoundId);
+            }
+
+            if (!GetLanguageDescByID(pTemp.uiLanguage))
+                error_db_log("TSCR: Entry %i in table `script_texts` using Language %u but Language does not exist.", iId, pTemp.uiLanguage);
+
+            if (pTemp.uiType > CHAT_TYPE_ZONE_YELL)
+                error_db_log("TSCR: Entry %i in table `script_texts` has Type %u but this Chat Type does not exist.", iId, pTemp.uiType);
+
+            m_mTextDataMap[iId] = pTemp;
+            ++uiCount;
+        } while (pResult->NextRow());
+
+        outstring_log("");
+        outstring_log(">> Loaded %u additional Script Texts data.", uiCount);
+    }
+    else
+    {
+        barGoLink bar(1);
+        bar.step();
+        outstring_log("");
+        outstring_log(">> Loaded 0 additional Script Texts data. DB table `script_texts` is empty.");
+    }
+}
+
+void SystemMgr::LoadScriptTextsCustom()
+{
+    outstring_log("TSCR: Loading Custom Texts...");
+    LoadTrinityStrings(TScriptDB,"custom_texts",TEXT_SOURCE_RANGE*2,1+(TEXT_SOURCE_RANGE*3));
+
+    QueryResult* pResult = TScriptDB.PQuery("SELECT entry, sound, type, language, emote FROM custom_texts");
+
+    outstring_log("TSCR: Loading Custom Texts additional data...");
+
+    if (pResult)
+    {
+        barGoLink bar(pResult->GetRowCount());
+        uint32 uiCount = 0;
+
+        do
+        {
+            bar.step();
+            Field* pFields = pResult->Fetch();
+            StringTextData pTemp;
+
+            int32 iId              = pFields[0].GetInt32();
+            pTemp.uiSoundId        = pFields[1].GetUInt32();
+            pTemp.uiType           = pFields[2].GetUInt32();
+            pTemp.uiLanguage       = pFields[3].GetUInt32();
+            pTemp.uiEmote          = pFields[4].GetUInt32();
+
+            if (iId >= 0)
+            {
+                error_db_log("TSCR: Entry %i in table `custom_texts` is not a negative value.", iId);
+                continue;
+            }
+
+            if (iId > TEXT_SOURCE_RANGE*2 || iId <= TEXT_SOURCE_RANGE*3)
+            {
+                error_db_log("TSCR: Entry %i in table `custom_texts` is out of accepted entry range for table.", iId);
+                continue;
+            }
+
+            if (pTemp.uiSoundId)
+            {
+                if (!GetSoundEntriesStore()->LookupEntry(pTemp.uiSoundId))
+                    error_db_log("TSCR: Entry %i in table `custom_texts` has soundId %u but sound does not exist.", iId, pTemp.uiSoundId);
+            }
+
+            if (!GetLanguageDescByID(pTemp.uiLanguage))
+                error_db_log("TSCR: Entry %i in table `custom_texts` using Language %u but Language does not exist.", iId, pTemp.uiLanguage);
+
+            if (pTemp.uiType > CHAT_TYPE_ZONE_YELL)
+                error_db_log("TSCR: Entry %i in table `custom_texts` has Type %u but this Chat Type does not exist.", iId, pTemp.uiType);
+
+            m_mTextDataMap[iId] = pTemp;
+            ++uiCount;
+        } while (pResult->NextRow());
+
+        outstring_log("");
+        outstring_log(">> Loaded %u additional Custom Texts data.", uiCount);
+    }
+    else
+    {
+        barGoLink bar(1);
+        bar.step();
+        outstring_log("");
+        outstring_log(">> Loaded 0 additional Custom Texts data. DB table `custom_texts` is empty.");
+    }
+}
+
+void SystemMgr::LoadScriptWaypoints()
+{
+    // Drop Existing Waypoint list
+    m_mPointMoveMap.clear();
+
+    uint64 uiCreatureCount = 0;
+
+    // Load Waypoints
+    QueryResult* pResult = TScriptDB.PQuery("SELECT COUNT(entry) FROM script_waypoint GROUP BY entry");
+    if (pResult)
+    {
+        uiCreatureCount = pResult->GetRowCount();
+        delete pResult;
+    }
+
+    outstring_log("TSCR: Loading Script Waypoints for %u creature(s)...", uiCreatureCount);
+
+    pResult = TScriptDB.PQuery("SELECT entry, pointid, location_x, location_y, location_z, waittime FROM script_waypoint ORDER BY pointid");
+
+    if (pResult)
+    {
+        barGoLink bar(pResult->GetRowCount());
+        uint32 uiNodeCount = 0;
+
+        do
+        {
+            bar.step();
+            Field* pFields = pResult->Fetch();
+            ScriptPointMove pTemp;
+
+            pTemp.uiCreatureEntry   = pFields[0].GetUInt32();
+            uint32 uiEntry          = pTemp.uiCreatureEntry;
+            pTemp.uiPointId         = pFields[1].GetUInt32();
+            pTemp.fX                = pFields[2].GetFloat();
+            pTemp.fY                = pFields[3].GetFloat();
+            pTemp.fZ                = pFields[4].GetFloat();
+            pTemp.uiWaitTime        = pFields[5].GetUInt32();
+
+            CreatureInfo const* pCInfo = GetCreatureTemplateStore(pTemp.uiCreatureEntry);
+
+            if (!pCInfo)
+            {
+                error_db_log("TSCR: DB table script_waypoint has waypoint for non-existant creature entry %u", pTemp.uiCreatureEntry);
+                continue;
+            }
+
+            if (!pCInfo->ScriptID)
+                error_db_log("TSCR: DB table script_waypoint has waypoint for creature entry %u, but creature does not have ScriptName defined and then useless.", pTemp.uiCreatureEntry);
+
+            m_mPointMoveMap[uiEntry].push_back(pTemp);
+            ++uiNodeCount;
+        } while (pResult->NextRow());
+
+        delete pResult;
+
+        outstring_log("");
+        outstring_log(">> Loaded %u Script Waypoint nodes.", uiNodeCount);
+    }
+    else
+    {
+        barGoLink bar(1);
+        bar.step();
+        outstring_log("");
+        outstring_log(">> Loaded 0 Script Waypoints. DB table `script_waypoint` is empty.");
+    }
+}
diff --git a/src/bindings/scripts/system/system.h b/src/bindings/scripts/system/system.h
index 886f31355a9..a9d35b6f3f0 100644
--- a/src/bindings/scripts/system/system.h
+++ b/src/bindings/scripts/system/system.h
@@ -5,4 +5,74 @@
 #ifndef SC_SYSTEM_H
 #define SC_SYSTEM_H
 
+extern DatabaseType TScriptDB;
+
+#define TEXT_SOURCE_RANGE -1000000                          //the amount of entries each text source has available
+
+struct ScriptPointMove
+{
+    uint32 uiCreatureEntry;
+    uint32 uiPointId;
+    float  fX;
+    float  fY;
+    float  fZ;
+    uint32 uiWaitTime;
+};
+
+struct StringTextData
+{
+    uint32 uiSoundId;
+    uint8  uiType;
+    uint32 uiLanguage;
+    uint32 uiEmote;
+};
+
+#define pSystemMgr SystemMgr::Instance()
+
+class SystemMgr
+{
+    public:
+        SystemMgr();
+        ~SystemMgr() {}
+
+        static SystemMgr& Instance();
+
+        //Maps and lists
+        typedef UNORDERED_MAP<int32, StringTextData> TextDataMap;
+        typedef UNORDERED_MAP<uint32, std::vector<ScriptPointMove> > PointMoveMap;
+
+        //Database
+        void LoadVersion();
+        void LoadScriptTexts();
+        void LoadScriptTextsCustom();
+        void LoadScriptWaypoints();
+
+        //Retrive from storage
+        StringTextData const* GetTextData(int32 uiTextId) const
+        {
+            TextDataMap::const_iterator itr = m_mTextDataMap.find(uiTextId);
+
+            if (itr == m_mTextDataMap.end())
+                return NULL;
+
+            return &itr->second;
+        }
+
+        std::vector<ScriptPointMove> const &GetPointMoveList(uint32 uiCreatureEntry) const
+        {
+            static std::vector<ScriptPointMove> vEmpty;
+
+            PointMoveMap::const_iterator itr = m_mPointMoveMap.find(uiCreatureEntry);
+
+            if (itr == m_mPointMoveMap.end())
+                return vEmpty;
+
+            return itr->second;
+        }
+
+    protected:
+        TextDataMap     m_mTextDataMap;                     //additional data for text strings
+        PointMoveMap    m_mPointMoveMap;                    //coordinates for waypoints
+};
+
 #endif