Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Sigras
Conglomo
764
|
Posted - 2014.05.15 09:07:00 -
[1] - Quote
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
298
|
Posted - 2014.05.15 09:51:00 -
[2] - Quote
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
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
764
|
Posted - 2014.05.15 11:07:00 -
[3] - Quote
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
3258
|
Posted - 2014.05.15 12:38:00 -
[4] - Quote
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 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 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
Sigras
Conglomo
764
|
Posted - 2014.05.15 18:14:00 -
[5] - Quote
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
3263
|
Posted - 2014.05.15 18:21:00 -
[6] - Quote
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 9! http://fuzzwork.enterprises/ Twitter: @fuzzysteve on Twitter |
Sigras
Conglomo
764
|
Posted - 2014.05.15 18:32:00 -
[7] - Quote
oh awesome thanks! sry some of this SQL is new to me; I cant yet parse a select statement that complicated in my head... |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |