Template:Char

From Edge of Darkness Wiki

Revision as of 15:45, 23 January 2017 (view source) West (Talk | contribs) ← Older edit		Revision as of 15:46, 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(NULLIF(uf1.field165,''), NULLIF(uf2.field165,''), 0),
-	{{{threadid|}}}statusorganization=COALESCE(NULLIF(uf1.field166,''), NULLIF(uf2.field166,''), 0),
-	{{{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),

---

Revision as of 15:46, 23 January 2017