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.
 

How to SELECT skill dependencies?
Author
Previous Topic Next Topic
fenistil
Federal Navy Academy
Gallente Federation
#1 - 2012-11-24 11:23:33 UTC
Hello!

I found a small SQL snippet that helps me list all the skills, however how can I check what skill requires what skill?

Quote:
SELECT groups.groupID,
groups.groupName AS groupName,
invTypes.typeName AS skillName,
invTypes.description,
invTypes.typeID
FROM ( SELECT * FROM invGroups WHERE categoryID = 16 AND published = 1 ) AS groups
INNER JOIN invTypes ON ( invTypes.groupID = groups.groupID AND invTypes.published = 1 )
ORDER BY groupName;


Thanks

.
ItsmeHcK1
Immortalis Inc.
Shadow Cartel
#2 - 2012-11-24 11:26:36 UTC
This is the one I use:
Quote:
SELECT [invTypes].[typeID] AS invTypeID,
[dgmTypeAttributes].[attributeID] AS attribID,
ISNULL([dgmTypeAttributes].[valueFloat], [dgmTypeAttributes].[valueInt]) AS attribValue
FROM [dgmTypeAttributes]
INNER JOIN [invTypes] ON [dgmTypeAttributes].[typeID] = [invTypes].[typeID]
INNER JOIN [dgmAttributeTypes] ON [dgmAttributeTypes].[attributeID] = [dgmTypeAttributes].[attributeID]
WHERE [dgmTypeAttributes].[attributeID] IN (182, 183, 184, 277, 278, 279)
fenistil
Federal Navy Academy
Gallente Federation
#3 - 2012-11-24 16:48:03 UTC  |  Edited by: fenistil
thanks..

Looks ugly though :) Is it mssql or whut?

.
Desmont McCallock
#4 - 2012-11-24 19:05:37 UTC
Does this suffice?
ItsmeHcK1
Immortalis Inc.
Shadow Cartel
#5 - 2012-11-24 19:45:16 UTC
fenistil wrote:
Is it mssql or whut?

Yup... I was forced to use it on account of CCP being baddies and only exporting in the MSSQL format.
fenistil
Federal Navy Academy
Gallente Federation
#6 - 2012-11-24 20:23:48 UTC
ItsmeHcK1 wrote:
fenistil wrote:
Is it mssql or whut?

Yup... I was forced to use it on account of CCP being baddies and only exporting in the MSSQL format.


There are other SQL ports.. eve-id.com is the website I believe where you can download it for mysql for sure but I think there is sqlite and pgsql versions too

.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#7 - 2012-11-24 20:56:04 UTC
http://www.fuzzwork.co.uk/dump/ for mysql and sqllite conversions of the exports.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter