Blooncyclopedia

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

← Older edit
Polavux (talk | contribs)
Bureaucrats, Interface administrators, Administrators
58,371 edits
VisualWikitext
No edit summary
mNo edit summary
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
<noinclude>{{#cargo_attach:_table=btdb2_cosmetic_sources}}
<includeonly><div class="center-col-1 center-col-3">{{#cargo_query:table=btdb2_cosmetic_items,btdb2_cosmetic_categories
 
{{/doc}}[[Category:Cargo query templates]][[Category:Battles 2 templates]]</noinclude><includeonly>{{#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


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
}}{{#cargo_store:_table=btdb2_cosmetic_sources
}}</div>{{#cargo_store:_table=btdb2_cosmetic_sources
|name={{{hero|}}} Hero Rewards
|name={{{hero|}}} Hero Rewards
|item={{{item 1|}}}
|item={{{item 1|}}}
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>
Retrieved from "https://www.bloonswiki.com/Template:BTDB2_hero_reward_list_by_id"