Template:BTDB2 cosmetic item list by id: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<includeonly><div class="center-col-2">{{#cargo_query:tables=btdb2_cosmetic_items=items, btdb2_cosmetic_categories=categories | |||
|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:", | |||
CONCAT("[[File:", | |||
|where= | |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= | |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 1|{{{source|}}}}}} | |name={{{source 1|{{{source|}}}}}} | ||
| Line 63: | Line 55: | ||
|name={{{source 16|{{{source|}}}}}} | |name={{{source 16|{{{source|}}}}}} | ||
|item={{{16|}}} | |item={{{16|}}} | ||
}}}}}}</includeonly> | }}}}{{#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> | |||