Ship Stats Viewer by ID

From EVEDev

Jump to: navigation, search

Shows statistics for Megathron (typeID 641) linked with field names.

SELECT `entity`.*, `dmgAttrib`.`attributeName`, 
        `dmgAttrib`.`displayName`
FROM `eve-db`.`dgmtypeattributes` as `entity`
INNER JOIN `eve-db`.`dgmattributetypes` as `dmgAttrib` 
    ON `dmgAttrib`.`attributeID` = `entity`.`attributeID`
WHERE `typeID` = '641';

Note: Almost all attributes have a attribute name, only a few have a external display name. Some specifics are missing from this query such as image name, image directory, and such :)

Personal tools