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.
 

DB Dump Tech III BP materials
Author
Previous Topic Next Topic
Ideki
Wolf Brothers INC
United Neopian Federation
#1 - 2012-05-08 17:18:27 UTC
I ma trying to use the DB Dump to find the components from the BP to build Tech III parts.

Ex: Tengu Offensive - Covert Reconfiguration (typeID: 30125)

All the other BPs I can find the materials from the DB by matching the typeIDs between 'invBlueprintTypes', 'invTypeMaterials' and 'invTypes'.

But not for the tech 3.
They have no entries in the invTypeMaterials table.

Is there a special table for those ?

Creator of The EVE Planetary Planner
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2012-05-08 17:39:12 UTC  |  Edited by: Steve Ronuken
take a look at ramTypeMaterials

That's for materials which you don't get back when recycling something. They're also not affected by ME waste (They are affected by PE waste, but only if they also exist in the regular materials)

( http://www.fuzzwork.co.uk/blueprints/30125/0/5/0/5 )

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Ideki
Wolf Brothers INC
United Neopian Federation
#3 - 2012-05-08 18:20:58 UTC
Steve Ronuken wrote:
take a look at ramTypeMaterials

That's for materials which you don't get back when recycling something. They're also not affected by ME waste (They are affected by PE waste, but only if they also exist in the regular materials)

( http://www.fuzzwork.co.uk/blueprints/30125/0/5/0/5 )


Thanks.
I will take a look at it Smile

Creator of The EVE Planetary Planner
Ideki
Wolf Brothers INC
United Neopian Federation
#4 - 2012-05-08 18:44:16 UTC
Steve Ronuken wrote:
take a look at ramTypeMaterials

That's for materials which you don't get back when recycling something. They're also not affected by ME waste (They are affected by PE waste, but only if they also exist in the regular materials)

( http://www.fuzzwork.co.uk/blueprints/30125/0/5/0/5 )


Hum.
I looked at the DB, and there is no ramTypeMaterials table.
The nearest one is ramTypeRequirements.
And I cannot find any entry with id '30125'.

I will continue to look around

Creator of The EVE Planetary Planner
Matthew
BloodStar Technologies
#5 - 2012-05-08 22:00:09 UTC
ramTypeRequirements is the table you want, but it is referenced on the blueprint TypeID, not the product.

So for your product of typeID 30125, you can go through invBlueprintTypes (productTypeID=30125) to find the corresponding blueprint is blueprintTypeID=30400

You then look up typeID 30400 in ramTypeRequirements for your desired activityID (see ramActivities) to find the corresponding requirements from that table.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2012-05-08 22:02:50 UTC
/me facepalms.

That teaches me for not doublechecking. Mathew is right. ramTypeRequirements.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Ideki
Wolf Brothers INC
United Neopian Federation
#7 - 2012-05-09 13:14:21 UTC
Matthew wrote:
ramTypeRequirements is the table you want, but it is referenced on the blueprint TypeID, not the product.

So for your product of typeID 30125, you can go through invBlueprintTypes (productTypeID=30125) to find the corresponding blueprint is blueprintTypeID=30400

You then look up typeID 30400 in ramTypeRequirements for your desired activityID (see ramActivities) to find the corresponding requirements from that table.


That worked.
Thanks a lot Big smile

Creator of The EVE Planetary Planner