Template:BTD6 hero list by insta: Difference between revisions

mNo edit summary
mNo edit summary
 
Line 1: Line 1:
<includeonly>{{#cargo_compound_query:
<includeonly>{{generic cargo compact list|table=btd6_hero_skins
tables=btd6_heroes
|image field=icon
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|", name, "]] [[", _pageName, "|", name, "]]") = Hero,
|extra col 1=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_1, ",", rl_tower_1_upgrades, "}}"), "—") = Insta Monkey 1,
|extra col 2=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
|extra col 3=CONCAT("{{", "BTD6 artifact{{!}}", rl_artifact, "}} ", rl_artifact_rarity) = Artifact
;where=rl_tower_1="{{{1|}}}" OR rl_tower_2="{{{1|}}}"
|order by=IF(hero = name, 0, 1), numeric_id
;order by=category_order
|where=NOT xd_only AND (rl_tower_1="{{{1|}}}" OR rl_tower_2="{{{1|}}}")
 
|tables=btd6_hero_skins
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|", name, "]] [[", _pageName, "|", 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, "}}"), "—") = Insta Monkey 2
;where=rl_tower_1="{{{1|}}}" OR rl_tower_2="{{{1|}}}"
;order by=category_order
|format=table
}}</includeonly><noinclude>{{/doc}}</noinclude>
}}</includeonly><noinclude>{{/doc}}</noinclude>