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.
 

Materials on a Planet in the SDE dump
Author
Previous Topic Next Topic
Louis Vitton
Viziam
Amarr Empire
#1 - 2012-07-13 01:22:08 UTC
Hey guys,

I am able to fin the planets and everything but the materials that are on each individule planet is what i am really looking for now from the SDE if possible i know i can prob pull them from somewhere else and enter manually if required.

Cheers Louis for you help.
Chaotic Mind
Republic University
Minmatar Republic
#2 - 2012-07-13 06:22:47 UTC
Depends..

for PI it's known, only takes a couple of minutes to hardcode it by planet type

if you ment the Moon mining, you have to enter them manually.
Louis Vitton
Viziam
Amarr Empire
#3 - 2012-07-15 03:56:11 UTC
i do just mean PI not moon goo
Thanks for the reply i though ti would be that
Lutz Major
Austriae Est Imperare Orbi Universo
#4 - 2012-07-16 18:03:11 UTC
Hardcoding? Oh, please ....


SELECT planet.typeName, pi.typeName
FROM invTypes planet, invTypes pi, dgmTypeAttributes dgmPlanet, dgmTypeAttributes dgmPi
WHERE dgmPlanet.typeID = dgmPi.typeID
AND dgmPlanet.attributeID = 1632 AND dgmPlanet.valueFloat = planet.typeID
AND dgmPi.attributeID = 709 AND dgmPi.valueFloat = pi.typeID
AND pi.published = 1
Louis Vitton
Viziam
Amarr Empire
#5 - 2012-07-17 09:42:44 UTC
Lutz Major wrote:
Hardcoding? Oh, please ....


SELECT planet.typeName, pi.typeName
FROM invTypes planet, invTypes pi, dgmTypeAttributes dgmPlanet, dgmTypeAttributes dgmPi
WHERE dgmPlanet.typeID = dgmPi.typeID
AND dgmPlanet.attributeID = 1632 AND dgmPlanet.valueFloat = planet.typeID
AND dgmPi.attributeID = 709 AND dgmPi.valueFloat = pi.typeID
AND pi.published = 1

Thank you mate works very well :)