| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
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]
Did you mean something like this: http://api.eveonline.com/eve/ConquerableStationList.xml.aspx?
|
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);
}
?>
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |