Main Page
From Edge of Darkness Wiki
Main Page
(→Changeling) |
|||
| Line 26: | Line 26: | ||
{{#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 | ||
}} | }} | ||
| Line 46: | Line 46: | ||
{{#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 | ||
}} | }} | ||
| Line 67: | Line 67: | ||
{{#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 | ||
}} | }} | ||
Revision as of 17:15, 29 January 2017
Welcome to The Edge of Darkness
Changeling Open |
Mage Open
|
Vampire Open
|
| ||||||||||||||||||||
