open All Channels
seplocked EVE Technology Lab
blankseplocked [Help] Wormhole database dump class?
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Miss Bombshell
Posted - 2011.04.14 17:56:00 - [1]
 

Hello,

I have some database dump with the table "mapsolarsystems", is there any possibility to determine class from any of the data columns or the wormhole ID? Such as: regionID, constellationID, solarSystemID or solarSystemName

Which is the best to determine it? I was going to use Jove labs w-space region reference, but wasn't sure if that'd be correct: http://www.jovelabs.com/regions

Thanks

Jercy Fravowitz
School of Applied Knowledge
Posted - 2011.04.14 20:47:00 - [2]
 

mapLocationWormholeClasses

make sure to match by system before constellation before region.

Miss Bombshell
Posted - 2011.04.14 23:43:00 - [3]
 

I don't seem to have that table (if that is a table). Where do I get that database dump?

Miss Bombshell
Posted - 2011.04.15 00:14:00 - [4]
 

Found it.

If anybody is interested... http://wiki.eve-id.net/CCP_Static_Data_Dump

Thanks

Jercy Fravowitz
School of Applied Knowledge
Posted - 2011.04.15 11:12:00 - [5]
 

Originally by: Miss Bombshell
http://wiki.eve-id.net/CCP_Static_Data_Dump

That is actualy outdated.

Why dont you simply take the current database dump from the sticky post at the top of this forum?

And, if i may ask, what datadump were you using first, and where/how did you find it?

Miss Bombshell
Posted - 2011.04.17 21:21:00 - [6]
 

Edited by: Miss Bombshell on 17/04/2011 21:56:24
Eh, I have a lot of trouble trying to import those files. The one I got from there is still pretty new, just an earlier build I guess. I have no clue where I found the older ones, I got them off some mirror a guy had, lost the BMs. Yeah... if I could import that I would, but this mapLocationWormholeClasses table only has 789 systems in it.

Lutz Major
Posted - 2011.04.17 22:06:00 - [7]
 

Originally by: Miss Bombshell
... but this mapLocationWormholeClasses table only has 789 systems in it.
Sounds about right, if I remember correctly.

Miss Bombshell
Posted - 2011.04.17 22:19:00 - [8]
 

Okay so I noticed you posted on the sticky Jercy, so I followed that link. Is this up to date? Still only very few systems with classes specified: http://eve.no-ip.de/inc14/inc14-mysql5-sql-v1/

Lutz Major
Posted - 2011.04.18 07:01:00 - [9]
 

Originally by: Miss Bombshell
Okay so I noticed you posted on the sticky Jercy, so I followed that link. Is this up to date? Still only very few systems with classes specified: http://eve.no-ip.de/inc14/inc14-mysql5-sql-v1/
To answer for Jercy, yes the inc14 is currently the newest dump.

But you are on the wrong track: The mapLocationWormholeClasses table is not a direct relation between solarSystemID and locationID. Hence there must not be 2498 entries for each wormhole.

Papa Yoru
Electric Monk inc
Redrum Fleet
Posted - 2011.04.18 21:08:00 - [10]
 

If you have some familiarity with python, you could try building your own wh data from the cache using reverence (https://github.com/ntt/reverence). I suggest building from SVN as Incursion changed some cache internals which aren't covered by the current binary d/l. The provided examples set you on course for building custom data sets directly from your eve installation.


 

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