Template:BTD6 cosmetic item list by id: Difference between revisions
No edit summary |
Pymonkibot (talk | contribs) m Text replacement - "[[Bloons TD 6 v" to "[[Update history:Bloons TD 6/Version " |
||
| (4 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
<includeonly><div class="center-col-2 | <includeonly><div class="center-col-2 responsive-block-col-1">{{#cargo_query:tables=btd6_cosmetic_items=items, btd6_cosmetic_sources=sources | ||
|fields= | |fields= | ||
CONCAT("[[File:", items.image, "|30px|link=", items._pageName, "#", items.name, "|Icon of ", items.name, "]] ", items.name) = Item, | CONCAT("[[File:", items.image, "|30px|link=", items._pageName, "#", items.name, "|Icon of ", items.name, "]] ", items.name) = Item, | ||
CONCAT(items.category, " — ", "[[", items._pageName, "|", items.subcategory, "]]") = Category, | CONCAT(items.category, " — ", "[[", items._pageName, "|", items.subcategory, "]]") = Category, | ||
{{#if:{{{hide sources|}}}||COALESCE(GROUP_CONCAT(sources.name ORDER BY CASE | {{#if:{{{hide sources|}}}||COALESCE(GROUP_CONCAT(sources.name ORDER BY CASE | ||
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 | IF(items.introduced = "", "''To be added''", CONCAT("[[Update history:Bloons TD 6/Version ", 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 | ||