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.
 

Additional Materials in the Database

First post
Author
Previous Topic Next Topic
Sigras
Conglomo
#1 - 2014-05-15 09:07:55 UTC
So, im looking to make a web tool, and I have the database downloaded and imported into SQL.

I was able to read the information but I noticed some weird things in the database. I looked up the build requirements for a random item, the Panther typeID 22440 in the invtypematerials table.

This gives me a list of what the panther reprocesses into, but im looking for a list of build requirements.

Where does the database list that the Panther also requires a Typhoon and RAM starship tech to manufacture? I checked the ramTypeRequirements table and it isnt in there; in fact there is nothing listed for typeID 22440 in that table...

Also how would one go about getting rid of the materials which are not used in manufacturing as the 281,602 that the table lists for the panther is FAR less than the amount of trit in the typhoon and RAM that are missing from the list.
I looked at this web site: http://wiki.eve-id.net/Bill_of_Materials but their solution didnt seem to apply to this situation for the reason stated above.

Thoughts?
Rob Crowley
State War Academy
#2 - 2014-05-15 09:51:39 UTC
Sigras wrote:
Where does the database list that the Panther also requires a Typhoon and RAM starship tech to manufacture? I checked the ramTypeRequirements table and it isnt in there; in fact there is nothing listed for typeID 22440 in that table...
Quoting the website you linked: "the latter is keyed by blueprintTypeID". TypeID 22441 Smile

Quote:
Thoughts?
Apart from the above which I hope answers your questions, I would suggest that maybe it's not the best time to make an industry tool now, when the industry system (and with it the according SDE resources) will change in a couple weeks.
Sigras
Conglomo
#3 - 2014-05-15 11:07:53 UTC
wow, I totally cant believe I missed that... thanks!

Any idea on how to get rid of the materials that arent actually used in manufacturing? Is there some sort of precedent where if you get back less (trit pyerite mex etc) than the required mat is worth then you get rid of it all or something?

Also, im making this tool because of the changes; I figure with all these changes my tool is going to be as feature complete as everyone elses given the new industry changes.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2014-05-15 12:38:25 UTC  |  Edited by: Steve Ronuken
I'm waiting for a new SDE and SiSi to be updated before I work up the changes for Crius.

It'll be, (probably) a little lower on features to start with, but better written Blink with a solid library behind it.


If you still want to write up for the current system:
https://www.fuzzwork.co.uk/2012/10/27/eve-sde-sql-blueprint-details/

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Sigras
Conglomo
#5 - 2014-05-15 18:14:12 UTC
wow, that link is awesome! thx for the info, but im still wondering what the rule is for getting rid of the minerals you get back from reprocessing but arent actually part of manufacturing...

Do you just subtract the build materials of all the sub components from the build materials of the parent component? assuming of course a minimum of zero? If so, do you take off a percentage for the RAM components?

IE a panther returns to me an amount of trit, pye, mex, iso, nocx, etc Do I just subtract the trit pye etc that goes into the typhoon that is required to build it?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2014-05-15 18:21:56 UTC
Sigras wrote:
wow, that link is awesome! thx for the info, but im still wondering what the rule is for getting rid of the minerals you get back from reprocessing but arent actually part of manufacturing...

Do you just subtract the build materials of all the sub components from the build materials of the parent component? assuming of course a minimum of zero? If so, do you take off a percentage for the RAM components?

IE a panther returns to me an amount of trit, pye, mex, iso, nocx, etc Do I just subtract the trit pye etc that goes into the typhoon that is required to build it?



If something is marked as recyclable, you remove its components (to a minimum of 0)

That's what the subquery is doing.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Sigras
Conglomo
#7 - 2014-05-15 18:32:18 UTC
oh awesome thanks! sry some of this SQL is new to me; I cant yet parse a select statement that complicated in my head...