Template:Character

Character

Jump to: navigation, search

Revision as of 17:50, 18 May 2016

Template documentation

Editors can experiment in this template's sandbox (create). Subpages of this template:

@@ Line 222: / Line 222: @@
 						|}}{{#switch:{{{Retainer Type|}}}
 						|Ghoul = <div class="Ghoulbordercolor" style="float: right; margin-left: 10px; text-align: center;">[[Image:{{{Retainer Of|}}}.jpg|100px|alt={{{Retainer Of|}}}|link={{{Retainer Of|}}}]]</div>
-						|}}{{#clear_external_data:}}{{#get_db_data:db=nwod
+						|}}</includeonly>
- |from=post JOIN thread ON (thread.threadid = post.threadid)
- |where=thread.forumid IN ({{#switch:{{#show: {{BASEPAGENAME}} |?Venue#= }}|Changeling=98|Mage=258|Vampire=61|61,258,98}}) AND
-post.iconid IN (50,51,52,53,54) AND
-post.userid = '{{#show: {{BASEPAGENAME}} |?forumid }}' AND
-thread.prefixid IN ('City','consilium','freehold_status') AND
-thread.lastpost >= UNIX_TIMESTAMP()-10000000
- |data={{#show: {{BASEPAGENAME}} |?forumid }}statusfor=thread.title,{{#show: {{BASEPAGENAME}} |?forumid }}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),{{{forumid|}}}venue=(case when thread.forumid = 61 then 'Vampire' when thread.forumid = 258 then 'Mage' when thread.forumid = 98 then 'Changeling' end)}}{{dontshow|{{#for_external_table:  [[{{{{{#show: {{BASEPAGENAME}} |?forumid }}status}}}::{{{{{#show: {{BASEPAGENAME}} |?forumid }}statusfor}}}]] }}}}</includeonly>