List of maps in BTD6: Difference between revisions
mNo edit summary |
m fixed the average rbs? i think? |
||
| Line 2: | Line 2: | ||
==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, "|120px|link=", _pageName, "]]<br>[[", _pageName, "|", name, "]]") = Map, | |fields=CONCAT("[[File:", image, "|120px|link=", _pageName, "]]<br>[[", _pageName, "|", name, "]]") = Map, | ||
difficulty = Difficulty, | difficulty = Difficulty, | ||
| 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 | ||