Mage
From Edge of Darkness Wiki
Mage
m |
m |
||
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 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 38: | Line 38: | ||
</td></tr></table> | </td></tr></table> | ||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
{{Footer|mta}}[[Category:Information]] | {{Footer|mta}}[[Category:Information]] |
Revision as of 03:20, 8 August 2016
|