ConfigDB Class Reference

#include "ConfigDB.h"

Inheritance diagram for ConfigDB:

Collaboration diagram for ConfigDB:

Public Member Functions
PyRep *	GetMultiOwnersEx (const std::vector< int32 > &entityIDs)
PyRep *	GetMultiLocationsEx (const std::vector< int32 > &entityIDs)
PyRep *	GetMultiStationEx (const std::vector< int32 > &entityIDs)
PyRep *	GetMultiAllianceShortNamesEx (const std::vector< int32 > &entityIDs)
PyRep *	GetMultiCorpTickerNamesEx (const std::vector< int32 > &entityIDs)
PyRep *	GetMultiGraphicsEx (const std::vector< int32 > &entityIDs)
PyRep *	GetMultiInvTypesEx (const std::vector< int32 > &typeIDs)
PyObject *	GetUnits ()
PyObjectEx *	GetMapObjects (uint32 entityID, bool wantRegions, bool wantConstellations, bool wantSystems, bool wantStations)
PyObject *	GetMap (uint32 solarSystemID)
PyObject *	GetMapOffices (uint32)
PyObject *	GetMapConnections (uint32, bool, bool, bool, uint16, uint16)
PyObject *	ListLanguages ()
PyRep *	GetStationSolarSystemsByOwner (uint32 ownerID)
PyRep *	GetCelestialStatistic (uint32 celestialID)
PyRep *	GetTextsForGroup (const std::string &langID, uint32 textgroup)
PyObject *	GetMapLandmarks ()
PyRep *	GetDynamicCelestials (uint32 solarSystemID)
	Retrieves dynamic, celestial objects for a given solar system. More...
Public Member Functions inherited from ServiceDB
uint32	GetStationOwner (uint32 stationID)

Additional Inherited Members
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)
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 36 of file ConfigDB.h.

Member Function Documentation

PyRep * ConfigDB::GetCelestialStatistic

(

uint32

celestialID

)

Definition at line 415 of file ConfigDB.cpp.

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

                                                         {
    //  corrected db query  -allan 8Dec14
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT"
        "   celestialID,"
        "   temperature,"
        "   spectralClass,"
        "   luminosity,"
        "   age,"
        "   life,"
        "   orbitRadius,"
        "   eccentricity,"
        "   massDust,"
        "   massGas,"
        "   fragmented,"
        "   density,"
        "   surfaceGravity,"
        "   escapeVelocity,"
        "   orbitPeriod,"
        "   rotationRate,"
        "   locked,"
        "   pressure,"
        "   radius,"
        "   mass"
        " FROM mapCelestialStatistics"
        " WHERE celestialID = %u", celestialID))
        {
            codelog(DATABASE__ERROR, "Error in GetCelestialStatistic query: %s", res.error.c_str());
            return new PyInt(0);
        }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * ConfigDB::GetDynamicCelestials

(

uint32

solarSystemID

)

Retrieves dynamic, celestial objects for a given solar system.

Parameters

[in]

solarSystemID

ID of the solar system whose objects are being retrieved

Author

allan

Definition at line 450 of file ConfigDB.cpp.

References DBerror::c_str(), codelog, DBResultToCRowset(), DBQueryResult::error, maxNPCStation, sDatabase, and EVEDB::invGroups::Station.

                                                          {
    //  corrected query and return type per packet info
    //      this returns ONLY OUTPOSTS.  -allan 8Dec14
    /* this packet is from a crowded (73 items) system (including pos'), yet is only return from this call.
              [PyObjectEx Type2]
                [PyTuple 2 items]
                  [PyTuple 1 items]
                    [PyToken dbutil.CRowset]
                  [PyDict 1 kvp]
                    [PyString "header"]
                [PyPackedRow 50 bytes]
                  ["groupID" => <15> [I2]]
                  ["typeID" => <21645> [I4]]    <-- Gallente Administrative Outpost
                  ["itemID" => <61000562> [I4]]
                  ["itemName" => <5E-EZC VI - X333 GEORGIOU'S PLACE> [WStr]]
                  ["locationID" => <30004168> [I4]]
                  ["orbitID" => <40264214> [I4]]
                  ["connector" => <0> [I4]]
                  ["x" => <-435188244480> [R8]]
                  ["y" => <27742740480> [R8]]
                  ["z" => <430524948480> [R8]]
                  ["celestialIndex" => <6> [UI1]]
                  ["orbitIndex" => <0> [UI1]]
                  */

    DBQueryResult result;
    if (!sDatabase.RunQuery(result,
        "SELECT"
        "   groupID,"
        "   typeID,"
        "   itemID,"
        "   itemName,"
        "   solarSystemID AS locationID,"
        "   IFNULL(orbitID, 0) AS orbitID,"
        "   0 AS connector,"     //this is connector field....have only seen 0 in server packets.
        "   x, y, z,"
        "   celestialIndex,"    //  this index denotes which planet this item orbits (PLANET #....NOT moon #)
        "   orbitIndex"         //  this index denotes which asteroid belt this item belongs to
        " FROM mapDenormalize"
        " WHERE solarSystemID = %u"
        " AND groupID = %d"
        " AND itemID > %d",   //this is min itemid for outposts   (pos' do NOT go here)
        solarSystemID, EVEDB::invGroups::Station, maxNPCStation )) {
        codelog(DATABASE__ERROR, "Error in GetDynamicCelestials query: %s", result.error.c_str());
            return new PyInt(0);
    }

    return DBResultToCRowset(result);
}

Here is the call graph for this function:

PyObject * ConfigDB::GetMap

(

uint32

solarSystemID

)

Definition at line 344 of file ConfigDB.cpp.

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

                                               {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT "
        "   s.solarSystemID AS locationID,"
        "   s.xMin, s.xMax, s.yMin,"
        "   s.yMax, s.zMin, s.zMax,"
        "   s.luminosity,"
        "   d.x, d.y, d.z,"
        "   d.itemID,"
        "   d.itemName,"
        "   d.typeID,"
        "   d.orbitID,"
        "   j.celestialID AS destinations"
        " FROM mapSolarSystems AS s"
        "  LEFT JOIN mapDenormalize AS d USING (solarSystemID)"
        "  LEFT JOIN mapJumps AS j ON j.stargateID = d.itemID"
        " WHERE solarSystemID=%u", solarSystemID
    )) {
        codelog(DATABASE__ERROR, "Error in GetMap query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyObject * ConfigDB::GetMapConnections	(	uint32	id,
		bool	sol,
		bool	reg,
		bool	con,
		uint16	cel,
		uint16	_c
	)

Todo:

more map data in /eve/client/script/ui/shared/maps/mapcommon.py

Definition at line 521 of file ConfigDB.cpp.

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

                                                                                                    {
  sLog.Warning ("ConfigDB::GetMapConnections", "DB query - System:%u, Sol:%u, Reg:%u, Con:%u, Cel:%u, cached:%u", id, sol, reg, con, cel, _c);
    const char *key = "fromsol";
    if (sol) {
        key = "fromsol";
    } else if (reg) {
        key = "fromreg";
    } else if (con) {
        key = "fromcon";
    } else {
        sLog.Error ("ConfigDB::GetMapConnections()", "Bad argument (id: %u, sol: %u, reg: %u, con: %u) passed to key.", id, sol, reg, con );
    }

    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT ctype, fromreg, fromcon, fromsol, stargateID, celestialID, tosol, tocon, toreg"
        " FROM mapConnections"
        " WHERE %s = %u", key, id )) {
        codelog(DATABASE__ERROR, "Error in GetMapConnections query: %s", res.error.c_str());
            sLog.Error ("ConfigDB::GetMapConnections()", "No Data for key: %s, id: %u.", key, id);
            return nullptr;
    }
    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyObject * ConfigDB::GetMapLandmarks

(

)

