Sandbox

From Edge of Darkness Wiki

Revision as of 15:53, 10 March 2020 (view source) West (Talk | contribs) ← Older edit		Revision as of 16:09, 6 April 2020 (view source) West (Talk | contribs) (Replaced content with "{{#ask: Category:Contracts |format=list }}") Newer edit →
Line 1:		Line 1:
-	{{#get_db_data:db=nwod	+	{{#ask: [[Category:Contracts]] |format=list }}
-	|from=post JOIN thread ON (thread.threadid = post.threadid) JOIN forum ON (forum.forumid = thread.forumid) JOIN user ON (user.username = thread.lastposter)	+
-	|where=thread.forumid IN (7) group by thread.title order by thread.lastpost desc LIMIT 10	+
-	|data=wtfforum=forum.title AS forum, wtfthread=thread.title, wtfdate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, wtfposter=thread.lastposter, wtfpostcount=count(postid), wtfpostid=post.postid, wtfforumid=thread.forumid, wtfuserid=user.userid	+
-	}}	+
-		+
-		+
-	{{#get_db_data:db=nwod	+
-	|from=characters	+
-	|where=status == 'Active'	+
-	|data=char_name	+
-	}}	+

---

Revision as of 16:09, 6 April 2020

Animation, Artifice, Board, Communion, Darkness Contracts, Den Contracts, Dream Contracts, Elements, Entropy, Eternal Autumn, Eternal Spring, Eternal Summer, Eternal Winter, Fang and Talon, Fleeting Autumn, Fleeting Spring, Fleeting Summer, Fleeting Winter, Forge Contracts, Four Directions, Hearth, Hours, Lucidity, Mirror, Moon, Oath and Punishment, Omen, Potential, Punishing Summer, Reflections, Separation, Shade and Spirit, Smoke, Sorrow-Frozen Heart, Spellbound Autumn, Stone, Thorns and Brambles, Vainglory, Verdant Spring, Wild