Blooncyclopedia

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

← Older edit
Polavux (talk | contribs)
Bureaucrats, Interface administrators, Administrators
58,353 edits
VisualWikitext
mNo edit summary
mNo edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
<includeonly><div class="center-col-1 center-col-3">{{#cargo_query:table=btdb2_cosmetic_items, btdb2_cosmetic_categories
<includeonly><div class="center-col-2">{{#cargo_query:tables=btdb2_cosmetic_items=items, btdb2_cosmetic_categories=categories
|join on=btdb2_cosmetic_items.category=btdb2_cosmetic_categories.name
|fields=CONCAT("[[File:", items.image, "|30px|link=", items._pageName, "|Icon of ", items.name, "]] ", items.name) = Item,
CONCAT("[[File:",categories.icon,"|x20px|link=", categories._pageName, "]] [[",categories._pageName, "|", items.category, "]]") = Category


|fields=CONCAT("[[File:", btdb2_cosmetic_items.image, "|x20px]]") = Icon,
|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|}}}'
CONCAT(btdb2_cosmetic_items.name) = Name,
|order by=categories.name
CONCAT("[[File:",btdb2_cosmetic_categories.icon,"|x20px|link=", btdb2_cosmetic_categories._pageName, "]] [[",btdb2_cosmetic_categories._pageName, "|", category, "]]") = Category
 
|where=btdb2_cosmetic_items.id = '{{{1|}}}' OR btdb2_cosmetic_items.id = '{{{2|}}}' OR btdb2_cosmetic_items.id = '{{{3|}}}' OR btdb2_cosmetic_items.id = '{{{4|}}}' OR btdb2_cosmetic_items.id = '{{{5|}}}' OR btdb2_cosmetic_items.id = '{{{6|}}}' OR btdb2_cosmetic_items.id = '{{{7|}}}' OR btdb2_cosmetic_items.id = '{{{8|}}}' OR btdb2_cosmetic_items.id = '{{{9|}}}' OR btdb2_cosmetic_items.id = '{{{10|}}}' OR btdb2_cosmetic_items.id = '{{{11|}}}' OR btdb2_cosmetic_items.id = '{{{12|}}}' OR btdb2_cosmetic_items.id = '{{{13|}}}' OR btdb2_cosmetic_items.id = '{{{14|}}}' OR btdb2_cosmetic_items.id = '{{{15|}}}' OR btdb2_cosmetic_items.id = '{{{16|}}}' OR btdb2_cosmetic_items.id = '{{{17|}}}' OR btdb2_cosmetic_items.id = '{{{18|}}}' OR btdb2_cosmetic_items.id = '{{{19|}}}' OR btdb2_cosmetic_items.id = '{{{20|}}}'
|order by=btdb2_cosmetic_categories.name
|format=table
|format=table
|limit=1500
|join on=items.category=categories.name
}}</div>{{#if:{{{source|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
}}</div>{{#if:{{{source|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 1|{{{source|}}}}}}
|name={{{source 1|{{{source|}}}}}}
Retrieved from "https://www.bloonswiki.com/Template:BTDB2_cosmetic_item_list_by_id"