Posting Activity/Data
From Edge of Darkness Wiki
Posting Activity/Data
m |
m |
||
| (4 intermediate revisions not shown) | |||
| 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 count(thread.title) DESC | + | |where=forumid IN (9,209,243) AND post.userid NOT IN ('2008','2656','1','447','1651','1418') 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) JOIN user ON (user.userid = post.userid) |
| - | |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 user.usergroupid IN ('50') 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=user.username,mageid=user.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.userid NOT IN ('2008','1','1418','2','866','2865','2446','2193','817','2656','1863','2588','1317','2089','2750','1971') 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}} | ||
Latest revision as of 00:59, 23 July 2016
ChangelingKray,28 |
MageThirteen,47 |
VampireSeryna,15 |
