User:Planterror/Sandbox/Cargo Wizardry: Difference between revisions

pee pee poo poo
 
why are there commas
Line 35: Line 35:
|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
}}
|}
== the tier 3s ==
{|class="wikitable mw-collapsible center-col-2 center-col-1 center-col-3 center-col-4"
|+Tier 3 upgrades in Bloons Monkey City
!Tower
!colspan="2"|Upgrade
!colspan="2"|Description
{{#cargo_query:table=bmc_upgrades
|fields=
CONCAT("<tr><td>[[", tower, " (BMC){{!}}",tower,"]]</td><td>",
"[[File:", icon_M, "{{!}}x50px{{!}}link=", _pageName, "]]<br>[[", _pageName, "{{!}}", name_M, "]]</td><td>",
IF(icon_F IS NOT NULL, CONCAT("[[File:", icon_F, "{{!}}x50px{{!}}link=", _pageName, "]]</td><td>"), "</td><td>"),
description_M, "</td><td>", IF(description_F IS NOT NULL, description_F, ""), "</tr></td>")=text
|where=tier = 3
}}
}}
|}
|}