Posting Activity/Data - Revision history

West at 00:59, 23 July 2016

2016-07-23T00:59:17Z

← Older revision		Revision as of 00:59, 23 July 2016
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 ~~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	+	\|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)

West at 19:53, 21 July 2016

2016-07-21T19:53:25Z

West at 14:05, 23 June 2016

2016-06-23T14:05:05Z

← Older revision		Revision as of 14:05, 23 June 2016
Line 2:		Line 2:
	\|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.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)
	\|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.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=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.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}}

West at 01:27, 23 June 2016

2016-06-23T01:27:57Z

← Older revision		Revision as of 01:27, 23 June 2016
Line 14:		Line 14:
	{{col-break\|width=33%}}		{{col-break\|width=33%}}
	==Changeling==		==Changeling==
-	{{:~~Posting Activity~~/~~Changeling~~}}	+	{{#for_external_table: {{{changelingname}}},{{{changelingposts}}}<br /> }}
	{{col-break\|width=33%}}		{{col-break\|width=33%}}
	==Mage==		==Mage==

West at 01:25, 23 June 2016

2016-06-23T01:25:48Z

← Older revision		Revision as of 01:25, 23 June 2016
Line 14:		Line 14:
	{{col-break\|width=33%}}		{{col-break\|width=33%}}
	==Changeling==		==Changeling==
-	{{~~#for_external_table~~: ~~{{{changelingname}}},{{{changelingposts}}}<br~~ /> }}	+	{{:Posting Activity/Changeling}}
	{{col-break\|width=33%}}		{{col-break\|width=33%}}
	==Mage==		==Mage==

West at 01:16, 23 June 2016

2016-06-23T01:16:35Z

West at 14:45, 27 May 2016

2016-05-27T14:45:57Z

West at 14:28, 27 May 2016

2016-05-27T14:28:32Z

West: Created page with "{{#get_db_data:db=nwod |from=post JOIN thread ON (thread.threadid = post.threadid) |where=forumid IN (9,209,243) AND thread.lastpost >= UNIX_TIMESTAMP()-650000 group by usernam..."

2016-05-27T14:16:05Z

Created page with "{{#get_db_data:db=nwod |from=post JOIN thread ON (thread.threadid = post.threadid) |where=forumid IN (9,209,243) AND thread.lastpost >= UNIX_TIMESTAMP()-650000 group by usernam..."

New page

{{#get_db_data:db=nwod
|from=post JOIN thread ON (thread.threadid = post.threadid)
|where=forumid IN (9,209,243) AND thread.lastpost >= UNIX_TIMESTAMP()-650000 group by username
|data=changelingposts=count(thread.title),changelingname=username
}}{{#get_db_data:db=nwod
|from=post JOIN thread ON (thread.threadid = post.threadid)
|where=forumid IN (8,221,242) AND thread.lastpost >= UNIX_TIMESTAMP()-650000 group by username
|data=mageposts=count(thread.title),magename=username
}}{{#get_db_data:db=nwod
|from=post JOIN thread ON (thread.threadid = post.threadid)
|where=forumid IN (5,200,210) AND thread.lastpost >= UNIX_TIMESTAMP()-650000 group by username
|data=vampireposts=count(thread.title),vampirename=username
}}{{col-begin|width=100%}}
{{col-break|width=33%}}
==Changeling==
{{#for_external_table: {{{changelingname}}},{{{changelingposts}}}<br /> }}
{{col-break|width=33%}}
==Mage==
{{#for_external_table: {{{magename}}},{{{mageposts}}}<br /> }}
{{col-break|width=33%}}
==Vampire==
{{#for_external_table: {{{vampirename}}},{{{vampireposts}}}<br /> }}
{{col-end}}

← Older revision		Revision as of 19:53, 21 July 2016
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%}}

← Older revision		Revision as of 01:16, 23 June 2016
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 ~~username ASC~~	+	\|where=forumid IN (9,209,243) 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
	}}{{#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 ~~username ASC~~	+	\|where=forumid IN (8,221,242) 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=username
	}}{{#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 ~~username ASC~~	+	\|where=forumid IN (5,200,210) 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
	}}{{col-begin\|width=100%}}		}}{{col-begin\|width=100%}}

← Older revision		Revision as of 14:45, 27 May 2016
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 ~~thread~~.~~lastpost~~ >= UNIX_TIMESTAMP()-~~650000~~ group by username order by username ASC	+	\|where=forumid IN (9,209,243) AND post.dateline >= UNIX_TIMESTAMP()-2400000 group by username order by username ASC
	\|data=changelingposts=count(thread.title),changelingname=username		\|data=changelingposts=count(thread.title),changelingname=username
	}}{{#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 ~~thread~~.~~lastpost~~ >= UNIX_TIMESTAMP()-~~650000~~ group by username order by username ASC	+	\|where=forumid IN (8,221,242) AND post.dateline >= UNIX_TIMESTAMP()-2400000 group by username order by username ASC
	\|data=mageposts=count(thread.title),magename=username		\|data=mageposts=count(thread.title),magename=username
	}}{{#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 ~~thread~~.~~lastpost~~ >= UNIX_TIMESTAMP()-~~650000~~ group by username order by username ASC	+	\|where=forumid IN (5,200,210) AND post.dateline >= UNIX_TIMESTAMP()-2400000 group by username order by username ASC
	\|data=vampireposts=count(thread.title),vampirename=username		\|data=vampireposts=count(thread.title),vampirename=username
	}}{{col-begin\|width=100%}}		}}{{col-begin\|width=100%}}

← Older revision		Revision as of 14:28, 27 May 2016
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 thread.lastpost >= UNIX_TIMESTAMP()-650000 group by username	+	\|where=forumid IN (9,209,243) AND thread.lastpost >= UNIX_TIMESTAMP()-650000 group by username order by username ASC
	\|data=changelingposts=count(thread.title),changelingname=username		\|data=changelingposts=count(thread.title),changelingname=username
	}}{{#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 thread.lastpost >= UNIX_TIMESTAMP()-650000 group by username	+	\|where=forumid IN (8,221,242) AND thread.lastpost >= UNIX_TIMESTAMP()-650000 group by username order by username ASC
	\|data=mageposts=count(thread.title),magename=username		\|data=mageposts=count(thread.title),magename=username
	}}{{#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 thread.lastpost >= UNIX_TIMESTAMP()-650000 group by username	+	\|where=forumid IN (5,200,210) AND thread.lastpost >= UNIX_TIMESTAMP()-650000 group by username order by username ASC
	\|data=vampireposts=count(thread.title),vampirename=username		\|data=vampireposts=count(thread.title),vampirename=username
	}}{{col-begin\|width=100%}}		}}{{col-begin\|width=100%}}