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.
 

Ship skills from Data dump.

First post
Author
Previous Topic Next Topic
Louis Vitton
Viziam
Amarr Empire
#1 - 2012-01-17 04:52:32 UTC
Hey guys,

I am looking for all the ship skills from the data dump.This following query shows me the required

As shown below according to the eve item database the avatar has more required skills that the 3 that the query returns i was wondering if there was a way to get them all and what level you require them at to fly it.
Query:
Quote:
SELECT
Ships.typeName AS ShipName,
Grouping.groupName AS ShipType,
Skills.typeName AS RequiredSkill,
SkillLevel.valueInt AS RequiredLevel

FROM dgmtypeattributes AS SkillName

INNER JOIN invtypes AS Ships ON Ships.typeID = SkillName.typeID

INNER JOIN invgroups AS Grouping ON Grouping.groupID = Ships.groupID

INNER JOIN 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 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))

Output for avatar:
Quote:


[ShipName] => Avatar
[ShipType] => Titan
[RequiredSkill] => Capital Ships
[RequiredLevel] => 5

[ShipName] => Avatar
[ShipType] => Titan
[RequiredSkill] => Amarr Titan
[RequiredLevel] => 1

[ShipName] => Avatar
[ShipType] => Titan
[RequiredSkill] => Jump Drive Operation
[RequiredLevel] => 1



Quote:
The avatar has the following skills that are required to fly it.
Required skills

Primary Skill required
Capital Ships Capital Ships V
Advanced Spaceship CommandAdvanced Spaceship Command V
Spaceship CommandSpaceship Command V

Secondary Skill required
Amarr Titan Amarr Titan I
Capital ShipsCapital Ships V
Advanced Spaceship CommandAdvanced Spaceship Command V
Spaceship CommandSpaceship Command V
Amarr BattleshipAmarr Battleship V
Spaceship CommandSpaceship Command IV
Amarr CruiserAmarr Cruiser IV
Spaceship CommandSpaceship Command III
Amarr FrigateAmarr Frigate IV
Spaceship CommandSpaceship Command I
LeadershipLeadership V

Tertiary Skill required
Jump Drive Operation Jump Drive Operation I
NavigationNavigation V
Warp Drive OperationWarp Drive Operation V
NavigationNavigation I
ScienceScience V


Cheers Louis,
Also this might not be possible i am just checking.
Ruziel
Twilight Military Industrial Complex
#2 - 2012-01-17 07:30:13 UTC
Correct... the only skills that are needed for the ship are the one the query returns.

The "missing" skills are all the prerequisite skills and levels needed for the required skills.

There's no easy way to get those out of the database without looping or recursion, so you're either have to do that with you programming language of choice that can connect to your database, or used a procedure.
Louis Vitton
Viziam
Amarr Empire
#3 - 2012-01-17 08:14:59 UTC
Ruziel wrote:
Correct... the only skills that are needed for the ship are the one the query returns.

The "missing" skills are all the prerequisite skills and levels needed for the required skills.

There's no easy way to get those out of the database without looping or recursion, so you're either have to do that with you programming language of choice that can connect to your database, or used a procedure.


Thank you for your reply, with php what might the easiest way be to do this is you know?
CCP Prism X
C C P
C C P Alliance
#4 - 2012-01-17 08:57:53 UTC  |  Edited by: CCP Prism X
I got bored, here's some snazzy TSQL recursion which I believe should work for skills of skills.

Pastebin link because forums do not support formatting and unformatted code angers me.

CCP Prism X

Programmer on Team Gridlock & Expert Ranter
Louis Vitton
Viziam
Amarr Empire
#5 - 2012-01-17 13:42:24 UTC
Thank you Prism X, you Sir are a good man :) I shall have a good look when I wake up, Thank you again!
dan Rotsuda
OTMOPO3OK Corporation
U N K N O W N
#6 - 2012-03-06 09:35:16 UTC
Hello! How can i create a data dump! what instrument should i use for it!
Louis Vitton
Viziam
Amarr Empire
#7 - 2012-03-11 09:59:05 UTC
dan Rotsuda wrote:
Hello! How can i create a data dump! what instrument should i use for it!

Do you just want it for the ships and skills required for them? Cause if it is I can upload a sql version that i made from CCP prismx's sql query
Desmont McCallock
#8 - 2012-03-11 10:52:37 UTC  |  Edited by: Desmont McCallock
NVM, failed on reading the entire thread.