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); }