open All Channels
seplocked EVE Technology Lab
blankseplocked Ships required Skills from Database dump
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Ideki
Gallente
Posted - 2011.07.22 15:02:00 - [1]
 

Is it possible to extract a ship required skills from the database dump?

Because so far I did not had success try to find that information.

Any pointers would be welcome.Very Happy

Lutz Major
Posted - 2011.07.22 15:43:00 - [2]
 

dgmTypeAttributes

Find the attributeIDs in the dgmAttributeTypes, I think requiredSkill1 to requiredSkill4..5?
Plus the corresponding requiredSkillLevel1..n

Ideki
Gallente
Posted - 2011.07.22 16:13:00 - [3]
 

Thanks, I'll look into that. Very Happy

Desmont McCallock
Posted - 2011.07.22 17:55:00 - [4]
 

Here's a little query I wrote for you. Hope you'll find it useful.
It returns columns [ShipName,ShipType,RequiredSkill,RequiredLevel] for all ships in market.
If you want all ships in DB then remove the line "Ships.published = 1 AND" but this will return also redundant info.


SELECT
Ships.typeName AS ShipName,
Grouping.groupName AS ShipType,
Skills.typeName AS RequiredSkill,
SkillLevel.valueInt AS RequiredLevel

FROM dbo.dgmTypeAttributes AS SkillName

INNER JOIN dbo.invTypes AS Ships ON Ships.typeID = SkillName.typeID

INNER JOIN dbo.invGroups AS Grouping ON Grouping.groupID = Ships.groupID

INNER JOIN dbo.invTypes AS Skills ON Skills.typeID = SkillName.valueInt AND (SkillName.attributeID = 182 OR SkillName.attributeID = 183 OR SkillName.attributeID = 184 OR SkillName.attributeID = 1285 OR SkillName.attributeID = 1289 OR SkillName.attributeID = 1290)

INNER JOIN dbo.dgmTypeAttributes AS SkillLevel ON SkillLevel.typeID = SkillName.typeID AND (SkillLevel.attributeID = 277 OR SkillLevel.attributeID = 278 OR SkillLevel.attributeID = 279 OR SkillLevel.attributeID = 1286 OR SkillLevel.attributeID = 1287 OR SkillLevel.attributeID = 1288)

WHERE
Grouping.categoryID = 6 AND
Ships.published = 1 AND
((SkillName.attributeID = 182 AND SkillLevel.attributeID = 277) OR
(SkillName.attributeID = 183 AND SkillLevel.attributeID = 278) OR
(SkillName.attributeID = 184 AND SkillLevel.attributeID = 279) OR
(SkillName.attributeID = 1285 AND SkillLevel.attributeID = 1286) OR
(SkillName.attributeID = 1289 AND SkillLevel.attributeID = 1287) OR
(SkillName.attributeID = 1290 AND SkillLevel.attributeID = 1288))


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only