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

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

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Question: where to find planet type in datadump?
Author
Previous Topic Next Topic
Daedalus II
Aliastra
Gallente Federation
#1 - 2011-10-19 19:36:02 UTC  |  Edited by: Daedalus II
What I want to find out is what type each planet in the static data dump is (lava, barren and so on). I would expect this to be an integer value somewhere in relation to other planetary data, but I can't find it.

I checked mapCelestialStatistics that seemed to be the most logical place for it, but I found nothing there that seemed to be the planet type. And I can't really see it fitting into any of the other tables either.

And while I'm at it, is there any resource somewhere I can use to find these things out myself? some list of what can be found in the data dump and how to use it? what each table really means and what it contains? A wiki perhaps? This far I have just checked the headers for each table and made a qualified guess of what the different items are and how they are related to each other.
Lutz Major
Austriae Est Imperare Orbi Universo
#2 - 2011-10-19 20:22:38 UTC
Have you tried the obvious?

SELECT * FROM invTypes WHERE groupID = 7
Daedalus II
Aliastra
Gallente Federation
#3 - 2011-10-19 20:54:19 UTC  |  Edited by: Daedalus II
Lutz Major wrote:
Have you tried the obvious?

SELECT * FROM invTypes WHERE groupID = 7

No I haven't as I don't consider that obvious at all, what is so obvious about invTypes? What does it stand for? inventory types? inverse types? invention types? what?

Edit: ok apparently it seems to be inventory types. Well then one might ask why it is logical to expect to find planets, factions and trade sessions amongst other stuff in ones inventory. But maybe it's not "inventory" or even if it is it means inventory in a way that is not connected to what can be found inside an inventory in the game. Anyway not a logical place to find info about planets IMO.

Also I realize I was a bit unclear about what I want. What I'm looking for is the type of each planet in the data, not which types are available. I'm sorry about that and will update the original post to better show this.
Lutz Major
Austriae Est Imperare Orbi Universo
#4 - 2011-10-20 04:17:35 UTC
SELECT * FROM mapDenormalize map, invTypes inv
WHERE map.typeID = inv.typeID and map.groupID = 7
Tonto Auri
Vhero' Multipurpose Corp
#5 - 2011-10-20 10:45:22 UTC
Daedalus II wrote:
Lutz Major wrote:
Have you tried the obvious?

SELECT * FROM invTypes WHERE groupID = 7

No I haven't as I don't consider that obvious at all, what is so obvious about invTypes? What does it stand for? inventory types? inverse types? invention types? what?

Edit: ok apparently it seems to be inventory types. Well then one might ask why it is logical to expect to find planets, factions and trade sessions amongst other stuff in ones inventory. But maybe it's not "inventory" or even if it is it means inventory in a way that is not connected to what can be found inside an inventory in the game. Anyway not a logical place to find info about planets IMO.

From server standpoint (also a good database organization POV), it's logical to keep inventory types together.
Planets are inventory of the solarsystem, right?

Two most common elements in the universe are hydrogen and stupidity. -- Harlan Ellison
Daedalus II
Aliastra
Gallente Federation
#6 - 2011-10-20 11:19:21 UTC
Tonto Auri wrote:
Daedalus II wrote:
Lutz Major wrote:
Have you tried the obvious?

SELECT * FROM invTypes WHERE groupID = 7

No I haven't as I don't consider that obvious at all, what is so obvious about invTypes? What does it stand for? inventory types? inverse types? invention types? what?

Edit: ok apparently it seems to be inventory types. Well then one might ask why it is logical to expect to find planets, factions and trade sessions amongst other stuff in ones inventory. But maybe it's not "inventory" or even if it is it means inventory in a way that is not connected to what can be found inside an inventory in the game. Anyway not a logical place to find info about planets IMO.

From server standpoint (also a good database organization POV), it's logical to keep inventory types together.
Planets are inventory of the solarsystem, right?

Yeah I can see why you would like to keep it in the same table, it's more the name calling convention I object against as one expects something else when one talks about the inventory in EVE. Personally I might have called it entityTypes/entityDescr/entities or something like that instead of invTypes. But I don't have much knowledge of databases, maybe you always call this kind of table inventory?

Also thanks to Lutz for the info, apparently it's in mapDenormalize then.