Template:BTDB2 cosmetic item list by id: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
<includeonly><div class="center-col-1 center-col-3">{{#cargo_query:table=btdb2_cosmetic_items, btdb2_cosmetic_categories | <includeonly><div class="center-col-1 center-col-3">{{#cargo_query:table=btdb2_cosmetic_items=items, btdb2_cosmetic_categories=categories | ||
|join on=btdb2_cosmetic_items.category=btdb2_cosmetic_categories.name | |join on=btdb2_cosmetic_items.category=btdb2_cosmetic_categories.name | ||
|fields=CONCAT("[[File:", | |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 | |||
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=btdb2_cosmetic_categories.name | |order by=btdb2_cosmetic_categories.name | ||
|format=table | |format=table | ||