open All Channels
seplocked EVE Technology Lab
blankseplocked Get a list of current outposts--And other API inquiries
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Resender
Posted - 2011.09.01 10:44:00 - [1]
 

Hello all,
As a hobby project I'm developping a database in SQL Server 2008R2.
The idea behind this to be able to keep track off 'sellable' inventory items and their value, with a small prediction tool in the future I hope.
ATM I'm using the EvE Asset Manager to get my inventory and xml files off the EvE Market site to unload data into the database.
I've recently moved from a single point location to mult-system location, I've used the static dump to fill in all the data for locations(Regions,Constellations,Systems,Stations) Hard to do since I was already using my own ID's for some.

So now I want to switch from a multi-system to a method where I can get the data stored for each individual station, NPC stations have been imported, now I'm looking for a way to get the outposts in the database.

In the end I would also like to have my application get the asset data automatically.
I'm currently using SQL Server 2008 R2 and its corresponding Visual Studio.

Thank you for reading

Lutz Major
Posted - 2011.09.01 15:15:00 - [2]
 


MillerUk
Caldari
Knights Of Divinity
Unforgiving.
Posted - 2011.09.01 22:00:00 - [3]
 

Something along the lines of what i use PHP based

<?
include ("../db.php");

$sql="truncate table conStations";
echo $sql."<br>";
$qry = new DBQuery();
$qry->execute($sql);


$uid="";//your api userid
$api="";//yourapikey (limited)
$req = "userid=".$uid;
$req .= "&apikey=".$api;
$req .= "&version=2";
$url="http://api.eve-online.com/eve/ConquerableStationList.xml.aspx";

$xml = simplexml_load_file($url);

$pos=0;
foreach($xml->result->rowset->children() as $a) {

$sql="insert into conStations values( '','".addslashes($a["stationName"])."','".$a["stationID"]."','".$a["solarSystemID"]."','".addslashes($a["corporationName"])."')";
echo $sql."<br>";
$qry = new DBQuery();
$qry->execute($sql);

}

?>


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only