Template:Character

From Edge of Darkness Wiki

Character
Jump to: navigation, search
(Added db fetch for one account, main name and ID)
m
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|}}}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, '%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=from_unixtime(user.joindate, '%M %D %Y')}}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}
+
|where=user.userid='{{{forumid|}}}' |data={{{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|}}}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, '%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=from_unixtime(user.joindate, '%M %D %Y')
+
|where=user.userid='{{{forumid|}}}' |data={{{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|}}}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, '%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=from_unixtime(user.joindate, '%M %D %Y')
+
|where=user.userid='{{{forumid|}}}' |data={{{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|}}}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, '%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=from_unixtime(user.joindate, '%M %D %Y')
+
|where=user.userid='{{{forumid|}}}' |data={{{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|}}}mainname=userfield.field164,{{{forumid|}}}mainid=userfield.field163,{{{forumid|}}}oneaccount=userfield.field260,{{{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=userid='{{{forumid|}}}' |data={{{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|}}}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, '%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=from_unixtime(user.joindate, '%M %D %Y')
+
|where=user.userid='{{{forumid|}}}' |data={{{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 60: Line 60:
}}<!---- END DB GET ---->{{#set:  
}}<!---- END DB GET ---->{{#set:  
forumid={{{forumid|}}}
forumid={{{forumid|}}}
 +
|oneaccount={{#external_value: {{{forumid|}}}oneaccount }}
|Player=User:{{{Player Name|}}}
|Player=User:{{{Player Name|}}}
|Posted={{#external_value: {{{forumid|}}}lastpost }}
|Posted={{#external_value: {{{forumid|}}}lastpost }}
Line 68: Line 69:
|Avatar={{#if: {{{Avatar|}}}|{{{Avatar|}}}|Unknown}}
|Avatar={{#if: {{{Avatar|}}}|{{{Avatar|}}}|Unknown}}
|Lived In=Sacramento
|Lived In=Sacramento
-
|Sacramento Start={{#if: {{{Inception|}}}|{{{Inception|}}}|{{#external_value:{{{forumid|}}}joindate}}}}
+
|Sacramento Start={{#if: {{#external_value:{{{forumid|}}}joindate}}|{{#external_value:{{{forumid|}}}joindate}}|{{{Inception|}}}}}
|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  
Line 361: Line 362:
<td width="33%" class="grade05 onepixelborder {{#external_value: {{{forumid|}}}venue }}bordercolor" >[[{{PAGENAME}}/Quotes|Quotes & Social Page]]&nbsp;●&nbsp;[http://nwod.org/forum/member.php?{{{forumid|}}} Forum Page]</td>
<td width="33%" class="grade05 onepixelborder {{#external_value: {{{forumid|}}}venue }}bordercolor" >[[{{PAGENAME}}/Quotes|Quotes & Social Page]]&nbsp;●&nbsp;[http://nwod.org/forum/member.php?{{{forumid|}}} Forum Page]</td>
<td></td>
<td></td>
-
<td width="33%" class="grade05 onepixelborder {{#external_value: {{{forumid|}}}venue }}bordercolor" >{{#if:{{{Inception|}}}|{{{Inception|}}}|{{#external_value:{{{forumid|}}}joindate}} }}&nbsp;●&nbsp;[[Sacramento End::{{#external_value: {{{forumid|}}}lastpost }}]]</td>
+
<td width="33%" class="grade05 onepixelborder {{#external_value: {{{forumid|}}}venue }}bordercolor" >{{#if:{{#external_value:{{{forumid|}}}joindate}}|{{#external_value:{{{forumid|}}}joindate}}|{{{Inception|}}} }}&nbsp;●&nbsp;[[Sacramento End::{{#external_value: {{{forumid|}}}lastpost }}]]</td>
</tr>
</tr>
</table>
</table>

Revision as of 14:40, 28 December 2016

[create] Template documentation
Retrieved from "http://nwod.org/wiki/index.php/Template:Character"
Personal tools
Namespaces
Variants
Actions
Navigation
games
Toolbox