Template:Character
From Edge of Darkness Wiki
Character
m |
m |
||
| Line 20: | Line 20: | ||
|where=userid='{{{forumid|}}}' |data={{{forumid|}}}venue=field104,{{{forumid|}}}family=field240,{{{forumid|}}}organization=field243,{{{forumid|}}}statusvenue=field247,{{{forumid|}}}statusorganization=field253,{{{forumid|}}}statusfamily=field250,{{{forumid|}}}presence=field237,{{{forumid|}}}adv=field256,{{{forumid|}}}mask=field259}}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}}} | |where=userid='{{{forumid|}}}' |data={{{forumid|}}}venue=field104,{{{forumid|}}}family=field240,{{{forumid|}}}organization=field243,{{{forumid|}}}statusvenue=field247,{{{forumid|}}}statusorganization=field253,{{{forumid|}}}statusfamily=field250,{{{forumid|}}}presence=field237,{{{forumid|}}}adv=field256,{{{forumid|}}}mask=field259}}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}}} | ||
}}{{#set:Venue={{#external_value:{{{forumid|}}}venue}}}}{{#set:Character Type={{#external_value:{{{forumid|}}}venue}}}}{{#set:Presence={{#external_value:{{{forumid|}}}presence}}}}{{#switch: {{#external_value:{{{forumid|}}}venue}} | }}{{#set:Venue={{#external_value:{{{forumid|}}}venue}}}}{{#set:Character Type={{#external_value:{{{forumid|}}}venue}}}}{{#set:Presence={{#external_value:{{{forumid|}}}presence}}}}{{#switch: {{#external_value:{{{forumid|}}}venue}} | ||
| - | |Changeling = {{#set:Seeming={{#external_value:{{{forumid|}}}family}}}} | + | |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) | ||
| + | }}{{#set:Seeming={{#external_value:{{{forumid|}}}family}}}} | ||
{{#set:Court={{#external_value:{{{forumid|}}}organization}}}} | {{#set:Court={{#external_value:{{{forumid|}}}organization}}}} | ||
{{#set:Mantle={{#external_value:{{{forumid|}}}statusorganization}}}} | {{#set:Mantle={{#external_value:{{{forumid|}}}statusorganization}}}} | ||
| - | |Mage = {{#set:Consilium Status={{#external_value:{{{forumid|}}}statusvenue}}}} | + | |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) | ||
| + | }}{{#set:Consilium Status={{#external_value:{{{forumid|}}}statusvenue}}}} | ||
{{#set:Path Status={{#external_value:{{{forumid|}}}statusfamily}}}} | {{#set:Path Status={{#external_value:{{{forumid|}}}statusfamily}}}} | ||
| + | {{#set:Order Status={{#external_value:{{{forumid|}}}statusorganization}}}} | ||
| + | |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) | ||
| + | }} | ||
{{#set:Order Status={{#external_value:{{{forumid|}}}statusorganization}}}} | {{#set:Order Status={{#external_value:{{{forumid|}}}statusorganization}}}} | ||
|Werewolf = {{#set:Auspice={{#external_value:{{{forumid|}}}family}}}} | |Werewolf = {{#set:Auspice={{#external_value:{{{forumid|}}}family}}}} | ||
| Line 113: | Line 127: | ||
</tr> | </tr> | ||
</table> | </table> | ||
| - | |Vampire= | + | |Vampire={{#switch: {{{Status|}}} |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
|Active = {{#if:{{{Domain Title|}}} |{{#set:Domain Title={{{Domain Title|}}} }} |}} | |Active = {{#if:{{{Domain Title|}}} |{{#set:Domain Title={{{Domain Title|}}} }} |}} | ||
{{#if:{{{Clan Title|}}} |{{#set:Clan Title={{{Clan Title|}}} }} |}} | {{#if:{{{Clan Title|}}} |{{#set:Clan Title={{{Clan Title|}}} }} |}} | ||
Revision as of 18:18, 18 May 2016
[create] 
Template documentation
Template documentation| Editors can experiment in this template's sandbox (create). Subpages of this template: |
