Template:BCS cosmetic item list by hero: Difference between revisions
Created page with "<includeonly><div class="center-col-2 center-col-4 responsive-block-col-1">{{#cargo_query:tables=bcs_cosmetic_items=items, bcs_rewards=rewards |fields=CONCAT("30px|link=", items._pageName, "|Icon of ", items.name, " ", items.name) = Item, CONCAT("", items.category, "") = Category, GROUP_CONCAT(rewards.name SEPARATOR ", ") = Unlock method(s), CONCAT(CASE WHEN items.introduced IS NULL THEN "Launch" ELSE CONCAT("Bloons..." |
mNo edit summary |
||
| Line 10: | Line 10: | ||
|order by=items.category | |order by=items.category | ||
}}</div>{{#cargo_store:_table=bcs_rewards | }}</div>{{#cargo_store:_table=bcs_rewards | ||
| | |item ={{{level 10|}}} | ||
| | |name =Level 10 {{{hero|}}} | ||
|amount=1 | |||
}}{{#cargo_store:_table=bcs_rewards | }}{{#cargo_store:_table=bcs_rewards | ||
|name=Level 10 {{{hero|}}} | |name =Level 10 {{{hero|}}} | ||
|item={{{level 15|}}} | |item ={{{level 15|}}} | ||
|amount=1 | |||
}}</includeonly><noinclude>{{#cargo_attach:_table=bcs_rewards}}{{/doc}}</noinclude> | }}</includeonly><noinclude>{{#cargo_attach:_table=bcs_rewards}}{{/doc}}</noinclude> | ||
Revision as of 10:39, 24 July 2025
This template adds rows to the table "bcs_rewards", which is declared by the template BCS rewards. View table.
Generates a table of cosmetic items in Bloons Card Storm that are equippable to a specific Hero using a Cargo query. This template also stores the IDs of the cosmetic items unlocked at levels 10 and 15 to "bcs_rewards".
| Parameter | Description | Type | Status | |
|---|---|---|---|---|
| Hero | 1 | no description | String | required |
| Level 10 cosmetic item ID | level 10 | no description | String | required |
| Level 15 cosmetic item ID | level 15 | no description | String | required |
Example usage
{{BCS cosmetic item list by hero|Quincy|level 10=CardBackQuincyMasterHero|level 15=AltQuincyHeroCard01}}
Function: CargoSQLQuery::run Query: SELECT CONCAT("Icon of ", `items`.`name`, " ", `items`.`name`) AS `Item`,CONCAT("", `items`.`category`, "") AS `Category`,GROUP_CONCAT(`rewards`.`name` SEPARATOR ", ") AS `Unlock method(s)`,CONCAT(CASE WHEN `items`.`introduced` IS NULL THEN "Launch" ELSE CONCAT("Version ", `items`.`introduced`, "") END) AS `Introduced` FROM `cargo__bcs_cosmetic_items` `items` LEFT OUTER JOIN `cargo__bcs_rewards` `rewards` ON ((`items`.`id`=`rewards`.`item`)) WHERE card = "Quincy" GROUP BY `items`.`_pageName`, `items`.`name`, `items`.`image`, `items`.`introduced`, `rewards`.`item` ORDER BY `items`.`category` LIMIT 100