Difference between revisions of "Template:CargoDisplayNHMaterial"

From Nookipedia, the Animal Crossing wiki
(Created page with "<includeonly><!-- This first line must remain empty -->{{#vardefine:material1|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material1_num),1)|where=nh_recipe.mater...")
 
Line 2: Line 2:
 
| {{i|{{{name|}}}|New Horizons}}{{#ifeq:{{{material-type|}}}|Star Fragment|{{Note|name=Star Fragment|All Star Fragments are limited to 40 per day, and only up to 20 can have been earned from another island.}}}}
 
| {{i|{{{name|}}}|New Horizons}}{{#ifeq:{{{material-type|}}}|Star Fragment|{{Note|name=Star Fragment|All Star Fragments are limited to 40 per day, and only up to 20 can have been earned from another island.}}}}
 
| [[File:{{{image|}}}|64px|{{{name|}}}]]
 
| [[File:{{{image|}}}|64px|{{{name|}}}]]
| {{Availability|{{{availability1|}}}|note={{#if:{{{availability1-note|}}}|{{{availability1-note|}}} {{#if:{{{material-seasonality|}}}|- {{{material-seasonality|}}}}}|{{{material-seasonality|}}}}}}} {{#if:{{{availability2|}}} |{{Availability|{{{availability2|}}}|note={{#if:{{{availability2-note|}}}|{{{availability2-note|}}} {{#if:{{{material-seasonality|}}}|- {{{material-seasonality|}}}}}|{{{material-seasonality|}}}}}}} | }}
+
| {{Availability|{{{availability1|}}}|note={{#if:{{{availability1-note|}}}|{{{availability1-note|}}} {{#if:{{{material-seasonality|}}}|- {{{material-seasonality|}}}}}|{{{material-seasonality|}}}}}}} {{#if:{{{availability2|}}} |{{Availability|{{{availability2|}}}|note={{#if:{{{availability2-note|}}}|{{{availability2-note|}}} {{#if:{{{material-seasonality|}}}|- {{{material-seasonality|}}}}}|{{{material-seasonality|}}}}}}} | }} {{#if:{{{availability3|}}} |{{Availability|{{{availability3|}}}|note={{#if:{{{availability3-note|}}}|{{{availability3-note|}}} {{#if:{{{material-seasonality|}}}|- {{{material-seasonality|}}}}}|{{{material-seasonality|}}}}}}} | }}
 
| data-sort-value="{{{sell|}}}" | {{#if:{{{sell|}}}|{{Currency|Bells|{{{sell|}}}}}|Cannot be sold}}
 
| data-sort-value="{{{sell|}}}" | {{#if:{{{sell|}}}|{{Currency|Bells|{{{sell|}}}}}|Cannot be sold}}
 
| {{#cargo_query:table=nh_recipe|fields=COUNT(*)|where=nh_recipe.materials LIKE '%"{{{name|}}}"%'|no html}}
 
| {{#cargo_query:table=nh_recipe|fields=COUNT(*)|where=nh_recipe.materials LIKE '%"{{{name|}}}"%'|no html}}
 
| {{#expr:{{#expr:trunc{{#var:material1|0}}}} + {{#expr:trunc{{#var:material2|0}}}} + {{#expr:trunc{{#var:material3|0}}}} + {{#expr:trunc{{#var:material4|0}}}} + {{#expr:trunc{{#var:material5|0}}}} + {{#expr:trunc{{#var:material6|0}}}}}}
 
| {{#expr:{{#expr:trunc{{#var:material1|0}}}} + {{#expr:trunc{{#var:material2|0}}}} + {{#expr:trunc{{#var:material3|0}}}} + {{#expr:trunc{{#var:material4|0}}}} + {{#expr:trunc{{#var:material5|0}}}} + {{#expr:trunc{{#var:material6|0}}}}}}
 
|-<</includeonly><noinclude>[[Category:Cargo display templates]]</noinclude>
 
|-<</includeonly><noinclude>[[Category:Cargo display templates]]</noinclude>

Revision as of 18:39, March 3, 2021