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

From Blooncyclopedia, the independent Bloons knowledge base
Jump to navigation Jump to search
← Older editNewer edit →
Polavux (talk | contribs)
Bureaucrats, Interface administrators, Administrators
63,192 edits
VisualWikitext
mNo edit summary
using the new template
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>{{generic cargo compact list|tables=btd6_cosmetic_items=items, btd6_cosmetic_sources=sources
|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,
|pagename field=CONCAT(items._pageName, "#", items.name)
IF(GROUP_CONCAT(sources.name) LIKE "%Trophy Store%", "{{Y}}", "{{N}}") = Trophy Store?
|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}}
|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? DESC, items.category, items.subcategory, items.name
}}</div></includeonly><noinclude>{{/doc}}</noinclude>
}}</noinclude></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.

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}}
Error 1052: Column '_pageName' in field list is ambiguous

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%", "Yes", "No") 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

</noinclude>

Retrieved from "https://www.bloonswiki.com/index.php?title=Template:BTD6_cosmetic_item_list_by_introduced&oldid=112991"