Template:Character
From Edge of Darkness Wiki
Character
m |
m |
||
| Line 1: | Line 1: | ||
<noinclude>{{documentation}}[[Category:Character Templates|{{PAGENAME}}]]</noinclude><includeonly> | <noinclude>{{documentation}}[[Category:Character Templates|{{PAGENAME}}]]</noinclude><includeonly> | ||
| - | {{#set:forumid={{{forumid|}}}}} | + | {{#set:forumid={{{forumid|}}}}}{{#switch:{{{Player Name|}}} |
| - | {{#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 FROM USER FOR USER INFO -->{{#get_db_data:db=nwod | + | |
|from=user | |from=user | ||
|where=userid='{{{forumid|}}}' | |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 | |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 | ||
| - | }} | + | }}<!-- DB FROM MINISHEET NUMBER TO GET VENUE INFO -->{{#switch: {{{minisheet|}}} |
| - | <!-- DB FROM MINISHEET NUMBER TO GET VENUE INFO -->{{#switch: {{{minisheet|}}} | + | |
|1={{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}}}{{#get_db_data:db=nwod | |1={{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}}}{{#get_db_data:db=nwod | ||
|from=userfield | |from=userfield | ||
| Line 27: | Line 24: | ||
|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 | |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 | ||
}} | }} | ||
| - | }} | + | }}<!-- DB FROM VENUE FOR QUOTES PAGE -->{{#switch: {{#external_value:{{{forumid|}}}venue}} |
| - | <!-- DB FROM VENUE FOR QUOTES PAGE -->{{#switch: {{#external_value:{{{forumid|}}}venue}} | + | |
|Changeling = {{#get_db_data:db=nwod | |Changeling = {{#get_db_data:db=nwod | ||
|from=post JOIN thread ON (thread.threadid = post.threadid) | |from=post JOIN thread ON (thread.threadid = post.threadid) | ||
| Line 44: | Line 40: | ||
|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) | |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) | ||
}} | }} | ||
| - | }} | + | }}<!---- END DB GET ---->{{#set: |
| - | <!---- END DB GET ----> | + | |
| - | {{#set: | + | |
Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character | Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character | ||
|Player=User:{{{Player Name|}}} | |Player=User:{{{Player Name|}}} | ||
| Line 63: | Line 57: | ||
{{#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 style="border-radius: 5px; width: 99%; position: absolute; top: 3px; text-align: center;" ><span style="margin-right: 210px; padding: 5px 20px; border-radius: 20px;" class="{{#external_value:{{{forumid|}}}venue}}back" >[[{{PAGENAME}}/Quotes|{{#ifexist: {{PAGENAME}}/Quotes|View Quotes & Extra Info|Create Quotes & Extra Info Page}}]]</span></div><div class="{{#external_value:{{{forumid|}}}venue}}page chartempwrapper {{#external_value:{{{forumid|}}}venue}}back"> |
| - | {{#if: {{{Departed|}}}|{{#set:Sacramento End={{{Departed|}}}}}|}} | + | |
| - | {{#if: {{{Venue|}}}|{{#set:Character Type={{{Venue|}}}}}|}} | + | |
| - | <!-- BEGIN VENUES --><div style="border-radius: 5px; width: 99%; position: absolute; top: 3px; text-align: center;" ><span style="margin-right: 210px; padding: 5px 20px; border-radius: 20px;" class="{{#external_value:{{{forumid|}}}venue}}back" >[[{{PAGENAME}}/Quotes|{{#ifexist: {{PAGENAME}}/Quotes|View Quotes & Extra Info|Create Quotes & Extra Info Page}}]]</span></div><div class="{{#external_value:{{{forumid|}}}venue}}page chartempwrapper {{#external_value:{{{forumid|}}}venue}}back"> | + | |
<div class="grade05 chartempheader" > | <div class="grade05 chartempheader" > | ||
{{#switch: {{#external_value:{{{forumid|}}}venue}} | {{#switch: {{#external_value:{{{forumid|}}}venue}} | ||
Revision as of 14:32, 20 May 2016
[create] 
Template documentation
Template documentation| Editors can experiment in this template's sandbox (create). Subpages of this template: |
