#include "PosMgrDB.h"

Inheritance diagram for PosMgrDB:

Collaboration diagram for PosMgrDB:

PosMgrDB.cpp
DataBase methods for all POS items : Allan Date : 8 December 17
PyRep *	GetSiloCapacityForType (uint16 typeID)

PyRep *	GetCorpControlTowers (uint32 corpID)

void	GetControlTowerFuelRequirements (DBQueryResult &res)

void	DeleteData (uint32 itemID)

bool	GetBaseData (EVEPOS::StructureData &data)

void	SaveBaseData (EVEPOS::StructureData &data)

void	UpdateBaseData (EVEPOS::StructureData &data)

bool	GetTowerData (EVEPOS::TowerData &tData, EVEPOS::StructureData &sData)

void	SaveTowerData (EVEPOS::TowerData &tData, EVEPOS::StructureData &sData)

bool	GetBridgeData (EVEPOS::JumpBridgeData &data)

void	SaveBridgeData (EVEPOS::JumpBridgeData &data)

void	UpdateBridgeData (EVEPOS::JumpBridgeData &data)

void	InstallBridgeLink (uint32 itemID, uint32 toSystemID, uint32 toItemID)

void	UninstallBridgeLink (uint32 itemID)

bool	GetReactorData (ReactorData *pData, EVEPOS::StructureData &sData)

void	SaveReactorData (ReactorData *pData, EVEPOS::StructureData &sData)

void	UpdateReactorData (ReactorData *pData, EVEPOS::StructureData &sData)

bool	GetCustomsData (EVEPOS::CustomsData &cData, EVEPOS::OrbitalData &oData)

void	SaveCustomsData (EVEPOS::CustomsData &cData, EVEPOS::OrbitalData &oData)

void	UpdateCustomsData (EVEPOS::CustomsData &cData, EVEPOS::OrbitalData &oData)

void	UpdateAccess (int32 itemID, EVEPOS::TowerData &data)

void	UpdateNotify (int32 itemID, EVEPOS::TowerData &data)

void	UpdateSentry (int32 itemID, EVEPOS::TowerData &data)

void	UpdatePassword (int32 itemID, EVEPOS::TowerData &data)

void	UpdateTimeStamp (int32 itemID, EVEPOS::StructureData &data)

void	UpdatePermission (int32 itemID, EVEPOS::TowerData &data)

void	UpdateUsageFlags (int32 itemID, EVEPOS::StructureData &data)

void	UpdateDeployFlags (int32 itemID, EVEPOS::TowerData &data)

void	UpdateHarmonicAndPassword (int32 itemID, EVEPOS::TowerData &data)

static void	GetLinkableJumpArrays (uint32 corpID, DBQueryResult &res)

static void	GetCorpJumpArrays (uint32 corpID, DBQueryResult &res)

static void	GetAllianceJumpArrays (uint32 allyID, DBQueryResult &res)

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 19 of file PosMgrDB.h.

Member Function Documentation

void PosMgrDB::DeleteData ( uint32 itemID )

Definition at line 17 of file PosMgrDB.cpp.

References sDatabase.

Referenced by StructureSE::Scoop().

                                        {
     DBerror err;
     sDatabase.RunQuery(err, "DELETE FROM posStructureData WHERE itemID = %u", itemID);
     sDatabase.RunQuery(err, "DELETE FROM posCustomsOfficeData WHERE itemID = %u", itemID);
     sDatabase.RunQuery(err, "DELETE FROM posJumpBridgeData WHERE itemID = %u", itemID);
     sDatabase.RunQuery(err, "DELETE FROM posTowerData WHERE itemID = %u", itemID);
 }

Here is the caller graph for this function:

void PosMgrDB::GetAllianceJumpArrays	(	uint32	allyID,
		DBQueryResult &	res
	)

static

Definition at line 87 of file PosMgrDB.cpp.

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

 {
     if (!sDatabase.RunQuery(res,
             "SELECT itemID, systemID, toItemID, toTypeID, toSystemID"
             " FROM posJumpBridgeData WHERE allyID = %u", allyID))
     {
         codelog(DATABASE__ERROR, "Error in GetAllianceJumpArrays query: %s", res.error.c_str());
     }
 }

Here is the call graph for this function:

