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

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

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Static Dump out of date?
Author
Previous Topic Next Topic
Big FatWallet
Synergie Industries
#1 - 2012-08-27 21:59:11 UTC  |  Edited by: Big FatWallet
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

222 34 Tritanium 184
222 35 Pyerite 15
222 38 Nocxium 1

which is not right ...

Thanks
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2012-08-28 00:41:40 UTC
Are you taking the waste into account?

Because those figures are right. For no waste.

ME 0 on that blueprint has a 10% waste.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Big FatWallet
Synergie Industries
#3 - 2012-08-28 05:32:25 UTC
Many thanks, I hadn't realised I needed to factor in the waste. Thanks.
Johnny Togenada
Doomheim
#4 - 2012-09-03 18:41:06 UTC
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
#5 - 2012-09-03 19:21:34 UTC
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
Vote Steve Ronuken for CSM
#6 - 2012-09-04 09:29:12 UTC
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)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter