Template:Character

From Edge of Darkness Wiki

Character
Jump to: navigation, search
Line 3: Line 3:
|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)
|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|}}}'
|where=characters.threadid='{{{threadid|}}}'
-
|data={{{forumid|}}}usertitle=COALESCE(u1.usertitle, u2.usertitle),
+
|data={{{forumid|}}}venue=Venue,
-
{{{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|}}}family=Family,
-
{{{forumid|}}}organization=Organization,
+
{{{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
{{#set:Page has default form=Edit {{#external_value:{{{forumid|}}}venue}} Character

Revision as of 12:11, 23 January 2017

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