Posting Activity/Data

From Edge of Darkness Wiki

You do not have permission to edit this page, for the following reason:

You can view and copy the source of this page:

{{#get_db_data:db=nwod |from=post JOIN thread ON (thread.threadid = post.threadid) |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 }}{{#get_db_data:db=nwod |from=post JOIN thread ON (thread.threadid = post.threadid) JOIN user ON (user.userid = post.userid) |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=user.username,mageid=user.userid }}{{#get_db_data:db=nwod |from=post JOIN thread ON (thread.threadid = post.threadid) |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 }}{{col-begin|width=100%}} {{col-break|width=33%}} ==Changeling== {{#for_external_table: [http://nwod.org/forum/member.php?{{{changelingid}}} {{{changelingname}}}],{{{changelingposts}}}<br /> }} {{col-break|width=33%}} ==Mage== {{#for_external_table: [http://nwod.org/forum/member.php?{{{mageid}}} {{{magename}}}],{{{mageposts}}}<br /> }} {{col-break|width=33%}} ==Vampire== {{#for_external_table: [http://nwod.org/forum/member.php?{{{vampireid}}} {{{vampirename}}}],{{{vampireposts}}}<br /> }} {{col-end}}

Return to Posting Activity/Data.