EffectsDataMgr.cpp

Go to the documentation of this file.

#include "effects/EffectsDataMgr.h"
#include "effects/EffectsProcessor.h"


FxDataMgr::FxDataMgr()
{
    m_loaded = false;

    m_fxMap.clear();
    m_opMap.clear();
    m_expMap.clear();
    m_effectMap.clear();
    m_typeFxMap.clear();
}

FxDataMgr::~FxDataMgr()
{

}

int FxDataMgr::Initialize()
{
    Populate();
    sLog.Blue("        FxDataMgr", "Effects Data Manager Initialized.");
    return 1;
}

void FxDataMgr::Populate()
{
    if (m_loaded)
        return;

    double begin = GetTimeMSeconds();
    double start = GetTimeMSeconds();
    DBResultRow row;
    DBQueryResult* res = new DBQueryResult();

    GetDgmTypeEffects(*res);
    while (res->GetRow(row)) {
        //SELECT typeID, effectID, isDefault
        TypeEffects mTfx = TypeEffects();
        mTfx.effectID = row.GetInt(1);
        mTfx.isDefault = row.GetBool(2);
        m_typeFxMap.insert(std::pair<uint16, TypeEffects>(row.GetInt(0), mTfx));
    }
    sLog.Cyan("        FxDataMgr", "%u Type Effects loaded in %.3fms.", m_typeFxMap.size(), (GetTimeMSeconds() - start));

    //res->Reset();
    start = GetTimeMSeconds();
    GetOperands(*res);
    while (res->GetRow(row)) {
        //SELECT operandID, operandKey, format, arg1categoryID, arg2categoryID, resultCategoryID
        Operand mOpr = Operand();
            mOpr.arg1categoryID = row.GetInt(3);
            mOpr.arg2categoryID = row.GetInt(4);
            mOpr.format = row.GetText(2);
            mOpr.operandKey = row.GetText(1);
            mOpr.resultCategoryID = row.GetInt(5);
        m_opMap.insert(std::pair<uint16, Operand>(row.GetInt(0), mOpr));
    }
    // insert a zero-value data set
    Operand mOpr = Operand();
        mOpr.format = "None";
        mOpr.operandKey = "NULL";
    m_opMap[0] = mOpr;
    sLog.Cyan("        FxDataMgr", "%u Operands loaded in %.3fms.", m_opMap.size(), (GetTimeMSeconds() - start));

    //res->Reset();
    start = GetTimeMSeconds();
    GetExpressions(*res);
    while (res->GetRow(row)) {
        //SELECT expressionID, operandID, arg1, arg2, expressionValue, description, expressionName, expressionTypeID, expressionGroupID, expressionAttributeID
        Expression mExp = Expression();
            mExp.id = row.GetInt(0);
            mExp.arg1 = (row.IsNull(2) ? 0 : row.GetInt(2));
            mExp.arg2 = (row.IsNull(3) ? 0 : row.GetInt(3));
            mExp.expressionAttributeID = (row.IsNull(9) ? 0 : row.GetInt(9));
            mExp.description = row.GetText(5);
            mExp.expressionGroupID = (row.IsNull(8) ? 0 : row.GetInt(8));
            mExp.expressionName = row.GetText(6);
            mExp.operandID = row.GetInt(1);
            mExp.expressionTypeID = (row.IsNull(7) ? 0 : row.GetInt(7));
            mExp.expressionValue = row.GetText(4);
        m_expMap.insert(std::pair<uint16, Expression>(row.GetInt(0), mExp));
    }
    // insert a zero-value data set
    Expression mExp = Expression();
        mExp.description = "NULL";
        mExp.expressionName = "NULL";
    m_expMap[0] = mExp;
    sLog.Cyan("        FxDataMgr", "%u Expressions loaded in %.3fms.", m_expMap.size(), (GetTimeMSeconds() - start));

    //res->Reset();
    start = GetTimeMSeconds();
    GetDgmEffects(*res);
    while (res->GetRow(row)) {
        //SELECT effectID, effectName, effectState, preExpression, postExpression, isOffensive, isAssistance, disallowAutoRepeat, isWarpSafe \
        //      npcUsageChanceAttributeID, npcActivationChanceAttributeID, fittingUsageChanceAttributeID,\
        //      durationAttributeID, trackingSpeedAttributeID, dischargeAttributeID, rangeAttributeID, falloffAttributeID, rangeChance, electronicChance, propulsionChance, guid
        Effect mEffect = Effect();
            mEffect.effectID = row.GetInt(0);
            mEffect.effectName = row.GetText(1);
            mEffect.effectState = row.GetInt(2);
            mEffect.preExpression = row.GetInt(3);
            mEffect.postExpression = row.GetInt(4);
            mEffect.isOffensive = row.GetInt(5) ? true : false;
            mEffect.isAssistance = row.GetInt(6) ? true : false;
            mEffect.disallowAutoRepeat = row.GetInt(7) ? true : false;
            mEffect.isWarpSafe = row.GetInt(8) ? true : false;
            mEffect.npcUsageChanceAttributeID = row.GetInt(9);
            mEffect.npcActivationChanceAttributeID = row.GetInt(10);
            mEffect.fittingUsageChanceAttributeID = row.GetInt(11);
            mEffect.durationAttributeID = (row.IsNull(12) ? 0 : row.GetInt(12));
            mEffect.trackingSpeedAttributeID = (row.IsNull(13) ? 0 : row.GetInt(13));
            mEffect.dischargeAttributeID = (row.IsNull(14) ? 0 : row.GetInt(14));
            mEffect.rangeAttributeID = (row.IsNull(15) ? 0 : row.GetInt(15));
            mEffect.falloffAttributeID = (row.IsNull(16) ? 0 : row.GetInt(16));
            mEffect.rangeChance = row.GetFloat(17);
            mEffect.electronicChance = row.GetFloat(18);
            mEffect.propulsionChance = row.GetFloat(19);
            mEffect.guid = row.GetText(20);
        m_effectMap.insert(std::pair<uint16, Effect>(row.GetInt(0), mEffect));
        m_effectName.insert(std::pair<std::string, uint16>(mEffect.effectName, row.GetInt(0)));
    }
    // insert a zero-value data set
    Effect mEffect = Effect();
        mEffect.effectName = "NULL";
    m_effectMap[0] = mEffect;
    sLog.Cyan("        FxDataMgr", "%u Effect Types loaded in %.3fms.", m_effectMap.size(), (GetTimeMSeconds() - start));

    //cleanup
    SafeDelete(res);

    m_loaded = true;
    sLog.Cyan("        FxDataMgr", "Effects Data loaded in %.3fms.", (GetTimeMSeconds() - begin));
}

