Blooncyclopedia

Template:BCS cosmetic item list by hero: Difference between revisions

Pymonkibot (talk | contribs)
Bots
28,530 edits
VisualWikitext
Created page with "<includeonly><div class="center-col-2 center-col-4 responsive-block-col-1">{{#cargo_query:tables=bcs_cosmetic_items=items, bcs_rewards=rewards |fields=CONCAT("30px|link=", items._pageName, "|Icon of ", items.name, " ", items.name) = Item, CONCAT("", items.category, "") = Category, GROUP_CONCAT(rewards.name SEPARATOR ", ") = Unlock method(s), CONCAT(CASE WHEN items.introduced IS NULL THEN "Launch" ELSE CONCAT("Bloons..."
 
Pymonkibot (talk | contribs)
Bots
28,530 edits
m Text replacement - "pagename field" to "link field"
 
(6 intermediate revisions by one other user not shown)
Line 1: Line 1:
<includeonly><div class="center-col-2 center-col-4 responsive-block-col-1">{{#cargo_query:tables=bcs_cosmetic_items=items, bcs_rewards=rewards
<includeonly>{{generic cargo compact list
|fields=CONCAT("[[File:", items.image, "|30px|link=", items._pageName, "|Icon of ", items.name, "]] ", items.name) = Item,
|tables=bcs_cosmetic_items=items, bcs_rewards=rewards
CONCAT("[[", items._pageName, "|", items.category, "]]") = Category,
|image field=items.image|name field=items.name|link field=items._pageName
GROUP_CONCAT(rewards.name SEPARATOR ", ") = Unlock method(s),
CONCAT(CASE WHEN items.introduced IS NULL THEN "Launch" ELSE CONCAT("[[Bloons Card Storm v", items.introduced, "|Version ", items.introduced, "]]") END) = Introduced


|where  =card = "{{{1|}}}"
|extra col 1=CONCAT("[[", items._pageName, "|", items.category, "]]") = Category
|extra col 2=GROUP_CONCAT(rewards.name SEPARATOR ", ") = Unlock method(s)
|col 1 name=Item
|introduced col game name=Bloons Card Storm
|no link=y
|where  =items.applies_to HOLDS "{{{1|}}}"
|join on =items.id = rewards.item
|join on =items.id = rewards.item
|group by=items._pageName, items.name, items.image, items.introduced, rewards.item
|group by=items._pageName, items.name, items.image, items.category, items.introduced, rewards.item
|order by=items.category
|order by=items.category
}}</div>{{#cargo_store:_table=bcs_rewards
|center extra cols=y
|name=Level 10 {{{hero|}}}
}}{{#ifeq:{{NAMESPACENUMBER}}|0|{{#cargo_store:_table=bcs_rewards
|item={{{level 10|}}}
|item  ={{{level 10|}}}
|name  =[[{{{1|}}} (BCS)|{{{1|}}}]] level 10
|amount=1
}}{{#cargo_store:_table=bcs_rewards
}}{{#cargo_store:_table=bcs_rewards
|name=Level 10 {{{hero|}}}
|item  ={{{level 15|}}}
|item={{{level 15|}}}
|name  =[[{{{1|}}} (BCS)|{{{1|}}}]] level 15
}}</includeonly><noinclude>{{#cargo_attach:_table=bcs_rewards}}{{/doc}}</noinclude>
|amount=1
}}}}</includeonly><noinclude>{{#cargo_attach:_table=bcs_rewards}}{{/doc}}</noinclude>
Retrieved from "https://www.bloonswiki.com/Template:BCS_cosmetic_item_list_by_hero"