Template:Character
From Edge of Darkness Wiki
Character
(Added db fetch for one account, main name and ID) |
|||
| Line 2: | Line 2: | ||
|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|}}} | + | |where=user.userid='{{{forumid|}}}' |data={{{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, '%M %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(user.lastactivity, '%M %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, '%M %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}} | ||
Revision as of 14:28, 28 December 2016
[create] 
Template documentation
Template documentation| Editors can experiment in this template's sandbox (create). Subpages of this template: |
