Template:BTD6 hero list by insta: Difference between revisions
Created page with "<includeonly><div class="center-col-2 center-col-3">{{#cargo_compound_query: table=btd6_heroes ;fields=CONCAT("30px|link=", _pageName, "|", name, " ", 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_2, ",", rl_tower_2_upgrades, "}}"), "—") = Inst..." |
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 |
||
| (11 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<includeonly | <includeonly>{{generic cargo compact list|table=btd6_hero_skins=skin, btd6_artifacts=artifact | ||
|col 1 name=Hero | |||
|name field=skin.name|image field=skin.icon|link field=skin._pageName | |||
COALESCE(CONCAT("{{ | |extra col 1=COALESCE(CONCAT("{{", "BTD6 insta{{!}}", skin.rl_tower_1, "{{!}}", skin.rl_tower_1_upgrades, "}}"), "—") = Insta Monkey 1 | ||
COALESCE(CONCAT("{{ | |extra col 2=COALESCE(CONCAT("{{", "BTD6 insta{{!}}", skin.rl_tower_2, "{{!}}", skin.rl_tower_2_upgrades, "}}"), "—") = Insta Monkey 2 | ||
|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), | |||
"{{!}}", | |||
(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), | |||
"}})"), "")) = Artifact | |||
| | |order by=IF(skin.hero = skin.name, 0, 1), skin.numeric_id | ||
}} | |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|}}}") | ||
|default=There are no starter parties that include this tower directly. | |||
|join on=skin.rl_artifact=artifact.name | |||
}}</includeonly><noinclude>{{/doc}}</noinclude> | |||