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

From Blooncyclopedia, the independent Bloons knowledge base
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(2 intermediate revisions by the same user not shown)
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
|join on=btdb2_cosmetic_items.category=btdb2_cosmetic_categories.name


|fields=CONCAT("[[File:", btdb2_cosmetic_items.image, "|50x50px]]") = Icon,
|fields=CONCAT("[[File:", btdb2_cosmetic_items.image, "|50x50px]]") = Icon,
CONCAT("'''", btdb2_cosmetic_items.name, "'''<br>", btdb2_cosmetic_items.description) = Name / description,
CONCAT("'''", btdb2_cosmetic_items.name, "'''<br>", btdb2_cosmetic_items.description) = Text,
CONCAT("[[File:",btdb2_cosmetic_categories.icon,"|20x20px|link=", btdb2_cosmetic_categories._pageName, "]][[",btdb2_cosmetic_categories._pageName, "|", category, "]]") = Category,
CONCAT("[[File:",btdb2_cosmetic_categories.icon,"|20x20px|link=", btdb2_cosmetic_categories._pageName, "]] [[",btdb2_cosmetic_categories._pageName, "|", category, "]]") = Category,
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
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
|format=table
}}</div>{{#cargo_store:_table=btdb2_cosmetic_sources
}}</div>{{#cargo_store:_table=btdb2_cosmetic_sources
Line 39: Line 37:
|name={{{hero|}}} Hero Rewards
|name={{{hero|}}} Hero Rewards
|item={{{item 9|}}}
|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>

Latest revision as of 14:20, 16 April 2025

This template adds rows to the table "btdb2_cosmetic_sources", which is declared by the template BTDB2 cosmetic item list by id. View table.

No description.

Template parameters[Edit template data]

ParameterDescriptionTypeStatus
Herohero

no description

Stringoptional
Item ID 1item 1

no description

Stringoptional
Item ID 2item 2

no description

Stringoptional
Item ID 3item 3

no description

Stringoptional
Item ID 4item 4

no description

Stringoptional
Item ID 5item 5

no description

Stringoptional
Item ID 6item 6

no description

Stringoptional
Item ID 7item 7

no description

Stringoptional
Item ID 8item 8

no description

Stringoptional
Item ID 9item 9

no description

Stringoptional