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

Created page with "<noinclude>{{#cargo_declare:_table=btdb2_cosmetic_sources |name=Wikitext string |item=String }} {{/doc}}Category:Cargo query templatesCategory:Battles 2 templates</noinclude><includeonly>{{#cargo_query:tables=btdb2_cosmetic_items,btdb2_cosmetic_categories |join on=btdb2_cosmetic_items.category=btdb2_cosmetic_categories.name |fields=CONCAT("20x20px") = Icon, btdb2_cosmetic_items.name = Name, CONCAT("File:",btdb2_cosmeti..."
 
mNo edit summary
 
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
<noinclude>{{#cargo_declare:_table=btdb2_cosmetic_sources
<includeonly><div class="center-col-2">{{#cargo_query:tables=btdb2_cosmetic_items=items, btdb2_cosmetic_categories=categories
|name=Wikitext string
|fields=CONCAT("[[File:", items.image, "|30px|link=", items._pageName, "|Icon of ", items.name, "]] ", items.name) = Item,
|item=String
CONCAT("[[File:",categories.icon,"|x20px|link=", categories._pageName, "]] [[",categories._pageName, "|", items.category, "]]") = Category
}}


{{/doc}}[[Category:Cargo query templates]][[Category:Battles 2 templates]]</noinclude><includeonly>{{#cargo_query:tables=btdb2_cosmetic_items,btdb2_cosmetic_categories
|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=btdb2_cosmetic_items.category=btdb2_cosmetic_categories.name
|order by=categories.name
|fields=CONCAT("[[File:", btdb2_cosmetic_items.image, "|20x20px]]") = Icon,
btdb2_cosmetic_items.name = Name,
CONCAT("[[File:",btdb2_cosmetic_categories.image,"|20x20px|link=", btdb2_cosmetic_categories._pageName, "]][[",btdb2_cosmetic_categories._pageName, "|", category, "]]") = Category
|where={{#invoke:cargo name list|main|btdb2_cosmetic_items.id|{{{1|x}}}}}
|order by=category
|format=table
|format=table
}}{{#if:{{{source|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|join on=items.category=categories.name
|name={{{source|}}}
}}</div>{{#if:{{{source|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 1|{{{source|}}}}}}
|item={{{1|}}}
|item={{{1|}}}
}}{{#if:{{{2|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
}}{{#if:{{{2|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source|}}}
|name={{{source 2|{{{source|}}}}}}
|item={{{2|}}}
|item={{{2|}}}
}}{{#if:{{{3|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
}}}}{{#if:{{{3|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source|}}}
|name={{{source 3|{{{source|}}}}}}
|item={{{3|}}}
|item={{{3|}}}
}}{{#if:{{{4|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
}}}}{{#if:{{{4|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source|}}}
|name={{{source 4|{{{source|}}}}}}
|item={{{4|}}}
|item={{{4|}}}
}}}}}}}}}}</includeonly>
}}}}{{#if:{{{5|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 5|{{{source|}}}}}}
|item={{{5|}}}
}}}}{{#if:{{{6|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 6|{{{source|}}}}}}
|item={{{6|}}}
}}}}{{#if:{{{7|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 7|{{{source|}}}}}}
|item={{{7|}}}
}}}}{{#if:{{{8|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 8|{{{source|}}}}}}
|item={{{8|}}}
}}}}{{#if:{{{9|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 9|{{{source|}}}}}}
|item={{{9|}}}
}}}}{{#if:{{{10|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 10|{{{source|}}}}}}
|item={{{10|}}}
}}}}{{#if:{{{11|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 11|{{{source|}}}}}}
|item={{{11|}}}
}}}}{{#if:{{{12|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 12|{{{source|}}}}}}
|item={{{12|}}}
}}}}{{#if:{{{13|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 13|{{{source|}}}}}}
|item={{{13|}}}
}}}}{{#if:{{{14|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 14|{{{source|}}}}}}
|item={{{14|}}}
}}}}{{#if:{{{15|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 15|{{{source|}}}}}}
|item={{{15|}}}
}}}}{{#if:{{{16|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 16|{{{source|}}}}}}
|item={{{16|}}}
}}}}{{#if:{{{17|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 17|{{{source|}}}}}}
|item={{{17|}}}
}}}}{{#if:{{{18|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 18|{{{source|}}}}}}
|item={{{18|}}}
}}}}{{#if:{{{19|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 19|{{{source|}}}}}}
|item={{{19|}}}
}}}}{{#if:{{{20|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source 20|{{{source|}}}}}}
|item={{{20|}}}
}}}}}}</includeonly><noinclude>{{#cargo_declare:_table=btdb2_cosmetic_sources
|name=Wikitext string
|item=String
}}{{/doc}}</noinclude>