List of maps in BTD6: Difference between revisions
Created page with "This is a list of all maps in ''Bloons TD 6''. ==List== <div style="text-align:center">{{#cargo_query:table=btd6_maps, btd6_maps__path_lengths, btd6_maps__removable_costs |fields=CONCAT("x100px|link=", _pageName, "<br>", name, "") = Map, difficulty = Difficulty, entrances = Entrances, exits = Exits, junctions = Junctions, water = Water?, FORMAT(AVG(btd6_maps__path_lengths._value), 1) = Average RBS, COALESCE(CONCAT("$", FORMAT..." |
m fixed the average rbs? i think? |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
This is a list of all maps in ''[[Bloons TD 6]]''. | This is a list of all maps in ''[[Bloons TD 6]]''. Average [[RBS]] is based on [[Hard]] difficulty. | ||
==List== | ==List== | ||
<div style="text-align:center">{{#cargo_query: | <div style="text-align:center">{{#cargo_query:tables=btd6_maps=maps, btd6_maps__removable_costs = costs, btd6_maps__path_lengths = lengths | ||
|fields=CONCAT("[[File:", image, "| | |fields=CONCAT("[[File:", image, "|120px|link=", _pageName, "]]<br>[[", _pageName, "|", name, "]]") = Map, | ||
difficulty = Difficulty, | difficulty = Difficulty, | ||
entrances = Entrances, | entrances = Entrances, | ||
| Line 9: | Line 9: | ||
junctions = Junctions, | junctions = Junctions, | ||
water = Water?, | water = Water?, | ||
FORMAT(AVG( | FORMAT(AVG(lengths._value), 1) = Average RBS, | ||
CONCAT(music) = Default music, | CONCAT(music) = Default music, | ||
COALESCE(CONCAT("[[Bloons TD 6 | COALESCE(CONCAT("[[Update history:Bloons TD 6/Version ", introduced, "|Version ", introduced, "]]"), "Launch") = Introduced | ||
|join on= | |join on=maps._ID = costs._rowID, maps._ID = lengths._rowID | ||
|group by=image, _pageName, name, difficulty, entrances, exits, junctions, water, music, introduced | |group by=image, _pageName, name, difficulty, entrances, exits, junctions, water, music, introduced | ||
|order by=(CASE difficulty WHEN 'Beginner' THEN 0 WHEN 'Intermediate' THEN 1 WHEN 'Advanced' THEN 2 WHEN 'Expert' THEN 3 END), | |order by=(CASE difficulty WHEN 'Beginner' THEN 0 WHEN 'Intermediate' THEN 1 WHEN 'Advanced' THEN 2 WHEN 'Expert' THEN 3 END), | ||
name | name | ||
| Line 25: | Line 23: | ||
{{BTD6 map nav}} | {{BTD6 map nav}} | ||
{{BTD6 nav}} | {{BTD6 nav}} | ||
[[Category:Maps in BTD6|*]][[Category:Lists| | [[Category:Maps in BTD6|*]][[Category:Lists|Maps in BTD6]] | ||