bool PosMgrDB::GetBaseData ( EVEPOS::StructureData & data )

Definition at line 97 of file PosMgrDB.cpp.

References EVEPOS::StructureData::anchorpointID, DBerror::c_str(), codelog, DBQueryResult::error, DBResultRow::GetInt(), DBResultRow::GetInt64(), DBQueryResult::GetRow(), EVEPOS::StructureData::itemID, sDatabase, EVEPOS::StructureData::state, EVEPOS::StructureData::status, EVEPOS::StructureData::take, EVEPOS::StructureData::timestamp, EVEPOS::StructureData::towerID, EVEPOS::StructureData::use, and EVEPOS::StructureData::view.

Referenced by StructureSE::Init().

 {
     DBQueryResult res;
     if (!sDatabase.RunQuery(res,
             "SELECT towerID, anchorpointID, state, status, timestamp, canUse, canView, canTake FROM posStructureData"
             " WHERE itemID = %u", data.itemID))
     {
         codelog(DATABASE__ERROR, "Error in GetBaseData query: %s", res.error.c_str());
         return false;
     }
 
     DBResultRow row;
     if (!res.GetRow(row))
         return false;
     data.towerID = row.GetInt(0);
     data.anchorpointID = row.GetInt(1);
     data.state = row.GetInt(2);
     data.status = row.GetInt(3);
     data.timestamp = row.GetInt64(4);
     data.use = row.GetInt(5);
     data.view = row.GetInt(6);
     data.take = row.GetInt(7);
     return true;
 }

Here is the call graph for this function:

Here is the caller graph for this function:

bool PosMgrDB::GetBridgeData ( EVEPOS::JumpBridgeData & data )

Definition at line 191 of file PosMgrDB.cpp.

 {
     DBQueryResult res;
     if (!sDatabase.RunQuery(res,
         "SELECT towerID, corpID, allyID, systemID, toItemID, toSystemID, toTypeID, password, allowCorp, allowAlliance"
             " FROM posJumpBridgeData WHERE itemID = %i", data.itemID))
         {
             codelog(DATABASE__ERROR, "Error in GetBridgeData query: %s", res.error.c_str());
             return false;
         }
 
     DBResultRow row;
     if (!res.GetRow(row)) {
         data = EVEPOS::JumpBridgeData();
         return false;
     }
 
     data.towerID = row.GetInt(0);
     data.corpID = row.GetInt(1);
     data.allyID = row.GetInt(2);
     data.systemID = row.GetInt(3);
     data.toItemID = row.GetInt(4);
     data.toSystemID = row.GetInt(5);
     data.toTypeID = row.GetInt(6);
     data.password = row.GetText(7);
     data.allowCorp = row.GetInt(8);
     data.allowAlliance = row.GetInt(9);
 
     return true;
 }

Here is the call graph for this function:

void PosMgrDB::GetControlTowerFuelRequirements ( DBQueryResult & res )

Definition at line 56 of file PosMgrDB.cpp.

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

                                                                  {
 
     if (!sDatabase.RunQuery(res,
             "SELECT controlTowerTypeID, resourceTypeID, purpose, quantity, minSecurityLevel, factionID, wormholeClassID"
             " FROM invControlTowerResources"
             " WHERE purpose = 1 OR purpose = 4"))
     {
         codelog(DATABASE__ERROR, "Error in GetControlTowerFuelRequirements query: %s", res.error.c_str());
     }
 }

Here is the call graph for this function:

PyRep * PosMgrDB::GetCorpControlTowers ( uint32 corpID )

Todo:: update this to pull from tower data table first to avoid iterating thru entity

Definition at line 38 of file PosMgrDB.cpp.

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

 {
     DBQueryResult res;
     if (!sDatabase.RunQuery(res,
             "SELECT e.typeID, e.itemID, e.locationID"
             " FROM entity AS e"
             " LEFT JOIN invTypes AS t USING (typeID)"
             " LEFT JOIN posTowerData AS d USING (itemID)"// we're not looking for towers in cargo
             " WHERE e.ownerID = %u AND t.groupID = %u", corpID, EVEDB::invGroups::Control_Tower))
     {
         codelog(DATABASE__ERROR, "Error in GetCorpControlTowers query: %s", res.error.c_str());
         return nullptr;
     }
 
     return DBResultToCRowset(res);
 }

