Template:TeamPrizeHistory: Difference between revisions
Template page
More actions
Esportsamaze (talk | contribs) No edit summary |
Esportsamaze (talk | contribs) No edit summary |
||
| Line 4: | Line 4: | ||
</noinclude><includeonly> | </noinclude><includeonly> | ||
== Earnings History == | == Earnings History == | ||
{{#cargo_query: | |||
|table=Tournament_Prizes | |||
|fields=SUM(money)=TotalWinnings | |||
|where=team='{{PAGENAME}}' | |||
|format=template | |||
|template=TotalEarningsDisplay | |||
}} | |||
{{#cargo_query: | {{#cargo_query: | ||
| Line 13: | Line 20: | ||
|format=template | |format=template | ||
|template=TeamPrizeHistoryRow | |template=TeamPrizeHistoryRow | ||
|intro=<table class="wikitable flat-table" style="width: | |named args=yes <-- THIS WAS MISSING! | ||
|intro=<table class="wikitable flat-table" style="width:100%; text-align:center;"> | |||
<tr> | <tr> | ||
<th style="text-align:left;">Tournament</th> | <th style="text-align:left;">Tournament</th> | ||
<th>Place</th> | <th>Place</th> | ||
<th style="text-align:right;">Prize Money</th> | <th style="text-align:right;">Prize Money</th> | ||
</tr> | </tr> | ||
|outro=</table> | |outro=</table> | ||
Revision as of 21:23, 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