| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
InternetSpaceJesus
Imperial Academy
Amarr Empire
7
   |
Posted - 2012.12.07 05:12:00 -
[1] - Quote
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
Republic University
Minmatar Republic
1
|
Posted - 2012.12.07 07:29:00 -
[2] - Quote
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
840
|
Posted - 2012.12.07 11:05:00 -
[3] - Quote
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
FuzzWork Enterprises
http://www.fuzzwork.co.uk/
Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities.As well as mysql and CSV/XLS conversions of the Static Data Extract. |
InternetSpaceJesus
Imperial Academy
Amarr Empire
7
|
Posted - 2012.12.07 13:29:00 -
[4] - Quote
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
Xanadu
13
|
Posted - 2012.12.07 13:53:00 -
[5] - Quote
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 |
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |