| Pages: [1] :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
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]
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.
|
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
Gallente
The Graduates
Morsus Mihi
|
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.
+++ Reality Error 404 - Reboot Cosmos +++ |
|
|
|
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |