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 -->{{#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}}}}
+
<includeonly><!-- This first line must remain empty -->{{#vardefine:material1|{{#cargo_query:table=nh_recipe|fields=nh_recipe.material1_num|where=nh_recipe.material1 = {{{name|}}}|no html}}}}{{#vardefine:material2|{{#cargo_query:table=nh_recipe|fields=nh_recipe.material2_num|where=nh_recipe.material2 = {{{name|}}}|no html}}}}{{#vardefine:material3|{{#cargo_query:table=nh_recipe|fields=nh_recipe.material3_num|where=nh_recipe.material3 = {{{name|}}}|no html}}}}{{#vardefine:material4|{{#cargo_query:table=nh_recipe|fields=nh_recipe.material4_num|where=nh_recipe.material4 = {{{name|}}}|no html}}}}{{#vardefine:material5|{{#cargo_query:table=nh_recipe|fields=nh_recipe.material5_num|where=nh_recipe.material5 = {{{name|}}}|no html}}}}{{#vardefine:material6|{{#cargo_query:table=nh_recipe|fields=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|}}}]]

Revision as of 16:58, March 3, 2021