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

mNo edit summary
mNo edit summary
 
(10 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><div class="center-col-1 center-col-3">{{#cargo_query:table=btdb2_cosmetic_items, btdb2_cosmetic_categories
|join on=btdb2_cosmetic_items.category=btdb2_cosmetic_categories.name
 
|fields=CONCAT("[[File:", btdb2_cosmetic_items.image, "|50x50px]]") = Icon,
CONCAT(btdb2_cosmetic_items.name) = Name,
CONCAT("[[File:",btdb2_cosmetic_categories.icon,"|20x20px|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|}}}'
|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|}}}'
|order by=btdb2_cosmetic_categories.name
|order by=categories.name
|format=table
|format=table
|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|}}}
|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|}}}
}}}}{{#if:{{{5|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
}}}}{{#if:{{{5|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source|}}}
|name={{{source 5|{{{source|}}}}}}
|item={{{5|}}}
|item={{{5|}}}
}}}}{{#if:{{{6|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
}}}}{{#if:{{{6|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source|}}}
|name={{{source 6|{{{source|}}}}}}
|item={{{6|}}}
|item={{{6|}}}
}}}}{{#if:{{{7|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
}}}}{{#if:{{{7|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source|}}}
|name={{{source 7|{{{source|}}}}}}
|item={{{7|}}}
|item={{{7|}}}
}}}}{{#if:{{{8|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
}}}}{{#if:{{{8|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source|}}}
|name={{{source 8|{{{source|}}}}}}
|item={{{8|}}}
|item={{{8|}}}
}}}}{{#if:{{{9|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
}}}}{{#if:{{{9|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source|}}}
|name={{{source 9|{{{source|}}}}}}
|item={{{9|}}}
|item={{{9|}}}
}}}}{{#if:{{{10|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
}}}}{{#if:{{{10|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{source|}}}
|name={{{source 10|{{{source|}}}}}}
|item={{{10|}}}
|item={{{10|}}}
}}}}}}</includeonly>
}}}}{{#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>