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
 
(2 intermediate revisions by the same user not shown)
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("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", 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("{{#", "invoke", ":BTD6 rewards|main|InstaMonkey:", 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.
}} {{#cargo_query:table=btd6_hero_skins=skin, btd6_artifacts=artifact
|fields=CONCAT("[[", skin._pageName, "|", skin.name, "]] ([[", artifact._pageName, "|", artifact.name, "]] ", skin.rl_artifact_rarity, ")")
|where=artifact.insta_type_common="{{{1|}}}" OR artifact.insta_type_rare="{{{1|}}}" OR artifact.insta_type_legendary="{{{1|}}}"
|join on=skin.rl_artifact=artifact.name
|join on=skin.rl_artifact=artifact.name
|format=ul
|order by=IF(skin.hero = skin.name, 0, 1), skin.numeric_id
|intro=The following starter parties implicitly include this tower because their starting Artifact adds this tower to the party:
|default=
}}</includeonly><noinclude>{{/doc}}</noinclude>
}}</includeonly><noinclude>{{/doc}}</noinclude>