Loci and Wormhole Name to Class Conversion

From EVEDev

To get a full list of systems and associated classes (highsec included):

 
SELECT solarSystemName AS name, wormholeClassID AS class 
FROM mapSolarSystems mss 
LEFT JOIN mapWormholeClassLocations mwhcl ON mss.regionID=mwhcl.locationID
 

To get a full list of wormholes and associated _target_ classes:

 
SELECT SUBSTRING(typeName,10) AS name,valueInt AS class 
FROM invTypes it 
LEFT JOIN dgmTypeAttributes dta USING(typeID) 
WHERE it.typeName REGEXP '^Wormhole [A-Z]{1}[0-9]{3}$' AND dta.attributeID=1381 
 

To get an even more complete list

 
SELECT
	wh.typeName AS name,
	whClass.valueInt AS wormholeType,
	whStableTime.valueInt AS maxStableTime,
	whStableMass.valueInt AS maxStableMass,
	whMassRegen.valueInt AS massRegeneration,
	whJumpMass.valueInt AS maxJumpMass
FROM invTypes AS wh 
	LEFT JOIN dgmTypeAttributes whClass USING(typeID)
	LEFT JOIN dgmTypeAttributes whStableTime USING(typeID) 
	LEFT JOIN dgmTypeAttributes whStableMass USING(typeID) 
	LEFT JOIN dgmTypeAttributes whMassRegen USING(typeID) 
	LEFT JOIN dgmTypeAttributes whJumpMass USING(typeID) 
WHERE wh.typeName REGEXP '^Wormhole [A-Z]{1}[0-9]{3}$'
	AND whClass.attributeID = 1381 
	AND whStableTime.attributeID = 1382
	AND whStableMass.attributeID = 1383
	AND whMassRegen.attributeID = 1384
	AND whJumpMass.attributeID = 1385
 

These methods require a dump with mapWormholeClassLocations (eg http://zofu.no-ip.de/dbz84244) to work.