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>{{#cargo_compound_query:
tables=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,  
Line 5: Line 5:
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
;where=rl_tower_1="{{{1|}}}" OR rl_tower_2="{{{1|}}}"
;where=rl_tower_1="{{{1|}}}" OR rl_tower_2="{{{1|}}}"
;order by=category_order


|tables=btd6_hero_skins
|tables=btd6_hero_skins
Line 11: Line 12:
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
;where=rl_tower_1="{{{1|}}}" OR rl_tower_2="{{{1|}}}"
;where=rl_tower_1="{{{1|}}}" OR rl_tower_2="{{{1|}}}"
;order by=category_order
|format=table
|format=table
}}</div></includeonly><noinclude>{{/doc}}</noinclude>
}}</includeonly><noinclude>{{/doc}}</noinclude>

Revision as of 19:46, 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 `category_order` LIMIT 100

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