Posting Activity/Data
From Edge of Darkness Wiki
Posting Activity/Data
m |
m |
||
| (One intermediate revision 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,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) 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,mageid=userid | + | |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,vampireid=userid | |data=vampireposts=count(thread.title),vampirename=username,vampireid=userid | ||
}}{{col-begin|width=100%}} | }}{{col-begin|width=100%}} | ||
Latest revision as of 00:59, 23 July 2016
ChangelingKray,44 |
MageCorn,46 |
VampireAlicia Silvers,23 |