Definition at line 546 of file ConfigDB.cpp.

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

                                    {    // working 29June14
    DBQueryResult res;

      if (!sDatabase.RunQuery(res,
          "SELECT"
          "   landmarkID,"
          "   landmarkName,"
          "   0 AS landmarkNameID,"
          "   x, y, z,"
          "   radius"
          " FROM mapLandmarks" ))
      {
          codelog(DATABASE__ERROR, "Error in GetMapLandmarks query: %s", res.error.c_str());
          return nullptr;
      }
    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyObjectEx * ConfigDB::GetMapObjects	(	uint32	entityID,
		bool	wantRegions,
		bool	wantConstellations,
		bool	wantSystems,
		bool	wantStations
	)

Definition at line 314 of file ConfigDB.cpp.

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

{       //  corrected query  -allan 8Dec14
    const char *key = "solarSystemID";
    if (wantRegions) {
        entityID = 3;   /* a little hackish... */
        key = "typeID";
    } else if (wantConstellations) {
        key = "regionID";
    } else if (wantSystems) {
        key = "constellationID";
    } else if (wantStations) {
        key = "solarSystemID";
    }

    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT "
        "   groupID, typeID, itemID, itemName,"
        "   solarSystemID AS locationID, IFNULL(orbitID, 0) AS orbitID,"
        "   x, y, z"
        " FROM mapDenormalize"
        " WHERE %s=%u", key, entityID )) {
        codelog(DATABASE__ERROR, "Error in GetMapObjects query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyObject * ConfigDB::GetMapOffices

(

uint32

solarSystemID

)

Definition at line 510 of file ConfigDB.cpp.

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

                                                      {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT corporationID, stationID FROM staStations WHERE solarSystemID=%u", solarSystemID)) {
        codelog(DATABASE__ERROR, "Error in GetMapOffices query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * ConfigDB::GetMultiAllianceShortNamesEx

(

const std::vector< int32 > &

entityIDs

)

Definition at line 165 of file ConfigDB.cpp.

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

                                                                               {
    std::string ids;
    ListToINString(entityIDs, ids);
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT allianceID, shortName FROM alnAlliance WHERE allianceID IN (%s)", ids.c_str() )) {
        codelog(DATABASE__ERROR, "Error in GetMultiAllianceShortNamesEx query: %s", res.error.c_str());
        return new PyInt(0);
    }

    return DBResultToTupleSet(res);
}

Here is the call graph for this function:

PyRep * ConfigDB::GetMultiCorpTickerNamesEx

(

const std::vector< int32 > &

entityIDs

)

Definition at line 262 of file ConfigDB.cpp.

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

{
    std::string ids;
    ListToINString(entityIDs, ids);
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT "
        "   corporationID, tickerName,"
        "   shape1, shape2, shape3,"
        "   color1, color2, color3 "
        " FROM crpCorporation"
        " WHERE corporationID in (%s)", ids.c_str()))
    {
        codelog(DATABASE__ERROR, "Error in GetMultiCorpTickerNamesEx query: %s", res.error.c_str());
        return new PyInt(0);
    }

    return DBResultToRowList(res);
}

Here is the call graph for this function:

PyRep * ConfigDB::GetMultiGraphicsEx

(

const std::vector< int32 > &

entityIDs

)

Definition at line 283 of file ConfigDB.cpp.

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

                                                                     {

    std::string ids;
    ListToINString(entityIDs, ids);

    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT"
        "   graphicID, url3D, urlWeb, icon, urlSound, explosionID"
        " FROM eveGraphics "
        " WHERE graphicID in (%s)", ids.c_str()))
    {
        codelog(DATABASE__ERROR, "Error in GetMultiGraphicsEx query: %s", res.error.c_str());
        return new PyInt(0);
    }

    return DBResultToRowList(res);
}

Here is the call graph for this function:

PyRep * ConfigDB::GetMultiInvTypesEx

(

const std::vector< int32 > &

typeIDs

)

Definition at line 381 of file ConfigDB.cpp.

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

                                                                     {
    std::string ids;
    ListToINString(entityIDs, ids);
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT"
        "   typeID,groupID,typeName,description,graphicID,radius,"
        "   mass,volume,capacity,portionSize,raceID,basePrice,"
        "   published,marketGroupID,chanceOfDuplicating "
        " FROM invTypes "
        " WHERE typeID in (%s)", ids.c_str()))
    {
        codelog(DATABASE__ERROR, "Error in GetMultiInvTypesEx query: %s", res.error.c_str());
        return new PyInt(0);
    }

    return DBResultToRowList(res);
}

Here is the call graph for this function:

PyRep * ConfigDB::GetMultiLocationsEx

(

const std::vector< int32 > &

entityIDs

)

Definition at line 177 of file ConfigDB.cpp.

