#include "StationDB.h"

Inheritance diagram for StationDB:

Collaboration diagram for StationDB:

StationDB.cpp
database methods for station data Author Allan Date 14 December 2017
void	UpdateOfficeData (OfficeData &data)

static PyRep *	GetOffices (uint32 stationID)

static PyRep *	GetStationOfficeIDs (uint32 locationID, uint32 corpID, const char *key)

static uint32	CreateOffice (ItemData &idata, OfficeData &odata)

static bool	GetOfficeData (uint32 officeID, OfficeData &odata)

static void	GetStationData (DBQueryResult &res)

static void	GetStationSystem (DBQueryResult &res)

static void	GetStationRegion (DBQueryResult &res)

static void	GetStationOfficeData (DBQueryResult &res)

static void	GetOperationServiceIDs (DBQueryResult &res)

static void	GetStationConstellation (DBQueryResult &res)

static int32	GetOfficeCount (uint32 corpID)

static void	LoadOffices (OwnerData &od, std::vector< uint32 > &into)

Additional Inherited Members
Public Member Functions inherited from ServiceDB
uint32	GetStationOwner (uint32 stationID)

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 18 of file StationDB.h.

Member Function Documentation

uint32 StationDB::CreateOffice	(	ItemData &	idata,
		OfficeData &	odata
	)

static

Definition at line 17 of file StationDB.cpp.

References DBerror::c_str(), codelog, OfficeData::corporationID, OfficeData::expiryTime, ItemData::flag, OfficeData::folderID, OfficeData::lockDown, OfficeData::name, OfficeData::officeID, OfficeData::rentalFee, sDatabase, OfficeData::stationID, stDataMgr, and OfficeData::typeID.

Referenced by StationOffice::Spawn().

 {
     uint32 uid = 0;
     DBerror err;
     if (!sDatabase.RunQueryLID(err, uid,
         "INSERT INTO staOffices (name, corporationID, stationID, officeFolderID, flag, solarSystemID, typeID, stationTypeID, lockDown, rentalFee, expiryDateTime)"
         " VALUES"
         " ('%s',%u,%u,%u,%u,%u, 27, %u,%u,%u,%li)",
         odata.name.c_str(), odata.corporationID, odata.stationID, odata.folderID, idata.flag, stDataMgr.GetStationSystemID(odata.stationID), odata.typeID, odata.lockDown, odata.rentalFee, odata.expiryTime)
     )
         codelog(DATABASE__ERROR, "Error in CreateOffice query: %s", err.c_str());
 
     return (odata.officeID = uid);
 }

Here is the call graph for this function:

Here is the caller graph for this function:

int32 StationDB::GetOfficeCount ( uint32 corpID )

static

Definition at line 38 of file StationDB.cpp.

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

 {
     DBQueryResult res;
     if (!sDatabase.RunQuery(res, "SELECT COUNT(itemID) FROM staOffices WHERE corporationID = %u ", corpID)) {
         codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
         return 0;
     }
 
     DBResultRow row;
     if (!res.GetRow(row)) {
         codelog(CORP__DB_WARNING, "Unable to find corporation's office data (%u)", corpID);
         return 0;
     }
     return row.GetInt(0);
 }

Here is the call graph for this function:

bool StationDB::GetOfficeData	(	uint32	officeID,
		OfficeData &	odata
	)

static

Definition at line 68 of file StationDB.cpp.

References DBerror::c_str(), codelog, OfficeData::corporationID, DBQueryResult::error, OfficeData::expiryTime, OfficeData::folderID, DBResultRow::GetBool(), DBResultRow::GetInt(), DBResultRow::GetInt64(), DBQueryResult::GetRow(), OfficeData::lockDown, OfficeData::officeID, OfficeData::rentalFee, sDatabase, OfficeData::stationID, and OfficeData::typeID.

