| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Messenger Of Truth
Butlerian Crusade
18
   |
Posted - 2016.01.14 19:07:11 -
[1] - Quote
In hisec manufacturing, there are 3 broad categories of items: those that can be built in a POS or npc station (most stuff), those that can be built in a station but not a POS (e.g. outpost upgrades), those that can be built in a POS but not an npc station (e.g. T3).
I want to use the SDE data to calculate the restrictions that apply to each item.
Using ramAssemblyLineTypeDetailPerGroup and ramAssemblyLineTypeDetailPerCategory I'm able to determine if there is a POS assembly line that the item can be built in. This allowed me to determine that outpost upgrades cannot be built in a POS. However I don't see how to prove that T3 items cannot be built in an npc station. I can find out if a particular npc station has manufacturing facilities with a query like:
"SELECT * from ramAssemblyLineStations as rals
INNER JOIN ramAssemblyLineTypes as ralt ON ralt.assemblyLineTypeID = rals.assemblyLineTypeID
where stationID IN (%s)"
I might be missing something, but you don't seem to be able to link ramAssemblyLineStations to blueprints via group/category and ramInstallationTypeContents as you are able to for POS facilities.
How do I determine that I can't build T3 things in an NPC station? |
Aineko Macx
353
|
Posted - 2016.01.14 20:56:08 -
[2] - Quote
No hisec NPC station has assembly lines for activity 1 for which ramAssemblyLineTypeDetailPerCategory includes category 6 or where ramAssemblyLineTypeDetailPerGroup includes group 963.
iveeCore: The PHP engine for industrial activities and CREST library
|
Zifrian
Licentia Ex Vereor
Phoebe Freeport Republic
1697
|
Posted - 2016.01.14 22:11:30 -
[3] - Quote
Aineko Macx wrote: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.
Yeah the product Id is the key piece of information. I struggled a bit with these tables and now I do a massive query to build a new one I can work with more easily but I also end up adding data too in line with the rules on the data.
This thread might help a bit if you are missing something: https://forums.eveonline.com/default.aspx?g=posts&m=5396419#post5396419
GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour!
|
Messenger Of Truth
Butlerian Crusade
18
|
Posted - 2016.01.15 14:52:34 -
[4] - Quote
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! |
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |