Template:Character
From Edge of Darkness Wiki
Character
| Line 2: | Line 2: | ||
|1={{#get_db_data:db=nwod | |1={{#get_db_data:db=nwod | ||
|from=user JOIN userfield ON (userfield.userid = user.userid) | |from=user JOIN userfield ON (userfield.userid = user.userid) | ||
| - | |where=user.userid='{{{forumid|}}}' |data={{{forumid|}}}username=user.username,{{{forumid|}}}mainname=userfield.field164,{{{forumid|}}}mainid=userfield.field163,{{{forumid|}}}oneaccount=userfield.field260,{{{forumid|}}}forumid=user.userid,{{{forumid|}}}posts=user.posts,{{{forumid|}}}lastpost=from_unixtime(user.lastpost, '%b %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(user.lastactivity, '%b %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,{{{forumid|}}}usergroupid=user.usergroupid,{{{forumid|}}}joindate=from_unixtime(user.joindate, '%b %D %Y')}}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}} | + | |where=user.userid='{{{forumid|}}}' |data={{{forumid|}}}usertitle=user.usertitle,{{{forumid|}}}username=user.username,{{{forumid|}}}mainname=userfield.field164,{{{forumid|}}}mainid=userfield.field163,{{{forumid|}}}oneaccount=userfield.field260,{{{forumid|}}}forumid=user.userid,{{{forumid|}}}posts=user.posts,{{{forumid|}}}lastpost=from_unixtime(user.lastpost, '%b %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(user.lastactivity, '%b %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,{{{forumid|}}}usergroupid=user.usergroupid,{{{forumid|}}}joindate=from_unixtime(user.joindate, '%b %D %Y')}}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}} |
|Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character | |Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character | ||
|Venue={{#external_value:{{{forumid|}}}venue}} | |Venue={{#external_value:{{{forumid|}}}venue}} | ||
| Line 9: | Line 9: | ||
|2={{#get_db_data:db=nwod | |2={{#get_db_data:db=nwod | ||
|from=user JOIN userfield ON (userfield.userid = user.userid) | |from=user JOIN userfield ON (userfield.userid = user.userid) | ||
| - | |where=user.userid='{{{forumid|}}}' |data={{{forumid|}}}username=user.username,{{{forumid|}}}mainname=userfield.field164,{{{forumid|}}}mainid=userfield.field163,{{{forumid|}}}oneaccount=userfield.field260,{{{forumid|}}}forumid=user.userid,{{{forumid|}}}posts=user.posts,{{{forumid|}}}lastpost=from_unixtime(user.lastpost, '%b %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(user.lastactivity, '%b %D %Y'),{{{forumid|}}}lastpostid=user.lastpostid,{{{forumid|}}}venue=userfield.field102,{{{forumid|}}}family=userfield.field238,{{{forumid|}}}organization=userfield.field241,{{{forumid|}}}statusvenue=userfield.field244,{{{forumid|}}}statusorganization=userfield.field251,{{{forumid|}}}statusfamily=userfield.field248,{{{forumid|}}}presence=userfield.field181,{{{forumid|}}}adv=userfield.field161,{{{forumid|}}}mask=userfield.field257,{{{forumid|}}}usergroupid=user.usergroupid,{{{forumid|}}}joindate=from_unixtime(user.joindate, '%b %D %Y') | + | |where=user.userid='{{{forumid|}}}' |data={{{forumid|}}}usertitle=user.usertitle,{{{forumid|}}}username=user.username,{{{forumid|}}}mainname=userfield.field164,{{{forumid|}}}mainid=userfield.field163,{{{forumid|}}}oneaccount=userfield.field260,{{{forumid|}}}forumid=user.userid,{{{forumid|}}}posts=user.posts,{{{forumid|}}}lastpost=from_unixtime(user.lastpost, '%b %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(user.lastactivity, '%b %D %Y'),{{{forumid|}}}lastpostid=user.lastpostid,{{{forumid|}}}venue=userfield.field102,{{{forumid|}}}family=userfield.field238,{{{forumid|}}}organization=userfield.field241,{{{forumid|}}}statusvenue=userfield.field244,{{{forumid|}}}statusorganization=userfield.field251,{{{forumid|}}}statusfamily=userfield.field248,{{{forumid|}}}presence=userfield.field181,{{{forumid|}}}adv=userfield.field161,{{{forumid|}}}mask=userfield.field257,{{{forumid|}}}usergroupid=user.usergroupid,{{{forumid|}}}joindate=from_unixtime(user.joindate, '%b %D %Y') |
}}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}} | }}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}} | ||
|Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character | |Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character | ||
| Line 17: | Line 17: | ||
|3={{#get_db_data:db=nwod | |3={{#get_db_data:db=nwod | ||
|from=user JOIN userfield ON (userfield.userid = user.userid) | |from=user JOIN userfield ON (userfield.userid = user.userid) | ||
| - | |where=user.userid='{{{forumid|}}}' |data={{{forumid|}}}username=user.username,{{{forumid|}}}mainname=userfield.field164,{{{forumid|}}}mainid=userfield.field163,{{{forumid|}}}oneaccount=userfield.field260,{{{forumid|}}}forumid=user.userid,{{{forumid|}}}posts=user.posts,{{{forumid|}}}lastpost=from_unixtime(user.lastpost, '%b %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(user.lastactivity, '%b %D %Y'),{{{forumid|}}}lastpostid=user.lastpostid,{{{forumid|}}}venue=userfield.field103,{{{forumid|}}}family=userfield.field239,{{{forumid|}}}organization=userfield.field242,{{{forumid|}}}statusvenue=userfield.field245,{{{forumid|}}}statusorganization=userfield.field252,{{{forumid|}}}statusfamily=userfield.field249,{{{forumid|}}}presence=userfield.field236,{{{forumid|}}}adv=userfield.field255,{{{forumid|}}}mask=userfield.field258,{{{forumid|}}}usergroupid=user.usergroupid,{{{forumid|}}}joindate=from_unixtime(user.joindate, '%b %D %Y') | + | |where=user.userid='{{{forumid|}}}' |data={{{forumid|}}}usertitle=user.usertitle,{{{forumid|}}}username=user.username,{{{forumid|}}}mainname=userfield.field164,{{{forumid|}}}mainid=userfield.field163,{{{forumid|}}}oneaccount=userfield.field260,{{{forumid|}}}forumid=user.userid,{{{forumid|}}}posts=user.posts,{{{forumid|}}}lastpost=from_unixtime(user.lastpost, '%b %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(user.lastactivity, '%b %D %Y'),{{{forumid|}}}lastpostid=user.lastpostid,{{{forumid|}}}venue=userfield.field103,{{{forumid|}}}family=userfield.field239,{{{forumid|}}}organization=userfield.field242,{{{forumid|}}}statusvenue=userfield.field245,{{{forumid|}}}statusorganization=userfield.field252,{{{forumid|}}}statusfamily=userfield.field249,{{{forumid|}}}presence=userfield.field236,{{{forumid|}}}adv=userfield.field255,{{{forumid|}}}mask=userfield.field258,{{{forumid|}}}usergroupid=user.usergroupid,{{{forumid|}}}joindate=from_unixtime(user.joindate, '%b %D %Y') |
}}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}} | }}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}} | ||
|Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character | |Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character | ||
| Line 25: | Line 25: | ||
|4={{#get_db_data:db=nwod | |4={{#get_db_data:db=nwod | ||
|from=user JOIN userfield ON (userfield.userid = user.userid) | |from=user JOIN userfield ON (userfield.userid = user.userid) | ||
| - | |where=user.userid='{{{forumid|}}}' |data={{{forumid|}}}username=user.username,{{{forumid|}}}mainname=userfield.field164,{{{forumid|}}}mainid=userfield.field163,{{{forumid|}}}oneaccount=userfield.field260,{{{forumid|}}}forumid=user.userid,{{{forumid|}}}posts=user.posts,{{{forumid|}}}lastpost=from_unixtime(user.lastpost, '%b %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(user.lastactivity, '%b %D %Y'),{{{forumid|}}}lastpostid=user.lastpostid,{{{forumid|}}}venue=userfield.field104,{{{forumid|}}}family=userfield.field240,{{{forumid|}}}organization=userfield.field243,{{{forumid|}}}statusvenue=userfield.field247,{{{forumid|}}}statusorganization=userfield.field253,{{{forumid|}}}statusfamily=userfield.field250,{{{forumid|}}}presence=userfield.field237,{{{forumid|}}}adv=userfield.field256,{{{forumid|}}}mask=userfield.field259,{{{forumid|}}}usergroupid=user.usergroupid,{{{forumid|}}}joindate=from_unixtime(user.joindate, '%b %D %Y') | + | |where=user.userid='{{{forumid|}}}' |data={{{forumid|}}}usertitle=user.usertitle,{{{forumid|}}}username=user.username,{{{forumid|}}}mainname=userfield.field164,{{{forumid|}}}mainid=userfield.field163,{{{forumid|}}}oneaccount=userfield.field260,{{{forumid|}}}forumid=user.userid,{{{forumid|}}}posts=user.posts,{{{forumid|}}}lastpost=from_unixtime(user.lastpost, '%b %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(user.lastactivity, '%b %D %Y'),{{{forumid|}}}lastpostid=user.lastpostid,{{{forumid|}}}venue=userfield.field104,{{{forumid|}}}family=userfield.field240,{{{forumid|}}}organization=userfield.field243,{{{forumid|}}}statusvenue=userfield.field247,{{{forumid|}}}statusorganization=userfield.field253,{{{forumid|}}}statusfamily=userfield.field250,{{{forumid|}}}presence=userfield.field237,{{{forumid|}}}adv=userfield.field256,{{{forumid|}}}mask=userfield.field259,{{{forumid|}}}usergroupid=user.usergroupid,{{{forumid|}}}joindate=from_unixtime(user.joindate, '%b %D %Y') |
}}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}} | }}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}} | ||
|Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character | |Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character | ||
| Line 33: | Line 33: | ||
|{{#get_db_data:db=nwod | |{{#get_db_data:db=nwod | ||
|from=user | |from=user | ||
| - | |where=userid='{{{forumid|}}}' |data={{{forumid|}}}username=user.username,{{{forumid|}}}mainname=userfield.field164,{{{forumid|}}}mainid=userfield.field163,{{{forumid|}}}oneaccount=userfield.field260,{{{forumid|}}}forumid=userid,{{{forumid|}}}posts=posts,{{{forumid|}}}lastpost=from_unixtime(lastpost, '%b %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(lastactivity, '%b %D %Y'),{{{forumid|}}}lastpostid=lastpostid | + | |where=userid='{{{forumid|}}}' |data={{{forumid|}}}usertitle=user.usertitle,{{{forumid|}}}username=user.username,{{{forumid|}}}mainname=userfield.field164,{{{forumid|}}}mainid=userfield.field163,{{{forumid|}}}oneaccount=userfield.field260,{{{forumid|}}}forumid=userid,{{{forumid|}}}posts=posts,{{{forumid|}}}lastpost=from_unixtime(lastpost, '%b %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(lastactivity, '%b %D %Y'),{{{forumid|}}}lastpostid=lastpostid |
}}{{#set:Page has default form=Edit {{{Venue|}}} Character|Venue={{{Venue|}}}|Character Type={{{Venue|}}}}} | }}{{#set:Page has default form=Edit {{{Venue|}}} Character|Venue={{{Venue|}}}|Character Type={{{Venue|}}}}} | ||
}}|{{#get_db_data:db=nwod | }}|{{#get_db_data:db=nwod | ||
|from=user JOIN userfield ON (userfield.userid = user.userid) | |from=user JOIN userfield ON (userfield.userid = user.userid) | ||
| - | |where=user.userid='{{{forumid|}}}' |data={{{forumid|}}}username=user.username,{{{forumid|}}}mainname=userfield.field164,{{{forumid|}}}mainid=userfield.field163,{{{forumid|}}}oneaccount=userfield.field260,{{{forumid|}}}forumid=user.userid,{{{forumid|}}}posts=user.posts,{{{forumid|}}}lastpost=from_unixtime(user.lastpost, '%b %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(user.lastactivity, '%b %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,{{{forumid|}}}usergroupid=user.usergroupid,{{{forumid|}}}joindate=from_unixtime(user.joindate, '%b %D %Y') | + | |where=user.userid='{{{forumid|}}}' |data={{{forumid|}}}usertitle=user.usertitle,{{{forumid|}}}username=user.username,{{{forumid|}}}mainname=userfield.field164,{{{forumid|}}}mainid=userfield.field163,{{{forumid|}}}oneaccount=userfield.field260,{{{forumid|}}}forumid=user.userid,{{{forumid|}}}posts=user.posts,{{{forumid|}}}lastpost=from_unixtime(user.lastpost, '%b %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(user.lastactivity, '%b %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,{{{forumid|}}}usergroupid=user.usergroupid,{{{forumid|}}}joindate=from_unixtime(user.joindate, '%b %D %Y') |
}}{{#set:Minisheet1={{PAGENAME}} | }}{{#set:Minisheet1={{PAGENAME}} | ||
|Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character | |Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character | ||
| Line 98: | Line 98: | ||
<table class="" width="100%" valign="top" cellpadding="3" cellspacing="3"> | <table class="" width="100%" valign="top" cellpadding="3" cellspacing="3"> | ||
<tr> | <tr> | ||
| - | <th class="" colspan="7"><span class="center Changelingfont Changelingcolor font200">{{{Character Name|}}}</span>{{#if:{{{Quote|}}}|<br /><span class="center Changelingfont Changelingcolor font150 italic">{{{Quote|}}}</span>|}} <br /><span class="center Changelingfont font150">{{#if: {{{Court Title|}}} | + | <th class="" colspan="7"><span class="center Changelingfont Changelingcolor font200">{{{Character Name|}}}</span>{{#if:{{{Quote|}}}|<br /><span class="center Changelingfont Changelingcolor font150 italic">{{{Quote|}}}</span>|}} <br /><span class="center Changelingfont font150">{{#switch: {{#external_value: {{{forumid|}}}usergroupid}} |
| - | |{{{Court Title|}}} | + | |123={{#external_value:{{{forumid|}}}usertitle}} |
| - | |Active =[[{{#external_value:{{{forumid|}}}organization}}]] | + | |126={{#external_value:{{{forumid|}}}usertitle}} |
| + | |{{#if: {{{Court Title|}}} | ||
| + | |{{{Court Title|}}} {{#switch: {{{Status|}}} | ||
| + | |Active =of [[{{#external_value:{{{forumid|}}}organization}}]] | ||
|[[{{{Court|}}}]] | |[[{{{Court|}}}]] | ||
}} | }} | ||
| - | |}} | + | |}} |
| + | }}</span></th> | ||
<!-- Portrait --> | <!-- Portrait --> | ||
<th width="210px;" rowspan="3"><div style="height: 218px;float: right;overflow: hidden;"><span style=" | <th width="210px;" rowspan="3"><div style="height: 218px;float: right;overflow: hidden;"><span style=" | ||
Revision as of 15:28, 28 December 2016
[create] 
Template documentation
Template documentation| Editors can experiment in this template's sandbox (create). Subpages of this template: |
