Template:Character
From Edge of Darkness Wiki
Character
| Line 1: | Line 1: | ||
| - | <includeonly>[[Category:{{{Player Name|}}}]]<!-- DB FOR USER INFO AND CHARACTER VARIABLES -->{{#if: {{{threadid|}}}|{{#get_db_data:db=nwod | + | <includeonly>[[Category:{{{Player Name|}}}]]<!-- DB FOR USER INFO AND CHARACTER VARIABLES -->{{#if: {{{threadid|}}}| |
| - | |FROM characters LEFT JOIN user u1 ON u1.userid = characters.char_userid LEFT JOIN user u2 ON u2.userid = characters.userid LEFT JOIN userfield uf1 ON uf1.userid = u1.userid LEFT JOIN userfield uf2 ON uf2.userid = u2.userid | + | {{#get_db_data:db=nwod |
| - | |where=characters.threadid='{{{threadid|}}}' | + | |FROM characters LEFT JOIN user u1 ON (u1.userid = characters.char_userid) LEFT JOIN user u2 ON (u2.userid = characters.userid) LEFT JOIN userfield uf1 ON (uf1.userid = u1.userid) LEFT JOIN userfield uf2 ON (uf2.userid = u2.userid) |
| + | |where=characters.threadid='{{{threadid|}}}' | ||
|data={{{forumid|}}}usertitle=COALESCE(u1.usertitle, u2.usertitle), | |data={{{forumid|}}}usertitle=COALESCE(u1.usertitle, u2.usertitle), | ||
{{{forumid|}}}mask=COALESCE(uf1.field173, uf2.field173), | {{{forumid|}}}mask=COALESCE(uf1.field173, uf2.field173), | ||
Revision as of 12:09, 23 January 2017
[create] 
Template documentation
Template documentation| Editors can experiment in this template's sandbox (create). Subpages of this template: |
