Blooncyclopedia

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

← Older editNewer edit →
Polavux (talk | contribs)
Bureaucrats, Interface administrators, Administrators
58,403 edits
VisualWikitext
mNo edit summary
No edit summary
Line 1: Line 1:
<includeonly><div class="center-col-1 center-col-3 center-col-5">{{#cargo_query:tables=btd6_cosmetic_items, btd6_cosmetic_sources
<includeonly><div class="center-col-1 center-col-3 center-col-5">{{#cargo_query:tables=btd6_cosmetic_items, btd6_cosmetic_sources
|fields=
|fields=
CONCAT("[[File:", btd6_cosmetic_items.image, "|x50px|", btd6_cosmetic_items.name, "]]") = Icon,
CONCAT("[[File:", btd6_cosmetic_items.image, "|x20px|", btd6_cosmetic_items.name, "]]") = Icon,
CONCAT("[[", btd6_cosmetic_items._pageName, "#", btd6_cosmetic_items.name, "|", btd6_cosmetic_items.name, "]]<br>", btd6_cosmetic_items.description) = Name / description,
CONCAT(btd6_cosmetic_items.name) = Name, <!-- the concat is a hack to get around apostrophes being parsed weirdly -->
CONCAT(btd6_cosmetic_items.category, "<hr>", btd6_cosmetic_items.subcategory) = Category,
CONCAT(btd6_cosmetic_items.category, " — ", "[[", btd6_cosmetic_items._pageName, "|", btd6_cosmetic_items.subcategory, "]]") = Category,
CONCAT("<ul>", GROUP_CONCAT("<li>", btd6_cosmetic_sources.name, "</li>" ORDER BY btd6_cosmetic_sources.name DESC SEPARATOR ""), "</ul>") = Source(s),
GROUP_CONCAT(btd6_cosmetic_sources.name ORDER BY CASE
WHEN btd6_cosmetic_sources.name LIKE 'Trophy Store%' THEN 0 ELSE 1 END <!-- sources beginning with "Trophy Store" are listed first -->
SEPARATOR ', ') = Source(s),
CONCAT("[[Bloons TD 6 v", btd6_cosmetic_items.introduced, "|Version ", btd6_cosmetic_items.introduced, "]]") = Introduced
CONCAT("[[Bloons TD 6 v", btd6_cosmetic_items.introduced, "|Version ", btd6_cosmetic_items.introduced, "]]") = Introduced


Line 12: Line 14:
|order by=introduced
|order by=introduced
|format  =table
|format  =table
}}</div></includeonly><noinclude>{{/doc}}[[Category:Cargo query templates]][[Category:BTD6 templates]]</noinclude>
}}</div></includeonly><noinclude>{{/doc}}</noinclude>
Retrieved from "https://www.bloonswiki.com/Template:BTD6_cosmetic_item_list_by_id"