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) AND thread.open = 1 group by thread.title order by thread.lastpost desc LIMIT 20 | + | |where=thread.forumid IN (8,242,221) AND thread.open = 1 AND thread.lastpost >= UNIX_TIMESTAMP()-30*24*60*60 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 | ||
}} | }} | ||
Revision as of 03:25, 8 August 2016
| ||||||||||||||||||||||
