Template:Char

From Edge of Darkness Wiki

Revision as of 15:35, 23 January 2017 (view source) West (Talk | contribs) ← Older edit		Revision as of 15:45, 23 January 2017 (view source) West (Talk | contribs) Newer edit →
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(uf1.field165, uf2.field165),	+	{{{threadid|}}}statusvenue=COALESCE(NULLIF(uf1.field165,''), NULLIF(uf2.field165,''), 0),
-	{{{threadid|}}}statusorganization=COALESCE(uf1.field166, uf2.field166),	+	{{{threadid|}}}statusorganization=COALESCE(NULLIF(uf1.field166,''), NULLIF(uf2.field166,''), 0),
-	{{{threadid|}}}statusfamily=COALESCE(uf1.field167, uf2.field167),	+	{{{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 58:		Line 58:
-	</div>	+
	</includeonly>[[Category:Player Use Templates]]		</includeonly>[[Category:Player Use Templates]]

---

Revision as of 15:45, 23 January 2017