InventoryDB Class Reference

#include "InventoryDB.h"

Inheritance diagram for InventoryDB:

Collaboration diagram for InventoryDB:

Public Member Functions
bool	GetCharacterType (uint8 bloodlineID, CharacterTypeData &into)
bool	GetBloodlineByCharacterType (uint16 characterTypeID, uint8 &bloodlineID)
bool	GetCharacterType (uint16 characterTypeID, uint8 &bloodlineID, CharacterTypeData &into)
bool	GetCharacterTypeByBloodline (uint8 bloodlineID, uint16 &characterTypeID, CharacterTypeData &into)
bool	GetShipType (uint16 shipTypeID, ShipTypeData &into)
bool	GetItemContents (OwnerData &od, std::vector< uint32 > &into)
bool	GetItemContents (uint32 itemID, EVEItemFlags flag, std::vector< uint32 > &into)
bool	GetItemContents (uint32 itemID, EVEItemFlags flag, uint32 ownerID, std::vector< uint32 > &into)
bool	GetCharacterData (uint32 characterID, CharacterData &into)
bool	GetCorpData (uint32 characterID, CorpData &into)
bool	GetCelestialObject (uint32 celestialID, CelestialObjectData &into)
bool	GetSolarSystem (uint32 solarSystemID, SolarSystemData &into)
Public Member Functions inherited from ServiceDB
uint32	GetStationOwner (uint32 stationID)

Static Public Member Functions
static bool	GetCharacterTypeByBloodline (uint8 bloodlineID, uint16 &characterTypeID)
static void	DeleteTrackingCans ()
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
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 39 of file InventoryDB.h.

Member Function Documentation

void InventoryDB::DeleteTrackingCans ( )

static

Definition at line 244 of file InventoryDB.cpp.

References sDatabase.

Referenced by ItemFactory::Initialize(), and ItemFactory::SaveItems().

{
    DBerror err;
    sDatabase.RunQuery(err, "DELETE FROM entity WHERE customInfo LIKE '%Position Test%'");  // 90.63s on main, 0.037s on dev
    //sDatabase.RunQuery(err, "DELETE FROM entity WHERE itemName LIKE '%Bubble%'");         // 66.75s on main, 0.036s on dev
}

Here is the caller graph for this function:

bool InventoryDB::GetBloodlineByCharacterType	(	uint16	characterTypeID,
		uint8 &	bloodlineID
	)

Obtains ID of bloodline based on character type.

Parameters

[in]	characterTypeID	ID of character type.
[out]	bloodlineID	Resulting ID of bloodline.

Returns

True on success, false on failure.

Definition at line 109 of file InventoryDB.cpp.

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

