Template:Character

From Edge of Darkness Wiki

Character
Jump to: navigation, search
Line 1: Line 1:
-
<includeonly>[[Category:{{{Player Name|}}}]]<!-- DB FOR USER INFO AND CHARACTER VARIABLES -->{{#if: {{{forumid|}}}|{{#if: {{{minisheet|}}}|{{#switch: {{{minisheet|}}}
+
<includeonly>[[Category:{{{Player Name|}}}]]<!-- DB FOR USER INFO AND CHARACTER VARIABLES -->{{#if: {{{threadid|}}}|{{#get_db_data:db=nwod
 +
|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
 +
|where=characters.threadid='{{{threadid|}}}'
 +
|data={{{forumid|}}}usertitle=COALESCE(u1.usertitle, u2.usertitle),
 +
{{{forumid|}}}mask=COALESCE(uf1.field173, uf2.field173),
 +
{{{forumid|}}}lastpost=COALESCE(from_unixtime(u1.lastpost, '%b %D %Y'), from_unixtime(u2.lastpost, '%b %D %Y')),
 +
{{{forumid|}}}lastvisit=COALESCE(from_unixtime(u1.lastactivity, '%b %D %Y'), from_unixtime(u2.lastactivity, '%b %D %Y')),
 +
{{{forumid|}}}joindate=COALESCE(from_unixtime(u1.joindate, '%b %D %Y'), from_unixtime(u2.joindate, '%b %D %Y')),
 +
{{{forumid|}}}statusvenue=COALESCE(uf1.field165, uf2.field165),
 +
{{{forumid|}}}statusorganization=COALESCE(uf1.field166, uf2.field166),
 +
{{{forumid|}}}statusfamily=COALESCE(uf1.field167, uf2.field167),
 +
{{{forumid|}}}lastpostid=COALESCE(u1.lastpostid, u2.lastpostid),
 +
{{{forumid|}}}usergroupid=COALESCE(u1.usergroupid, u2.usergroupid),
 +
{{{forumid|}}}oneaccount=COALESCE(uf1.field260, uf2.field260),
 +
{{{forumid|}}}posts=COALESCE(u1.posts, u2.posts),
 +
{{{forumid|}}}venue=Venue,
 +
{{{forumid|}}}family=Family,
 +
{{{forumid|}}}organization=Organization,
 +
{{{forumid|}}}presence=Presence,
 +
{{{forumid|}}}adv=Power,
 +
{{{forumid|}}}username=characters.char_name,
 +
{{{forumid|}}}mainname=characters.username,
 +
{{{forumid|}}}mainid=characters.userid,
 +
{{{forumid|}}}forumid=char_userid
 +
}}
 +
{{#set:Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character
 +
|Venue={{#external_value:{{{forumid|}}}venue}}
 +
|Character Type={{#external_value:{{{forumid|}}}venue}}
 +
}}
 +
|{{#if: {{{forumid|}}}|{{#if: {{{minisheet|}}}|{{#switch: {{{minisheet|}}}
|1={{#get_db_data:db=nwod
|1={{#get_db_data:db=nwod
|from=user JOIN userfield ON (userfield.userid = user.userid)
|from=user JOIN userfield ON (userfield.userid = user.userid)
-
|where=user.userid='{{{forumid|}}}' |data={{{forumid|}}}usertitle=user.usertitle,{{{forumid|}}}username=user.username,{{{forumid|}}}mainname=userfield.field164,{{{forumid|}}}mainid=userfield.field163,{{{forumid|}}}oneaccount=userfield.field260,{{{forumid|}}}forumid=user.userid,{{{forumid|}}}posts=user.posts,{{{forumid|}}}lastpost=from_unixtime(user.lastpost, '%b %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(user.lastactivity, '%b %D %Y'),{{{forumid|}}}lastpostid=user.lastpostid,{{{forumid|}}}venue=userfield.field101,{{{forumid|}}}family=userfield.field211,{{{forumid|}}}organization=userfield.field212,{{{forumid|}}}statusvenue=userfield.field165,{{{forumid|}}}statusorganization=userfield.field166,{{{forumid|}}}statusfamily=userfield.field167,{{{forumid|}}}presence=userfield.field132,{{{forumid|}}}adv=userfield.field159,{{{forumid|}}}mask=userfield.field173,{{{forumid|}}}usergroupid=user.usergroupid,{{{forumid|}}}joindate=from_unixtime(user.joindate, '%b %D %Y')}}{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}
+
|where=user.userid='{{{forumid|}}}' |data={{{forumid|}}}usertitle=user.usertitle,{{{forumid|}}}username=user.username,{{{forumid|}}}mainname=userfield.field164,{{{forumid|}}}mainid=userfield.field163,{{{forumid|}}}oneaccount=userfield.field260,{{{forumid|}}}forumid=user.userid,{{{forumid|}}}posts=user.posts,{{{forumid|}}}lastpost=from_unixtime(user.lastpost, '%b %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(user.lastactivity, '%b %D %Y'),{{{forumid|}}}lastpostid=user.lastpostid,{{{forumid|}}}venue=userfield.field101,{{{forumid|}}}family=userfield.field211,{{{forumid|}}}organization=userfield.field212,{{{forumid|}}}statusvenue=userfield.field165,{{{forumid|}}}statusorganization=userfield.field166,{{{forumid|}}}statusfamily=userfield.field167,{{{forumid|}}}presence=userfield.field132,{{{forumid|}}}adv=userfield.field159,{{{forumid|}}}mask=userfield.field173,{{{forumid|}}}usergroupid=user.usergroupid,{{{forumid|}}}joindate=from_unixtime(user.joindate, '%b %D %Y')}}
 +
{{#set:Minisheet{{{minisheet|}}}={{PAGENAME}}
|Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character
|Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character
|Venue={{#external_value:{{{forumid|}}}venue}}
|Venue={{#external_value:{{{forumid|}}}venue}}
Line 42: Line 72:
|Venue={{#external_value:{{{forumid|}}}venue}}
|Venue={{#external_value:{{{forumid|}}}venue}}
|Character Type={{#external_value:{{{forumid|}}}venue}}
|Character Type={{#external_value:{{{forumid|}}}venue}}
-
}}}}|{{#get_db_data:db=nwod|from=user JOIN userfield ON (userfield.userid = user.userid)|where=user.username LIKE '{{{Player Name|}}}'|data={{{forumid|}}}noinfouserid=user.userid,{{{forumid|}}}noinfousername=user.username}}{{#set:PlayerID={{#external_value: {{{forumid|}}}noinfouserid}}}}}}<!-- DB FROM VENUE FOR QUOTES PAGE -->{{#switch: {{#show: {{PAGENAME}} |?Venue# }}
+
}}}}|{{#get_db_data:db=nwod|from=user JOIN userfield ON (userfield.userid = user.userid)|where=user.username LIKE '{{{Player Name|}}}'|data={{{forumid|}}}noinfouserid=user.userid,{{{forumid|}}}noinfousername=user.username}}{{#set:PlayerID={{#external_value: {{{forumid|}}}noinfouserid}}}}}} }}
 +
<!-- DB FROM VENUE FOR QUOTES PAGE -->{{#switch: {{#show: {{PAGENAME}} |?Venue# }}
|Changeling = {{#get_db_data:db=nwod
|Changeling = {{#get_db_data:db=nwod
|from=post JOIN thread ON (thread.threadid = post.threadid) JOIN user ON (user.username = thread.title)
|from=post JOIN thread ON (thread.threadid = post.threadid) JOIN user ON (user.username = thread.title)

Revision as of 12:04, 23 January 2017

[create] Template documentation
Retrieved from "http://nwod.org/wiki/index.php/Template:Character"
Personal tools
Namespaces
Variants
Actions
Navigation
games
Toolbox