Template:Char
From Edge of Darkness Wiki
Char
| Line 2: | Line 2: | ||
{{#get_db_data:db=nwod | {{#get_db_data:db=nwod | ||
|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 LEFT JOIN customavatar ON customavatar.userid = u1.userid LEFT JOIN customprofilepic ON customprofilepic.userid = u1.userid | |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 LEFT JOIN customavatar ON customavatar.userid = u1.userid LEFT JOIN customprofilepic ON customprofilepic.userid = u1.userid | ||
| - | |WHERE=characters.threadid=' | + | |WHERE=characters.threadid='36802' |
|DATA={{{threadid|}}}usertitle=COALESCE(u1.usertitle, u2.usertitle), | |DATA={{{threadid|}}}usertitle=COALESCE(u1.usertitle, u2.usertitle), | ||
{{{threadid|}}}mask=COALESCE(uf1.field173, uf2.field173), | {{{threadid|}}}mask=COALESCE(uf1.field173, uf2.field173), | ||
