Main Page
From Edge of Darkness Wiki
Main Page
(→Changeling) |
|||
Line 25: | Line 25: | ||
<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) JOIN userfield ON (userfield.userid = user.userid) LEFT JOIN customavatar ON (customavatar.userid = user.userid) |
- | |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=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, |
+ | ctlhasavatar=customavatar.visible AS hasavatar, | ||
+ | ctloneaccount=field260 AS oneaccount, | ||
+ | ctlshortname=LEFT(user.username, 1) AS shortname | ||
}} | }} | ||
<table style="width:100%"> | <table style="width:100%"> | ||
Line 35: | Line 38: | ||
{{col-break|width=33%}} | {{col-break|width=33%}} | ||
+ | |||
==[[Mage]]== | ==[[Mage]]== | ||
{{#ask: [[Concept:PCA Mage]] |?Venue |?Player |searchlabel=|limit=1|order=random|link=none|format=template|template=Template:Askpc/Format/Mainpage}} | {{#ask: [[Concept:PCA Mage]] |?Venue |?Player |searchlabel=|limit=1|order=random|link=none|format=template|template=Template:Askpc/Format/Mainpage}} |
Revision as of 17:30, 27 January 2017
Welcome to The Edge of Darkness
ChangelingOpen |
MageOpen
|
VampireOpen
|
|