User:Planterror/Project Water Placement: Difference between revisions

<div style="text-align:center">{{#cargo_query:table=btd5_tracks

|fields=CONCAT("[[File:", image_F, "|x100px|link=", _pageName, "]]<br>[[", _pageName, "|", name_F, "]]") = Map,

difficulty_F=Difficulty,

introduced_F=Introduced (Flash),

introduced_D=Introduced (Deluxe)

|where=name_f != "" AND water=TRUE

|group by=image_f, _pageName, name_F, difficulty_F, water, introduced_f, introduced_d

|order by=(CASE difficulty_F WHEN 'Beginner' THEN 0 WHEN 'Intermediate' THEN 1 WHEN 'Advanced' THEN 2 WHEN 'Expert' THEN 3 WHEN 'Extreme' THEN 4 END),

}}</div>

===Bloons TD 5 Mobile/Steam===

<div style="text-align:center">{{#cargo_query:table=btd5_tracks

|fields=CONCAT("[[File:", image_M, "|x100px|link=", _pageName, "]]<br>[[", _pageName, "|", name_M, "]]") = Map,

difficulty_M=Difficulty,

introduced_M=Introduced

 

<div style="text-align:center">{{#cargo_query:table=bmc_tracks

|fields=CONCAT("[[File:", image_M, "|x100px|link=", _pageName, "]]<br>[[", _pageName, "|", name, "]]") = Map,

difficulty=Difficulty

 

|where=image_M != "" AND water=TRUE

|group by=image_M, _pageName, name, difficulty, water

}}</div>

The water towers are Buccaneers, Subs, and Mermonkeys. For Mermonkeys in specific, find all placements that are considered on water (a good way to test is if they have the Carrier Flagship buff, or have the increased range). All platforms are identical, so no need to worry about that. List of maps with water are below:

<div style="text-align:center">{{#cargo_query:table=btd6_maps

|fields=CONCAT("[[File:", image, "|x100px|link=", _pageName, "]]<br>[[", _pageName, "|", name, "]]") = Map,

difficulty = Difficulty,

introduced=Introduced

|where=water=TRUE

|group by=image, _pageName, name, difficulty, water, introduced

|order by=(CASE difficulty WHEN 'Beginner' THEN 0 WHEN 'Intermediate' THEN 1 WHEN 'Advanced' THEN 2 WHEN 'Expert' THEN 3 END),

}}</div>