MapDB Class Reference

#include "MapDB.h"

Inheritance diagram for MapDB:

Collaboration diagram for MapDB:

Static Public Member Functions
static PyObject *	GetPseudoSecurities ()
static PyObject *	GetStationExtraInfo ()
static PyObject *	GetStationOpServices ()
static PyObject *	GetStationServiceInfo ()
static PyObject *	GetSolSystemVisits (uint32)
static void	GetStationCount (DBQueryResult &res)
static void	GetSystemJumps (DBQueryResult &res)
static void	SystemStartup ()
static void	LoadDynamicData (uint32 sysID, SystemKillData &data)
static PyRep *	GetDynamicData (uint8 type, uint8 time)
static void	ManipulateTimeData ()
static void	SetSystemActive (uint32 sysID, bool active=false)
static void	AddJump (uint32 sysID)
static void	AddKill (uint32 sysID)
static void	AddPodKill (uint32 sysID)
static void	AddFactionKill (uint32 sysID)
static void	UpdateJumps (uint32 sysID, uint16 jumps)
static void	UpdateKillData (uint32 sysID, SystemKillData &data)
static void	UpdatePilotCount (uint32 sysID, uint16 docked=0, uint16 space=0)
Static Public Member Functions inherited from ServiceDB
static bool	GetAccountInformation (CryptoChallengePacket &ccp, AccountData &aData, std::string &failMsg)
static bool	UpdateAccountHash (const char *username, std::string &hash)
static bool	IncrementLoginCount (uint32 accountID)
static void	UpdatePassword (uint32 accountID, const char *pass)
static void	SaveKillOrLoss (CharKillData &data)
static bool	GetConstant (const char *name, uint32 &into)
static void	SetServerOnlineStatus (bool online=false)
static void	SetCharacterOnlineStatus (uint32 char_id, bool online=false)
static void	SetAccountOnlineStatus (uint32 accountID, bool online=false)
static void	SetAccountBanStatus (uint32 accountID, bool banned=false)
static void	SaveServerStats (double threads, float rss, float vm, float user, float kernel, uint32 items, uint32 bubbles)
static uint32	SetClientSeed ()
static PyRep *	LookupChars (const char *match, bool exact=false)
static PyRep *	LookupOwners (const char *match, bool exact=false)
static PyRep *	LookupCorporations (const std::string &)
static PyRep *	LookupFactions (const std::string &)
static PyRep *	LookupCorporationTickers (const std::string &)
static PyRep *	LookupStations (const std::string &)
static PyRep *	LookupKnownLocationsByGroup (const std::string &, uint32)
static PyRep *	PrimeOwners (std::vector< int32 > &itemIDs)
static bool	ValidateAccountName (CryptoChallengePacket &ccp, std::string &failMsg)
static void	GetCorpHangarNames (uint32 corpID, std::map< uint8, std::string > &hangarNames)

Additional Inherited Members
Public Member Functions inherited from ServiceDB
uint32	GetStationOwner (uint32 stationID)
Protected Member Functions inherited from ServiceDB
void	ProcessStringChange (const char *key, const std::string &oldValue, std::string newValue, PyDict *notif, std::vector< std::string > &dbQ)
void	ProcessRealChange (const char *key, double oldValue, double newValue, PyDict *notif, std::vector< std::string > &dbQ)
void	ProcessIntChange (const char *key, uint32 oldValue, uint32 newValue, PyDict *notif, std::vector< std::string > &dbQ)
void	ProcessLongChange (const char *key, int64 oldValue, int64 newValue, PyDict *notif, std::vector< std::string > &dbQ)
Static Protected Member Functions inherited from ServiceDB
static uint32	CreateNewAccount (const char *login, const char *pass, const char *passHash, int64 role)

Detailed Description

Definition at line 35 of file MapDB.h.

Member Function Documentation

void MapDB::AddFactionKill ( uint32  sysID )

static

podKillsHour, podKills24Hour

Definition at line 256 of file MapDB.cpp.

References sDatabase.

