Template:BCS rewards: Difference between revisions

From Blooncyclopedia, the independent Bloons knowledge base
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
<includeonly><ul>{{#if:{{{card 1|}}}|{{#cargo_query:tables=bcs_cards
<includeonly><ul>{{#if:{{{card 1|}}}|{{#cargo_query:tables=bcs_cards
|fields=CONCAT("<li>[[File:", image, "|30px|link=", _pageName, "|Icon of ", name, "]] ", name, " ×", CASE
|fields=CONCAT("<li>[[File:", image, "|30px|link=", _pageName, "|Icon of ", name, "]] ", name, " ×", CASE
WHEN name = "{{{card 1}}}" THEN "{{{card 1 amount|1}}}" WHEN name = "{{{card 2}}}" THEN "{{{card 2 amount|1}}}" WHEN name = "{{{card 3}}}" THEN "{{{card 3 amount|1}}}" WHEN name = "{{{card 4}}}" THEN "{{{card 4 amount|1}}}" WHEN name = "{{{card 5}}}" THEN "{{{card 5 amount|1}}}" WHEN name = "{{{card 6}}}" THEN "{{{card 6 amount|1}}}" WHEN name = "{{{card 7}}}" THEN "{{{card 7 amount|1}}}" WHEN name = "{{{card 8}}}" THEN "{{{card 8 amount|1}}}" WHEN name = "{{{card 9}}}" THEN "{{{card 9 amount|1}}}" WHEN name = "{{{card 10}}}" THEN "{{{card 10 amount|1}}}" WHEN name = "{{{card 11}}}" THEN "{{{card 11 amount|1}}}" WHEN name = "{{{card 12}}}" THEN "{{{card 12 amount|1}}}" WHEN name = "{{{card 13}}}" THEN "{{{card 13 amount|1}}}" WHEN name = "{{{card 14}}}" THEN "{{{card 14 amount|1}}}" WHEN name = "{{{card 15}}}" THEN "{{{card 15 amount|1}}}" WHEN name = "{{{card 16}}}" THEN "{{{card 16 amount|1}}}" WHEN name = "{{{card 17}}}" THEN "{{{card 17 amount|1}}}" WHEN name = "{{{card 18}}}" THEN "{{{card 18 amount|1}}}" WHEN name = "{{{card 19}}}" THEN "{{{card 19 amount|1}}}" WHEN name = "{{{card 20}}}" THEN "{{{card 20 amount|1}}}" ELSE "1" END, "</li>") = text
WHEN id = "{{{card 1}}}" THEN "{{{card 1 amount|1}}}" WHEN id = "{{{card 2}}}" THEN "{{{card 2 amount|1}}}" WHEN id = "{{{card 3}}}" THEN "{{{card 3 amount|1}}}" WHEN id = "{{{card 4}}}" THEN "{{{card 4 amount|1}}}" WHEN id = "{{{card 5}}}" THEN "{{{card 5 amount|1}}}" WHEN id = "{{{card 6}}}" THEN "{{{card 6 amount|1}}}" WHEN id = "{{{card 7}}}" THEN "{{{card 7 amount|1}}}" WHEN id = "{{{card 8}}}" THEN "{{{card 8 amount|1}}}" WHEN id = "{{{card 9}}}" THEN "{{{card 9 amount|1}}}" WHEN id = "{{{card 10}}}" THEN "{{{card 10 amount|1}}}" WHEN id = "{{{card 11}}}" THEN "{{{card 11 amount|1}}}" WHEN id = "{{{card 12}}}" THEN "{{{card 12 amount|1}}}" WHEN id = "{{{card 13}}}" THEN "{{{card 13 amount|1}}}" WHEN id = "{{{card 14}}}" THEN "{{{card 14 amount|1}}}" WHEN id = "{{{card 15}}}" THEN "{{{card 15 amount|1}}}" WHEN id = "{{{card 16}}}" THEN "{{{card 16 amount|1}}}" WHEN id = "{{{card 17}}}" THEN "{{{card 17 amount|1}}}" WHEN id = "{{{card 18}}}" THEN "{{{card 18 amount|1}}}" WHEN id = "{{{card 19}}}" THEN "{{{card 19 amount|1}}}" WHEN id = "{{{card 20}}}" THEN "{{{card 20 amount|1}}}" ELSE "1" END, "</li>") = text
|where=name = "{{{card 1|}}}" OR name = "{{{card 2|}}}" OR name = "{{{card 3|}}}" OR name = "{{{card 4|}}}" OR name = "{{{card 5|}}}" OR name = "{{{card 6|}}}" OR name = "{{{card 7|}}}" OR name = "{{{card 8|}}}" OR name = "{{{card 9|}}}" OR name = "{{{card 10|}}}" OR name = "{{{card 11|}}}" OR name = "{{{card 12|}}}" OR name = "{{{card 13|}}}" OR name = "{{{card 14|}}}" OR name = "{{{card 15|}}}" OR name = "{{{card 16|}}}" OR name = "{{{card 17|}}}" OR name = "{{{card 18|}}}" OR name = "{{{card 19|}}}" OR name = "{{{card 20|}}}"
|where=id = "{{{card 1|}}}" OR id = "{{{card 2|}}}" OR id = "{{{card 3|}}}" OR id = "{{{card 4|}}}" OR id = "{{{card 5|}}}" OR id = "{{{card 6|}}}" OR id = "{{{card 7|}}}" OR id = "{{{card 8|}}}" OR id = "{{{card 9|}}}" OR id = "{{{card 10|}}}" OR id = "{{{card 11|}}}" OR id = "{{{card 12|}}}" OR id = "{{{card 13|}}}" OR id = "{{{card 14|}}}" OR id = "{{{card 15|}}}" OR id = "{{{card 16|}}}" OR id = "{{{card 17|}}}" OR id = "{{{card 18|}}}" OR id = "{{{card 19|}}}" OR id = "{{{card 20|}}}"
|order by=name
|order by=name
|format=list
|format=list
Line 28: Line 28:
|fields=CONCAT("<li>[[File:", image, "|30px|link=", _pageName, "|Icon of ", name, "]] ", name, "</li>") = text
|fields=CONCAT("<li>[[File:", image, "|30px|link=", _pageName, "|Icon of ", name, "]] ", name, "</li>") = text


|where=name = "{{{cosmetic 1|}}}" OR name = "{{{cosmetic 2|}}}" OR name = "{{{cosmetic 3|}}}" OR name = "{{{cosmetic 4|}}}" OR name = "{{{cosmetic 5|}}}" OR name = "{{{cosmetic 6|}}}" OR name = "{{{cosmetic 7|}}}" OR name = "{{{cosmetic 8|}}}" OR name = "{{{cosmetic 9|}}}" OR name = "{{{cosmetic 10|}}}" OR name = "{{{cosmetic 11|}}}" OR name = "{{{cosmetic 12|}}}" OR name = "{{{cosmetic 13|}}}" OR name = "{{{cosmetic 14|}}}" OR name = "{{{cosmetic 15|}}}" OR name = "{{{cosmetic 16|}}}" OR name = "{{{cosmetic 17|}}}" OR name = "{{{cosmetic 18|}}}" OR name = "{{{cosmetic 19|}}}" OR name = "{{{cosmetic 20|}}}"
|where=id = "{{{cosmetic 1|}}}" OR id = "{{{cosmetic 2|}}}" OR id = "{{{cosmetic 3|}}}" OR id = "{{{cosmetic 4|}}}" OR id = "{{{cosmetic 5|}}}" OR id = "{{{cosmetic 6|}}}" OR id = "{{{cosmetic 7|}}}" OR id = "{{{cosmetic 8|}}}" OR id = "{{{cosmetic 9|}}}" OR id = "{{{cosmetic 10|}}}" OR id = "{{{cosmetic 11|}}}" OR id = "{{{cosmetic 12|}}}" OR id = "{{{cosmetic 13|}}}" OR id = "{{{cosmetic 14|}}}" OR id = "{{{cosmetic 15|}}}" OR id = "{{{cosmetic 16|}}}" OR id = "{{{cosmetic 17|}}}" OR id = "{{{cosmetic 18|}}}" OR id = "{{{cosmetic 19|}}}" OR id = "{{{cosmetic 20|}}}"
|order by=category, name
|order by=category, name
|format=list
|format=list

Revision as of 10:12, 24 July 2025

This template defines the Cargo table "bcs_rewards". View table.Template:BCS rewards/doc