EVE Technology Lab

You have to check the product for compatibility, not the blueprint. No hisec NPC station has assembly lines for activity 1 for which ramAssemblyLineTypeDetailPerCategory includes category 6 or where ramAssemblyLineTypeDetailPerGroup includes group 963.

Sorry I misspoke a bit (I'm actually using the the product typeid not the blueprint typeid) and also cos I wanted to avoid pasting loads of SQL I haven't communicated very well the problem I'm having. So let me restate, with added sql.

I will use the example of a condor with typeId 583 and a svipul with typeid 34562.

First I shall answer the question, are these blueprints buildable in any of the pos facilities I have access to?

select * from ramAssemblyLineTypeDetailPerCategory as raltdpc inner join invCategories as ic on ic.categoryId = raltdpc.categoryId  inner join ramAssemblyLineTypes as ralt on ralt.assemblyLineTypeId = raltdpc.assemblyLineTypeId inner join invGroups as ig on ic.categoryID = ig.categoryID  inner join invTypes as it on ig.groupID = it.groupID INNER JOIN ramInstallationTypeContents as ritc ON ritc.assemblyLineTypeId = ralt.assemblyLineTypeId       where it.typeId = 583;


select * from ramAssemblyLineTypeDetailPerGroup as raltdpg inner join invGroups as ig on ig.groupId = raltdpg.groupId inner join  ramAssemblyLineTypes as ralt on ralt.assemblyLineTypeId = raltdpg.assemblyLineTypeId inner join invTypes as it on ig.groupId = it.groupId INNER JOIN ramInstallationTypeContents as ritc ON ritc.assemblyLineTypeId = ralt.assemblyLineTypeId       where it.typeId = 583;

I can check the facility types that are returned by those two queries and find that yes, the small ship assembly array module is mentioned so I can build the condor in a pos with this module. I can do a similar query and find that there is an advanced small ship assembly array module so I can build the svipul in any pos that has this module.

Now I want to answer the question: can I build these items in a particular npc station?


The following query returns one result which indicates that manufacturing is possible at this particular NPC station.

SELECT * from ramAssemblyLineStations as rals INNER JOIN ramAssemblyLineTypes as ralt ON ralt.assemblyLineTypeID = rals.assemblyLineTypeID INNER JOIN staStations as sta ON sta.stationID = rals.stationID where sta.stationName = "Amarr VIII (Oris) - Emperor Family Academy";

Now given that we can build Condors in NPC stations but we can't build Svipuls in NPC stations, I would *expect* to be able to find out whether this specific product is buildable on this assemblyLineType with a query like this:

SELECT * from ramAssemblyLineStations AS rals INNER JOIN ramAssemblyLineTypes as ralt ON ralt.assemblyLineTypeID = rals.assemblyLineTypeID INNER JOIN staStations as sta ON sta.stationID = rals.stationID INNER JOIN ramAssemblyLineTypeDetailPerGroup as raltdpg ON rals.assemblyLineTypeID = raltdpg.assemblyLineTypeId INNER JOIN invGroups as ig on ig.groupId = raltdpg.groupId  inner join invTypes as it on ig.groupId = it.groupId where sta.stationName = "Amarr VIII (Oris) - Emperor Family Academy" and it.typeId = 34562;

NOTE....while writing this answer, the query seems to have given the result I was expecting - that is the prev query gives a result for a condor but not for a svipul. I mus thave made a mistake when I was trying this previously. I shall leave this post here as a signpost for anybody in the future having the same difficulty as me!