Template:Char

From Edge of Darkness Wiki

Revision as of 14:29, 23 January 2017 (view source) West (Talk | contribs) ← Older edit		Revision as of 14:34, 23 January 2017 (view source) West (Talk | contribs) Newer edit →
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|}}}posts=COALESCE(u1.posts, u2.posts),	+	{{{threadid|}}}posts=COALESCE(u1.posts, u2.posts),
	{{{threadid|}}}venue=Venue,		{{{threadid|}}}venue=Venue,
	{{{threadid|}}}family=Family,		{{{threadid|}}}family=Family,
Line 30:		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|}}}oneaccount=CASE WHEN characters.userid = characters.char_userid THEN 'yes' ELSE 'no' END AS oneaccount,
-	{{{threadid|}}}citylabel=CASE Venue WHEN 'Changeling' THEN 'Freehold' WHEN 'Mage' THEN 'Consilium' WHEN 'Vampire' THEN 'Domain'  ELSE 'City' END,	+	{{{threadid|}}}status=CASE Status WHEN 'Active' THEN 'Active' WHEN 'Deceased' THEN 'Deceased' ELSE 'Inactive' END AS status,
-	{{{threadid|}}}refinementlabel=CASE Venue WHEN 'Changeling' THEN 'Entitlement' WHEN 'Mage' THEN 'Legacy' WHEN 'Vampire' THEN 'Bloodline' WHEN 'Werewolf' THEN 'Lodge' ELSE 'Refinement' END,	+	{{{threadid|}}}citylabel=CASE Venue WHEN 'Changeling' THEN 'Freehold' WHEN 'Mage' THEN 'Consilium' WHEN 'Vampire' THEN 'Domain'  ELSE 'City' END AS citylabel
-	{{{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	+
	}}		}}

---

Revision as of 14:34, 23 January 2017