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.
 

Wormhole Properties out of Database?
Author
Previous Topic Next Topic
Chaotic Mind
Republic University
Minmatar Republic
#1 - 2013-12-11 11:16:48 UTC
Hello

just wondering if there's a way to get the informations about a workhole (where it leads to, max mass, etc) from the Databasedump or is it hardcoded?

thanks
Rob Crowley
State War Academy
#2 - 2013-12-11 12:09:18 UTC
The only thing I can tell you is that the different wormhole types are listed in invTypes with a groupID of 988. I couldn't find any attributes linked to those typeIDs though, so maybe they aren't in the DB or I didn't know where to look.
Chaotic Mind
Republic University
Minmatar Republic
#3 - 2013-12-11 12:20:49 UTC
Rob Crowley wrote:
The only thing I can tell you is that the different wormhole types are listed in invTypes with a groupID of 988. I couldn't find any attributes linked to those typeIDs though, so maybe they aren't in the DB or I didn't know where to look.


that's why I ask ;)
Vogue
A Blessed Bean
Pandemic Horde
#4 - 2013-12-11 14:00:36 UTC  |  Edited by: Vogue
It would seem that wormhole systems are unique in having a (solarsystem) security of -0.99.

As https://wiki.eveonline.com/en/wiki/List_of_All_W-Space_Systems states there are 2498 W-Space systems this SQL query returns 2498 rows\systems:

SELECT * FROM mapSolarSystems WHERE security = -0.99

This SQL query returns the same 2498 rows:

SELECT * FROM mapSolarSystems WHERE LEN(solarSystemName) = 7 AND SUBSTRING(solarSystemName,1,1) = 'J' AND SUBSTRING(solarSystemName,2,6) LIKE '%[0-9]' AND security = -0.99

Also:

SELECT * FROM mapDenormalize WHERE security = -0.99
-- AND groupID = 5 -- comment this line to include Wormhole system Moons