Difference between revisions of "Template:CargoDisplayNHMaterial"
From Nookipedia, the Animal Crossing wiki
PanchamBro (talk | contribs) (overriding in the event that Turnips is a material) |
PanchamBro (talk | contribs) m (fixing recipe count for turnips) |
||
| Line 5: | Line 5: | ||
| {{Availability|{{{availability1|}}}|note={{#if:{{{availability1-note|}}}|{{{availability1-note|}}} {{#if:{{{material-seasonality|}}}|- {{{material-seasonality|}}}}}|{{{material-seasonality|}}}}}}} {{#if:{{{availability2|}}} |{{Availability|{{{availability2|}}}|note={{#if:{{{availability2-note|}}}|{{{availability2-note|}}} {{#if:{{{material-seasonality|}}}|- {{{material-seasonality|}}}}}|{{{material-seasonality|}}}}}}} | }} {{#if:{{{availability3|}}} |{{Availability|{{{availability3|}}}|note={{#if:{{{availability3-note|}}}|{{{availability3-note|}}} {{#if:{{{material-seasonality|}}}|- {{{material-seasonality|}}}}}|{{{material-seasonality|}}}}}}} | }} | | {{Availability|{{{availability1|}}}|note={{#if:{{{availability1-note|}}}|{{{availability1-note|}}} {{#if:{{{material-seasonality|}}}|- {{{material-seasonality|}}}}}|{{{material-seasonality|}}}}}}} {{#if:{{{availability2|}}} |{{Availability|{{{availability2|}}}|note={{#if:{{{availability2-note|}}}|{{{availability2-note|}}} {{#if:{{{material-seasonality|}}}|- {{{material-seasonality|}}}}}|{{{material-seasonality|}}}}}}} | }} {{#if:{{{availability3|}}} |{{Availability|{{{availability3|}}}|note={{#if:{{{availability3-note|}}}|{{{availability3-note|}}} {{#if:{{{material-seasonality|}}}|- {{{material-seasonality|}}}}}|{{{material-seasonality|}}}}}}} | }} | ||
| 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 '%"{{{name|}}}"%'|no html}} | + | | {{#ifeq:{{{name|}}}|Turnips|{{#cargo_query:table=nh_recipe|fields=COUNT(*)|where=nh_recipe.materials LIKE '%{{{name|}}}%'|no html}}|{{#cargo_query:table=nh_recipe|fields=COUNT(*)|where=nh_recipe.materials LIKE '%"{{{name|}}}"%'|no html}}}} |
| {{#ifeq:{{{name|}}}|Turnips|50|{{#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}}}}}}}} | | {{#ifeq:{{{name|}}}|Turnips|50|{{#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}}}}}}}} | ||
|-<</includeonly><noinclude>[[Category:Cargo display templates]]</noinclude> | |-<</includeonly><noinclude>[[Category:Cargo display templates]]</noinclude> | ||
