Template:Character

From Edge of Darkness Wiki

Character
Jump to: navigation, search
m
Line 1: Line 1:
-
<includeonly><!-- PLAYER TOP ICON -->{{#ask: [[User:{{{Player Name|}}}]] |?forumid= |?forumname= |format=template |template=PlayerAvatar }}<!-- DB FOR USER INFO AND CHARACTER VARIABLES -->{{#if: {{{minisheet|}}}|{{#switch: {{{minisheet|}}}
+
<includeonly><!-- DB FOR USER INFO AND CHARACTER VARIABLES -->{{#if: {{{minisheet|}}}|{{#switch: {{{minisheet|}}}
|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|}}}'
+
|where=user.userid='{{{forumid|}}}' |data={{{forumid|}}}forumid=user.userid,{{{forumid|}}}mainname=userfield.field164{{{forumid|}}}mainid=userfield.field163,{{{forumid|}}}oneaccount=userfield.field260,{{{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}}
-
|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=from_unixtime(user.joindate, '%M %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 11: 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|}}}'
+
|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')
-
|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=from_unixtime(user.joindate, '%M %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 20: 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|}}}'
+
|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')
-
|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=from_unixtime(user.joindate, '%M %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 29: 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|}}}'
+
|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')
-
|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=from_unixtime(user.joindate, '%M %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 38: Line 33:
|{{#get_db_data:db=nwod
|{{#get_db_data:db=nwod
|from=user
|from=user
-
|where=userid='{{{forumid|}}}'
+
|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
-
|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: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|}}}'
+
|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')
-
|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=from_unixtime(user.joindate, '%M %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
|Venue={{#external_value:{{{forumid|}}}venue}}
|Venue={{#external_value:{{{forumid|}}}venue}}
|Character Type={{#external_value:{{{forumid|}}}venue}}
|Character Type={{#external_value:{{{forumid|}}}venue}}
-
}}}}<!-- DB FROM VENUE FOR QUOTES PAGE -->{{#switch: {{#show: {{PAGENAME}} |?Venue# }}
+
}}}}<!-- PLAYER TOP ICON -->{{#ask: [[User:{{{Player Name|}}}]] |?forumid= |?forumname= |format=template |template=PlayerAvatar }}<!-- DB FROM VENUE FOR QUOTES PAGE -->{{#switch: {{#show: {{PAGENAME}} |?Venue# }}
|Changeling = {{#get_db_data:db=nwod
|Changeling = {{#get_db_data:db=nwod
|from=post JOIN thread ON (thread.threadid = post.threadid) JOIN user ON (user.username = thread.title)
|from=post JOIN thread ON (thread.threadid = post.threadid) JOIN user ON (user.username = thread.title)

Revision as of 14:26, 28 December 2016

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