Template:BTDB2 gift code rewards: Difference between revisions

mNo edit summary
mNo edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
<includeonly>{{#if:{{{mm|}}}|{{BTDB2 mm|{{{mm|}}}}}{{#if:{{{item 1|}}}{{{gb|}}}|,<nowiki> </nowiki>}}}}{{#if:{{{gb|}}}|{{BTDB2 gb|{{{gb|}}}}}{{#if:{{{item 1|}}}|,<nowiki> </nowiki>}}}}{{#if:{{{item 1|}}}|{{#cargo_query:tables=btdb2_cosmetic_items, btdb2_cosmetic_categories
<includeonly>{{#if:{{{mm|}}}|{{BTDB2 mm|{{{mm|}}}}}{{#if:{{{item 1|}}}{{{gb|}}}|,<nowiki> </nowiki>}}}}{{#if:{{{gb|}}}|{{BTDB2 gb|{{{gb|}}}}}{{#if:{{{item 1|}}}|,<nowiki> </nowiki>}}}}{{#if:{{{item 1|}}}|{{#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("<span style='white-space:nowrap'>{", "{icon", btdb2_cosmetic_items.image, "}", "}", btdb2_cosmetic_items.name, " [[", btdb2_cosmetic_categories._pageName, "|", category, "]]</span>") = text
|fields=CONCAT("<span style='white-space:nowrap'>[[File:", btdb2_cosmetic_items.image, "{{!}}x20px]] ", btdb2_cosmetic_items.name, " [[", btdb2_cosmetic_categories._pageName, "|", category, "]]</span>") = text


|where=btdb2_cosmetic_items.id = '{{{item 1|}}}' OR btdb2_cosmetic_items.id = '{{{item 2|}}}' OR btdb2_cosmetic_items.id = '{{{item 3|}}}' OR btdb2_cosmetic_items.id = '{{{item 4|}}}' OR btdb2_cosmetic_items.id = '{{{item 5|}}}' OR btdb2_cosmetic_items.id = '{{{item 6|}}}' OR btdb2_cosmetic_items.id = '{{{item 7|}}}' OR btdb2_cosmetic_items.id = '{{{item 8|}}}' OR btdb2_cosmetic_items.id = '{{{item 9|}}}' OR btdb2_cosmetic_items.id = '{{{item 10|}}}' OR btdb2_cosmetic_items.id = '{{{item 11|}}}' OR btdb2_cosmetic_items.id = '{{{item 12|}}}' OR btdb2_cosmetic_items.id = '{{{item 13|}}}' OR btdb2_cosmetic_items.id = '{{{item 14|}}}' OR btdb2_cosmetic_items.id = '{{{item 15|}}}' OR btdb2_cosmetic_items.id = '{{{item 16|}}}'
|where=btdb2_cosmetic_items.id = '{{{item 1|}}}' OR btdb2_cosmetic_items.id = '{{{item 2|}}}' OR btdb2_cosmetic_items.id = '{{{item 3|}}}' OR btdb2_cosmetic_items.id = '{{{item 4|}}}' OR btdb2_cosmetic_items.id = '{{{item 5|}}}' OR btdb2_cosmetic_items.id = '{{{item 6|}}}' OR btdb2_cosmetic_items.id = '{{{item 7|}}}' OR btdb2_cosmetic_items.id = '{{{item 8|}}}' OR btdb2_cosmetic_items.id = '{{{item 9|}}}' OR btdb2_cosmetic_items.id = '{{{item 10|}}}' OR btdb2_cosmetic_items.id = '{{{item 11|}}}' OR btdb2_cosmetic_items.id = '{{{item 12|}}}' OR btdb2_cosmetic_items.id = '{{{item 13|}}}' OR btdb2_cosmetic_items.id = '{{{item 14|}}}' OR btdb2_cosmetic_items.id = '{{{item 15|}}}' OR btdb2_cosmetic_items.id = '{{{item 16|}}}'