EVE Technology Lab

The problem is that you are only retrieving the "Raw Material" requirements (those that suffer waste). You need to retrieve the "Extra Materials" as well (those that do not suffer waste). For a long time, T1 manufacturing didn't feature Extra Materials, so you'll find a lot of "T1 manufacture requirement" queries out there that ignore it.

But with the tiericide rebalancing of ships, they are also rebalancing the material requirements. While Extra Materials do not suffer waste, they also have the property that they are not recovered when the ship is reprocessed. CCP have been adding the additional mineral requirements for rebalanced ships as Extra Materials, presumably to avoid people mass-producing the ships pre-patch and reprocessing them all post-patch and magically creating huge piles of minerals (which is what would have happened if they had just increased the quantities of Raw Materials).

You can retrieve the Extra Materials from the ramTypeRequirements table, bearing in mind that this is keyed on the ProductTypeID, not the BlueprintTypeID.

Just to be safe, I'd probably suggest implementing the full manufacturing logic along the lines of what I originally described way back when...

Really old forum post

I figured that was kind of the problem, but my inital query returned 0 results. After I read through your old post I tried something new.

select typeName, round(sum(quantity)*1.10)
from (select t2.typeName, tm.quantity
from evestatic.invTypes t, evestatic.invTypeMaterials tm, evestatic.invTypes t2
where t.typeName = 'Procurer'
and t.typeid = tm.typeID
and t2.typeid = tm.materialTypeID
union
select t2.typeName, tr.quantity
from evestatic.invTypes t, evestatic.invBlueprintTypes bt, evestatic.ramTypeRequirements tr, evestatic.invTypes t2
where t.typeName = 'Procurer'
and t.typeID = bt.productTypeID
and bt.blueprintTypeID = tr.typeID
and tr.requiredTypeID = t2.typeid
and tr.activityID = 1
and tr.damagePerJob > 0) as r1
group by typeName

I get the following results.

typeName round(sum(quantity)*1.10)
Isogen 30800
Megacyte 231
Mexallon 46200
Nocxium 3080
Pyerite 462000
Tritanium 1540000
Zydrine 770

Which still isn't correct, but it's getting there. I welcome any suggestions to clean up that query. This query is just for t1 products. I have a working t2 model (gotta fix the t1 component.)

Extra materials aren't subject to waste from ME
They are only subject to waste from your production efficiency if they also exist in the base materials.

To make it a little more generic, your waste multiplier is in the invBlueprintTypes table as wasteFactor. not everything is 10%. I'd have directed you to the blog entry I wrote on this, but that server is taking a winter break in the Bahamas at the moment.

http://webcache.googleusercontent.com/search?q=cache:gdtQ14CzV8EJ:www.fuzzwork.co.uk/blog/2012/10/24/eve-sde-sql-blueprint-details/&hl=en&client=firefox-a&hs=Xd3&tbo=d&strip=1 isn't perfect, but it covers a lot of the stuff you might be interested in. Hit the text only link as everything is broken right now.

Wow, CCP sure have convoluted production calculations.....