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.
 

ramAssemblyLineType Tables
Author
Previous Topic Next Topic
Zifrian
University of Caille
Gallente Federation
#1 - 2014-08-16 01:32:59 UTC
I'm looking at the ramAssemblyLineTypeDetailPerGroup and ramAssemblyLineTypeDetailPerCategory tables in the SDE to look at faculties and the data isn't making sense to me. There are TE and ME values in those tables in addition to the ramAssemblyLineTypes table but when I link up the groupID or categoryID, I'm not seeing data that makes any sense. I'm using the assemblyLineTypeID to link the tables.

Anyone use these tables that can clue me in to how they work or is there a data issue here? I assume that the TE and ME values there should be taken into account in some way but I'm not sure I'm linking the data up correctly.

Thanks

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

Import CCP's SDE - EVE SDE Database Builder
Cecil Oppenheimer
Uti Possidetis
#2 - 2014-08-23 04:58:02 UTC
Zifrian wrote:
I'm looking at the ramAssemblyLineTypeDetailPerGroup and ramAssemblyLineTypeDetailPerCategory tables in the SDE to look at faculties and the data isn't making sense to me. There are TE and ME values in those tables in addition to the ramAssemblyLineTypes table but when I link up the groupID or categoryID, I'm not seeing data that makes any sense. I'm using the assemblyLineTypeID to link the tables.

Anyone use these tables that can clue me in to how they work or is there a data issue here? I assume that the TE and ME values there should be taken into account in some way but I'm not sure I'm linking the data up correctly.

Thanks



Don't know if you've sorted it by now, but unless I've got it wrong, the 2 tables seem to refer to ship and non ship industry.

Compare the results of these two queries for the same station:

Query 1:

SELECT a.stationID
,a.assemblyLineTypeID
,a.stationTypeID
,b.assemblyLineTypeName
,b.baseCostMultiplier
,b.baseMaterialMultiplier
,b.baseTimeMultiplier
,c.groupID
,d.groupName
,c.timeMultiplier
,c.materialMultiplier
,c.costMultiplier

FROM [ebs_DATADUMP].[dbo].[ramAssemblyLineStations] as a
inner join [ebs_DATADUMP].[dbo].[ramAssemblyLineTypes] as b on a.assemblyLineTypeID = b.assemblyLineTypeID
inner join [ebs_DATADUMP].[dbo].[ramAssemblyLineTypeDetailPerGroup] as c on a.assemblyLineTypeID = c.assemblyLineTypeID
inner join [ebs_DATADUMP].[dbo].[invGroups] as d on c.groupID = d.groupID

where a.stationID = 60000976

Query 2:

SELECT a.stationID
,a.assemblyLineTypeID
,a.stationTypeID
,b.assemblyLineTypeName
,b.baseCostMultiplier
,b.baseMaterialMultiplier
,b.baseTimeMultiplier
,c.categoryID
,d.categoryName
,c.timeMultiplier
,c.materialMultiplier
,c.costMultiplier

FROM [ebs_DATADUMP].[dbo].[ramAssemblyLineStations] as a
inner join [ebs_DATADUMP].[dbo].[ramAssemblyLineTypes] as b on a.assemblyLineTypeID = b.assemblyLineTypeID
inner join [ebs_DATADUMP].[dbo].[ramAssemblyLineTypeDetailPerCategory] as c on a.assemblyLineTypeID = c.assemblyLineTypeID
inner join [ebs_DATADUMP].[dbo].[invCategories] as d on c.categoryID = d.categoryID

where a.stationID = 60000976
Aineko Macx
#3 - 2014-08-24 13:20:48 UTC  |  Edited by: Aineko Macx
I coded support for assemblyLines a month ago, so from memory:
- Assembly Lines are compatible with the activity if the activities output items groupID appears in DetailsPerGroup or its categoryID appears in the DetailsPerCategory table. Depending on the activity, you have to check a different "thing" for compatibility:
For manufacturing, check the product type. For TE/ME research, copying and reverse engineering, check the input BP. For invention, check the product of the invented BP.
- The time, material and cost modifier of ramAssemblyLineTypes and the Details* tables for a given product are multiplied together. This is in addition to the modifiers of Teams, and in the case of cost modifiers, also system industry indices.

What exactly is the difficulty?

iveeCore 3.0: The PHP engine for industrial activities and CREST library
Zifrian
University of Caille
Gallente Federation
#4 - 2014-08-31 00:53:29 UTC
Gah, it would help if I imported my data correctly. It works exactly how I thought (and you said). I imported the categoryID for groupID. Oh boy...

Thanks!

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

Import CCP's SDE - EVE SDE Database Builder
Magic Crisp
Amarrian Micro Devices
#5 - 2014-09-01 08:23:08 UTC
Aineko Macx wrote:
I coded support for assemblyLines a month ago, so from memory:
- Assembly Lines are compatible with the activity if the activities output items groupID appears in DetailsPerGroup or its categoryID appears in the DetailsPerCategory table. Depending on the activity, you have to check a different "thing" for compatibility:
For manufacturing, check the product type. For TE/ME research, copying and reverse engineering, check the input BP. For invention, check the product of the invented BP.
- The time, material and cost modifier of ramAssemblyLineTypes and the Details* tables for a given product are multiplied together. This is in addition to the modifiers of Teams, and in the case of cost modifiers, also system industry indices.

