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

From Nookipedia, the Animal Crossing wiki
Line 4: Line 4:
 
| {{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}}
| {{{recipe-count|}}}
+
| {{#cargo_query:table=nh_recipe|fields=COUNT(*)|where=nh_recipe.materials LIKE '%"{{{recipe-count|}}}"%'|no html}}
| {{{recipe-total|}}}
+
| {{#cargo_query:table=nh_recipe|fields=SUM(*)|where=nh_recipe.materials LIKE '%"{{{recipe-total|}}}"%'|no html}}
 
|-<</includeonly><noinclude></noinclude>
 
|-<</includeonly><noinclude></noinclude>

Revision as of 15:39, March 3, 2021