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 = 'Speechmirror'
AND (
poitab.mapid = '7774'
OR (
poitab.startYear > 0
AND ( poitab.endYear = 0 OR (poitab.endYear * 100 + poitab.endSeason) >= '20409' )
AND ( (poitab.startYear * 100 + poitab.startSeason) <= '20409' )
)
)
ORDER BY
IF(maptab.default_poi=poitab.poiid,1,0) DESC,
IF(maptab.mapYear>'204',0,maptab.mapYear) DESC
LIMIT 1
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.
[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.