Template:Character

From Edge of Darkness Wiki

Character
Jump to: navigation, search
m
m
Line 1: Line 1:
-
<noinclude>{{documentation}}[[Category:Character Templates|{{PAGENAME}}]]</noinclude><includeonly>{{#set:forumid={{{forumid|}}}}}{{#switch:{{{Player Name|}}}
+
<noinclude>{{documentation}}[[Category:Character Templates|{{PAGENAME}}]]</noinclude><includeonly>{{#clear_external_data:}}{{#get_db_data:db=nwod
 +
|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
 +
|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}}}]] }}}}{{#set:forumid={{{forumid|}}}}}{{#switch:{{{Player Name|}}}
|NPC=
|NPC=
|{{#ask: [[User:{{{Player Name|}}}]] |?forumid= |?forumname= |format=template |template=PlayerAvatar }}
|{{#ask: [[User:{{{Player Name|}}}]] |?forumid= |?forumname= |format=template |template=PlayerAvatar }}
Line 222: Line 226:
|}}{{#switch:{{{Retainer Type|}}}
|}}{{#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>
|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 = '{{{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)
+
-
}}{{dontshow|{{#for_external_table:  [[{{{{{{forumid|}}}statusgiven}}}::{{{{{{forumid|}}}statusfor}}}]] }}}}</includeonly>
+

Revision as of 18:00, 18 May 2016

[create] Template documentation
Personal tools
Namespaces
Variants
Actions
Navigation
games
Toolbox