Effect FxDataMgr::GetEffect(uint16 eID)
{
    effectMapType::const_iterator itr = m_effectMap.find(eID);
    if (itr != m_effectMap.end())
        return itr->second;
    return m_effectMap.at(0);
}

void FxDataMgr::GetTypeEffect(uint16 typeID, std::vector< TypeEffects >& typeEffMap)
{
    auto itr = m_typeFxMap.equal_range(typeID);
    for (auto it = itr.first; it != itr.second; ++it)
        typeEffMap.push_back(it->second);
}

Expression FxDataMgr::GetExpression(uint16 eID)
{
    std::map<uint16, Expression>::const_iterator itr = m_expMap.find(eID);
    if (itr != m_expMap.end())
        return itr->second;
    return m_expMap.at(0);
}

Operand FxDataMgr::GetOperand(uint16 oID)
{
    std::map<uint16, Operand>::const_iterator itr = m_opMap.find(oID);
    if (itr != m_opMap.end())
        return itr->second;
    return m_opMap.at(0);

}

bool FxDataMgr::isWarpSafe(uint16 eID)
{
    effectMapType::const_iterator itr = m_effectMap.find(eID);
    if (itr != m_effectMap.end())
        return itr->second.isWarpSafe;
    return false;   // default to false if effectID not found
}

