Difference between revisions of "Template:NHMaterialTotal"

From Nookipedia, the Animal Crossing wiki
m
(adding category)
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}}}}}}<noinclude>[[Category:Cargo templates]]</noinclude>
+
{{#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]][[Category:Pages using the Variables extension]]</noinclude>

Revision as of 12:25, November 1, 2022

0