Posting Activity/Data

From Edge of Darkness Wiki

Revision as of 14:45, 27 May 2016 (view source) West (Talk | contribs) m ← Older edit		Revision as of 01:16, 23 June 2016 (view source) West (Talk | contribs) m Newer edit →
Line 1:		Line 1:
	{{#get_db_data:db=nwod		{{#get_db_data:db=nwod
	|from=post JOIN thread ON (thread.threadid = post.threadid)		|from=post JOIN thread ON (thread.threadid = post.threadid)
-	|where=forumid IN (9,209,243) AND post.dateline >= UNIX_TIMESTAMP()-2400000 group by username order by username ASC	+	|where=forumid IN (9,209,243) AND post.dateline >= UNIX_TIMESTAMP()-2400000 group by username order by count(thread.title) DESC
	|data=changelingposts=count(thread.title),changelingname=username		|data=changelingposts=count(thread.title),changelingname=username
	}}{{#get_db_data:db=nwod		}}{{#get_db_data:db=nwod
	|from=post JOIN thread ON (thread.threadid = post.threadid)		|from=post JOIN thread ON (thread.threadid = post.threadid)
-	|where=forumid IN (8,221,242) AND post.dateline >= UNIX_TIMESTAMP()-2400000 group by username order by username ASC	+	|where=forumid IN (8,221,242) AND post.dateline >= UNIX_TIMESTAMP()-2400000 group by username order by count(thread.title) DESC
	|data=mageposts=count(thread.title),magename=username		|data=mageposts=count(thread.title),magename=username
	}}{{#get_db_data:db=nwod		}}{{#get_db_data:db=nwod
	|from=post JOIN thread ON (thread.threadid = post.threadid)		|from=post JOIN thread ON (thread.threadid = post.threadid)
-	|where=forumid IN (5,200,210) AND post.dateline >= UNIX_TIMESTAMP()-2400000 group by username order by username ASC	+	|where=forumid IN (5,200,210) AND post.dateline >= UNIX_TIMESTAMP()-2400000 group by username order by count(thread.title) DESC
	|data=vampireposts=count(thread.title),vampirename=username		|data=vampireposts=count(thread.title),vampirename=username
	}}{{col-begin|width=100%}}		}}{{col-begin|width=100%}}

---

Revision as of 01:16, 23 June 2016

Changeling Circe,35 Kray,32 Mina,15 Jack Violet,13 Saber Sloth,13 Svelte Sven,8 Sonnie Wu,8 Ellaria Undertow,7

Mage Chambers,46 Aurora,43 Skye,35 Thirteen,26 ReubanBrightwood,25 Asclepius,25 Mateus,16 Witch,8 Salem,1

Vampire Alessandra,25 Otto Schneider,22 Seryna,18 Jennifer Hazelton,17 Kylar Stern,11 Diana Warren,8 Alicia Silvers,3 Neville Godwin,2 Raul,1