Template:BTD6 hero list by insta: Difference between revisions

mNo edit summary
mNo edit summary
 
(One intermediate revision 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
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
 
|where=NOT xd_only AND (rl_tower_1="{{{1|}}}" OR rl_tower_2="{{{1|}}}")
|tables=btd6_hero_skins
}}</includeonly><noinclude>{{/doc}}</noinclude>
;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|}}}"
|format=table
}}</div></includeonly><noinclude>{{/doc}}</noinclude>