Referenced by Sentry::Killed(), CustomsSE::Killed(), NPC::Killed(), StructureSE::Killed(), and ShipSE::Killed().

                                       {
    DBerror err;
    sDatabase.RunQuery(err,
            "UPDATE mapDynamicData SET factionKills = factionKills + 1, factionKills24Hour = factionKills24Hour + 1 WHERE solarSystemID = %u", sysID);
}

Here is the caller graph for this function:

void MapDB::AddJump ( uint32  sysID )

static

Definition at line 218 of file MapDB.cpp.

References sDatabase.

Referenced by SystemManager::AddClient(), Client::CynoJump(), SystemManager::RemoveClient(), and Client::StargateJump().

{
    DBerror err;
    sDatabase.RunQuery(err, "UPDATE mapDynamicData SET jumpsHour = jumpsHour + 1 WHERE solarSystemID = %u", sysID );
}

Here is the caller graph for this function:

void MapDB::AddKill ( uint32  sysID )

static

Definition at line 250 of file MapDB.cpp.

References sDatabase.

Referenced by Sentry::Killed(), CustomsSE::Killed(), NPC::Killed(), StructureSE::Killed(), and ShipSE::Killed().

                                {
    DBerror err;
    sDatabase.RunQuery(err,
            "UPDATE mapDynamicData SET killsHour = killsHour + 1, kills24Hour = kills24Hour + 1 WHERE solarSystemID = %u", sysID);
}

Here is the caller graph for this function:

void MapDB::AddPodKill ( uint32  sysID )

static

killsHour, kills24Hours

Definition at line 262 of file MapDB.cpp.

References sDatabase.

Referenced by ShipSE::Killed().

                                   {
    DBerror err;
    sDatabase.RunQuery(err,
            "UPDATE mapDynamicData SET podKillsHour = podKillsHour + 1, podKills24Hour = podKills24Hour + 1 WHERE solarSystemID = %u", sysID);
}

Here is the caller graph for this function:

PyRep * MapDB::GetDynamicData ( uint8  type, uint8  time  )

static

added jumpsHour and numPilots data inserts. 16Mar14 added killsHour, factionKills, podKillsHour 24Mar14 NOTE: DB has fields for timing the *Hour and *24Hour parts. need to write checks for that once everything else is working. NOTE: use averages for *Hour based on current data and serverUpTime. may be able to do 24Hour same way.

Definition at line 153 of file MapDB.cpp.

References DBResultToRowset(), DBResultRow::GetInt(), DBQueryResult::GetRow(), sDatabase, PyTuple::SetItem(), and PyDict::SetItem().

                                                   {
    DBQueryResult res;
    switch (type) {
        case 1: {
            sDatabase.RunQuery(res, "SELECT solarSystemID, jumpsHour AS value1 FROM mapDynamicData" );
        } break;
        case 2: {
            // cynos arent implemented yet, so this will always return 0
            sDatabase.RunQuery(res, "SELECT solarSystemID, moduleCnt, structureCnt FROM mapDynamicData WHERE active=1" );
            DBResultRow row;
            PyDict* dict = new PyDict();
            while (res.GetRow(row)) {
                PyTuple* inner = new PyTuple(2);
                    inner->SetItem(0, new PyInt(row.GetInt(1)));    // cyno modules on ships (fields)
                    inner->SetItem(1, new PyInt(row.GetInt(2)));    // cyno generators (POS structures)
                dict->SetItem(new PyInt(row.GetInt(0)), inner);
            }
            return dict;
        };
        case 3: {
            if (time == 1) {
                sDatabase.RunQuery(res, "SELECT solarSystemID, killsHour AS value1, factionKills AS value2, podKillsHour AS value3 FROM mapDynamicData" );
            } else if (time == 24) {
                sDatabase.RunQuery(res, "SELECT solarSystemID, kills24Hour AS value1, factionKills24Hour AS value2, podKills24Hour AS value3 FROM mapDynamicData" );
            }
        } break;
        case 4: {
            // not coded in client
        } break;
        case 5: {   //FacWarSvc.GetMostDangerousSystems
            sDatabase.RunQuery(res, "SELECT solarSystemID, killsHour AS value1, factionKills AS value2 FROM mapDynamicData" );
            //, kills24Hour AS value3, factionKills24Hour AS value4, podKills24Hour AS value5
        } break;
        default:
            return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyObject * MapDB::GetPseudoSecurities ( )

static

Definition at line 31 of file MapDB.cpp.

References DBerror::c_str(), codelog, DBResultToRowset(), DBQueryResult::error, and sDatabase.

Referenced by MapData::Populate().

                                     {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res, "SELECT solarSystemID, security FROM mapSolarSystems")) {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyObject * MapDB::GetSolSystemVisits ( uint32  charID )

static

Definition at line 96 of file MapDB.cpp.

References DBerror::c_str(), codelog, DBResultToRowset(), DBQueryResult::error, and sDatabase.

{
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        " SELECT"
        "   solarSystemID,"
        "   visits,"
        "   lastDateTime"
        " FROM chrVisitedSystems"
        " WHERE characterID = %u", charID ))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

void MapDB::GetStationCount ( DBQueryResult &  res )

static

Definition at line 84 of file MapDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res,
        "SELECT map.solarSystemID, count(sta.stationID)"
        " FROM mapSolarSystems AS map"
        "  LEFT JOIN staStations AS sta USING(solarSystemID)"
        " GROUP BY map.solarSystemID"))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyObject * MapDB::GetStationExtraInfo ( )

