Mage Timeline

From Edge of Darkness Wiki

Revision as of 15:36, 12 February 2017 (view source) West (Talk | contribs) ← Older edit		Revision as of 17:41, 19 February 2017 (view source) West (Talk | contribs) Newer edit →
Line 1:		Line 1:
-	{{#ask: [[Category:Spells]] |?Spell Arcana |?Permission |?Source |limit=800 }}	+	{{#get_db_data:db=nwod
		+	|from=char2 JOIN characters ON char2.threadid = characters.threadid
		+
		+	|where=char2.detail = 'Fame' AND characters.Status = 'Active' OR char2.detail = 'Contacts' AND characters.Status = 'Active' OR char2.detail = 'Allies' AND char2.value > 2 AND char2.option IN ('Academia','Arms Dealers','Charities','City Hall','Clubs','Criminals','Culture','Digital Networks','Emergency Services','Entertainment','Fashion','Finance','Judicial','Medical','Status','News Media','Public Works','Religious Groups','Street','Unions') AND characters.Status = 'Active' OR char2.detail = 'Status' AND char2.value > 1 AND char2.option IN ('Academia','Arms Dealers','Charities','City Hall','Clubs','Criminals','Culture','Digital Networks','Emergency Services','Entertainment','Fashion','Finance','Judicial','Medical','Status','News Media','Public Works','Religious Groups','Street','Unions') AND characters.Status = 'Active'
		+
		+	|data=threadid=characters.threadid, name=char_name, detail=detail, spheres=GROUP_CONCAT(DISTINCT char2.option ORDER BY char2.option ASC SEPARATOR ', ')
		+	}}

---

Revision as of 17:41, 19 February 2017