Template:BCS cosmetic item list by hero: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 5: | Line 5: | ||
CONCAT(CASE WHEN items.introduced IS NULL THEN "Launch" ELSE CONCAT("[[Bloons Card Storm v", items.introduced, "|Version ", items.introduced, "]]") END) = Introduced | CONCAT(CASE WHEN items.introduced IS NULL THEN "Launch" ELSE CONCAT("[[Bloons Card Storm v", items.introduced, "|Version ", items.introduced, "]]") END) = Introduced | ||
|where = | |where =items.applies_to HOLDS "{{{1|}}}" | ||
|join on =items.id = rewards.item | |join on =items.id = rewards.item | ||
|group by=items._pageName, items.name, items.image, items.introduced, rewards.item | |group by=items._pageName, items.name, items.image, items.introduced, rewards.item | ||
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 `items`.`_ID` IN (SELECT `_rowID` FROM `cargo__bcs_cosmetic_items__applies_to` WHERE `_value`= "Quincy") GROUP BY `items`.`_pageName`, `items`.`name`, `items`.`image`, `items`.`introduced`, `rewards`.`item` ORDER BY `items`.`category` LIMIT 100