Template:BCS cosmetic item list by hero: Difference between revisions
mNo edit summary |
Pymonkibot (talk | contribs) m Text replacement - "pagename field" to "link field" |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
<includeonly | <includeonly>{{generic cargo compact list | ||
| | |tables=bcs_cosmetic_items=items, bcs_rewards=rewards | ||
|image field=items.image|name field=items.name|link field=items._pageName | |||
|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|}}}" | |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.category, 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 | ||
}} | |center extra cols=y | ||
}}{{#ifeq:{{NAMESPACENUMBER}}|0|{{#cargo_store:_table=bcs_rewards | |||
|item ={{{level 10|}}} | |item ={{{level 10|}}} | ||
|name = | |name =[[{{{1|}}} (BCS)|{{{1|}}}]] level 10 | ||
|amount=1 | |amount=1 | ||
}}{{#cargo_store:_table=bcs_rewards | }}{{#cargo_store:_table=bcs_rewards | ||
|item ={{{level 15|}}} | |item ={{{level 15|}}} | ||
|name = | |name =[[{{{1|}}} (BCS)|{{{1|}}}]] level 15 | ||
|amount=1 | |amount=1 | ||
}}</includeonly><noinclude>{{#cargo_attach:_table=bcs_rewards}}{{/doc}}</noinclude> | }}}}</includeonly><noinclude>{{#cargo_attach:_table=bcs_rewards}}{{/doc}}</noinclude> | ||