Posting Activity/Data
From Edge of Darkness Wiki
Posting Activity/Data
m |
m |
||
| Line 4: | Line 4: | ||
|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 | + | |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) | ||
Latest revision as of 00:59, 23 July 2016
ChangelingKray,44 |
MageCorn,46 |
VampireAlicia Silvers,23 |
