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 = 'Glazedear'
AND (
poitab.mapid = '170'
OR (
poitab.startYear > 0
AND ( poitab.endYear = 0 OR (poitab.endYear * 100 + poitab.endSeason) >= '106100' )
AND ( (poitab.startYear * 100 + poitab.startSeason) <= '106100' )
)
)
ORDER BY
IF(maptab.default_poi=poitab.poiid,1,0) DESC,
IF(maptab.mapYear>'1061',0,maptab.mapYear) DESC
LIMIT 1
Point of Interest: East-Side Bedroom Complex
The eastern bedrooms, over the chasm... attacks here are actually rare... - ReWolf
There are 4 comments for this map series, last post 2007-06-18
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.
These are the deluxe suites, with en-suite for the nobles. The en-suite is activated through locking the door when said smelly noble is sleeping, and pulling the lever outside his house.
This leaves a clean noble, smelling fresh of mountain spring water.
(Warning: En-Suite side-effects may possibly definitely include, but are not limited to, the following: Death and/or the Ending of Life)
- ReWolf
[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: Rewolf - 2007-06-09 to 1061
oops.... experimenting is fun! :D
Submitted by: Markavian - 2007-06-10 to 1061
Hey, great job on the canal and the rest of the fortress layout. Looks great.
Submitted by: Markavian - 2007-06-13 to 1063
That's gonna be a mighty canal, although it looks like you've emptied the water out =)
Submitted by: ReWolf - 2007-06-18 to 1063
Yeah, it's shut off. It's only useful for aesthetics and noble flooding. up top is the soon-to-be magma river... heheheh...