Revision as of 14:20, 19 May 2016

Changeling

December 2025

@@ Line 1: / Line 1: @@
-{{#get_db_data:db=nwod
+=Changeling=
- |from=post JOIN thread ON (thread.threadid = post.threadid)
+{{#ask: [[Concept:Active Changelings]]
- |where=thread.prefixid = 'City' AND post.iconid != '0' AND thread.forumid IN (61) AND post.username LIKE '%Asa%' AND thread.lastpost >= UNIX_TIMESTAMP()-10000000
+| ?Player
- |data=statusfor=thread.title,status=(case when post.iconid = 50 then 'Acknowledges' when post.iconid = 51 then 'Recognizes' when post.iconid = 52 then 'Values' when post.iconid = 53 then 'Respects' when post.iconid = 54 then 'Admires' end)
+| ?Last Post
+| ?Posted
+| mainlabel=Character Name
+| sort=Character Name
+| order=descending
+| format=calendar
+| template=OnlineCalendar
 }}
-{{#for_external_table:  {{#set:{{{status}}}={{{statusfor}}}}} }}