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.
 

locationID= moonID= question

First post
Author
Samuel Sachs
#1 - 2015-09-02 20:53:49 UTC  |  Edited by: Samuel Sachs
locationID="xxx" moonID="xxx"

Where can i find the information about datas like this ???

Someone was talking about mapDenormalize but i have no clue how i can read the informations in the database, is there a list what i can use online just type in the numbers and find what i need or do i need to study for this? Big smile

SheetMon_V2 a gdocs spreadsheet what pulls lots of stuff, feel free to make a copy :-)

Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2015-09-02 21:22:02 UTC
Samuel Sachs
#3 - 2015-09-02 21:42:01 UTC
Thank you, hard to find informations but with your help i was finally able to sort my minds and got it Lol

SheetMon_V2 a gdocs spreadsheet what pulls lots of stuff, feel free to make a copy :-)

Samuel Sachs
#4 - 2015-09-06 20:06:01 UTC
How can i pull data from silos on a pos and the amount of goo inside via api ?

Or is it the same as the thing with the item id from a tower and then get the location to make it running? Because then i miss the item id from silos maybe and i have no idea where i can find them.

SheetMon_V2 a gdocs spreadsheet what pulls lots of stuff, feel free to make a copy :-)

Samuel Sachs
#5 - 2015-09-07 21:13:09 UTC
=ImportXML("https://api.eveonline.com/corp/AssetList.xml.aspx?vcode=xxx&keyID=xxx", "sum(//row[@locationid=xxx]//row[@typeid=16650]/@quantity)")

This works so far but i still have a problem, how can i customize it to give me the amount of goo on a specific moon or moonID, can not find anything to put this together.

SheetMon_V2 a gdocs spreadsheet what pulls lots of stuff, feel free to make a copy :-)

Kali Izia
GoomWaffe
#6 - 2015-09-08 04:48:14 UTC
There's nothing that directly links them. The way that most tools do it is by calling Locations on your assets and calculating the distances from their xyz, from there you can tell if it's within range of a tower.