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

From Blooncyclopedia, the independent Bloons knowledge base
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
<includeonly>{{generic cargo compact list|tables=btd6_cosmetic_items=items, btd6_cosmetic_sources=sources
<includeonly>{{#if:{{{hide trophy store|}}}|{{generic cargo compact list|tables=btd6_cosmetic_items=items
|image field=items.image
|image field=items.image
|link field=CONCAT(items._pageName, "#", items.name)
|link field=CONCAT(items._pageName, "#", items.name)
Line 5: Line 5:


|extra col 1=CONCAT(items.category, " ― [[", items._pageName, "|", items.subcategory, "]]") = Category
|extra col 1=CONCAT(items.category, " ― [[", items._pageName, "|", items.subcategory, "]]") = Category
{{#if:{{{show trophy store|}}}|{{!}}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}}
|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
|center extra cols=y


Line 11: Line 21:
|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
|order by={{#if:{{{show trophy store|}}}|Trophy Store? DESC,}} items.category, items.subcategory, items.name
|order by=Trophy Store? DESC, items.category, items.subcategory, items.name
}}</includeonly><noinclude>{{/doc}}</noinclude>
}}}}</includeonly><noinclude>{{/doc}}</noinclude>

Latest revision as of 08:06, 8 April 2026

Generates a table of cosmetic items in Bloons TD 6 according to the version they were introduced in using a Cargo query.

Template parameters[Edit template data]

This template prefers inline formatting of parameters.

ParameterDescriptionTypeStatus
Version1

The version to list items from. Must be a number and cannot include the "v".

Example
40.0
Numberrequired
XD only?xd only

If enabled, shows items exclusive to the Chinese version. If not, Chinese version-exclusive items are excluded.

Booleanoptional

Example usage

{{BTD6 cosmetic item list by introduced|45.0}}