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.
 

Determining packaged ship volumes

Author
Xander Hunt
#1 - 2011-10-17 05:58:06 UTC
Does anyone know how to correlate ships packaged vs unpackaged volumes? The invTypes seems to only have the unpackaged volumes. Anyone know how to get packaged volumes?

Tried this query (From SQLite):

SELECT [invTypes].[typeID], [invTypes].[typeName], [invGroups].[groupName],
[invCategories].[categoryName], [invTypes].[volume],
[dgmAttributeTypes].[attributeName], [dgmTypeAttributes].[valueInt],
[dgmTypeAttributes].[valueFloat]
FROM [invTypes] INNER JOIN
[invGroups] ON [invGroups].[groupID] = [invTypes].[groupID] INNER JOIN
[invCategories] ON [invCategories].[categoryID] = [invGroups].[categoryID]
INNER JOIN
[dgmTypeAttributes] ON [dgmTypeAttributes].[typeID] = [invTypes].[typeID]
INNER JOIN
[dgmAttributeTypes] ON [dgmAttributeTypes].[attributeID] =
[dgmTypeAttributes].[attributeID]
WHERE [invTypes].[typeName] LIKE 'mach%' AND [invTypes].[published] = 1 AND
[invCategories].[categoryName] = 'Ship'
ORDER BY [dgmAttributeTypes].[attributeName]

Using the Mach as an example, the ships packaged size is 50k m3 and unpackaged is 595k m3. I don't see 50k anywhere in that list, so, I guess I'm barking up the wrong tree.
Desmont McCallock
#2 - 2011-10-17 06:01:44 UTC
You will find your answer here.
Xander Hunt
#3 - 2011-10-21 11:59:32 UTC
Very nice. Thank you.