Main Page
From Edge of Darkness Wiki
Main Page
m |
m |
||
Line 15: | Line 15: | ||
</div> | </div> | ||
{{clear left}} | {{clear left}} | ||
+ | <div style="margin-right: 30px; 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) | + | |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 20 | |where=thread.forumid IN (9,209,98,243) group by thread.title order by thread.lastpost desc LIMIT 20 | ||
- | |data= | + | |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: [http://nwod.org/forum/showthread.php?p={{{ | + | {{#for_external_table: <html><div style="margin-right: 5px; float: left; height: 38px; width: 38px; overflow: hidden; border-radius: 50%;" ><img src="http://nwod.org/forum/image.php?u=</html>{{{ctluserid}}}<html>" width="38" /></div></html> [http://nwod.org/forum/showthread.php?p={{{ctlpostid}}}#post{{{ctlpostid}}} {{{ctlthread}}}] <br /><div style="margin-left: 4em;"><small>{{{ctlpostcount}}} Posts, Last By: [http://nwod.org/forum/member.php?{{{ctluserid}}} {{{ctlposter}}}], {{{ctldate}}} </small></div> }} |
</table> | </table> | ||
+ | </div> | ||
{{col-break|width=33%}} | {{col-break|width=33%}} | ||
Line 32: | Line 34: | ||
</div> | </div> | ||
{{clear left}} | {{clear left}} | ||
+ | <div style="margin-right: 30px; 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) | + | |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 20 | |where=thread.forumid IN (8,221,242,258) group by thread.title order by thread.lastpost desc LIMIT 20 | ||
- | |data=mageforum=forum.title AS forum, magethread=thread.title, magedate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, mageposter=thread.lastposter, magepostcount=count(postid), magepostid=post.postid, mageforumid=thread.forumid | + | |data=mageforum=forum.title AS forum, magethread=thread.title, magedate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, mageposter=thread.lastposter, magepostcount=count(postid), magepostid=post.postid, mageforumid=thread.forumid, mageuserid=user.userid |
}} | }} | ||
<table style="width:100%"> | <table style="width:100%"> | ||
- | {{#for_external_table: [http://nwod.org/forum/showthread.php?p={{{magepostid}}}#post{{{magepostid}}} {{{magethread}}}] <br /><div style="margin-left: | + | {{#for_external_table: <html><div style="margin-right: 5px; float: left; height: 38px; width: 38px; overflow: hidden; border-radius: 50%;" ><img src="http://nwod.org/forum/image.php?u=</html>{{{mageuserid}}}<html>" width="38" /></div></html> [http://nwod.org/forum/showthread.php?p={{{magepostid}}}#post{{{magepostid}}} {{{magethread}}}] <br /><div style="margin-left: 4em;"><small>{{{magepostcount}}} Posts, Last By: [http://nwod.org/forum/member.php?{{{mageuserid}}} {{{mageposter}}}], {{{magedate}}} </small></div> }} |
</table> | </table> | ||
+ | </div> | ||
Line 50: | Line 54: | ||
</div> | </div> | ||
{{clear left}} | {{clear left}} | ||
+ | <div style="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) | + | |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 20 | |where=thread.forumid IN (5,210,61,200) group by thread.title order by thread.lastpost desc LIMIT 20 | ||
- | |data=vampireforum=forum.title AS forum, vampirethread=thread.title, vampiredate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, vampireposter=thread.lastposter, vampirepostcount=count(postid), vampirepostid=post.postid, vampireforumid=thread.forumid | + | |data=vampireforum=forum.title AS forum, vampirethread=thread.title, vampiredate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, vampireposter=thread.lastposter, vampirepostcount=count(postid), vampirepostid=post.postid, vampireforumid=thread.forumid, vampireuserid=user.userid |
}} | }} | ||
<table style="width:100%"> | <table style="width:100%"> | ||
- | {{#for_external_table: [http://nwod.org/forum/showthread.php?p={{{vampirepostid}}}#post{{{vampirepostid}}} {{{vampirethread}}}] <br /><div style="margin-left: | + | {{#for_external_table: <html><div style="margin-right: 5px; float: left; height: 38px; width: 38px; overflow: hidden; border-radius: 50%;" ><img src="http://nwod.org/forum/image.php?u=</html>{{{vampireuserid}}}<html>" width="38" /></div></html> [http://nwod.org/forum/showthread.php?p={{{vampirepostid}}}#post{{{vampirepostid}}} {{{vampirethread}}}] <br /><div style="margin-left: 4em;"><small>{{{vampirepostcount}}} Posts, Last By: [http://nwod.org/forum/member.php?{{{vampireuserid}}} {{{vampireposter}}}], {{{vampiredate}}} </small></div> }} |
</table> | </table> | ||
+ | </div> | ||
Revision as of 16:36, 5 June 2016
Welcome to The Edge of Darkness,
a site for role-play based on White-Wolf's New World of Darkness setting.
ChangelingOpen |
MageOpen
|
VampireOpen
|
|