Here is the call graph for this function:

void PosMgrDB::GetCorpJumpArrays	(	uint32	corpID,
		DBQueryResult &	res
	)

static

Definition at line 77 of file PosMgrDB.cpp.

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

 {
     if (!sDatabase.RunQuery(res,
             "SELECT itemID, systemID, toItemID, toTypeID, toSystemID"
             " FROM posJumpBridgeData WHERE corpID = %u", corpID))
     {
         codelog(DATABASE__ERROR, "Error in GetCorpJumpArrays query: %s", res.error.c_str());
     }
 }

Here is the call graph for this function:

bool PosMgrDB::GetCustomsData	(	EVEPOS::CustomsData &	cData,
		EVEPOS::OrbitalData &	oData
	)

Definition at line 289 of file PosMgrDB.cpp.

References Calendar::Flag::Alliance, EVEPOS::CustomsData::allowAlliance, EVEPOS::CustomsData::allowStandings, DBerror::c_str(), codelog, Calendar::Flag::Corp, DBQueryResult::error, DBResultRow::GetBool(), DBResultRow::GetFloat(), DBResultRow::GetInt(), DBResultRow::GetInt64(), DBQueryResult::GetRow(), EVEPOS::CustomsData::itemID, EVEPOS::OrbitalData::level, EVEPOS::OrbitalData::orbitalHackerID, EVEPOS::OrbitalData::orbitalHackerProgress, EVEPOS::CustomsData::ownerID, EVEPOS::OrbitalData::rotation, sDatabase, EVEPOS::CustomsData::selectedHour, EVEPOS::TaxValues::StandingBad, EVEPOS::TaxValues::StandingGood, EVEPOS::TaxValues::StandingHigh, EVEPOS::TaxValues::StandingHorrible, EVEPOS::TaxValues::StandingNeutral, EVEPOS::CustomsData::standingValue, EVEPOS::CustomsData::state, EVEPOS::CustomsData::status, EVEPOS::CustomsData::taxRateValues, and EVEPOS::CustomsData::timestamp.

Referenced by CustomsSE::Init().

 {
     DBQueryResult res;
     if (!sDatabase.RunQuery(res,
         "SELECT ownerID, allowAlly, allowStandings, selectedHour, standingValue,"
         " corpTax, allyTax, horribleTax, badTax, neutTax, goodTax, highTax, timestamp,"
         " rotX, rotY, rotZ, orbitalHackerProgress, orbitalHackerID, state, status, level"
         " FROM posCustomsOfficeData WHERE itemID = %i", cData.itemID))
     {
         codelog(DATABASE__ERROR, "Error in GetCustomsData query: %s", res.error.c_str());
         return false;
     }
 
     DBResultRow row;
     if (!res.GetRow(row))
         return false;
 
     cData.ownerID = row.GetInt(0);
     cData.allowAlliance = row.GetBool(1);
     cData.allowStandings = row.GetBool(2);
     cData.selectedHour = row.GetInt(3);
     cData.standingValue = row.GetInt(4);
 
     using namespace EVEPOS;
     std::map<uint8, float> taxRateValues;
         taxRateValues[TaxValues::Corp]              = row.GetFloat(5);
         taxRateValues[TaxValues::Alliance]          = row.GetFloat(6);
         taxRateValues[TaxValues::StandingHorrible]  = row.GetFloat(7);
         taxRateValues[TaxValues::StandingBad]       = row.GetFloat(8);
         taxRateValues[TaxValues::StandingNeutral]   = row.GetFloat(9);
         taxRateValues[TaxValues::StandingGood]      = row.GetFloat(10);
         taxRateValues[TaxValues::StandingHigh]      = row.GetFloat(11);
     cData.taxRateValues = taxRateValues;
     cData.timestamp = row.GetInt64(12);
     oData.rotation = GVector(row.GetFloat(13), row.GetFloat(14), row.GetFloat(15));
     oData.orbitalHackerProgress = row.GetInt(16);
     oData.orbitalHackerID = row.GetInt(17);
     cData.state = row.GetInt(18);
     cData.status = row.GetInt(19);
     oData.level = row.GetInt(20);
     //oData.standingOwnerID = row.GetInt(19);   // not sure what this is for
 
     return true;
 }

