Template:BTDB2 hero reward list by id: Difference between revisions

Line 1:

~~<noinclude>{{/doc}}~~

<includeonly><div class="center-col-1 center-col-3">{{#cargo_query:table=btdb2_cosmetic_items,btdb2_cosmetic_categories

~~{{#cargo_attach:_table=btdb2_cosmetic_sources}}</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

Line 9:

Line 7:

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

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

|order by=(case btdb2_cosmetic_items.id when '{{{item 1|}}}' then 0 when '{{{item 2|}}}' then 1 when '{{{item 3|}}}' then 2 when '{{{item 4|}}}' then 3 when '{{{item 5|}}}' then 4 when '{{{item 6|}}}' then 5 when '{{{item 7|}}}' then 6 when '{{{item 8|}}}' then 7 when '{{{item 9|}}}' then 8 end)

|order by=(case btdb2_cosmetic_items.id when '{{{item 1|}}}' then 0 when '{{{item 2|}}}' then 1 when '{{{item 3|}}}' then 2 when '{{{item 4|}}}' then 3 when '{{{item 5|}}}' then 4 when '{{{item 6|}}}' then 5 when '{{{item 7|}}}' then 6 when '{{{item 8|}}}' then 7 when '{{{item 9|}}}' then 8 when '{{{item 10|}}}' then 9 end)

|format=table

}}</div>{{#cargo_store:_table=btdb2_cosmetic_sources

Line 39:

Line 37:

|name={{{hero|}}} Hero Rewards

|item={{{item 9|}}}

}}</includeonly>

}}{{#cargo_store:_table=btdb2_cosmetic_sources

|name={{{hero|}}} Hero Rewards

|item={{{item 10|}}}

}}</includeonly><noinclude>{{#cargo_attach:_table=btdb2_cosmetic_sources}}{{/doc}}</noinclude>

@@ Line 1: / Line 1: @@
-<noinclude>{{/doc}}
+<includeonly><div class="center-col-1 center-col-3">{{#cargo_query:table=btdb2_cosmetic_items,btdb2_cosmetic_categories
-{{#cargo_attach:_table=btdb2_cosmetic_sources}}</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
@@ Line 9: / Line 7: @@
 CONCAT("[[File:BTDB2 money icon.png|x20px|link=Monkey Money (Battles 2)|Monkey Money]] ", btdb2_cosmetic_categories.hero_mm_cost, "<br>[[File:BTDB2 hero xp large.png|x20px|link=Hero Point|Hero Points]] ", FORMAT(btdb2_cosmetic_categories.hero_point_cost, 0)) = Cost
-|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|}}}'
+|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|}}}'
-|order by=(case btdb2_cosmetic_items.id when '{{{item 1|}}}' then 0 when '{{{item 2|}}}' then 1 when '{{{item 3|}}}' then 2 when '{{{item 4|}}}' then 3 when '{{{item 5|}}}' then 4 when '{{{item 6|}}}' then 5 when '{{{item 7|}}}' then 6 when '{{{item 8|}}}' then 7 when '{{{item 9|}}}' then 8 end)
+|order by=(case btdb2_cosmetic_items.id when '{{{item 1|}}}' then 0 when '{{{item 2|}}}' then 1 when '{{{item 3|}}}' then 2 when '{{{item 4|}}}' then 3 when '{{{item 5|}}}' then 4 when '{{{item 6|}}}' then 5 when '{{{item 7|}}}' then 6 when '{{{item 8|}}}' then 7 when '{{{item 9|}}}' then 8 when '{{{item 10|}}}' then 9 end)
 |format=table
 }}</div>{{#cargo_store:_table=btdb2_cosmetic_sources
@@ Line 39: / Line 37: @@
 |name={{{hero|}}} Hero Rewards
 |item={{{item 9|}}}
-}}</includeonly>
+}}{{#cargo_store:_table=btdb2_cosmetic_sources
+|name={{{hero|}}} Hero Rewards
+|item={{{item 10|}}}
+}}</includeonly><noinclude>{{#cargo_attach:_table=btdb2_cosmetic_sources}}{{/doc}}</noinclude>