These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

BPO or BPC
Author
Previous Topic Next Topic
Neroo Tal
Order of the Golden Dawn
#1 - 2014-02-09 05:42:52 UTC  |  Edited by: Neroo Tal
Trying to mess with the database and attempting to find only those items that can be picked up through BPC's ( ie. Large Ancillary Shield Booster blueprinttypeid 4392 ) What mysql query would I use to determine if it is bpc only? Or how would I filter them out from an existing query?

EDIT: Nope, not what I thought it was.
Zifrian
The Frog Pond
Ribbit.
#2 - 2014-02-09 12:11:55 UTC
Maybe look at MarketID. BPOs will have one, copies won't.

Not sure how else to do it.

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder
Neroo Tal
Order of the Golden Dawn
#3 - 2014-02-09 16:17:15 UTC  |  Edited by: Neroo Tal
That seems to have sorted it :) Thank you kindly. For anyone else interested join invtypes t with invblueprinttypes b and look up b.blueprinttypeid = t.typeid and t.marketgroupid is not null