Template:BTD6 hero list by insta: Difference between revisions
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 |
||
| Line 1: | Line 1: | ||
<includeonly>{{generic cargo compact list|table=btd6_hero_skins | <includeonly>{{generic cargo compact list|table=btd6_hero_skins=skin, btd6_artifacts=artifact | ||
|image field=icon | |col 1 name=Hero | ||
|extra col 1=COALESCE(CONCAT("{{", "BTD6 insta{{!}}", rl_tower_1, "{{!}}", rl_tower_1_upgrades, "}}"), "—") = Insta Monkey 1 | |name field=skin.name|image field=skin.icon|link field=skin._pageName | ||
|extra col 2=COALESCE(CONCAT("{{", "BTD6 insta{{!}}", rl_tower_2, "{{!}}", rl_tower_2_upgrades, "}}"), "—") = Insta Monkey 2 | |extra col 1=COALESCE(CONCAT("{{", "BTD6 insta{{!}}", skin.rl_tower_1, "{{!}}", skin.rl_tower_1_upgrades, "}}"), "—") = Insta Monkey 1 | ||
|extra col 3=CONCAT("{{", "BTD6 artifact{{!}}", rl_artifact, "}} ", rl_artifact_rarity) = Artifact | |extra col 2=COALESCE(CONCAT("{{", "BTD6 insta{{!}}", skin.rl_tower_2, "{{!}}", skin.rl_tower_2_upgrades, "}}"), "—") = Insta Monkey 2 | ||
|order by=IF(hero = name, 0, 1), numeric_id | |extra col 3=CONCAT("{{", "BTD6 artifact{{!}}", skin.rl_artifact, "}} ", skin.rl_artifact_rarity, COALESCE(CONCAT(" (adds {{", "BTD6 insta{{!}}", | ||
|where=NOT xd_only AND (rl_tower_1="{{{1|}}}" OR rl_tower_2="{{{1|}}}") | (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. | |default=There are no starter parties that include this tower directly. | ||
|join on=skin.rl_artifact=artifact.name | |join on=skin.rl_artifact=artifact.name | ||
}}</includeonly><noinclude>{{/doc}}</noinclude> | }}</includeonly><noinclude>{{/doc}}</noinclude> | ||