Template:BTD6 cosmetic item list by introduced: Difference between revisions
using the new template |
mNo edit summary |
||
| Line 12: | Line 12: | ||
|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=Trophy Store? DESC, items.category, items.subcategory, items.name | |order by=Trophy Store? DESC, items.category, items.subcategory, items.name | ||
}} | }}</includeonly><noinclude>{{/doc}}</noinclude> | ||
Revision as of 05:50, 27 February 2026
Generates a table of cosmetic items in Bloons TD 6 according to the version they were introduced in using a Cargo query.
| Parameter | Description | Type | Status | |
|---|---|---|---|---|
| Version | 1 | The version to list items from. Must be a number and cannot include the "v".
| Number | required |
| XD only? | xd only | If enabled, shows items exclusive to the Chinese version. If not, Chinese version-exclusive items are excluded. | Boolean | optional |
Example usage
{{BTD6 cosmetic item list by introduced|45.0}}
Function: CargoSQLQuery::run
Query: SELECT CONCAT("<div class='flex-left-icon-wrapper'>Image of", `items`.`name`, "<div>",
"", `items`.`name`, "", "</div></div>") AS `Item`,CONCAT(`items`.`category`, " ― ", `items`.`subcategory`, "") AS `Category`,IF(GROUP_CONCAT(`sources`.`name`) LIKE "%Trophy Store%", "
", "
") AS `Trophy Store?` FROM `cargo__btd6_cosmetic_items` `items` LEFT OUTER JOIN `cargo__btd6_cosmetic_sources` `sources` ON ((`items`.`id`=`sources`.`item`)) WHERE `items`.`introduced` = "45.0" AND NOT xd_only GROUP BY `items`.`_pageName`, `items`.`name`, `items`.`image`, `items`.`category`, `items`.`subcategory`, `items`.`introduced` ORDER BY `Trophy Store?` DESC,`items`.`category`,`items`.`subcategory`,`items`.`name` LIMIT 100