Blooncyclopedia

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

Polavux (talk | contribs)
Bureaucrats, Interface administrators, Administrators
58,352 edits
VisualWikitext
Created page with "<includeonly><div class="center-col-1 center-col-3 center-col-5">{{#cargo_query:tables=btdb2_cosmetic_items, btdb2_cosmetic_categories |where =introduced = "{{{1|}}}" |fields=CONCAT("20px|", btdb2_cosmetic_items.name, "") = Icon, CONCAT(btdb2_cosmetic_items.name) = Name, <!-- the concat is a hack to get around apostrophes being parsed weirdly --> CONCAT("File:", btdb2_cosmetic_categories.icon, "|x20px|", btdb2_cosmetic_categori..."
 
mNo edit summary
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
<includeonly><div class="center-col-1 center-col-3 center-col-5">{{#cargo_query:tables=btdb2_cosmetic_items, btdb2_cosmetic_categories
<includeonly>{{generic cargo compact list
|where =introduced = "{{{1|}}}"
|table=btdb2_cosmetic_items
|fields=CONCAT("[[File:", btdb2_cosmetic_items.image, "|20px|", btdb2_cosmetic_items.name, "]]") = Icon,
|col 1 name=Item
CONCAT(btdb2_cosmetic_items.name) = Name, <!-- the concat is a hack to get around apostrophes being parsed weirdly -->
|extra col 1=CONCAT("[[", _pageName, "|", category, "]]")=Category
CONCAT("[[File:", btdb2_cosmetic_categories.icon, "|x20px|", btdb2_cosmetic_categories.name, "|link=", btdb2_cosmetic_categories._pageName, "]][[",
|where=introduced="{{{1|2.0}}}"
btdb2_cosmetic_categories._pageName, "|", btdb2_cosmetic_categories.name, "]]") = Category
|center extra cols=y
 
|order by=category, name
|join on =btdb2_cosmetic_items.category = btdb2_cosmetic_categories.name
|no link=y
|group by=btdb2_cosmetic_items.image, btdb2_cosmetic_items.name, btdb2_cosmetic_categories.icon, btdb2_cosmetic_categories._pageName, btdb2_cosmetic_categories.name, btdb2_cosmetic_items.introduced
}}</includeonly><noinclude>{{/doc}}</noinclude>
|order by=Category
}}</div></includeonly><noinclude>{{/doc}}[[Category:Cargo query templates]][[Category:Battles 2 templates]]</noinclude>
Retrieved from "https://www.bloonswiki.com/Template:BTDB2_cosmetic_item_list_by_introduced"