Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Trenker
|
Posted - 2011.08.11 16:51:00 -
[1]
Hi everyone
I tried to get the typeIDs of the resources of a celestial object but could not find it. More specific: I want to know which ore / ice types can found in a given belt, and which resources are available on a given planet (type) and moon. Couldn't find it in the ram, map and dgm tables.
Using the mysql dump from http://zofu.no-ip.de/inca10/
Any hints on were to look?
|
Callean Drevus
Caldari Icosahedron Crafts and Shipping Silent Infinity
|
Posted - 2011.08.11 17:33:00 -
[2]
Most of the data you are looking for is not in the static data dump, as far as I know. --- "A fool flatters himself, a wise man flatters the fool."
Chief Developer of EVE Marketeer. |
Lutz Major
|
Posted - 2011.08.11 18:36:00 -
[3]
Only PI resources are available in the dump:SELECT resource.* FROM invTypes planet, invTypes resource, dgmTypeAttributes dgm1, dgmTypeAttributes dgm2 WHERE dgm1.typeID = dgm2.typeID -- planet info AND dgm1.attributeID = 1632 AND dgm1.valueFloat = planet.typeID -- ressource info AND dgm2.attributeID = 709 AND dgm2.valueFloat = resource.typeID AND planet.typeID = 11 All other stuff you are looking for is not available.
|
Pantload
Gallente Handsome Millionaire Playboys
|
Posted - 2011.08.17 04:27:00 -
[4]
Originally by: Lutz Major Only PI resources are available in the dump:SELECT resource.* FROM invTypes planet, invTypes resource, dgmTypeAttributes dgm1, dgmTypeAttributes dgm2 WHERE dgm1.typeID = dgm2.typeID -- planet info AND dgm1.attributeID = 1632 AND dgm1.valueFloat = planet.typeID -- ressource info AND dgm2.attributeID = 709 AND dgm2.valueFloat = resource.typeID AND planet.typeID = 11 All other stuff you are looking for is not available.
So let's say I don't speak SQL at all. I do speak a bit of Python and I have Entity's Reverence library. How do I do the same lookup in the bulkdata tables?
If I understand at all...that query tells what plants yield what resources? That's all I'm after anyway, if so.
Any help is appreciated. Thanks.
Cheers, -PL
TUG: The Underpants Gnomes. Buy Corps here
|
Lutz Major
|
Posted - 2011.08.17 06:56:00 -
[5]
Originally by: Pantload So let's say I don't speak SQL at all. I do speak a bit of Python and I have Entity's Reverence library. How do I do the same lookup in the bulkdata tables?
If I understand at all...that query tells what plants yield what resources? That's all I'm after anyway, if so.
Any help is appreciated. Thanks.
Cheers, -PL
I don't know Reverence, but it's static data anyway. So I hope this will help:|========================================| | PLANET | RESSOURCE | |========================================| | Planet (Barren) | Aqueous Liquids | | Planet (Barren) | Base Metals | | Planet (Barren) | Carbon Compounds | | Planet (Barren) | Micro Organisms | | Planet (Barren) | Noble Metals | | Planet (Gas) | Aqueous Liquids | | Planet (Gas) | Base Metals | | Planet (Gas) | Ionic Solutions | | Planet (Gas) | Noble Gas | | Planet (Gas) | Reactive Gas | | Planet (Ice) | Aqueous Liquids | | Planet (Ice) | Heavy Metals | | Planet (Ice) | Micro Organisms | | Planet (Ice) | Noble Gas | | Planet (Ice) | Planktic Colonies | | Planet (Lava) | Base Metals | | Planet (Lava) | Felsic Magma | | Planet (Lava) | Heavy Metals | | Planet (Lava) | Non-CS Crystals | | Planet (Lava) | Suspended Plasma | | Planet (Oceanic) | Aqueous Liquids | | Planet (Oceanic) | Carbon Compounds | | Planet (Oceanic) | Complex Organisms | | Planet (Oceanic) | Micro Organisms | | Planet (Oceanic) | Planktic Colonies | | Planet (Plasma) | Base Metals | | Planet (Plasma) | Heavy Metals | | Planet (Plasma) | Noble Metals | | Planet (Plasma) | Non-CS Crystals | | Planet (Plasma) | Suspended Plasma | | Planet (Storm) | Aqueous Liquids | | Planet (Storm) | Base Metals | | Planet (Storm) | Ionic Solutions | | Planet (Storm) | Noble Gas | | Planet (Storm) | Suspended Plasma | | Planet (Temperate) | Aqueous Liquids | | Planet (Temperate) | Autotrophs | | Planet (Temperate) | Carbon Compounds | | Planet (Temperate) | Complex Organisms | | Planet (Temperate) | Micro Organisms | |----------------------------------------| or more Excel friendly (copy first in a notepad, then into Excel!):
PLANETRESSOURCE Planet (Barren)Aqueous Liquids Planet (Barren)Base Metals Planet (Barren)Carbon Compounds Planet (Barren)Micro Organisms Planet (Barren)Noble Metals Planet (Gas)Aqueous Liquids Planet (Gas)Base Metals Planet (Gas)Ionic Solutions Planet (Gas)Noble Gas Planet (Gas)Reactive Gas Planet (Ice)Aqueous Liquids Planet (Ice)Heavy Metals Planet (Ice)Micro Organisms Planet (Ice)Noble Gas Planet (Ice)Planktic Colonies Planet (Lava)Base Metals Planet (Lava)Felsic Magma Planet (Lava)Heavy Metals Planet (Lava)Non-CS Crystals Planet (Lava)Suspended Plasma Planet (Oceanic)Aqueous Liquids Planet (Oceanic)Carbon Compounds Planet (Oceanic)Complex Organisms Planet (Oceanic)Micro Organisms Planet (Oceanic)Planktic Colonies Planet (Plasma)Base Metals Planet (Plasma)Heavy Metals Planet (Plasma)Noble Metals Planet (Plasma)Non-CS Crystals Planet (Plasma)Suspended Plasma Planet (Storm)Aqueous Liquids Planet (Storm)Base Metals Planet (Storm)Ionic Solutions Planet (Storm)Noble Gas Planet (Storm)Suspended Plasma Planet (Temperate)Aqueous Liquids Planet (Temperate)Autotrophs Planet (Temperate)Carbon Compounds Planet (Temperate)Complex Organisms Planet (Temperate)Micro Organisms
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |