Template:Character
From Edge of Darkness Wiki
Character
m |
m |
||
| Line 4: | Line 4: | ||
|NPC= | |NPC= | ||
|{{#ask: [[User:{{{Player Name|}}}]] |?forumid= |?forumname= |format=template |template=PlayerAvatar }} | |{{#ask: [[User:{{{Player Name|}}}]] |?forumid= |?forumname= |format=template |template=PlayerAvatar }} | ||
| - | }}{{#get_db_data: | + | }}{{#get_db_data:db=nwod |
| - | db=nwod | + | |
|from=user | |from=user | ||
|where=username='{{#if: {{#show: {{PAGENAME}} |?forumname# }} |{{#show: {{PAGENAME}} |?forumname# }} |{{BASEPAGENAME}}}}' | |where=username='{{#if: {{#show: {{PAGENAME}} |?forumname# }} |{{#show: {{PAGENAME}} |?forumname# }} |{{BASEPAGENAME}}}}' | ||
|data={{PAGENAMEE}}forumid=userid,{{PAGENAMEE}}posts=posts,{{PAGENAMEE}}lastactivity=lastpost | |data={{PAGENAMEE}}forumid=userid,{{PAGENAMEE}}posts=posts,{{PAGENAMEE}}lastactivity=lastpost | ||
}}{{#if: {{#external_value:{{PAGENAMEE}}forumid}}| | }}{{#if: {{#external_value:{{PAGENAMEE}}forumid}}| | ||
| - | {{#set:Character forumid={{#external_value:{{PAGENAMEE}}forumid}}}} | + | {{#set:Character forumid={{#external_value:{{PAGENAMEE}}forumid}}}} |
| - | {{#set:Last Activity={{#time: M d Y |@{{#external_value: {{PAGENAMEE}}lastactivity }}}}}} | + | {{#set:Last Activity={{#time: M d Y |@{{#external_value: {{PAGENAMEE}}lastactivity }}}}}} |
| - | {{#set:Post Count={{#external_value:{{PAGENAMEE}}posts}}}} | + | {{#set:Post Count={{#external_value:{{PAGENAMEE}}posts}}}} |
| - | |}}{{#ifexist:{{#ask: [[Has Minisheet::{{PAGENAME}}]]|link=none}}|{{#set:forumid={{#ask: [[Has Minisheet::{{PAGENAME}}]]|mainlabel=- |?forumid= |link=none}}}}|}}{{#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|}}}|Presence={{{Presence|}}}|Sacramento Start={{{Inception|}}}|Lived In=Sacramento}}{{#if: {{{Venue|}}}|{{#set:Character Type={{{Venue|}}}}}|}}{{#if: {{{Departed|}}}|{{#set:Sacramento End={{{Departed|}}}}}|}}{{#if: {{{Avatar|}}}|{{#set:Avatar={{{Avatar|}}}}}|{{#set:Avatar=Unknown}}}}{{#if: {{{Retired Avatar|}}}|{{#set:Retired Avatar={{{Avatar|}}}}}|}}{{#if: {{{Acknowledges|}}}|{{#arraymap:{{{Acknowledges|}}}|,|x|{{#set:Acknowledges=x}}}}|}}{{#if: {{{Recognizes|}}}|{{#arraymap:{{{Recognizes|}}}|,|x|{{#set:Recognizes=x}}}}|}}{{#if: {{{Values|}}}|{{#arraymap:{{{Values|}}}|,|x|{{#set:Values=x}}}}|}}{{#if: {{{Respects|}}}|{{#arraymap:{{{Respects|}}}|,|x|{{#set:Respects=x}}}}|}}{{#if: {{{Admires|}}}|{{#arraymap:{{{Admires|}}}|,|x|{{#set:Admires=x}}}}|}}<!-- BEGIN VENUES --><div class="{{#show: {{PAGENAME}} |?Venue# }}page chartempwrapper {{#show: {{PAGENAME}} |?Venue# }}back"> | + | |}}{{#get_db_data:db=nwod |
| + | |from=userfield | ||
| + | |where=userid='{{#external_value:{{PAGENAMEE}}forumid}}' | ||
| + | |data={{PAGENAMEE}}101=field101,{{PAGENAMEE}}211=field211,{{PAGENAMEE}}212=field212 | ||
| + | }}{{#set:field101={{#external_value:{{PAGENAMEE}}101}}}}{{#set:field1211={{#external_value:{{PAGENAMEE}}211}}}}{{#set:field1212={{#external_value:{{PAGENAMEE}}212}}}}{{#ifexist:{{#ask: [[Has Minisheet::{{PAGENAME}}]]|link=none}}|{{#set:forumid={{#ask: [[Has Minisheet::{{PAGENAME}}]]|mainlabel=- |?forumid= |link=none}}}}|}}{{#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|}}}|Presence={{{Presence|}}}|Sacramento Start={{{Inception|}}}|Lived In=Sacramento}}{{#if: {{{Venue|}}}|{{#set:Character Type={{{Venue|}}}}}|}}{{#if: {{{Departed|}}}|{{#set:Sacramento End={{{Departed|}}}}}|}}{{#if: {{{Avatar|}}}|{{#set:Avatar={{{Avatar|}}}}}|{{#set:Avatar=Unknown}}}}{{#if: {{{Retired Avatar|}}}|{{#set:Retired Avatar={{{Avatar|}}}}}|}}{{#if: {{{Acknowledges|}}}|{{#arraymap:{{{Acknowledges|}}}|,|x|{{#set:Acknowledges=x}}}}|}}{{#if: {{{Recognizes|}}}|{{#arraymap:{{{Recognizes|}}}|,|x|{{#set:Recognizes=x}}}}|}}{{#if: {{{Values|}}}|{{#arraymap:{{{Values|}}}|,|x|{{#set:Values=x}}}}|}}{{#if: {{{Respects|}}}|{{#arraymap:{{{Respects|}}}|,|x|{{#set:Respects=x}}}}|}}{{#if: {{{Admires|}}}|{{#arraymap:{{{Admires|}}}|,|x|{{#set:Admires=x}}}}|}}<!-- 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 19:16, 7 May 2016
[create] 
Template documentation
Template documentation| Editors can experiment in this template's sandbox (create). Subpages of this template: |
