ShipDB Class Reference

#include "ShipDB.h"

Inheritance diagram for ShipDB:

Collaboration diagram for ShipDB:

Public Member Functions
PyRep *	GetInsuranceByShipID (uint32 shipID)
PyRep *	GetInsuranceByOwnerID (uint32 ownerID)
bool	InsertInsuranceByShipID (uint32 shipID, std::string name, uint32 ownerID, float level, double payOut, bool isCorpItem=false, uint8 numWeeks=12)
float	GetShipInsurancePayout (uint32 shipID)
bool	IsShipInsured (uint32 shipID)
Public Member Functions inherited from ServiceDB
uint32	GetStationOwner (uint32 stationID)

Static Public Member Functions
static void	DeleteInsuranceByShipID (uint32 shipID)
static void	LoadWeaponGroups (uint32 shipID, DBQueryResult &res)
static void	SaveWeaponGroups (uint32 shipID, std::multimap< uint32, uint32 > &data)
static void	ClearWeaponGroups (uint32 shipID)
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 37 of file ShipDB.h.

Member Function Documentation

void ShipDB::ClearWeaponGroups ( uint32  shipID )

static

Definition at line 92 of file ShipDB.cpp.

References sDatabase.

Referenced by ShipItem::UnlinkAllWeapons().

{
    DBerror err;
    sDatabase.RunQuery(err, "DELETE FROM shipWeaponGroups WHERE shipID = %u", shipID );
}

Here is the caller graph for this function:

void ShipDB::DeleteInsuranceByShipID ( uint32  shipID )

static

Definition at line 65 of file ShipDB.cpp.

References sDatabase.

Referenced by ShipSE::PayInsurance(), and TradeService::TransferContainerContents().

                                                  {
    DBerror err;
    sDatabase.RunQuery(err, "DELETE FROM shipInsurance WHERE shipID=%u", shipID);
}

Here is the caller graph for this function:

PyRep * ShipDB::GetInsuranceByOwnerID

(

uint32

ownerID

)

Definition at line 46 of file ShipDB.cpp.

References DBResultToRowset(), and sDatabase.

                                                   {
    DBQueryResult res;
    sDatabase.RunQuery(res,
        "SELECT startDate, shipName, shipID, endDate, ownerID, fraction"
        " FROM shipInsurance"
        " WHERE ownerID = %u", ownerID );

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * ShipDB::GetInsuranceByShipID

(

uint32

shipID

)

Definition at line 32 of file ShipDB.cpp.

References DBRowToRow(), DBQueryResult::GetRow(), PyStatic, and sDatabase.

                                                 {
    DBQueryResult res;
    DBResultRow row;
    sDatabase.RunQuery(res,
        "SELECT startDate, shipName, shipID, endDate, ownerID, fraction"
        " FROM shipInsurance"
        " WHERE shipID = %u", shipID );

    if (res.GetRow(row))
        return DBRowToRow(row);

    return PyStatic.NewZero();
}

Here is the call graph for this function:

float ShipDB::GetShipInsurancePayout

(

uint32

shipID

)

Todo:

send mail to owner about no insurance, so limited payout. from SCC

Definition at line 70 of file ShipDB.cpp.

References DBResultRow::GetFloat(), DBQueryResult::GetRow(), and sDatabase.

Referenced by ShipSE::PayInsurance().

                                                  {
    DBQueryResult res;
    DBResultRow row;
    sDatabase.RunQuery(res, "SELECT payOutAmount FROM shipInsurance WHERE shipID = %u", shipID);
    if (res.GetRow(row))
        return row.GetFloat(0);

    return 15000;  //default to flat 15K for no insurance.
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool ShipDB::InsertInsuranceByShipID	(	uint32	shipID,
		std::string	name,
		uint32	ownerID,
		float	level,
		double	payOut,
		bool	isCorpItem = false,
		uint8	numWeeks = 12
	)

Definition at line 56 of file ShipDB.cpp.

References DBerror::c_str(), GetFileTimeNow(), sDatabase, and EvE::Time::Week.

                                                                                                                                                  {
    DBerror err;
    return sDatabase.RunQuery(err, "INSERT INTO shipInsurance"
            " (shipID, shipName, ownerID, isCorpItem, startDate, endDate, fraction, payOutAmount)"
            " VALUES (%u, '%s', %u, %u, %f, %f, %.2f, %f)",
                       shipID, name.c_str(), ownerID, isCorpItem, GetFileTimeNow(), \
                       (GetFileTimeNow() + (EvE::Time::Week * numWeeks)), fraction, payOut );
}

Here is the call graph for this function:

bool ShipDB::IsShipInsured

(

uint32

shipID

)

Definition at line 81 of file ShipDB.cpp.

References DBQueryResult::GetRow(), and sDatabase.

{
    DBQueryResult res;
    sDatabase.RunQuery(res, "SELECT ownerID FROM shipInsurance WHERE shipID = %u", shipID );
    DBResultRow row;
    if (res.GetRow(row))
        return true;

    return false;
}

Here is the call graph for this function:

void ShipDB::LoadWeaponGroups ( uint32  shipID, DBQueryResult &  res  )

static

Definition at line 98 of file ShipDB.cpp.

References sDatabase.

Referenced by ShipItem::LoadWeaponGroups().

{
    sDatabase.RunQuery(res, "SELECT masterID, slaveID FROM shipWeaponGroups WHERE shipID = %u", shipID );
}

Here is the caller graph for this function:

void ShipDB::SaveWeaponGroups ( uint32  shipID, std::multimap< uint32, uint32 > &  data  )

static

Definition at line 103 of file ShipDB.cpp.

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

Referenced by ShipItem::SaveWeaponGroups().

{
    DBerror err;
    sDatabase.RunQuery(err, "DELETE FROM shipWeaponGroups WHERE shipID = %u", shipID );
    std::ostringstream Inserts;
    // start the insert data.
    Inserts << "INSERT INTO shipWeaponGroups";
    Inserts << " (shipID, masterID, slaveID)";
    bool first = true;
    for (auto cur : data) {
        if (first) {
            Inserts << " VALUES ";
            first = false;
        } else {
            Inserts << ", ";
        }
        Inserts << "(" << shipID << ", " << cur.first << ", " << cur.second << ")";
    }

    if (!first)
        if (!sDatabase.RunQuery(err, Inserts.str().c_str()))
            _log(DATABASE__ERROR, "SaveLinkedWeapons - unable to save data - %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/ship/ShipDB.h
• /backups/local/src/eve/EvEmu_Crucible/src/eve-server/ship/ShipDB.cpp