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

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

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Getting the Datacores needed for Bluerprint invention.
Author
Previous Topic Next Topic
Kw1jybo
Sunny Weather Mercenaries
The Initiative.
#1 - 2012-11-02 18:52:03 UTC
Anyone have a query to get this info?
TheSkeptic
Federal Navy Academy
Gallente Federation
#2 - 2012-11-02 22:54:22 UTC
Example is for 200mm AC I Blueprint (typeid 821)

select
tam.requiredTypeID,
t.typename,
tam.quantity
from typeactivitymaterials tam
join invtypes t on t.typeid = tam.requiredtypeid
where tam.activityid = 8
and t.typename like 'Datacore - %'
and tam.typeid = 821;

If you want the interface listed also, remove the and t.typename like 'Datacore - %' line

...

Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2012-11-02 23:27:07 UTC