Template:Char
From Edge of Darkness Wiki
Char
| Line 1: | Line 1: | ||
| - | <includeonly><!-- DB FOR USER INFO AND CHARACTER VARIABLES -->{{#get_db_data:db=nwod | + | <includeonly><!-- DB FOR USER INFO AND CHARACTER VARIABLES --> |
| + | {{#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|}}}' | ||
