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|}}}| | <includeonly>[[Category:{{{Player Name|}}}]]<!-- DB FOR USER INFO AND CHARACTER VARIABLES -->{{#if: {{{threadid|}}}| | ||
{{#get_db_data:db=nwod | {{#get_db_data:db=nwod | ||
| - | |FROM characters | + | |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), |
| + | {{{forumid|}}}mask=COALESCE(uf1.field173, uf2.field173), | ||
| + | {{{forumid|}}}lastpost=COALESCE(from_unixtime(u1.lastpost, '%b %D %Y'), from_unixtime(u2.lastpost, '%b %D %Y')), | ||
| + | {{{forumid|}}}lastvisit=COALESCE(from_unixtime(u1.lastactivity, '%b %D %Y'), from_unixtime(u2.lastactivity, '%b %D %Y')), | ||
| + | {{{forumid|}}}joindate=COALESCE(from_unixtime(u1.joindate, '%b %D %Y'), from_unixtime(u2.joindate, '%b %D %Y')), | ||
| + | {{{forumid|}}}statusvenue=COALESCE(uf1.field165, uf2.field165), | ||
| + | {{{forumid|}}}statusorganization=COALESCE(uf1.field166, uf2.field166), | ||
| + | {{{forumid|}}}statusfamily=COALESCE(uf1.field167, uf2.field167), | ||
| + | {{{forumid|}}}lastpostid=COALESCE(u1.lastpostid, u2.lastpostid), | ||
| + | {{{forumid|}}}usergroupid=COALESCE(u1.usergroupid, u2.usergroupid), | ||
| + | {{{forumid|}}}oneaccount=COALESCE(uf1.field260, uf2.field260), | ||
| + | {{{forumid|}}}posts=COALESCE(u1.posts, u2.posts), | ||
| + | {{{forumid|}}}venue=Venue, | ||
{{{forumid|}}}family=Family, | {{{forumid|}}}family=Family, | ||
| - | {{{forumid|}}}organization=Organization | + | {{{forumid|}}}organization=Organization, |
| + | {{{forumid|}}}presence=Presence, | ||
| + | {{{forumid|}}}adv=Power, | ||
| + | {{{forumid|}}}username=characters.char_name, | ||
| + | {{{forumid|}}}mainname=characters.username, | ||
| + | {{{forumid|}}}mainid=characters.userid, | ||
| + | {{{forumid|}}}forumid=char_userid | ||
}} | }} | ||
{{#set:Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character | {{#set:Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character | ||
Revision as of 12:14, 23 January 2017
[create] 
Template documentation
Template documentation| Editors can experiment in this template's sandbox (create). Subpages of this template: |
