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='{{{threadid|}}}' | |where=characters.threadid='{{{threadid|}}}' | ||
| Line 30: | Line 30: | ||
{{{threadid|}}}avatar=customavatar.visible, | {{{threadid|}}}avatar=customavatar.visible, | ||
{{{threadid|}}}ppic=customprofilepic.visible, | {{{threadid|}}}ppic=customprofilepic.visible, | ||
| - | {{{threadid|}}}refinement=Refinement | + | {{{threadid|}}}refinement=Refinement |
| - | + | ||
}} | }} | ||
