Template:TeamPastPerformances: Difference between revisions

Content added Content deleted
(default to PAGENAME)
(Add exclude_hunt and only_hunt parameters. Workshop subteams functionality for a later time.)
 
(4 intermediate revisions by 2 users not shown)
Line 2: Line 2:
tables=Leaderboard=lb,HuntData=hd
tables=Leaderboard=lb,HuntData=hd
|join on=lb.hunt=hd.hunt
|join on=lb.hunt=hd.hunt
|fields=hd.start_date=Date,lb.hunt=Hunt,IF(lb.rank < 0, 'Host', lb.rank)=Rank,CONCAT(IF(lb.alias IS NULL, '', CONCAT('as ', lb.team)), ' ', IF(lb.comment IS NULL, '', lb.comment))=Notes
|fields=hd.start_date=Date,lb.hunt=Hunt,
{{#if:{{{no_rank|}}}||IF(lb.rank < 0, 'Host', lb.rank)=Rank,}}
|where=(lb.team='{{{team|{{PAGENAME}}}}}' OR lb.alias='{{{team|{{PAGENAME}}}}}') AND lb.rank <= {{{max_rank|30}}}
CONCAT(IF(lb.alias IS NULL OR lb.team='{{{team|{{PAGENAME}}}}}', '', CONCAT('as ', lb.team, ' ')),
<!-- IF(lb.alias != {{{team|{{PAGENAME}}}}} AND lb.team != lb.alias != {{{team|{{PAGENAME}}}}}, 'Joint team', ''), -->
<!-- IF(lb.subteams = '', '', CONCAT('with ', lb.subteams, ' ')), -->
IF(lb.comment IS NULL, '', CONCAT('(',lb.comment,')')))=Notes
|where=(lb.team='{{{team|{{PAGENAME}}}}}' OR lb.alias='{{{team|{{PAGENAME}}}}}' <!-- OR lb.subteams HOLDS '{{{team|{{PAGENAME}}}}}' -->)
AND lb.rank <= {{{max_rank|30}}}
{{#if:{{{exclude_hunt|}}}| AND hd.franchise != '{{{exclude_hunt|}}}'|}}
{{#if:{{{only_hunt|}}}| AND hd.franchise = '{{{only_hunt|}}}'|}}
|order by=hd.start_date DESC
|order by=hd.start_date DESC
|format=table
|format=table
}}
}}
<noinclude>{{documentation}}</noinclude>

Latest revision as of 17:40, 3 October 2022

No results