Template:HuntLeaderboard: Difference between revisions
Content added Content deleted
(Part 2 of real fix) |
(Now that points is properly a float class, add flags to modify whether points and tiebreaker should be displayed as a float.) |
||
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|} |
|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}}}|}} |
|||
{{#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|None}}}' AND lb.rank>0 |
|where=lb.hunt='{{{hunt|None}}}' AND lb.rank>0 |
||
|order by=lb.rank |
|order by=lb.rank |
Revision as of 21:19, 18 September 2022
No results