Template:HuntLeaderboard: Difference between revisions

Content added Content deleted
VisualWikitext
(Part 2 of real fix)
m (typo fix)
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{#cargo_query:
{{#cargo_query:
tables=Leaderboard=lb
tables=Leaderboard=lb
|fields=lb.rank=Rank,CONCAT('[[', IF(lb.alias IS NULL, '', CONCAT(lb.alias, '|')), lb.team, ']]')={{{team|}}}{{#if:{{{points|}}}|,lb.points={{{points|}}}|}}{{#if:{{{tiebreaker|}}}|,lb.tiebreaker={{{tiebreaker}}}|}}{{#if:{{{finishtime|}}}|,lb.finishtime={{{finishtime|}}}|}}{{#if:{{{comment|}}}|,lb.comment={{{comment}}}|}}
|fields=lb.rank=Rank,CONCAT('[[', IF(lb.alias IS NULL, '', CONCAT(lb.alias, '|')), lb.team, ']]')={{{team|Team}}}
{{#if:{{{points|}}}|,{{#if:{{{points_float|}}}|lb.points|FLOOR(lb.points)}}={{{points|Solves}}}|}}
⚫
|where=lb.hunt='{{{hunt|None}}}' AND lb.rank>0
{{#if:{{{tiebreaker|}}}|,{{#if:{{{tiebreaker_float|}}}|lb.tiebreaker|FLOOR(lb.tiebreaker)}}={{{tiebreaker|Tiebreaker}}}|}}
{{#if:{{{finishtime|}}}|,lb.finishtime={{{finishtime|Finish time}}}|}}
{{#if:{{{comment|}}}|,lb.comment={{{comment|Comments}}}|}}
⚫
|where=lb.hunt='{{{hunt|{{PAGENAME}}}}}' AND lb.rank>0
|order by=lb.rank
|order by=lb.rank
|limit={{{max_teams|30}}}
|limit={{{max_teams|30}}}
|format=table
|format=table
|outro={{#if:{{{source|}}}|,[{{{source}}} Source] · |}}[[Data:{{{hunt|None}}}|Edit data]]}}
|outro={{#if:{{{source|}}}|[{{{source}}} Source] · |}}[[Data:{{{hunt|{{PAGENAME}}}}}|Edit data]]}}
<noinclude>{{documentation}}</noinclude>

Latest revision as of 19:02, 8 December 2022

No results

Retrieved from "https://www.puzzles.wiki/wiki/Template:HuntLeaderboard?oldid=6858"