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:table=btd6_maps, btd6_maps__path_lengths, btd6_maps__removable_costs
<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, "|x100px|link=", _pageName, "]]<br>[[", _pageName, "|", name, "]]") = Map,
|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(btd6_maps__path_lengths._value), 1) = Average RBS,
FORMAT(AVG(lengths._value), 1) = Average RBS,
COALESCE(CONCAT("$", FORMAT(SUM(btd6_maps__removable_costs._value), 0)), "N/A") = Total cost of removables,
CONCAT(music) = Default music,
CONCAT(music) = Default music,
COALESCE(CONCAT("[[Bloons TD 6 v", introduced, "|Version ", introduced, "]]"), "Launch") = Introduced
COALESCE(CONCAT("[[Update history:Bloons TD 6/Version ", introduced, "|Version ", introduced, "]]"), "Launch") = Introduced


|join on=btd6_maps._ID = btd6_maps__path_lengths._rowID, btd6_maps._ID = btd6_maps__removable_costs._rowID
|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]]