static

Definition at line 42 of file MapDB.cpp.

References DBerror::c_str(), codelog, DBResultToRowset(), DBQueryResult::error, and sDatabase.

Referenced by MapData::Populate().

                                     {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT"
        "   stationID,"
        "   solarSystemID,"
        "   operationID,"
        "   stationTypeID,"
        "   corporationID AS ownerID"
        " FROM staStations" )) {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyObject * MapDB::GetStationOpServices ( )

static

Definition at line 60 of file MapDB.cpp.

References DBerror::c_str(), codelog, DBResultToRowset(), DBQueryResult::error, and sDatabase.

Referenced by MapData::Populate().

                                      {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT operationID, serviceID FROM staOperationServices")) {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyObject * MapDB::GetStationServiceInfo ( )

static

Definition at line 72 of file MapDB.cpp.

References DBerror::c_str(), codelog, DBResultToRowset(), DBQueryResult::error, and sDatabase.

Referenced by MapData::Populate().

                                       {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT serviceID, serviceName FROM staServices ")) {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void MapDB::GetSystemJumps ( DBQueryResult &  res )

static

Definition at line 194 of file MapDB.cpp.

References sDatabase.

Referenced by MapData::Populate().

{
    //sDatabase.RunQuery(res, "SELECT ctype, fromreg, fromcon, fromsol, tosol, tocon, toreg FROM mapConnections");
    sDatabase.RunQuery(res, "SELECT ctype, fromsol, tosol FROM mapConnections");
}

Here is the caller graph for this function:

void MapDB::LoadDynamicData ( uint32  sysID, SystemKillData &  data  )

static

Definition at line 117 of file MapDB.cpp.

References DBerror::c_str(), codelog, DBQueryResult::error, SystemKillData::faction24DateTime, SystemKillData::factionDateTime, SystemKillData::factionKills, SystemKillData::factionKills24Hour, DBResultRow::GetInt(), DBResultRow::GetInt64(), DBQueryResult::GetRow(), SystemKillData::kills24DateTime, SystemKillData::kills24Hour, SystemKillData::killsDateTime, SystemKillData::killsHour, SystemKillData::pod24DateTime, SystemKillData::podDateTime, SystemKillData::podKills24Hour, SystemKillData::podKillsHour, and sDatabase.

Referenced by SystemManager::BootSystem().

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT killsHour, kills24Hour, factionKills, factionKills24Hour, podKillsHour, podKills24Hour,"
        " killsDateTime, kills24DateTime, podDateTime, pod24DateTime, factionDateTime, faction24DateTime"
        " FROM mapDynamicData"
        " WHERE solarSystemID = %u", sysID))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return;
    }
    DBResultRow row;
    if (res.GetRow(row)) {
        data.killsHour = row.GetInt(0);
        data.kills24Hour = row.GetInt(1);
        data.factionKills = row.GetInt(2);
        data.factionKills24Hour = row.GetInt(3);
        data.podKillsHour = row.GetInt(4);
        data.podKills24Hour = row.GetInt(5);
        data.killsDateTime = row.GetInt64(6);
        data.kills24DateTime = row.GetInt64(7);
        data.factionDateTime = row.GetInt64(8);
        data.faction24DateTime = row.GetInt64(9);
        data.podDateTime = row.GetInt64(10);
        data.pod24DateTime = row.GetInt64(11);
    } else {
        data = SystemKillData();
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

void MapDB::ManipulateTimeData ( )

static

Definition at line 270 of file MapDB.cpp.

Referenced by EntityList::Process().

{

}

Here is the caller graph for this function:

void MapDB::SetSystemActive ( uint32  sysID, bool  active = false  )

static

UPDATE: this is populated when db is created. we are not deleting from mapDynamicData, but setting active as needed notes concerning previous system configuration removed

Definition at line 212 of file MapDB.cpp.

References sDatabase.

Referenced by SystemManager::BootSystem(), and SystemManager::UnloadSystem().

{
    DBerror err;
    sDatabase.RunQuery(err, "UPDATE mapDynamicData SET active = %u WHERE solarSystemID = %u", active?1:0, sysID );
}

Here is the caller graph for this function:

void MapDB::SystemStartup ( )

static

Definition at line 201 of file MapDB.cpp.

References sDatabase.

Referenced by main().

{
    DBerror err;
    sDatabase.RunQuery(err, "UPDATE mapDynamicData SET active = 0, jumpsHour = 0, pilotsDocked = 0, pilotsInSpace = 0, moduleCnt = 0, structureCnt = 0 WHERE 1");
}

Here is the caller graph for this function:

void MapDB::UpdateJumps ( uint32  sysID, uint16  jumps  )

static

factionKills, factionKills24Hour

Definition at line 232 of file MapDB.cpp.

References sLog.

{
    //DBerror err;
    //sDatabase.RunQuery(err, "UPDATE mapDynamicData SET jumpsHour = %u WHERE solarSystemID = %u", jumps, sysID );
    sLog.Warning("MapDB::UpdateJumps", "UPDATE mapDynamicData SET jumpsHour = %u WHERE solarSystemID = %u", jumps, sysID);
}

void MapDB::UpdateKillData ( uint32  sysID, SystemKillData &  data  )

static

Definition at line 239 of file MapDB.cpp.

References SystemKillData::faction24DateTime, SystemKillData::factionDateTime, SystemKillData::factionKills, SystemKillData::factionKills24Hour, SystemKillData::kills24DateTime, SystemKillData::kills24Hour, SystemKillData::killsDateTime, SystemKillData::killsHour, SystemKillData::pod24DateTime, SystemKillData::podDateTime, SystemKillData::podKills24Hour, SystemKillData::podKillsHour, and sDatabase.

Referenced by SystemManager::ManipulateTimeData().

{
    DBerror err;
    sDatabase.RunQuery(err, "UPDATE mapDynamicData SET killsHour = %u, kills24Hour = %u, factionKills = %u, factionKills24Hour = %u,"
    "  podKillsHour = %u, podKills24Hour = %u, killsDateTime = %li, kills24DateTime = %li, podDateTime = %li, pod24DateTime = %li,"
    "  factionDateTime = %li, faction24DateTime = %li",
    data.killsHour, data.kills24Hour, data.factionKills, data.factionKills24Hour, data.podKillsHour, data.podKills24Hour,
    data.killsDateTime, data.kills24DateTime, data.factionDateTime, data.faction24DateTime, data.podDateTime, data.pod24DateTime);
}

Here is the caller graph for this function:

void MapDB::UpdatePilotCount ( uint32  sysID, uint16  docked = 0, uint16  space = 0  )

static

Definition at line 225 of file MapDB.cpp.

References sDatabase.

Referenced by SystemManager::SetDockCount(), and SystemManager::UpdateData().

{
    DBerror err;
    sDatabase.RunQuery(err, "UPDATE mapDynamicData SET pilotsDocked = %u, pilotsInSpace = %u WHERE solarSystemID = %u",
                       docked, space, sysID );
}

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/map/MapDB.h
• /backups/local/src/eve/EvEmu_Crucible/src/eve-server/map/MapDB.cpp