Guardians of the Veil/Masques

@@ Line 1: / Line 1: @@
 {{#get_db_data:db=nwod
-	|from=user JOIN userfield ON (userfield.userid = user.userid)
+	|from=post JOIN thread ON (thread.threadid = post.threadid) JOIN forum ON (forum.forumid = thread.forumid)
-	|where=user.usergroupid LIKE '50'
+	|where=thread.forumid IN (8,221,242,258) group by thread.title order by thread.lastpost desc LIMIT 20
-	|data=lastpost=from_unixtime(user.lastpost, '%M %D %Y'),lastactivity=from_unixtime(user.lastactivity, '%M %D %Y'),venue=user.lastpostid,username=userfield.field109
+	|data=mageforum=forum.title AS forum, magethread=thread.title, magedate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, mageposter=thread.lastposter, magepostcount=count(postid), magepostid=post.postid, mageforumid=thread.forumid
 }}
 <table style="width:100%">
-{{#for_external_table: <tr><td>[[{{{username}}}]]</td><td>{{{lastpost}}}</td></tr>}}
+{{#for_external_table: [http://nwod.org/forum/showthread.php?p={{{magepostid}}}#post{{{magepostid}}} {{{magethread}}}] <br /><div style="margin-left: 1.6em;"><small>{{{magepostcount}}} Posts, Last By: '''{{{mageposter}}}''' {{{magedate}}}</small></div> }}
 </table>

Revision as of 16:04, 5 June 2016