Online

Online

Jump to: navigation, search

Latest revision as of 15:16, 25 May 2016

There's a better display on the Character List

@@ Line 1: / Line 1: @@
-{{#get_db_data:db=nwod
+There's a better display on the [http://nwod.org/forum/characterlist.php Character List]
- |from=post JOIN thread ON (thread.threadid = post.threadid)
- |where=thread.prefixid = 'City' AND post.iconid != '0' AND thread.forumid IN (61) AND post.username LIKE '%Asa%' AND thread.lastpost >= UNIX_TIMESTAMP()-10000000
- |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)
-}}
-{{#for_external_table:  {{#set:{{{status}}}={{{statusfor}}}}} }}