Here is the call graph for this function:

Here is the caller graph for this function:

void PosMgrDB::GetLinkableJumpArrays	(	uint32	corpID,
		DBQueryResult &	res
	)

static

Definition at line 67 of file PosMgrDB.cpp.

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

 {
     if (!sDatabase.RunQuery(res,
             "SELECT systemID, itemID"
             " FROM posJumpBridgeData WHERE corpID = %u AND toItemID = 0", corpID))
     {
         codelog(DATABASE__ERROR, "Error in GetLinkableJumpArrays query: %s", res.error.c_str());
     }
 }

Here is the call graph for this function:

bool PosMgrDB::GetReactorData	(	ReactorData *	pData,
		EVEPOS::StructureData &	sData
	)

Definition at line 266 of file PosMgrDB.cpp.

Referenced by ReactorSE::Init().

 {
     return true;
 }

Here is the caller graph for this function:

PyRep * PosMgrDB::GetSiloCapacityForType ( uint16 typeID )

Definition at line 25 of file PosMgrDB.cpp.

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

                                                      {
     DBQueryResult res;
     if (!sDatabase.RunQuery(res,
             "SELECT attributeID, valueFloat FROM dgmTypeAttributes"
             " WHERE typeID = %u AND attributeID = %u", typeID, AttrCapacity))
     {
         codelog(DATABASE__ERROR, "Error in GetSiloCapacityForType query: %s", res.error.c_str());
         return nullptr;
     }
 
     return DBResultToCRowset(res);
 }

Here is the call graph for this function:

bool PosMgrDB::GetTowerData	(	EVEPOS::TowerData &	tData,
		EVEPOS::StructureData &	sData
	)

Definition at line 140 of file PosMgrDB.cpp.

Referenced by TowerSE::Init().

 {
     DBQueryResult res;
     if (!sDatabase.RunQuery(res,
             "SELECT"
             " harmonic, standing, standingOwnerID, statusDrop, corpWar, allyStandings, showInCalendar,"
             " sendFuelNotifications, allowCorp, allowAlliance, password, anchor, unanchor, online, offline, status"
             " FROM posTowerData"
             " WHERE itemID = %i", sData.itemID))
     {
         codelog(DATABASE__ERROR, "Error in GetTowerData query: %s", res.error.c_str());
         return false;
     }
 
     DBResultRow row;
     if (!res.GetRow(row)) {
         tData = EVEPOS::TowerData();
         return false;
     }
     tData.harmonic = row.GetInt(0);
     tData.standing = row.GetFloat(1);
     tData.standingOwnerID = row.GetInt(2);
     tData.statusDrop = row.GetInt(3);
     tData.corpWar = row.GetInt(4);
     tData.allyStandings = row.GetInt(5);
     tData.showInCalendar = row.GetInt(6);
     tData.sendFuelNotifications = row.GetInt(7);
     tData.allowCorp = row.GetInt(8);
     tData.allowAlliance = row.GetInt(9);
     tData.password = row.GetText(10);
     tData.anchor = row.GetInt(11);
     tData.unanchor = row.GetInt(12);
     tData.online = row.GetInt(13);
     tData.offline = row.GetInt(14);
     tData.status = row.GetFloat(15);
     return true;
 }

Here is the call graph for this function:

Here is the caller graph for this function:

void PosMgrDB::InstallBridgeLink	(	uint32	itemID,
		uint32	toSystemID,
		uint32	toItemID
	)

Definition at line 246 of file PosMgrDB.cpp.

References sDatabase.

 {
     DBerror err;
     sDatabase.RunQuery(err,
         "UPDATE posJumpBridgeData SET "
         " toItemID=%i, toTypeID=27897, toSystemID=%i "
         " WHERE itemID=%i",
         toItemID, toSystemID, itemID);
 }

void PosMgrDB::SaveBaseData ( EVEPOS::StructureData & data )

Definition at line 122 of file PosMgrDB.cpp.

References EVEPOS::StructureData::anchorpointID, EVEPOS::StructureData::itemID, sDatabase, EVEPOS::StructureData::state, EVEPOS::StructureData::status, EVEPOS::StructureData::take, EVEPOS::StructureData::timestamp, EVEPOS::StructureData::towerID, EVEPOS::StructureData::use, and EVEPOS::StructureData::view.

