Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Kronus Heilgar
Caldari Provisions Caldari State
6
|
Posted - 2012.05.17 05:56:00 -
[1] - Quote
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
174
|
Posted - 2012.05.17 06:11:00 -
[2] - Quote
Simply because "Large Blaster Battery" doesn't need any minerals to be constructed. You need look in ramTypeRequirements for typeID=2803. |
Kronus Heilgar
Caldari Provisions Caldari State
6
|
Posted - 2012.05.17 19:18:00 -
[3] - Quote
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
410
|
Posted - 2012.05.17 20:21:00 -
[4] - Quote
invTypeMaterials contains what things reprocess into.
ramTypeRequirements is for those materials you don't get back.
(also, ME affects ITM. Doesn't touch RTR) FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Kronus Heilgar
Caldari Provisions Caldari State
6
|
Posted - 2012.05.17 21:17:00 -
[5] - Quote
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
410
|
Posted - 2012.05.18 10:09:00 -
[6] - Quote
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. 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 |