Mage Timeline

Mage Timeline

Jump to: navigation, search

Latest revision as of 15:45, 10 March 2020

@@ Line 1: / Line 1: @@
-{{#get_db_data:db=nwod
+{{#ask: [[Category:Vampire]] [[Character Status::Active]] [[PC or NPC::PC]] |?Venue |?Player |searchlabel=|limit=50|order=random|link=none|format=template|template=Template:Askpc/Format/Mainpage}}
-	|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 ', ')
-}}