|
|
| Line 16: |
Line 16: |
| | {{{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), |
| - | {{{threadid|}}}oneaccount=CASE WHEN characters.userid = characters.char_userid THEN 'yes' ELSE 'no' END,
| |
| | {{{threadid|}}}posts=COALESCE(u1.posts, u2.posts), | | {{{threadid|}}}posts=COALESCE(u1.posts, u2.posts), |
| | {{{threadid|}}}venue=Venue, | | {{{threadid|}}}venue=Venue, |
| Line 31: |
Line 30: |
| | {{{threadid|}}}avatar=customavatar.visible, | | {{{threadid|}}}avatar=customavatar.visible, |
| | {{{threadid|}}}ppic=customprofilepic.visible, | | {{{threadid|}}}ppic=customprofilepic.visible, |
| - | {{{threadid|}}}refinement=Refinement, | + | {{{threadid|}}}refinement=Refinement |
| - | {{{threadid|}}}status=CASE Status WHEN 'Active' THEN 'Active' WHEN 'Deceased' THEN 'Deceased' ELSE 'Inactive' 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|}}}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' 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 NULL END
| + | |
| | }} | | }} |
| | | | |
