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: | ||
<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|}}} | |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> | |||