Template:Character
From Edge of Darkness Wiki
Character
m |
m |
||
| Line 1: | Line 1: | ||
| - | + | <includeonly>{{#switch:{{{Player Name|}}} | |
| - | + | ||
|NPC= | |NPC= | ||
|{{#ask: [[User:{{{Player Name|}}}]] |?forumid= |?forumname= |format=template |template=PlayerAvatar }} | |{{#ask: [[User:{{{Player Name|}}}]] |?forumid= |?forumname= |format=template |template=PlayerAvatar }} | ||
| - | }}<!-- DB | + | }}<!-- DB FOR USER INFO -->{{#switch: {{{minisheet|}}} |
| - | + | |1={{#get_db_data:db=nwod | |
| - | + | |from=user JOIN userfield ON (userfield.userid = user.userid) | |
| - | + | |where=user.userid='{{{forumid|}}}' | |
| - | + | |data={{{forumid|}}}forumid=user.userid,{{{forumid|}}}posts=user.posts,{{{forumid|}}}lastpost=from_unixtime(user.lastpost, '%M %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(user.lastactivity, '%M %D %Y'),{{{forumid|}}}lastpostid=user.lastpostid,{{{forumid|}}}venue=userfield.field101,{{{forumid|}}}family=userfield.field211,{{{forumid|}}}organization=userfield.field212,{{{forumid|}}}statusvenue=userfield.field165,{{{forumid|}}}statusorganization=userfield.field166,{{{forumid|}}}statusfamily=userfield.field167,{{{forumid|}}}presence=userfield.field132,{{{forumid|}}}adv=userfield.field159,{{{forumid|}}}mask=userfield.field173 | |
| - | + | }}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}} | |
| - | + | |Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character | |
| - | + | |Venue={{#external_value:{{{forumid|}}}venue}} | |
| - | }} | + | |Character Type={{#external_value:{{{forumid|}}}venue}} |
| - | + | ||
| - | | | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
}} | }} | ||
| + | |2={{#get_db_data:db=nwod | ||
| + | |from=user | ||
| + | |where=userid='{{{forumid|}}}' | ||
| + | |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:Minisheet{{{minisheet|}}}={{PAGENAME}}}}{{#set:Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character|Venue={{#external_value:{{{forumid|}}}venue}}|Character Type={{#external_value:{{{forumid|}}}venue}} }}{{#get_db_data:db=nwod | ||
| + | |from=userfield | ||
| + | |where=userid='{{{forumid|}}}' |data={{{forumid|}}}venue=field102,{{{forumid|}}}family=field238,{{{forumid|}}}organization=field241,{{{forumid|}}}statusvenue=field244,{{{forumid|}}}statusorganization=field251,{{{forumid|}}}statusfamily=field248,{{{forumid|}}}presence=field181,{{{forumid|}}}adv=field161,{{{forumid|}}}mask=field257 | ||
| + | }} | ||
| + | |3={{#get_db_data:db=nwod | ||
| + | |from=user | ||
| + | |where=userid='{{{forumid|}}}' | ||
| + | |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:Minisheet{{{minisheet|}}}={{PAGENAME}}}}{{#set:Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character|Venue={{#external_value:{{{forumid|}}}venue}}|Character Type={{#external_value:{{{forumid|}}}venue}} }}{{#get_db_data:db=nwod | ||
| + | |from=userfield | ||
| + | |where=userid='{{{forumid|}}}' |data={{{forumid|}}}venue=field103,{{{forumid|}}}family=field239,{{{forumid|}}}organization=field242,{{{forumid|}}}statusvenue=field245,{{{forumid|}}}statusorganization=field252,{{{forumid|}}}statusfamily=field249,{{{forumid|}}}presence=field236,{{{forumid|}}}adv=field255,{{{forumid|}}}mask=field258 | ||
| + | }} | ||
| + | |4={{#get_db_data:db=nwod | ||
| + | |from=user | ||
| + | |where=userid='{{{forumid|}}}' | ||
| + | |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:Minisheet{{{minisheet|}}}={{PAGENAME}}}}{{#set:Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character|Venue={{#external_value:{{{forumid|}}}venue}}|Character Type={{#external_value:{{{forumid|}}}venue}} }}{{#get_db_data:db=nwod | ||
| + | |from=userfield | ||
| + | |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 | ||
| + | }} | ||
| + | |{{#get_db_data:db=nwod | ||
| + | |from=user | ||
| + | |where=userid='{{{forumid|}}}' | ||
| + | |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 VENUE FROM MINISHEET OR TEMPLATE DECLARATION -->{{#if:{{#external_value:{{{forumid|}}}venue}} | }}<!-- SET VENUE FROM MINISHEET OR TEMPLATE DECLARATION -->{{#if:{{#external_value:{{{forumid|}}}venue}} | ||
|{{#set:Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character|Venue={{#external_value:{{{forumid|}}}venue}}|Character Type={{#external_value:{{{forumid|}}}venue}} }} | |{{#set:Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character|Venue={{#external_value:{{{forumid|}}}venue}}|Character Type={{#external_value:{{{forumid|}}}venue}} }} | ||
| Line 43: | Line 60: | ||
}} | }} | ||
}}<!---- END DB GET ---->{{#set: | }}<!---- END DB GET ---->{{#set: | ||
| - | Posted={{#external_value: {{{forumid|}}}lastpost }} | + | forumid={{{forumid|}}} |
| + | |Player=User:{{{Player Name|}}} | ||
| + | |Posted={{#external_value: {{{forumid|}}}lastpost }} | ||
|Online={{#external_value: {{{forumid|}}}lastvisit }} | |Online={{#external_value: {{{forumid|}}}lastvisit }} | ||
|Last Post=[http://nwod.org/forum/showpost.php?p={{#external_value:{{{forumid|}}}lastpostid}} Last Post] | |Last Post=[http://nwod.org/forum/showpost.php?p={{#external_value:{{{forumid|}}}lastpostid}} Last Post] | ||
| Line 49: | Line 68: | ||
|Character Name={{PAGENAME}} | |Character Name={{PAGENAME}} | ||
|Character Status={{{Status|}}} | |Character Status={{{Status|}}} | ||
| + | |Avatar={{#if: {{{Avatar|}}}|{{{Avatar|}}}|Unknown}} | ||
|Lived In=Sacramento | |Lived In=Sacramento | ||
|Sacramento Start={{{Inception|}}} | |Sacramento Start={{{Inception|}}} | ||
| + | |Sacramento End={{#if: {{{Departed|}}}|{{{Departed|}}}|}} | ||
|Tenure={{#expr: | |Tenure={{#expr: | ||
{{#expr: {{#time: xNU|{{#show: {{PAGENAME}} |?Sacramento End }}|}} - {{#time: xNU|{{#show: {{PAGENAME}} |?Sacramento Start }}|}} }} / 31536000 round 1 | {{#expr: {{#time: xNU|{{#show: {{PAGENAME}} |?Sacramento End }}|}} - {{#time: xNU|{{#show: {{PAGENAME}} |?Sacramento Start }}|}} }} / 31536000 round 1 | ||
}} | }} | ||
| - | + | }}<!-- BEGIN VENUES --><div class="{{#show: {{PAGENAME}} |?Venue# }}page chartempwrapper {{#show: {{PAGENAME}} |?Venue# }}back" style="min-width: 850px;"> | |
<div class="grade05 chartempheader" > | <div class="grade05 chartempheader" > | ||
{{#switch: {{#show: {{PAGENAME}} |?Venue# }} | {{#switch: {{#show: {{PAGENAME}} |?Venue# }} | ||
| Line 253: | Line 274: | ||
|}}{{#switch:{{{Retainer Type|}}} | |}}{{#switch:{{{Retainer Type|}}} | ||
|Ghoul = <div class="Ghoulbordercolor" style="float: right; margin-left: 10px; text-align: center;">[[Image:{{{Retainer Of|}}}.jpg|100px|alt={{{Retainer Of|}}}|link={{{Retainer Of|}}}]]</div> | |Ghoul = <div class="Ghoulbordercolor" style="float: right; margin-left: 10px; text-align: center;">[[Image:{{{Retainer Of|}}}.jpg|100px|alt={{{Retainer Of|}}}|link={{{Retainer Of|}}}]]</div> | ||
| - | |}}{{dontshow|{{#for_external_table: [[{{{{{{forumid|}}}statusgiven}}}::{{{{{{forumid|}}}statusfor}}}]] }}}}</includeonly> | + | |}}{{dontshow|{{#for_external_table: [[{{{{{{forumid|}}}statusgiven}}}::{{{{{{forumid|}}}statusfor}}}]] }}}}</includeonly><noinclude>{{documentation}}[[Category:Character Templates|{{PAGENAME}}]]</noinclude> |
Revision as of 13:58, 23 May 2016
[create]
Template documentation
| Editors can experiment in this template's sandbox (create). Subpages of this template: |