AgentDB Class Reference

#include "AgentDB.h"

Static Public Member Functions
AgentDB.cpp
Agent DB operations original agent code by zhur, this was completely rewritten based on new data. : Allan Date : 24 June 2018
static void	LoadAgentData (uint32 agentID, AgentData &data)
static void	LoadAgentSkills (uint32 agentID, std::map< uint16, uint8 > &data)

Detailed Description

Definition at line 22 of file AgentDB.h.

Member Function Documentation

void AgentDB::LoadAgentData ( uint32  agentID, AgentData &  data  )

static

Todo:

fix this....not all agents have an entry in chrNPCCharacters table.

Todo:

there may be some errors here with agents in space or NOT in stations....will have to test and fix as they come up.

Definition at line 20 of file AgentDB.cpp.

References _log, AgentData::bloodlineID, DBerror::c_str(), codelog, AgentData::corporationID, AgentData::divisionID, AgentData::enemyCorp, DBQueryResult::error, AgentData::factionID, AgentData::friendCorp, AgentData::gender, DBResultRow::GetBool(), DBResultRow::GetInt(), DBQueryResult::GetRow(), DBResultRow::GetText(), DBResultRow::GetUInt(), DBResultRow::IsNull(), AgentData::level, AgentData::locationID, AgentData::locationTypeID, AgentData::locator, AgentData::name, AgentData::quality, AgentData::raceID, AgentData::research, Agents::Type::Research, sDatabase, sDataMgr, AgentData::solarSystemID, AgentData::stationID, and AgentData::typeID.

Referenced by Agent::Load().

{
    DBQueryResult res;
    if(!sDatabase.RunQuery(res,
        "SELECT"
        "   agt.agentTypeID,"
        "   agt.divisionID,"
        "   agt.level,"
        "   agt.quality,"
        "   agt.corporationID,"
        "   agt.locationID, "   //5
        "   agt.isLocator,"
        "   chr.solarSystemID,"
        "   chr.stationID,"
        "   chr.gender,"
        "   bl.bloodlineID,"    //10
        "   itm.typeID, "
        "   crp.friendID, "
        "   crp.enemyID, "
        "   crp.factionID, "
        "   chr.characterName " //15
        " FROM agtAgents AS agt"
        " LEFT JOIN chrNPCCharacters AS chr ON chr.characterID = agt.agentID"
        " LEFT JOIN crpNPCCorporations AS crp ON crp.corporationID = agt.corporationID"
        " LEFT JOIN bloodlineTypes AS bl ON bl.typeID = chr.typeID"
        " LEFT JOIN mapDenormalize AS itm ON itm.itemID = agt.locationID"
        " WHERE agt.agentID = %u", agentID))
    {
        codelog(DATABASE__ERROR, "Error in GetAgents query: %s", res.error.c_str());
        return;
    }

    DBResultRow row;
    if (res.GetRow(row)) {
        if (row.GetUInt(10) == 0) {
            _log(DATABASE__MESSAGE, "No charTypeID for Agent %u", agentID);
            return;
        }
        data.typeID         = row.GetUInt(0);
        data.divisionID     = row.GetUInt(1);
        data.level          = row.GetUInt(2);
        data.quality        = row.GetInt(3);
        data.corporationID  = row.GetUInt(4);
        data.locationID     = row.GetUInt(5);
        data.locator        = row.GetBool(6);
        data.solarSystemID  = row.GetUInt(7);
        data.stationID      = row.GetUInt(8);
        data.gender         = row.GetBool(9);
        data.bloodlineID    = row.GetUInt(10);
        data.locationTypeID = row.GetUInt(11);
        data.friendCorp     = (row.IsNull(12) ? 0 : row.GetInt(12));
        data.enemyCorp      = (row.IsNull(13) ? 0 : row.GetInt(13));
        data.factionID      = row.GetInt(14);
        data.raceID         = sDataMgr.GetFactionRace(data.factionID);
        data.name           = row.GetText(15);
        data.research       = (data.typeID == Agents::Type::Research);
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

void AgentDB::LoadAgentSkills ( uint32  agentID, std::map< uint16, uint8 > &  data  )

static

Definition at line 80 of file AgentDB.cpp.

References DBerror::c_str(), codelog, DBQueryResult::error, DBResultRow::GetInt(), DBQueryResult::GetRow(), and sDatabase.

Referenced by Agent::Load().

{
    // SELECT typeID, level FROM agtSkillLevel WHERE agentID = %u
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT typeID, level FROM agtSkillLevel WHERE agentID = %u", agentID))
        codelog(DATABASE__ERROR, "Error in LoadAgentSkills query: %s", res.error.c_str());

    DBResultRow row;
    while (res.GetRow(row))
        data[row.GetInt(0)] = row.GetInt(1);
}

Here is the call graph for this function:

Here is the caller graph for this function:

---

The documentation for this class was generated from the following files:

• /backups/local/src/eve/EvEmu_Crucible/src/eve-server/agents/AgentDB.h
• /backups/local/src/eve/EvEmu_Crucible/src/eve-server/agents/AgentDB.cpp