Template:BTD6 cosmetic item list by id: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
| Line 6: | Line 6: | ||
WHEN sources.name LIKE 'Trophy Store%' THEN 0 ELSE 1 END <!-- sources beginning with "Trophy Store" are listed first --> | WHEN sources.name LIKE 'Trophy Store%' THEN 0 ELSE 1 END <!-- sources beginning with "Trophy Store" are listed first --> | ||
SEPARATOR ', '), "TBD") = Unlock method(s),}} | SEPARATOR ', '), "TBD") = Unlock method(s),}} | ||
IF(items.introduced = "", "''To be added''", CONCAT("[[Bloons TD 6 v", items.introduced, "|Version ", items.introduced, "]]")) = Introduced | IF(items.introduced = "", "''To be added''", CONCAT("[[Bloons TD 6 v", items.introduced, "|Version ", items.introduced, "]]", IF(items.xd_only, " ([[Bloons TD 6 (Chinese)|Chinese version]] only)", ""))) = Introduced | ||
|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|}}}' | |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 =items.id = sources.item | |join on =items.id = sources.item | ||
|group by=items._pageName, items.name, items.image, items.description, items.category, items.subcategory, items.introduced | |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 | ||
Revision as of 20:08, 25 July 2025
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 |
|---|---|---|---|
 Obyn Ghost Wolf Pet |
Heroes — Pets | Trophy Store —  100, Pets Fan Pack (IAP) |
Version 20.0 |
 Obyn Bunny Pet |
Heroes — Pets | Trophy Store — 75, Pets Fan Pack (IAP) |
Version 24.0 |
 Obyn Wolf Dance Place & Upgrade |
Heroes — Place FX | Trophy Store — 70 |
Version 43.0 |