Referenced by StructureSE::Init().

 {
     DBerror err;
     sDatabase.RunQuery(err,
         "INSERT INTO posStructureData "
         "(itemID, towerID, anchorpointID, state, status, timestamp, canUse, canView, canTake)"
         " VALUES ( %i, %i, %i, %i, %i, %li, %i, %i, %i)",
         data.itemID, data.towerID, data.anchorpointID, data.state, data.status, data.timestamp, data.use, data.view, data.take);
 }

Here is the caller graph for this function:

void PosMgrDB::SaveBridgeData ( EVEPOS::JumpBridgeData & data )

Definition at line 222 of file PosMgrDB.cpp.

References EVEPOS::JumpBridgeData::allowAlliance, EVEPOS::JumpBridgeData::allowCorp, EVEPOS::JumpBridgeData::allyID, EVEPOS::JumpBridgeData::corpID, EVEPOS::JumpBridgeData::itemID, EVEPOS::JumpBridgeData::password, sDatabase, EVEPOS::JumpBridgeData::systemID, EVEPOS::JumpBridgeData::toItemID, EVEPOS::JumpBridgeData::toSystemID, EVEPOS::JumpBridgeData::toTypeID, and EVEPOS::JumpBridgeData::towerID.

Referenced by StructureSE::InitData().

 {
     std::string escPass;
     sDatabase.DoEscapeString(escPass, data.password);
     DBerror err;
     sDatabase.RunQuery(err,
         "INSERT INTO posJumpBridgeData(itemID, towerID, corpID, allyID, systemID, toItemID, toTypeID, toSystemID, password, allowCorp, allowAlliance)"
         " VALUES (%i,%i,%i,%i,%i,%i,%i,%i,'%s',%u,%u)",
         data.itemID, data.towerID, data.corpID, data.allyID, data.systemID, data.toItemID, data.toTypeID,
         data.toSystemID, escPass.c_str(), data.allowCorp, data.allowAlliance);
 }

Here is the caller graph for this function:

void PosMgrDB::SaveCustomsData	(	EVEPOS::CustomsData &	cData,
		EVEPOS::OrbitalData &	oData
	)

Definition at line 334 of file PosMgrDB.cpp.

Referenced by CustomsSE::Init().

 {
     using namespace EVEPOS;
     DBerror err;
     sDatabase.RunQuery(err,
         "INSERT INTO posCustomsOfficeData (itemID, ownerID, allowAlly, allowStandings, selectedHour, standingValue,"
         " corpTax, allyTax, horribleTax, badTax, neutTax, goodTax, highTax, timestamp,"
         " rotX, rotY, rotZ, orbitalHackerProgress, orbitalHackerID, state, status, level)"
         " VALUES (%u, %u, %u, %u, %u, %u, %f, %f, %f, %f, %f, %f, %f, %li, %f, %f, %f, %f, %u, %i, %i, %i)",
         cData.itemID, cData.ownerID, cData.allowAlliance, cData.allowStandings, cData.selectedHour, cData.standingValue,
         cData.taxRateValues[TaxValues::Corp], cData.taxRateValues[TaxValues::Alliance], cData.taxRateValues[TaxValues::StandingHorrible],
         cData.taxRateValues[TaxValues::StandingBad], cData.taxRateValues[TaxValues::StandingNeutral], cData.taxRateValues[TaxValues::StandingGood],
         cData.taxRateValues[TaxValues::StandingHigh], cData.timestamp, oData.rotation.x, oData.rotation.y, oData.rotation.z,
         oData.orbitalHackerProgress, oData.orbitalHackerID, cData.state, cData.status, oData.level);
 }

Here is the caller graph for this function:

void PosMgrDB::SaveReactorData	(	ReactorData *	pData,
		EVEPOS::StructureData &	sData
	)

Definition at line 271 of file PosMgrDB.cpp.

Referenced by ReactorSE::InitData().

 {
     /*
     bool active;
     int32 itemID;
     int16 reaction;     // bp typeID?
     std::map<uint32, EVEPOS::POS_Connections> connections;  // itemID, data
     std::map<uint32, EVEPOS::POS_Resource> demands;         // itemID, resourceData(typeID/quantity)
     std::map<uint32, EVEPOS::POS_Resource> supplies;        // itemID, resourceData(typeID/quantity)
 */
 
 }

