These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

Eve MSSQL Market Data - stationID & typeID

First post
Author
Previous Topic Next Topic
Chloey Armstrong
University of Caille
Gallente Federation
#1 - 2011-09-26 08:24:43 UTC
I just imported the Eve Market Data MSSQL Dump (http://www.eveonline.com/devblog.asp?a=blog&nbid=2357)

Anyone know if there are additional dumps for Station and Type information?
CCP Stillman
C C P
C C P Alliance
#2 - 2011-09-26 14:33:52 UTC
Chloey Armstrong wrote:
I just imported the Eve Market Data MSSQL Dump (http://www.eveonline.com/devblog.asp?a=blog&nbid=2357)

Anyone know if there are additional dumps for Station and Type information?

Just to clarify a bit to avoid any confusion:

In the SQL dump, the column is called stationID. This is a typo I made. It's in fact the regionID.

You can cross-reference the regionID and typeID to the Static Data Dump, which can be found here: https://forums.eveonline.com/default.aspx?g=posts&t=6376&find=unread

Just a random dude in Team Security.
malaire
#3 - 2011-09-26 15:02:30 UTC
For TypeIDs, download
http://zofu.no-ip.de/inca10/inca10-mysql5-sql-v1/inca10-invTypes-mysql5-v1.sql.bz2
and for RegionIDs:
http://zofu.no-ip.de/inca10/inca10-mysql5-sql-v1/inca10-mapRegions-mysql5-v1.sql.bz2

Both are in SQL format, which is quite simple to parse if you just look at the datalines and ignore extra code at beginning/end.

(copy-pasted from my original message)

New to EVE? Don't forget to read: The Manual * The Wiki * The Career Options * and everything else
Callean Drevus
Perkone
Caldari State
#4 - 2011-09-26 19:15:48 UTC
CCP Stillman wrote:
Just to clarify a bit to avoid any confusion:

In the SQL dump, the column is called stationID. This is a typo I made. It's in fact the regionID.


Would it not be wise to redump without the typo? Or does that constitute a days work? I know my database takes some time to dump all region history, but it'll happily continue doing other things while doing it, and I happily continue doing other things while it's dumping, so it isn't much of a problem.

Developer/Creator of EVE Marketeer
Chloey Armstrong
University of Caille
Gallente Federation
#5 - 2011-09-27 08:32:36 UTC
CCP Stillman wrote:
Chloey Armstrong wrote:
I just imported the Eve Market Data MSSQL Dump (http://www.eveonline.com/devblog.asp?a=blog&nbid=2357)

Anyone know if there are additional dumps for Station and Type information?

Just to clarify a bit to avoid any confusion:

In the SQL dump, the column is called stationID. This is a typo I made. It's in fact the regionID.

You can cross-reference the regionID and typeID to the Static Data Dump, which can be found here: https://forums.eveonline.com/default.aspx?g=posts&t=6376&find=unread


Thanks!