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 systemId
Author
Previous Topic Next Topic
Yuko Ostus
Republic Military School
Minmatar Republic
#1 - 2011-10-22 00:56:58 UTC
Hi,

Ive been playing around trying to get jump and kill stats for wormhole systems through the api, but Ive run into a hitch I cant seem to find the corresponding solarSystemId given the wormhole name.

This must have been done before as sites like dotlan clearly have a mapping for this, any pointers?

In advance thanks
Vessper
Dark Mason Society
#2 - 2011-10-22 10:46:34 UTC
If you check the Eve static data dump, you can use the mapSolarSystems table to get the ID, e.g.

SELECT solarSystemID FROM mapSolarSystems WHERE solarSystemName='J100409';
Trenker
#3 - 2011-10-23 15:21:55 UTC
Wormhole systems belong to the "Unknown" regions which have an ID above 11000000

So to get all wormhole systems simply do a
SELECT solarSystemID, solarSystemName FROM `mapSolarSystems` WHERE `regionID` > 11000000
Yuko Ostus
Republic Military School
Minmatar Republic
#4 - 2011-10-23 16:54:40 UTC
It worked perfectly now, but for some reason I did the exact same thing right before I posted this. Strange, thanks for the replies!