Referenced by StationOffice::_LoadItem().

 {
     DBQueryResult res;
     if (!sDatabase.RunQuery(res,
         "SELECT"
         " corporationID, stationID, typeID, lockDown, rentalFee, expiryDateTime, officeFolderID"
         " FROM staOffices"
         " WHERE itemID = %u", officeID)
     ) {
         codelog(DATABASE__ERROR, "Error in GetOfficeData query: %s", res.error.c_str());
         return false;
     }
 
     DBResultRow row;
     if (!res.GetRow(row))
         return false;
 
     odata.officeID      = officeID;
     odata.corporationID = row.GetInt(0);
     odata.stationID     = row.GetInt(1);
     odata.typeID        = row.GetInt(2);
     odata.lockDown      = row.GetBool(3);
     odata.rentalFee     = row.GetInt64(4);
     odata.expiryTime    = row.GetInt64(5);
     odata.folderID      = row.GetInt(6);
     return true;
 }

Here is the call graph for this function:

Here is the caller graph for this function:

PyRep * StationDB::GetOffices ( uint32 stationID )

static

Definition at line 54 of file StationDB.cpp.

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

Referenced by StationItem::_Load(), and StationItem::RentOffice().

 {
     DBQueryResult res;
     if (!sDatabase.RunQuery(res,
         "SELECT"
         " corporationID, itemID, officeFolderID"
         " FROM staOffices"
         " WHERE stationID = %u", stationID)
     )
         codelog(DATABASE__ERROR, "Error in GetOffices query: %s", res.error.c_str());
 
     return DBResultToCRowset(res);
 }

Here is the call graph for this function:

Here is the caller graph for this function:

void StationDB::GetOperationServiceIDs ( DBQueryResult & res )

static

Definition at line 175 of file StationDB.cpp.

References sDatabase.

Referenced by StationDataMgr::Populate().

 {
     sDatabase.RunQuery(res, "SELECT operationID, serviceID FROM staOperationServices");
 }

Here is the caller graph for this function:

void StationDB::GetStationConstellation ( DBQueryResult & res )

static

Definition at line 169 of file StationDB.cpp.

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

Referenced by StaticDataMgr::Populate().

 {
     if (!sDatabase.RunQuery(res, "SELECT stationID, constellationID FROM staStations"))
         codelog(DATABASE__ERROR, "Error in GetStationConstellation query: %s", res.error.c_str());
 }

Here is the call graph for this function:

Here is the caller graph for this function:

void StationDB::GetStationData ( DBQueryResult & res )

static

Definition at line 138 of file StationDB.cpp.

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

Referenced by StationDataMgr::Populate().

 {
     if (!sDatabase.RunQuery(res,
         "SELECT"
         "  s.stationID, s.x, s.y, s.z, st.dockOrientationX, st.dockOrientationY, st.dockOrientationZ,"
         "  s.dockingCostPerVolume, s.maxShipVolumeDockable, s.officeSlots, s.officeRentalCost,"
         "  s.operationID, s.stationTypeID, s.corporationID, s.stationName,"
         "  s.reprocessingStationsTake, s.reprocessingEfficiency, s.reprocessingHangarFlag, st.conquerable, st.hangarGraphicID,"
         "  m.orbitID, m.radius, m.security, o.description, o.descriptionID, t.graphicID, s.solarSystemID, s.constellationID, s.regionID,"
         "  st.dockEntryX, st.dockEntryY, st.dockEntryZ"
         " FROM staStations AS s"
         "  LEFT JOIN staStationTypes AS st USING (stationTypeID)"
         "  LEFT JOIN invTypes AS t ON t.typeID = s.stationTypeID"
         "  LEFT JOIN staOperations AS o ON o.operationID = s.operationID"
         "  LEFT JOIN mapDenormalize AS m ON m.itemID = s.stationID")
         )
         codelog(DATABASE__ERROR, "Error in GetStationData query: %s", res.error.c_str());
 }

Here is the call graph for this function:

Here is the caller graph for this function:

void StationDB::GetStationOfficeData ( DBQueryResult & res )

static

Definition at line 97 of file StationDB.cpp.

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

Referenced by StationDataMgr::Populate().

 {
     if (!sDatabase.RunQuery(res,
         "SELECT"
         " itemID, corporationID, stationID, typeID, lockDown, rentalFee, expiryDateTime, officeFolderID"
         " FROM staOffices")
     )
         codelog(DATABASE__ERROR, "Error in GetStationOfficeData query: %s", res.error.c_str());
 }

