Guardians of the Veil/Masques - Revision history

West: moved Sandbox to Guardians of the Veil/Masques

2016-06-06T04:04:24Z

moved Sandbox to Guardians of the Veil/Masques

← Older revision

Revision as of 04:04, 6 June 2016

West at 04:03, 6 June 2016

2016-06-06T04:03:03Z

← Older revision		Revision as of 04:03, 6 June 2016
Line 1:		Line 1:
-	{~~{#get_db_data:db~~=~~nwod~~	+	{\|class="wikitable sortable"
-	~~\|from~~=~~post JOIN thread ON (thread~~.~~threadid = post.threadid) JOIN forum ON (forum.forumid = thread~~.~~forumid)~~	+	! data-sort-type="" \| Name!!Appearance!!Token!!Benefit!!Drawback!!Masques
-	\|~~where=thread~~.~~forumid IN (8~~,~~221~~,~~242,258) group by thread.title order by thread.lastpost desc LIMIT 20~~	+	\|-
-	\|~~data=mageforum=forum.title AS forum~~, ~~magethread=thread.title~~, ~~magedate=FROM_UNIXTIME(thread~~.~~lastpost, '%M %D') as date, mageposter=thread~~.~~lastposter~~, ~~magepostcount=count(postid)~~, ~~magepostid=post.postid, mageforumid=thread.forumid~~	+	\|Avenging Son\|\|Strong and energetic. Wears a uniform as a symbol of loyalty.\|\|A keepsake from a member of his “family.”\|\|Stamina rolls +1\|\|Subterfuge rolls -2\|\|Troubled Veteran, Renegade Cop, Ronin
-	}}	+	\|-
-	~~<table style="width:100%">~~	+	\|Holy Concubine\|\|A sensual style, less a matter of appearance than the confident, suggestive way in which she carries herself.\|\|Token of affection from one of her lovers.\|\|Persuasion rolls +1\|\|Empathy rolls -2\|\|Honeytrap, Succubus, Tantric Master
-	~~{{#for_external_table: [http://nwod~~.~~org/forum/showthread~~.~~php?p={{{magepostid}}}#post{{{magepostid}}} {{{magethread}}}] <br /><div style="margin-left:~~ 1~~.6em;"><small>{{{magepostcount}}} Posts~~, ~~Last By: '''{{{mageposter}}}''' {{{magedate}}}</small></div> }}~~	+	\|-
-	~~</table>~~	+	\|Lancet Master\|\|Dresses well, professional garb is spotless and the latest fashions.\|\|An unusually expensive tool used by her healing profession.\|\|Intelligence rolls used to practice her healing skill +1\|\|Socialize rolls -2\|\|Surgeon, Therapist, Celebrity, Cult Leader
		+	\|}

West at 16:04, 5 June 2016

2016-06-05T16:04:09Z

← Older revision		Revision as of 16:04, 5 June 2016
Line 1:		Line 1:
	{{#get_db_data:db=nwod		{{#get_db_data:db=nwod
-	\|from=~~user~~ JOIN ~~userfield~~ ON (~~userfield~~.~~userid~~ = ~~user~~.~~userid~~)	+	\|from=post JOIN thread ON (thread.threadid = post.threadid) JOIN forum ON (forum.forumid = thread.forumid)
-	\|where=~~user~~.~~usergroupid LIKE '50'~~	+	\|where=thread.forumid IN (8,221,242,258) group by thread.title order by thread.lastpost desc LIMIT 20
-	\|data=~~lastpost~~=~~from_unixtime~~(~~user~~.lastpost, '%M %D %Y'),~~lastactivity~~=~~from_unixtime(user~~.~~lastactivity~~, ~~'%M %D %Y'~~),~~venue~~=~~user~~.~~lastpostid~~,~~username~~=~~userfield~~.~~field109~~	+	\|data=mageforum=forum.title AS forum, magethread=thread.title, magedate=FROM_UNIXTIME(thread.lastpost, '%M %D') as date, mageposter=thread.lastposter, magepostcount=count(postid), magepostid=post.postid, mageforumid=thread.forumid
	}}		}}
-
-
	<table style="width:100%">		<table style="width:100%">
-	{{#for_external_table: ~~<tr><td>[~~[{{{~~username~~}}}]]</td><td>{{{~~lastpost~~}}}</td></tr>}}	+	{{#for_external_table: [http://nwod.org/forum/showthread.php?p={{{magepostid}}}#post{{{magepostid}}} {{{magethread}}}] <br /><div style="margin-left: 1.6em;"><small>{{{magepostcount}}} Posts, Last By: '''{{{mageposter}}}''' {{{magedate}}}</small></div> }}
	</table>		</table>

West at 14:41, 25 May 2016

2016-05-25T14:41:05Z

← Older revision		Revision as of 14:41, 25 May 2016
Line 2:		Line 2:
	\|from=user JOIN userfield ON (userfield.userid = user.userid)		\|from=user JOIN userfield ON (userfield.userid = user.userid)
	\|where=user.usergroupid LIKE '50'		\|where=user.usergroupid LIKE '50'
-	\|data=lastpost=from_unixtime(user.lastpost, '%M %D %Y'),lastactivity=from_unixtime(user.lastactivity, '%M %D %Y'),venue=user.lastpostid,userfield.field109~~,username=user.username~~	+	\|data=lastpost=from_unixtime(user.lastpost, '%M %D %Y'),lastactivity=from_unixtime(user.lastactivity, '%M %D %Y'),venue=user.lastpostid,username=userfield.field109
	}}		}}


-	~~{\| class~~="~~wikitable~~"	+	<table style="width:100%">
-	~~! Name~~	+	{{#for_external_table: <tr><td>[[{{{username}}}]]</td><td>{{{lastpost}}}</td></tr>}}
-	~~! Online~~	+	</table>
-	{{#~~display_external_table~~:~~template=OnlineTemplate\|data=~~username~~=username,lastpost=~~lastpost}}	+
-	\|}	+

West: Created page with "{{#get_db_data:db=nwod |from=user JOIN userfield ON (userfield.userid = user.userid) |where=user.usergroupid LIKE '50' |data=lastpost=from_unixtime(user.lastpost, '%M %D %Y'),..."

2016-05-25T13:49:40Z

Created page with "{{#get_db_data:db=nwod |from=user JOIN userfield ON (userfield.userid = user.userid) |where=user.usergroupid LIKE '50' |data=lastpost=from_unixtime(user.lastpost, '%M %D %Y'),..."

New page

{{#get_db_data:db=nwod
|from=user JOIN userfield ON (userfield.userid = user.userid)
|where=user.usergroupid LIKE '50'
|data=lastpost=from_unixtime(user.lastpost, '%M %D %Y'),lastactivity=from_unixtime(user.lastactivity, '%M %D %Y'),venue=user.lastpostid,userfield.field109,username=user.username
}}

{| class="wikitable"
! Name
! Online
{{#display_external_table:template=OnlineTemplate|data=username=username,lastpost=lastpost}}
|}