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.
 

Sub System combinations

First post
Author
Previous Topic Next Topic
Avrora Primogenitor
Pator Tech School
Minmatar Republic
#1 - 2016-04-30 19:27:54 UTC
Dear reader,

I am looking to get the slots unlocked by Sub System combinations from the SDE (If possible). Could anyone point me into the right direction? For example which tables and/or columns to combine to get the slot type and amount unlocked.

Kind regards,
Avrora Primogentior
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2016-04-30 22:46:08 UTC
You want to look at dgmTypeAttributes.

For slots: 1374, 1375, 1376

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Avrora Primogenitor
Pator Tech School
Minmatar Republic
#3 - 2016-05-01 08:39:11 UTC  |  Edited by: Avrora Primogenitor
Thanks Steve appreciate the directions. I will just leave this here for future references.

SELECT it.typeName, dat.displayName, dta.valueFloat FROM `invTypes` as it
INNER JOIN `dgmTypeAttributes` as dta on dta.typeID = it.typeID
INNER JOIN `dgmAttributeTypes` as dat on dat.attributeID = dta.attributeID
WHERE dta.attributeID in (1374, 1375, 1376)

Or

SELECT it.typeName,
(SELECT valueFloat from `dgmTypeAttributes` where attributeID = 1374 and typeID = it.typeId) as highSlotMod,
(SELECT valueFloat from `dgmTypeAttributes` where attributeID = 1375 and typeID = it.typeId) as midSlotMod,
(SELECT valueFloat from `dgmTypeAttributes` where attributeID = 1376 and typeID = it.typeId) as lowSlotMod
FROM `invTypes` as it
INNER JOIN `dgmTypeAttributes` as dta on dta.typeID = it.typeID
WHERE dta.attributeID in (1374, 1375, 1376)
GROUP BY it.typeID