Template:Char
From Edge of Darkness Wiki
Char
| Line 11: | Line 11: | ||
{{{threadid|}}}lastvisit=COALESCE(u1.lastactivity, u2.lastactivity), | {{{threadid|}}}lastvisit=COALESCE(u1.lastactivity, u2.lastactivity), | ||
{{{threadid|}}}joindate=COALESCE(u1.joindate, created, u2.joindate), | {{{threadid|}}}joindate=COALESCE(u1.joindate, created, u2.joindate), | ||
| + | |||
| + | {{{threadid|}}}statusvenue=(COALESCE(NULLIF(uf1.field165,''), NULLIF(uf2.field165,''), 0)), | ||
| + | {{{threadid|}}}statusorganization=(COALESCE(NULLIF(uf1.field166,''), NULLIF(uf2.field166,''), 0)), | ||
| + | {{{threadid|}}}statusfamily=(COALESCE(NULLIF(uf1.field167,''), NULLIF(uf2.field167,''), 0)), | ||
| + | |||
{{{threadid|}}}lastpostid=COALESCE(u1.lastpostid, u2.lastpostid), | {{{threadid|}}}lastpostid=COALESCE(u1.lastpostid, u2.lastpostid), | ||
{{{threadid|}}}usergroupid=COALESCE(u1.usergroupid, u2.usergroupid), | {{{threadid|}}}usergroupid=COALESCE(u1.usergroupid, u2.usergroupid), | ||
| Line 46: | Line 51: | ||
</td> | </td> | ||
<td style="width: 200px;"> | <td style="width: 200px;"> | ||
| - | <div style="height: 200px; overflow: hidden; margin-top: -3px;">[[Image:{{#external_value: {{{threadid|}}} | + | <div style="height: 200px; overflow: hidden; margin-top: -3px;">[[Image:{{#external_value: {{{threadid|}}}username}}.jpg|200px|Click here to upload portrait.]]</div> |
</td> | </td> | ||
</tr> | </tr> | ||
