Posting Activity/Data
From Edge of Darkness Wiki
Posting Activity/Data
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
ChangelingKray,53 |
MageThirteen,52 |
VampireOtto Schneider,16 |
