Posting Activity/Data

From Edge of Darkness Wiki

Posting Activity/Data
Jump to: navigation, search
m
m
Line 2: Line 2:
|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 count(thread.title) DESC
|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,changelingid=userid
}}{{#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 count(thread.title) DESC
|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,mageid=userid
}}{{#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 count(thread.title) DESC
|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,vampireid=userid
}}{{col-begin|width=100%}}
}}{{col-begin|width=100%}}
{{col-break|width=33%}}
{{col-break|width=33%}}
==Changeling==
==Changeling==
-
{{#for_external_table: {{{changelingname}}},{{{changelingposts}}}<br /> }}
+
{{#for_external_table: [http://nwod.org/forum/member.php?{{{changelingid}}} {{{changelingname}}}],{{{changelingposts}}}<br /> }}
{{col-break|width=33%}}
{{col-break|width=33%}}
==Mage==
==Mage==
-
{{#for_external_table: {{{magename}}},{{{mageposts}}}<br /> }}
+
{{#for_external_table: [http://nwod.org/forum/member.php?{{{mageid}}} {{{magename}}}],{{{mageposts}}}<br /> }}
{{col-break|width=33%}}
{{col-break|width=33%}}
==Vampire==
==Vampire==
-
{{#for_external_table: {{{vampirename}}},{{{vampireposts}}}<br /> }}
+
{{#for_external_table: [http://nwod.org/forum/member.php?{{{vampireid}}} {{{vampirename}}}],{{{vampireposts}}}<br /> }}
{{col-end}}
{{col-end}}

Revision as of 14:05, 23 June 2016

Changeling

Kray,53
Circe,45
Mina,26
Jack Violet,19
Saber Sloth,17
Sonnie Wu,10
Ellaria Undertow,9
Svelte Sven,6
Jasper,4

Mage

Thirteen,52
Aurora,43
Chambers,42
ReubanBrightwood,32
Skye,28
Salem,26
Asclepius,18
Witch,12

Vampire

Otto Schneider,16
Alicia Silvers,12
Seryna,11
Kylar Stern,11
Raul,9
Jennifer Hazelton,9
Alessandra,6

Personal tools
Namespaces
Variants
Actions
Navigation
games
Toolbox