Changeling
From Edge of Darkness Wiki
Main ● Lost ● Changeling: The Lost ● Changeling
m |
|||
| (9 intermediate revisions not shown) | |||
| Line 1: | Line 1: | ||
| - | {{#set:Venue Status= | + | {{#set:Venue Status=Open}}[[Category:Information]]{{header|ctl}}{{Changeling/Index}}__NOTOC__ |
| - | The | + | The history of the Sacramento Freehold is inconsistent and diverse. It has known feast and famine, war and peace, bliss and pain. Many attribute this to the Freehold's status as a hub for travel up and down the West coast. Many more Changelings pass through Sacramento than ever put down roots and stay, and you would be hard pressed to find a native among the Freehold. It's mood can depend a great deal on who it currently counts among it's pledged members, and what boons or troubles they bring with them or find in their residence. |
| - | That | + | That is less true, of late. A cloud has hung over the Freehold in recent years. Manifested most dramatically in the burning of the Four Seasons, the former commons of the entire 'Hold, by the Draconic True Fae who calls himself Fairweather. The dragon claimed vassals and sovereigns alike as he wrought devastation upon the Changelings of Sacramento, and then abruptly vanished back into the Hedge. His work continues, however. His minions burn a path through the surrounding Hollows, searching for something. His real-world businesses make moves and counter-moves, all in service to some hidden agenda. And the mortal guise of the Fae himself has been spotted again on the streets of Sacramento. |
| - | + | As if these weren't troubles enough, Sacramento has also been struck by the abandonment of it's leadership. In the Spring of 2016, all four Sovereigns vanished, leaving behind only a few tokens of their good-will and a letter of consolation and hope. In their wake, new Sovereigns have emerged, untested Queens of each of the four Seasons, who lead their Courts through this time of danger and strife. Even as the dragon works, other matters continue to assail them. Mad Changelings, escaped hedge-beasts, an unfriendly goblin market, and other troubles besides continue to test the Freehold's capacity to deal with adversity. Such desperate struggles drive many Lost to hunger, to anger, to fear, and to sorrow, for every battle fought is mirrored in their own fractured minds. | |
| - | + | What good would it do to retain Sacramento but lose your mind? | |
| - | |||
{{Venue Status|Changeling}} | {{Venue Status|Changeling}} | ||
| Line 20: | Line 19: | ||
{{#get_db_data:db=nwod | {{#get_db_data:db=nwod | ||
|from=post JOIN thread ON (thread.threadid = post.threadid) JOIN forum ON (forum.forumid = thread.forumid) JOIN user ON (user.username = thread.lastposter) | |from=post JOIN thread ON (thread.threadid = post.threadid) JOIN forum ON (forum.forumid = thread.forumid) JOIN user ON (user.username = thread.lastposter) | ||
| - | |where=thread.forumid IN (9,209,243) group by thread.title order by thread.lastpost desc LIMIT 20 | + | |where=thread.forumid IN (9,209,243) AND thread.open = 1 AND thread.lastpost >= UNIX_TIMESTAMP()-30*24*60*60 group by thread.title order by thread.lastpost desc LIMIT 20 |
|data=ctlforum=forum.title AS forum, ctlthread=thread.title, ctldate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, ctlposter=thread.lastposter, ctlpostcount=count(postid), ctlpostid=post.postid, ctlforumid=thread.forumid, ctluserid=user.userid | |data=ctlforum=forum.title AS forum, ctlthread=thread.title, ctldate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, ctlposter=thread.lastposter, ctlpostcount=count(postid), ctlpostid=post.postid, ctlforumid=thread.forumid, ctluserid=user.userid | ||
}} | }} | ||
| Line 30: | Line 29: | ||
<td style="width: auto; padding: 1px 1em 0;" valign="top"> | <td style="width: auto; padding: 1px 1em 0;" valign="top"> | ||
<div style="margin-bottom: 5px; border-bottom: 1px dimgrey solid; color:green;">'''Current Characters'''</div> | <div style="margin-bottom: 5px; border-bottom: 1px dimgrey solid; color:green;">'''Current Characters'''</div> | ||
| - | <div style="font-size: 85%;">{{# | + | <div style="font-size: 85%;">{{#get_db_data:db=nwod |
| + | |from=characters | ||
| + | |where=characters.Status = 'Active' AND characters.Venue = 'Changeling' ORDER BY characters.char_name | ||
| + | |data=userid=characters.char_userid,name=characters.char_name | ||
| + | }} | ||
| + | {{#for_external_table: <html><div style="margin-top: 5px; margin-right: 5px; clear: left;"><div style="margin-top: 5px; margin-right: 5px; clear: left; float: left; height: 38px; width: 38px; overflow: hidden; border-radius: 50%;" ><a href="http://nwod.org/forum/member.php?</html>{{{userid}}}<html>" title="</html>{{{name}}}<html>"><img title="</html>{{{name}}}<html>"src="http://nwod.org/forum/image.php?u=</html>{{{userid}}}<html>" width="38" /></a></div><div style="padding-top: 10px;"><a href="http://nwod.org/forum/member.php?</html>{{{userid}}}<html>"></html>{{{name}}}<html></a></div></div></html> }}</div> | ||
</td> | </td> | ||
<td style="width: auto; padding: 1px 1em 0;" valign="top"> | <td style="width: auto; padding: 1px 1em 0;" valign="top"> | ||
<div style="border-bottom: 1px dimgrey solid; color:green;">'''Archived Scenes'''</div> | <div style="border-bottom: 1px dimgrey solid; color:green;">'''Archived Scenes'''</div> | ||
| - | <div style="color:green; font-size: 85%;">{{#ask: [[Category:Changeling Scenes]] |sort=Sacramento date |order=desc |format = ul |limit= | + | <div style="color:green; font-size: 85%;">{{#ask: [[Category:Changeling Scenes]] |sort=Sacramento date |order=desc |format = ul |limit=15}}</div> |
</td></tr></table> | </td></tr></table> | ||
</div> | </div> | ||
| + | |||
| + | |||
| + | |||
{{#ask: [[Event for::Changeling]] [[Sacramento date::+]] | {{#ask: [[Event for::Changeling]] [[Sacramento date::+]] | ||
Latest revision as of 13:22, 11 July 2017
| |||||||||||||||||||
