Template:TeamPrizeHistory: Difference between revisions
Template page
More actions
Esportsamaze (talk | contribs) Created page with "<noinclude> Displays a team's prize money history and total earnings. Usage: {{TeamPrizeHistory}} </noinclude><includeonly> == Earnings History == {{#cargo_query: |table=Tournament_Prizes |fields=SUM(money)=TotalWinnings |where=team='{{PAGENAME}}' |format=template |template=TotalEarningsDisplay }} {{#cargo_query: |table=Tournament_Prizes |fields=tournament, place, money |where=team='{{PAGENAME}}' |order by=money DESC |limit=10 |format=template |template=TeamPrizeHistory..." |
Esportsamaze (talk | contribs) No edit summary |
||
| Line 22: | Line 22: | ||
|intro=<table class="wikitable flat-table" style="width:100%; text-align:center;"> | |intro=<table class="wikitable flat-table" style="width:100%; text-align:center;"> | ||
<tr> | <tr> | ||
<th style="text-align:left;">Tournament</th> | |||
<th>Place</th> | |||
<th style="text-align:right;">Prize Money</th> | |||
</tr> | </tr> | ||
|outro=</table> | |outro=</table> | ||
Revision as of 21:14, 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