Template:BTD6 hero list by insta: Difference between revisions

From Blooncyclopedia, the independent Bloons knowledge base
Jump to navigation Jump to search
← Older editNewer edit →
Polavux (talk | contribs)
Bureaucrats, Interface administrators, Administrators
58,352 edits
VisualWikitext
mNo edit summary
mNo edit summary
Line 1: Line 1:
<includeonly><div class="center-col-2 center-col-3">{{#cargo_compound_query:
<includeonly><div class="center-col-2 center-col-3">{{#cargo_compound_query:
table=btd6_heroes
tables=btd6_heroes
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|", name, "]] [[", _pageName, "|", name, "]]") = Hero,  
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|", name, "]] [[", _pageName, "|", name, "]]") = Hero,  
COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_1, ",", rl_tower_1_upgrades, "}}"), "—") = Insta Monkey 1,
COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_1, ",", rl_tower_1_upgrades, "}}"), "—") = Insta Monkey 1,
COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_2, ",", rl_tower_2_upgrades, "}}"), "—") = Insta Monkey 2
COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_2, ",", rl_tower_2_upgrades, "}}"), "—") = Insta Monkey 2
|table=btd6_hero_skins
;where=rl_tower_1="{{{1|}}}" OR rl_tower_2="{{{1|}}}"
 
|tables=btd6_hero_skins
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|", name, "]] [[", _pageName, "|", name, "]]") = Hero,  
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|", name, "]] [[", _pageName, "|", name, "]]") = Hero,  
COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_1, ",", rl_tower_1_upgrades, "}}"), "—") = Insta Monkey 1,
COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_1, ",", rl_tower_1_upgrades, "}}"), "—") = Insta Monkey 1,

Revision as of 19:42, 2 July 2025

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.

Template parameters[Edit template data]

This template prefers inline formatting of parameters.

ParameterDescriptionTypeStatus
ID1

The ID of the tower to use. (For all relevant towers, this is just the tower's name with no spaces.)

Example
BombShooter
Stringrequired

Example usage

{{BTD6 hero list by insta|BombShooter}}
Error 1054: Unknown column 'rl_tower_1' in 'field list'

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

Retrieved from "https://www.bloonswiki.com/index.php?title=Template:BTD6_hero_list_by_insta&oldid=84477"