| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Glucuronolactone
   |
Posted - 2009.03.24 21:22:00 -
[1]
Background: I'm working on an EVE-compatible site for my corporation, and want to be able to link to the systems we have offices in.
I've been on Google for a while now, looking for someone who has System IDs. Is there anywhere (a website, or a program) to get System IDs by searching for the name, besides installing the database backup? Someone out there must have done something like that already. Is in the publicly available database backup(I'm getting erorrs installing the backup, so I'd have no clue)?
And on that note, hey, CCP, why aren't IDs (for systems AND items) in the wiki?
|
Shionoya Risa
The Xenodus Initiative.
Overclockers Podpilot Services
|
Posted - 2009.03.24 21:55:00 -
[2]
Best I can do for you is a dump of the systems table for you to ctrl+f you way through in xml format. Linkage.
Someone else will have something better though, I'm sure.
-----
|
Dark Monarch
Minmatar
Hunter Killer Club
|
Posted - 2009.03.24 22:00:00 -
[3]
Edited by: Dark Monarch on 24/03/2009 22:01:56
Well looks like we're in roughly the same boat, if I get the solution I'm hoping for from my post (or even a solution that is usable) I'll let you know. My thread started today and personally I feel it's rude to link your own thread unless it directly answers the current question.
Shionoya Risa - can this XML be pulled directly from the API?
|
Shionoya Risa
The Xenodus Initiative.
Overclockers Podpilot Services
|
Posted - 2009.03.24 22:12:00 -
[4]
 Originally by: Dark Monarch
Shionoya Risa - can this XML be pulled directly from the API?
You can pull Sov data from the api, and it should also include all the systems, good call.  Linkage (Big-ish file)
-----
|
Silwar Naiilo
Crimson Logistical
|
Posted - 2009.03.24 23:21:00 -
[5]
Edited by: Silwar Naiilo on 24/03/2009 23:22:07
Thanks! (At the top, that was me... accidentally left a character I was messing with selected, and apparently I can't edit the character I was typing with).
I'll check out the file. Maybe if I can get the database working on my system, I'll provide some kind of user interface into it; I'm open to anyone who wants to help. I'll either do it in PHP or C#.NET, depending on if anyone's interested / what the majority prefers. Seems rediculously hard to find this kind of information, when there's so much data readily available. Let's fix this 
|
Catari Taga
Centre Of Attention
Rough Necks
|
Posted - 2009.03.25 01:23:00 -
[6]
Originally by: Silwar Naiilo
Seems rediculously hard to find this kind of information, when there's so much data readily available. Let's fix this
If you don't want to mess with the database you could always just link the system you are looking for in chat and then right click and copy, that'll give you the link.
|
Dark Monarch
Minmatar
Hunter Killer Club
|
Posted - 2009.03.25 03:07:00 -
[7]
Originally by: Silwar Naiilo
... Maybe if I can get the database working on my system, I'll provide some kind of user interface into it; I'm open to anyone who wants to help. I'll either do it in PHP or C#.NET, depending on if anyone's interested / what the majority prefers. Seems rediculously hard to find this kind of information, when there's so much data readily available. Let's fix this
Well... perhaps we should talk, I'm pretty good with PHP.
|
Immersive
Immersive Technology Solutions
|
Posted - 2009.03.25 11:31:00 -
[8]
[Eve-Dev] Name to ID API
Handles Character, Corporation, and Alliance names.
Also handles most static data.
---
New to the API? GrabRaw XML
It's coming...
|
Silwar Naiilo
Crimson Logistical
|
Posted - 2009.03.25 13:39:00 -
[9]
Edited by: Silwar Naiilo on 25/03/2009 13:40:15
Originally by: Catari Taga
Originally by: Silwar Naiilo
Seems rediculously hard to find this kind of information, when there's so much data readily available. Let's fix this
If you don't want to mess with the database you could always just link the system you are looking for in chat and then right click and copy, that'll give you the link.
Problem with that is, though, that I always have to have Eve running on the machine I'm working on, and then I have to copy the system ID over; I shouldn't have to have Eve up to develop.
And thanks, Immersive; that'll help with some of the other stuff I've been looking for. Now I just have to track down items.
|
Salizar Amolkshue
|
Posted - 2009.03.25 14:03:00 -
[10]
I have a C# class that reads the entire SolarSystems table into memory from an XML version of the table. It stores it into a key/value pair collection keyed on the ID of the system, but it wouldn't be hard to modify it to key it by system name instead. Let me know if you want the classes.
-Sal
|
Silwar Naiilo
Crimson Logistical
|
Posted - 2009.03.25 14:56:00 -
[11]
Originally by: Salizar Amolkshue
I have a C# class that reads the entire SolarSystems table into memory from an XML version of the table. It stores it into a key/value pair collection keyed on the ID of the system, but it wouldn't be hard to modify it to key it by system name instead. Let me know if you want the classes.
-Sal
That'd be cool, I'd definitely like to take a look at it. I haven't started looking at the APIs available yet, so I don't know what's already out there; but I imagine that if there isn't one already, I'll have to go through and map all of the tables out to classes. I think I will go with .NET, and use either nHibernate for ORM or maybe LINQ.
I'll shoot you an Evemail tonight with my email, unless you'd be ok with uploading a zip.
|
Salizar Amolkshue
|
Posted - 2009.03.25 15:09:00 -
[12]
Originally by: Silwar Naiilo
That'd be cool, I'd definitely like to take a look at it. I haven't started looking at the APIs available yet, so I don't know what's already out there; but I imagine that if there isn't one already, I'll have to go through and map all of the tables out to classes. I think I will go with .NET, and use either nHibernate for ORM or maybe LINQ.
There are a few API libraries available for .NET that wrap the actual Eve API, but I don't know of any that wrap the static data dump, which is where this data comes from. If someone has one, I'd be interested in that too.
I highly recommend LLBLGen Pro for an ORM mapper. I've used it extensively in the past and it's really powerful, probably way more then you need. But if you're going to generate a datalayer anyway... It works best off of a real database, which is why my classes don't use it though.
And I just wrote my own data layer to read the 10 tables I needed. Why? Because I'm a geek probably. 
Originally by: Silwar Naiilo
I'll shoot you an Evemail tonight with my email, unless you'd be ok with uploading a zip.
No problem with uploading a zip, just have no place to put it. The app that I'm using the classes in is planned to be open source, but I haven't tried putting it into SourceForge yet. Hopefully soon... In the meantime, I'd be happy to email it to you.
|
Amida Ta
German Mining and Manufacture Corp.
|
Posted - 2009.03.25 16:39:00 -
[13]
Edited by: Amida Ta on 25/03/2009 16:39:18
Originally by: Salizar Amolkshue
There are a few API libraries available for .NET that wrap the actual Eve API, but I don't know of any that wrap the static data dump, which is where this data comes from. If someone has one, I'd be interested in that too.
EveAI.Live has all this (Static and Dynamic data). In fact it will even automatically match that up as object references, so you will never ever again have to think about an "ID" at all.
_________________________
EveAI.Live - The EVE-Online API/class library for .Net, C# and VB.Net |
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |