DBQueryResult Class Reference

#include "dbcore.h"

Collaboration diagram for DBQueryResult:

Public Member Functions
	DBQueryResult ()
	~DBQueryResult ()
bool	GetRow (DBResultRow &into)
size_t	GetRowCount ()
void	Reset ()
uint32	ColumnCount () const
const char *	ColumnName (uint32 index) const
DBTYPE	ColumnType (uint32 index) const
bool	IsUnsigned (uint32 index) const
bool	IsBinary (uint32 index) const

Public Attributes
DBerror	error

Protected Member Functions
void	SetResult (MYSQL_RES *res, uint32 colCount)

Protected Attributes
uint32	mColumnCount
MYSQL_RES *	mResult
MYSQL_FIELD **	mFields

Static Protected Attributes
static const DBTYPE	MYSQL_DBTYPE_TABLE_SIGNED []
static const DBTYPE	MYSQL_DBTYPE_TABLE_UNSIGNED []

Friends
class	DBcore

Detailed Description

Definition at line 62 of file dbcore.h.

Constructor & Destructor Documentation

DBQueryResult::DBQueryResult

(

)

Definition at line 502 of file dbcore.cpp.

: mColumnCount(0),
mResult(nullptr),
mFields(nullptr)
{
}

DBQueryResult::~DBQueryResult

(

)

Definition at line 509 of file dbcore.cpp.

References mFields, mResult, and SafeDeleteArray().

{
    SafeDeleteArray( mFields );

    if (mResult != nullptr)
        mysql_free_result( mResult );
}

Here is the call graph for this function:

Member Function Documentation

uint32 DBQueryResult::ColumnCount ( ) const

inline

Definition at line 76 of file dbcore.h.

References mColumnCount.

Referenced by DBResultRow::ColumnCount(), DBResultRow::ColumnLength(), DBResultToCIndexedRowset(), DBResultToIndexRowset(), DBResultToPackedRowDict(), DBResultToRowList(), DBResultToRowset(), DBResultToTupleSet(), DBRowDescriptor::DBRowDescriptor(), DBResultRow::GetBool(), DBResultRow::GetDouble(), DBResultRow::GetFloat(), DBResultRow::GetInt(), DBResultRow::GetInt64(), and DBResultRow::GetUInt().

{ return mColumnCount; }

Here is the caller graph for this function:

const char * DBQueryResult::ColumnName

(

uint32

index

)

const

Definition at line 569 of file dbcore.cpp.

References _log, mColumnCount, mFields, and EvE::traceStack().

Referenced by DBResultRow::ColumnName(), DBResultToCIndexedRowset(), DBResultToIndexRowset(), DBResultToPackedRowDict(), DBResultToRowList(), DBResultToRowset(), DBResultToTupleSet(), and DBRowDescriptor::DBRowDescriptor().

{
    if (index >= mColumnCount) {
        _log(DATABASE__ERROR,  "DBCore ColumnName: Column index %d exceeds number of columns in row (%s)\n", index, mColumnCount );
        EvE::traceStack();
        return "(ERROR)";
    }

    return mFields[ index ]->name;
}

Here is the call graph for this function:

Here is the caller graph for this function:

DBTYPE DBQueryResult::ColumnType

(

uint32

index

)

const

Definition at line 580 of file dbcore.cpp.

References _log, DBTYPE_BYTES, DBTYPE_ERROR, DBTYPE_I8, DBTYPE_STR, DBTYPE_WSTR, IsBinary(), IsUnsigned(), mColumnCount, mFields, MYSQL_DBTYPE_TABLE_SIGNED, MYSQL_DBTYPE_TABLE_UNSIGNED, and EvE::traceStack().

Referenced by DBResultRow::ColumnType(), and DBRowDescriptor::DBRowDescriptor().

