APIv2 Corp AssetList XML

From EVEDev

Jump to: navigation, search

/corp/AssetList.xml.aspx

[edit] officeID to stationID conversion

To convert locationIDs greater than or equal to 66000000 and less than 67000000 to stationIDs from staStations subtract 6000001 from the locationID. To convert locationIDs greater than or equal to 67000000 and less than 68000000 to stationIDs from ConquerableStationList subtract 6000000 from the locationID. More Info can be found at this thread

[edit] SQL 

 
SELECT case
  when a.locationid BETWEEN 66000000 AND 66015131 then
    (SELECT s.stationName FROM staStations AS s
      WHERE s.stationID=a.locationid-6000001)
  when a.locationid BETWEEN 66015132 AND 67999999 then
    (SELECT c.stationname FROM ConquerableStationList AS c
      WHERE c.stationid=a.locationid-6000000)
  else (SELECT m.itemName FROM mapDenormalize AS m
    WHERE m.itemID=a.locationid) end
AS location
FROM assetlist AS a WHERE a.locationid=66009170;
 

This works in MySQL 5.0 for me anyway.


[edit] Ideas for usage

Please see the discussion for some ideas for using this info in your corp/alliance.

Retrieved from "http://wiki.eve-id.net/APIv2_Corp_AssetList_XML"
Personal tools