Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Datis Komis
|
Posted - 2010.08.03 08:55:00 -
[1]
Hi all,
I am (again) more or less new to eve. I didn't play for at least 3 years and just reactivated my account. The last time I did play I programmed some tools for myself. To do so again I downloaded the db.sql file(s) and screened through it.
Atm I am interested in getting information about ore in different systems. I found the description, category name of ore etc in the db and I found the asteroid-belds in mapSolarSystems. But how do I get from ateroid belt to type of asteroids?
I remember that this information was supported by eve-online some years ago but I can't find it in the new db. Or is this info not shared anymore?
Can anyone help?
Thnx, Uggeddie
|
darius mclever
|
Posted - 2010.08.03 09:34:00 -
[2]
you want the technology lab forum.
|
|
CCP Navigator
C C P C C P Alliance
|
Posted - 2010.08.03 09:41:00 -
[3]
Moved from Features & Ideas.
Navigator Senior Community Representative CCP Hf, EVE Online
|
|
Datis Komis
|
Posted - 2010.08.03 10:03:00 -
[4]
Edited by: Datis Komis on 03/08/2010 10:03:44 Ups, sorry. Thanx for moving the topic.
Still, any suggestions? Or maybe a class-scheme/description? ... although I guess I already know the answer to that ;-) ...
|
Serious Masta
Caldari
|
Posted - 2010.08.03 10:25:00 -
[5]
http://games.chruker.dk/eve_online/datadump.php
Here you have a database table schema diagram, i hope it helps.
|
Datis Komis
|
Posted - 2010.08.03 11:01:00 -
[6]
Edited by: Datis Komis on 03/08/2010 11:01:16 Thanks a lot Serious Master, nice work. But still the question holds: how to find the ore types for a particular system? It seems as if the data is not included in the db. Or is there another sql-dump?
Cheers DK
|
Serious Masta
Caldari
|
Posted - 2010.08.03 11:15:00 -
[7]
Edited by: Serious Masta on 03/08/2010 11:17:51
Originally by: Datis Komis
But still the question holds: how to find the ore types for a particular system?
i dont have the answer to your question but a website where you can find the information.
maybe you can ask the operator for the sql query.
this is jita, for example http://www.fluidorbit.co.uk/view.php?id=30000142
/edit: and where a chart of ore per race/security level. http://dl.eve-files.com/media/0803/roid_grid_Glow.jpg but this dont have the information how MANY roids are located per system.
Cheers
|
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2010.08.03 12:05:00 -
[8]
Originally by: Datis Komis Atm I am interested in getting information about ore in different systems. I found the description, category name of ore etc in the db and I found the asteroid-belds in mapSolarSystems. But how do I get from ateroid belt to type of asteroids?
This information is not in the datadump. You can *expect* certain types of ore in certain security systems. But that's all. -- Thanks CCP for cu |
Datis Komis
|
Posted - 2010.08.03 14:00:00 -
[9]
Tanks again to you two.
I will have a look and try to find the sources from my old stuff to see where I got it from.
C u, DK
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |