Blooncyclopedia

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

← Older editNewer edit →
Polavux (talk | contribs)
Bureaucrats, Interface administrators, Administrators
58,353 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-2 center-col-4">{{#cargo_query:tables=btd6_cosmetic_items=items, btd6_cosmetic_sources=sources
|fields=
|fields=
CONCAT("[[File:", btd6_cosmetic_items.image, "|x20px|", btd6_cosmetic_items.name, "]]") = Icon,
CONCAT("[[File:", items.image, "|30px|link=", items._pageName, "#", items.name, "|Icon of ", items.name, "]] ", items.name) = Item,
CONCAT(btd6_cosmetic_items.name) = Name, <!-- the concat is a hack to get around apostrophes being parsed weirdly -->
CONCAT(items.category, " — ", "[[", items._pageName, "|", items.subcategory, "]]") = Category,
CONCAT(btd6_cosmetic_items.category, " — ", "[[", btd6_cosmetic_items._pageName, "|", btd6_cosmetic_items.subcategory, "]]") = Category,
{{#if:{{{hide sources|}}}||COALESCE(GROUP_CONCAT(sources.name ORDER BY CASE
COALESCE(GROUP_CONCAT(btd6_cosmetic_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 btd6_cosmetic_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") = Source(s),
IF(items.introduced = "", "''To be added''", CONCAT("[[Bloons TD 6 v", items.introduced, "|Version ", items.introduced, "]]")) = Introduced
IF(btd6_cosmetic_items.introduced = "", "TBD", CONCAT("[[Bloons TD 6 v", btd6_cosmetic_items.introduced, "|Version ", btd6_cosmetic_items.introduced, "]]")) = Introduced


|where   ={{#invoke:cargo name list|main|id|{{{1|x}}}}}
|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 =btd6_cosmetic_items.id = btd6_cosmetic_sources.item
|join on =items.id = sources.item
|group by=btd6_cosmetic_items._pageName, btd6_cosmetic_items.name, btd6_cosmetic_items.image, btd6_cosmetic_items.description, btd6_cosmetic_items.category, btd6_cosmetic_items.subcategory, btd6_cosmetic_items.introduced
|group by=items._pageName, items.name, items.image, items.description, items.category, items.subcategory, items.introduced
|order by=introduced
|order by=introduced
|format  =table
|format  =table
}}</div></includeonly><noinclude>{{/doc}}</noinclude>
}}</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>
Retrieved from "https://www.bloonswiki.com/Template:BTD6_cosmetic_item_list_by_id"