Posting Activity/Data

From Edge of Darkness Wiki

Revision as of 14:16, 27 May 2016 (view source) West (Talk | contribs) m (Created page with "{{#get_db_data:db=nwod |from=post JOIN thread ON (thread.threadid = post.threadid) |where=forumid IN (9,209,243) AND thread.lastpost >= UNIX_TIMESTAMP()-650000 group by usernam...") ← Older edit		Revision as of 14:28, 27 May 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 thread.lastpost >= UNIX_TIMESTAMP()-650000 group by username	+	|where=forumid IN (9,209,243) AND thread.lastpost >= UNIX_TIMESTAMP()-650000 group by username order by username ASC
	|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 thread.lastpost >= UNIX_TIMESTAMP()-650000 group by username	+	|where=forumid IN (8,221,242) AND thread.lastpost >= UNIX_TIMESTAMP()-650000 group by username order by username ASC
	|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 thread.lastpost >= UNIX_TIMESTAMP()-650000 group by username	+	|where=forumid IN (5,200,210) AND thread.lastpost >= UNIX_TIMESTAMP()-650000 group by username order by username ASC
	|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 14:28, 27 May 2016

Changeling Circe,44 Jasper,3 Kray,55 Saber Sloth,22 Seraphina,22 Sonnie Wu,33 Svelte Sven,18 Vincent Black,18 Withers,17

Mage Asclepius,17 Aurora,21 Chambers,30 Corn,38 Eidolon,11 Guru,14 Philip Crosen,1 Phoenyx,2 ReubanBrightwood,55 Skye,19 Winter,31 Witch,14

Vampire Albert Baker,8 Alessandra,7 Alicia Silvers,23 Fast Eddie,1 Helen Kingsley,6 Jennifer Hazelton,14 Marcus Roman,14 Otto Schneider,8 Rebecca Dawson,4 Seryna,9