References DBerror::c_str(), codelog, DBResultToTupleSet(), DBQueryResult::error, IsAsteroidID, IsStaticItem, ListToINString(), sDatabase, and sLog.

                                                                      {
    // this is locations only....region, const, system, station, ship
    // wtf are asteroids seen in this call???
    std::vector<int32> staticItems, dynamicItems, asteroidItems;
    staticItems.clear();
    dynamicItems.clear();
    asteroidItems.clear();

    for (auto cur : entityIDs) {
        if (IsStaticItem(cur)) {
            staticItems.push_back(cur);
        } else if (IsAsteroidID(cur)) {
            asteroidItems.push_back(cur);
        } else {
            dynamicItems.push_back(cur);
        }
    }

    DBQueryResult res;
    std::string ids = "";

    if (staticItems.size()) {
        ListToINString(staticItems, ids);
        if (!sDatabase.RunQuery(res,
            "SELECT "
            " itemID AS locationID,"
            " itemName AS locationName,"
            " x, y, z,"
            " itemNameID AS locationNameID"   //locationName = localization.GetByMessageID(self.locationNameID)
            " FROM mapDenormalize"
            " WHERE itemID in (%s)", ids.c_str()))
        {
            codelog(DATABASE__ERROR, "Error in GetMultiLocationsEx query: %s", res.error.c_str());
        }
        ids = "";
    }

    if (dynamicItems.size()) {
        ListToINString(dynamicItems, ids);
        if (!sDatabase.RunQuery(res,
            "SELECT "
            " itemID AS locationID,"
            " itemName AS locationName,"
            " x, y, z,"
            " NULL AS locationNameID"
            " FROM entity"
            " WHERE itemID in (%s)", ids.c_str()))
        {
            codelog(DATABASE__ERROR, "Error in GetMultiLocationsEx query: %s", res.error.c_str());
        }
        ids = "";
    }

    if (asteroidItems.size()) {
        ListToINString(asteroidItems, ids);
        sLog.Warning("GetMultiLocationsEx", "Asteroid Items (%s) requested.", ids.c_str());
        if (!sDatabase.RunQuery(res,
            "SELECT "
            " itemID AS locationID,"
            " itemName AS locationName,"
            " x, y, z,"
            " NULL AS locationNameID"
            " FROM sysAsteroids"
            " WHERE itemID in (%s)", ids.c_str()))
        {
            codelog(DATABASE__ERROR, "Error in GetMultiLocationsEx query: %s", res.error.c_str());
        }
    }

    return DBResultToTupleSet(res);
}

Here is the call graph for this function:

PyRep * ConfigDB::GetMultiOwnersEx

(

const std::vector< int32 > &

entityIDs

)

Definition at line 31 of file ConfigDB.cpp.