Here is the caller graph for this function:

void PosMgrDB::SaveTowerData	(	EVEPOS::TowerData &	tData,
		EVEPOS::StructureData &	sData
	)

Definition at line 178 of file PosMgrDB.cpp.

Referenced by TowerSE::InitData().

 {
     DBerror err;
     sDatabase.RunQuery(err,
         "INSERT INTO posTowerData"
         " (itemID, harmonic, standing, standingOwnerID, status, statusDrop, corpWar, allyStandings, showInCalendar,"
         " sendFuelNotifications, allowCorp, allowAlliance, anchor, unanchor, online, offline)"
         " VALUES ( %i, %i, %f, %i, %f, %u, %u, %u, %u, %u, %u, %u, %i, %i, %i,%i)",
         sData.itemID, tData.harmonic, tData.standing, tData.standingOwnerID, tData.status, tData.statusDrop, tData.corpWar, tData.allyStandings,
         tData.showInCalendar, tData.sendFuelNotifications, tData.allowCorp, tData.allowAlliance,
         tData.anchor, tData.unanchor, tData.online, tData.offline);
 }

Here is the caller graph for this function:

void PosMgrDB::UninstallBridgeLink ( uint32 itemID )

Definition at line 256 of file PosMgrDB.cpp.

References sDatabase.

 {
     DBerror err;
     sDatabase.RunQuery(err,
         "UPDATE posJumpBridgeData SET "
         " toItemID=0, toTypeID=0, toSystemID=0 "
         " WHERE itemID=%i",
         itemID);
 }

void PosMgrDB::UpdateAccess	(	int32	itemID,
		EVEPOS::TowerData &	data
	)

Definition at line 393 of file PosMgrDB.cpp.

References EVEPOS::TowerData::allowAlliance, EVEPOS::TowerData::allowCorp, itemID(), EVEPOS::TowerData::password, and sDatabase.

Referenced by TowerSE::UpdateAccess().

 {
     std::string nameEsc;
     sDatabase.DoEscapeString(nameEsc, data.password);
     DBerror err;
     sDatabase.RunQuery(err,
         "UPDATE posTowerData"
         " SET allowAlliance=%i, allowCorp=%i, password = '%s'"
         " WHERE itemID = %u", data.allowAlliance, data.allowCorp, nameEsc.c_str(), itemID);
 }

Here is the call graph for this function:

Here is the caller graph for this function:

void PosMgrDB::UpdateBaseData ( EVEPOS::StructureData & data )

Definition at line 132 of file PosMgrDB.cpp.

References EVEPOS::StructureData::itemID, sDatabase, EVEPOS::StructureData::state, EVEPOS::StructureData::status, and EVEPOS::StructureData::timestamp.

Referenced by StructureSE::Activate(), StructureSE::Deactivate(), StructureSE::Process(), StructureSE::SetInvulnerable(), TowerSE::SetOnline(), StructureSE::SetOnline(), StructureSE::SetOperating(), StructureSE::SetUsageFlags(), and StructureSE::SetVulnerable().

 {
     DBerror err;
     sDatabase.RunQuery(err,
         "UPDATE posStructureData SET state=%i, status=%i, timestamp=%li WHERE itemID = %i",
         data.state, data.status, data.timestamp, data.itemID);
 }

Here is the caller graph for this function:

void PosMgrDB::UpdateBridgeData ( EVEPOS::JumpBridgeData & data )

Definition at line 234 of file PosMgrDB.cpp.

References EVEPOS::JumpBridgeData::allowAlliance, EVEPOS::JumpBridgeData::allowCorp, EVEPOS::JumpBridgeData::allyID, EVEPOS::JumpBridgeData::itemID, EVEPOS::JumpBridgeData::password, sDatabase, EVEPOS::JumpBridgeData::toItemID, EVEPOS::JumpBridgeData::toSystemID, and EVEPOS::JumpBridgeData::toTypeID.

 {
     std::string escPass;
     sDatabase.DoEscapeString(escPass, data.password);
     DBerror err;
     sDatabase.RunQuery(err,
         "UPDATE posJumpBridgeData"
         " SET allyID=%i, toItemID=%i, toTypeID=%i, toSystemID=%i, password='%s', allowCorp=%u, allowAlliance=%u"
         " WHERE itemID=%i",
         data.allyID, data.toItemID, data.toTypeID, data.toSystemID, escPass.c_str(), data.allowCorp, data.allowAlliance, data.itemID);
 }

