Template:Char
From Edge of Darkness Wiki
Char
| Line 33: | Line 33: | ||
{{{threadid|}}}oneaccount=(CASE WHEN characters.userid = characters.char_userid THEN 'yes' ELSE 'no' END), | {{{threadid|}}}oneaccount=(CASE WHEN characters.userid = characters.char_userid THEN 'yes' ELSE 'no' END), | ||
{{{threadid|}}}status=(CASE Status WHEN 'Active' THEN 'Active' WHEN 'Deceased' THEN 'Deceased' ELSE 'Inactive' END), | {{{threadid|}}}status=(CASE Status WHEN 'Active' THEN 'Active' WHEN 'Deceased' THEN 'Deceased' ELSE 'Inactive' END), | ||
| + | {{{threadid|}}}troupelabel=(CASE Venue WHEN 'Changeling' THEN 'Motley' WHEN 'Mage' THEN 'Cabal' WHEN 'Vampire' THEN 'Coterie' WHEN 'Werewolf' THEN 'Pack' WHEN 'Hunter' THEN 'Cell' ELSE NULL END), | ||
{{{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), | ||
