Mage
From Edge of Darkness Wiki
Mage
m |
|||
| (9 intermediate revisions not shown) | |||
| Line 6: | Line 6: | ||
The Awakened of Sacramento remember Sacramento. | The Awakened of Sacramento remember Sacramento. | ||
| - | One day, that's all they had. Memories. Conflicting memories of lives that never were, and lives that could have been. The memory-visions sounded the horn of a new | + | One day, that's all they had. Memories. Conflicting memories of lives that never were, and lives that could have been. The memory-visions sounded the horn of a new [[Reality War]] against the Seers, being fought across time itself. |
And now, every memory and reality itself is a question mark. | And now, every memory and reality itself is a question mark. | ||
| Line 21: | Line 21: | ||
{{#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 (8,242,221) group by thread.title order by thread.lastpost desc LIMIT 20 | + | |where=thread.forumid IN (8,242,221) 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=mtaforum=forum.title AS forum, mtathread=thread.title, mtadate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, mtaposter=thread.lastposter, mtapostcount=count(postid), mtapostid=post.postid, mtaforumid=thread.forumid, mtauserid=user.userid | |data=mtaforum=forum.title AS forum, mtathread=thread.title, mtadate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, mtaposter=thread.lastposter, mtapostcount=count(postid), mtapostid=post.postid, mtaforumid=thread.forumid, mtauserid=user.userid | ||
}} | }} | ||
| Line 31: | Line 31: | ||
<td style="padding: 1px 1em 0;" valign="top"> | <td style="padding: 1px 1em 0;" valign="top"> | ||
<div style="margin-bottom: 5px; border-bottom: 1px dimgrey solid; color:cyan;">'''Active Characters'''</div> | <div style="margin-bottom: 5px; border-bottom: 1px dimgrey solid; color:cyan;">'''Active 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 = 'Mage' 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 style="padding: 1px 1em 0;" valign="top"> | <td style="padding: 1px 1em 0;" valign="top"> | ||
<div style="border-bottom: 1px dimgrey solid; color:cyan;">'''Scenes & Stories'''</div> | <div style="border-bottom: 1px dimgrey solid; color:cyan;">'''Scenes & Stories'''</div> | ||
| - | <div style="font-size: 85%; color:cyan;">{{#ask: [[Category:Mage Scenes]]|limit= | + | <div style="font-size: 85%; color:cyan;">{{#ask: [[Category:Mage Scenes]]|limit=15 |sort=Sacramento date |order=desc |format = ul |columns=1}}</div> |
</td></tr></table> | </td></tr></table> | ||
| - | |||
| - | |||
| - | |||
{{#ask: [[Event for::Mage]] [[Sacramento date::+]] | {{#ask: [[Event for::Mage]] [[Sacramento date::+]] | ||
| Line 49: | Line 51: | ||
| timelineposition=end | | timelineposition=end | ||
}} | }} | ||
| + | |||
{{Footer|mta}}[[Category:Information]] | {{Footer|mta}}[[Category:Information]] | ||
Latest revision as of 20:33, 20 March 2022
| ||||||||||||||||||||||
