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.
 

SDD - Where to find requirements per item?
Author
Previous Topic Next Topic
La'Lathlien
The Scope
Gallente Federation
#1 - 2013-02-27 16:08:59 UTC
Hello World.

I have just started working with the API & SDD system from EvE and I am through a lot of explanations. (EFT, EvEMon does not do the job)

So far - I got all I need for my little project -beside the requirements per item. (ship, drones, ship equipment, etc)
Can anybody help me to find out what data (or in which file of the SDD) I find this information?

Example would be - I want to have information in my db what skills are required for Warden II.
I have the IDs for the skills and the items - but I do not have yet a table with the requirements....

Hope this is not a very obvious link in the menu just left side from my post.... '-_-
Sable Blitzmann
24th Imperial Crusade
Amarr Empire
#2 - 2013-02-27 16:46:59 UTC  |  Edited by: Sable Blitzmann
Here's a MySQL stroed function I made a long time ago. Might need to be updated if the database has changed at all. http://wiki.eve-id.net/Prerequisite_Skilltree It gives a sample output at the bottom there

However, IIRC it's farily slow, and I honestly can't remember how exactly it works as it's been a while since I looked at it. required skills for an item/ship was a pain in the ass due to various flags involved. if you want to just get the skills required to use a particular item, look here: https://forums.eveonline.com/default.aspx?g=posts&t=58558

if you want to get the prereq tree, it would be much easier and faster to look through it with your programming language of choice instead of using a procedure.

EDIT: a more generalized answer: `dgmTypeAttributes` has the info you're looking for in the form of attribute IDs:

To get the type IDs of the prereq skills:
182 requiredSkill1
183 requiredSkill2
184 requiredSkill3
1285 requiredSkill4
1289 requiredSkill5
1290 requiredSkill6

To get the level the skill needs to be trained to:
277 requiredSkill1Level
278 requiredSkill2Level
279 requiredSkill3Level
1286 requiredSkill4Level
1287 requiredSkill5Level
1288 requiredSkill6Level

Like I said, this will only get you the skills required by a particular item. It will NOT get you the whole tree (the prereqs of the prereqs). To do that, you'll have to recurse either in the database or via your programming language
La'Lathlien
The Scope
Gallente Federation
#3 - 2013-02-27 18:00:56 UTC
Thanks a lot for the prompt reply!

As it is only for a couple of items, it should be feasible.

Thank you so much :-)