Difference between revisions of "Template:NHMaterialTotal"

From Nookipedia, the Animal Crossing wiki
(Creating)
 
m
Line 1: Line 1:
 
{{#vardefine:material1|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material1_num),1)|where=nh_recipe.material1 = '{{{1|}}}'|no html}}}}{{#vardefine:material2|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material2_num),1)|where=nh_recipe.material2 = '{{{1|}}}'|no html}}}}{{#vardefine:material3|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material3_num),1)|where=nh_recipe.material3 = '{{{1|}}}'|no html}}}}{{#vardefine:material4|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material4_num),1)|where=nh_recipe.material4 = '{{{1|}}}'|no html}}}}{{#vardefine:material5|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material5_num),1)|where=nh_recipe.material5 = '{{{1|}}}'|no html}}}}{{#vardefine:material6|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material6_num),1)|where=nh_recipe.material6 = '{{{1|}}}'|no html}}}}
 
{{#vardefine:material1|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material1_num),1)|where=nh_recipe.material1 = '{{{1|}}}'|no html}}}}{{#vardefine:material2|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material2_num),1)|where=nh_recipe.material2 = '{{{1|}}}'|no html}}}}{{#vardefine:material3|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material3_num),1)|where=nh_recipe.material3 = '{{{1|}}}'|no html}}}}{{#vardefine:material4|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material4_num),1)|where=nh_recipe.material4 = '{{{1|}}}'|no html}}}}{{#vardefine:material5|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material5_num),1)|where=nh_recipe.material5 = '{{{1|}}}'|no html}}}}{{#vardefine:material6|{{#cargo_query:table=nh_recipe|fields=ROUND(SUM(nh_recipe.material6_num),1)|where=nh_recipe.material6 = '{{{1|}}}'|no html}}}}
 
 
{{#expr:{{#expr:trunc{{#var:material1|0}}}} + {{#expr:trunc{{#var:material2|0}}}} + {{#expr:trunc{{#var:material3|0}}}} + {{#expr:trunc{{#var:material4|0}}}} + {{#expr:trunc{{#var:material5|0}}}} + {{#expr:trunc{{#var:material6|0}}}}}}
 
{{#expr:{{#expr:trunc{{#var:material1|0}}}} + {{#expr:trunc{{#var:material2|0}}}} + {{#expr:trunc{{#var:material3|0}}}} + {{#expr:trunc{{#var:material4|0}}}} + {{#expr:trunc{{#var:material5|0}}}} + {{#expr:trunc{{#var:material6|0}}}}}}
 
<noinclude>[[Category:Cargo templates]]</noinclude>
 
<noinclude>[[Category:Cargo templates]]</noinclude>

Revision as of 14:42, January 12, 2022

0