void PosMgrDB::UpdateCustomsData	(	EVEPOS::CustomsData &	cData,
		EVEPOS::OrbitalData &	oData
	)

Definition at line 350 of file PosMgrDB.cpp.

References Calendar::Flag::Alliance, EVEPOS::CustomsData::allowAlliance, EVEPOS::CustomsData::allowStandings, Calendar::Flag::Corp, EVEPOS::CustomsData::itemID, EVEPOS::OrbitalData::orbitalHackerID, EVEPOS::OrbitalData::orbitalHackerProgress, sDatabase, EVEPOS::CustomsData::selectedHour, EVEPOS::TaxValues::StandingBad, EVEPOS::TaxValues::StandingGood, EVEPOS::TaxValues::StandingHigh, EVEPOS::TaxValues::StandingHorrible, EVEPOS::TaxValues::StandingNeutral, EVEPOS::CustomsData::standingValue, EVEPOS::CustomsData::state, EVEPOS::CustomsData::status, EVEPOS::CustomsData::taxRateValues, and EVEPOS::CustomsData::timestamp.

Referenced by CustomsSE::UpdateSettings().

 {
     using namespace EVEPOS;
     DBerror err;
     sDatabase.RunQuery(err,
         "UPDATE posCustomsOfficeData"
         " SET allowAlly=%u, allowStandings=%u, selectedHour=%u, standingValue=%u,"
         " corpTax=%f, allyTax=%f, horribleTax=%f, badTax=%f, neutTax=%f, goodTax=%f, highTax=%f, timestamp=%li,"
         " orbitalHackerProgress=%f, orbitalHackerID=%u, state=%i, status=%i"
         " WHERE itemID=%i",
         cData.allowAlliance, cData.allowStandings, cData.selectedHour, cData.standingValue,
         cData.taxRateValues[TaxValues::Corp], cData.taxRateValues[TaxValues::Alliance], cData.taxRateValues[TaxValues::StandingHorrible],
         cData.taxRateValues[TaxValues::StandingBad], cData.taxRateValues[TaxValues::StandingNeutral], cData.taxRateValues[TaxValues::StandingGood],
         cData.taxRateValues[TaxValues::StandingHigh], cData.timestamp, oData.orbitalHackerProgress, oData.orbitalHackerID,
         cData.state, cData.status, cData.itemID);
 }

Here is the caller graph for this function:

void PosMgrDB::UpdateDeployFlags	(	int32	itemID,
		EVEPOS::TowerData &	data
	)

Definition at line 456 of file PosMgrDB.cpp.

References EVEPOS::TowerData::anchor, EVEPOS::TowerData::offline, EVEPOS::TowerData::online, sDatabase, and EVEPOS::TowerData::unanchor.

Referenced by TowerSE::SetDeployFlags().

 {
     DBerror err;
     sDatabase.RunQuery(err,
         "UPDATE posTowerData"
         " SET anchor=%f, unanchor=%i, online=%i, offline=%i WHERE itemID = %u",
         data.anchor, data.unanchor, data.online, data.offline, itemID);
 }

Here is the caller graph for this function:

void PosMgrDB::UpdateHarmonicAndPassword	(	int32	itemID,
		EVEPOS::TowerData &	data
	)

Definition at line 430 of file PosMgrDB.cpp.

References EVEPOS::TowerData::harmonic, itemID(), EVEPOS::TowerData::password, and sDatabase.

Referenced by TowerSE::UpdatePassword().

 {
     std::string nameEsc;
     sDatabase.DoEscapeString(nameEsc, data.password);
     DBerror err;
     sDatabase.RunQuery(err, "UPDATE posTowerData SET harmonic=%i, password = '%s' WHERE itemID = %i", data.harmonic, nameEsc.c_str(), itemID);
 }

Here is the call graph for this function:

