ManagerDB Class Reference

#include "ManagerDB.h"

ManagerDB.cpp
cosmic manager database methods : Allan Date : 17 April 2016
static void	GetStatisticData (DBQueryResult &res, int64 starttime)
static void	SaveStatisticData (StatisticData &data)
static void	UpdateStatisticHistory (StatisticData &data)
static void	GetTypeData (DBQueryResult &res)
static void	GetGroupData (DBQueryResult &res)
static void	GetCategoryData (DBQueryResult &res)
static void	GetOreBySSC (DBQueryResult &res)
static void	GetSkillList (DBQueryResult &res)
static void	GetSystemData (DBQueryResult &res)
static void	GetStaticData (DBQueryResult &res)
static void	GetMoonResouces (DBQueryResult &res)
static void	GetAgentLocation (DBQueryResult &res)
static void	GetSalvageGroups (DBQueryResult &res)
static void	GetTypeAttributes (DBQueryResult &res)
static void	LoadNPCCorpFactionData (DBQueryResult &res)
static void	LoadCorpFactions (std::map< uint32, uint32 > &into)
static void	LoadFactionStationCounts (std::map< uint32, uint32 > &into)
static void	LoadFactionSystemCounts (std::map< uint32, uint32 > &into)
static void	LoadFactionRegions (std::map< int32, PyRep * > &into)
static void	LoadFactionConstellations (std::map< int32, PyRep * > &into)
static void	LoadFactionSolarSystems (std::map< int32, PyRep * > &into)
static void	LoadFactionRaces (std::map< int32, PyRep * > &into)
static PyDict *	LoadNPCCorpInfo ()
static PyObject *	GetEntryTypes ()
static PyObject *	GetKeyMap ()
static PyObject *	GetNPCDivisions ()
static PyObject *	GetBillTypes ()
static PyObjectEx *	GetAgents ()
static PyObjectEx *	GetOperands ()
static void	GetRegionFaction (DBQueryResult &res)
static bool	GetAsteroidData (uint32 asteroidID, AsteroidData &dbData)
static void	CreateRoidItemID (ItemData &idata, AsteroidData &adata)
static void	DeleteSpawnedRats ()
static void	GetSpawnClasses (DBQueryResult &res)
static void	GetFactionGroups (DBQueryResult &res)
static void	GetRegionRatFaction (DBQueryResult &res)
static void	GetGroupTypeIDs (uint8 shipClass, uint16 groupID, uint32 factionID, DBQueryResult &res)
static void	GetDunRoomData (DBQueryResult &res)
static void	GetDunRoomInfo (DBQueryResult &res)
static void	GetDunEntryData (DBQueryResult &res)
static void	GetDunTemplates (DBQueryResult &res)
static void	GetDunGroupData (DBQueryResult &res)
static void	GetDunSpawnInfo (DBQueryResult &res)
static void	SaveActiveDungeon (Dungeon::ActiveData &dun)
static void	ClearDungeons ()
static void	ClearDungeons (uint32 systemID)
static bool	GetSavedDungeons (uint32 systemID, std::vector< Dungeon::ActiveData > &into)
static GPoint	GetAnomalyPos (std::string &string)
static void	GetWHSystemClass (DBQueryResult &res)
void	ClearAsteroids ()
void	SaveRoid (AsteroidData &data)
void	SaveSystemRoids (uint32 systemID, std::vector< AsteroidData > &roids)
void	RemoveAsteroid (uint32 asteroidID)
bool	LoadSystemRoids (uint32 systemID, uint32 &beltID, std::vector< AsteroidData > &into)
void	SaveAnomaly (CosmicSignature &sig)
void	GetAnomalyList (DBQueryResult &res)
void	GetSystemAnomalies (uint32 systemID, DBQueryResult &res)
void	GetSystemAnomalies (uint32 systemID, std::vector< CosmicSignature > &sigs)

Detailed Description

Definition at line 22 of file ManagerDB.h.

Member Function Documentation

void ManagerDB::ClearAsteroids

(

)

Definition at line 545 of file ManagerDB.cpp.

References sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err, "DELETE FROM sysAsteroids WHERE 1");
    sDatabase.RunQuery(err, "ALTER TABLE `sysAsteroids` auto_increment = 450000000");
}

void ManagerDB::ClearDungeons ( )

static

Definition at line 690 of file ManagerDB.cpp.

References sDatabase.

Referenced by DungeonDataMgr::Initialize(), and SystemManager::UnloadSystem().

{
    DBerror err;
    sDatabase.RunQuery(err, "DELETE FROM dunActive WHERE 1");
    sDatabase.RunQuery(err, "DELETE FROM sysSignatures WHERE 1");
    // anomaly items are all temp, except roids, so we may not need this...
    sDatabase.RunQuery(err, "DELETE FROM entity_attributes WHERE itemID IN (SELECT itemID FROM entity WHERE customInfo LIKE 'Dungeon%%')");
    sDatabase.RunQuery(err, "DELETE FROM entity WHERE customInfo LIKE 'Dungeon%%'");
}

Here is the caller graph for this function:

void ManagerDB::ClearDungeons ( uint32  systemID )

static

Definition at line 700 of file ManagerDB.cpp.

References sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err, "DELETE FROM dunActive WHERE systemID = %u", systemID);
    sDatabase.RunQuery(err, "DELETE FROM sysSignatures WHERE  systemID = %u", systemID);
    // anomaly items are all temp, except roids, so we may not need this...
    sDatabase.RunQuery(err, "DELETE FROM entity_attributes WHERE itemID IN (SELECT itemID FROM entity WHERE locationID = %u AND customInfo LIKE 'Dungeon%%')", systemID);
    sDatabase.RunQuery(err, "DELETE FROM entity WHERE locationID = %u AND customInfo LIKE 'Dungeon%%'", systemID);
}

void ManagerDB::CreateRoidItemID ( ItemData &  idata, AsteroidData &  adata  )

static

Definition at line 468 of file ManagerDB.cpp.

References AsteroidData::beltID, AsteroidData::itemID, AsteroidData::itemName, AsteroidData::position, AsteroidData::quantity, AsteroidData::radius, sDatabase, AsteroidData::systemID, AsteroidData::typeID, Ga::GaVec3::x, Ga::GaVec3::y, and Ga::GaVec3::z.

Referenced by AsteroidItem::Spawn().

{
    DBerror err;
    sDatabase.RunQueryLID(err, adata.itemID,
        "INSERT INTO sysAsteroids (itemName,typeID,systemID,beltID,quantity,radius,x, y, z)"
        " VALUES ('%s', %u, %u, %u, %f, %f, %f, %f, %f)",
                          adata.itemName.c_str(), adata.typeID, adata.systemID, adata.beltID, adata.quantity, adata.radius,
                          adata.position.x, adata.position.y, adata.position.z );
}

Here is the caller graph for this function:

void ManagerDB::DeleteSpawnedRats ( )

static

Definition at line 462 of file ManagerDB.cpp.

References sDatabase.

Referenced by ItemFactory::Initialize().

{
    DBerror err;
    sDatabase.RunQuery(err, "DELETE FROM entity WHERE customInfo LIKE '%beltrat%'");
}

Here is the caller graph for this function:

void ManagerDB::GetAgentLocation ( DBQueryResult &  res )

static