{
    if (index >= mColumnCount) {
        _log(DATABASE__ERROR,  "DBCore ColumnType: Column index %d exceeds number of columns in row (%s)\n", index, mColumnCount );
        EvE::traceStack();
        return DBTYPE_STR;
    }

    uint16 columnType = mFields[ index ]->type;

    if ( columnType > MYSQL_TYPE_BIT )
        columnType -= 229;  //( MYSQL_TYPE_NEWDECIMAL - MYSQL_TYPE_BIT - 1 )

    DBTYPE result = ( IsUnsigned( index ) ? MYSQL_DBTYPE_TABLE_UNSIGNED : MYSQL_DBTYPE_TABLE_SIGNED )[ columnType ];

    // test for numeric type and set to signed 64b integer.  may have to revise this to float/double depending on what's found.
    if (result == DBTYPE_ERROR)
        if (IS_NUM(columnType))
            result = DBTYPE_I8;

    /* if result is (wide) binary string, set result to DBTYPE_BYTES. */
    if (((DBTYPE_STR == result) or (DBTYPE_WSTR == result)) and IsBinary(index))
        result = DBTYPE_BYTES;

    /* debug check */
    assert( result != DBTYPE_ERROR);
    return result;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool DBQueryResult::GetRow

(

DBResultRow &

into

)

Definition at line 552 of file dbcore.cpp.

References mResult, and DBResultRow::SetData().

Referenced by PlanetDataMgr::_Populate(), PIDataMgr::_Populate(), CharacterDB::ChangeCloneType(), StatisticMgr::CompileData(), FactoryDB::CountManufacturingJobs(), FactoryDB::CountResearchJobs(), AllianceDB::CreateAllianceChangePacket(), CorporationDB::CreateCorporationChangePacket(), CorporationDB::CreateCorporationCreatePacket(), MailDB::CreateLabel(), CorporationDB::CreateMemberAttributeUpdate(), DBResultToCIndexedRowset(), DBResultToCRowset(), DBResultToIndexRowset(), DBResultToIntIntDict(), DBResultToIntIntlistDict(), DBResultToIntRowDict(), DBResultToPackedRowDict(), DBResultToPackedRowList(), DBResultToPackedRowListTuple(), DBResultToRowList(), DBResultToRowset(), DBResultToTupleSet(), DBResultToUIntUIntDict(), CorporationDB::Fetch(), MarketDB::FindBuyOrder(), MarketDB::FindSellOrder(), CommandDB::FullSkillList(), LiveUpdateDB::GenerateUpdates(), CommandDB::GetAccountID(), APIServiceDB::GetAccountIdFromUserID(), APIServiceDB::GetAccountIdFromUsername(), APIAccountDB::GetAccountInfo(), ServiceDB::GetAccountInformation(), CharacterDB::GetActiveCloneID(), CharacterDB::GetActiveCloneType(), CorporationDB::GetAdvertTime(), AllianceDB::GetAlliance(), ManagerDB::GetAnomalyPos(), APIServiceDB::GetApiAccountInfoUsingAccountID(), APIServiceDB::GetApiAccountInfoUsingUserID(), FactoryDB::GetAssemblyLineProperties(), FactoryDB::GetAssemblyLineRestrictions(), ManagerDB::GetAsteroidData(), CommandDB::GetAttributeID(), CharacterDB::GetAttributesFromAncestry(), PosMgrDB::GetBaseData(), CharacterDB::GetBaseSkills(), SystemDB::GetBelts(), InventoryDB::GetBloodlineByCharacterType(), FactoryDB::GetBlueprint(), BookmarkDB::GetBookmarkByFolderID(), BookmarkDB::GetBookmarkDescription(), BookmarkDB::GetBookmarkInformation(), BookmarkDB::GetBookmarkName(), BookmarkDB::GetBookmarks(), BookmarkDB::GetBookmarksInFolder(), PosMgrDB::GetBridgeData(), CharacterDB::GetCareerBySchool(), InventoryDB::GetCelestialObject(), SystemDB::GetCelestialRadius(), LSCDB::GetChannelID(), LSCDB::GetChannelIDFromComparisonKey(), LSCDB::GetChannelInfo(), LSCDB::GetChannelInformation(), LSCDB::GetChannelName(), LSCDB::GetChannelNames(), LSCDB::GetChannelSubscriptions(), APICharacterDB::GetCharacterAttributes(), CharacterDB::GetCharacterData(), InventoryDB::GetCharacterData(), APICharacterDB::GetCharacterInfo(), APICharacterDB::GetCharacterSkillQueue(), APICharacterDB::GetCharacterSkillsTrained(), APIAccountDB::GetCharactersList(), InventoryDB::GetCharacterType(), InventoryDB::GetCharacterTypeByBloodline(), CharacterDB::GetCharClones(), CharacterDB::GetCharHomeStation(), CharacterDB::GetCharItems(), CharacterDB::GetCharName(), CharacterDB::GetCharPrivateInfo(), CharacterDB::GetCharPublicInfo(), CharacterDB::GetCharSelectInfo(), CorporationDB::GetCloneTypeCostByID(), ServiceDB::GetConstant(), AccountDB::GetCorpBalance(), InventoryDB::GetCorpData(), CorporationDB::GetCorpData(), ServiceDB::GetCorpHangarNames(), CharacterDB::GetCorpID(), CorporationDB::GetCorpIDforChar(), CorporationDB::GetCorpInfo(), CorporationDB::GetCorpMemberCount(), CorporationDB::GetCorpMemberLimit(), CorporationDB::GetCorpName(), CorporationDB::GetCorporation(), CharacterDB::GetCorporationBySchool(), CorporationDB::GetCorporationCEO(), CorporationDB::GetCorporations(), CharacterDB::GetCorpRole(), CorporationDB::GetCorpStations(), CharacterDB::GetCorpTaxRate(), MarketDB::GetCruPriceAvg(), AllianceDB::GetCurrentApplicationInfo(), CorporationDB::GetCurrentApplicationInfo(), PosMgrDB::GetCustomsData(), CorporationDB::GetDivisionName(), MapDB::GetDynamicData(), CalendarDB::GetEventDetails(), CalendarDB::GetEventList(), AllianceDB::GetExecutorID(), PlanetSE::GetExtractorsForPlanet(), FactionWarMgrDB::GetFactionMilitiaCorporation(), FactionWarMgrDB::GetFacWarSystems(), BookmarkDB::GetFolders(), SystemDB::GetGates(), CharacterDB::GetInfoWindowDataForChar(), ShipDB::GetInsuranceByShipID(), ItemDB::GetItem(), InventoryDB::GetItemContents(), ItemDB::GetItems(), SystemDB::GetItemTypeRadius(), FactoryDB::GetJobProperties(), MailDB::GetJoinedMailingLists(), MailDB::GetLabels(), PlanetDB::GetLaunchDetails(), PlanetDB::GetLaunchItemID(), PlanetDB::GetLaunchPlanet(), PlanetDB::GetLaunchPos(), CharacterDB::GetLocationCorporationByCareer(), MailDB::GetMailBody(), LSCDB::GetMailDetails(), MailDB::GetMailingListMembers(), MarketDB::GetManufacturedItems(), MarketDB::GetMarketGroups(), MarketDB::GetMaterialPrices(), CorporationDB::GetMember(), CorporationDB::GetMemberCount(), CorporationDB::GetMemberIDs(), CorporationDB::GetMembersForQuery(), MarketDB::GetMineralPrices(), SystemDB::GetMoons(), FactoryDB::GetMultipliers(), LSCDB::GetNextAvailableChannelID(), FactoryDB::GetNextFreeTime(), CharacterDB::GetNote(), SystemDB::GetObjectLocationID(), StationDB::GetOfficeCount(), StationDB::GetOfficeData(), MarketDB::GetOrderInfo(), MarketDB::GetOrderRow(), PaperDollDB::GetPaperDollAvatar(), SystemDB::GetPlanets(), ReprocessingDB::GetRecoverables(), CorporationDB::GetRecruiters(), CharacterDB::GetRespecInfo(), CalendarDB::GetResponsesForCharacter(), CalendarDB::GetResponsesToEvent(), ManagerDB::GetSavedDungeons(), CorporationDB::GetSharesForCorp(), MarketDB::GetShipIDs(), ShipDB::GetShipInsurancePayout(), CharacterDB::GetSkillLevel(), CharacterDB::GetSkillsByCareer(), CharacterDB::GetSkillsByRace(), SystemDB::GetSolarSystem(), CommandDB::GetSolarSystem(), InventoryDB::GetSolarSystem(), SystemDB::GetSolarSystemPosition(), StandingDB::GetStanding(), CharacterDB::GetStartingStationByCareer(), CommandDB::GetStation(), CorporationDB::GetStationCorporationCEO(), StationDB::GetStationOfficeIDs(), ServiceDB::GetStationOwner(), CorporationDB::GetStationOwner(), FactoryDB::GetTech2Blueprint(), CorporationDB::GetTitles(), PosMgrDB::GetTowerData(), MarketDB::GetUpdateTime(), BookmarkDB::GetVoucherData(), AccountDB::GetWalletDivisionsInfo(), LSCDB::IsChannelIDAvailable(), LSCDB::IsChannelNameAvailable(), LSCDB::IsChannelSubscribedByThisChar(), FactoryDB::IsRecyclable(), FactoryDB::IsRefinable(), ShipDB::IsShipInsured(), CommandDB::ItemSearch(), AttributeMap::Load(), AgentDB::LoadAgentData(), AgentDB::LoadAgentSkills(), CertificateMgrDB::LoadCertificates(), PlanetDB::LoadColony(), PlanetDB::LoadContents(), MapDB::LoadDynamicData(), PlanetDB::LoadHeads(), PlanetDB::LoadLinks(), StationDB::LoadOffices(), CharacterDB::LoadPausedSkillQueue(), PlanetDB::LoadPins(), SystemDB::LoadPlayerDynamicEntities(), PlanetDB::LoadRoutes(), CharacterDB::LoadSkillQueue(), SystemDB::LoadSystemDynamicEntities(), ManagerDB::LoadSystemRoids(), SystemDB::LoadSystemStaticEntities(), ShipItem::LoadWeaponGroups(), MailDB::MailingListGetSettings(), CorporationDB::MoveShares(), AccountDB::OfflineFundXfer(), CharacterDB::PickAlternateShip(), FxDataMgr::Populate(), MapData::Populate(), MissionDataMgr::Populate(), SovereigntyDataMgr::Populate(), StationDataMgr::Populate(), DungeonDataMgr::Populate(), StaticDataMgr::Populate(), MapCon::PopulateConnections(), ServiceDB::PrimeOwners(), SearchDB::QuickQuery(), MissionDB::RemoveMissionItem(), MailDB::SendMail(), ServiceDB::SetClientSeed(), SovereigntyDataMgr::UpdateClaim(), CorporationDB::UpdateCorporation(), CorporationDB::UpdateDivisionNames(), CorporationDB::UpdateLogo(), and CorporationDB::UpdateTitle().

{
    if (mResult == nullptr)
        return false;

    MYSQL_ROW row = mysql_fetch_row( mResult );
    if (row == nullptr)
        return false;

    const ulong* lengths = mysql_fetch_lengths( mResult );
    if (lengths == nullptr)
        return false;

    into.SetData( this, row, lengths );
    return true;
}

Here is the call graph for this function:

size_t DBQueryResult::GetRowCount ( )

inline

Definition at line 72 of file dbcore.h.

References mResult.

Referenced by StatisticMgr::CompileData(), MailDB::CreateLabel(), DBResultToPackedRowList(), DBResultToPackedRowListTuple(), CharacterDB::DoesCorporationExist(), LiveUpdateDB::GenerateUpdates(), ManagerDB::GetAgents(), ManagerDB::GetBillTypes(), ManagerDB::GetCategoryData(), ManagerDB::GetEntryTypes(), CalendarDB::GetEventList(), PlanetDB::GetExtractorsForPlanet(), ManagerDB::GetGroupData(), InventoryDB::GetItemContents(), ManagerDB::GetKeyMap(), CharacterDB::GetKillOrLoss(), CorporationDB::GetKillsAndLosses(), MailDB::GetMailBody(), CorporationDB::GetMembersForQuery(), CorporationDB::GetMktInfo(), MarketMgr::GetNewPriceHistory(), MarketMgr::GetOldPriceHistory(), ManagerDB::GetOperands(), MarketDB::GetOrders(), MarketDB::GetOrdersForOwner(), PlanetDB::GetPlanetsForChar(), CorporationDB::GetRecruiters(), ManagerDB::GetSavedDungeons(), ManagerDB::GetSkillList(), SystemDB::GetSolarSystemPosition(), ManagerDB::GetTypeAttributes(), ManagerDB::GetTypeData(), CorporationDB::HasShares(), AllianceDB::IsShortNameTaken(), CorporationDB::IsTickerTaken(), PlanetDB::LoadContents(), PlanetDB::LoadHeads(), PlanetDB::LoadLinks(), ManagerDB::LoadNPCCorpFactionData(), PlanetDB::LoadPins(), SystemDB::LoadPlayerDynamicEntities(), PlanetDB::LoadRoutes(), SystemDB::LoadSystemDynamicEntities(), ManagerDB::LoadSystemRoids(), SystemDB::LoadSystemStaticEntities(), CorporationDB::PyHasShares(), SearchDB::Query(), CharacterDB::ValidateCharName(), and CharacterDB::ValidateCharNameRep().

{ return ((mResult == nullptr) ? 0 : (size_t)mResult->row_count); }

Here is the caller graph for this function:

bool DBQueryResult::IsBinary

(

uint32

index

)

const

Definition at line 531 of file dbcore.cpp.

References mFields.

Referenced by ColumnType(), and DBResultRow::IsBinary().

{
    // According to MySQL C API Documentation, binary string
    // fields like BLOB or VAR_BINARY have charset "63".
    return (mFields[index]->charsetnr == 63);
}

Here is the caller graph for this function:

bool DBQueryResult::IsUnsigned

(

uint32

index

)

const

Definition at line 526 of file dbcore.cpp.

References mFields.

Referenced by ColumnType(), and DBResultRow::IsUnsigned().

{
    return ((mFields[index]->flags & UNSIGNED_FLAG) == UNSIGNED_FLAG);
}

Here is the caller graph for this function:

void DBQueryResult::Reset

(

)

Definition at line 517 of file dbcore.cpp.

References mColumnCount, mFields, mResult, and SafeDeleteArray().

Referenced by SetResult().

{
    mColumnCount = 0;
    SafeDeleteArray( mFields );

    if (mResult != nullptr)
        mysql_free_result(mResult);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void DBQueryResult::SetResult ( MYSQL_RES *  res, uint32  colCount  )

protected

Definition at line 538 of file dbcore.cpp.

References mColumnCount, mFields, mResult, and Reset().

Referenced by DBcore::RunQuery().

{
    Reset();

    mResult = res;
    mColumnCount = colCount;

    if (mResult != nullptr) {
        mFields = new MYSQL_FIELD*[ mColumnCount ];
        for( uint16 i = 0; i < mColumnCount; ++i )
            mFields[ i ] = mysql_fetch_field( mResult );
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

Friends And Related Function Documentation

friend class DBcore

friend

Definition at line 85 of file dbcore.h.

Member Data Documentation

DBerror DBQueryResult::error

Definition at line 69 of file dbcore.h.

Referenced by FactoryDB::AssemblyLinesGet(), FactoryDB::AssemblyLinesSelectAlliance(), FactoryDB::AssemblyLinesSelectCorporation(), FactoryDB::AssemblyLinesSelectPersonal(), FactoryDB::AssemblyLinesSelectPrivate(), FactoryDB::AssemblyLinesSelectPublic(), CharacterDB::ChangeCloneLocation(), CharacterDB::ChangeCloneType(), CorporationDB::CreateMemberAttributeUpdate(), CharacterDB::DoesCorporationExist(), CorporationDB::Fetch(), MarketDB::FindBuyOrder(), MarketDB::FindSellOrder(), CommandDB::FullSkillList(), ObjCacheDB::Generate_a_accessories(), ObjCacheDB::Generate_a_backgrounds(), ObjCacheDB::Generate_a_beards(), ObjCacheDB::Generate_a_costumes(), ObjCacheDB::Generate_a_decos(), ObjCacheDB::Generate_a_eyebrows(), ObjCacheDB::Generate_a_eyes(), ObjCacheDB::Generate_a_hairs(), ObjCacheDB::Generate_a_lights(), ObjCacheDB::Generate_a_lipsticks(), ObjCacheDB::Generate_a_makeups(), ObjCacheDB::Generate_a_skins(), ObjCacheDB::Generate_AllianceShortnames(), ObjCacheDB::Generate_BillTypes(), ObjCacheDB::Generate_bl_accessories(), ObjCacheDB::Generate_bl_backgrounds(), ObjCacheDB::Generate_bl_beards(), ObjCacheDB::Generate_bl_costumes(), ObjCacheDB::Generate_bl_decos(), ObjCacheDB::Generate_bl_eyebrows(), ObjCacheDB::Generate_bl_eyes(), ObjCacheDB::Generate_bl_hairs(), ObjCacheDB::Generate_bl_lights(), ObjCacheDB::Generate_bl_lipsticks(), ObjCacheDB::Generate_bl_makeups(), ObjCacheDB::Generate_bl_skins(), ObjCacheDB::Generate_BloodlineNames(), ObjCacheDB::Generate_c_chrAncestries(), ObjCacheDB::Generate_c_chrAttributes(), ObjCacheDB::Generate_c_chrBloodlines(), ObjCacheDB::Generate_c_chrRaces(), ObjCacheDB::Generate_c_chrSchools(), ObjCacheDB::Generate_cacheLocations(), ObjCacheDB::Generate_cacheOwners(), ObjCacheDB::Generate_certificateRelationships(), ObjCacheDB::Generate_certificates(), ObjCacheDB::Generate_CharNewExtraCareers(), ObjCacheDB::Generate_CharNewExtraCareerSkills(), ObjCacheDB::Generate_CharNewExtraRaceSkills(), ObjCacheDB::Generate_CharNewExtraSpecialities(), ObjCacheDB::Generate_CharNewExtraSpecialitySkills(), ObjCacheDB::Generate_chrAttributes(), ObjCacheDB::Generate_chrBloodlines(), ObjCacheDB::Generate_chrRaces(), ObjCacheDB::Generate_dgmAttribs(), ObjCacheDB::Generate_dgmEffects(), ObjCacheDB::Generate_dgmExpressions(), ObjCacheDB::Generate_dgmTypeAttribs(), ObjCacheDB::Generate_dgmTypeEffects(), ObjCacheDB::Generate_eveBulkDataUnits(), ObjCacheDB::Generate_eveGraphics(), ObjCacheDB::Generate_eveStaticLocations(), ObjCacheDB::Generate_eveStaticOwners(), ObjCacheDB::Generate_eveUnits(), ObjCacheDB::Generate_Icons(), ObjCacheDB::Generate_invBlueprintTypes(), ObjCacheDB::Generate_invCategories(), ObjCacheDB::Generate_invContrabandTypes(), ObjCacheDB::Generate_invFlags(), ObjCacheDB::Generate_invGroups(), ObjCacheDB::Generate_invMetaGroups(), ObjCacheDB::Generate_invMetaTypes(), ObjCacheDB::Generate_invShipTypes(), ObjCacheDB::Generate_Invtypematerials(), ObjCacheDB::Generate_invTypeReactions(), ObjCacheDB::Generate_invTypes(), ObjCacheDB::Generate_Locationscenes(), ObjCacheDB::Generate_locationWormholeClasses(), ObjCacheDB::Generate_mapCelestialDescriptions(), ObjCacheDB::Generate_OverviewDefaultGroups(), ObjCacheDB::Generate_OverviewDefaults(), ObjCacheDB::Generate_Ownericons(), ObjCacheDB::Generate_PaperdollColorNames(), ObjCacheDB::Generate_PaperdollColorRestrictions(), ObjCacheDB::Generate_PaperdollColors(), ObjCacheDB::Generate_PaperdollModifierLocations(), ObjCacheDB::Generate_PaperdollResources(), ObjCacheDB::Generate_PaperdollSculptingLocations(), ObjCacheDB::Generate_ramActivities(), ObjCacheDB::Generate_ramALTypeCategory(), ObjCacheDB::Generate_ramALTypeGroup(), ObjCacheDB::Generate_ramALTypes(), ObjCacheDB::Generate_ramCompletedStatuses(), ObjCacheDB::Generate_ramTypeRequirements(), ObjCacheDB::Generate_Schematics(), ObjCacheDB::Generate_Schematicspinmap(), ObjCacheDB::Generate_Schematicstypemap(), ObjCacheDB::Generate_Sounds(), ObjCacheDB::Generate_tickerNames(), LiveUpdateDB::GenerateUpdates(), ServiceDB::GetAccountInformation(), CharacterDB::GetActiveCloneID(), CharacterDB::GetActiveCloneType(), CorporationDB::GetAdGroupData(), CorporationDB::GetAdRegistryData(), CorporationDB::GetAdTypeData(), CorporationDB::GetAdvert(), ManagerDB::GetAgentLocation(), ManagerDB::GetAgents(), CorporationDB::GetAllCorpMedals(), TutorialDB::GetAllCriterias(), PosMgrDB::GetAllianceJumpArrays(), AllianceDB::GetAllianceMembers(), CertificateMgrDB::GetAllShipCertificateRecommendations(), TutorialDB::GetAllTutorials(), ManagerDB::GetAnomalyList(), ManagerDB::GetAnomalyPos(), AllianceDB::GetApplications(), CorporationDB::GetApplications(), FactoryDB::GetAssemblyLineProperties(), FactoryDB::GetAssemblyLineRestrictions(), CorporationDB::GetAssetInventory(), CorporationDB::GetAssetInventoryForLocation(), ManagerDB::GetAsteroidData(), CharacterDB::GetAttributesFromAncestry(), PosMgrDB::GetBaseData(), CharacterDB::GetBaseSkills(), ManagerDB::GetBillTypes(), InventoryDB::GetBloodlineByCharacterType(), FactoryDB::GetBlueprint(), FactoryDB::GetBlueprintType(), BookmarkDB::GetBookmarkByFolderID(), BookmarkDB::GetBookmarkDescription(), BookmarkDB::GetBookmarkInformation(), BookmarkDB::GetBookmarkName(), BookmarkDB::GetBookmarks(), BookmarkDB::GetBookmarksInFolder(), PosMgrDB::GetBridgeData(), AllianceDB::GetBulletins(), CorporationDB::GetBulletins(), CharacterDB::GetCareerBySchool(), TutorialDB::GetCategories(), ManagerDB::GetCategoryData(), InventoryDB::GetCelestialObject(), SystemDB::GetCelestialRadius(), ConfigDB::GetCelestialStatistic(), CertificateMgrDB::GetCertificateCategories(), CertificateMgrDB::GetCertificateClasses(), LSCDB::GetChannelID(), LSCDB::GetChannelIDFromComparisonKey(), LSCDB::GetChannelInfo(), LSCDB::GetChannelInformation(), LSCDB::GetChannelName(), LSCDB::GetChannelNames(), LSCDB::GetChannelSubscriptions(), CharacterDB::GetCharacterData(), InventoryDB::GetCharacterData(), CharacterDB::GetCharacterList(), InventoryDB::GetCharacterType(), InventoryDB::GetCharacterTypeByBloodline(), CharacterDB::GetCharClones(), CharacterDB::GetCharItems(), CharacterDB::GetCharName(), CharacterDB::GetCharPrivateInfo(), CharacterDB::GetCharPublicInfo(), CharacterDB::GetCharPublicInfo3(), CharacterDB::GetCharSelectInfo(), FactoryDB::GetCommodities(), FactoryDB::GetComponents(), FactoryDB::GetCompounds(), ServiceDB::GetConstant(), AllianceDB::GetContacts(), CorporationDB::GetContacts(), CharacterDB::GetContacts(), PosMgrDB::GetControlTowerFuelRequirements(), AccountDB::GetCorpBalance(), PosMgrDB::GetCorpControlTowers(), InventoryDB::GetCorpData(), CorporationDB::GetCorpData(), CharacterDB::GetCorpID(), CorporationDB::GetCorpIDforChar(), PosMgrDB::GetCorpJumpArrays(), CorporationDB::GetCorpMedalData(), CorporationDB::GetCorpMemberCount(), CorporationDB::GetCorpMemberLimit(), CorporationDB::GetCorpName(), CorporationDB::GetCorporationBills(), CharacterDB::GetCorporationBySchool(), CorporationDB::GetCorporationCEO(), CharacterDB::GetCorpRole(), CorporationDB::GetCorpRoleGroups(), CorporationDB::GetCorpRoles(), CorporationDB::GetCorpStations(), CharacterDB::GetCorpTaxRate(), AllianceDB::GetCurrentApplicationInfo(), CorporationDB::GetCurrentApplicationInfo(), PosMgrDB::GetCustomsData(), FxDataMgr::GetDgmEffects(), FxDataMgr::GetDgmTypeEffects(), CorporationDB::GetDivisionName(), BulkDB::GetDogmaAttribs(), BulkDB::GetDogmaEffects(), BulkDB::GetDogmaTypeAttribs(), BulkDB::GetDogmaTypeEffects(), ManagerDB::GetDunEntryData(), ManagerDB::GetDunGroupData(), ManagerDB::GetDunRoomData(), ManagerDB::GetDunRoomInfo(), ManagerDB::GetDunSpawnInfo(), DungeonDB::GetDunTemplates(), ManagerDB::GetDunTemplates(), ConfigDB::GetDynamicCelestials(), AllianceDB::GetEmploymentRecord(), CorporationDB::GetEmploymentRecord(), ManagerDB::GetEntryTypes(), CalendarDB::GetEventDetails(), CalendarDB::GetEventList(), CorporationDB::GetEveOwners(), AllianceDB::GetExecutorID(), BulkDB::GetExpressions(), FxDataMgr::GetExpressions(), PlanetDB::GetExtractorsForPlanet(), ManagerDB::GetFactionGroups(), FactionWarMgrDB::GetFactionMilitiaCorporation(), FactionWarMgrDB::GetFacWarSystems(), BookmarkDB::GetFolders(), ManagerDB::GetGroupData(), ManagerDB::GetGroupTypeIDs(), CharacterDB::GetInfoWindowDataForChar(), ItemDB::GetItem(), InventoryDB::GetItemContents(), CorporationDB::GetItemEvents(), ItemDB::GetItems(), SystemDB::GetItemTypeRadius(), FactoryDB::GetJobProperties(), FactoryDB::GetJobs2(), AccountDB::GetJournal(), ManagerDB::GetKeyMap(), CharacterDB::GetKillOrLoss(), CorporationDB::GetKillsAndLosses(), AllianceDB::GetLabels(), CorporationDB::GetLabels(), CharacterDB::GetLabels(), PlanetDB::GetLaunchDetails(), PlanetDB::GetLaunchItemID(), PlanetDB::GetLaunchPlanet(), PlanetDB::GetLaunchPos(), PosMgrDB::GetLinkableJumpArrays(), CharacterDB::GetLocationCorporationByCareer(), SystemDB::GetLootGroups(), SystemDB::GetLootGroupTypes(), LSCDB::GetMailDetails(), LSCDB::GetMailHeaders(), MarketDB::GetManufacturedItems(), ConfigDB::GetMap(), ConfigDB::GetMapConnections(), ConfigDB::GetMapLandmarks(), ConfigDB::GetMapObjects(), ConfigDB::GetMapOffices(), MarketDB::GetMarketGroups(), FactoryDB::GetMaterialCompositionOfItemType(), CorporationDB::GetMedalDetails(), CorporationDB::GetMedalsReceived(), CorporationDB::GetMedalsReceivedDetails(), CorporationDB::GetMember(), CorporationDB::GetMemberCount(), CorporationDB::GetMemberIDs(), CorporationDB::GetMembers(), AllianceDB::GetMembers(), CorporationDB::GetMembersForQuery(), CorporationDB::GetMembersPaged(), CorporationDB::GetMemberTrackingInfo(), CorporationDB::GetMemberTrackingInfoSimple(), FactoryDB::GetMinerals(), FactoryDB::GetMiscCommodities(), CorporationDB::GetMktInfo(), ManagerDB::GetMoonResouces(), ConfigDB::GetMultiAllianceShortNamesEx(), ConfigDB::GetMultiCorpTickerNamesEx(), ConfigDB::GetMultiGraphicsEx(), ConfigDB::GetMultiInvTypesEx(), ConfigDB::GetMultiLocationsEx(), ConfigDB::GetMultiOwnersEx(), FactoryDB::GetMultipliers(), ConfigDB::GetMultiStationEx(), AllianceDB::GetMyApplications(), CorporationDB::GetMyApplications(), CharacterDB::GetMyCorpMates(), PlanetDB::GetMyLaunchesDetails(), CorporationDB::GetMyShares(), MarketMgr::GetNewPriceHistory(), LSCDB::GetNextAvailableChannelID(), FactoryDB::GetNextFreeTime(), CharacterDB::GetNote(), ManagerDB::GetNPCDivisions(), SystemDB::GetObjectLocationID(), StationDB::GetOfficeCount(), StationDB::GetOfficeData(), StationDB::GetOffices(), MarketMgr::GetOldPriceHistory(), BulkDB::GetOperands(), FxDataMgr::GetOperands(), ManagerDB::GetOperands(), MarketDB::GetOrderInfo(), MarketDB::GetOrderRow(), MarketDB::GetOrders(), MarketDB::GetOrdersForOwner(), ManagerDB::GetOreBySSC(), CharacterDB::GetOwnerNote(), CharacterDB::GetOwnerNoteLabels(), TutorialDB::GetPageCriterias(), TutorialDB::GetPages(), PaperDollDB::GetPaperDollAvatar(), PaperDollDB::GetPaperDollAvatarColors(), PaperDollDB::GetPaperDollAvatarModifiers(), PaperDollDB::GetPaperDollAvatarSculpts(), PaperDollDB::GetPaperDollPortraitData(), PlanetDB::GetPlanetData(), PlanetDB::GetPlanetsForChar(), MapDB::GetPseudoSecurities(), FactoryDB::GetRAMMaterials(), FactoryDB::GetRAMRequirements(), AllianceDB::GetRankedAlliances(), CorporationDB::GetRecipientsOfMedal(), ReprocessingDB::GetRecoverables(), CorporationDB::GetRecruiters(), MarketDB::GetRegionBest(), ManagerDB::GetRegionFaction(), ManagerDB::GetRegionRatFaction(), FactoryDB::GetResources(), CalendarDB::GetResponsesForCharacter(), CalendarDB::GetResponsesToEvent(), CorporationDB::GetRoleHistroy(), FactoryDB::GetSalvage(), ManagerDB::GetSalvageGroups(), CorporationDB::GetSanctionedItems(), ManagerDB::GetSavedDungeons(), ScanningDB::GetScanResults(), PlanetDB::GetSchematicData(), PlanetDB::GetSchematicTimes(), CorporationDB::GetShares(), CorporationDB::GetSharesForCorp(), PosMgrDB::GetSiloCapacityForType(), CharacterDB::GetSkillHistory(), CharacterDB::GetSkillLevel(), ManagerDB::GetSkillList(), CharacterDB::GetSkillsByCareer(), CharacterDB::GetSkillsByRace(), SystemDB::GetSolarSystem(), CommandDB::GetSolarSystem(), InventoryDB::GetSolarSystem(), SystemDB::GetSolarSystemPosition(), MapDB::GetSolSystemVisits(), SovereigntyDB::GetSovereigntyData(), SovereigntyDB::GetSovereigntyDataForSystem(), ManagerDB::GetSpawnClasses(), StandingDB::GetStandingTransactions(), CharacterDB::GetStartingStationByCareer(), ManagerDB::GetStaticData(), CommandDB::GetStation(), MarketDB::GetStationAsks(), StationDB::GetStationConstellation(), CorporationDB::GetStationCorporationCEO(), MapDB::GetStationCount(), StationDB::GetStationData(), MapDB::GetStationExtraInfo(), StationDB::GetStationOfficeData(), MapDB::GetStationOpServices(), ServiceDB::GetStationOwner(), CorporationDB::GetStationOwner(), StationDB::GetStationRegion(), CorporationDB::GetStations(), MapDB::GetStationServiceInfo(), ConfigDB::GetStationSolarSystemsByOwner(), StationDB::GetStationSystem(), ManagerDB::GetStatisticData(), ManagerDB::GetSystemAnomalies(), MarketDB::GetSystemAsks(), ManagerDB::GetSystemData(), FactoryDB::GetTech2Blueprint(), ConfigDB::GetTextsForGroup(), CorporationDB::GetTitles(), PosMgrDB::GetTowerData(), MarketDB::GetTransactions(), TutorialDB::GetTutorial(), TutorialDB::GetTutorialCriterias(), ManagerDB::GetTypeAttributes(), ManagerDB::GetTypeData(), ConfigDB::GetUnits(), MarketDB::GetUpdateTime(), CorporationDB::GetVoteItems(), CorporationDB::GetVoteOptions(), CorporationDB::GetVotes(), BookmarkDB::GetVoucherData(), AccountDB::GetWalletDivisionsInfo(), FactionWarMgrDB::GetWarFactions(), ManagerDB::GetWHSystemClass(), SystemDB::GetWrecksToTypes(), CorporationDB::HasShares(), LSCDB::IsChannelIDAvailable(), LSCDB::IsChannelNameAvailable(), LSCDB::IsChannelSubscribedByThisChar(), FactoryDB::IsRecyclable(), FactoryDB::IsRefinable(), CommandDB::ItemSearch(), CharacterDB::List(), SystemDB::ListFactions(), SystemDB::ListJumps(), ConfigDB::ListLanguages(), CharacterDB::ListStationBlueprintItems(), CorporationDB::ListStationCorps(), CharacterDB::ListStationItems(), CorporationDB::ListStationOwners(), CharacterDB::ListStations(), AttributeMap::Load(), AgentDB::LoadAgentData(), AgentDB::LoadAgentSkills(), CertificateMgrDB::LoadCertificates(), MissionDB::LoadClosedOffers(), PlanetDB::LoadColony(), PlanetDB::LoadContents(), ManagerDB::LoadCorpFactions(), MissionDB::LoadCourierData(), MapDB::LoadDynamicData(), ManagerDB::LoadFactionConstellations(), ManagerDB::LoadFactionRaces(), ManagerDB::LoadFactionRegions(), ManagerDB::LoadFactionSolarSystems(), ManagerDB::LoadFactionStationCounts(), ManagerDB::LoadFactionSystemCounts(), PlanetDB::LoadHeads(), PlanetDB::LoadLinks(), MissionDB::LoadMiningData(), MissionDB::LoadMissionBookMark(), MissionDB::LoadMissionData(), ManagerDB::LoadNPCCorpFactionData(), ManagerDB::LoadNPCCorpInfo(), StationDB::LoadOffices(), MissionDB::LoadOpenOffers(), CharacterDB::LoadPausedSkillQueue(), PlanetDB::LoadPins(), SystemDB::LoadPlayerDynamicEntities(), PlanetDB::LoadRoutes(), CharacterDB::LoadSkillQueue(), SystemDB::LoadSystemDynamicEntities(), ManagerDB::LoadSystemRoids(), SystemDB::LoadSystemStaticEntities(), ServiceDB::LookupChars(), ServiceDB::LookupCorporations(), ServiceDB::LookupCorporationTickers(), ServiceDB::LookupFactions(), ServiceDB::LookupKnownLocationsByGroup(), ServiceDB::LookupStations(), StandingDB::PrimeCharStandings(), CorporationDB::PyHasShares(), DBcore::RunQuery(), CorporationDB::UpdateCorporation(), CorporationDB::UpdateDivisionNames(), CorporationDB::UpdateLogo(), and CorporationDB::UpdateTitle().

uint32 DBQueryResult::mColumnCount

protected

Definition at line 88 of file dbcore.h.

Referenced by ColumnCount(), ColumnName(), ColumnType(), Reset(), and SetResult().

MYSQL_FIELD** DBQueryResult::mFields

protected

Definition at line 90 of file dbcore.h.

Referenced by ColumnName(), ColumnType(), IsBinary(), IsUnsigned(), Reset(), SetResult(), and ~DBQueryResult().

MYSQL_RES* DBQueryResult::mResult

protected

Definition at line 89 of file dbcore.h.

Referenced by GetRow(), GetRowCount(), Reset(), SetResult(), and ~DBQueryResult().

const DBTYPE DBQueryResult::MYSQL_DBTYPE_TABLE_SIGNED

staticprotected

Initial value:

=
{
    DBTYPE_ERROR,   
    DBTYPE_I1,      
    DBTYPE_I2,      
    DBTYPE_I4,      
    DBTYPE_R4,      
    DBTYPE_R8,      
    DBTYPE_ERROR,   
    DBTYPE_FILETIME,
    DBTYPE_I8,      
    DBTYPE_I4,      
    DBTYPE_ERROR,   
    DBTYPE_ERROR,   
    DBTYPE_ERROR,   
    DBTYPE_ERROR,   
    DBTYPE_ERROR,   
    DBTYPE_ERROR,   
    DBTYPE_BOOL,    
    DBTYPE_R8,      
    DBTYPE_ERROR,   
    DBTYPE_ERROR,   
    DBTYPE_WSTR,    
    DBTYPE_WSTR,    
    DBTYPE_WSTR,    
    DBTYPE_WSTR,    
    DBTYPE_WSTR,    
    DBTYPE_STR,     
    DBTYPE_ERROR,   
}

Definition at line 92 of file dbcore.h.

Referenced by ColumnType().

const DBTYPE DBQueryResult::MYSQL_DBTYPE_TABLE_UNSIGNED

staticprotected

Initial value:

=
{
    DBTYPE_ERROR,   
    DBTYPE_UI1,     
    DBTYPE_UI2,     
    DBTYPE_UI4,     
    DBTYPE_R4,      
    DBTYPE_R8,      
    DBTYPE_ERROR,   
    DBTYPE_FILETIME,
    DBTYPE_UI8,     
    DBTYPE_UI4,     
    DBTYPE_ERROR,   
    DBTYPE_ERROR,   
    DBTYPE_ERROR,   
    DBTYPE_ERROR,   
    DBTYPE_ERROR,   
    DBTYPE_ERROR,   
    DBTYPE_BOOL,    
    DBTYPE_R8,      
    DBTYPE_ERROR,   
    DBTYPE_ERROR,   
    DBTYPE_WSTR,    
    DBTYPE_WSTR,    
    DBTYPE_WSTR,    
    DBTYPE_WSTR,    
    DBTYPE_WSTR,    
    DBTYPE_STR,     
    DBTYPE_ERROR,   
}

Definition at line 93 of file dbcore.h.

Referenced by ColumnType().

---

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

• /backups/local/src/eve/EvEmu_Crucible/src/eve-core/database/dbcore.h
• /backups/local/src/eve/EvEmu_Crucible/src/eve-core/database/dbcore.cpp