Template:BTDB2 cosmetic item list by id: Difference between revisions
mNo edit summary Tag: Manual revert |
No edit summary |
||
| Line 4: | Line 4: | ||
}} | }} | ||
{{/doc}}[[Category:Cargo query templates]][[Category:Battles 2 templates]]</noinclude><includeonly>{{#cargo_query: | {{/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 | |join on=btdb2_cosmetic_items.category=btdb2_cosmetic_categories.name | ||
|fields=CONCAT("[[File:", btdb2_cosmetic_items.image, "| | |||
btdb2_cosmetic_items.name = Name, | |fields=CONCAT("[[File:", btdb2_cosmetic_items.image, "|50x50px]]") = Icon, | ||
CONCAT("[[File:",btdb2_cosmetic_categories. | CONCAT(btdb2_cosmetic_items.name, "<br>", btdb2_cosmetic_items.description) = Name, | ||
|where={{ | CONCAT("[[File:",btdb2_cosmetic_categories.icon,"|20x20px|link=", btdb2_cosmetic_categories._pageName, "]][[",btdb2_cosmetic_categories._pageName, "|", category, "]]") = Category | ||
|order by= | |||
|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|}}}' | |||
|order by=btdb2_cosmetic_categories.name | |||
|format=table | |format=table | ||
}}{{#if:{{{source|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources | }}</div>{{#if:{{{source|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources | ||
|name={{{source|}}} | |name={{{source|}}} | ||
|item={{{1|}}} | |item={{{1|}}} | ||
| Line 18: | Line 20: | ||
|name={{{source|}}} | |name={{{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|}}} | ||
|item={{{3|}}} | |item={{{3|}}} | ||
}}{{#if:{{{4|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources | }}}}{{#if:{{{4|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources | ||
|name={{{source|}}} | |name={{{source|}}} | ||
|item={{{4|}}} | |item={{{4|}}} | ||
}}}}}}}}}}</includeonly> | }}}}{{#if:{{{5|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources | ||
|name={{{source|}}} | |||
|item={{{5|}}} | |||
}}}}{{#if:{{{6|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources | |||
|name={{{source|}}} | |||
|item={{{6|}}} | |||
}}}}{{#if:{{{7|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources | |||
|name={{{source|}}} | |||
|item={{{7|}}} | |||
}}}}{{#if:{{{8|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources | |||
|name={{{source|}}} | |||
|item={{{8|}}} | |||
}}}}{{#if:{{{9|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources | |||
|name={{{source|}}} | |||
|item={{{9|}}} | |||
}}}}{{#if:{{{10|}}}|{{#cargo_store:_table=btdb2_cosmetic_sources | |||
|name={{{source|}}} | |||
|item={{{10|}}} | |||
}}}}}}</includeonly> | |||