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.
 

Help needed with data dump
Author
Previous Topic Next Topic
Victoria Sin
Doomheim
#1 - 2013-08-15 10:14:07 UTC
I'm wanting to make a tree of all buildable items (or all blueprints I guess) and their build requirements and stats. Looking at the data dump I can see a table called invBlueprintTypes and I can see a table called invItems. I assume in order to get from blueprint to built item there's a third table somewhere containing a blueprint key and one or more invItem keys.

OK, back to basics: Is there a diagram anywhere showing the table relationships? Big smile
Kid Delicious
Caldari Provisions
Caldari State
#2 - 2013-08-15 11:47:31 UTC
This should help. (by Steve Ronuken)
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2013-08-15 12:06:39 UTC
Indeed Lol

InvBlueprintTypes
InvTypes (For the product type, the blueprint type, and the material types)
ramTypeRequirements (for the extra materials)
InvTypeMaterials (For the base materials, though you'll need to exclude, to a minimum of zero, anything from the base materials of anything inRamTypeRequirements, marked as recyclable.)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Victoria Sin
Doomheim
#4 - 2013-08-15 12:52:16 UTC
Wonderful. Thank you both very much Pirate.