Pages: 1 :: [one page] |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Worgorg Ashwielder
A.W.M Ka-Tet
|
Posted - 2007.12.23 15:39:00 -
[1]
can anyone help me with this, I've downloaded the corp asset list to a database via the API and have found the offices (typeID=27) but can't find the location of the offices from the locationID
for example one of our offices has locationID of 67000083, searched all tables in the Trinity 1.0 static data export and can't find anything..
anyone know what these locationIDs refer to?
<3 the new eveAPI v2
|
Zu Guty
|
Posted - 2007.12.23 16:47:00 -
[2]
Got reported, but since garth left, dont think any "quick fixes" are going to happen. Guess we'll have to wait some time before being able to use corp assets.
|
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.23 18:52:00 -
[3]
you'll have to make that table yourself, officesIDs wont change unless you unrent/rent
Corporation Management Improvement |
Worgorg Ashwielder
A.W.M Ka-Tet
|
Posted - 2007.12.24 00:32:00 -
[4]
bah never mind :(
thanks for the info folks, will keep my eyes peeled for a solution appearing in the future
|
Rhispa
Merch Industrial GoonSwarm
|
Posted - 2007.12.24 09:43:00 -
[5]
LocationID can be one of the following:
Solarsystem Station Outpost
If the locationID starts with a 3, it's a solarsystem. You can find these in the mapsolarsystems table.
If it starts with a 6 it's either a station or an outpost. The stations are in the staStations table. If you can't find it in here it's a player made outpost which you can find in this api call: http://api.eve-online.com//eve/ConquerableStationList.xml.aspx
|
Worgorg Ashwielder
A.W.M Ka-Tet
|
Posted - 2007.12.24 15:49:00 -
[6]
60000001-60015053 seem to be normal stations 61xxxxxx seem to be player planted station 66xxxxxx and 67xxxxxx don't seem to refer to anything we have access too, including the outpost list and the data export
|
Fubar
Eagle Eye Inc.
|
Posted - 2007.12.24 17:13:00 -
[7]
I think you can convert offices to stations by subtracting 6000001.
Worgorg Ashwielder the office locationID you gave 67000083 - 6000001 = 61000082
61000082 is "<row stationID="61000082" stationName="EG Prime" stationTypeID="21646" solarSystemID="30000798" corporationID="200688913" corporationName="REUNI0N" />" from http://api.eve-online.com/eve/ConquerableStationList.xml.aspx
|
Worgorg Ashwielder
A.W.M Ka-Tet
|
Posted - 2007.12.25 00:30:00 -
[8]
Originally by: Fubar I think you can convert offices to stations by subtracting 6000001.
Worgorg Ashwielder the office locationID you gave 67000083 - 6000001 = 61000082
61000082 is "<row stationID="61000082" stationName="EG Prime" stationTypeID="21646" solarSystemID="30000798" corporationID="200688913" corporationName="REUNI0N" />" from http://api.eve-online.com/eve/ConquerableStationList.xml.aspx
Fubar is a genious, didn't think of anything so abstract, works perfectly for all NPC stations and old conquerable stations, so any locationIDs starting 66 (stationID 60)
doesn't work for outposts, locationID starting 67 (stationID 61) you need to subtract 6000000 for some reason
sooo... to convert locationIDs starting 66 to stationIDs from staStations subtract 6000001 from the locationID to convert locationIDs starting 67 to stationIDs from the eveAPI ConquerableStationList subtract 6000000 from the locationID
thanks for the help guys, my brain was starting to hurt when I first looked at this
|
Salvis Tallan
Gallente The Shadow Order SMASH Alliance
|
Posted - 2007.12.25 02:10:00 -
[9]
Fubar: you are awesome! ------
|
|
|
|
Pages: 1 :: [one page] |