Difference between revisions of "User:PanchamBro/Sandbox/Coconut"
From Nookipedia, the Animal Crossing wiki
< User:PanchamBro | Sandbox
PanchamBro (talk | contribs) |
PanchamBro (talk | contribs) (Undo revision 540357 by PanchamBro (talk)) Tag: Undo |
||
Line 1: | Line 1: | ||
− | <includeonly><!-- This first line must remain empty -->{{#vardefine:material1|{{#cargo_query:table=nh_recipe|fields= | + | <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}} | | {{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}} | + | | {{#expr:trunc{{#var:material1}}}} |
|-<</includeonly><noinclude></noinclude> | |-<</includeonly><noinclude></noinclude> |