TutorialDB Class Reference

#include "TutorialDB.h"

Inheritance diagram for TutorialDB:

Collaboration diagram for TutorialDB:

Public Member Functions
PyRep *	GetPageCriterias (uint32 tutorialID)
PyRep *	GetPages (uint32 tutorialID)
PyRep *	GetTutorial (uint32 tutorialID)
PyRep *	GetTutorialCriterias (uint32 tutorialID)
PyRep *	GetAllTutorials ()
PyRep *	GetAllCriterias ()
PyRep *	GetCategories ()
PyRep *	GetTutorialsAndConnections (uint8 raceID)
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 34 of file TutorialDB.h.

Member Function Documentation

PyRep * TutorialDB::GetAllCriterias

(

)

Definition at line 107 of file TutorialDB.cpp.

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

                                   {
    DBQueryResult res;

    if(!sDatabase.RunQuery(res,
        "SELECT criteriaID, criteriaName, messageText, audioPath, 0 AS dataID"
        " FROM tutorial_criteria"))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * TutorialDB::GetAllTutorials

(

)

Definition at line 92 of file TutorialDB.cpp.

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

                                   {
    /*  this is wrong...our db is incomplete */
    DBQueryResult res;

    if(!sDatabase.RunQuery(res,
        "SELECT tutorialID, tutorialName, nextTutorialID, categoryID, 0 AS dataID"
        " FROM tutorials"))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * TutorialDB::GetCategories

(

)

Definition at line 121 of file TutorialDB.cpp.

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

                                 {
    DBQueryResult res;

    if(!sDatabase.RunQuery(res,
        "SELECT"
        " categoryID, categoryName, description, 0 AS dataID"
        " FROM tutorial_categories"))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * TutorialDB::GetPageCriterias

(

uint32

tutorialID

)

Definition at line 30 of file TutorialDB.cpp.

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

                                                     {
    DBQueryResult res;

    if(!sDatabase.RunQuery(res,
        "SELECT pageID, criteriaID"
        " FROM tutorial_pages"
        " JOIN tutorial_page_criteria USING (pageID)"
        " WHERE tutorialID=%u", tutorialID))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * TutorialDB::GetPages

(

uint32

tutorialID

)

Definition at line 46 of file TutorialDB.cpp.

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

                                             {
    DBQueryResult res;

    if(!sDatabase.RunQuery(res,
        "SELECT pageID, pageNumber, pageName, text, imagePath, audioPath, 0 AS dataID"
        " FROM tutorial_pages"
        " WHERE tutorialID=%u"
        " ORDER BY pageNumber", tutorialID))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * TutorialDB::GetTutorial

(

uint32

tutorialID

)

Definition at line 62 of file TutorialDB.cpp.

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

                                                {
    DBQueryResult res;

    if(!sDatabase.RunQuery(res,
        "SELECT tutorialID, tutorialName, nextTutorialID, 0 AS dataID"
        " FROM tutorials"
        " WHERE tutorialID=%u", tutorialID))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * TutorialDB::GetTutorialCriterias

(

uint32

tutorialID

)

Definition at line 77 of file TutorialDB.cpp.

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

                                                         {
    DBQueryResult res;

    if(!sDatabase.RunQuery(res,
        "SELECT criteriaID"
        " FROM tutorials_criterias"
        " WHERE tutorialID=%u", tutorialID))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * TutorialDB::GetTutorialsAndConnections

(

uint8

raceID

)

Definition at line 136 of file TutorialDB.cpp.

References DBResultToRowset(), and sDatabase.

                                                          {
    DBQueryResult res;
    sDatabase.RunQuery(res, "SELECT tutorialID, %u AS raceID, nextTutorialID FROM tutorials", raceID);
    /*
    DBQueryResult res;
    if(!sDatabase.RunQuery(res, "SELECT `tutorialID`, `tutorialName`, `categoryID`, `dataID`, `tutorialNameID` FROM `tutorialsvc_tutorials`")) {
        sLog.Error("TutorialService","GetTutorialsAndConnections query1 error: %s", res.error.c_str());
        return nullptr;
    }
    PyObjectEx *tutorials = DBResultToCRowset(res);

    res.Reset();
    if(!sDatabase.RunQuery(res, "SELECT `tutorialID`, `raceID`, `nextTutorialID`, `dataID` FROM `tutorialsvc_connections`")) {
        sLog.Error("TutorialService","GetTutorialsAndConnections query2 error: %s", res.error.c_str());
        return nullptr;
    }
    DBRowDescriptor
    PyObjectEx *connections = DBResultToCRowset(res);
    PyList *rtn = new PyList(2);
    rtn->SetItem(0, tutorials);
    rtn->SetItem(1, connections);
    rtn->Dump(stdout, "GTAC:   ");
    return rtn; */
    return DBResultToRowset(res);
}

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