Template:Character
From Edge of Darkness Wiki
Character
m |
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 -->{{#switch: {{{minisheet|}}} | + | <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|}}} |
|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 41: | Line 41: | ||
|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|}}}}} | ||
| - | }}<!-- DB FROM VENUE FOR QUOTES PAGE -->{{#switch: {{#show: {{PAGENAME}} |?Venue# }} | + | }}|{{#get_db_data:db=nwod |
| + | |from=user JOIN userfield ON (userfield.userid = user.userid) | ||
| + | |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 | ||
| + | }}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}} | ||
| + | |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) 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 02:56, 26 December 2016
[create] 
Template documentation
Template documentation| Editors can experiment in this template's sandbox (create). Subpages of this template: |
