List of tracks in BTD5: Difference between revisions

m Bloons TD 5 (mobile): fixed incorrect path lengths
these aren't RBS values I just realized
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
This is a list of all maps across the ''[[Bloons TD 5]]'' games.
This is a list of all tracks across the ''[[Bloons TD 5]]'' games.


==[[Bloons TD 5 (mobile)]]==
==[[Bloons TD 5 (mobile)]]==
{{Cleanup|figure out a more elegant solution to cargo only listing 100 results}}
<div style="text-align:center">{{#cargo_query:table=btd5_tracks
<div style="text-align:center">{{#cargo_query:table=btd5_tracks
|fields=CONCAT("[[File:", image_M, "|120px|link=", _pageName, "]]<br>[[", _pageName, "|", name_M, "]]") = Map,
|fields=CONCAT("[[File:", image_M, "|120px|link=", _pageName, "]]<br>[[", _pageName, "|", name_M, "]]") = Map,
Line 10: Line 9:
junctions = Junctions,
junctions = Junctions,
water = Water?,
water = Water?,
FORMAT(AVG(btd5_tracks.path_lengths_M__full), 1) = Average RBS,
FORMAT(AVG(btd5_tracks.path_lengths_M__full), 1) = Average path length,
CONCAT(music_M) = Default music,
CONCAT(music_M) = Default music,


Line 17: Line 16:
|order by=(CASE difficulty_M WHEN 'Beginner' THEN 0 WHEN 'Intermediate' THEN 1 WHEN 'Advanced' THEN 2 WHEN 'Expert' THEN 3 WHEN 'Extreme' THEN 4 END),
|order by=(CASE difficulty_M WHEN 'Beginner' THEN 0 WHEN 'Intermediate' THEN 1 WHEN 'Advanced' THEN 2 WHEN 'Expert' THEN 3 WHEN 'Extreme' THEN 4 END),
name_M
name_M
|where=id_M IS NOT NULL AND difficulty_M='Beginner' OR difficulty_M='Intermediate'
|where=id_M IS NOT NULL AND difficulty_M IS NOT NULL
}}</div>
|limit=200
<div style="text-align:center">{{#cargo_query:table=btd5_tracks
|fields=CONCAT("[[File:", image_M, "|120px|link=", _pageName, "]]<br>[[", _pageName, "|", name_M, "]]") = Map,
difficulty_M = Difficulty,
entrances = Entrances,
exits = Exits,
junctions = Junctions,
water = Water?,
FORMAT(AVG(btd5_tracks.path_lengths_M__full), 1) = Average RBS,
CONCAT(music_M) = Default music,
 
|group by=image_M, _pageName, name_M, difficulty_M, entrances, exits, junctions, water, music_M
 
|order by=(CASE difficulty_M WHEN 'Beginner' THEN 0 WHEN 'Intermediate' THEN 1 WHEN 'Advanced' THEN 2 WHEN 'Expert' THEN 3 WHEN 'Extreme' THEN 4 END),
name_M
|where=id_M IS NOT NULL AND difficulty_M!='Beginner' AND difficulty_M!='Intermediate'
}}</div>
}}</div>


Line 44: Line 28:
junctions = Junctions,
junctions = Junctions,
water = Water?,
water = Water?,
FORMAT(AVG(btd5_tracks.path_lengths_F__full), 1) = Average RBS,
FORMAT(AVG(btd5_tracks.path_lengths_F__full), 1) = Average path length,
CONCAT(music_F) = Default music,
CONCAT(music_F) = Default music,


Line 62: Line 46:
junctions = Junctions,
junctions = Junctions,
water = Water?,
water = Water?,
FORMAT(AVG(btd5_tracks.path_lengths_F__full), 1) = Average RBS,
FORMAT(AVG(btd5_tracks.path_lengths_F__full), 1) = Average path length,
CONCAT(music_F) = Default music,
CONCAT(music_F) = Default music,