Template:TeamPrizeHistory: Difference between revisions

Revision as of 21:39, 11 January 2026

Displays a team's prize money history and total earnings. Usage:

Earnings History

Error 1054: Unknown column 'team' in 'WHERE'

Function: CargoSQLQuery::run Query: SELECT `Tournament_Prizes`.`_pageID` AS `cargo_backlink_page_id_Tournament_Prizes`,SUM(money) AS `TotalWinnings` FROM `cargo__Tournament_Prizes` `Tournament_Prizes` WHERE team='TeamPrizeHistory' ORDER BY `Tournament_Prizes`.`_pageID`,SUM(money) LIMIT 100

Error 1054: Unknown column 'team' in 'WHERE'

Function: CargoSQLQuery::run Query: SELECT `Tournament_Prizes`.`_pageID` AS `cargo_backlink_page_id_Tournament_Prizes`,`tournament` AS `tournament`,`place` AS `place`,`money` AS `money` FROM `cargo__Tournament_Prizes` `Tournament_Prizes` WHERE team='TeamPrizeHistory' ORDER BY `money` DESC LIMIT 100

@@ Line 4: / Line 4: @@
 </noinclude><includeonly>
 == Earnings History ==
 {{#cargo_query:
 |table=Tournament_Prizes
@@ Line 12: / Line 13: @@
 |named args=yes
 }}
 {{#cargo_query:
 |table=Tournament_Prizes
@@ Line 21: / Line 21: @@
 |format=template
 |template=TeamPrizeHistoryRow
-|intro=<table class="wikitable flat-table" style="width:500px; text-align:center;">
+|intro=<table class="wikitable flat-table" style="width:500px; text-align:center;"><tr><th style="text-align:left;">Tournament</th><th>Ranked</th><th style="text-align:right;">Prize Money</th></tr>
-<tr><th style="text-align:left;">Tournament</th><th>Ranked</th><th style="text-align:right;">Prize Money</th></tr>
 |outro=</table>
 |default=<p>''No prize data recorded for this team.''</p>
 }}
 </includeonly>