Here is the caller graph for this function:

void PosMgrDB::UpdateNotify	(	int32	itemID,
		EVEPOS::TowerData &	data
	)

Definition at line 412 of file PosMgrDB.cpp.

References sDatabase, EVEPOS::TowerData::sendFuelNotifications, and EVEPOS::TowerData::showInCalendar.

Referenced by TowerSE::UpdateNotify().

 {
     DBerror err;
     sDatabase.RunQuery(err,
         "UPDATE posTowerData"
         " SET showInCalendar=%i, sendFuelNotifications=%i"
         " WHERE itemID = %u", data.showInCalendar, data.sendFuelNotifications, itemID);
 }

Here is the caller graph for this function:

void PosMgrDB::UpdatePassword	(	int32	itemID,
		EVEPOS::TowerData &	data
	)

Definition at line 404 of file PosMgrDB.cpp.

References DBerror::c_str(), itemID(), EVEPOS::TowerData::password, and sDatabase.

 {
     std::string nameEsc;
     sDatabase.DoEscapeString(nameEsc, data.password);
     DBerror err;
     sDatabase.RunQuery(err, "UPDATE posTowerData SET password = '%s' WHERE itemID = %u", nameEsc.c_str(), itemID);
 }

Here is the call graph for this function:

void PosMgrDB::UpdatePermission	(	int32	itemID,
		EVEPOS::TowerData &	data
	)

Definition at line 438 of file PosMgrDB.cpp.

References EVEPOS::TowerData::allowAlliance, EVEPOS::TowerData::allowCorp, and sDatabase.

Referenced by TowerSE::UpdatePermission().

 {
     DBerror err;
     sDatabase.RunQuery(err,
         "UPDATE posTowerData"
         " SET allowCorp=%i, allowAlliance=%i"
         " WHERE itemID = %u", data.allowCorp, data.allowAlliance, itemID);
 }

Here is the caller graph for this function:

void PosMgrDB::UpdateReactorData	(	ReactorData *	pData,
		EVEPOS::StructureData &	sData
	)

Definition at line 284 of file PosMgrDB.cpp.

 {
 
 }

void PosMgrDB::UpdateSentry	(	int32	itemID,
		EVEPOS::TowerData &	data
	)

Definition at line 421 of file PosMgrDB.cpp.

References EVEPOS::TowerData::allyStandings, EVEPOS::TowerData::corpWar, sDatabase, EVEPOS::TowerData::standing, and EVEPOS::TowerData::statusDrop.

Referenced by TowerSE::UpdateSentry().

 {
     DBerror err;
     sDatabase.RunQuery(err,
         "UPDATE posTowerData"
         " SET standing=%f, statusDrop=%i, corpWar=%i, allyStandings=%i WHERE itemID = %u",
         data.standing, data.statusDrop, data.corpWar, data.allyStandings, itemID);
 }

Here is the caller graph for this function:

void PosMgrDB::UpdateTimeStamp	(	int32	itemID,
		EVEPOS::StructureData &	data
	)

Definition at line 386 of file PosMgrDB.cpp.

References sDatabase, and EVEPOS::StructureData::timestamp.

Referenced by StructureSE::UpdateTimeStamp().

 {
     DBerror err;
     sDatabase.RunQuery(err, "UPDATE posStructureData SET timestamp=%li WHERE itemID = %u", data.timestamp, itemID);
 }

Here is the caller graph for this function:

void PosMgrDB::UpdateUsageFlags	(	int32	itemID,
		EVEPOS::StructureData &	data
	)

Definition at line 447 of file PosMgrDB.cpp.

References sDatabase, EVEPOS::StructureData::take, EVEPOS::StructureData::use, and EVEPOS::StructureData::view.

Referenced by StructureSE::UpdateUsageFlags().

 {
     DBerror err;
     sDatabase.RunQuery(err,
         "UPDATE posStructureData"
         " SET canUse=%i, canView=%i, canTake=%i"
         " WHERE itemID = %u", data.use, data.view, data.take, itemID);
 }

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/pos/PosMgrDB.h
/backups/local/src/eve/EvEmu_Crucible/src/eve-server/pos/PosMgrDB.cpp

PosMgrDB.cpp

Additional Inherited Members

Detailed Description

Member Function Documentation