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 -->
+
<includeonly><!-- This first line must remain empty -->{{#vardefine:material1|{{#cargo_query:table=nh_recipe|fields=nh_recipe.material1_num|where=nh_recipe.material1 LIKE '%"{{{recipe-total|}}}"%'|no html}}}}{{#vardefine:material2|{{#cargo_query:table=nh_recipe|fields=nh_recipe.material2_num|where=nh_recipe.material2 LIKE '%"{{{recipe-total|}}}"%'|no html}}}}{{#vardefine:material3|{{#cargo_query:table=nh_recipe|fields=nh_recipe.material3_num|where=nh_recipe.material3 LIKE '%"{{{recipe-total|}}}"%'|no html}}}}{{#vardefine:material4|{{#cargo_query:table=nh_recipe|fields=nh_recipe.material4_num|where=nh_recipe.material4 LIKE '%"{{{recipe-total|}}}"%'|no html}}}}{{#vardefine:material5|{{#cargo_query:table=nh_recipe|fields=nh_recipe.material5_num|where=nh_recipe.material5 LIKE '%"{{{recipe-total|}}}"%'|no html}}}}{{#vardefine:material6|{{#cargo_query:table=nh_recipe|fields=nh_recipe.material6_num|where=nh_recipe.material6 LIKE '%"{{{recipe-total|}}}"%'|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 '%"{{{recipe-count|}}}"%'|no html}}
 
| {{#cargo_query:table=nh_recipe|fields=COUNT(*)|where=nh_recipe.materials LIKE '%"{{{recipe-count|}}}"%'|no html}}
| {{#cargo_query:table=nh_recipe|fields=COUNT(nh_recipe.material1_num + nh_recipe.material2_num + nh_recipe.material3_num + nh_recipe.material4_num + nh_recipe.material5_num + nh_recipe.material6_num)|where=nh_recipe.material1 LIKE '%"{{{recipe-total|}}}"%' OR nh_recipe.material2 LIKE '%"{{{recipe-total|}}}"%' OR nh_recipe.material3 LIKE '%"{{{recipe-total|}}}"%' OR nh_recipe.material4 LIKE '%"{{{recipe-total|}}}"%' OR nh_recipe.material5 LIKE '%"{{{recipe-total|}}}"%' OR nh_recipe.material6 LIKE '%"{{{recipe-total|}}}"%'|no html}}
+
| {{#expr:{{#var:material1}}+{{#var:material2}}+{{#var:material3}}+{{#var:material4}}+{{#var:material5}}+{{#var:material6}}}}
 
|-<</includeonly><noinclude></noinclude>
 
|-<</includeonly><noinclude></noinclude>

Revision as of 16:53, March 3, 2021