Well, work in progress, kinda screwed up at the beginning as the tree lovers send an ambush. Aren't they learning anything today at their tree house?
Had some fun with elves and restraines, mostly because i forgot to take away their weapons....
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 = 'Pickgorged'
AND (
poitab.mapid = '9841'
OR (
poitab.startYear > 0
AND ( poitab.endYear = 0 OR (poitab.endYear * 100 + poitab.endSeason) >= '25211' )
AND ( (poitab.startYear * 100 + poitab.startSeason) <= '25211' )
)
)
ORDER BY
IF(maptab.default_poi=poitab.poiid,1,0) DESC,
IF(maptab.mapYear>'252',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.