| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Big FatWallet
Twisted Defence
0
   |
Posted - 2012.08.27 21:59:00 -
[1] - Quote
Hi guys, might be a stupid question.
Is the static dump out of date?
I downloaded Inferno_1.2_76477_db
which contained DATADUMP201208080939.bak
select
eve.dbo.invTypeMaterials.typeID,
eve.dbo.invTypeMaterials.materialTypeID,
eve.dbo.invTypes.typeName,
eve.dbo.invTypeMaterials.quantity
from eve.dbo.invTypeMaterials
inner join eve.dbo.invTypes on
eve.dbo.invTypes.typeID = eve.dbo.invTypeMaterials.materialTypeID
This returned: for Antimatter S
22234Tritanium184
22235Pyerite15
22238Nocxium1
which is not right ...
Thanks |
Steve Ronuken
Fuzzwork Enterprises
584
|
Posted - 2012.08.28 00:41:00 -
[2] - Quote
Are you taking the waste into account?
Because those figures are right. For no waste.
ME 0 on that blueprint has a 10% waste.
FuzzWork Enterprises
http://www.fuzzwork.co.uk/
Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Big FatWallet
Twisted Defence
0
|
Posted - 2012.08.28 05:32:00 -
[3] - Quote
Many thanks, I hadn't realised I needed to factor in the waste. Thanks. |
Johnny Togenada
School of Applied Knowledge
Caldari State
0
|
Posted - 2012.09.03 18:41:00 -
[4] - Quote
Does somebody know, where to get the blueprint data for the extra materials? Can't find it in the dump. |
Lutz Major
Austriae Est Imperare Orbi Universo
290
|
Posted - 2012.09.03 19:21:00 -
[5] - Quote
Johnny Togenada wrote:Does somebody know, where to get the blueprint data for the extra materials? Can't find it in the dump.
They are in the ramTypeRequirements table. The typeID is the ID of the blueprint, though! |
Steve Ronuken
Fuzzwork Enterprises
616
|
Posted - 2012.09.04 09:29:00 -
[6] - Quote
Johnny Togenada wrote:Does somebody know, where to get the blueprint data for the extra materials? Can't find it in the dump.
Base materials:
select typeid,name,greatest(0,sum(quantity)) quantity from (select invTypes.typeid typeid,invTypes.typeName name,quantity from invTypes,invTypeMaterials where invTypeMaterials.materialTypeID=invTypes.typeID and invTypeMaterials.TypeID=? union select invTypes.typeid typeid,invTypes.typeName name,invTypeMaterials.quantity*r.quantity*-1 quantity from invTypes,invTypeMaterials,ramTypeRequirements r,invBlueprintTypes bt where invTypeMaterials.materialTypeID=invTypes.typeID and invTypeMaterials.TypeID =r.requiredTypeID and r.typeID = bt.blueprintTypeID AND r.activityID = 1 and bt.productTypeID=? and r.recycle=1) t group by typeid,name
Extra materials:
SELECT t.typeName tn, r.quantity qn, r.damagePerJob dmg,t.typeID typeid FROM ramTypeRequirements r,invTypes t,invBlueprintTypes bt,invGroups g where r.requiredTypeID = t.typeID and r.typeID = bt.blueprintTypeID AND r.activityID = 1 and bt.productTypeID=? and g.categoryID != 16 and t.groupID = g.groupID
All three binds (two in the first, 1 in the second) are the type id of the thing that you're making.
This is to catch the things which are marked as recyclable in the extra materials table, and remove them from the list in invTypeMaterials (which is what you get when you recycle something, rather than the cost to make. They're just the same, most of the time)
FuzzWork Enterprises
http://www.fuzzwork.co.uk/
Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |