open All Channels
seplocked EVE Technology Lab
blankseplocked Solarsystems & Icebelts
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Nuran DeSiad
Gallente
Plain Trash
Posted - 2011.04.28 13:04:00 - [1]
 

Hi all,

I've been rummaging through the static dump, I want to extract the solarsystems which contain Ice Fields. I have added the custom table mapRegionIceTypes (from http://wiki.eve-id.net/MapRegionIceTypes ). The example query does not quite give the information I want.

Anybody can give me a hint into the right direction ?

cheers,
Nuran

Nuran DeSiad
Gallente
Plain Trash
Posted - 2011.04.28 13:16:00 - [2]
 

OK, as usual, the answer comes to me after I post here....Very HappyVery HappyVery Happy

I found a partly answer in this thread:
http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1486227

Next step is to identify the Ice types in the Ice Fields.


Emilie Sunstrider
Posted - 2011.04.28 14:19:00 - [3]
 

Edited by: Emilie Sunstrider on 28/04/2011 14:20:06
Is something like this that you need?

Quote:
SELECT itemName,solarSystemName,typename FROM `evedump`.`mapdenormalize`
join invtypes on invtypes.typeid = mapdenormalize.typeid
join mapsolarsystems on mapdenormalize.solarsystemid = mapsolarsystems.solarsystemid
where invtypes.typename = "Ice Field";


result

edit: its quick and dirt and im not a miner, so idk if it is the correct locations. all extracted from the mysql export from the sticky thread.

Greg Huff
Posted - 2011.04.28 15:00:00 - [4]
 

This will give you the Belt, System, Security Level, and Region
SELECT itemName, solarSystemName, mss.security, regionName
FROM mapDenormalize map
join mapSolarSystems mss on map.solarSystemID = mss.solarSystemID
join dbo.mapRegions reg on reg.regionID=mss.regionID
where map.typeID = 17774


I suspect that you would have to calculate the ice types based on region and security level.

Nuran DeSiad
Gallente
Plain Trash
Posted - 2011.04.29 14:49:00 - [5]
 

Thanks for the input !

I am looking for the ice types in the belts according to region and security, as Greg stated. I hope to produce a query or even a custom table (like the mapSolarSystemOreBySecurityClass ) for the ice types.

cheers, Nuran


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only