Template:HuntLeaderboard: Difference between revisions

Content added Content deleted

Inline

Revision as of 09:20, 16 September 2022

No results

@@ Line 1: / Line 1: @@
 {{#cargo_query:
 tables=Leaderboard=lb
-|fields=lb.rank=Rank,CONCAT('[[', <!--COALESCE(lb.alias, lb.team), '|',--> lb.team, ']]')={{{team|Team}}}{{#if:{{{points|Solves}}}|,lb.points={{{points|Solves}}}|}}{{#if:{{{tiebreaker|}}}|,lb.tiebreaker={{{tiebreaker}}}|}}{{#if:{{{finishtime|Finish Time}}}|,lb.finishtime={{{finishtime|Finish Time}}}|}}{{#if:{{{comment|}}}|,lb.comment={{{comment}}}|}}
+|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}}}|}}
-|where=lb.hunt='{{{hunt|Galactic Puzzle Hunt 2022}}}' AND lb.rank>0
+|where=lb.hunt='{{{hunt|None}}}' AND lb.rank>0
 |order by=<!--lb.rank-->_rowID
 |limit={{{max_teams|30}}}
 |format=table
-|outro={{#if:{{{source|}}}|,[{{{source}}} Source] · |}}[[Data:{{{hunt|Galactic Puzzle Hunt 2022}}}|Edit data]]}}
+|outro={{#if:{{{source|}}}|,[{{{source}}} Source] · |}}[[Data:{{{hunt|None}}}|Edit data]]}}