SovereigntyDB Class Reference

#include "SovereigntyDB.h"

Inheritance diagram for SovereigntyDB:

Collaboration diagram for SovereigntyDB:

Static Public Member Functions
static void	GetSovereigntyData (DBQueryResult &res)
static void	GetSovereigntyDataForSystem (DBQueryResult &res, uint32 systemID)
static void	AddSovereigntyData (SovereigntyData data, uint32 &claimID)
static void	RemoveSovereigntyData (uint32 systemID)
static void	SetContested (uint32 systemID, bool contested)
static void	SetHubID (uint32 systemID, uint32 hubID)
static void	SetJammerID (uint32 systemID, uint32 jammerID)
static void	SetBeaconID (uint32 systemID, uint32 beaconID)
static void	GetUpgradeData (DBQueryResult &res)
static void	GetUpgradesForSystem (DBQueryResult &res, uint32 systemID)
static void	AddSystemUpgrade (uint32 systemID, uint32 upgradeID)
static void	RemoveSystemUpgrade (uint32 systemID, uint32 upgradeID)
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
Public Member Functions inherited from ServiceDB
uint32	GetStationOwner (uint32 stationID)
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 34 of file SovereigntyDB.h.

Member Function Documentation

void SovereigntyDB::AddSovereigntyData ( SovereigntyData  data, uint32 &  claimID  )

static

Definition at line 60 of file SovereigntyDB.cpp.

References SovereigntyData::allianceID, DBerror::c_str(), SovereigntyData::claimStructureID, codelog, SovereigntyData::contested, SovereigntyData::corporationID, GetFileTimeNow(), SovereigntyData::hubID, sDatabase, and SovereigntyData::solarSystemID.

Referenced by SovereigntyDataMgr::AddSovClaim().

{
    DBerror err;
    if (!sDatabase.RunQueryLID(err, claimID,
                            "INSERT into mapSystemSovInfo (solarSystemID, corporationID, "
                            " allianceID, claimStructureID, claimTime, hubID, contested) "
                            " VALUES (%u, %u, %u, %u, %f, %u, %u)", data.solarSystemID, 
                            data.corporationID, data.allianceID, data.claimStructureID, 
                            GetFileTimeNow(), data.hubID, data.contested))
    {
        codelog(SOV__ERROR, "Error in adding new claim: %s", err.c_str());
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

static void SovereigntyDB::AddSystemUpgrade ( uint32  systemID, uint32  upgradeID  )

static

void SovereigntyDB::GetSovereigntyData ( DBQueryResult &  res )

static

Definition at line 31 of file SovereigntyDB.cpp.

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

Referenced by SovereigntyDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res,
                            "SELECT mapSystemSovInfo.solarSystemID, mapSolarSystems.constellationID, mapSolarSystems.regionID, corporationID, "
                            " allianceID, claimStructureID, claimTime, "
                            " hubID, contested, 0 as stationCount, "
                            " 5 as militaryPoints, 5 as industrialPoints, claimID, beaconID, jammerID"
                            " FROM mapSystemSovInfo "
                            " INNER JOIN mapSolarSystems ON mapSolarSystems.solarSystemID=mapSystemSovInfo.solarSystemID"))
    {
        codelog(SOV__ERROR, "Error in query: %s", res.error.c_str());
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

void SovereigntyDB::GetSovereigntyDataForSystem ( DBQueryResult &  res, uint32  systemID  )

static

Definition at line 45 of file SovereigntyDB.cpp.

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

Referenced by SovereigntyDataMgr::UpdateClaim().

{
    if (!sDatabase.RunQuery(res,
                            "SELECT mapSystemSovInfo.solarSystemID, mapSolarSystems.constellationID, mapSolarSystems.regionID, corporationID, "
                            " allianceID, claimStructureID, claimTime, "
                            " hubID, contested, 0 as stationCount, "
                            " 5 as militaryPoints, 5 as industrialPoints, claimID, beaconID, jammerID"
                            " FROM mapSystemSovInfo "
                            " INNER JOIN mapSolarSystems ON mapSolarSystems.solarSystemID=mapSystemSovInfo.solarSystemID"
                            " WHERE mapSystemSovInfo.solarSystemID=%u ", systemID))
    {
        codelog(SOV__ERROR, "Error in query: %s", res.error.c_str());
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

static void SovereigntyDB::GetUpgradeData ( DBQueryResult &  res )

static

static void SovereigntyDB::GetUpgradesForSystem ( DBQueryResult &  res, uint32  systemID  )

static

void SovereigntyDB::RemoveSovereigntyData ( uint32  systemID )

static

Definition at line 74 of file SovereigntyDB.cpp.

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

Referenced by SovereigntyDataMgr::RemoveSovClaim().

{
    DBerror err;
    if (!sDatabase.RunQuery(err,
                            "DELETE from mapSystemSovInfo WHERE solarSystemID=%u", systemID))
    {
        codelog(SOV__ERROR, "Error in removing claim: %s", err.c_str());
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

static void SovereigntyDB::RemoveSystemUpgrade ( uint32  systemID, uint32  upgradeID  )

static

void SovereigntyDB::SetBeaconID ( uint32  systemID, uint32  beaconID  )

static

Definition at line 114 of file SovereigntyDB.cpp.

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

Referenced by SovereigntyDataMgr::UpdateSystemBeaconID().

{
    DBerror err;
    if (!sDatabase.RunQuery(err,
                            "UPDATE mapSystemSovInfo SET beaconID=%u WHERE solarSystemID=%u", beaconID, systemID))
    {
        codelog(SOV__ERROR, "Error in changing Beacon ID: %s", err.c_str());
    }
}

void SovereigntyDB::SetContested ( uint32  systemID, bool  contested  )

static

Definition at line 84 of file SovereigntyDB.cpp.

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

Referenced by SovereigntyDataMgr::MarkContested().

{
    DBerror err;
    if (!sDatabase.RunQuery(err,
                            "UPDATE mapSystemSovInfo SET contested=%u WHERE solarSystemID=%u", int(contested), systemID))
    {
        codelog(SOV__ERROR, "Error in changing contested state: %s", err.c_str());
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

void SovereigntyDB::SetHubID ( uint32  systemID, uint32  hubID  )

static

Definition at line 94 of file SovereigntyDB.cpp.

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

Referenced by SovereigntyDataMgr::UpdateSystemHubID().

{
    DBerror err;
    if (!sDatabase.RunQuery(err,
                            "UPDATE mapSystemSovInfo SET hubID=%u WHERE solarSystemID=%u", hubID, systemID))
    {
        codelog(SOV__ERROR, "Error in changing IHub ID: %s", err.c_str());
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

void SovereigntyDB::SetJammerID ( uint32  systemID, uint32  jammerID  )

static

Definition at line 104 of file SovereigntyDB.cpp.

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

Referenced by SovereigntyDataMgr::UpdateSystemJammerID().

{
    DBerror err;
    if (!sDatabase.RunQuery(err,
                            "UPDATE mapSystemSovInfo SET jammerID=%u WHERE solarSystemID=%u", jammerID, systemID))
    {
        codelog(SOV__ERROR, "Error in changing Jammer ID: %s", err.c_str());
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

---

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

• /backups/local/src/eve/EvEmu_Crucible/src/eve-server/system/sov/SovereigntyDB.h
• /backups/local/src/eve/EvEmu_Crucible/src/eve-server/system/sov/SovereigntyDB.cpp