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 = 'Palacerules'
AND (
poitab.mapid = '11598'
OR (
poitab.startYear > 0
AND ( poitab.endYear = 0 OR (poitab.endYear * 100 + poitab.endSeason) >= '12904' )
AND ( (poitab.startYear * 100 + poitab.startSeason) <= '12904' )
)
)
ORDER BY
IF(maptab.default_poi=poitab.poiid,1,0) DESC,
IF(maptab.mapYear>'129',0,maptab.mapYear) DESC
LIMIT 1
There are 2 comments for this map series, last post 23/02/2013 05:02
Got something to say, a question or a comment... feel free to post. If you want to reference a point of interest or another map, find its ID number and use BBCode to reference it in your comment. For example [map=67]my map[/map] or What is that [poi=100]cool place[/poi]...
Add new point of interest
If you've found something interesting on this map, or you want to document parts of your fortress, then use this form.
Browse (move/zoom) to a place on the map, its position will be displayed in the boxes below. Fill out the form and hit add to store a new point of interest.
I like the shape of the deeper levels! You're going to have a dozen legendary miners by the time the digging is all done. Or one EXTREMELY legendary miner!
Submitted by: ajr_ - 23/02/2013 05:02 to 129 Early Summer
[x] This map viewer uses the new ByteArray features only available with the newest version of Flash 9. Please update your player in order to view this map.
Submitted by: Noble Digger - 21/02/2013 08:02 to 128 Early Spring
I like the shape of the deeper levels! You're going to have a dozen legendary miners by the time the digging is all done. Or one EXTREMELY legendary miner!
Submitted by: ajr_ - 23/02/2013 05:02 to 129 Early Summer
A very dwarfy scale of things aye