Difference between revisions of "Template:NHMaterialTotal"

From Nookipedia, the Animal Crossing wiki
m
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