Template:Character
From Edge of Darkness Wiki
Character
m |
m |
||
| Line 3: | Line 3: | ||
|from=user JOIN userfield ON (userfield.userid = user.userid) | |from=user JOIN userfield ON (userfield.userid = user.userid) | ||
|where=user.userid='{{{forumid|}}}' | |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,{{{forumid|}}}usergroupid=user.usergroupid | + | |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,{{{forumid|}}}usergroupid=user.usergroupid,{{{forumid|}}}joindate=user.joindate |
}}{{#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 12: | Line 12: | ||
|from=user JOIN userfield ON (userfield.userid = user.userid) | |from=user JOIN userfield ON (userfield.userid = user.userid) | ||
|where=user.userid='{{{forumid|}}}' | |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.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 | + | |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.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=user.joindate |
}}{{#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 21: | Line 21: | ||
|from=user JOIN userfield ON (userfield.userid = user.userid) | |from=user JOIN userfield ON (userfield.userid = user.userid) | ||
|where=user.userid='{{{forumid|}}}' | |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.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 | + | |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.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=user.joindate |
}}{{#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 30: | Line 30: | ||
|from=user JOIN userfield ON (userfield.userid = user.userid) | |from=user JOIN userfield ON (userfield.userid = user.userid) | ||
|where=user.userid='{{{forumid|}}}' | |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.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 | + | |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.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=user.joindate |
}}{{#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 44: | Line 44: | ||
|from=user JOIN userfield ON (userfield.userid = user.userid) | |from=user JOIN userfield ON (userfield.userid = user.userid) | ||
|where=user.userid='{{{forumid|}}}' | |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,{{{forumid|}}}usergroupid=user.usergroupid | + | |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,{{{forumid|}}}usergroupid=user.usergroupid,{{{forumid|}}}joindate=user.joindate |
| - | }}{{#set: | + | }}{{#set:Minisheet1={{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 75: | Line 75: | ||
|Avatar={{#if: {{{Avatar|}}}|{{{Avatar|}}}|Unknown}} | |Avatar={{#if: {{{Avatar|}}}|{{{Avatar|}}}|Unknown}} | ||
|Lived In=Sacramento | |Lived In=Sacramento | ||
| - | |Sacramento Start={{{Inception|}}} | + | |Sacramento Start={{#if: {{{Inception|}}}|{{{Inception|}}}|{{#external_value:{{{forumid|}}}joindate}}}} |
|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 | ||
Revision as of 02:59, 26 December 2016
[create] 
Template documentation
Template documentation| Editors can experiment in this template's sandbox (create). Subpages of this template: |
