Posting Activity/Data
From Edge of Darkness Wiki
Posting Activity/Data
m |
m |
||
| 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,changelingid=userid | |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.userid NOT IN ('2008','1','1418','2','866','2865','2446','2193','1863','2588','1317') AND post.dateline >= UNIX_TIMESTAMP()-2400000 group by username order by count(thread.title) DESC |
|data=mageposts=count(thread.title),magename=username,mageid=userid | |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.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,vampireid=userid | |data=vampireposts=count(thread.title),vampirename=username,vampireid=userid | ||
}}{{col-begin|width=100%}} | }}{{col-begin|width=100%}} | ||
Revision as of 19:53, 21 July 2016
ChangelingKray,44 |
MageReubanBrightwood,64 |
VampireAlicia Silvers,23 |
