NpcDatabase.h

#pragma once
#include "ic/ParaDatabase.h"
#include <vector>
namespace ParaEngine
{
    using namespace std;
    struct CNpcDbItem
    {
        enum UPDATE_FIELDS
        {
            POSITION_FACING     = 0x1<<0,
            APPEARANCE_ATTRIBUTES   = 0x1<<1,
            MENTAL_STATE_0      = 0x1<<2,
            MENTAL_STATE_1      = 0x1<<3,
            MENTAL_STATE_2      = 0x1<<4,
            MENTAL_STATE_3      = 0x1<<5,
            RPG_ATTRIBUTES      = 0x1<<6,
            DND_ATTRIBUTES      = 0x1<<7,
            ALL_ATTRIBUTES      = 0xffffffff
        };
        
        // Biped attributes
        string m_sName;
        string m_sAssetName;
        bool m_bIsGlobal;
        bool m_bSnapToTerrain;
        float m_fRadius;
        float m_fFacing;
        float m_fScaling;
        Vector3 m_vPos;

        // RPG attributes
        int m_nID;

        int m_nCharacterType;

        DWORD m_MentalState[4];

        // DnD attributes
        float m_fLifePoint;
        float m_fAge;
        float m_fHeight;
        float m_fWeight;
        int m_nOccupation;
        int m_nRaceSex;
        float m_fStrength;
        float m_fDexterity;
        float m_fIntelligence;
        float m_fBaseDefense;
        float m_fDefense, m_fDefenseflat, m_fDefenseMental;
        float m_fBaseAttack;
        float m_fAttackMelee, m_fAttackRanged, m_fAttackMental;
        float m_fMaxLifeLoad;
        int m_nHeroPoints;

        // IGameObject attributes
        float m_fPerceptiveRadius;
        float m_fSentientRadius;
        int m_nGroupID;
        DWORD m_dwSentientField;
        string m_sOnLoadScript;
        vector<byte> m_binCustomAppearance;
    public:
        CNpcDbItem(){LoadDefaultValues();};
        void LoadDefaultValues();
    };
    typedef vector<CNpcDbItem> NPCDBItemList;

    class CNpcDatabase
    {
    public:
        CNpcDatabase(void);
        ~CNpcDatabase(void);

    public:
        // common function 

        bool IsValid() {return m_pDataBase.get() !=0;};

        void Cleanup();
        DBEntity* GetDBEntity(){return m_pDataBase.get();};
        void SetDBEntity(const string& sConnectionstring);

        void ResetDatabase();

        void ValidateDatabase();
#ifdef _DEBUG

        void TestDB();
#endif

    public:
        // query functions 

        bool SelectNPCByID(int nNPCID, CNpcDbItem& pOut);
        bool SelectNPCByName(const string& sName, CNpcDbItem& pOut);
        
        bool SelectNPCListByRegion(NPCDBItemList* pOut, const Vector3& vMin, const Vector3& vMax);

        bool InsertNPC(CNpcDbItem& npc);

        int GetNPCIDByName(const string& name);
        
        int GetNPCCount();

        bool DeleteNPCByID(int nNPCID);
        bool DeleteNPCByName(const string& sName);

        bool UpdateNPC(const CNpcDbItem& npc, DWORD dwFields);

    private:
        ParaEngine::asset_ptr<DBEntity> m_pDataBase;
        CDBRecordSet* m_pProcInsertNPC;
        CDBRecordSet* m_pProcSelectNPCByID;
        CDBRecordSet* m_pProcSelectNPCByName;
        CDBRecordSet* m_pProcSelectNPCListByRegion;
        CDBRecordSet* m_pProcGetNPCIDByName;
        CDBRecordSet* m_pProcDeleteNPCByID;
        CDBRecordSet* m_pProcDeleteNPCByName;
        CDBRecordSet* m_pProcUpdateNPC;
    };

}