PyPackedRow *StationDB::GetSolarSystem(uint32 solarSystemID) {
DBQueryResult res;
if(!sDatabase.RunQuery(res,
"SELECT "
" solarSystemID," // nr
" solarSystemName," // string
" x, y, z," // double
" radius," // double
" security," // double
" constellationID," // nr
" factionID," // nr
" sunTypeID," // nr
" regionID,"
" 0 AS wormholeClassID"
" FROM mapSolarSystems"
" WHERE solarSystemID=%u", solarSystemID
))
{
_log(SERVICE__ERROR, "Error in GetSolarSystem query: %s", res.error.c_str());
return NULL;
}
DBResultRow row;
if(!res.GetRow(row)) {
_log(SERVICE__ERROR, "Error in GetSolarSystem query: no solarsystem for id %d", solarSystemID);
return NULL;
}
return(DBRowToPackedRow(row));
}
PyRep *MarketDB::GetContract( uint32 contractID )
{
DBQueryResult res;
if(!sDatabase.RunQuery(res,
"SELECT"
" contractID,"
" issuerID,"
" issuerCorpID,"
" type,"
" avail AS availability,"
" assigneeID,"
" expiretime,"
" duration AS numDays,"
" startStationID,"
" endStationID,"
" startSolarSystemID,"
" endSolarSystemID,"
" startRegionID,"
" endRegionID,"
" price,"
" reward,"
" collateral,"
" title,"
" description,"
" forCorp,"
" status,"
" isAccepted,"
" acceptorID,"
" dateIssued,"
" dateExpired,"
" dateAccepted,"
" dateCompleted,"
" volume"
" FROM contract"
" WHERE contractID=%d", contractID ))
{
codelog(MARKET__ERROR, "Error in query: %s", res.error.c_str() );
return NULL;
}
DBResultRow row;
if(!res.GetRow(row)) {
codelog(MARKET__ERROR, "Contract %d not found.", contractID);
return NULL;
}
return(DBRowToPackedRow(row));
}
PyRep *MarketDB::GetOrderRow(uint32 orderID) {
DBQueryResult res;
if(!sDatabase.RunQuery(res,
"SELECT"
" price, volRemaining, typeID, `range`, orderID,"
" volEntered, minVolume, bid, issued as issueDate, duration,"
" stationID, regionID, solarSystemID, jumps"
" FROM market_orders"
" WHERE orderID=%u", orderID))
{
codelog(MARKET__ERROR, "Error in query: %s", res.error.c_str());
return NULL;
}
DBResultRow row;
if(!res.GetRow(row)) {
codelog(MARKET__ERROR, "Order %u not found.", orderID);
return NULL;
}
return(DBRowToPackedRow(row));
}
