Template:BTD6 cosmetic item list by id: Difference between revisions
mNo edit summary |
Pymonkibot (talk | contribs) m Text replacement - "[[Bloons TD 6 v" to "[[Update history:Bloons TD 6/Version " |
||
| (5 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
<includeonly><div class="center-col- | <includeonly><div class="center-col-2 responsive-block-col-1">{{#cargo_query:tables=btd6_cosmetic_items=items, btd6_cosmetic_sources=sources | ||
|fields= | |fields= | ||
CONCAT("[[File:", | CONCAT("[[File:", items.image, "|30px|link=", items._pageName, "#", items.name, "|Icon of ", items.name, "]] ", items.name) = Item, | ||
CONCAT(items.category, " — ", "[[", items._pageName, "|", items.subcategory, "]]") = Category, | |||
CONCAT( | {{#if:{{{hide sources|}}}||COALESCE(GROUP_CONCAT(sources.name ORDER BY CASE | ||
COALESCE(GROUP_CONCAT( | WHEN sources.name LIKE '[[Trophy Store]]%' THEN 0 ELSE 1 END <!-- sources beginning with "Trophy Store" are listed first --> | ||
WHEN | SEPARATOR ', '), "TBD") = Unlock method(s),}} | ||
SEPARATOR ', '), "TBD") = | IF(items.introduced = "", "''To be added''", CONCAT("[[Update history:Bloons TD 6/Version ", items.introduced, "|Version ", items.introduced, "]]", IF(items.xd_only, " ([[Bloons TD 6 (Chinese)|Chinese version]] only)", ""))) = Introduced | ||
IF( | |||
|where | |where=items.id = '{{{1|}}}' OR items.id = '{{{2|}}}' OR items.id = '{{{3|}}}' OR items.id = '{{{4|}}}' OR items.id = '{{{5|}}}' OR items.id = '{{{6|}}}' OR items.id = '{{{7|}}}' OR items.id = '{{{8|}}}' OR items.id = '{{{9|}}}' OR items.id = '{{{10|}}}' OR items.id = '{{{11|}}}' OR items.id = '{{{12|}}}' OR items.id = '{{{13|}}}' OR items.id = '{{{14|}}}' OR items.id = '{{{15|}}}' OR items.id = '{{{16|}}}' OR items.id = '{{{17|}}}' OR items.id = '{{{18|}}}' OR items.id = '{{{19|}}}' OR items.id = '{{{20|}}}' | ||
|join on = | |join on =items.id = sources.item | ||
|group by= | |group by=items._pageName, items.name, items.image, items.description, items.category, items.subcategory, items.introduced, items.xd_only | ||
|order by=introduced | |order by=introduced | ||
|format =table | |format =table | ||
}}</div></includeonly><noinclude>{{/doc}}</noinclude> | }}</div>{{#if:{{{source|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | ||
|name={{{source 1|{{{source|}}}}}} | |||
|item={{{1|}}} | |||
}}{{#if:{{{2|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 2|{{{source|}}}}}} | |||
|item={{{2|}}} | |||
}}}}{{#if:{{{3|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 3|{{{source|}}}}}} | |||
|item={{{3|}}} | |||
}}}}{{#if:{{{4|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 4|{{{source|}}}}}} | |||
|item={{{4|}}} | |||
}}}}{{#if:{{{5|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 5|{{{source|}}}}}} | |||
|item={{{5|}}} | |||
}}}}{{#if:{{{6|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 6|{{{source|}}}}}} | |||
|item={{{6|}}} | |||
}}}}{{#if:{{{7|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 7|{{{source|}}}}}} | |||
|item={{{7|}}} | |||
}}}}{{#if:{{{8|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 8|{{{source|}}}}}} | |||
|item={{{8|}}} | |||
}}}}{{#if:{{{9|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 9|{{{source|}}}}}} | |||
|item={{{9|}}} | |||
}}}}{{#if:{{{10|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 10|{{{source|}}}}}} | |||
|item={{{10|}}} | |||
}}}}{{#if:{{{11|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 11|{{{source|}}}}}} | |||
|item={{{11|}}} | |||
}}}}{{#if:{{{12|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 12|{{{source|}}}}}} | |||
|item={{{12|}}} | |||
}}}}{{#if:{{{13|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 13|{{{source|}}}}}} | |||
|item={{{13|}}} | |||
}}}}{{#if:{{{14|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 14|{{{source|}}}}}} | |||
|item={{{14|}}} | |||
}}}}{{#if:{{{15|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 15|{{{source|}}}}}} | |||
|item={{{15|}}} | |||
}}}}{{#if:{{{16|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 16|{{{source|}}}}}} | |||
|item={{{16|}}} | |||
}}}}{{#if:{{{17|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 17|{{{source|}}}}}} | |||
|item={{{17|}}} | |||
}}}}{{#if:{{{18|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 18|{{{source|}}}}}} | |||
|item={{{18|}}} | |||
}}}}{{#if:{{{19|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 19|{{{source|}}}}}} | |||
|item={{{19|}}} | |||
}}}}{{#if:{{{20|}}}|{{#cargo_store:_table=btd6_cosmetic_sources | |||
|name={{{source 20|{{{source|}}}}}} | |||
|item={{{20|}}} | |||
}}}}}}</includeonly><noinclude>{{/doc}}</noinclude> | |||
Latest revision as of 00:59, 24 April 2026
Creates a list of cosmetic items with the specified internal IDs.
| Parameter | Description | Type | Status | |
|---|---|---|---|---|
| Item 1 ID | 1 | The ID of the first cosmetic item. IDs can be found in the source of pages like [[Pet]] and [[Place FX]] for reference.
| String | required |
| Item 2 ID | 2 | The ID of the second cosmetic item. | String | optional |
| Item 3 ID | 3 | The ID of the third cosmetic item. | String | optional |
| 4 | 4 | no description | Unknown | optional |
| 5 | 5 | no description | Unknown | optional |
| 6 | 6 | no description | Unknown | optional |
| 7 | 7 | no description | Unknown | optional |
| 8 | 8 | no description | Unknown | optional |
| 9 | 9 | no description | Unknown | optional |
| 10 | 10 | no description | Unknown | optional |
| 11 | 11 | no description | Unknown | optional |
| 12 | 12 | no description | Unknown | optional |
| 13 | 13 | no description | Unknown | optional |
| 14 | 14 | no description | Unknown | optional |
| 15 | 15 | no description | Unknown | optional |
| 16 | 16 | no description | Unknown | optional |
| 17 | 17 | no description | Unknown | optional |
| 18 | 18 | no description | Unknown | optional |
| 19 | 19 | no description | Unknown | optional |
| 20 | 20 | no description | Unknown | optional |
| source | source | no description | Unknown | optional |
| source 1 | source 1 | no description | Unknown | optional |
| source 2 | source 2 | no description | Unknown | optional |
| source 3 | source 3 | no description | Unknown | optional |
| source 4 | source 4 | no description | Unknown | optional |
| source 5 | source 5 | no description | Unknown | optional |
| source 6 | source 6 | no description | Unknown | optional |
| source 7 | source 7 | no description | Unknown | optional |
| source 8 | source 8 | no description | Unknown | optional |
| source 9 | source 9 | no description | Unknown | optional |
| source 10 | source 10 | no description | Unknown | optional |
| source 11 | source 11 | no description | Unknown | optional |
| source 12 | source 12 | no description | Unknown | optional |
| source 13 | source 13 | no description | Unknown | optional |
| source 14 | source 14 | no description | Unknown | optional |
| source 15 | source 15 | no description | Unknown | optional |
| source 16 | source 16 | no description | Unknown | optional |
| source 17 | source 17 | no description | Unknown | optional |
| source 18 | source 18 | no description | Unknown | optional |
| source 19 | source 19 | no description | Unknown | optional |
| source 20 | source 20 | no description | Unknown | optional |
| Hide sources? | hide sources | If true, hides the "unlock method(s)" column. | Boolean | optional |
Example usage
{{BTD6 cosmetic item list by id|HeroesObynPetWolf|HeroesObynPetBunny|HeroesObynPlacementWolf}}
| Item | Category | Unlock method(s) | Introduced |
|---|---|---|---|
| Heroes — Pets | Trophy Store — |
Version 20.0 | |
| Heroes — Pets | Trophy Store — |
Version 24.0 | |
| Heroes — Place FX | Trophy Store — |
Version 43.0 |