Template:BCS cosmetic item list by hero
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