Vampire
From Edge of Darkness Wiki
Vampire
m |
m |
||
| Line 33: | Line 33: | ||
{{#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 20 | + | |where=thread.forumid IN (5,210,61,200) 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=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 03:26, 8 August 2016
| |||||||||||||||||
