Template:Character

From Edge of Darkness Wiki

Character
Jump to: navigation, search
m
m
Line 41: Line 41:
|data={{{forumid|}}}forumid=userid,{{{forumid|}}}posts=posts,{{{forumid|}}}lastpost=from_unixtime(lastpost, '%M %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(lastactivity, '%M %D %Y'),{{{forumid|}}}lastpostid=lastpostid
|data={{{forumid|}}}forumid=userid,{{{forumid|}}}posts=posts,{{{forumid|}}}lastpost=from_unixtime(lastpost, '%M %D %Y'),{{{forumid|}}}lastvisit=from_unixtime(lastactivity, '%M %D %Y'),{{{forumid|}}}lastpostid=lastpostid
}}{{#set:Page has default form=Edit {{{Venue|}}} Character|Venue={{{Venue|}}}|Character Type={{{Venue|}}}}}
}}{{#set:Page has default form=Edit {{{Venue|}}} Character|Venue={{{Venue|}}}|Character Type={{{Venue|}}}}}
-
}}<!-- DB FROM VENUE FOR QUOTES PAGE -->{{#switch: {{#show: {{PAGENAME}} |?Venue# }}
+
}}<!-- DB FROM VENUE FOR QUOTES PAGE -->{{#get_db_data:db=nwod
-
|Changeling = {{#get_db_data:db=nwod
+
|from=post JOIN thread ON (thread.threadid = post.threadid)
-
|from=post JOIN thread ON (thread.threadid = post.threadid)
+
|where=thread.forumid IN (98,258,61) AND post.iconid IN (50,51,52,53,54) AND post.userid = '{{{forumid|}}}' AND thread.prefixid IN ('freehold_status','consilium','City') AND thread.lastpost >= UNIX_TIMESTAMP()-10000000
-
|where=thread.forumid IN (98) AND post.iconid IN (50,51,52,53,54) AND post.userid = '{{{forumid|}}}' AND thread.prefixid IN ('freehold_status') AND thread.lastpost >= UNIX_TIMESTAMP()-10000000
+
|data={{{forumid|}}}statusfor=thread.title,{{{forumid|}}}statusgiven=(case when post.iconid = 50 then 'Acknowledges' when post.iconid = 51 then 'Recognizes' when post.iconid = 52 then 'Values' when post.iconid = 53 then 'Respects' when post.iconid = 54 then 'Admires' end)
-
|data={{{forumid|}}}statusfor=thread.title,{{{forumid|}}}statusgiven=(case when post.iconid = 50 then 'Acknowledges' when post.iconid = 51 then 'Recognizes' when post.iconid = 52 then 'Values' when post.iconid = 53 then 'Respects' when post.iconid = 54 then 'Admires' end)
+
-
}}
+
-
|Mage = {{#get_db_data:db=nwod
+
-
|from=post JOIN thread ON (thread.threadid = post.threadid)
+
-
|where=thread.forumid IN (258) AND post.iconid IN (50,51,52,53,54) AND post.userid = '{{{forumid|}}}' AND thread.prefixid IN ('consilium') AND thread.lastpost >= UNIX_TIMESTAMP()-10000000
+
-
|data={{{forumid|}}}statusfor=thread.title,{{{forumid|}}}statusgiven=(case when post.iconid = 50 then 'Acknowledges' when post.iconid = 51 then 'Recognizes' when post.iconid = 52 then 'Values' when post.iconid = 53 then 'Respects' when post.iconid = 54 then 'Admires' end)
+
-
}}
+
-
|Vampire = {{#get_db_data:db=nwod
+
-
|from=post JOIN thread ON (thread.threadid = post.threadid)
+
-
|where=thread.forumid IN (61) AND post.iconid IN (50,51,52,53,54) AND post.userid = '{{{forumid|}}}' AND thread.prefixid IN ('City') AND thread.lastpost >= UNIX_TIMESTAMP()-10000000
+
-
|data={{{forumid|}}}statusfor=thread.title,{{{forumid|}}}statusgiven=(case when post.iconid = 50 then 'Acknowledges' when post.iconid = 51 then 'Recognizes' when post.iconid = 52 then 'Values' when post.iconid = 53 then 'Respects' when post.iconid = 54 then 'Admires' end)
+
-
}}
+
}}<!---- END DB GET ---->{{#set:  
}}<!---- END DB GET ---->{{#set:  
forumid={{{forumid|}}}
forumid={{{forumid|}}}

Revision as of 15:15, 23 May 2016

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