Definition at line 313 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT agentID, locationID FROM agtAgents"))
        codelog(DATABASE__ERROR, "Error in GetAgentLocation query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyObjectEx * ManagerDB::GetAgents ( )

static

Definition at line 130 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                 {
    // NOTE:  havent found data for agents in space yet....still looking.
    DBQueryResult res;
    if(!sDatabase.RunQuery(res,
        "SELECT"
        "    agt.agentID,"
        "    agt.agentTypeID,"
        "    agt.divisionID,"
        "    agt.level,"
        "    agt.quality,"
        "    agt.corporationID,"
        "    chr.stationID,"
        "    chr.gender,"
        "    bl.bloodlineID"
        " FROM agtAgents AS agt"
        " LEFT JOIN chrNPCCharacters AS chr ON chr.characterID = agt.agentID"
        " LEFT JOIN bloodlineTypes AS bl ON bl.typeID = chr.typeID"
    ))
    {
        codelog(DATABASE__ERROR, "Error in GetAgents query: %s", res.error.c_str());
        return nullptr;
    }

    _log(DATABASE__RESULTS, "GetAgents returned %u items", res.GetRowCount());
    return DBResultToCRowset(res);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetAnomalyList

(

DBQueryResult &

res

)

Definition at line 338 of file ManagerDB.cpp.

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

{// sysSignatures (sigID,sigItemID,dungeonType,sigName,systemID,sigTypeID,sigGroupID,scanGroupID,scanAttributeID,x,y,z)
    if(!sDatabase.RunQuery(res,
        "SELECT sigID,sigItemID,dungeonType,sigName,systemID,sigTypeID,sigGroupID,scanGroupID,scanAttributeID,x,y,z"
        " FROM sysSignatures"
        " ORDER BY systemid")) {
        _log(DATABASE__ERROR, "Error in GetAnomalyList query: %s", res.error.c_str());
        }
}

Here is the call graph for this function:

GPoint ManagerDB::GetAnomalyPos ( std::string &  string )

static

Definition at line 348 of file ManagerDB.cpp.

References _log, DBerror::c_str(), DBQueryResult::error, DBQueryResult::GetRow(), NULL_ORIGIN(), and sDatabase.

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT x,y,z FROM sysSignatures WHERE sigID = '%s'", string.c_str()))
        _log(DATABASE__ERROR, "Error in GetAnomalyPos query: %s", res.error.c_str());

    DBResultRow row;
    if (!res.GetRow(row)) {
        _log(DATABASE__MESSAGE, "GetAnomalyPos query returned no items");
        return NULL_ORIGIN;
    }

    GPoint pos(row.GetDouble(0), row.GetDouble(1), row.GetDouble(2));
    return pos;
}

Here is the call graph for this function:

bool ManagerDB::GetAsteroidData ( uint32  asteroidID, AsteroidData &  dbData  )

static

Definition at line 478 of file ManagerDB.cpp.

References _log, AsteroidData::beltID, DBerror::c_str(), DBQueryResult::error, DBResultRow::GetDouble(), DBResultRow::GetInt(), DBQueryResult::GetRow(), DBResultRow::GetText(), AsteroidData::itemID, AsteroidData::itemName, AsteroidData::position, AsteroidData::quantity, AsteroidData::radius, sDatabase, AsteroidData::systemID, and AsteroidData::typeID.

Referenced by AsteroidItem::_LoadItem().

{
    DBQueryResult res;
    if(!sDatabase.RunQuery(res,
        "SELECT itemName, typeID, systemID, beltID, quantity, radius, x, y, z"
        " FROM sysAsteroids"
        " WHERE itemID = %u", asteroidID)) {
        _log(DATABASE__ERROR, "Error in GetAsteroidData query: %s", res.error.c_str());
            return false;
    }

    DBResultRow row;
    if (res.GetRow(row)) {
        dbData.itemID = asteroidID;
        dbData.itemName = row.GetText(0);
        dbData.typeID = row.GetInt(1);
        dbData.systemID = row.GetInt(2);
        dbData.beltID = row.GetInt(3);
        dbData.quantity = row.GetDouble(4);
        dbData.radius = row.GetDouble(5);
        GPoint pos(row.GetDouble(6), row.GetDouble(7), row.GetDouble(8));
        dbData.position = pos;
        return true;
    } else {
        dbData = AsteroidData();
    }

    return false;
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyObject * ManagerDB::GetBillTypes ( )

static

Definition at line 118 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                  {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT billTypeID, billTypeName, description FROM billTypes")) {
        codelog(DATABASE__ERROR, "Failed to query bill types: %s.", res.error.c_str());
        return nullptr;
    }

    _log(DATABASE__RESULTS, "GetBillTypes returned %u items", res.GetRowCount());

    return DBResultToRowset(res);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetCategoryData ( DBQueryResult &  res )

static

Definition at line 16 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                                  {
    if (!sDatabase.RunQuery(res, "SELECT categoryID, categoryName, description, published FROM invCategories"))
        codelog(DATABASE__ERROR, "Error in GetCategoryData query: %s.", res.error.c_str());

    _log(DATABASE__RESULTS, "GetCategoryData returned %u items", res.GetRowCount());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetDunEntryData ( DBQueryResult &  res )

static

Definition at line 604 of file ManagerDB.cpp.

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

Referenced by DungeonDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT dunEntryID, dunEntryName, xpos, ypos, zpos FROM dunEntryData"))
        _log(DATABASE__ERROR, "Error in GetDunRoomData query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetDunGroupData ( DBQueryResult &  res )

static

Definition at line 610 of file ManagerDB.cpp.

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

Referenced by DungeonDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT d.dunGroupID, d.itemTypeID, d.itemGroupID, t.typeName, t.groupID, g.categoryID, t.radius, d.xpos, d.ypos, d.zpos"
        " FROM dunGroupData AS d"
        "  LEFT JOIN invTypes AS t ON d.itemTypeID = t.typeID"
        "  LEFT JOIN invGroups AS g ON g.groupID = t.groupID" ))
    {
        _log(DATABASE__ERROR, "Error in GetDunGroupData query: %s", res.error.c_str());
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetDunRoomData ( DBQueryResult &  res )

static

Definition at line 621 of file ManagerDB.cpp.

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

Referenced by DungeonDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT dunRoomID, dunGroupID, xpos, ypos, zpos FROM dunRoomData"))
        _log(DATABASE__ERROR, "Error in GetDunRoomData query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetDunRoomInfo ( DBQueryResult &  res )

static

Definition at line 627 of file ManagerDB.cpp.

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

{
    if (!sDatabase.RunQuery(res, "SELECT dunRoomID, dunRoomType, dunRoomCategory, dunRoomSpawnID, dunRoomSpawnType FROM dunRoomInfo"))
        _log(DATABASE__ERROR, "Error in GetDunRoomInfo query: %s", res.error.c_str());
}

Here is the call graph for this function:

void ManagerDB::GetDunSpawnInfo ( DBQueryResult &  res )

static

Definition at line 633 of file ManagerDB.cpp.

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

{
    if (!sDatabase.RunQuery(res, "SELECT dunRoomSpawnID, dunRoomSpawnType, xpos, ypos, zpos FROM dunRoomSpawnInfo"))
        _log(DATABASE__ERROR, "Error in GetDunSpawnInfo query: %s", res.error.c_str());
}

Here is the call graph for this function:

void ManagerDB::GetDunTemplates ( DBQueryResult &  res )

static

Definition at line 639 of file ManagerDB.cpp.

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

Referenced by DungeonDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT dunTemplateID, dunTemplateName, dunEntryID, dunSpawnID, dunRoomID FROM dunTemplates"))
        _log(DATABASE__ERROR, "Error in GetDunTemplates query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyObject * ManagerDB::GetEntryTypes ( )

static

Definition at line 94 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                   {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT entryTypeID, entryTypeName, entryTypeNameID FROM jnlEntryTypeIDs"))    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    _log(DATABASE__RESULTS, "GetEntryTypes returned %u items", res.GetRowCount());

    return DBResultToRowset(res);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetFactionGroups ( DBQueryResult &  res )

static

Definition at line 390 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                                   {
    if (!sDatabase.RunQuery(res, "SELECT shipClass, groupID, factionID FROM npcClassGroup"))
        _log(DATABASE__ERROR, "Error in GetFactionGroups query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetGroupData ( DBQueryResult &  res )

static

Definition at line 23 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res,
        "SELECT"
        "  groupID,"
        "  categoryID,"
        "  groupName,"
        "  description,"
        "  useBasePrice,"
        "  allowManufacture,"
        "  allowRecycler,"
        "  anchored,"
        "  anchorable,"
        "  fittableNonSingleton,"
        "  published "
        " FROM invGroups "))
        codelog(DATABASE__ERROR, "Error in GetGroupData query: %s.", res.error.c_str());

    _log(DATABASE__RESULTS, "GetGroupData returned %u items", res.GetRowCount());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetGroupTypeIDs ( uint8  shipClass, uint16  groupID, uint32  factionID, DBQueryResult &  res  )

static

Definition at line 401 of file ManagerDB.cpp.

References _log, DBerror::c_str(), DBQueryResult::error, factionAngel, factionBloodRaider, factionGuristas, factionRogueDrones, factionSanshas, factionSerpentis, and sDatabase.

Referenced by StaticDataMgr::Populate().

                                                                                                     {
    // this now gets advanced frigates and cruisers based on faction (best i could think of)
    std::string name = "";

    // there are unused types in the data for these...just sayin
    switch (factionID) {
        case factionAngel: {  //  Cyber
            if ((shipClass == 2) or (shipClass == 5) or (shipClass == 16) or (shipClass == 19)) { // 2 = adv frig, 5 = adv cruiser, 16 = adv frig, 19 = adv cruiser
                name = "AND typeName LIKE '%Arch%'";
                name = "AND typeName NOT LIKE '%Cyber%'";
            } else if ((shipClass == 1) or (shipClass == 4) or (shipClass == 15) or (shipClass == 18)) { // 1 = frig, 4 = cruiser, 15 = frig, 18 = cruiser
                name = "AND typeName NOT LIKE '%Arch%'";
                name = "AND typeName NOT LIKE '%Cyber%'";
            }
        } break;
        case factionBloodRaider: {
            if ((shipClass == 2) or (shipClass == 5) or (shipClass == 16) or (shipClass == 19)) {
                name = "AND typeName LIKE '%Elder%'";
            } else if ((shipClass == 1) or (shipClass == 4) or (shipClass == 15) or (shipClass == 18)) {
                name = "AND typeName NOT LIKE '%Elder%'";
            }
        } break;
        case factionGuristas: {   //Outlaw
            if ((shipClass == 2) or (shipClass == 5) or (shipClass == 16) or (shipClass == 19)) {
                name = "AND typeName LIKE '%Dire%'";
                name = "AND typeName NOT LIKE '%Outlaw%'";
            } else if ((shipClass == 1) or (shipClass == 4) or (shipClass == 15) or (shipClass == 18)) {
                name = "AND typeName NOT LIKE '%Dire%'";
                name = "AND typeName NOT LIKE '%Outlaw%'";
            }
        } break;
        case factionSanshas: {
            if ((shipClass == 2) or (shipClass == 5) or (shipClass == 16) or (shipClass == 19)) {
                name = "AND typeName LIKE '%Loyal%'";
            } else if ((shipClass == 1) or (shipClass == 4) or (shipClass == 15) or (shipClass == 18)) {
                name = "AND typeName NOT LIKE '%Loyal%'";
            }
        } break;
        case factionSerpentis: {   //Crook
            if ((shipClass == 2) or (shipClass == 5) or (shipClass == 16) or (shipClass == 19)) {
                name = "AND typeName LIKE '%Guardian%'";
                name = "AND typeName NOT LIKE '%Crook%'";
            } else if ((shipClass == 1) or (shipClass == 4) or (shipClass == 15) or (shipClass == 18)) {
                name = "AND typeName NOT LIKE '%Guardian%'";
                name = "AND typeName NOT LIKE '%Crook%'";
            }
        } break;
        case factionRogueDrones: {
            if ((shipClass == 2) or (shipClass == 5) or (shipClass == 16) or (shipClass == 19)) {
                name = "AND typeName LIKE '%Strain%'";
            } else if ((shipClass == 1) or (shipClass == 4) or (shipClass == 15) or (shipClass == 18)) {
                name = "AND typeName NOT LIKE '%Strain%'";
            }
        } break;
    }

    if (!sDatabase.RunQuery(res, "SELECT typeID FROM invTypes WHERE groupID = %u %s ORDER BY typeID", groupID, name.c_str()))
        _log(DATABASE__ERROR, "Error in GetGroupTypeIDs query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyObject * ManagerDB::GetKeyMap ( )

static

Definition at line 106 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                               {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT keyID, keyType, keyName, keyNameID FROM actKeyTypes")) {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    _log(DATABASE__RESULTS, "GetKeyMap returned %u items", res.GetRowCount());

    return DBResultToRowset(res);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetMoonResouces ( DBQueryResult &  res )

static

Definition at line 319 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT typeID,volume FROM invTypes WHERE groupID = %u", EVEDB::invGroups::Moon_Materials))
        codelog(DATABASE__ERROR, "Error in GetMoonResouces query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyObject * ManagerDB::GetNPCDivisions ( )

static

Definition at line 269 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                     {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT "
        " divisionID, divisionName, description, leaderType, divisionNameID, leaderTypeID"
        " FROM crpNPCDivisions" )) {
        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:

PyObjectEx * ManagerDB::GetOperands ( )

static

Definition at line 157 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

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

    _log(DATABASE__RESULTS, "GetOperands returned %u items", res.GetRowCount());

    return DBResultToCIndexedRowset(res, "operandID");
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetOreBySSC ( DBQueryResult &  res )

static

Definition at line 290 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT systemSec, roidID, percent FROM roidDistribution"))
        codelog(DATABASE__ERROR, "Error in GetRoidDist query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetRegionFaction ( DBQueryResult &  res )

static

Definition at line 380 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                                   {
    if (!sDatabase.RunQuery(res, "SELECT regionID, factionID FROM mapRegions WHERE factionID != 0"))
        _log(DATABASE__ERROR, "Error in GetRegionFactionInfo query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetRegionRatFaction ( DBQueryResult &  res )

static

Definition at line 385 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                                      {
    if (!sDatabase.RunQuery(res, "SELECT regionID, ratFactionID FROM mapRegions WHERE ratFactionID != 0"))
        _log(DATABASE__ERROR, "Error in GetRegionFactionInfo query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetSalvageGroups ( DBQueryResult &  res )

static

Definition at line 282 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                                   {
    //facSalvage (factionID,itemID,itemName)
    if (!sDatabase.RunQuery(res, "SELECT factionID, itemID FROM facSalvage")) {
        codelog(DATABASE__ERROR, "Error in GetSalvageGroups query: %s", res.error.c_str());
        return;
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool ManagerDB::GetSavedDungeons ( uint32  systemID, std::vector< Dungeon::ActiveData > &  into  )

static

Definition at line 645 of file ManagerDB.cpp.

References _log, DBerror::c_str(), Dungeon::ActiveData::dunExpiryTime, Dungeon::ActiveData::dunItemID, Dungeon::ActiveData::dunTemplateID, DBQueryResult::error, DBQueryResult::GetRow(), DBQueryResult::GetRowCount(), sDatabase, Dungeon::ActiveData::state, Dungeon::ActiveData::systemID, Dungeon::ActiveData::x, Dungeon::ActiveData::y, and Dungeon::ActiveData::z.

Referenced by DungeonMgr::Load().

{
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT systemID, state, dunTemplateID, dunExpiryTime, xpos, ypos, zpos"
        " FROM dunActive"   //Active Dungeons
        " WHERE systemID = %u", systemID))
    {
        _log(DATABASE__ERROR, "Error in GetSavedDungeons query: %s", res.error.c_str());
        return false;
    }

    _log(DATABASE__RESULTS, "GetSavedDungeons returned %u items", res.GetRowCount());
    DBResultRow row;
    while(res.GetRow(row)) {
        Dungeon::ActiveData entry = Dungeon::ActiveData();
            entry.systemID = row.GetInt(0);
            entry.state = row.GetInt(1);
            entry.dunItemID = 0;
            entry.dunTemplateID = row.GetInt(2);
            entry.dunExpiryTime = row.GetInt64(3);
            entry.x = row.GetInt(4);
            entry.y = row.GetInt(5);
            entry.z = row.GetInt(6);
        into.push_back(entry);
    }

    return !into.empty();
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetSkillList ( DBQueryResult &  res )

static

Definition at line 70 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT typeID, typeName FROM invTypes WHERE groupID IN (SELECT groupID FROM invGroups WHERE categoryID = 16)"))
        codelog(DATABASE__ERROR, "Error in GetSkillList query: %s", res.error.c_str());

    _log(DATABASE__RESULTS, "GetSkillList returned %u items", res.GetRowCount());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetSpawnClasses ( DBQueryResult &  res )

static

Definition at line 395 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                                  {
    if (!sDatabase.RunQuery(res, "SELECT type, sub, f, af, d, c, ac, bc, bs, h, o, cf, cd, cc, cbc, cbs FROM npcSpawnClass"))
        _log(DATABASE__ERROR, "Error in GetSpawnClasses query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetStaticData ( DBQueryResult &  res )

static

Definition at line 306 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res,
        "SELECT itemID, regionID, constellationID, solarSystemID, typeID, radius, x, y, z FROM mapDenormalize WHERE solarSystemID IS NOT NULL"))
        codelog(DATABASE__ERROR, "Error in GetStaticInfo query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetStatisticData ( DBQueryResult &  res, int64  starttime  )

static

Definition at line 714 of file ManagerDB.cpp.

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

Referenced by StatisticMgr::CompileData().

{
    if (!sDatabase.RunQuery(res,
        "SELECT pcShots, pcMissiles, ramJobs, shipsSalvaged, pcBounties, npcBounties, oreMined, iskMarket, probesLaunched, sitesScanned"
        " FROM srvStatisticData"
        " WHERE timeStamp > %li", starttime))
        codelog(DATABASE__ERROR, "Error in GetStatisticData query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetSystemAnomalies	(	uint32	systemID,
		DBQueryResult &	res
	)

Definition at line 365 of file ManagerDB.cpp.

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

{// sysSignatures (sigTypeID,scanGroupID,sigGroupID,scanAttributeID,sigName,sigID,x,y,z)
    if(!sDatabase.RunQuery(res,
        "SELECT sigTypeID, scanGroupID, sigGroupID, scanAttributeID, sigName, sigID, x, y, z"
        " FROM sysSignatures"
        " WHERE systemID = %u", systemID)) {
        _log(DATABASE__ERROR, "Error in GetSystemAnomalies query: %s", res.error.c_str());
        }
}

Here is the call graph for this function:

void ManagerDB::GetSystemAnomalies	(	uint32	systemID,
		std::vector< CosmicSignature > &	sigs
	)

Definition at line 375 of file ManagerDB.cpp.

{// sysSignatures (sigID,sigItemID,sigName,systemID,sigTypeID,sigGroupID,scanGroupID,scanAttributeID,x,y,z)

}

void ManagerDB::GetSystemData ( DBQueryResult &  res )

static

Definition at line 296 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res,
        "SELECT mss.solarSystemID, mss.solarSystemName, mss.constellationID, mss.regionID, mss.securityClass, md.security, mss.factionID"
        " FROM mapSolarSystems AS mss"
        " LEFT JOIN mapDenormalize AS md ON (md.itemID = mss.solarSystemID)"
    ))
        codelog(DATABASE__ERROR, "Error in GetSystemData query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetTypeAttributes ( DBQueryResult &  res )

static

Definition at line 78 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT typeID, attributeID, valueInt, valueFloat FROM dgmTypeAttributes"))
        codelog(DATABASE__ERROR, "Error in GetTypeAttributes query: %s", res.error.c_str());

    _log(DATABASE__RESULTS, "GetTypeAttributes returned %u items", res.GetRowCount());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetTypeData ( DBQueryResult &  res )

static

Definition at line 44 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res,
        "SELECT"
        "  t.typeID,"
        "  t.groupID,"
        "  t.typeName,"
        "  t.description,"
        "  t.radius,"
        "  t.mass,"
        "  t.volume,"
        "  t.capacity,"
        "  t.portionSize,"
        "  t.raceID,"
        "  t.basePrice,"
        "  t.published,"
        "  t.marketGroupID,"
        "  t.chanceOfDuplicating,"
        "  m.metaGroupID"
        " FROM invTypes AS t"
        " LEFT JOIN invMetaTypes AS m USING (typeID)"))
        codelog(DATABASE__ERROR, "Error in GetTypeData query: %s.", res.error.c_str());

    _log(DATABASE__RESULTS, "GetTypeData returned %u items", res.GetRowCount());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::GetWHSystemClass ( DBQueryResult &  res )

static

Definition at line 598 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT locationID, wormholeClassID FROM mapLocationWormholeClasses"))
        _log(DATABASE__ERROR, "Error in GetWHSystemClass query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::LoadCorpFactions ( std::map< uint32, uint32 > &  into )

static

Definition at line 170 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                                             {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT corporationID,factionID FROM crpNPCCorporations" )) {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return;
    }

    DBResultToUIntUIntDict(res, into);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::LoadFactionConstellations ( std::map< int32, PyRep * > &  into )

static

Definition at line 216 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                                                      {
    DBQueryResult res;
    //this is not quite right, but its good enough.
    if (!sDatabase.RunQuery(res, "SELECT factionID,constellationID FROM mapConstellations WHERE factionID IS NOT NULL" ))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return;
    }
    DBResultToIntIntlistDict(res, into);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::LoadFactionRaces ( std::map< int32, PyRep * > &  into )

static

Definition at line 238 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                                             {
    DBQueryResult res;
    //this is not quite right, but its good enough.
    if (!sDatabase.RunQuery(res, "SELECT factionID,raceID FROM facRaces WHERE factionID IS NOT NULL"))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return;
    }
    DBResultToIntIntlistDict(res, into);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::LoadFactionRegions ( std::map< int32, PyRep * > &  into )

static

Definition at line 205 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                                               {
    DBQueryResult res;
    //this is not quite right, but its good enough.
    if (!sDatabase.RunQuery(res, "SELECT factionID,regionID FROM mapRegions WHERE factionID IS NOT NULL"))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return;
    }
    DBResultToIntIntlistDict(res, into);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::LoadFactionSolarSystems ( std::map< int32, PyRep * > &  into )

static

Definition at line 227 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                                                    {
    DBQueryResult res;
    //this is not quite right, but its good enough.
    if (!sDatabase.RunQuery(res, "SELECT factionID,solarSystemID FROM mapSolarSystems WHERE factionID IS NOT NULL"))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return;
    }
    DBResultToIntIntlistDict(res, into);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::LoadFactionStationCounts ( std::map< uint32, uint32 > &  into )

static

Definition at line 180 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                                                     {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT factionID, COUNT(DISTINCT staStations.stationID) FROM crpNPCCorporations"
        " LEFT JOIN staStations USING (corporationID)"
        " GROUP BY factionID"))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return;
    }

    DBResultToUIntUIntDict(res, into);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::LoadFactionSystemCounts ( std::map< uint32, uint32 > &  into )

static

Definition at line 193 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                                                    {
    DBQueryResult res;
    //this is not quite right, but its good enough.
    if (!sDatabase.RunQuery(res, "SELECT factionID, COUNT(solarSystemID) FROM mapSolarSystems GROUP BY factionID"))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return;
    }

    DBResultToUIntUIntDict(res, into);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::LoadNPCCorpFactionData ( DBQueryResult &  res )

static

Definition at line 86 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT corporationID, factionID FROM crpNPCCorporations" ))
        codelog(DATABASE__ERROR, "Error in LoadCorpFactionData query: %s", res.error.c_str());

    _log(DATABASE__RESULTS, "LoadCorpFactionData returned %u items", res.GetRowCount());
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyDict * ManagerDB::LoadNPCCorpInfo ( )

static

Definition at line 249 of file ManagerDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                   {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT"
        "   crp.corporationName,"
        "   ncrp.corporationID,"
        "   ncrp.size, ncrp.extent, ncrp.solarSystemID,"
        "   ncrp.factionID, ncrp.sizeFactor, ncrp.stationCount, ncrp.stationSystemCount,"
        "   crp.stationID, crp.ceoID, chr.characterName AS ceoName"
        " FROM crpNPCCorporations AS ncrp"
        "  LEFT JOIN crpCorporation AS crp ON ncrp.corporationID = crp.corporationID"
        "  LEFT JOIN chrNPCCharacters AS chr ON ceoID=chr.characterID"))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToIntRowDict(res, 1);
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool ManagerDB::LoadSystemRoids	(	uint32	systemID,
		uint32 &	beltID,
		std::vector< AsteroidData > &	into
	)

Definition at line 508 of file ManagerDB.cpp.

References _log, AsteroidData::beltID, DBerror::c_str(), DBQueryResult::error, DBQueryResult::GetRow(), DBQueryResult::GetRowCount(), AsteroidData::itemID, AsteroidData::itemName, AsteroidData::position, AsteroidData::quantity, AsteroidData::radius, sDatabase, AsteroidData::systemID, and AsteroidData::typeID.

Referenced by BeltMgr::Load().

{
    DBQueryResult res;
    if(!sDatabase.RunQuery(res,
        "SELECT itemID, itemName, typeID, systemID, beltID, quantity, radius, x, y, z"
        " FROM sysAsteroids"
        " WHERE systemID = %u"
        "  AND beltID = %u", systemID, beltID)) {
        _log(DATABASE__ERROR, "Error in LoadSystemRoids query: %s", res.error.c_str());
        return false;
    }

    _log(DATABASE__RESULTS, "LoadSystemRoids returned %u items", res.GetRowCount());
    DBResultRow row;
    while(res.GetRow(row)) {
        AsteroidData entry = AsteroidData();
        entry.itemID = row.GetInt(0);
        entry.itemName = row.GetText(1);
        entry.typeID = row.GetInt(2);
        entry.systemID = row.GetInt(3);
        entry.beltID = row.GetInt(4);
        entry.quantity = row.GetDouble(5);
        entry.radius = row.GetDouble(6);
        GPoint pos(row.GetDouble(7), row.GetDouble(8), row.GetDouble(9));
        entry.position = pos;
        into.push_back(entry);
    }

    return !into.empty();
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::RemoveAsteroid

(

uint32

asteroidID

)

Definition at line 539 of file ManagerDB.cpp.

References sDatabase.

Referenced by BeltMgr::RemoveAsteroid().

{
    DBerror err;
    sDatabase.RunQuery(err, "DELETE FROM sysAsteroids WHERE itemID = %u", asteroidID);
}

Here is the caller graph for this function:

void ManagerDB::SaveActiveDungeon ( Dungeon::ActiveData &  dun )

static

Definition at line 676 of file ManagerDB.cpp.

References _log, DBerror::c_str(), Dungeon::ActiveData::dunExpiryTime, Dungeon::ActiveData::dunItemID, Dungeon::ActiveData::dunTemplateID, sDatabase, Dungeon::ActiveData::state, Dungeon::ActiveData::systemID, Dungeon::ActiveData::x, Dungeon::ActiveData::y, and Dungeon::ActiveData::z.

{
    DBerror err;
    if (!sDatabase.RunQuery(err,
        "INSERT INTO dunActive" //Active Dungeons
        " (systemID, dungeonID, state, dunTemplateID, dunExpiryTime, xpos, ypos, zpos)"
        " VALUES "
        "(%u, %u, %u, %u, %li, %f, %f, %f)",
        dun.systemID, dun.dunItemID, dun.state, dun.dunTemplateID, dun.dunExpiryTime, dun.x, dun.y, dun.z ))
    {
        _log(DATABASE__ERROR, "SaveActiveDungeon - unable to save dungeon: %s", err.c_str());
    }
}

Here is the call graph for this function:

void ManagerDB::SaveAnomaly

(

CosmicSignature &

sig

)

Definition at line 325 of file ManagerDB.cpp.

References _log, CosmicSignature::dungeonType, CosmicSignature::position, CosmicSignature::scanAttributeID, sDatabase, CosmicSignature::sigGroupID, CosmicSignature::sigID, CosmicSignature::sigItemID, CosmicSignature::sigName, CosmicSignature::sigTypeID, CosmicSignature::systemID, Ga::GaVec3::x, Ga::GaVec3::y, and Ga::GaVec3::z.

Referenced by AnomalyMgr::SaveAnomaly().

{// sysSignatures (sigID,sigItemID,dungeonType,sigName,systemID,sigTypeID,sigGroupID,scanGroupID,scanAttributeID,x,y,z)
    DBerror err;
    if (!sDatabase.RunQuery(err,
        "INSERT INTO sysSignatures"
        " (sigID,sigItemID,dungeonType,sigName,systemID,sigTypeID,sigGroupID,scanGroupID,scanAttributeID,x,y,z)"
        " VALUES ('%s', %u, %u, '%s', %u, %u, %u, %u, %u, %f, %f, %f)", \
            sig.sigID.c_str(), sig.sigItemID, sig.dungeonType, sig.sigName.c_str(), sig.systemID, sig.sigTypeID, sig.sigGroupID, \
            sig.scanGroupID, sig.scanAttributeID, sig.position.x, sig.position.y, sig.position.z )) {
        _log(DATABASE__ERROR, "SaveActiveDungeon - unable to save dungeon");
        }
}

Here is the caller graph for this function:

void ManagerDB::SaveRoid

(

AsteroidData &

data

)

Definition at line 552 of file ManagerDB.cpp.

References _log, DBerror::c_str(), AsteroidData::itemID, AsteroidData::quantity, AsteroidData::radius, and sDatabase.

{
    DBerror err;
    if (!sDatabase.RunQuery(err,
        "UPDATE sysAsteroids"
        " SET quantity = %f,"
        " radius = %f"
        " WHERE itemID = %u",
        data.quantity, data.radius, data.itemID))
    {
        _log(DATABASE__ERROR, "SaveSystemRoids - unable to save roids - %s", err.c_str());
    }
}

Here is the call graph for this function:

void ManagerDB::SaveStatisticData ( StatisticData &  data )

static

Definition at line 723 of file ManagerDB.cpp.

References _log, DBerror::c_str(), GetFileTimeNow(), StatisticData::iskMarket, StatisticData::npcBounties, StatisticData::oreMined, StatisticData::pcBounties, StatisticData::pcMissiles, StatisticData::pcShots, StatisticData::probesLaunched, StatisticData::ramJobs, sDatabase, StatisticData::shipsSalvaged, StatisticData::sitesScanned, and StatisticData::span.

Referenced by StatisticMgr::SaveData().

{
    DBerror err;
    if (!sDatabase.RunQuery(err,
        "INSERT INTO srvStatisticData"
        " (timeStamp, timeSpan, pcShots, pcMissiles, ramJobs, shipsSalvaged, pcBounties, npcBounties, oreMined, iskMarket, probesLaunched, sitesScanned)"
        " VALUES "
        "(%f, %u, %u, %u, %u, %u, %f, %f, %f, %f, %u, %u)", GetFileTimeNow(),
        data.span, data.pcShots, data.pcMissiles, data.ramJobs, data.shipsSalvaged, data.pcBounties, data.npcBounties, data.oreMined, data.iskMarket, data.probesLaunched, data.sitesScanned ))
    {
        _log(DATABASE__ERROR, "SaveStatisticData - unable to save data: %s", err.c_str());
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::SaveSystemRoids	(	uint32	systemID,
		std::vector< AsteroidData > &	roids
	)

Definition at line 566 of file ManagerDB.cpp.

References _log, DBerror::c_str(), and sDatabase.

Referenced by BeltMgr::Save().

{
    std::ostringstream Inserts;
    // start the insert into command.
    Inserts << "INSERT INTO sysAsteroids";
    Inserts << " (itemID,itemName,typeID,systemID,beltID,quantity,radius,x, y, z)";
    bool first = true;
    for (auto cur : roids) {
        if (first) {
            Inserts << " VALUES ";
            first = false;
        } else {
            Inserts << ", ";
        }
        // itemID and attributeID keys.
        Inserts << "(" << cur.itemID << ", '" << cur.itemName << "', " << cur.typeID << ", " << systemID << ", " << cur.beltID << ", ";
        Inserts << cur.quantity << ", " << cur.radius << ", " << std::to_string(cur.position.x) << ", " << std::to_string(cur.position.y);
        Inserts << ", " << std::to_string(cur.position.z) << ")";
    }
    // did we get at least 1 insert?
    if (!first) {
        // finish creating the command.
        Inserts << "ON DUPLICATE KEY UPDATE ";
        Inserts << "quantity=VALUES(quantity), ";
        Inserts << "radius=VALUES(radius)";
        // execute the command.
        DBerror err;
        if (!sDatabase.RunQuery(err, Inserts.str().c_str()))
            _log(DATABASE__ERROR, "SaveSystemRoids - unable to save roids - %s", err.c_str());
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

void ManagerDB::UpdateStatisticHistory ( StatisticData &  data )

static

Definition at line 737 of file ManagerDB.cpp.

References _log, DBerror::c_str(), StatisticData::iskMarket, StatisticData::npcBounties, StatisticData::oreMined, StatisticData::pcBounties, StatisticData::pcMissiles, StatisticData::pcShots, StatisticData::probesLaunched, StatisticData::ramJobs, sDatabase, StatisticData::shipsSalvaged, and StatisticData::sitesScanned.

Referenced by StatisticMgr::CompileData(), and StatisticMgr::Initialize().

{
    DBerror err;
    if (!sDatabase.RunQuery(err,
        "UPDATE srvStatisticHistory"
        " SET pcShots=%u, pcMissiles=%u, ramJobs=%u, shipsSalvaged=%u, pcBounties=%f, npcBounties=%f, oreMined=%f, iskMarket=%f, probesLaunched=%u, sitesScanned=%u"
        " WHERE idx = 1",
        data.pcShots, data.pcMissiles, data.ramJobs, data.shipsSalvaged, data.pcBounties, data.npcBounties,
        data.oreMined, data.iskMarket, data.probesLaunched, data.sitesScanned ))
    {
        _log(DATABASE__ERROR, "srvStatisticHistory - unable to save data: %s", err.c_str());
    }
}

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/system/cosmicMgrs/ManagerDB.h
• /backups/local/src/eve/EvEmu_Crucible/src/eve-server/system/cosmicMgrs/ManagerDB.cpp