Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Badmoons
Industrial Nightmare Inc
0
|
Posted - 2012.12.04 17:10:00 -
[1] - Quote
So I've loaded the Retribution db dump and I'm still seeing incorrect returns for the required materials for the Procurer. I was hopeing someone knew what's up.
select t2.typeName, round(tm.quantity*1.10) from evestatic.invTypes t, evestatic.invTypeMaterials tm, evestatic.invTypes t2 where t.typeName = 'Procurer' and t.typeid = tm.typeID and t2.typeid = tm.materialTypeID
typeNameround(tm.quantity*1.10) Tritanium256824 Pyerite16173 Mexallon6602 Isogen560 Nocxium54 Zydrine32 Megacyte10
Tritanium should be 1423348. Any ideas? |
Matthew
BloodStar Technologies
3
|
Posted - 2012.12.04 19:45:00 -
[2] - Quote
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 |
Badmoons
Industrial Nightmare Inc
0
|
Posted - 2012.12.04 19:53:00 -
[3] - Quote
I was thinking that may have been the problem, but
select * from evestatic.ramTypeRequirements where typeID = 17480
reveals no results. |
Badmoons
Industrial Nightmare Inc
0
|
Posted - 2012.12.04 20:15:00 -
[4] - Quote
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.
typeNameround(sum(quantity)*1.10) Isogen30800 Megacyte231 Mexallon46200 Nocxium3080 Pyerite462000 Tritanium1540000 Zydrine770
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.) |
Louis Vitton
Jita Trade and Industry
20
|
Posted - 2012.12.04 23:08:00 -
[5] - Quote
If your still having issues with this query i would hold off and try when the next SDD is done tomorrow as there are a few issues with the first one. |
Steve Ronuken
Fuzzwork Enterprises
830
|
Posted - 2012.12.04 23:23:00 -
[6] - Quote
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. 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. |
Badmoons
Industrial Nightmare Inc
0
|
Posted - 2012.12.04 23:48:00 -
[7] - Quote
BINGO, thank you to everyone for your help!
select typeName, round(sum(quantity)) from (select t2.typeName, tm.quantity*1.10 as 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
typeNameround(sum(quantity)) Isogen28051 Megacyte211 Mexallon42600 Nocxium2805 Pyerite421470 Tritanium1423348 Zydrine703 |
Steve Ronuken
Fuzzwork Enterprises
831
|
Posted - 2012.12.04 23:54:00 -
[8] - Quote
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. 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. |
Badmoons
Industrial Nightmare Inc
0
|
Posted - 2012.12.05 00:00:00 -
[9] - Quote
Cool, thanks. I keep it open because I want to make it changeable in my function. |
Somatic Neuron
Masterwork Productions Inc
19
|
Posted - 2012.12.05 15:16:00 -
[10] - Quote
Wow, CCP sure have convoluted production calculations..... |
|
Steve Ronuken
Fuzzwork Enterprises
832
|
Posted - 2012.12.05 15:19:00 -
[11] - Quote
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/
Now that it's back up and running. 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. |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |