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=nh_recipe.material1_num|where=nh_recipe.material1 LIKE '%"{{{ | + | <includeonly><!-- This first line must remain empty -->{{#vardefine:material1|{{#cargo_query:table=nh_recipe|fields=SUM(nh_recipe.material1_num)|where=nh_recipe.material1 LIKE '%"{{{name|}}}"%'|no html}}}}{{#vardefine:material2|{{#cargo_query:table=nh_recipe|fields=SUM(nh_recipe.material2_num)|where=nh_recipe.material2 LIKE '%"{{{name|}}}"%'|no html}}}}{{#vardefine:material3|{{#cargo_query:table=nh_recipe|fields=SUM(nh_recipe.material3_num)|where=nh_recipe.material3 LIKE '%"{{{name|}}}"%'|no html}}}}{{#vardefine:material4|{{#cargo_query:table=nh_recipe|fields=SUM(nh_recipe.material4_num)|where=nh_recipe.material4 LIKE '%"{{{name|}}}"%'|no html}}}}{{#vardefine:material5|{{#cargo_query:table=nh_recipe|fields=SUM(nh_recipe.material5_num)|where=nh_recipe.material5 LIKE '%"{{{name|}}}"%'|no html}}}}{{#vardefine:material6|{{#cargo_query:table=nh_recipe|fields=SUM(nh_recipe.material6_num)|where=nh_recipe.material6 LIKE '%"{{{name|}}}"%'|no html}}}} |
| {{i|{{{name|}}}|New Horizons}} | | {{i|{{{name|}}}|New Horizons}} | ||
| [[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|}}}}}}} | }} | ||
| 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 '%"{{{ | + | | {{#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}} | | {{#var:material1}}+{{#var:material2}}+{{#var:material3}}+{{#var:material4}}+{{#var:material5}}+{{#var:material6}} | ||
|-<</includeonly><noinclude></noinclude> | |-<</includeonly><noinclude></noinclude> | ||
