PyDict *CorporationDB::ListAllCorpInfo() {
DBQueryResult res;
if(!sDatabase.RunQuery(res,
"SELECT "
" corporationName,"
" corporationID,mainActivityID,secondaryActivityID,"
" size,extent,solarSystemID,investorID1,investorShares1,"
" investorID2, investorShares2, investorID3,investorShares3,"
" investorID4,investorShares4,"
" friendID,enemyID,publicShares,initialPrice,"
" minSecurity,scattered,fringe,corridor,hub,border,"
" factionID,sizeFactor,stationCount,stationSystemCount,"
" stationID,ceoID,entity.itemName AS ceoName"
" FROM crpNPCCorporations"
" JOIN corporation USING (corporationID)"
" LEFT JOIN entity ON ceoID=entity.itemID"
))
{
codelog(SERVICE__ERROR, "Error in query: %s", res.error.c_str());
return NULL;
}
return(DBResultToIntRowDict(res, 1));
}
PyRep *CertificateMgrDB::GetCertificateClasses() {
DBQueryResult res;
if(!sDatabase.RunQuery(res,
"SELECT"
" classID,"
" className,"
" classNameID,"
" description,"
" 0 AS dataID"
" FROM crtClasses"))
{
_log(DATABASE__ERROR, "Failed to query certificate classes: %s.", res.error.c_str());
return(NULL);
}
return DBResultToIntRowDict(res, 0);
}