References DBerror::c_str(), codelog, LSC::corp, DBResultToTupleSet(), DBQueryResult::error, IsAlliance, IsCharacterID, IsCorp, IsStationID, ListToINString(), Profile::npc, and sDatabase.

                                                                   {
    // separate list of ids into respective groups
    std::vector<int32> player, corp, ally, owner, npc, station;
    player.clear();
    corp.clear();
    ally.clear();
    owner.clear();
    npc.clear();
    station.clear();

    for (auto cur : entityIDs) {
        if (IsCorp(cur)) {
            corp.push_back(cur);
        } else if (IsAlliance(cur)) {
            ally.push_back(cur);
        } else if (IsCharacterID(cur)) {
            player.push_back(cur);
        } else if (cur < 33000) {
            npc.push_back(cur);
        } else if (IsStationID(cur)) {
            station.push_back(cur);
        } else {
            owner.push_back(cur);
        }

        // add check here for trader joe.
        //  will have to hardcode data, then run thru db query cause i dont know how to build packet for this return
    }

    DBQueryResult res;
    std::string ids = "";

    if (corp.size()) {
        ListToINString(corp, ids);
        if (!sDatabase.RunQuery(res,
            "SELECT "
            "  corporationID AS ownerID,"
            "  corporationName AS ownerName,"
            "  2 AS typeID,"                    // corp typeID
            "  false AS gender,"
            "  NULL AS ownerNameID"             // this is a messageID - have not taken time to find and insert
            " FROM crpCorporation"
            " WHERE corporationID IN (%s)", ids.c_str()))
        {
            codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        }
        ids = "";
    }

    if (ally.size()) {
        ListToINString(ally, ids);
        if (!sDatabase.RunQuery(res,
            "SELECT "
            "  allianceID AS ownerID,"
            "  allianceName AS ownerName,"
            "  16159 AS typeID,"                 // alliance typeID.
            "  false AS gender,"
            "  NULL AS ownerNameID"
            " FROM alnAlliance"
            " WHERE allianceID IN (%s)", ids.c_str()))
        {
            codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        }
        ids = "";
    }

    if (player.size()) {
        ListToINString(player, ids);
        if (!sDatabase.RunQuery(res,
            "SELECT "
            "  characterID AS ownerID,"
            "  characterName AS ownerName,"
            "  typeID,"
            "  gender,"
            "  NULL AS ownerNameID"
            " FROM chrCharacters"
            " WHERE characterID IN (%s)", ids.c_str()))
        {
            codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        }
        ids = "";
    }

    if (npc.size()) {
        ListToINString(npc, ids);
        if (!sDatabase.RunQuery(res,
            "SELECT "
            "  typeID AS ownerID,"
            "  typeName AS ownerName,"
            "  typeID,"
            "  1 AS gender,"
            "  typeNameID AS ownerNameID"
            " FROM invTypes"
            " WHERE typeID IN (%s)", ids.c_str()))
        {
            codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        }
        ids = "";
    }

    if (station.size()) {
        ListToINString(station, ids);
        if (!sDatabase.RunQuery(res,
            "SELECT "
            "  corporationID AS ownerID,"
            "  corporationName AS ownerName,"
            "  2 AS typeID"                    // corp typeID
            " FROM crpCorporation"
            " WHERE corporationID IN (SELECT corporationID FROM staStations WHERE stationID IN (%s))", ids.c_str()))
        {
            codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        }
        ids = "";
    }

    if (owner.size()) {
        ListToINString(owner, ids);
        if (!sDatabase.RunQuery(res,
            "SELECT "
            "  ownerID,"
            "  ownerName,"
            "  typeID,"
            "  true AS gender,"
            "  NULL AS ownerNameID"
            " FROM eveStaticOwners"
            " WHERE ownerID IN (%s)", ids.c_str()))
        {
            codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        }
    }

    return DBResultToTupleSet(res);
}

Here is the call graph for this function:

PyRep * ConfigDB::GetMultiStationEx

(

const std::vector< int32 > &

entityIDs

)

Definition at line 249 of file ConfigDB.cpp.

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

{
    std::string ids;
    ListToINString(entityIDs, ids);
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT stationID, stationName, stationTypeID, solarSystemID, x, y, z FROM staStations WHERE stationID in (%s)", ids.c_str())) {
        codelog(DATABASE__ERROR, "Error in GetMultiStationEx query: %s", res.error.c_str());
    }

    return DBResultToTupleSet(res);
}

Here is the call graph for this function:

PyRep * ConfigDB::GetStationSolarSystemsByOwner

(

uint32

ownerID

)

Definition at line 400 of file ConfigDB.cpp.

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

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

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * ConfigDB::GetTextsForGroup	(	const std::string &	langID,
		uint32	textgroup
	)

Definition at line 500 of file ConfigDB.cpp.

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

                                                                            {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT textLabel, `text` FROM intro WHERE langID = '%s' AND textgroup = %u", langID.c_str(), textgroup)) {
        codelog(DATABASE__ERROR, "Error in GetTextsForGroup query: %s", res.error.c_str());
        return new PyInt(0);
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyObject * ConfigDB::GetUnits

(

)

Definition at line 303 of file ConfigDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT unitID, unitName, displayName FROM eveUnits")) {
        codelog(DATABASE__ERROR, "Error in GetUnits query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToIndexRowset(res, "unitID");
}

Here is the call graph for this function:

PyObject * ConfigDB::ListLanguages

(

)

Definition at line 370 of file ConfigDB.cpp.

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

                                  {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT languageID,languageName,translatedLanguageName FROM languages")) {
        codelog(DATABASE__ERROR, "Error in ListLanguages query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

---

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

• /backups/local/src/eve/EvEmu_Crucible/src/eve-server/config/ConfigDB.h
• /backups/local/src/eve/EvEmu_Crucible/src/eve-server/config/ConfigDB.cpp