bool FxDataMgr::isOffensive(uint16 eID)
{
    effectMapType::const_iterator itr = m_effectMap.find(eID);
    if (itr != m_effectMap.end())
        return itr->second.isOffensive;
    return false;   // default to false if effectID not found
}

bool FxDataMgr::isAssistance(uint16 eID)
{
    effectMapType::const_iterator itr = m_effectMap.find(eID);
    if (itr != m_effectMap.end())
        return itr->second.isAssistance;
    return false;   // default to false if effectID not found
}

uint16 FxDataMgr::GetEffectID(std::string effectName)
{
    std::map<std::string, uint16>::const_iterator itr = m_effectName.find(effectName);
    if (itr != m_effectName.end())
        return itr->second;
    return 0;
}

std::string FxDataMgr::GetEffectGuid(uint16 eID)
{
    effectMapType::const_iterator itr = m_effectMap.find(eID);
    if (itr != m_effectMap.end())
        return itr->second.guid;
    return "";   // default to 'nothing' if effectID not found
}

std::string FxDataMgr::GetEffectName(uint16 eID)
{
    effectMapType::const_iterator itr = m_effectMap.find(eID);
    if (itr != m_effectMap.end())
        return itr->second.effectName;
    return "";   // default to 'nothing' if effectID not found
}


void FxDataMgr::GetOperands(DBQueryResult& res)
{
    if( !sDatabase.RunQuery(res,
        " SELECT"
        " operandID,"
        " operandKey,"
        " format,"
        " arg1categoryID,"
        " arg2categoryID,"
        " resultCategoryID"
        " FROM dgmOperands"))
    {
        codelog(DATABASE__ERROR, "Error in GetOperands: %s", res.error.c_str());
    }
}

void FxDataMgr::GetDgmEffects(DBQueryResult& res)
{
    if( !sDatabase.RunQuery(res,
        " SELECT"
        "   effectID,"
        "   effectName,"
        "   effectCategory,"
        "   preExpression,"
        "   postExpression,"
        "   isOffensive,"
        "   isAssistance,"
        "   disallowAutoRepeat,"
        "   isWarpSafe,"
        "   npcUsageChanceAttributeID,"
        "   npcActivationChanceAttributeID,"
        "   fittingUsageChanceAttributeID,"
        "   durationAttributeID,"
        "   trackingSpeedAttributeID,"
        "   dischargeAttributeID,"
        "   rangeAttributeID,"
        "   falloffAttributeID,"
        "   rangeChance,"    // dunno what this is ...bool?
        "   electronicChance,"   // dunno what this is...bool?
        "   propulsionChance,"   // not used (all 0)...bool?
        "   guid"
        " FROM dgmEffects"))
    {
        codelog(DATABASE__ERROR, "Error in GetDgmEffects: %s", res.error.c_str());
    }
}

void FxDataMgr::GetExpressions(DBQueryResult& res)
{
    if( !sDatabase.RunQuery(res,
        " SELECT"
        " expressionID,"
        " operandID,"
        " arg1,"
        " arg2,"
        " expressionValue,"
        " description,"
        " expressionName,"
        " expressionTypeID,"
        " expressionGroupID,"
        " expressionAttributeID"
        " FROM dgmExpressions"))
    {
        codelog(DATABASE__ERROR, "Error in GetExpressions: %s", res.error.c_str());
    }
}

void FxDataMgr::GetDgmTypeEffects(DBQueryResult &res)
{
    if( !sDatabase.RunQuery(res,
        " SELECT"
        "  typeID,"
        "  effectID,"
        "  isDefault"
        " FROM dgmTypeEffects "
        " WHERE effectID != 132"))  // 132 maps skill level onto skill data. this screws up my skill level code
    {
        codelog(DATABASE__ERROR, "Error in GetDgmTypeEffects: %s", res.error.c_str());
    }
}