Template:Char

From Edge of Darkness Wiki

Revision as of 14:23, 23 January 2017 (view source) West (Talk | contribs) ← Older edit		Revision as of 14:25, 23 January 2017 (view source) West (Talk | contribs) Newer edit →
Line 2:		Line 2:
	{{#get_db_data:db=nwod		{{#get_db_data:db=nwod
-	|FROM=characters LEFT JOIN user u1 ON u1.userid = characters.char_userid LEFT JOIN user u2 ON u2.userid = characters.userid LEFT JOIN userfield uf1 ON uf1.userid = u1.userid LEFT JOIN userfield uf2 ON uf2.userid = u2.userid LEFT JOIN customavatar ON customavatar.userid = u1.userid LEFT JOIN customprofilepic ON customprofilepic.userid = u1.userid	+	|FROM=characters
	|WHERE=characters.threadid='36802'		|WHERE=characters.threadid='36802'
-	|DATA={{{threadid|}}}usertitle=COALESCE(u1.usertitle, u2.usertitle),	+	|DATA={{{threadid|}}}venue=Venue,{{{threadid|}}}family=Family,
-	{{{threadid|}}}mask=COALESCE(uf1.field173, uf2.field173),	+
-	{{{threadid|}}}lastpost=COALESCE(u1.lastpost, u2.lastpost),	+
	}}		}}
-	{{#external_value: {{{threadid|}}}mask}}	+	{{#external_value: {{{threadid|}}}family}}
	</includeonly>[[Category:Player Use Templates]]		</includeonly>[[Category:Player Use Templates]]

---

Revision as of 14:25, 23 January 2017