Difference between revisions of "User:PanchamBro/Sandbox/Coconut"

From Nookipedia, the Animal Crossing wiki
Line 1: Line 1:
<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.material1 = '{{{name|}}}'|no html}}}}{{#vardefine:material2|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material2_num),1)|where=nh_recipe.material2 = '{{{name|}}}'|no html}}}}{{#vardefine:material3|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material3_num),1)|where=nh_recipe.material3 = '{{{name|}}}'|no html}}}}{{#vardefine:material4|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material4_num),1)|where=nh_recipe.material4 = '{{{name|}}}'|no html}}}}{{#vardefine:material5|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material5_num),1)|where=nh_recipe.material5 = '{{{name|}}}'|no html}}}}{{#vardefine:material6|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material6_num),1)|where=nh_recipe.material6 = '{{{name|}}}'|no html}}}}{{#vardefine:fragment|{{#cargo_query:table=nh_item|fields=nh_item.en_name|where=nh_item.en_name LIKE '%Fragment$'|no html}}}}
+
<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.material1 = '{{{name|}}}'|no html}}}}{{#vardefine:material2|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material2_num),1)|where=nh_recipe.material2 = '{{{name|}}}'|no html}}}}{{#vardefine:material3|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material3_num),1)|where=nh_recipe.material3 = '{{{name|}}}'|no html}}}}{{#vardefine:material4|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material4_num),1)|where=nh_recipe.material4 = '{{{name|}}}'|no html}}}}{{#vardefine:material5|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material5_num),1)|where=nh_recipe.material5 = '{{{name|}}}'|no html}}}}{{#vardefine:material6|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material6_num),1)|where=nh_recipe.material6 = '{{{name|}}}'|no html}}}}
| {{i|{{{name|}}}|New Horizons}}{{#ifeq:{{{name|}}}|{{#var: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:{{{name|}}}|{{#cargo_query:table=nh_item|fields=nh_item.en_name|where={{{name|}}} LIKE '%Fragment$'|no html}}{{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|}}}}}}} | }}

Revision as of 17:46, March 3, 2021