FactoryDB Class Reference

#include "FactoryDB.h"

Inheritance diagram for FactoryDB:

Collaboration diagram for FactoryDB:

Static Public Member Functions
FactoryDB.cpp
db query methods for R.A.M. activities : Allan Date : 9Jan18 UD 5Nov20
static PyRep *	GetJobs2 (const int32 ownerID, const bool completed)
static PyRep *	AssemblyLinesSelectPublic (const uint32 regionID)
static PyRep *	AssemblyLinesSelectPersonal (const uint32 charID)
static PyRep *	AssemblyLinesSelectPrivate (const uint32 charID)
static PyRep *	AssemblyLinesSelectCorporation (const uint32 corporationID)
static PyRep *	AssemblyLinesSelectAlliance (const int32 allianceID)
static PyRep *	AssemblyLinesGet (const uint32 containerID)
static PyRep *	GetMaterialCompositionOfItemType (const uint32 typeID)
static bool	IsRefinable (const uint16 typeID)
static bool	IsRecyclable (const uint16 typeID)
static void	GetSalvage (DBQueryResult &res)
static void	GetMinerals (DBQueryResult &res)
static void	GetCompounds (DBQueryResult &res)
static void	GetResources (DBQueryResult &res)
static void	GetComponents (DBQueryResult &res)
static void	GetCommodities (DBQueryResult &res)
static void	GetMiscCommodities (DBQueryResult &res)
static void	GetRAMMaterials (DBQueryResult &res)
static void	GetBlueprintType (DBQueryResult &res)
static void	GetRAMRequirements (DBQueryResult &res)
static bool	GetAssemblyLineProperties (const uint32 assemblyLineID, Character *pChar, Rsp_InstallJob &into, bool isCorpJob=false)
static bool	GetAssemblyLineRestrictions (const int32 assemblyLineID, EvERam::LineRestrictions &data)
static uint32	InstallJob (const uint32 ownerID, const uint32 installerID, Call_InstallJob &args, const int64 beginTime, const int64 endTime, const uint32 systemID)
static bool	GetJobProperties (const uint32 jobID, EvERam::JobProperties &data)
static bool	CompleteJob (const uint32 jobID, const int8 completedStatus)
static bool	DeleteBlueprint (uint32 blueprintID)
static bool	GetBlueprint (uint32 blueprintID, EvERam::bpData &into)
static bool	SaveBlueprintData (uint32 blueprintID, EvERam::bpData &data)
static bool	IsProducableBy (const uint32 assemblyLineID, const ItemType *pType)
static bool	GetMultipliers (const uint32 assemblyLineID, const ItemType *pType, Rsp_InstallJob &into)
static uint32	CountManufacturingJobs (const uint32 installerID)
static uint32	CountResearchJobs (const uint32 installerID)
static uint32	GetTech2Blueprint (const uint32 blueprintTypeID)
static int64	GetNextFreeTime (const uint32 assemblyLineID)
static void	SetJobEventID (const uint32 jobID, const uint32 eventID)
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 21 of file FactoryDB.h.

Member Function Documentation

PyRep * FactoryDB::AssemblyLinesGet ( const uint32  containerID )

static

Todo:

need to add check/query for POS assembly modules here

