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.
 

[SDE] Reprocessing Skills and their affecting Items?
Author
Previous Topic Next Topic
Expert173
GENFA Alpha Squad
#1 - 2014-06-24 12:06:22 UTC
Help,

i have a question regarding the SDE:

Where in the SDE can i find the association between the Reprocessing Skills and their affecting Items?

Arkonor Processing (12180) is affecting Arkonor(22), Crimson Arkonor(17425), Prime Arkonor(17426), Compressed Arkonor/Crimson/Prime (28367,28385,28387).

Is it somewhere in the SDE, or do we need to search them all manually and hardcode the typeID's?

mfg Expert173
Aineko Macx
#2 - 2014-06-25 06:38:26 UTC
There ya go:
Quote:
SELECT ore.typeID, ore.typeName, skill.typeID, skill.typeName
FROM dgmTypeAttributes as dta
JOIN invTypes as ore ON dta.typeID = ore.typeID
JOIN invTypes as skill ON dta.valueInt = skill.typeID
WHERE attributeID = 790 # reprocessingSkillType

iveeCore 3.0: The PHP engine for industrial activities and CREST library
Expert173
GENFA Alpha Squad
#3 - 2014-06-25 07:28:25 UTC
Awesome,

thanks.

I assumed the dgmTypeAttributes is only holding Ship/Module Stats.

Small aditional Question:
Is everything else covered by the Scapmetal Processing Skill, or is there another 'hidden' attributeID for them, and some Items left which are not Reprocessable?

mfg Expert173
Aineko Macx
#4 - 2014-06-25 09:40:40 UTC
Yes, scrap metal processing should cover everything else. AFAIK as long as the item has materials in the invTypeMaterials table for it, it is reprocessable.

iveeCore 3.0: The PHP engine for industrial activities and CREST library