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.
 

T2 manufacturing Info from the DB dump
Author
Previous Topic Next Topic
Gonca Sari Offermans
Viktor's Invention Emporium
#1 - 2012-12-16 01:33:19 UTC
I'm trying to get manufacturing data for Shield Power Relay II's (1422) from the db dump and am having issues. Taking Tritanium for example, looking in the db for the amount that goes into a SPRII and I get 1205. I then look for the amount that goes into a Shield Power Relay I (2331) which is 1004. Subtracting that from the SPRII yields 201. The SPRII BPO in eve says 221. Where did I lose 20?
Iume
Federal Navy Academy
Gallente Federation
#2 - 2012-12-16 09:05:15 UTC
Unfortunatly materialrequirements isn't a simple 2 table table lookup in Eve.

You need to take the blueprint (invBlueprintTypes table ) and additional materials (ramTypeRequirements) into account, too.

also be aware, that some materials are fed back into the production process and actually lower the amount required.
e.g. a Zealot used the materials refined form the Omen that is needed for production.

Side note:

One important thing for retribution is: All the rebalanced frigs and cruisers that were not tier 1(Maller, Rifter, etc. ) had additional materials added (theinvBlueprintTypes and ramTypeRequirements thing ).

So actually they cost more to produce now, but yield the same amout of materials when reprocessing them.

best Iume




EveXup http://www.digitalcreaturesnetwork.com/EveXup/ EveAssembler http://www.digitalcreaturesnetwork.com/EveAssembler/ EveIskBox http://www.digitalcreaturesnetwork.com/EveISKBox/
Gonca Sari Offermans
Viktor's Invention Emporium
#3 - 2012-12-16 17:47:23 UTC  |  Edited by: Gonca Sari Offermans
Iume wrote:
blueprint (invBlueprintTypes table )

this is step 1 described
lume wrote:
additional materials (ramTypeRequirements)

This doesn't affect trit but was added to the numbers I got from step 1 anyway
lume wrote:
that some materials are fed back into the production process and actually lower the amount required.

This is step 2 described

I know it takes a tripple lookup for the ram types are simple as you don't have to subtract, just to elaborate furthur, these are the querys run

Store

SELECT m.materialTypeID, m.quantity
FROM invTypeMaterials AS m
WHERE m.typeID = 1422

Add

SELECT r.requiredTypeID, r.quantity, r.damagePerJob
FROM ramTypeRequirements AS r
INNER JOIN invBlueprintTypes AS b
ON r.typeID = b.blueprintTypeID
INNER JOIN invTypes AS t
ON r.requiredTypeID = t.typeID
INNER JOIN invGroups AS g
ON t.groupID = g.groupID
WHERE b.productTypeID = 1422
AND r.activityID = 1
AND g.categoryID != 16

use
SELECT valueInt FROM `dgmTypeAttributes` WHERE `typeID` = 1422 AND `attributeID` =422
to detect T2

use
SELECT parentTypeID FROM `invMetaTypes` WHERE `typeID` = 1422
to get the T1 item

then subtract
SELECT m.materialTypeID, m.quantity
FROM invTypeMaterials AS m
WHERE m.typeID = 2331
Abdiel Kavash
Deep Core Mining Inc.
Caldari State
#4 - 2012-12-16 18:50:46 UTC
Gonca Sari Offermans wrote:
I'm trying to get manufacturing data for Shield Power Relay II's (1422) from the db dump and am having issues. Taking Tritanium for example, looking in the db for the amount that goes into a SPRII and I get 1205. I then look for the amount that goes into a Shield Power Relay I (2331) which is 1004. Subtracting that from the SPRII yields 201. The SPRII BPO in eve says 221. Where did I lose 20?


I didn't run the actual numbers myself, but I am reasonably certain that you failed to account for the 10% inherent waste of the (unresearched) in-game BPO.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2012-12-17 00:22:27 UTC
By the looks of it, Abdiel is right. Of course, you're not going to get a ME 0 blueprint. With invention, the best you'll manage is -1, and that's a stupid way to do it. -4 is the norm. (To get -1 you have to use a decryptor. And you will not make up the cost of the decryptor in any of your savings)

The following two posts should be of interest to you.

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/

As might http://www.fuzzwork.co.uk/blueprints/1422/0/5/0/5


Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Gonca Sari Offermans
Viktor's Invention Emporium
#6 - 2012-12-17 01:02:00 UTC
Thanks, that was it!