Definition at line 370 of file FactoryDB.cpp.

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

                                                           {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT"
        " assemblyLineID,"
        " assemblyLineTypeID,"
        " containerID,"
        " nextFreeTime,"
        " costInstall,"
        " costPerHour,"
        " restrictionMask,"
        " discountPerGoodStandingPoint,"
        " surchargePerBadStandingPoint,"
        " minimumStanding,"
        " minimumCharSecurity,"
        " minimumCorpSecurity,"
        " maximumCharSecurity,"
        " maximumCorpSecurity"
        " FROM ramAssemblyLines"
        " WHERE containerID = %u",
        containerID)) {
        _log(DATABASE__ERROR, "Failed to query assembly lines for container %u: %s.", containerID, res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * FactoryDB::AssemblyLinesSelectAlliance ( const int32  allianceID )

static

Todo:

need to add check/query for POS assembly modules here

Definition at line 344 of file FactoryDB.cpp.

References _log, EvERam::RestrictionMask::ByAlliance, DBerror::c_str(), DBResultToCRowset(), DBQueryResult::error, and sDatabase.

                                                                    {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT"
        " station.stationID AS containerID,"
        " station.stationTypeID AS containerTypeID,"
        " station.solarSystemID AS containerLocationID,"
        " station.assemblyLineTypeID,"
        " station.quantity,"
        " station.ownerID"
        " FROM ramAssemblyLineStations AS station"
        " LEFT JOIN crpCorporation AS crp ON station.ownerID = crp.corporationID"
        " LEFT JOIN ramAssemblyLines AS line ON station.stationID = line.containerID AND station.assemblyLineTypeID = line.assemblyLineTypeID AND station.ownerID = line.ownerID"
        " WHERE crp.allianceID = %u"
        " AND (line.restrictionMask & %u) = %u",
        allianceID, EvERam::RestrictionMask::ByAlliance, EvERam::RestrictionMask::ByAlliance))
    {
        _log(DATABASE__ERROR, "Failed to query alliance assembly lines for alliance %u: %s.", allianceID, res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * FactoryDB::AssemblyLinesSelectCorporation ( const uint32  corpID )

static

Todo:

need to add check/query for POS assembly modules here

Definition at line 319 of file FactoryDB.cpp.

References _log, EvERam::RestrictionMask::ByCorp, DBerror::c_str(), DBResultToCRowset(), DBQueryResult::error, and sDatabase.

                                                                    {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT"
        " station.stationID AS containerID,"
        " station.stationTypeID AS containerTypeID,"
        " station.solarSystemID AS containerLocationID,"
        " station.assemblyLineTypeID,"
        " station.quantity,"
        " station.ownerID"
        " FROM ramAssemblyLineStations AS station"
        " LEFT JOIN ramAssemblyLines AS line ON station.stationID = line.containerID AND station.assemblyLineTypeID = line.assemblyLineTypeID AND station.ownerID = line.ownerID"
        " WHERE station.ownerID = %u"
        " AND (line.restrictionMask & %u) = %u",
        corpID, EvERam::RestrictionMask::ByCorp, EvERam::RestrictionMask::ByCorp))
    {
        _log(DATABASE__ERROR, "Failed to query corporation assembly lines for corp %u: %s.", corpID, res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * FactoryDB::AssemblyLinesSelectPersonal ( const uint32  charID )

static

Definition at line 271 of file FactoryDB.cpp.

References _log, EvERam::RestrictionMask::ByAlliance, EvERam::RestrictionMask::ByCorp, DBerror::c_str(), DBResultToCRowset(), DBQueryResult::error, and sDatabase.

                                                                 {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT"
        " station.stationID AS containerID,"
        " station.stationTypeID AS containerTypeID,"
        " station.solarSystemID AS containerLocationID,"
        " station.assemblyLineTypeID,"
        " station.quantity,"
        " station.ownerID"
        " FROM ramAssemblyLineStations AS station"
        " LEFT JOIN ramAssemblyLines AS line ON station.stationID = line.containerID AND station.assemblyLineTypeID = line.assemblyLineTypeID AND station.ownerID = line.ownerID"
        " WHERE station.ownerID = %u"
        " AND (line.restrictionMask & %u) = %u",
        charID, (EvERam::RestrictionMask::ByCorp | EvERam::RestrictionMask::ByAlliance), (EvERam::RestrictionMask::ByCorp | EvERam::RestrictionMask::ByAlliance)))
    {
        _log(DATABASE__ERROR, "Failed to query personal assembly lines for char %u: %s.", charID, res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * FactoryDB::AssemblyLinesSelectPrivate ( const uint32  charID )

static

Definition at line 295 of file FactoryDB.cpp.

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

                                                                {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT"
        " station.stationID AS containerID,"
        " station.stationTypeID AS containerTypeID,"
        " station.solarSystemID AS containerLocationID,"
        " station.assemblyLineTypeID,"
        " station.quantity,"
        " station.ownerID"
        " FROM ramAssemblyLineStations AS station"
        " LEFT JOIN ramAssemblyLines AS line ON station.stationID = line.containerID AND station.assemblyLineTypeID = line.assemblyLineTypeID AND station.ownerID = line.ownerID"
        " WHERE station.ownerID = %u",
        charID))
    {
        _log(DATABASE__ERROR, "Failed to query private assembly lines for char %u: %s.", charID, res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * FactoryDB::AssemblyLinesSelectPublic ( const uint32  regionID )

static

Definition at line 245 of file FactoryDB.cpp.

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

                                                                 {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT"
        " station.stationID AS containerID,"
        " station.stationTypeID AS containerTypeID,"
        " station.solarSystemID AS containerLocationID,"
        " station.assemblyLineTypeID,"
        " station.quantity,"
        " station.ownerID,"
        " types.activityID"
        " FROM ramAssemblyLineStations AS station"
        " LEFT JOIN crpNPCCorporations AS corp ON station.ownerID = corp.corporationID"
        " LEFT JOIN ramAssemblyLineTypes as types ON station.assemblyLineTypeID = types.assemblyLineTypeID"
        " WHERE station.ownerID = corp.corporationID"
        " AND station.regionID = %u",
        regionID))
    {
        _log(DATABASE__ERROR, "Failed to query public assembly lines for region %u: %s.", regionID, res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

bool FactoryDB::CompleteJob ( const uint32  jobID, const int8  completedStatus  )

static

Definition at line 636 of file FactoryDB.cpp.

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

                                                                          {
    DBerror err;

    if (!sDatabase.RunQuery(err, "UPDATE ramJobs SET completedStatusID = %i WHERE jobID = %u", completedStatus, jobID)) {
        _log(DATABASE__ERROR, "Failed to complete job %u (status = %i): %s.", jobID, completedStatus, err.c_str());
        return false;
    }

    return true;
}

Here is the call graph for this function:

uint32 FactoryDB::CountManufacturingJobs ( const uint32  installerID )

static

Definition at line 554 of file FactoryDB.cpp.

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

Referenced by RamMethods::JobsCheck().

                                                                 {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT"
        " COUNT(job.jobID)"
        " FROM ramJobs AS job"
        " LEFT JOIN ramAssemblyLines AS line USING (assemblyLineID)"
        " WHERE job.installerID = %u"
        " AND job.completedStatusID = 0"
        " AND line.activityID = 1",
        installerID))
    {
        _log(DATABASE__ERROR, "Failed to count manufacturing jobs for installer %u.", installerID);
        return 0;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        _log(DATABASE__ERROR, "No rows returned while counting manufacturing jobs for installer %u.", installerID);
        return 0;
    }

    return row.GetUInt(0);
}

Here is the call graph for this function:

Here is the caller graph for this function:

uint32 FactoryDB::CountResearchJobs ( const uint32  installerID )

static

Definition at line 579 of file FactoryDB.cpp.

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

Referenced by RamMethods::JobsCheck().

                                                            {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT"
        " COUNT(job.jobID)"
        " FROM ramJobs AS job"
        " LEFT JOIN ramAssemblyLines AS line USING (assemblyLineID)"
        " WHERE job.installerID = %u"
        " AND job.completedStatusID = 0"
        " AND line.activityID != 1",    // is this accurate?
        installerID))
    {
        _log(DATABASE__ERROR, "Failed to count research jobs for installer %u.", installerID);
        return 0;
    }

    DBResultRow row;
    if (!res.GetRow(row))
        return 0;

    return row.GetUInt(0);
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool FactoryDB::DeleteBlueprint ( uint32  blueprintID )

static

Definition at line 94 of file FactoryDB.cpp.

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

Referenced by Blueprint::Delete().

                                                  {
    DBerror err;
    if(!sDatabase.RunQuery(err, "DELETE FROM invBlueprints WHERE itemID=%u", blueprintID)) {
        _log(DATABASE__ERROR, "Failed to delete blueprint %u: %s.", blueprintID, err.c_str());
        return false;
    }
    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool FactoryDB::GetAssemblyLineProperties ( const uint32  assemblyLineID, Character *  pChar, Rsp_InstallJob &  into, bool  isCorpJob = false  )

static

Todo:

need to add check/query for POS assembly modules here

Todo:

this shit will have to be verified for negative standings

Definition at line 400 of file FactoryDB.cpp.

References _log, DBerror::c_str(), Character::corporationID(), DBQueryResult::error, DBResultRow::GetFloat(), DBResultRow::GetInt(), DBQueryResult::GetRow(), StandingDB::GetStanding(), InventoryItem::itemID(), sDatabase, and sDataMgr.

Referenced by RamMethods::Calculate().

                                                                                                                              {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT"
        " alt.baseMaterialMultiplier,"
        " alt.baseTimeMultiplier,"
        " al.costInstall,"
        " alt.minCostPerHour,"
        " al.costPerHour,"
        " al.ownerID,"                          //5
        " al.discountPerGoodStandingPoint,"
        " al.surchargePerBadStandingPoint"
        " FROM ramAssemblyLines AS al"
        " LEFT JOIN ramAssemblyLineTypes AS alt USING (assemblyLineTypeID)"
        " WHERE al.assemblyLineID = %u",
        assemblyLineID))
    {
        _log(DATABASE__ERROR, "Failed to query properties for assembly line %u: %s.", assemblyLineID, res.error.c_str());
        return false;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        _log(DATABASE__ERROR, "No properties found for assembly line %u.", assemblyLineID);
        return false;
    }

    into.materialMultiplier     = row.GetFloat(0);
    into.timeMultiplier         = row.GetFloat(1);
    into.installCost            = row.GetFloat(2);
    if (row.GetFloat(3) > row.GetFloat(4)) {            //min of base cost/hr vs minimum cost/hr
        into.usageCost          = row.GetFloat(3);
    } else {
        into.usageCost          = row.GetFloat(4);
    }

    // verify line standings modifiers (some have no modifiers)
    if ((row.GetFloat(6) == 0) and (row.GetFloat(7) == 0))
        return true;

    float standing(1), costModifier(1);
    uint32 factionID(sDataMgr.GetCorpFaction(row.GetInt(5)));
    if (isCorpJob) {
        // this is only for PC corps.  take higher of (npc faction to pc corp)/2 or npc corp to pc corp
        float cStanding(StandingDB::GetStanding(row.GetInt(5), pChar->corporationID()));
        float fStanding(StandingDB::GetStanding(factionID, pChar->corporationID()));
        fStanding /= 2;
        // this works for negative standings also
        if (cStanding > fStanding) {
            standing = cStanding;
        } else {
            standing = fStanding;
        }

        // modify end result by 25% for char standings with station owner
        standing *= (1 - (0.025f * StandingDB::GetStanding(row.GetInt(5), pChar->itemID())));
    } else {
        // else take personal standings with station corp only
        standing = StandingDB::GetStanding(row.GetInt(5), pChar->itemID());
    }

    if (standing < 0) {
        costModifier += row.GetFloat(7) * -standing;
    } else {
        costModifier -= row.GetFloat(6) * standing;
    }

    // make sure costModifier isnt 0 (some lines have 0 as modifier)
    if (costModifier == 0)
        costModifier = 1;

    _log(MANUF__MESSAGE, "FactoryDB::GetALProps() - Cost Modifier %.2f, standing %.2f", costModifier, standing);

    // modify setup cost based on standings
    into.installCost *= costModifier;

    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool FactoryDB::GetAssemblyLineRestrictions ( const int32  assemblyLineID, EvERam::LineRestrictions &  data  )

static

Todo:

need to add check/query for POS assembly modules here

Definition at line 481 of file FactoryDB.cpp.

References _log, EvERam::LineRestrictions::activityID, DBerror::c_str(), DBQueryResult::error, DBResultRow::GetFloat(), DBQueryResult::GetRow(), DBResultRow::GetUInt(), EvERam::LineRestrictions::maxCharSec, EvERam::LineRestrictions::maxCorpSec, EvERam::LineRestrictions::minCharSec, EvERam::LineRestrictions::minCorpSec, EvERam::LineRestrictions::minStanding, EvERam::LineRestrictions::ownerID, EvERam::LineRestrictions::rMask, and sDatabase.

Referenced by RamMethods::LinePermissionCheck().

                                                                                                    {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT"
        " ownerID,"
        " minimumStanding,"
        " minimumCharSecurity,"
        " maximumCharSecurity,"
        " minimumCorpSecurity,"
        " maximumCorpSecurity,"
        " restrictionMask,"
        " activityID"
        " FROM ramAssemblyLines"
        " WHERE assemblyLineID = %i",
        assemblyLineID))
    {
        _log(DATABASE__ERROR, "Failed to query verify properties for assembly line %u: %s.", assemblyLineID, res.error.c_str());
        return false;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        _log(DATABASE__ERROR, "No verify properties found for assembly line %u.", assemblyLineID);
        return false;
    }

    data.ownerID        = row.GetUInt(0);
    data.minStanding    = row.GetFloat(1);
    data.minCharSec     = row.GetFloat(2);
    data.maxCharSec     = row.GetFloat(3);
    data.minCorpSec     = row.GetFloat(4);
    data.maxCorpSec     = row.GetFloat(5);
    data.rMask          = row.GetUInt(6);
    data.activityID     = row.GetUInt(7);

    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool FactoryDB::GetBlueprint ( uint32  blueprintID, EvERam::bpData &  into  )

static

Definition at line 140 of file FactoryDB.cpp.

References _log, DBerror::c_str(), codelog, EvERam::bpData::copy, DBQueryResult::error, DBResultRow::GetBool(), DBResultRow::GetInt(), DBQueryResult::GetRow(), EvERam::bpData::mLevel, EvERam::bpData::pLevel, EvERam::bpData::runs, and sDatabase.

Referenced by Blueprint::_LoadItem().

                                                                   {
    DBQueryResult res;
    if(!sDatabase.RunQuery(res,
        "SELECT"
        "  copy,"
        "  mLevel,"
        "  pLevel,"
        "  runs"
        " FROM invBlueprints"
        " WHERE itemID=%u",
        blueprintID))
    {
        codelog(DATABASE__ERROR, "Error in GetBlueprint query: %s.", res.error.c_str());
        return false;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        _log(DATABASE__MESSAGE, "Blueprint %u not found.", blueprintID);
        return false;
    }

    into.copy = row.GetBool(0);
    into.mLevel = row.GetInt(1);
    into.pLevel = row.GetInt(2);
    into.runs = row.GetInt(3);

    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

void FactoryDB::GetBlueprintType ( DBQueryResult &  res )

static

Definition at line 170 of file FactoryDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                                   {
    if (!sDatabase.RunQuery(res,
        "SELECT"
        "  blueprintTypeID,"
        "  parentBlueprintTypeID,"
        "  productTypeID,"
        "  productionTime,"
        "  techLevel,"
        "  researchProductivityTime,"
        "  researchMaterialTime,"
        "  researchCopyTime,"
        "  researchTechTime,"
        "  productivityModifier,"
        "  materialModifier,"
        "  wasteFactor,"
        "  maxProductionLimit, "
        "  chanceOfRE,"
        "  g.categoryID"
        " FROM invBlueprintTypes AS bt"
        "  LEFT JOIN invTypes AS t ON t.typeID = bt.blueprintTypeID"
        "  LEFT JOIN invGroups AS g USING (groupID)"))
        //" WHERE t.published = 1" ))
    {
        codelog(DATABASE__ERROR, "Error in GetBlueprintType query: %s.", res.error.c_str());
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

void FactoryDB::GetCommodities ( DBQueryResult &  res )

static

Definition at line 58 of file FactoryDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT typeID, typeName FROM invTypes WHERE groupID IN (1042, 1034, 1040, 1041)"))   // PI Commodities
        codelog(DATABASE__ERROR, "Error in GetCommodities query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void FactoryDB::GetComponents ( DBQueryResult &  res )

static

Definition at line 52 of file FactoryDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT typeID, typeName FROM invTypes WHERE groupID IN (280, 283, 313, 334, 428, 429, 526, 536, 873, 886, 913, 964)"))   // components
        codelog(DATABASE__ERROR, "Error in GetComponents query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void FactoryDB::GetCompounds ( DBQueryResult &  res )

static

Definition at line 40 of file FactoryDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT typeID, typeName FROM invTypes WHERE groupID IN (282, 333, 423, 427, 530, 711, 712)"))
        codelog(DATABASE__ERROR, "Error in GetCompounds query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool FactoryDB::GetJobProperties ( const uint32  jobID, EvERam::JobProperties &  data  )

static

Definition at line 603 of file FactoryDB.cpp.

References _log, EvERam::JobProperties::activity, DBerror::c_str(), EvERam::JobProperties::endTime, DBQueryResult::error, EvERam::JobProperties::eventID, DBResultRow::GetInt(), DBResultRow::GetInt64(), DBQueryResult::GetRow(), DBResultRow::GetUInt(), EvERam::JobProperties::itemID, EvERam::JobProperties::jobRuns, EvERam::JobProperties::licensedRuns, EvERam::JobProperties::outputFlag, EvERam::JobProperties::ownerID, sDatabase, and EvERam::JobProperties::status.

                                                                              {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT job.installedItemID, job.ownerID, job.outputFlag, job.runs, job.licensedProductionRuns,"
        " job.endProductionTime, job.completedStatusID, line.activityID, job.eventID"
        " FROM ramJobs AS job"
        " LEFT JOIN ramAssemblyLines AS line USING (assemblyLineID)"
        " WHERE job.jobID = %u",
        jobID))
    {
        _log(DATABASE__ERROR, "Failed to query properties of job %u: %s.", jobID, res.error.c_str());
        return false;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        _log(DATABASE__ERROR, "No properties found for job %u.", jobID);
        return false;
    }

    data.itemID         = row.GetUInt(0);
    data.ownerID        = row.GetUInt(1);
    data.outputFlag     = (EVEItemFlags)row.GetUInt(2);
    data.jobRuns        = row.GetInt(3);
    data.licensedRuns   = row.GetInt(4);
    data.endTime        = row.GetInt64(5);
    data.status         = row.GetInt(6);
    data.activity       = row.GetUInt(7);
    data.eventID        = row.GetUInt(8);

    return true;
}

Here is the call graph for this function:

PyRep * FactoryDB::GetJobs2 ( const int32  ownerID, const bool  completed  )

static

Definition at line 197 of file FactoryDB.cpp.

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

{
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT"
        " job.jobID,"
        " job.assemblyLineID,"
        " assemblyLine.containerID,"
        " job.installedItemID,"
        " installedItem.typeID AS installedItemTypeID,"
        " installedItem.ownerID AS installedItemOwnerID,"
        " blueprint.pLevel AS installedItemProductivityLevel,"
        " blueprint.mLevel AS installedItemMaterialLevel,"
        // quite ugly, but lets us use DBResultToRowset
        " IF(assemblyLine.activityID = 1, blueprintType.productTypeID, installedItem.typeID) AS outputTypeID,"
        " job.outputFlag,"
        " job.installerID,"
        " assemblyLine.activityID,"
        " job.runs,"
        " job.installTime,"
        " job.beginProductionTime,"
        " job.pauseProductionTime,"
        " job.endProductionTime,"
        " job.completedStatusID != 0 AS completed,"
        " job.licensedProductionRuns,"
        " station.solarSystemID AS installedInSolarSystemID,"
        " job.completedStatusID AS completedStatus,"
        " station.stationTypeID AS containerTypeID,"
        " station.solarSystemID AS containerLocationID"
        " FROM ramJobs AS job"
        " LEFT JOIN entity AS installedItem ON job.installedItemID = installedItem.itemID"
        " LEFT JOIN ramAssemblyLines AS assemblyLine ON job.assemblyLineID = assemblyLine.assemblyLineID"
        " LEFT JOIN invBlueprints AS blueprint ON installedItem.itemID = blueprint.itemID"
        " LEFT JOIN invBlueprintTypes AS blueprintType ON installedItem.typeID = blueprintType.blueprintTypeID"
        " LEFT JOIN ramAssemblyLineStations AS station ON assemblyLine.containerID = station.stationID"
        " WHERE job.ownerID = %u"
        " AND job.completedStatusID %s 0"
        " GROUP BY job.jobID",
        ownerID, (completed ? "!=" : "=") ))
    {
        _log(DATABASE__ERROR, "Failed to query jobs for owner %u: %s", ownerID, res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * FactoryDB::GetMaterialCompositionOfItemType ( const uint32  typeID )

static

Definition at line 103 of file FactoryDB.cpp.

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

                                                                      {
    DBQueryResult res;

    if(!sDatabase.RunQuery(res,
        "SELECT requiredTypeID AS typeID, quantity"
        " FROM ramTypeRequirements"
        " WHERE typeID = (SELECT blueprintTypeID FROM invBlueprintTypes WHERE productTypeID = %u)"
        " AND activityID = 1 AND damagePerJob = 1",
        typeID))
    {
        _log(DATABASE__ERROR, "Could not retrieve material composition for type %u : %s", typeID, res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

void FactoryDB::GetMinerals ( DBQueryResult &  res )

static

Definition at line 46 of file FactoryDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT typeID, typeName FROM invTypes WHERE groupID = 18 AND published = 1"))   // minerals
        codelog(DATABASE__ERROR, "Error in GetMinerals query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void FactoryDB::GetMiscCommodities ( DBQueryResult &  res )

static

Definition at line 64 of file FactoryDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT typeID, typeName FROM invTypes WHERE groupID = 314"))
        codelog(DATABASE__ERROR, "Error in GetMinerals query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool FactoryDB::GetMultipliers ( const uint32  assemblyLineID, const ItemType *  pType, Rsp_InstallJob &  into  )

static

Definition at line 678 of file FactoryDB.cpp.

References _log, DBerror::c_str(), ItemType::categoryID(), DBQueryResult::error, DBResultRow::GetDouble(), DBQueryResult::GetRow(), ItemType::groupID(), and sDatabase.

Referenced by RamMethods::Calculate(), and IsProducableBy().

                                                                                                       {
    DBQueryResult res;
    // check Category first
    if (!sDatabase.RunQuery(res,
        "SELECT alc.materialMultiplier, alc.timeMultiplier"
        " FROM ramAssemblyLineTypeDetailPerCategory AS alc"
        " LEFT JOIN ramAssemblyLines AS al USING (assemblyLineTypeID)"
        " WHERE al.assemblyLineID = %u AND alc.categoryID = %u",
        assemblyLineID, pType->categoryID()))
    {
        _log(DATABASE__ERROR, "Failed to check producability of cat %u by line %u: %s", pType->categoryID(), assemblyLineID, res.error.c_str());
        return false;
    }

    DBResultRow row;
    if (res.GetRow(row)) {
        into.materialMultiplier *= row.GetDouble(0);
        into.timeMultiplier *= row.GetDouble(1);
    }

    // then Group  (all materialMultiplier = 1)
    if (!sDatabase.RunQuery(res,
        "SELECT alg.materialMultiplier, alg.timeMultiplier"
        " FROM ramAssemblyLineTypeDetailPerGroup AS alg"
        " LEFT JOIN ramAssemblyLines AS al USING (assemblyLineTypeID)"
        " WHERE al.assemblyLineID = %u"
        " AND alg.groupID = %u",
        assemblyLineID, pType->groupID()))
    {
        _log(DATABASE__ERROR, "Failed to check producability of group %u by line %u: %s", pType->groupID(), assemblyLineID, res.error.c_str());
        return false;
    }

    if (res.GetRow(row)) {
        into.materialMultiplier *= row.GetDouble(0);
        into.timeMultiplier *= row.GetDouble(1);
    }

    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

int64 FactoryDB::GetNextFreeTime ( const uint32  assemblyLineID )

static

Definition at line 662 of file FactoryDB.cpp.

References _log, DBerror::c_str(), DBQueryResult::error, DBResultRow::GetInt64(), DBQueryResult::GetRow(), DBResultRow::IsNull(), and sDatabase.

Referenced by RamMethods::Calculate().

                                                            {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT nextFreeTime FROM ramAssemblyLines WHERE assemblyLineID = %u", assemblyLineID)) {
        _log(DATABASE__ERROR, "Failed to query next free time for assembly line %u: %s.", assemblyLineID, res.error.c_str());
        return 0;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        _log(DATABASE__ERROR, "Assembly line %u not found.", assemblyLineID);
        return 0;
    }

    return (row.IsNull(0) ? 0 : row.GetInt64(0));
}

Here is the call graph for this function:

Here is the caller graph for this function:

void FactoryDB::GetRAMMaterials ( DBQueryResult &  res )

static

Definition at line 76 of file FactoryDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT typeID, materialTypeID, quantity FROM invTypeMaterials"))
        codelog(DATABASE__ERROR, "Error in GetRAMMaterials query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void FactoryDB::GetRAMRequirements ( DBQueryResult &  res )

static

Definition at line 82 of file FactoryDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT typeID, activityID, requiredTypeID, quantity, damagePerJob, extra FROM ramTypeRequirements"))
        codelog(DATABASE__ERROR, "Error in GetRAMRequirements query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void FactoryDB::GetResources ( DBQueryResult &  res )

static

Definition at line 70 of file FactoryDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT typeID, typeName FROM invTypes WHERE groupID IN (1031, 1032, 1033, 1035)"))   // PI Resources
        codelog(DATABASE__ERROR, "Error in GetResources query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void FactoryDB::GetSalvage ( DBQueryResult &  res )

static

Definition at line 34 of file FactoryDB.cpp.

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

Referenced by StaticDataMgr::Populate().

{
    if (!sDatabase.RunQuery(res, "SELECT typeID, typeName FROM invTypes WHERE groupID IN (754, 966)"))
        codelog(DATABASE__ERROR, "Error in GetSalvage query: %s", res.error.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

uint32 FactoryDB::GetTech2Blueprint ( const uint32  blueprintTypeID )

static

Definition at line 647 of file FactoryDB.cpp.

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

Referenced by RamMethods::ActivityCheck().

                                                                {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res, "SELECT blueprintTypeID FROM invBlueprintTypes WHERE parentBlueprintTypeID = %u", blueprintTypeID)) {
        _log(DATABASE__ERROR, "Unable to get T2 type for type ID %u: %s", blueprintTypeID, res.error.c_str());
        return 0;
    }

    DBResultRow row;
    if (!res.GetRow(row))
        return 0;

    return row.GetUInt(0);
}

Here is the call graph for this function:

Here is the caller graph for this function:

uint32 FactoryDB::InstallJob ( const uint32  ownerID, const uint32  installerID, Call_InstallJob &  args, const int64  beginTime, const int64  endTime, const uint32  systemID  )

static

Definition at line 520 of file FactoryDB.cpp.

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

{
    DBerror err;
    uint32 jobID(0);
    // insert job
    if (!sDatabase.RunQueryLID(err, jobID,
        "INSERT INTO ramJobs"
        " (ownerID, installerID, assemblyLineID, installedItemID, installTime, beginProductionTime, endProductionTime,"
        " runs, outputFlag, licensedProductionRuns, completedStatusID, installedInSolarSystemID)"
        " VALUES"
        " (%u, %u, %i, %i, %.0f, %li, %li,"
        " %i, %i, %i, 0, %i)",
        ownerID, installerID, args.AssemblyLineID, args.bpItemID, GetFileTimeNow(), beginTime, endTime,
        args.runs, args.outputFlag, args.copyRuns, systemID))
    {
        _log(DATABASE__ERROR, "Failed to insert new job to database: %s.", err.c_str());
        return 0;
    }

    // update nextFreeTime
    if (!sDatabase.RunQuery(err,
        "UPDATE ramAssemblyLines"
        " SET nextFreeTime = %li"
        " WHERE assemblyLineID = %i",
        endTime, args.AssemblyLineID))
    {
        _log(DATABASE__ERROR, "Failed to update next free time for assembly line %u: %s.", args.AssemblyLineID, err.c_str());
        return 0;
    }

    return jobID;
}

Here is the call graph for this function:

bool FactoryDB::IsProducableBy ( const uint32  assemblyLineID, const ItemType *  pType  )

static

Todo:

is there is a better way to do this??

Definition at line 29 of file FactoryDB.cpp.

References GetMultipliers().

Referenced by RamMethods::ActivityCheck().

                                                                                 {
    Rsp_InstallJob into;
    return FactoryDB::GetMultipliers(assemblyLineID, pType, into);
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool FactoryDB::IsRecyclable ( const uint16  typeID )

static

Definition at line 737 of file FactoryDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                                {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT NULL FROM ramTypeRequirements"
        " LEFT JOIN invBlueprintTypes ON typeID = blueprintTypeID"
        " WHERE damagePerJob = 1 AND activityID = 6 AND typeID = %u"
        " AND extra = 1"
        " LIMIT 1",
        typeID))
    {
        _log(DATABASE__ERROR, "Failed to check item type ID: %s.", res.error.c_str());
        return false;
    }

    DBResultRow row;
    if (res.GetRow(row))
        return true;

    if (!sDatabase.RunQuery(res,
        "SELECT NULL FROM ramTypeRequirements"
        " LEFT JOIN invBlueprintTypes ON typeID = blueprintTypeID"
        " WHERE damagePerJob = 1 AND activityID = 1 AND productTypeID = %u"
        " AND extra = 1"
        " LIMIT 1",
        typeID))
    {
        _log(DATABASE__ERROR, "Failed to check item type ID: %s.", res.error.c_str());
        return false;
    }

    return (res.GetRow(row));
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool FactoryDB::IsRefinable ( const uint16  typeID )

static

Definition at line 719 of file FactoryDB.cpp.

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

Referenced by StaticDataMgr::Populate().

                                               {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT NULL"
        " FROM ramTypeRequirements"
        " WHERE typeID=%u"
        " AND extra = 0"
        " LIMIT 1",
        typeID))
    {
        _log(DATABASE__ERROR, "Failed to check ore type ID: %s.", res.error.c_str());
        return false;
    }

    DBResultRow row;
    return (res.GetRow(row));
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool FactoryDB::SaveBlueprintData ( uint32  blueprintID, EvERam::bpData &  data  )

static

Definition at line 120 of file FactoryDB.cpp.

References DBerror::c_str(), codelog, EvERam::bpData::copy, EvERam::bpData::mLevel, EvERam::bpData::pLevel, EvERam::bpData::runs, and sDatabase.

Referenced by Blueprint::CreateItemID(), and Blueprint::SaveBlueprint().

                                                                        {
    DBerror err;
    if(!sDatabase.RunQuery(err,
        "INSERT INTO invBlueprints"
        "  (itemID, copy, mLevel, pLevel, runs)"
        " VALUES"
        "  (%u, %u, %i, %i, %i)"
        "ON DUPLICATE KEY UPDATE "
        "mLevel=VALUES(mLevel), "
        "pLevel=VALUES(pLevel), "
        "runs=VALUES(runs) ",
        blueprintID, data.copy, data.mLevel, data.pLevel, data.runs))
    {
        codelog(DATABASE__ERROR, "Error in SaveBlueprint query: %s.", err.c_str());
        return false;
    }

    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

void FactoryDB::SetJobEventID ( const uint32  jobID, const uint32  eventID  )

static

Definition at line 88 of file FactoryDB.cpp.

References sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err, "UPDATE ramJobs SET eventID=%u WHERE jobID=%u", eventID, jobID);
}

---

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

• /backups/local/src/eve/EvEmu_Crucible/src/eve-server/manufacturing/FactoryDB.h
• /backups/local/src/eve/EvEmu_Crucible/src/eve-server/manufacturing/FactoryDB.cpp