Blooncyclopedia

Template:BTD6 hero list by insta: Difference between revisions

← Older edit
Polavux (talk | contribs)
Bureaucrats, Interface administrators, Administrators
63,192 edits
VisualWikitext
mNo edit summary
changed it so instead of displaying heroes that have towers implicitly from their starting artifact, it just includes them in the table if their artifact has the tower
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
<includeonly><div class="center-col-2 center-col-3">{{#cargo_compound_query:
<includeonly>{{generic cargo compact list|table=btd6_hero_skins=skin, btd6_artifacts=artifact
tables=btd6_heroes
|col 1 name=Hero
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|", name, "]] [[", _pageName, "|", name, "]]") = Hero,
|name field=skin.name|image field=skin.icon|link field=skin._pageName
COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_1, ",", rl_tower_1_upgrades, "}}"), "—") = Insta Monkey 1,
|extra col 1=COALESCE(CONCAT("{{", "BTD6 insta{{!}}", skin.rl_tower_1, "{{!}}", skin.rl_tower_1_upgrades, "}}"), "—") = Insta Monkey 1
COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_2, ",", rl_tower_2_upgrades, "}}"), "—") = Insta Monkey 2
|extra col 2=COALESCE(CONCAT("{{", "BTD6 insta{{!}}", skin.rl_tower_2, "{{!}}", skin.rl_tower_2_upgrades, "}}"), "—") = Insta Monkey 2
;where=rl_tower_1="{{{1|}}}" OR rl_tower_2="{{{1|}}}"
|extra col 3=CONCAT("{{", "BTD6 artifact{{!}}", skin.rl_artifact, "}} ", skin.rl_artifact_rarity, COALESCE(CONCAT(" (adds {{", "BTD6 insta{{!}}",  
 
(CASE skin.rl_artifact_rarity WHEN "Common" THEN artifact.insta_type_common WHEN "Rare" THEN artifact.insta_type_rare WHEN "Legendary" THEN artifact.insta_type_legendary END),
|tables=btd6_hero_skins
"{{!}}",
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|", name, "]] [[", _pageName, "|", name, "]]") = Hero,  
(CASE skin.rl_artifact_rarity WHEN "Common" THEN artifact.insta_tiers_common WHEN "Rare" THEN artifact.insta_tiers_rare WHEN "Legendary" THEN artifact.insta_tiers_legendary END),
COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_1, ",", rl_tower_1_upgrades, "}}"), "—") = Insta Monkey 1,
"}})"), "")) = Artifact
COALESCE(CONCAT("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", rl_tower_2, ",", rl_tower_2_upgrades, "}}"), "—") = Insta Monkey 2
|order by=IF(skin.hero = skin.name, 0, 1), skin.numeric_id
;where=rl_tower_1="{{{1|}}}" OR rl_tower_2="{{{1|}}}"
|where=NOT xd_only AND (skin.rl_tower_1="{{{1|}}}" OR skin.rl_tower_2="{{{1|}}}" OR artifact.insta_type_common="{{{1|}}}" OR artifact.insta_type_rare="{{{1|}}}" OR artifact.insta_type_legendary="{{{1|}}}")
|format=table
|default=There are no starter parties that include this tower directly.
}}</div></includeonly><noinclude>{{/doc}}</noinclude>
|join on=skin.rl_artifact=artifact.name
}}</includeonly><noinclude>{{/doc}}</noinclude>
Retrieved from "https://www.bloonswiki.com/Template:BTD6_hero_list_by_insta"