Vampire
From Edge of Darkness Wiki
Vampire
m |
|||
| (6 intermediate revisions not shown) | |||
| Line 1: | Line 1: | ||
{{#set:Venue Status={{#switch: {{#expr: {{#expr: {{#ask: [[Storyteller::Vampire]]|format=count}} * 15}} > {{#ask: [[Concept:PCA Vampire]]|format=count}} }} | {{#set:Venue Status={{#switch: {{#expr: {{#expr: {{#ask: [[Storyteller::Vampire]]|format=count}} * 15}} > {{#ask: [[Concept:PCA Vampire]]|format=count}} }} | ||
| - | | 0 = | + | | 0 = Open |
| 1 = Open | | 1 = Open | ||
}}}}__NOTOC__{{header|vtr}}[[Category:Information]]{{Vampire/Index}} | }}}}__NOTOC__{{header|vtr}}[[Category:Information]]{{Vampire/Index}} | ||
| 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 | ||
}} | }} | ||
| Line 43: | Line 43: | ||
<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; margin-bottom: 5px; 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%;">{{# | + | <div style="font-size: 85%;">{{#get_db_data:db=nwod |
| + | |from=characters | ||
| + | |where=characters.Status = 'Active' AND characters.Venue = 'Vampire' ORDER BY characters.char_name | ||
| + | |data=userid=characters.char_userid,name=characters.char_name | ||
| + | }} | ||
| + | {{#for_external_table: <html><div style="margin-top: 5px; margin-right: 5px; clear: left;"><div style="margin-top: 5px; margin-right: 5px; clear: left; float: left; height: 38px; width: 38px; overflow: hidden; border-radius: 50%;" ><a href="http://nwod.org/forum/member.php?</html>{{{userid}}}<html>" title="</html>{{{name}}}<html>"><img title="</html>{{{name}}}<html>"src="http://nwod.org/forum/image.php?u=</html>{{{userid}}}<html>" width="38" /></a></div><div style="padding-top: 10px;"><a href="http://nwod.org/forum/member.php?</html>{{{userid}}}<html>"></html>{{{name}}}<html></a></div></div></html> }}</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=1 |limit= | + | <div style="font-size: 85%;">{{#ask: [[Event for::Vampire]]|sort=Sacramento date |order=desc |format = ul |columns=1 |limit=15}}</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> | ||
Latest revision as of 13:23, 11 July 2017
| |||||||||||||||||
