Template:Character
From Edge of Darkness Wiki
Character
| Line 1: | Line 1: | ||
| - | <includeonly>[[Category:{{{Player Name|}}}]]<!-- DB FOR USER INFO AND CHARACTER VARIABLES -->{{#if: {{{forumid|}}} | + | <includeonly>[[Category:{{{Player Name|}}}]]<!-- DB FOR USER INFO AND CHARACTER VARIABLES -->{{#if: {{{forumid|}}}|{{#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 42: | Line 42: | ||
|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# }} | + | }}}}|{{#get_db_data:db=nwod|from=user JOIN userfield ON (userfield.userid = user.userid)|where=user.username LIKE '{{{Player Name|}}}'|data={{{forumid|}}}noinfouserid=user.userid,{{{forumid|}}}noinfousername=user.username}}{{#set:PlayerID={{#external_value: {{{forumid|}}}noinfouserid}}}}}<!-- 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 18:01, 1 January 2017
[create] 
Template documentation
Template documentation| Editors can experiment in this template's sandbox (create). Subpages of this template: |
