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

mNo edit summary
Pymonkibot (talk | contribs)
m Text replacement - "[[Bloons TD 6 v" to "[[Update history:Bloons TD 6/Version "
 
(11 intermediate revisions by one other user not shown)
Line 1: Line 1:
<includeonly><table class="wikitable sortable"><tr><th class="unsortable">Icon</th><th>Name / Description</th><th>Category</th><th>[[File:BTD6 TrophyIcon.png|x20px|link=Monkey Money (BTD6)]]Cost</th><th>Limited?</th></tr>{{#cargo_query:table=btd6_cosmetic_items
<includeonly><div class="center-col-2 responsive-block-col-1">{{#cargo_query:tables=btd6_cosmetic_items=items, btd6_cosmetic_sources=sources
|fields=_pageName = page name,name,image,description,category,subcategory,cost,limited,introduced
|fields=
|where={{#invoke:cargo name list|main|id|{{{1|x}}}}}
CONCAT("[[File:", items.image, "|30px|link=", items._pageName, "#", items.name, "|Icon of ", items.name, "]] ", items.name) = Item,
|order by=category,subcategory
CONCAT(items.category, " — ", "[[", items._pageName, "|", items.subcategory, "]]") = Category,
|format=template
{{#if:{{{hide sources|}}}||COALESCE(GROUP_CONCAT(sources.name ORDER BY CASE
|template=BTD6 cosmetic item list row
WHEN sources.name LIKE '[[Trophy Store]]%' THEN 0 ELSE 1 END <!-- sources beginning with "Trophy Store" are listed first -->
|named args=yes
SEPARATOR ', '), "TBD") = Unlock method(s),}}
}}</table></includeonly><noinclude>[[Category:Cargo query templates]][[Category:BTD6 templates]]</noinclude>
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|}}}'
|join on =items.id = sources.item
|group by=items._pageName, items.name, items.image, items.description, items.category, items.subcategory, items.introduced, items.xd_only
|order by=introduced
|format  =table
}}</div>{{#if:{{{source|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 1|{{{source|}}}}}}
|item={{{1|}}}
}}{{#if:{{{2|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 2|{{{source|}}}}}}
|item={{{2|}}}
}}}}{{#if:{{{3|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 3|{{{source|}}}}}}
|item={{{3|}}}
}}}}{{#if:{{{4|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 4|{{{source|}}}}}}
|item={{{4|}}}
}}}}{{#if:{{{5|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 5|{{{source|}}}}}}
|item={{{5|}}}
}}}}{{#if:{{{6|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 6|{{{source|}}}}}}
|item={{{6|}}}
}}}}{{#if:{{{7|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 7|{{{source|}}}}}}
|item={{{7|}}}
}}}}{{#if:{{{8|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 8|{{{source|}}}}}}
|item={{{8|}}}
}}}}{{#if:{{{9|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 9|{{{source|}}}}}}
|item={{{9|}}}
}}}}{{#if:{{{10|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 10|{{{source|}}}}}}
|item={{{10|}}}
}}}}{{#if:{{{11|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 11|{{{source|}}}}}}
|item={{{11|}}}
}}}}{{#if:{{{12|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 12|{{{source|}}}}}}
|item={{{12|}}}
}}}}{{#if:{{{13|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 13|{{{source|}}}}}}
|item={{{13|}}}
}}}}{{#if:{{{14|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 14|{{{source|}}}}}}
|item={{{14|}}}
}}}}{{#if:{{{15|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 15|{{{source|}}}}}}
|item={{{15|}}}
}}}}{{#if:{{{16|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 16|{{{source|}}}}}}
|item={{{16|}}}
}}}}{{#if:{{{17|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 17|{{{source|}}}}}}
|item={{{17|}}}
}}}}{{#if:{{{18|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 18|{{{source|}}}}}}
|item={{{18|}}}
}}}}{{#if:{{{19|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 19|{{{source|}}}}}}
|item={{{19|}}}
}}}}{{#if:{{{20|}}}|{{#cargo_store:_table=btd6_cosmetic_sources
|name={{{source 20|{{{source|}}}}}}
|item={{{20|}}}
}}}}}}</includeonly><noinclude>{{/doc}}</noinclude>