Template:Character
From Edge of Darkness Wiki
Character
m |
m |
||
| Line 6: | Line 6: | ||
|where=userid='{{{forumid|}}}' | |where=userid='{{{forumid|}}}' | ||
|data={{{forumid|}}}forumid=userid,{{{forumid|}}}posts=posts,{{{forumid|}}}lastactivity=lastpost | |data={{{forumid|}}}forumid=userid,{{{forumid|}}}posts=posts,{{{forumid|}}}lastactivity=lastpost | ||
| - | }}{{#switch: {{{minisheet|}}} | + | }}{{#get_db_data:db=nwod |
| + | |from=userlist | ||
| + | |where=userid='{{{forumid|}}}' and type='buddy' and friend='yes' | ||
| + | |data={{{forumid|}}}friend=relationid | ||
| + | }}{{#get_db_data:db=nwod | ||
| + | |from=userlist | ||
| + | |where=userid='{{{forumid|}}}' and type='buddy' and friend='no' | ||
| + | |data={{{forumid|}}}contact=relationid | ||
| + | }}{{#arraymap:{{#for_external_table: {{{{{{forumid|}}}friend}}}, }}|,|xxx|{{#set:Friend To=xxx}}}}{{#arraymap:{{#for_external_table: {{{{{{forumid|}}}contact}}}, }}|,|yyy|{{#set:Connected To=yyy}}}}{{#switch: {{{minisheet|}}} | ||
|1={{#get_db_data:db=nwod | |1={{#get_db_data:db=nwod | ||
|from=userfield | |from=userfield | ||
| Line 21: | Line 29: | ||
}}{{#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 = {{#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 = | + | |Mage = {{#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}}}} | {{#set:Order Status={{#external_value:{{{forumid|}}}statusorganization}}}} | ||
| Line 33: | Line 38: | ||
|{{#set:venue={{#external_value:{{{forumid|}}}venue}}}} | |{{#set:venue={{#external_value:{{{forumid|}}}venue}}}} | ||
{{#set:presence={{#external_value:{{{forumid|}}}presence}}}} | {{#set:presence={{#external_value:{{{forumid|}}}presence}}}} | ||
| - | }}<!---- END DB GET ----> | + | }}<!---- END DB GET ---->{{#set: Page has default form=Add {{#show: {{PAGENAME}} |?Venue# }} Character|Tenure={{#expr: {{#expr: {{#time: xNU|{{#show: {{PAGENAME}} |?Sacramento End }}|}} - {{#time: xNU|{{#show: {{PAGENAME}} |?Sacramento Start }}|}} }} / 31536000 round 1 }}|Player=User:{{{Player Name|}}}|Character Name={{PAGENAME}}|Character Status={{{Status|}}}|Player=User:{{{Player Name|}}}|Sacramento Start={{{Inception|}}}|Lived In=Sacramento}}{{#if: {{{Departed|}}}|{{#set:Sacramento End={{{Departed|}}}}}|}}{{#if: {{{Venue|}}}|{{#set:Character Type={{{Venue|}}}}}|}}<!-- BEGIN VENUES --><div class="{{#show: {{PAGENAME}} |?Venue# }}page chartempwrapper {{#show: {{PAGENAME}} |?Venue# }}back"> |
<div class="grade05 chartempheader" > | <div class="grade05 chartempheader" > | ||
{{#switch: {{#show: {{PAGENAME}} |?Venue# }} | {{#switch: {{#show: {{PAGENAME}} |?Venue# }} | ||
Revision as of 22:27, 9 May 2016
[create]
Template documentation
| Editors can experiment in this template's sandbox (create). Subpages of this template: |