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.
 

Missing SDE data?
Author
Previous Topic Next Topic
Kronus Heilgar
Science and Trade Institute
Caldari State
#1 - 2012-05-17 05:56:15 UTC
Anyone know why some items are missing from the static export? For example, the Large Blaster Battery (typeID = 17402, blueprintTypeID = 2803) has no corresponding entries in the invTypeMaterials (which specifies how much of different materials are needed to construct any given object).

It would seem like most of the missing ones are POS structures, is there a reason their required materials aren't in the SDE?

This is not the signature you're looking for.
Desmont McCallock
#2 - 2012-05-17 06:11:40 UTC  |  Edited by: Desmont McCallock
Simply because "Large Blaster Battery" doesn't need any minerals to be constructed. You need to look in ramTypeRequirements for typeID=2803.
Kronus Heilgar
Science and Trade Institute
Caldari State
#3 - 2012-05-17 19:18:53 UTC
Ok, interesting. invTypeMaterials doesn't just show mineral requirements though, for rigs it shows the salvage components required. I wonder why they separate RAM components into a different table...

This is not the signature you're looking for.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2012-05-17 20:21:42 UTC
invTypeMaterials contains what things reprocess into.

ramTypeRequirements is for those materials you don't get back.

(also, ME affects ITM. Doesn't touch RTR)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Kronus Heilgar
Science and Trade Institute
Caldari State
#5 - 2012-05-17 21:17:53 UTC  |  Edited by: Kronus Heilgar
Ok, so if a BPO has requirements in RTR but NOT ITM, that means that ME research will never have any effect?

On a similar topic, does anyone know the formula for calculating the exact "perfect ME" for a BPO? I see contradicting numbers; for example, look at a "Large Warp Core Optimizer I" with the highest material requirement being 99 "burned logic circuits" (according to the SDE). If you use any of the popular online ME calculators (like here or here), they will tell you that perfect ME is at level 19. However, if you look at the Evelopedia page on it (here) it says that for an item with material requirement of 99, "perfect ML" is at level 9 (shows in the table).

Can anyone explain this discrepancy?

This is not the signature you're looking for.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2012-05-18 10:09:41 UTC
Sometimes what's in Evelopedia isn't accurate?

anyway, the formula I'm using for perfect ME level:

floor(quantity*((wasteFactor/100)/0.5))

(yes, I could have /50 instead. it's written like that to remind me why I'm doing it.)


The waste factor comes out of invBlueprintTypes, as wasteFactor.


In case you're curious:
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

and:
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

are the queries I'm using to get out the materials. All three parameters are the typeid of the thing being made.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter