CommandDB Class Reference

#include "CommandDB.h"

Inheritance diagram for CommandDB:

Collaboration diagram for CommandDB:

Public Member Functions
bool	ItemSearch (const char *query, std::map< uint32, std::string > &into)
bool	ItemSearch (uint32 typeID, uint32 &actualTypeID, std::string &actualTypeName, uint32 &actualGroupID, uint32 &actualCategoryID, double &actualRadius)
int	GetAttributeID (const char *attributeName)
int	GetAccountID (std::string name)
bool	FullSkillList (std::vector< uint32 > &skillList)
uint32_t	GetStation (const char *name)
uint32_t	GetSolarSystem (const char *name)
Public Member Functions inherited from ServiceDB
uint32	GetStationOwner (uint32 stationID)

Additional Inherited Members
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 30 of file CommandDB.h.

Member Function Documentation

bool CommandDB::FullSkillList

(

std::vector< uint32 > &

skillList

)

Definition at line 213 of file CommandDB.cpp.

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

Referenced by Command_giveallskills().

                                                          {
    skillList.clear();

    DBQueryResult result;
    if (!sDatabase.RunQuery(result,
        " SELECT typeID FROM `invTypes` WHERE "
        " ((`groupID` IN (SELECT groupID FROM invGroups WHERE categoryID = 16)) AND (published = 1)) "
        ))
    {
        codelog(SERVICE__ERROR, "Error in query: %s", result.error.c_str());
        return false;
    }

    DBResultRow row;
    while (result.GetRow(row)) {
        skillList.push_back( (row.GetInt(0)) );
    }

    // Because we searched skills with published = 1 and some GM skills are not published but still usable,
    // we will add them manually here:
    skillList.push_back( 3755 );    // Jove Frigate
    skillList.push_back( 3758 );    // Jove Cruiser
    skillList.push_back( 9955 );    // Polaris
    skillList.push_back( 10264 );   // Concord
    skillList.push_back( 11075 );   // Jove Industrial
    skillList.push_back( 11078 );   // Jove Battleship
    skillList.push_back( 19430 );   // Omnipotent
    skillList.push_back( 28604 );   // Tournament Observation

    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

int CommandDB::GetAccountID

(

std::string

name

)

Definition at line 193 of file CommandDB.cpp.

References DBResultRow::GetInt(), DBQueryResult::GetRow(), sDatabase, and sLog.

Referenced by Command_unban().

                                          {

    if (!sDatabase.IsSafeString(name))
        return 0;

    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT accountID FROM chrCharacters WHERE name = '%s'", name.c_str())) {
        sLog.Error("CommandDB", "Failed to retrieve accountID for %s", name.c_str());
        return 0;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        sLog.Error("CommandDB", "Query Returned no results");
        return 0;
    }

    return row.GetInt(0);
}

Here is the call graph for this function:

Here is the caller graph for this function:

int CommandDB::GetAttributeID

(

const char *

attributeName

)

Definition at line 163 of file CommandDB.cpp.

References codelog, DBQueryResult::GetRow(), DBResultRow::GetUInt(), and sDatabase.

Referenced by Command_dogma().

                                                       {

    if (!sDatabase.IsSafeString(attributeName))
        return 0;

    DBQueryResult res;
    std::string escape;
    sDatabase.DoEscapeString(escape, attributeName);

    if(!sDatabase.RunQuery(res,
        " SELECT "
        " attributeID "
        " FROM dgmAttributeTypes "
        " WHERE attributeName = '%s' ",
        escape.c_str() ) )
    {
        codelog(DATABASE__ERROR, "Error retrieving attributeID for attributeName = '%s' ", escape.c_str() );
        return 0;
    }

    DBResultRow row;
    if( !res.GetRow(row) ){
        codelog(DATABASE__ERROR, "Null result finding attributeID for attributeName = '%s' ", escape.c_str() );
        return 0;
    }

    return row.GetUInt( 0 );

}

Here is the call graph for this function:

Here is the caller graph for this function:

uint32_t CommandDB::GetSolarSystem

(

const char *

name

)

Todo:

update this...

Definition at line 32 of file CommandDB.cpp.

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

Referenced by Command_tr().

                                                   {
    //sDatabase.ReplaceSlash(name);
    if (!sDatabase.IsSafeString(name))
        return 0;

    std::string escaped;
    sDatabase.DoEscapeString(escaped, name);

    DBQueryResult result;
    if (!sDatabase.RunQuery(result,
                            "SELECT solarSystemID "
                            "FROM mapSolarSystems "
                            "WHERE solarSystemName LIKE '%%%s%%';",
                            escaped.c_str()
                            )) {
        codelog(DATABASE__ERROR, "Error in query: %s", result.error.c_str());
        return 0;
    }

    DBResultRow row;
    if (!result.GetRow(row)) {
        codelog(COMMAND__ERROR, "Solar System query returned nothing");
        return 0;
    }

    return row.GetUInt(0);
}

Here is the call graph for this function:

Here is the caller graph for this function:

uint32_t CommandDB::GetStation

(

const char *

name

)

Definition at line 60 of file CommandDB.cpp.

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

Referenced by Command_tr().

{
    if (!sDatabase.IsSafeString(name))
        return 0;

    std::string escaped;
    sDatabase.DoEscapeString(escaped, name);

    DBQueryResult result;
    if (!sDatabase.RunQuery(result,
                "SELECT `stationID`"
                " FROM `staStations`"
                " WHERE `stationName` LIKE '%%%s%%';",
                escaped.c_str()
        )) {
        codelog(DATABASE__ERROR, "Error in query: %s", result.error.c_str());
        return 0;
    }

    DBResultRow row;
    if (!result.GetRow(row)) {
        codelog(COMMAND__ERROR, "Station query returned nothing");
        return 0;
    }

    return row.GetUInt(0);
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool CommandDB::ItemSearch	(	const char *	query,
		std::map< uint32, std::string > &	into
	)

Definition at line 89 of file CommandDB.cpp.

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

Referenced by Command_search(), Command_spawn(), Command_spawnn(), and generic_createitem().

                                                                             {

    into.clear();

    //sDatabase.ReplaceSlash(query);
    if (!sDatabase.IsSafeString(query))
        return 0;

    std::string escaped;
    sDatabase.DoEscapeString(escaped, query);


    //we need to query out the primary message here... not sure how to properly
    //grab the "main message" though... the text/plain clause is pretty hackish.
    DBQueryResult result;
    if (!sDatabase.RunQuery(result,
        " SELECT typeID,typeName"
        " FROM invTypes"
        " WHERE"
        "  typeName rlike '%s'",
            escaped.c_str()
        ))
    {
        codelog(SERVICE__ERROR, "Error in query: %s", result.error.c_str());
        return (false);
    }

    DBResultRow row;
    while(result.GetRow(row)) {
        into[row.GetUInt(0)] = row.GetText(1);
    }
    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool CommandDB::ItemSearch	(	uint32	typeID,
		uint32 &	actualTypeID,
		std::string &	actualTypeName,
		uint32 &	actualGroupID,
		uint32 &	actualCategoryID,
		double &	actualRadius
	)

Definition at line 123 of file CommandDB.cpp.

References DBerror::c_str(), DBQueryResult::error, DBResultRow::GetDouble(), DBQueryResult::GetRow(), DBResultRow::GetText(), DBResultRow::GetUInt(), sDatabase, and sLog.

{
    DBQueryResult result;
    DBResultRow row;

    if (!sDatabase.RunQuery(result,
        "SELECT  "
        " invTypes.typeID,"
        " invTypes.typeName,"
        " invTypes.groupID,"
        " invTypes.radius,"
        " invGroups.categoryID"
        " FROM invTypes"
        "  LEFT JOIN invGroups"
        "   ON invGroups.groupID = invTypes.groupID"
        " WHERE typeID = %u",
        typeID
        ))
    {
        sLog.Error( "CommandDB::ItemSearch()", "Error in query: %s", result.error.c_str() );
        return (false);
    }

    if( !result.GetRow(row) )
    {
        sLog.Error( "CommandDB::ItemSearch()", "Query returned NO results: %s", result.error.c_str() );
        return (false);
    }

    // Extract values from the first row:
    actualTypeID = row.GetUInt( 0 );
    actualTypeName = row.GetText( 1 );
    actualGroupID = row.GetUInt( 2 );
    actualCategoryID = row.GetUInt( 4 );
    actualRadius = row.GetDouble( 3 );

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