Template:Char
From Edge of Darkness Wiki
Char
| Line 6: | Line 6: | ||
{{{threadid|}}}statusorganization=COALESCE(uf1.field166, uf2.field166), | {{{threadid|}}}statusorganization=COALESCE(uf1.field166, uf2.field166), | ||
{{{threadid|}}}statusfamily=COALESCE(uf1.field167, uf2.field167), | {{{threadid|}}}statusfamily=COALESCE(uf1.field167, uf2.field167), | ||
| - | {{{threadid|}}}lastpostid=COALESCE(u1.lastpostid, u2.lastpostid), {{{threadid|}}}usergroupid=COALESCE(u1.usergroupid, u2.usergroupid), {{{threadid|}}}posts=COALESCE(u1.posts, u2.posts),{{{threadid|}}}venue=Venue, {{{threadid|}}}family=Family, {{{threadid|}}}kith=Kith, {{{threadid|}}}dualkith=DualKith, {{{threadid|}}}organization=Organization, {{{threadid|}}}presence=Presence, {{{threadid|}}}adv=Power, {{{threadid|}}}username=characters.char_name, {{{threadid|}}}mainname=characters.username, {{{threadid|}}}mainid=characters.userid, {{{threadid|}}}forumid=char_userid, {{{threadid|}}}avatar=customavatar.visible, {{{threadid|}}}ppic=customprofilepic.visible, {{{threadid|}}}refinement=Refinement, {{{threadid|}}}oneaccount=(CASE WHEN characters.userid = characters.char_userid THEN 'Yes' ELSE 'No' END), {{{threadid|}}}status=(CASE Status WHEN 'Active' THEN 'Active' WHEN 'Deceased' THEN 'Deceased' ELSE 'Inactive' END), {{{threadid|}}}troupelabel=(CASE Venue WHEN 'Changeling' THEN 'Motley' WHEN 'Mage' THEN 'Cabal' WHEN 'Vampire' THEN 'Coterie' WHEN 'Werewolf' THEN 'Pack' WHEN 'Hunter' THEN 'Cell' ELSE NULL END), {{{threadid|}}}citylabel=(CASE Venue WHEN 'Changeling' THEN 'Freehold' WHEN 'Mage' THEN 'Consilium' WHEN 'Vampire' THEN 'Domain' ELSE 'City' END), {{{threadid|}}}refinementlabel=(CASE Venue WHEN 'Changeling' THEN 'Entitlement' WHEN 'Mage' THEN 'Legacy' WHEN 'Vampire' THEN 'Bloodline' WHEN 'Werewolf' THEN 'Lodge' ELSE 'Refinement' END), {{{threadid|}}}organizationlabel=(CASE Venue WHEN 'Changeling' THEN 'Court' WHEN 'Mage' THEN 'Order' WHEN 'Vampire' THEN 'Covenant' WHEN 'Werewolf' THEN 'Tribe' WHEN 'Hunter' THEN 'Conspiracy' ELSE 'Org.' END), {{{threadid|}}}familylabel=(CASE Venue WHEN 'Changeling' THEN 'Seeming' WHEN 'Mage' THEN 'Path' WHEN 'Vampire' THEN 'Clan' WHEN 'Werewolf' THEN 'Auspice' WHEN 'Hunter' THEN 'Compact' ELSE 'Family' END), {{{threadid|}}}powerlabel=(CASE Venue WHEN 'Changeling' THEN 'Wyrd' WHEN 'Mage' THEN 'Gnosis' WHEN 'Vampire' THEN 'Blood Potency' WHEN 'Werewolf' THEN 'Primal Urge' ELSE NULL END) | + | {{{threadid|}}}lastpostid=COALESCE(u1.lastpostid, u2.lastpostid), {{{threadid|}}}usergroupid=COALESCE(u1.usergroupid, u2.usergroupid), {{{threadid|}}}posts=COALESCE(u1.posts, u2.posts),{{{threadid|}}}venue=Venue, {{{threadid|}}}family=Family, {{{threadid|}}}kith=Kith, |
| + | {{{threadid|}}}dualkith=IF(DualKith IS NULL OR DualKith = '', 'None', DualKith, | ||
| + | {{{threadid|}}}organization=Organization, {{{threadid|}}}presence=Presence, {{{threadid|}}}adv=Power, {{{threadid|}}}username=characters.char_name, {{{threadid|}}}mainname=characters.username, {{{threadid|}}}mainid=characters.userid, {{{threadid|}}}forumid=char_userid, {{{threadid|}}}avatar=customavatar.visible, {{{threadid|}}}ppic=customprofilepic.visible, {{{threadid|}}}refinement=Refinement, {{{threadid|}}}oneaccount=(CASE WHEN characters.userid = characters.char_userid THEN 'Yes' ELSE 'No' END), {{{threadid|}}}status=(CASE Status WHEN 'Active' THEN 'Active' WHEN 'Deceased' THEN 'Deceased' ELSE 'Inactive' END), {{{threadid|}}}troupelabel=(CASE Venue WHEN 'Changeling' THEN 'Motley' WHEN 'Mage' THEN 'Cabal' WHEN 'Vampire' THEN 'Coterie' WHEN 'Werewolf' THEN 'Pack' WHEN 'Hunter' THEN 'Cell' ELSE NULL END), {{{threadid|}}}citylabel=(CASE Venue WHEN 'Changeling' THEN 'Freehold' WHEN 'Mage' THEN 'Consilium' WHEN 'Vampire' THEN 'Domain' ELSE 'City' END), {{{threadid|}}}refinementlabel=(CASE Venue WHEN 'Changeling' THEN 'Entitlement' WHEN 'Mage' THEN 'Legacy' WHEN 'Vampire' THEN 'Bloodline' WHEN 'Werewolf' THEN 'Lodge' ELSE 'Refinement' END), {{{threadid|}}}organizationlabel=(CASE Venue WHEN 'Changeling' THEN 'Court' WHEN 'Mage' THEN 'Order' WHEN 'Vampire' THEN 'Covenant' WHEN 'Werewolf' THEN 'Tribe' WHEN 'Hunter' THEN 'Conspiracy' ELSE 'Org.' END), {{{threadid|}}}familylabel=(CASE Venue WHEN 'Changeling' THEN 'Seeming' WHEN 'Mage' THEN 'Path' WHEN 'Vampire' THEN 'Clan' WHEN 'Werewolf' THEN 'Auspice' WHEN 'Hunter' THEN 'Compact' ELSE 'Family' END), {{{threadid|}}}powerlabel=(CASE Venue WHEN 'Changeling' THEN 'Wyrd' WHEN 'Mage' THEN 'Gnosis' WHEN 'Vampire' THEN 'Blood Potency' WHEN 'Werewolf' THEN 'Primal Urge' ELSE NULL END) | ||
}}<!-- DB FOR AWARDS -->{{#get_db_data:db=nwod | }}<!-- DB FOR AWARDS -->{{#get_db_data:db=nwod | ||
|from=rank_user JOIN rank ON rank.rank_id = rank_user.rank_id | |from=rank_user JOIN rank ON rank.rank_id = rank_user.rank_id | ||
| Line 34: | Line 36: | ||
</div><div class="{{#external_value: {{{threadid|}}}venue}}page chartempwrapper {{#external_value: {{{threadid|}}}venue}}back" style="min-width: 600px;"> | </div><div class="{{#external_value: {{{threadid|}}}venue}}page chartempwrapper {{#external_value: {{{threadid|}}}venue}}back" style="min-width: 600px;"> | ||
{{#switch:{{{pic2|}}} | {{#switch:{{{pic2|}}} | ||
| - | |Yes=<div style="float: left; width: | + | |Yes=<div style="float: left; width: 215px; margin-right: 3px;"><div style="height: 200px; overflow: hidden;">[[Image:{{#external_value: {{{threadid|}}}username}}_2.jpg|200px|Click here to upload portrait.]]</div></div> |}} |
<div style="float: right; width: 200px; margin-right: 3px; margin-left: 20px;" id="newcharsidebar" > | <div style="float: right; width: 200px; margin-right: 3px; margin-left: 20px;" id="newcharsidebar" > | ||
<div style="height: 200px; overflow: hidden;">[[Image:{{#external_value: {{{threadid|}}}username}}.jpg|200px|Click here to upload portrait.]]</div> | <div style="height: 200px; overflow: hidden;">[[Image:{{#external_value: {{{threadid|}}}username}}.jpg|200px|Click here to upload portrait.]]</div> | ||
| Line 72: | Line 74: | ||
<td> | <td> | ||
{{#switch: {{#external_value: {{{threadid|}}}venue}} | {{#switch: {{#external_value: {{{threadid|}}}venue}} | ||
| - | |Changeling=<div style="font-size: 16px; font-weight: bold; white-space: nowrap;">[[Kith Primary::{{#external_value: {{{threadid|}}}kith}}]]{{#set:Kith={{#external_value: {{{threadid|}}}kith}} }}</div> | + | |Changeling= |
| - | + | ||
| - | + | <div style="font-size: 16px; font-weight: bold; white-space: nowrap;">[[Kith Primary::{{#external_value: {{{threadid|}}}kith}}]]{{#set:Kith={{#external_value: {{{threadid|}}}kith}} }}</div>{{#switch: {{#external_value: {{{threadid|}}}dualkith}} | |
| + | |None= | ||
| + | |<div style="font-size: 16px; font-weight: bold; white-space: nowrap;">[[Dual Kith::{{#external_value: {{{threadid|}}}dualkith}}]]{{#set:Kith={{#external_value: {{{threadid|}}}dualkith}} }}</div> | ||
| + | }}|<div>[[{{#external_value: {{{threadid|}}}familylabel}} Status::{{#if: {{#external_value: {{{threadid|}}}statusfamily}} |{{#external_value: {{{threadid|}}}statusfamily}}|0}}]]</div> | ||
}} | }} | ||
</td> | </td> | ||
Revision as of 23:54, 23 January 2017
[edit] [] 
Template documentation
Template documentationThis is the new character template that pulls information from the character database rather than being inputted manually or scraping minisheets.
It requires the character sheet number, and support flags for Avatar (Face Claim), Quote and pic2 (for Werewolves and Changelings). Three optional 'boxes' can be displayed. It should be used at the very top of the page in the following format:
{{Char
|threadid = 23
|Avatar = Gavin Rossdale
|pic2 = No
|box1 = foo
|box2 = bar
|box3 = foobar
|Quote = Lorna, smile upon your least favorite but best looking son tonight...
}}
Pages using this template should 'close' the page with the appropriate venue footer.
- Template:Changeling Character
- Template:Mage Character
- Template:Vampire Character
- Template:Werewolf Character
Example of options:
| The above documentation is transcluded from Template:Char/doc. (edit | history) Editors can experiment in this template's sandbox (create). Subpages of this template:
|