Referenced by GetCharacterType().

                                                                                        {
    DBQueryResult res;
    if(!sDatabase.RunQuery(res, "SELECT bloodlineID FROM bloodlineTypes WHERE typeID = %u", characterTypeID)) {
        codelog(DATABASE__ERROR, "Failed to query character type %u: %s.", characterTypeID, res.error.c_str());
        return false;
    }

    DBResultRow row;
    if(!res.GetRow(row)) {
        _log(DATABASE__MESSAGE, "No data for character type %u.", characterTypeID);
        return false;
    }

    bloodlineID = row.GetUInt(0);

    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool InventoryDB::GetCelestialObject	(	uint32	celestialID,
		CelestialObjectData &	into
	)

Todo:

update these below to use static data manager

Definition at line 458 of file InventoryDB.cpp.

References _log, DBerror::c_str(), CelestialObjectData::celestialIndex, codelog, DBQueryResult::error, DBResultRow::GetDouble(), DBQueryResult::GetRow(), DBResultRow::GetUInt(), DBResultRow::IsNull(), IsStaticMapItem, CelestialObjectData::orbitIndex, CelestialObjectData::radius, sDatabase, and CelestialObjectData::security.

                                                                                  {
    DBQueryResult res;

    if( IsStaticMapItem(celestialID)) {
        // This Celestial object is a static celestial, so get its data from the 'mapDenormalize' table:
        if(!sDatabase.RunQuery(res,
            "SELECT"
            "  security, radius, celestialIndex, orbitIndex"
            " FROM mapDenormalize"
            " WHERE itemID = %u",
            celestialID))
        {
            codelog(DATABASE__ERROR, "Failed to query celestial object %u: %s.", celestialID, res.error.c_str());
            return false;
        }

        DBResultRow row;
        if(!res.GetRow(row)) {
            _log(DATABASE__MESSAGE, "Static Celestial object %u not found.", celestialID);
            return false;
        }

        into.security = (row.IsNull(0) ? 0 : row.GetDouble(0));
        into.radius = row.GetDouble(1);
        into.celestialIndex = (row.IsNull(2) ? 0 : row.GetUInt(2));
        into.orbitIndex = (row.IsNull(3) ? 0 : row.GetUInt(3));
    } else {
        // Quite possibly, this Celestial object is a dynamic one, so try to get its data from the 'entity' table,
        // and if it's not there either, then flag an error.
        if(!sDatabase.RunQuery(res,
            "SELECT"
            "  entity.itemID, "
            "  invTypes.radius "
            " FROM entity "
            "  LEFT JOIN invTypes USING (typeID)"
            " WHERE entity.itemID = %u",
            celestialID))
        {
            codelog(DATABASE__ERROR, "Failed to query celestial object %u: %s.", celestialID, res.error.c_str());
            return false;
        }

        DBResultRow row;
        if(!res.GetRow(row)) {
            _log(DATABASE__MESSAGE, "Dynamic Celestial object %u not found.", celestialID);
            return false;
        }

        into.security = 1.0;
        into.radius = (row.IsNull(1) ? 1 : row.GetDouble(1));
        into.celestialIndex = 0;
        into.orbitIndex = 0;
    }

    return true;
}

Here is the call graph for this function:

bool InventoryDB::GetCharacterData	(	uint32	characterID,
		CharacterData &	into
	)

Todo:

fix these

Definition at line 251 of file InventoryDB.cpp.

References _log, CharacterData::accountID, CharacterData::ancestryID, CharacterData::aurBalance, CharacterData::balance, CharacterData::bloodlineID, CharacterData::bounty, DBerror::c_str(), CharacterData::capsuleID, CharacterData::careerID, CharacterData::careerSpecialityID, codelog, CharacterData::constellationID, CharacterData::createDateTime, CharacterData::description, DBQueryResult::error, CharacterData::flag, CharacterData::gender, DBResultRow::GetDouble(), DBResultRow::GetInt(), DBResultRow::GetInt64(), DBQueryResult::GetRow(), DBResultRow::GetText(), DBResultRow::GetUInt(), IsAgent, DBResultRow::IsNull(), CharacterData::locationID, CharacterData::logonMinutes, CharacterData::name, CharacterData::raceID, CharacterData::regionID, CharacterData::schoolID, sDatabase, CharacterData::securityRating, CharacterData::shipID, CharacterData::skillPoints, CharacterData::solarSystemID, CharacterData::stationID, CharacterData::title, and CharacterData::typeID.

                                                                          {
    DBQueryResult res;

    if (IsAgent(characterID)) {
        if(!sDatabase.RunQuery(res,
            "SELECT"
            "   0 as accountID,"
            "   title,"
            "   description,"
            "   gender,"
            "   bounty,"
            "   0 as balance,"
            "   0 as aurBalance,"
            "   securityRating,"
            "   0 as logonMinutes,"
            "   stationID,"
            "   solarSystemID,"
            "   constellationID,"
            "   regionID,"
            "   ancestryID,"
            "   0 AS bloodlineID,"      
            "   0 AS raceID,"
            "   careerID,"
            "   schoolID,"
            "   careerSpecialityID,"
            "   createDateTime,"
            "   0 as shipID,"       // update this when agents are in space
            "   0 as capsuleID,"
            "   flag,"
            "   name,"
            "   0 AS skillPoints,"
            "   typeID"
            " FROM chrNPCCharacters AS chr"
            " WHERE characterID = %u", characterID)) {
            codelog(DATABASE__ERROR, "Error in GetCharacter query: %s", res.error.c_str());
            return false;
            }
    } else {
        if(!sDatabase.RunQuery(res,
            "SELECT"
            "   accountID,"
            "   title,"
            "   description,"
            "   gender,"
            "   bounty,"
            "   balance,"
            "   aurBalance,"
            "   securityRating,"
            "   logonMinutes,"
            "   stationID,"
            "   solarSystemID,"
            "   constellationID,"
            "   regionID,"
            "   ancestryID,"
            "   bloodlineID,"
            "   raceID,"
            "   careerID,"
            "   schoolID,"
            "   careerSpecialityID,"
            "   createDateTime,"
            "   shipID,"
            "   capsuleID,"
            "   flag,"
            "   characterName,"
            "   skillPoints,"
            "   typeID"
            " FROM chrCharacters"
            " WHERE characterID = %u", characterID))
        {
            codelog(DATABASE__ERROR, "Error in GetCharacter query: %s", res.error.c_str());
            return false;
        }
    }

    DBResultRow row;
    if(!res.GetRow(row)) {
        _log(DATABASE__MESSAGE, "No data found for character %u.", characterID);
        return false;
    }

    into.accountID = row.IsNull( 0 ) ? 0 : row.GetUInt( 0 );
    into.title = row.GetText( 1 );
    into.description = row.GetText( 2 );
    into.gender = row.GetInt( 3 ) ? true : false;
    into.bounty = row.GetDouble( 4 );
    into.balance = row.GetDouble( 5 );
    into.aurBalance = row.GetDouble( 6 );
    into.securityRating = row.GetDouble( 7 );
    into.logonMinutes = row.GetUInt( 8 );
    into.stationID = row.GetUInt( 9 );
    into.solarSystemID = row.GetUInt( 10 );
    into.locationID = (into.stationID == 0 ? into.solarSystemID : into.stationID);
    into.constellationID = row.GetUInt( 11 );
    into.regionID = row.GetUInt( 12 );
    into.ancestryID = row.GetUInt( 13 );
    into.bloodlineID =  row.GetUInt( 14 );
    into.raceID = row.GetUInt( 15 );
    into.careerID =row.GetUInt( 16 );
    into.schoolID = row.GetUInt( 17 );
    into.careerSpecialityID = row.GetUInt( 18 );
    into.createDateTime = row.GetInt64( 19 );
    into.shipID = row.GetUInt( 20 );
    into.capsuleID = row.GetUInt( 21 );
    into.flag = row.GetUInt(22);
    into.name = row.GetText(23);
    into.skillPoints = row.GetUInt(24);
    into.typeID = row.GetUInt(25);

    return true;
}

Here is the call graph for this function:

bool InventoryDB::GetCharacterType	(	uint8	bloodlineID,
		CharacterTypeData &	into
	)

Loads character type data.

Parameters

[in]	bloodlineID	Bloodline to be loaded.
[out]	into	Where loaded data should be stored.

Returns

True on success, false on failure.

Todo:

most of this needs to go into static data

Definition at line 41 of file InventoryDB.cpp.

References _log, CharacterTypeData::bloodlineName, DBerror::c_str(), CharacterTypeData::charisma, codelog, CharacterTypeData::corporationID, CharacterTypeData::description, DBQueryResult::error, CharacterTypeData::femaleDescription, DBQueryResult::GetRow(), DBResultRow::GetText(), DBResultRow::GetUInt(), CharacterTypeData::intelligence, CharacterTypeData::maleDescription, CharacterTypeData::memory, CharacterTypeData::perception, CharacterTypeData::race, sDatabase, CharacterTypeData::shortDescription, CharacterTypeData::shortFemaleDescription, CharacterTypeData::shortMaleDescription, and CharacterTypeData::willpower.

Referenced by GetCharacterType(), and GetCharacterTypeByBloodline().

                                                                             {
    DBQueryResult res;

    if(!sDatabase.RunQuery(res,
        "SELECT"
        "  bloodlineName,"
        "  raceID,"
        "  description,"
        "  maleDescription,"
        "  femaleDescription,"
        "  corporationID,"
        "  perception,"
        "  willpower,"
        "  charisma,"
        "  memory,"
        "  intelligence,"
        "  shortDescription,"
        "  shortMaleDescription,"
        "  shortFemaleDescription "
        " FROM chrBloodlines "
        " WHERE bloodlineID = %u",
        bloodlineID))
    {
        codelog(DATABASE__ERROR, "Failed to query bloodline %u: %s.", bloodlineID, res.error.c_str());
        return false;
    }

    DBResultRow row;
    if(!res.GetRow(row)) {
        _log(DATABASE__MESSAGE, "No data found for bloodline %u.", bloodlineID);
        return false;
    }

    into.bloodlineName = row.GetText(0);
    into.race = row.GetUInt(1);
    into.description = row.GetText(2);
    into.maleDescription = row.GetText(3);
    into.femaleDescription = row.GetText(4);
    into.corporationID = row.GetUInt(5);
    into.perception = row.GetUInt(6);
    into.willpower = row.GetUInt(7);
    into.charisma = row.GetUInt(8);
    into.memory = row.GetUInt(9);
    into.intelligence = row.GetUInt(10);
    into.shortDescription = row.GetText(11);
    into.shortMaleDescription = row.GetText(12);
    into.shortFemaleDescription = row.GetText(13);
    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool InventoryDB::GetCharacterType	(	uint16	characterTypeID,
		uint8 &	bloodlineID,
		CharacterTypeData &	into
	)

Obtains bloodline and loads character type data.

Parameters

[in]	characterTypeID	ID of character type to be loaded.
[out]	bloodlineID	Resulting bloodline.
[out]	into	Where character type data should be stored.

Returns

True on success, false on failure.

Definition at line 127 of file InventoryDB.cpp.

References GetBloodlineByCharacterType(), and GetCharacterType().

                                                                                                      {
    if(!GetBloodlineByCharacterType(characterTypeID, bloodlineID))
        return false;
    return GetCharacterType(bloodlineID, into);
}

Here is the call graph for this function:

bool InventoryDB::GetCharacterTypeByBloodline ( uint8  bloodlineID, uint16 &  characterTypeID  )

static

Obtains ID of character type based on bloodline.

Parameters

[in]	bloodlineID	ID of bloodline.
[out]	characterTypeID	Resulting ID of character type.

Returns

True on success, false on failure.

Definition at line 91 of file InventoryDB.cpp.

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

Referenced by ItemFactory::GetCharacterTypeByBloodline(), and GetCharacterTypeByBloodline().

                                                                                        {
    DBQueryResult res;
    if(!sDatabase.RunQuery(res, "SELECT typeID FROM bloodlineTypes WHERE bloodlineID = %u", bloodlineID)) {
        codelog(DATABASE__ERROR, "Failed to query bloodline %u: %s.", bloodlineID, res.error.c_str());
        return false;
    }

    DBResultRow row;
    if(!res.GetRow(row)) {
        _log(DATABASE__MESSAGE, "No data for bloodline %u.", bloodlineID);
        return false;
    }

    characterTypeID = row.GetUInt(0);

    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool InventoryDB::GetCharacterTypeByBloodline	(	uint8	bloodlineID,
		uint16 &	characterTypeID,
		CharacterTypeData &	into
	)

Obtains ID of character type and loads it.

Parameters

[in]	bloodlineID	ID of bloodline to be loaded.
[out]	characterTypeID	Resulting character type.
[out]	into	Where loaded character type data should be stored.

Returns

True on success, false on failure.

Definition at line 133 of file InventoryDB.cpp.

References GetCharacterType(), and GetCharacterTypeByBloodline().

                                                                                                                 {
    if(!GetCharacterTypeByBloodline(bloodlineID, characterTypeID))
        return false;
    return GetCharacterType(bloodlineID, into);
}

Here is the call graph for this function:

bool InventoryDB::GetCorpData	(	uint32	characterID,
		CorpData &	into
	)

Definition at line 362 of file InventoryDB.cpp.

References _log, CorpData::allianceID, CorpData::baseID, DBerror::c_str(), codelog, CorpData::corpAccountKey, CorpData::corpHQ, CorpData::corporationID, CorpData::corpRole, DBQueryResult::error, DBResultRow::GetDouble(), DBResultRow::GetInt(), DBResultRow::GetInt64(), DBQueryResult::GetRow(), DBResultRow::GetText(), DBResultRow::GetUInt(), CorpData::grantableRoles, CorpData::grantableRolesAtBase, CorpData::grantableRolesAtHQ, CorpData::grantableRolesAtOther, IsAgent, DBResultRow::IsNull(), CorpData::name, CorpData::rolesAtAll, CorpData::rolesAtBase, CorpData::rolesAtHQ, CorpData::rolesAtOther, sDatabase, CorpData::startDateTime, CorpData::taxRate, CorpData::ticker, and CorpData::warFactionID.

                                                                {
    DBQueryResult res;
    DBResultRow row;

    if (IsAgent(characterID)) {
        into.corpAccountKey = 1001;

        if (!sDatabase.RunQuery(res,
            "SELECT corporationID, locationID"
            " FROM agtAgents"
            " WHERE agentID = %u",
            characterID))
        {
            codelog(DATABASE__ERROR, "Failed to query corp member info of character %u: %s.", characterID, res.error.c_str());
            return false;
        }

        if (!res.GetRow(row)) {
            _log(DATABASE__MESSAGE, "No corp member info found for character %u.", characterID);
            return false;
        }
        into.corporationID = row.GetInt(0);
        into.baseID = row.GetInt(1);
    } else {
        if (!sDatabase.RunQuery(res,
            "SELECT"
            "  startDateTime,"
            "  corporationID,"
            "  corpAccountKey,"
            "  corpRole,"
            "  rolesAtAll,"
            "  rolesAtBase,"
            "  rolesAtHQ,"
            "  rolesAtOther,"
            "  grantableRoles,"
            "  grantableRolesAtBase,"
            "  grantableRolesAtHQ,"
            "  grantableRolesAtOther,"
            "  baseID"
            " FROM chrCharacters"
            " WHERE characterID = %u",
            characterID))
        {
            codelog(DATABASE__ERROR, "Failed to query corp member info of character %u: %s.", characterID, res.error.c_str());
            return false;
        }
        if (!res.GetRow(row)) {
            _log(DATABASE__MESSAGE, "No corp member info found for character %u.", characterID);
            return false;
        }

        into.startDateTime = row.GetInt64(0);
        into.corporationID = row.GetInt(1);
        into.corpAccountKey = row.GetInt(2);
        into.corpRole = row.GetInt64(3);
        into.rolesAtAll = row.GetInt64(4);
        into.rolesAtBase = row.GetInt64(5);
        into.rolesAtHQ = row.GetInt64(6);
        into.rolesAtOther = row.GetInt64(7);
        into.grantableRoles = row.GetInt64(8);
        into.grantableRolesAtBase = row.GetInt64(9);
        into.grantableRolesAtHQ = row.GetInt64(10);
        into.grantableRolesAtOther = row.GetInt64(11);
        into.baseID = row.GetInt(12);
    }

    if(!sDatabase.RunQuery(res,
        "SELECT"
        "  taxRate,"
        "  stationID,"
        "  allianceID,"
        "  warFactionID,"
        "  corporationName,"
        "  tickerName"
        " FROM crpCorporation"
        " WHERE corporationID = %u", into.corporationID))
    {
        codelog(DATABASE__ERROR, "Failed to query HQ of character's %u corporation %u: %s.", characterID, into.corporationID, res.error.c_str());
        return false;
    }

    if(!res.GetRow(row)) {
        _log(DATABASE__MESSAGE, "No HQ found for character's %u corporation.", characterID);
        return false;
    }

    into.taxRate = row.GetDouble(0);
    into.corpHQ = (row.IsNull(1) ? 0 : row.GetUInt(1));
    into.allianceID = (row.IsNull(2) ? 0 : row.GetUInt(2));
    into.warFactionID = (row.IsNull(3) ? 0 : row.GetUInt(3));
    into.name = row.GetText(4);
    into.ticker = row.GetText(5);

    return true;
}

Here is the call graph for this function:

bool InventoryDB::GetItemContents	(	OwnerData &	od,
		std::vector< uint32 > &	into
	)

Definition at line 143 of file InventoryDB.cpp.

References _log, DBerror::c_str(), codelog, OwnerData::corpID, DBQueryResult::error, DBQueryResult::GetRow(), DBQueryResult::GetRowCount(), IsCharacterID, IsOfficeID, IsPlayerCorp, OwnerData::locID, maxNPCItem, OwnerData::ownerID, sDatabase, and sDataMgr.

Referenced by Inventory::GetItems().

                                                                        {
    std::stringstream query;
    query << "SELECT itemID FROM entity WHERE locationID = ";
    query << od.locID;

    if (sDataMgr.IsSolarSystem(od.locID)) {
        query << " AND ownerID = " << od.ownerID;
    } else if (sDataMgr.IsStation(od.locID)) {
        if (od.ownerID == 1) {
            /* this will get agents in station */
            query << " AND ownerID < " << maxNPCItem;
            query << " AND itemID < " << maxNPCItem;
        } else {
            if (IsPlayerCorp(od.corpID)) {
                // check for items owned by corp in players cargo/hangar
                query << " AND ((ownerID = " << od.ownerID << ") OR (ownerID = " << od.corpID << "))";
            } else {
                query << " AND ownerID = " << od.ownerID;
            }
        }
    } else if (IsCharacterID(od.locID)) {
        if (od.ownerID == 1) {
            // not sure what to do here....
        } else if (IsPlayerCorp(od.corpID)) {
            // check for items owned by corp in players cargo/hangar...this *should* work for cap ships' cargo, also
           query << " AND ((ownerID = " << od.ownerID << ") OR (ownerID = " << od.corpID << "))";
        } else {
            query << " AND ownerID = " << od.ownerID;
        }
    } else if (IsOfficeID(od.locID)) {
        // may not need this, as location is officeID, but items MAY be owned by players in corp hangar.
        //query << " AND ownerID = " << od.ownerID;
    }

    query << " ORDER BY itemID";

    DBQueryResult res;
    if(!sDatabase.RunQuery(res,query.str().c_str() )) {
        codelog(DATABASE__ERROR, "Error in GetItemContents query for locationID %u: %s", od.locID, res.error.c_str());
        return false;
    }

    _log(DATABASE__RESULTS, "GetItemContents: '%s' returned %u items", query.str().c_str(), res.GetRowCount());
    DBResultRow row;
    while( res.GetRow( row ) )
        into.push_back( row.GetUInt( 0 ) );

    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool InventoryDB::GetItemContents	(	uint32	itemID,
		EVEItemFlags	flag,
		std::vector< uint32 > &	into
	)

Definition at line 194 of file InventoryDB.cpp.

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

{
    DBQueryResult res;

    if( !sDatabase.RunQuery( res,
        "SELECT "
        "  itemID"
        " FROM entity "
        " WHERE locationID=%u"
        "  AND flag=%d",
        itemID, (int)flag ) )
    {
        codelog(DATABASE__ERROR, "Error in GetItemContents query for item %u: %s", itemID, res.error.c_str());
        return false;
    }

    _log(DATABASE__RESULTS, "GetItemContents for item %u returned %u items", itemID, res.GetRowCount());
    DBResultRow row;
    while( res.GetRow( row ) )
        into.push_back( row.GetUInt( 0 ) );

    return true;
}

Here is the call graph for this function:

bool InventoryDB::GetItemContents	(	uint32	itemID,
		EVEItemFlags	flag,
		uint32	ownerID,
		std::vector< uint32 > &	into
	)

Definition at line 219 of file InventoryDB.cpp.

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

{
    DBQueryResult res;

    if( !sDatabase.RunQuery( res,
        "SELECT "
        "  itemID"
        " FROM entity "
        " WHERE locationID=%u"
        "  AND flag=%d"
        "  AND ownerID=%u",
        itemID, (int)flag, ownerID ) )
    {
        codelog(DATABASE__ERROR, "Error in GetItemContents query for item %u with flag %u: %s", itemID, (int)flag, res.error.c_str());
        return false;
    }

    _log(DATABASE__RESULTS, "GetItemContents for item %u with flag %u returned %u items", itemID, flag, res.GetRowCount());
    DBResultRow row;
    while( res.GetRow( row ) )
        into.push_back( row.GetUInt( 0 ) );

    return true;
}

Here is the call graph for this function:

bool InventoryDB::GetShipType	(	uint16	shipTypeID,
		ShipTypeData &	into
	)

Loads ship type data into given container.

Parameters

[in]	shipTypeID	ID of ship type.
[in]	into	Container to load data into.

Returns

True on success, false on failure.

bool InventoryDB::GetSolarSystem	(	uint32	solarSystemID,
		SolarSystemData &	into
	)

Definition at line 515 of file InventoryDB.cpp.

References _log, SolarSystemData::border, DBerror::c_str(), codelog, SolarSystemData::constellation, SolarSystemData::corridor, DBQueryResult::error, SolarSystemData::factionID, SolarSystemData::fringe, DBResultRow::GetBool(), DBResultRow::GetDouble(), DBQueryResult::GetRow(), DBResultRow::GetText(), DBResultRow::GetUInt(), SolarSystemData::hub, SolarSystemData::international, DBResultRow::IsNull(), SolarSystemData::luminosity, SolarSystemData::maxPosition, SolarSystemData::minPosition, SolarSystemData::radius, SolarSystemData::regional, sDatabase, SolarSystemData::security, SolarSystemData::securityClass, and SolarSystemData::sunTypeID.

                                                                            {
    DBQueryResult res;

    if(!sDatabase.RunQuery(res,
        "SELECT"
        "  xMin, yMin, zMin,"
        "  xMax, yMax, zMax,"
        "  luminosity,"
        "  border, fringe, corridor, hub, international, regional, constellation,"
        "  security, factionID, radius, sunTypeID, securityClass"
        " FROM mapSolarSystems"
        " WHERE solarSystemID=%u", solarSystemID))
    {
        codelog(DATABASE__ERROR, "Error in GetSolarSystem query for system %u: %s.", solarSystemID, res.error.c_str());
        return false;
    }

    DBResultRow row;
    if(!res.GetRow(row)) {
        _log(DATABASE__MESSAGE, "No data found for solar system %u.", solarSystemID);
        return false;
    }

    into.minPosition = GPoint(row.GetDouble(0), row.GetDouble(1), row.GetDouble(2));
    into.maxPosition = GPoint(row.GetDouble(3), row.GetDouble(4), row.GetDouble(5));
    into.luminosity = row.GetDouble(6);

    into.border = row.GetBool(7);
    into.fringe = row.GetBool(8);
    into.corridor = row.GetBool(9);
    into.hub = row.GetBool(10);
    into.international = row.GetBool(11);
    into.regional = row.GetBool(12);
    into.constellation = row.GetBool(13);

    into.security = row.GetDouble(14);
    into.factionID = (row.IsNull(15) ? 0 : row.GetUInt(15));
    into.radius = row.GetDouble(16);
    into.sunTypeID = row.GetUInt(17);
    into.securityClass = (row.IsNull(18) ? (std::string("")) : row.GetText(18));

    return true;
}

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