Template:Char
From Edge of Darkness Wiki
Char
| Line 2: | Line 2: | ||
|from=characters LEFT JOIN user u1 ON u1.userid = characters.char_userid LEFT JOIN user u2 ON u2.userid = characters.userid LEFT JOIN userfield uf1 ON uf1.userid = u1.userid LEFT JOIN userfield uf2 ON uf2.userid = u2.userid LEFT JOIN customavatar ON customavatar.userid = u1.userid LEFT JOIN customprofilepic ON customprofilepic.userid = u1.userid | |from=characters LEFT JOIN user u1 ON u1.userid = characters.char_userid LEFT JOIN user u2 ON u2.userid = characters.userid LEFT JOIN userfield uf1 ON uf1.userid = u1.userid LEFT JOIN userfield uf2 ON uf2.userid = u2.userid LEFT JOIN customavatar ON customavatar.userid = u1.userid LEFT JOIN customprofilepic ON customprofilepic.userid = u1.userid | ||
|where=characters.threadid='{{{threadid|}}}' | |where=characters.threadid='{{{threadid|}}}' | ||
| - | |data={{{threadid|}}}usertitle=COALESCE(u1.usertitle, u2.usertitle), {{{threadid|}}}mask=COALESCE(uf1.field173, uf2.field173), {{{threadid|}}}lastpost=COALESCE(u1.lastpost, u2.lastpost), {{{threadid|}}}lastvisit=COALESCE(u1.lastactivity, u2.lastactivity), {{{threadid|}}}joindate=COALESCE(u1.joindate, created, u2.joindate), {{{threadid|}}}statusvenue=COALESCE(uf1.field165, uf2.field165), {{{threadid|}}}statusvenue=COALESCE(uf1.field166, uf2.field166), {{{threadid|}}}statusvenue=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 ' | + | |data={{{threadid|}}}usertitle=COALESCE(u1.usertitle, u2.usertitle), {{{threadid|}}}mask=COALESCE(uf1.field173, uf2.field173), {{{threadid|}}}lastpost=COALESCE(u1.lastpost, u2.lastpost), {{{threadid|}}}lastvisit=COALESCE(u1.lastactivity, u2.lastactivity), {{{threadid|}}}joindate=COALESCE(u1.joindate, created, u2.joindate), {{{threadid|}}}statusvenue=COALESCE(uf1.field165, uf2.field165), {{{threadid|}}}statusvenue=COALESCE(uf1.field166, uf2.field166), {{{threadid|}}}statusvenue=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) |
}}<!-- 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 17: | Line 17: | ||
|Character Name={{#external_value: {{{threadid|}}}username}} | |Character Name={{#external_value: {{{threadid|}}}username}} | ||
|Avatar={{#if: {{{Avatar|}}}|{{{Avatar|}}}|Unknown}} | |Avatar={{#if: {{{Avatar|}}}|{{{Avatar|}}}|Unknown}} | ||
| + | |PC or NPC=PC | ||
|Lived In=Sacramento | |Lived In=Sacramento | ||
| + | |Character Status={{#external_value:{{{threadid|}}}status}} | ||
|Sacramento Start={{#external_value:{{{threadid|}}}joindate}} | |Sacramento Start={{#external_value:{{{threadid|}}}joindate}} | ||
|Sacramento End={{#external_value:{{{threadid|}}}lastpost}} | |Sacramento End={{#external_value:{{{threadid|}}}lastpost}} | ||
| + | |{{#external_value:{{{threadid|}}}citylabel}} Status={{#external_value:{{{threadid|}}}citystatus}} | ||
| + | |Presence={{#external_value:{{{threadid|}}}presence}} | ||
| + | |Character Type={{#external_value:{{{threadid|}}}venue}} | ||
| + | |Venue={{#external_value:{{{threadid|}}}venue}} | ||
| + | |Dual Kith={{#external_value:{{{threadid|}}}dualkith}} | ||
| + | |Kith Primary={{#external_value:{{{threadid|}}}kith}} | ||
| + | |Kith={{#external_value:{{{threadid|}}}kith}} | ||
| + | |Kith={{#external_value:{{{threadid|}}}dualkith}} | ||
| + | |{{#external_value:{{{threadid|}}}organizationlabel}} Status={{#external_value:{{{threadid|}}}organizationstatus}} | ||
| + | |{{#external_value:{{{threadid|}}}organizationlabel}}={{#external_value:{{{threadid|}}}organization}} | ||
| + | |Player{{#external_value:{{{threadid|}}}mainname}} | ||
| + | |PlayerID={{#external_value:{{{threadid|}}}mainid}} | ||
| + | |{{#external_value:{{{threadid|}}}familylabel}}={{#external_value:{{{threadid|}}}family}} | ||
}}<div style="position: absolute; right: 0px; top: -25px;"> | }}<div style="position: absolute; right: 0px; top: -25px;"> | ||
{{#for_external_table: <div style="display: inline; padding-left: 3px;" ><html><a href="http://nwod.org/forum/member.php?</html>{{#external_value: {{{threadid|}}}forumid }}<html>&tab=myranks" title="</html>{{{{{{threadid|}}}rankname}}}<html>"><img src="http://nwod.org/forum/</html>{{{{{{threadid|}}}rankimage}}}<html>" /></a></html></div> }} | {{#for_external_table: <div style="display: inline; padding-left: 3px;" ><html><a href="http://nwod.org/forum/member.php?</html>{{#external_value: {{{threadid|}}}forumid }}<html>&tab=myranks" title="</html>{{{{{{threadid|}}}rankname}}}<html>"><img src="http://nwod.org/forum/</html>{{{{{{threadid|}}}rankimage}}}<html>" /></a></html></div> }} | ||
