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

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

Science & Industry

 
  • Topic is locked indefinitely.
 

Data Dump Extra Minerals Location
Author
Previous Topic Next Topic
InternetSpaceJesus
Imperial Academy
Amarr Empire
#1 - 2012-12-07 05:12:17 UTC
Anyone know where to find no-waste materials in the data dump for an item? All crusiers got a bunch of no-waste mineral requirements added to them, but I don't know where to find them so I can correctly display the refine price for refining the crusiers.

I make meth to fund my internet spaceships.
loyalslave Askold
Doomheim
#2 - 2012-12-07 07:29:26 UTC
hi,

the extra materials are in the ramTypeRequirements table (activityID=1 for manufactoring)

it won't help you though, as the extra materials don't refine.
refining only gives you the base materials back.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2012-12-07 11:05:23 UTC
Take a look at the following posts. They cover most of what you'll want.

http://www.fuzzwork.co.uk/blog/2012/10/24/eve-sde-sql-blueprint-details/
http://www.fuzzwork.co.uk/blog/2012/10/27/eve-sde-sql-blueprint-details-part-2/

Loyalslave is right though. What you get out of refining something is invTypeMaterials. You won't get anything back.


And Extra materials, duing manufacture, aren't waste free. They're still affected by your Production efficiency if they also appear in the base materials (if they're not in the base, they're not touched). It's just ME waste that's not applied

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
InternetSpaceJesus
Imperial Academy
Amarr Empire
#4 - 2012-12-07 13:29:21 UTC
Yeah I know they won't refine, but if I know the amount of unrefinable minerals, I can figure out the correct refine amounts and price, ect.

I make meth to fund my internet spaceships.
Rutger Janssen
Chanuur
The Initiative.
#5 - 2012-12-07 13:53:31 UTC
From http://wiki.eve-id.net/Bill_of_Materials:

SELECT t.typeName, r.quantity, r.damagePerJob
FROM ramTypeRequirements AS r
INNER JOIN invTypes AS t
ON r.requiredTypeID = t.typeID
WHERE r.typeID = 27913 -- Concussion Bomb Blueprint
AND r.activityID = 1; -- Manufacturing