Difference between revisions of "User:PanchamBro/Sandbox/Coconut"
From Nookipedia, the Animal Crossing wiki
< User:PanchamBro | Sandbox
PanchamBro (talk | contribs) |
PanchamBro (talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | <includeonly><!-- This first line must remain empty -->{{#vardefine:material1|{{#cargo_query:table=nh_recipe|fields=SUM(nh_recipe.material1_num)|where=nh_recipe.material1 = '{{{name|}}}'|no html}}}}{{#vardefine:material2|{{#cargo_query:table=nh_recipe|fields=SUM(nh_recipe.material2_num)|where=nh_recipe.material2 = '{{{name|}}}'|no html}}}}{{#vardefine:material3|{{#cargo_query:table=nh_recipe|fields=SUM(nh_recipe.material3_num)|where=nh_recipe.material3 = '{{{name|}}}'|no html}}}}{{#vardefine:material4|{{#cargo_query:table=nh_recipe|fields=SUM(nh_recipe.material4_num)|where=nh_recipe.material4 = '{{{name|}}}'|no html}}}}{{#vardefine:material5|{{#cargo_query:table=nh_recipe|fields=SUM(nh_recipe.material5_num)|where=nh_recipe.material5 = '{{{name|}}}'|no html}}}}{{#vardefine:material6|{{#cargo_query:table=nh_recipe|fields=SUM(nh_recipe.material6_num)|where=nh_recipe.material6 = '{{{name|}}}'|no html}}}} | + | <includeonly><!-- This first line must remain empty -->{{#vardefine:material1|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material1_num))|where=nh_recipe.material1 = '{{{name|}}}'|no html}}}}{{#vardefine:material2|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material2_num))|where=nh_recipe.material2 = '{{{name|}}}'|no html}}}}{{#vardefine:material3|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material3_num))|where=nh_recipe.material3 = '{{{name|}}}'|no html}}}}{{#vardefine:material4|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material4_num))|where=nh_recipe.material4 = '{{{name|}}}'|no html}}}}{{#vardefine:material5|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material5_num))|where=nh_recipe.material5 = '{{{name|}}}'|no html}}}}{{#vardefine:material6|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material6_num))|where=nh_recipe.material6 = '{{{name|}}}'|no html}}}} |
| {{i|{{{name|}}}|New Horizons}} | | {{i|{{{name|}}}|New Horizons}} | ||
| [[File:{{{image|}}}|64px|{{{name|}}}]] | | [[File:{{{image|}}}|64px|{{{name|}}}]] | ||
| Line 5: | Line 5: | ||
| 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}} | ||
| − | | {{#var:material1}}+{{#var:material2}}+{{#var:material3}}+{{#var:material4}}+{{#var:material5}}+{{#var:material6}} | + | | {{#expr:{{#var:material1}}+{{#var:material2}}+{{#var:material3}}+{{#var:material4}}+{{#var:material5}}+{{#var:material6}}}} |
|-<</includeonly><noinclude></noinclude> | |-<</includeonly><noinclude></noinclude> | ||
