Template:Character
From Edge of Darkness Wiki
Character
m |
m |
||
| Line 41: | Line 41: | ||
|data={{{forumid|}}}forumid=userid,{{{forumid|}}}posts=posts,{{{forumid|}}}lastpost=from_unixtime(lastpost, '%M %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(lastactivity, '%M %D %Y'),{{{forumid|}}}lastpostid=lastpostid | |data={{{forumid|}}}forumid=userid,{{{forumid|}}}posts=posts,{{{forumid|}}}lastpost=from_unixtime(lastpost, '%M %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(lastactivity, '%M %D %Y'),{{{forumid|}}}lastpostid=lastpostid | ||
}}{{#set:Page has default form=Edit {{{Venue|}}} Character|Venue={{{Venue|}}}|Character Type={{{Venue|}}}}} | }}{{#set:Page has default form=Edit {{{Venue|}}} Character|Venue={{{Venue|}}}|Character Type={{{Venue|}}}}} | ||
| - | }}<!-- DB FROM VENUE FOR QUOTES PAGE -->{{#get_db_data:db=nwod | + | }}<!-- DB FROM VENUE FOR QUOTES PAGE -->{{#switch: {{#show: {{PAGENAME}} |?Venue# }} |
| - | + | |Changeling = {{#get_db_data:db=nwod | |
| - | + | |from=post JOIN thread ON (thread.threadid = post.threadid) | |
| - | + | |where=thread.forumid IN (98) AND post.iconid IN (50,51,52,53,54) AND post.userid = '{{{forumid|}}}' AND thread.prefixid IN ('freehold_status') AND thread.lastpost >= UNIX_TIMESTAMP()-10000000 | |
| + | |data={{{forumid|}}}statusfor=thread.title,{{{forumid|}}}statusgiven=(case when post.iconid = 50 then 'Acknowledges' when post.iconid = 51 then 'Recognizes' when post.iconid = 52 then 'Values' when post.iconid = 53 then 'Respects' when post.iconid = 54 then 'Admires' end) | ||
| + | }} | ||
| + | |Mage = {{#get_db_data:db=nwod | ||
| + | |from=post JOIN thread ON (thread.threadid = post.threadid) | ||
| + | |where=thread.forumid IN (258) AND post.iconid IN (50,51,52,53,54) AND post.userid = '{{{forumid|}}}' AND thread.prefixid IN ('consilium') AND thread.lastpost >= UNIX_TIMESTAMP()-10000000 | ||
| + | |data={{{forumid|}}}statusfor=thread.title,{{{forumid|}}}statusgiven=(case when post.iconid = 50 then 'Acknowledges' when post.iconid = 51 then 'Recognizes' when post.iconid = 52 then 'Values' when post.iconid = 53 then 'Respects' when post.iconid = 54 then 'Admires' end) | ||
| + | }} | ||
| + | |Vampire = {{#get_db_data:db=nwod | ||
| + | |from=post JOIN thread ON (thread.threadid = post.threadid) | ||
| + | |where=thread.forumid IN (61) AND post.iconid IN (50,51,52,53,54) AND post.userid = '{{{forumid|}}}' AND thread.prefixid IN ('City') AND thread.lastpost >= UNIX_TIMESTAMP()-10000000 | ||
| + | |data={{{forumid|}}}statusfor=thread.title,{{{forumid|}}}statusgiven=(case when post.iconid = 50 then 'Acknowledges' when post.iconid = 51 then 'Recognizes' when post.iconid = 52 then 'Values' when post.iconid = 53 then 'Respects' when post.iconid = 54 then 'Admires' end) | ||
| + | }} | ||
}}<!---- END DB GET ---->{{#set: | }}<!---- END DB GET ---->{{#set: | ||
forumid={{{forumid|}}} | forumid={{{forumid|}}} | ||
Revision as of 15:25, 23 May 2016
[create] 
Template documentation
Template documentation| Editors can experiment in this template's sandbox (create). Subpages of this template: |
