Werewolf
From Edge of Darkness Wiki
Werewolf
Line 25: | Line 25: | ||
<table width="100%"><tr> | <table width="100%"><tr> | ||
<td style="padding: 1px 1em 0;" valign="top"> | <td style="padding: 1px 1em 0;" valign="top"> | ||
- | <div style="border-bottom: 1px dimgrey solid; color:#664834;">''' | + | <div style="border-bottom: 1px dimgrey solid; color:#664834;">'''Current Scenes'''</div> |
- | <div style=" | + | <div style="margin-right: 40px; white-space: nowrap; overflow: hidden;"> |
+ | {{#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) 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 | ||
+ | }} | ||
+ | <table style="width:100%"> | ||
+ | {{#for_external_table: <html><div style="margin-right: 5px; float: left; height: 38px; width: 38px; overflow: hidden; border-radius: 50%;" ><a href="http://nwod.org/forum/member.php?</html>{{{mtauserid}}}<html>"><img title="</html>{{{mtaposter}}}<html>"src="http://nwod.org/forum/image.php?u=</html>{{{mtauserid}}}<html>" width="38" /></a></div></html> [http://nwod.org/forum/showthread.php?p={{{mtapostid}}}#post{{{mtapostid}}} {{{mtathread}}}] <br /><div style="margin-left: 4em;"><small>{{{mtapostcount}}} Posts, Updated {{{mtadate}}} </small></div> }} | ||
+ | </table> | ||
+ | </div> | ||
<td style="padding: 1px 1em 0;" valign="top"> | <td style="padding: 1px 1em 0;" valign="top"> | ||
Line 38: | Line 47: | ||
<td style="padding: 1px 1em 0;" valign="top"> | <td style="padding: 1px 1em 0;" valign="top"> | ||
- | <div style="border-bottom: 1px dimgrey solid; color:#664834;">'''Scenes'''</div> | + | <div style="border-bottom: 1px dimgrey solid; color:#664834;">'''Scenes & Stories'''</div> |
- | <div style="color:#664834;">{{#ask: [[Category:Werewolf Scenes]]| | + | <div style="color:#664834;">{{#ask: [[Category:Werewolf Scenes]]|limit=15 |sort=Sacramento date |order=desc |format = ul |columns=1}}</div> |
- | + | ||
- | + | ||
- | + | ||
- | + | ||
</td></tr></table> | </td></tr></table> | ||
</div> | </div> |
Revision as of 13:27, 11 July 2017
|