Template:BTD6 hero list by insta
Uses Cargo to create a list of Heroes and Hero Skins that have towers of a specified type in their starting party in Rogue Legends.
| Parameter | Description | Type | Status | |
|---|---|---|---|---|
| ID | 1 | The ID of the tower to use. (For all relevant towers, this is just the tower's name with no spaces.)
| String | required |
Example usage
{{BTD6 hero list by insta|BombShooter}}
Function: CargoSQLQuery::run Query: SELECT CONCAT("", name, " ", name, "") AS `Hero`,COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_1, ",", rl_tower_1_upgrades, "}}"), "—") AS `Insta Monkey 1`,COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_2, ",", rl_tower_2_upgrades, "}}"), "—") AS `Insta Monkey 2` FROM `cargo__btd6_heroes` `btd6_heroes` WHERE rl_tower_1="BombShooter" OR rl_tower_2="BombShooter" ORDER BY CONCAT("", name, " ", name, ""),COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_1, ",", rl_tower_1_upgrades, "}}"), "—"),COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_2, ",", rl_tower_2_upgrades, "}}"), "—") LIMIT 100