Blooncyclopedia

Template:BTD6 cosmetic item list by introduced: Difference between revisions

← Older edit
Polavux (talk | contribs)
Bureaucrats, Interface administrators, Administrators
58,403 edits
VisualWikitext
column noting if an item is in the trophy store or not
mNo edit summary
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<includeonly><div class="center-col-2 center-col-3">{{#cargo_query:table=btd6_cosmetic_items=items, btd6_cosmetic_sources=sources
<includeonly>{{#if:{{{hide trophy store|}}}|{{generic cargo compact list|tables=btd6_cosmetic_items=items
|fields=CONCAT("[[File:", items.image, "|30px|link=", items._pageName, "|Icon of", items.name, "]] ", items.name) = Name,
|image field=items.image
CONCAT(items.category, " ― [[", items._pageName, "|", items.subcategory, "]]") = Category,
|link field=CONCAT(items._pageName, "#", items.name)
IF(GROUP_CONCAT(sources.name) LIKE "%Trophy Store%", "{{Y}}", "{{N}}") = Trophy Store?
|name field=items.name
|where=items.introduced = "{{{1|}}}"


|extra col 1=CONCAT(items.category, " ― [[", items._pageName, "|", items.subcategory, "]]") = Category
|center extra cols=y
|where=items.introduced = "{{{1|}}}" {{#if:{{{xd only|}}}|AND xd_only|AND NOT xd_only}}
|order by=items.category, items.subcategory, items.name
}}|{{generic cargo compact list|tables=btd6_cosmetic_items=items, btd6_cosmetic_sources=sources
|image field=items.image
|link field=CONCAT(items._pageName, "#", items.name)
|name field=items.name
|extra col 1=CONCAT(items.category, " ― [[", items._pageName, "|", items.subcategory, "]]") = Category
|extra col 2=IF(GROUP_CONCAT(sources.name) LIKE "%Trophy Store%", "{{Y}}", "{{N}}") = Trophy Store?
|center extra cols=y
|where=items.introduced = "{{{1|}}}" {{#if:{{{xd only|}}}|AND xd_only|AND NOT xd_only}}
|join on =items.id = sources.item
|join on =items.id = sources.item
|group by=items._pageName, items.name, items.image, items.category, items.subcategory, items.introduced
|group by=items._pageName, items.name, items.image, items.category, items.subcategory, items.introduced
|format=table
|order by=Trophy Store? DESC, items.category, items.subcategory, items.name
|order by=Trophy Store?, items.category, items.subcategory, items.name
}}}}</includeonly><noinclude>{{/doc}}</noinclude>
}}</div></includeonly><noinclude>{{/doc}}</noinclude>
Retrieved from "https://www.bloonswiki.com/Template:BTD6_cosmetic_item_list_by_introduced"