| Pages: [1] :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Flavan
Cosmic Cimmerians
   |
Posted - 2010.08.17 05:54:00 -
[1]
I have an idea of something I'd like to do, a resource I'd like to make available on the web.
But to achieve it, I need a list of every star system in New Eden. (Actually, I only need every named (hi-sec) system, but a complete list would be workable too)
Does anyone know how to obtain such a list in a .txt file, or similarly editable format?
Thanks
Flavan
Ardene System
|
darius mclever
|
Posted - 2010.08.17 11:03:00 -
[2]
see the technology lab forum
|
Morfig
Caldari
De Re Metallica
|
Posted - 2010.08.17 13:17:00 -
[3]
Have a look at the static database dump that CCP issue.
If you know databases you should be able to get what you want without trouble.
Official place
http://www.eveonline.com/community/toolkit.asp
Other useful place (not official)
http://wiki.eve-id.net/CCP_Static_Data_Dump
Personally I went with the MYSQL server and the MYSQL community (unofficial) dump because installing MS MYSQL server express was such a big pain (after 4 days still no go) . MySQL server was up and running in 20mins!
I can't remember exactly how I got the Eve database onto the server. I remember it was easy once I found the command.
From there a simple query of the "mapSolarSystems" table should get you what you need.
Something like...
SELECT `solarSystemName`, `security`
FROM `mapsolarsystems`
WHERE `security` >= 0.50
I started from absolute zero understanding of MYSQL and only basic (hardly any) knowledge of databases. In 2 weeks I was running queries and getting good data.
If you're thinking about making an app or an online reference or something, then I suggest you get to know what's in the Database dump. It might end up saving you a bunch of time.
|
|
CCP Adida
C C P
C C P Alliance
|
Posted - 2010.08.17 15:00:00 -
[4]
Moved from features and ideas
Adida
Community Rep
CCP Hf, EVE Online
|
|
Ricky Baby
NibbleTek
RED.OverLord
|
Posted - 2010.08.17 19:03:00 -
[5]
http://smith-net.org.uk/stuff/named_systems.txt
http://smith-net.org.uk/stuff/hisec_only.txt
if you need anything else just poke me.
-------
|
Flavan
Cosmic Cimmerians
|
Posted - 2010.08.17 23:48:00 -
[6]
Edited by: Flavan on 17/08/2010 23:48:36
Thnx Ricky Baby
That hisec list is EXACTLY what I was looking for.
Flavan
Ardene System
|
|
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |