Koganrur - 258 Mid Winter by Jon

SELECT poitab.poiid AS default_poi, UNIX_TIMESTAMP(maptab.dateSubmitted) as dateSubmittedUnix FROM dfma_pointsofinterest AS poitab LEFT JOIN dfma_maps_v2 AS maptab ON maptab.mapid=poitab.mapid WHERE maptab.fortressName = 'Koganrur' AND ( poitab.mapid = '10339' OR ( poitab.startYear > 0 AND ( poitab.endYear = 0 OR (poitab.endYear * 100 + poitab.endSeason) >= '25811' ) AND ( (poitab.startYear * 100 + poitab.startSeason) <= '25811' ) ) ) ORDER BY IF(maptab.default_poi=poitab.poiid,1,0) DESC, IF(maptab.mapYear>'258',0,maptab.mapYear) DESC LIMIT 1

There are 2 comments for this map series, last post 2011-05-03

Add a Comment

Comments

Submitted by: Markavian - 2011-04-28 to 258 Mid Winter

How about some PoIs? I see a huge number of coffins on the surface...

Submitted by: ClsfdKidd - 2011-05-03 to 258 Mid Winter

The blood in the drinking water will not please Urist. Hopefully it is only for hospital uses. May the booze flow forever.

Viewer Controls

SHIFT + Key doubles keyboard scroll rate.

Problems?

Do you only see a blank space?

Don't have Flash?
You can download the compressed map file: 2011-04/jon-Boatsrun-region2-258-35981.fdf-map but you will need the .NET version of SL's DF Map Compressor to convert to the .PNG image format.

Login: