Vampire
From Edge of Darkness Wiki
Vampire
m |
m |
||
Line 24: | Line 24: | ||
<td style="width: auto; padding: 1px 1em 0; valign="top"> | <td style="width: auto; padding: 1px 1em 0; valign="top"> | ||
- | <div style="border-bottom: 1px dimgrey solid; color:#800000; text-align: top; font-size: 125%;">'''Current Scenes'''</div> | + | <div style="border-bottom: 1px dimgrey solid; margin-bottom: 5px; color:#800000; text-align: top; font-size: 125%;">'''Current Scenes'''</div> |
- | <div>< | + | |
+ | <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 (5,210,61,200) 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 | ||
+ | }} | ||
+ | <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>{{{vtruserid}}}<html>"><img title="</html>{{{vtrposter}}}<html>"src="http://nwod.org/forum/image.php?u=</html>{{{vtruserid}}}<html>" width="38" /></a></div></html> [http://nwod.org/forum/showthread.php?p={{{vtrpostid}}}#post{{{vtrpostid}}} {{{vtrthread}}}] <br /><div style="margin-left: 4em;"><small>{{{vtrpostcount}}} Posts, Updated {{{vtrdate}}} </small></div> }} | ||
+ | </table> | ||
+ | </div> | ||
<td style="width: auto; padding: 1px 1em 0;" valign="top"> | <td style="width: auto; padding: 1px 1em 0;" valign="top"> | ||
- | <div style="border-bottom: 1px dimgrey solid; color:#800000; font-size: 125%;">'''Current Characters'''</div> | + | <div style="border-bottom: 1px dimgrey solid; margin-bottom: 5px; color:#800000; font-size: 125%;">'''Current Characters'''</div> |
- | <div style="font-size: 85%;">{{#ask: [[Concept:Active Vampires]]|format = | + | <div style="font-size: 85%;">{{#ask: [[Concept:Active Vampires]] |?Domain Title= | format= template |link=none |template=Status-Table}}</div> |
<td style="width: auto; padding: 1px 1em 0; valign="top"> | <td style="width: auto; padding: 1px 1em 0; valign="top"> | ||
<div style="border-bottom: 1px dimgrey solid; color:#800000; font-size: 125%; white-space: nowrap;">'''Scenes & Stories'''</div> | <div style="border-bottom: 1px dimgrey solid; color:#800000; font-size: 125%; white-space: nowrap;">'''Scenes & Stories'''</div> | ||
- | <div style="font-size: 85%;">{{#ask: [[Event for::Vampire]]|sort=Sacramento date |order=desc |format = ul |columns= | + | <div style="font-size: 85%;">{{#ask: [[Event for::Vampire]]|sort=Sacramento date |order=desc |format = ul |columns=1 |limit=40}}</div> |
<div style="font-size: 85%;">* All [[:Category:Vampire Scenes|Vampire Scenes]]</div> | <div style="font-size: 85%;">* All [[:Category:Vampire Scenes|Vampire Scenes]]</div> | ||
<br> | <br> |
Revision as of 17:34, 5 June 2016
|