Here is the call graph for this function:

Here is the caller graph for this function:

PyRep * StationDB::GetStationOfficeIDs	(	uint32	locationID,
		uint32	corpID,
		const char *	key
	)

static

Definition at line 107 of file StationDB.cpp.

References _log, DBRowToRow(), DBQueryResult::GetRow(), IsOfficeFolder, IsOfficeID, sDatabase, sDataMgr, and STATION_OFFICE_OFFSET.

 {
     DBQueryResult res;
     if (sDataMgr.IsStation(locationID)) {
         sDatabase.RunQuery(res, "SELECT itemID AS officeID, stationID, officeFolderID"
         " FROM staOffices WHERE stationID = %u", locationID);
     } else if (IsOfficeFolder(locationID)) {
         sDatabase.RunQuery(res, "SELECT itemID AS officeID, stationID, officeFolderID"
         " FROM staOffices WHERE officeFolderID = %u",
             locationID - STATION_OFFICE_OFFSET);
     } else if (IsOfficeID(locationID)) {
         sDatabase.RunQuery(res, "SELECT itemID AS officeID, stationID, officeFolderID"
         " FROM staOffices WHERE itemID = %u", locationID);
     } else {
         _log(CORP__DB_ERROR, "StationDB::GetStationOfficeIDs got invalid locationID %u", locationID);
     }
 
     DBResultRow row;
     if (res.GetRow(row))
         return DBRowToRow(row);
 
     return nullptr;
 
     //return DBResultToCIndexedRowset(res, key);
     //return DBResultToIndexRowset(res, key);
     //return DBResultToCRowset(res);
     //return DBResultToRowList(res);
     //return DBResultToRowset(res);
     //return DBResultToPackedRowDict(res, key);
 }

Here is the call graph for this function:

void StationDB::GetStationRegion ( DBQueryResult & res )

static

Definition at line 163 of file StationDB.cpp.

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

Referenced by StaticDataMgr::Populate().

 {
     if (!sDatabase.RunQuery(res, "SELECT stationID, regionID FROM staStations"))
         codelog(DATABASE__ERROR, "Error in GetStationRegion query: %s", res.error.c_str());
 }

Here is the call graph for this function:

Here is the caller graph for this function:

void StationDB::GetStationSystem ( DBQueryResult & res )

static

Definition at line 157 of file StationDB.cpp.

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

Referenced by StaticDataMgr::Populate().

 {
     if (!sDatabase.RunQuery(res, "SELECT stationID, solarSystemID FROM staStations"))
         codelog(DATABASE__ERROR, "Error in GetStationSystem query: %s", res.error.c_str());
 }

Here is the call graph for this function:

Here is the caller graph for this function:

void StationDB::LoadOffices	(	OwnerData &	od,
		std::vector< uint32 > &	into
	)

static

Definition at line 180 of file StationDB.cpp.

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

Referenced by Inventory::LoadContents().

 {
     DBQueryResult res;
     if (!sDatabase.RunQuery(res, "SELECT itemID FROM staOffices WHERE stationID = %u", od.locID)) {
         codelog(DATABASE__ERROR, "Error in LoadOffices query: %s", res.error.c_str());
         return;
     }
 
     DBResultRow row;
     while (res.GetRow(row))
         into.push_back(row.GetInt(0));
 }

Here is the call graph for this function:

Here is the caller graph for this function:

void StationDB::UpdateOfficeData ( OfficeData & data )

Definition at line 32 of file StationDB.cpp.

References OfficeData::expiryTime, OfficeData::lockDown, OfficeData::rentalFee, and sDatabase.

 {
     DBerror err;
     sDatabase.RunQuery(err, "UPDATE staOffices SET lockDown = %u, rentalFee = %u, expiryDateTime = %li)", data.lockDown, data.rentalFee, data.expiryTime);
 }

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

/backups/local/src/eve/EvEmu_Crucible/src/eve-server/station/StationDB.h
/backups/local/src/eve/EvEmu_Crucible/src/eve-server/station/StationDB.cpp

StationDB.cpp

Additional Inherited Members

Detailed Description

Member Function Documentation