Template:Character

From Edge of Darkness Wiki

Character
Jump to: navigation, search
m
m
Line 1: Line 1:
-
<includeonly>{{#switch:{{{Player Name|}}}
+
<includeonly><!-- PLAYER TOP ICON -->{{#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 FOR USER INFO -->{{#switch: {{{minisheet|}}}
+
}}<!-- DB FOR USER INFO AND CHARACTER VARIABLES -->{{#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)
Line 13: Line 13:
}}
}}
|2={{#get_db_data:db=nwod
|2={{#get_db_data:db=nwod
-
|from=user
+
|from=user JOIN userfield ON (userfield.userid = user.userid)
-
|where=userid='{{{forumid|}}}'
+
|where=user.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=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
-
}}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}}}{{#set:Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character|Venue={{#external_value:{{{forumid|}}}venue}}|Character Type={{#external_value:{{{forumid|}}}venue}} }}{{#get_db_data:db=nwod
+
}}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}
-
|from=userfield
+
|Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character
-
|where=userid='{{{forumid|}}}' |data={{{forumid|}}}venue=field102,{{{forumid|}}}family=field238,{{{forumid|}}}organization=field241,{{{forumid|}}}statusvenue=field244,{{{forumid|}}}statusorganization=field251,{{{forumid|}}}statusfamily=field248,{{{forumid|}}}presence=field181,{{{forumid|}}}adv=field161,{{{forumid|}}}mask=field257
+
|Venue={{#external_value:{{{forumid|}}}venue}}
-
}}
+
|Character Type={{#external_value:{{{forumid|}}}venue}}
 +
}}
|3={{#get_db_data:db=nwod
|3={{#get_db_data:db=nwod
-
|from=user
+
|from=user JOIN userfield ON (userfield.userid = user.userid)
-
|where=userid='{{{forumid|}}}'
+
|where=user.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=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
-
}}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}}}{{#set:Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character|Venue={{#external_value:{{{forumid|}}}venue}}|Character Type={{#external_value:{{{forumid|}}}venue}} }}{{#get_db_data:db=nwod
+
}}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}
-
|from=userfield
+
|Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character
-
|where=userid='{{{forumid|}}}' |data={{{forumid|}}}venue=field103,{{{forumid|}}}family=field239,{{{forumid|}}}organization=field242,{{{forumid|}}}statusvenue=field245,{{{forumid|}}}statusorganization=field252,{{{forumid|}}}statusfamily=field249,{{{forumid|}}}presence=field236,{{{forumid|}}}adv=field255,{{{forumid|}}}mask=field258
+
|Venue={{#external_value:{{{forumid|}}}venue}}
-
}}
+
|Character Type={{#external_value:{{{forumid|}}}venue}}
 +
}}
|4={{#get_db_data:db=nwod
|4={{#get_db_data:db=nwod
-
|from=user
+
|from=user JOIN userfield ON (userfield.userid = user.userid)
-
|where=userid='{{{forumid|}}}'
+
|where=user.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=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
-
}}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}}}{{#set:Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character|Venue={{#external_value:{{{forumid|}}}venue}}|Character Type={{#external_value:{{{forumid|}}}venue}} }}{{#get_db_data:db=nwod
+
}}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}
-
|from=userfield
+
|Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character
-
|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
+
|Venue={{#external_value:{{{forumid|}}}venue}}
-
}}
+
|Character Type={{#external_value:{{{forumid|}}}venue}}
 +
}}
|{{#get_db_data:db=nwod
|{{#get_db_data:db=nwod
|from=user
|from=user
Line 41: Line 44:
|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
}}{{#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|}}}}}
-
}}<!-- SET VENUE FROM MINISHEET OR TEMPLATE DECLARATION -->{{#if:{{#external_value:{{{forumid|}}}venue}}
+
}}<!-- DB FROM VENUE FOR QUOTES PAGE -->{{#switch: {{#show: {{PAGENAME}} |?Venue# }}
-
|{{#set:Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character|Venue={{#external_value:{{{forumid|}}}venue}}|Character Type={{#external_value:{{{forumid|}}}venue}} }}
+
-
}}<!-- 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)
|from=post JOIN thread ON (thread.threadid = post.threadid)

Revision as of 14:12, 23 May 2016

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