What exactly is the difficulty?


And how do you join this data with the proper instance of the location? For a simple activityID (= 1 =manufacturing), for a single item, i get 52 rows. These seem to be different outposts/stations parameters. How do I get these, especially for player built outposts?

I haven't seen such data in any of the API endpoints, but I might be missing something.
Zifrian
University of Caille
Gallente Federation
#6 - 2014-09-01 11:39:17 UTC  |  Edited by: Zifrian
Magic Crisp wrote:
Aineko Macx wrote:
I coded support for assemblyLines a month ago, so from memory:
- Assembly Lines are compatible with the activity if the activities output items groupID appears in DetailsPerGroup or its categoryID appears in the DetailsPerCategory table. Depending on the activity, you have to check a different "thing" for compatibility:
For manufacturing, check the product type. For TE/ME research, copying and reverse engineering, check the input BP. For invention, check the product of the invented BP.
- The time, material and cost modifier of ramAssemblyLineTypes and the Details* tables for a given product are multiplied together. This is in addition to the modifiers of Teams, and in the case of cost modifiers, also system industry indices.

What exactly is the difficulty?


And how do you join this data with the proper instance of the location? For a simple activityID (= 1 =manufacturing), for a single item, i get 52 rows. These seem to be different outposts/stations parameters. How do I get these, especially for player built outposts?

I haven't seen such data in any of the API endpoints, but I might be missing something.

I'm not sure what you are looking for specifically but if you are looking for the types of items to build in an outpost, you can link it up with the crest data to get the facility type ID. Use the ramInstallationTypeContents table and link the facilityTypeID from CREST to the installationTypeID in at table. Here's an example of outposts to get you started (INDUSTRY_FACILITIES is my table for the CREST import):

SELECT FACILITY_NAME, FACILITY_TYPE_ID, typeName, ramAssemblyLineTypes.assemblyLineTypeName, ramActivities.activityName, invGroups.groupName
FROM INDUSTRY_FACILITIES, invTypes, ramInstallationTypeContents, ramAssemblyLineTypes, ramActivities
LEFT JOIN ramAssemblyLineTypeDetailPerGroup ON ramAssemblyLineTypes.assemblyLineTypeID = ramAssemblyLineTypeDetailPerGroup.assemblyLineTypeID
LEFT JOIN invGroupsON ramAssemblyLineTypeDetailPerGroup.groupID = invGroups.groupID
WHERE INDUSTRY_FACILITIES.FACILITY_TYPE_ID = invTypes.typeID
AND INDUSTRY_FACILITIES.FACILITY_TYPE_ID = ramInstallationTypeContents.installationTypeID
AND ramInstallationTypeContents.assemblyLineTypeID = ramAssemblyLineTypes.assemblyLineTypeID
AND ramAssemblyLineTypes.activityID = ramActivities.activityID
AND FACILITY_TYPE_ID IN (21642,21644,21645,21646)
ORDER BY FACILITY_NAME

For NPC stations, it works similarly but you can use the static ramAssemblyLineStations to get the list of stations and the assemblyLineTypeID.

If you are looking for the upgrades installed in an outpost, those aren't available from CREST but I hope they add it at some point.

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

Import CCP's SDE - EVE SDE Database Builder
Aineko Macx
#7 - 2014-09-01 16:44:04 UTC
Magic Crisp wrote:
How do I get these, especially for player built outposts?

I haven't seen such data in any of the API endpoints, but I might be missing something.

Unfortunately there is no info at all about player built outposts in the SDE.
With the data from https://api.eveonline.com/Eve/ConquerableStationList.xml.aspx you can get the stationTypeID, which you can use to get the base assemblyLineTypeIDs via ramInstallationTypeContents. No way to get the upgrades (different assemblyLines), though. I have asked for this situation to be improved, but I'm not holding my breath.

If you know the upgrades the station has, you can pick the appropriate assemblyLineTypeID, the names are fairly discriptive.

iveeCore 3.0: The PHP engine for industrial activities and CREST library
Querns
Science and Trade Institute
Caldari State
#8 - 2014-10-06 22:57:21 UTC
Zifrian wrote:

I'm not sure what you are looking for specifically but if you are looking for the types of items to build in an outpost, you can link it up with the crest data to get the facility type ID. Use the ramInstallationTypeContents table and link the facilityTypeID from CREST to the installationTypeID in at table. Here's an example of outposts to get you started (INDUSTRY_FACILITIES is my table for the CREST import):

--sql--

For NPC stations, it works similarly but you can use the static ramAssemblyLineStations to get the list of stations and the assemblyLineTypeID.

If you are looking for the upgrades installed in an outpost, those aren't available from CREST but I hope they add it at some point.

This was exactly what I was looking for. I had overlooked the ramInstallationTypeContents table. Thanks for your help.

This post was crafted by the wormhole expert of the Goonswarm Economic Warfare Cabal, the foremost authority on Eve: Online economics and gameplay.