Template:Character

From Edge of Darkness Wiki

Character
Jump to: navigation, search
m
m
Line 1: Line 1:
-
<noinclude>{{documentation}}[[Category:Character Templates|{{PAGENAME}}]]</noinclude><includeonly>
+
<includeonly>{{#switch:{{{Player Name|}}}
-
{{#set:forumid={{{forumid|}}}|Player=User:{{{Player Name|}}} }}{{#if: {{{Avatar|}}}|{{#set:Avatar={{{Avatar|}}}}}|{{#set:Avatar=Unknown}}}}{{#if: {{{Retired Avatar|}}}|{{#set:Retired Avatar={{{Avatar|}}}}}|}}{{#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 FROM USER FOR USER INFO -->{{#get_db_data:db=nwod
+
}}<!-- DB FOR USER INFO -->{{#switch: {{{minisheet|}}}
-
|from=user
+
|1={{#get_db_data:db=nwod
-
|where=userid='{{{forumid|}}}'
+
|from=user JOIN userfield ON (userfield.userid = user.userid)
-
|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
+
|where=user.userid='{{{forumid|}}}'
-
}}<!-- DB FROM MINISHEET NUMBER TO GET VENUE INFO -->{{#switch: {{{minisheet|}}}
+
|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
-
|1={{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}}}{{#get_db_data:db=nwod
+
}}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}
-
|from=userfield
+
|Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character
-
|where=userid='{{{forumid|}}}' |data={{{forumid|}}}venue=field101,{{{forumid|}}}family=field211,{{{forumid|}}}organization=field212,{{{forumid|}}}statusvenue=field165,{{{forumid|}}}statusorganization=field166,{{{forumid|}}}statusfamily=field167,{{{forumid|}}}presence=field132,{{{forumid|}}}adv=field159,{{{forumid|}}}mask=field173
+
|Venue={{#external_value:{{{forumid|}}}venue}}
-
}}
+
|Character Type={{#external_value:{{{forumid|}}}venue}}
-
|2={{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}}}{{#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={{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}}}{{#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={{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}}}{{#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
+
}}
}}
 +
|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  
}}
}}
-
}}{{#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" style="min-width: 850px;">
+
}}<!-- 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
Personal tools
Namespaces
Variants
Actions
Navigation
games
Toolbox