Main Page
From Edge of Darkness Wiki
Main Page
m |
m |
||
| (11 intermediate revisions not shown) | |||
| Line 15: | Line 15: | ||
{{col-begin|width=100%}} | {{col-begin|width=100%}} | ||
| - | {{col-break|width= | + | {{col-break|width=25%}} |
==[[Changeling]]== | ==[[Changeling]]== | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
<div style="margin-right: 40px; white-space: nowrap; overflow: hidden;"> | <div style="margin-right: 40px; white-space: nowrap; overflow: hidden;"> | ||
{{#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,98,243) group by thread.title order by thread.lastpost desc LIMIT | + | |where=thread.forumid IN (9,209,98,243) group by thread.title order by thread.lastpost desc LIMIT 10 |
|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 | ||
}} | }} | ||
<table style="width:100%"> | <table style="width:100%"> | ||
| - | {{#for_external_table: <html><div style="background: darkgreen; margin-right: 5px; float: left; height: 38px; width: 38px; overflow: hidden; border-radius: 50%;" ><a href="http://nwod.org/forum/member.php?</html>{{{ctluserid}}}<html>"><img title="</html>{{{ctlposter}}}<html>"src="http://nwod.org/forum/image.php?u=</html>{{{ctluserid}}}<html>" style="width: 38px; min-height: 38px;" /></a></div></html> [http://nwod.org/forum/showthread.php?p={{{ctlpostid}}}#post{{{ctlpostid}}} {{{ctlthread}}}] <br /><div style="margin-left: 4em;"><small>{{{ctlpostcount}}} Posts, Updated {{{ctldate}}} </small></div> }} | + | {{#for_external_table: <html><div style="background: darkgreen; margin-right: 5px; float: left; height: 38px; width: 38px; overflow: hidden; border-radius: 50%;" ><a href="http://nwod.org/forum/member.php?</html>{{{ctluserid}}}<html>"><img title="</html>{{{ctlposter}}}<html>"src="http://nwod.org/forum/image.php?u=</html>{{{ctluserid}}}<html>&type=thumb" style="width: 38px; min-height: 38px;" /></a></div></html> [http://nwod.org/forum/showthread.php?p={{{ctlpostid}}}#post{{{ctlpostid}}} {{{ctlthread}}}] <br /><div style="margin-left: 4em;"><small>{{{ctlpostcount}}} Posts, Updated {{{ctldate}}} </small></div> }} |
</table> | </table> | ||
</div> | </div> | ||
| - | {{col-break|width= | + | {{col-break|width=25%}} |
| + | |||
==[[Mage]]== | ==[[Mage]]== | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
<div style="margin-right: 40px; white-space: nowrap; overflow: hidden;"> | <div style="margin-right: 40px; white-space: nowrap; overflow: hidden;"> | ||
{{#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,221,242,258) group by thread.title order by thread.lastpost desc LIMIT | + | |where=thread.forumid IN (8,221,242,258) group by thread.title order by thread.lastpost desc LIMIT 10 |
|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 | ||
}} | }} | ||
<table style="width:100%"> | <table style="width:100%"> | ||
| - | {{#for_external_table: <html><div style="background: black; margin-right: 5px; float: left; height: 38px; width: 38px; overflow: hidden; border-radius: 50%;" ><a href="http://nwod.org/forum/member.php?</html>{{{mtauserid}}}<html>"><img title="</html>{{{mtaposter}}}<html>"src="http://nwod.org/forum/image.php?u=</html>{{{mtauserid}}}<html>" style="width: 38px; min-height: 38px;" /></a></div></html> [http://nwod.org/forum/showthread.php?p={{{mtapostid}}}#post{{{mtapostid}}} {{{mtathread}}}] <br /><div style="margin-left: 4em;"><small>{{{mtapostcount}}} Posts, Updated {{{mtadate}}} </small></div> }} | + | {{#for_external_table: <html><div style="background: black; margin-right: 5px; float: left; height: 38px; width: 38px; overflow: hidden; border-radius: 50%;" ><a href="http://nwod.org/forum/member.php?</html>{{{mtauserid}}}<html>"><img title="</html>{{{mtaposter}}}<html>"src="http://nwod.org/forum/image.php?u=</html>{{{mtauserid}}}<html>&type=thumb" style="width: 38px; min-height: 38px;" /></a></div></html> [http://nwod.org/forum/showthread.php?p={{{mtapostid}}}#post{{{mtapostid}}} {{{mtathread}}}] <br /><div style="margin-left: 4em;"><small>{{{mtapostcount}}} Posts, Updated {{{mtadate}}} </small></div> }} |
</table> | </table> | ||
</div> | </div> | ||
| Line 55: | Line 45: | ||
| - | {{col-break|width= | + | {{col-break|width=25%}} |
==[[Vampire]]== | ==[[Vampire]]== | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
<div style="margin-right: 40px; white-space: nowrap; overflow: hidden;"> | <div style="margin-right: 40px; white-space: nowrap; overflow: hidden;"> | ||
{{#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 (5,210,61,200) group by thread.title order by thread.lastpost desc LIMIT | + | |where=thread.forumid IN (5,210,61,200) group by thread.title order by thread.lastpost desc LIMIT 10 |
|data=vtrforum=forum.title AS forum, vtrthread=thread.title, vtrdate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, vtrposter=thread.lastposter, vtrpostcount=count(postid), vtrpostid=post.postid, vtrforumid=thread.forumid, vtruserid=user.userid | |data=vtrforum=forum.title AS forum, vtrthread=thread.title, vtrdate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, vtrposter=thread.lastposter, vtrpostcount=count(postid), vtrpostid=post.postid, vtrforumid=thread.forumid, vtruserid=user.userid | ||
}} | }} | ||
<table style="width:100%"> | <table style="width:100%"> | ||
| - | {{#for_external_table: <html><div style="background: darkred; margin-right: 5px; float: left; height: 38px; width: 38px; overflow: hidden; border-radius: 50%;" ><a href="http://nwod.org/forum/member.php?</html>{{{vtruserid}}}<html>"><img title="</html>{{{vtrposter}}}<html>"src="http://nwod.org/forum/image.php?u=</html>{{{vtruserid}}}<html>" style="width: 38px; min-height: 38px;" /></a></div></html> [http://nwod.org/forum/showthread.php?p={{{vtrpostid}}}#post{{{vtrpostid}}} {{{vtrthread}}}] <br /><div style="margin-left: 4em;"><small>{{{vtrpostcount}}} Posts, Updated {{{vtrdate}}} </small></div> }} | + | {{#for_external_table: <html><div style="background: darkred; margin-right: 5px; float: left; height: 38px; width: 38px; overflow: hidden; border-radius: 50%;" ><a href="http://nwod.org/forum/member.php?</html>{{{vtruserid}}}<html>"><img title="</html>{{{vtrposter}}}<html>"src="http://nwod.org/forum/image.php?u=</html>{{{vtruserid}}}<html>&type=thumb" style="width: 38px; min-height: 38px;" /></a></div></html> [http://nwod.org/forum/showthread.php?p={{{vtrpostid}}}#post{{{vtrpostid}}} {{{vtrthread}}}] <br /><div style="margin-left: 4em;"><small>{{{vtrpostcount}}} Posts, Updated {{{vtrdate}}} </small></div> }} |
</table> | </table> | ||
</div> | </div> | ||
| + | |||
| + | |||
| + | {{col-break|width=25%}} | ||
| + | ==[[Werewolf]]== | ||
| + | <div style="margin-right: 40px; white-space: nowrap; overflow: hidden;"> | ||
| + | {{#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) | ||
| + | |where=thread.forumid IN (7) group by thread.title order by thread.lastpost desc LIMIT 10 | ||
| + | |data=wtfforum=forum.title AS forum, wtfthread=thread.title, wtfdate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, wtfposter=thread.lastposter, wtfpostcount=count(postid), wtfpostid=post.postid, wtfforumid=thread.forumid, wtfuserid=user.userid | ||
| + | }} | ||
| + | <table style="width:100%"> | ||
| + | {{#for_external_table: <html><div style="background: brown; margin-right: 5px; float: left; height: 38px; width: 38px; overflow: hidden; border-radius: 50%;" ><a href="http://nwod.org/forum/member.php?</html>{{{wtfuserid}}}<html>"><img title="</html>{{{wtfposter}}}<html>"src="http://nwod.org/forum/image.php?u=</html>{{{wtfuserid}}}<html>&type=thumb" style="width: 38px; min-height: 38px;" /></a></div></html> [http://nwod.org/forum/showthread.php?p={{{wtfpostid}}}#post{{{wtfpostid}}} {{{wtfthread}}}] <br /><div style="margin-left: 4em;"><small>{{{wtfpostcount}}} Posts, Updated {{{wtfdate}}} </small></div> }} | ||
| + | </table> | ||
| + | </div> | ||
{{col-end}} | {{col-end}} | ||
| + | ==Random Characters== | ||
| + | <div style="width: 100%; text-align: center; height: 180px; overflow: hidden;"> | ||
| + | {{#ask: [[Category:Characters]] [[Character Status::Active]] [[PC or NPC::PC]] |?Venue |?Player |searchlabel=|limit=30|order=random|link=none|format=template|template=Template:Askpc/Format/Mainpage}} | ||
| + | </div> | ||
{{Help}} | {{Help}} | ||
Latest revision as of 16:49, 10 March 2020
Welcome to The Edge of Darkness
Changeling |
Mage
|
Vampire
|
Werewolf |
Random Characters
| ||||||||||||||||||||
