Sandbox
From Edge of Darkness Wiki
Sandbox
(moved Sandbox to Mage Timeline) |
|||
Line 1: | Line 1: | ||
- | # | + | {{#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) | ||
+ | |where=thread.forumid IN (7) group by thread.title order by thread.lastpost desc LIMIT 10 | ||
+ | |data=wtfforum=forum.title AS forum, wtfthread=thread.title, wtfdate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, wtfposter=thread.lastposter, wtfpostcount=count(postid), wtfpostid=post.postid, wtfforumid=thread.forumid, wtfuserid=user.userid | ||
+ | }} | ||
+ | |||
+ | |||
+ | {{#get_db_data:db=nwod | ||
+ | |from=characters | ||
+ | |where=status == 'Active' | ||
+ | |data=char_name | ||
+ | }} |
Revision as of 15:53, 10 March 2020