Template:Character
From Edge of Darkness Wiki
Character
m |
m |
||
| Line 225: | Line 225: | ||
|from=post JOIN thread ON (thread.threadid = post.threadid) | |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 = '{{{forumid|}}}' AND thread.prefixid IN ('City','consilium','freehold_status') AND thread.lastpost >= UNIX_TIMESTAMP()-10000000 | |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 = '{{{forumid|}}}' AND thread.prefixid IN ('City','consilium','freehold_status') AND thread.lastpost >= UNIX_TIMESTAMP()-10000000 | ||
| - | |data={{{forumid|}}}statusfor=thread.title,{{{forumid|}}}statusgiven=(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) | + | |data={{{forumid|}}}statusfor=thread.title,{{{forumid|}}}statusgiven=(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) |
| + | }}{{dontshow|{{#for_external_table: [[{{{{{{forumid|}}}statusgiven}}}::{{{{{{forumid|}}}statusfor}}}]] }}}}</includeonly> | ||
Revision as of 18:00, 18 May 2016
[create] 
Template documentation
Template documentation| Editors can experiment in this template's sandbox (create). Subpages of this template: |
