Template:Char
From Edge of Darkness Wiki
Char
| Line 4: | Line 4: | ||
|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), | ||
| - | {{{threadid|}}}lastpost=COALESCE | + | {{{threadid|}}}lastpost=COALESCE(u1.lastpost, u2.lastpost), |
| - | {{{threadid|}}}lastvisit=COALESCE | + | {{{threadid|}}}lastvisit=COALESCE(u1.lastactivity, u2.lastactivity), |
| - | {{{threadid|}}}joindate=COALESCE | + | {{{threadid|}}}joindate=COALESCE(u1.joindate, created, u2.joindate), |
{{{threadid|}}}statusvenue=COALESCE(uf1.field165, uf2.field165), | {{{threadid|}}}statusvenue=COALESCE(uf1.field165, uf2.field165), | ||
{{{threadid|}}}statusorganization=COALESCE(uf1.field166, uf2.field166), | {{{threadid|}}}statusorganization=COALESCE(uf1.field166, uf2.field166), | ||
| Line 31: | Line 31: | ||
{{{threadid|}}}citylabel=CASE Venue WHEN 'Changeling' THEN 'Freehold' WHEN 'Mage' THEN 'Consilium' WHEN 'Vampire' THEN 'Domain' ELSE 'City' END, | {{{threadid|}}}citylabel=CASE Venue WHEN 'Changeling' THEN 'Freehold' WHEN 'Mage' THEN 'Consilium' WHEN 'Vampire' THEN 'Domain' ELSE 'City' END, | ||
{{{threadid|}}}refinementlabel=CASE Venue WHEN 'Changeling' THEN 'Entitlement' WHEN 'Mage' THEN 'Legacy' WHEN 'Vampire' THEN 'Bloodline' WHEN 'Werewolf' THEN 'Lodge' ELSE 'Refinement' END, | {{{threadid|}}}refinementlabel=CASE Venue WHEN 'Changeling' THEN 'Entitlement' WHEN 'Mage' THEN 'Legacy' WHEN 'Vampire' THEN 'Bloodline' WHEN 'Werewolf' THEN 'Lodge' ELSE 'Refinement' END, | ||
| - | {{{threadid|}}}organizationlabel=CASE Venue WHEN 'Changeling' THEN 'Court' WHEN 'Mage' THEN 'Order' WHEN 'Vampire' THEN 'Covenant' WHEN 'Werewolf' THEN 'Tribe' ELSE 'Org.' END, | + | {{{threadid|}}}organizationlabel=CASE Venue WHEN 'Changeling' THEN 'Court' WHEN 'Mage' THEN 'Order' WHEN 'Vampire' THEN 'Covenant' WHEN 'Werewolf' THEN 'Tribe' WHEN 'Hunter' THEN 'Conspiracy' ELSE 'Org.' END, |
| - | {{{threadid|}}}familylabel=CASE Venue WHEN 'Changeling' THEN 'Seeming' WHEN 'Mage' THEN 'Path' WHEN 'Vampire' THEN 'Clan' WHEN 'Werewolf' THEN 'Auspice' ELSE 'Family' END, | + | {{{threadid|}}}familylabel=CASE Venue WHEN 'Changeling' THEN 'Seeming' WHEN 'Mage' THEN 'Path' WHEN 'Vampire' THEN 'Clan' WHEN 'Werewolf' THEN 'Auspice' WHEN 'Hunter' THEN 'Compact' ELSE 'Family' END, |
| - | {{{threadid|}}}powerlabel=CASE Venue WHEN 'Changeling' THEN 'Wyrd' WHEN 'Mage' THEN 'Gnosis' WHEN 'Vampire' THEN 'Blood Potency' WHEN 'Werewolf' THEN 'Primal Urge' ELSE | + | {{{threadid|}}}powerlabel=CASE Venue WHEN 'Changeling' THEN 'Wyrd' WHEN 'Mage' THEN 'Gnosis' WHEN 'Vampire' THEN 'Blood Potency' WHEN 'Werewolf' THEN 'Primal Urge' ELSE NULL END |
}} | }} | ||
</includeonly>[[Category:Player Use Templates]] | </includeonly>[[Category:Player Use Templates]] | ||
