Difference between revisions of "User:PanchamBro/Sandbox/Green"

Revision as of 16:35, March 3, 2021

Materials are resources in Animal Crossing: New Horizons that are used for crafting DIY recipes. The player can obtain raw materials from hitting rocks, shaking trees, and fishing around the player's island as well as Mystery Islands. Additionally, the player can obtain Star Fragments after wishing on a shooting star during a Meteor Shower. These resources can be crafted into items from DIY Recipes or sold to Timmy or Tommy.

There are also seasonal materials that are only available at certain times of the year or during specific events.

List of materials

Items in Animal Crossing: New Horizons

Item	Image	Available From	Sell Price	Recipes	Total Needed^{[nb 1]}

Includes data sourced from the Data Spreadsheet for Animal Crossing New Horizons, compiled and edited by 6480, noizhub, Ricky, chaiinchomp, saberslime, robotic_scarab, mollumisc, sunmarsh, kyrokey, obstinateRixatrix, jackiwi, Zalex, SuperHamster, kait, hyuum, Azarro, Czarcasm, cinnamon_swirlix, astronomyfortwo, Welcius, glowtopia, BriKun, Alyrei, dodocodes.com, StevieCoops, sneeze, Shiny190, TwistedPeach, LavaToaster, capstone, vmario, rocklamp, Alexis, Aeon, and PanchamBro.

Seasonal

Some materials are seasonal and are only available at certain times of the year.

Items in Animal Crossing: New Horizons

Item	Image	Available From	Sell Price	Recipes	Total Needed^{[nb 1]}

Includes data sourced from the Data Spreadsheet for Animal Crossing New Horizons, compiled and edited by 6480, noizhub, Ricky, chaiinchomp, saberslime, robotic_scarab, mollumisc, sunmarsh, kyrokey, obstinateRixatrix, jackiwi, Zalex, SuperHamster, kait, hyuum, Azarro, Czarcasm, cinnamon_swirlix, astronomyfortwo, Welcius, glowtopia, BriKun, Alyrei, dodocodes.com, StevieCoops, sneeze, Shiny190, TwistedPeach, LavaToaster, capstone, vmario, rocklamp, Alexis, Aeon, and PanchamBro.

Notes

↑ ^1.0 ^1.1 Number of material needed to craft one of everything that requires this material

[Material-1] 1.0 ^1.1 Number of material needed to craft one of everything that requires this material

[nb 1]

@@ Line 19: / Line 19: @@
 }}
 {{#cargo_query:
-|tables=nh_item, nh_recipe
+|tables=nh_item
-|join on=nh_item.en_name = nh_recipe.material1, nh_item.en_name = nh_recipe.material2, nh_item.en_name = nh_recipe.material3, nh_item.en_name = nh_recipe.material4, nh_item.en_name = nh_recipe.material5, nh_item.en_name = nh_recipe.material6
 |group by=nh_item.en_name
-|fields=nh_item.en_name=name,nh_item.image,nh_item.sell,nh_item.availability1,nh_item.availability1_note=availability1-note,nh_item.availability2,nh_item.availability2_note=availability2-note,COUNT(SUBSTRING(1,nh_recipe.materials-1) LIKE '%nh_item.en_name%')=recipe-count,SUM(nh_recipe.materials LIKE nh_item.en_name)=recipe-total
+|fields=nh_item.en_name=name,nh_item.image,nh_item.sell,nh_item.availability1,nh_item.availability1_note=availability1-note,nh_item.availability2,nh_item.availability2_note=availability2-note,CONCAT(nh_item.en_name)=recipe-count,CONCAT(nh_item.en_name)=recipe-total
 |where=nh_item.is_material=1 AND nh_item.material_seasonality IS NULL
 |order by=nh_item.material_type, nh_item.en_name
@@ Line 254: / Line 253: @@
 }}
 {{#cargo_query:
-|tables=nh_item, nh_recipe
+|tables=nh_item
-|join on=nh_item.en_name = nh_recipe.material1, nh_item.en_name = nh_recipe.material2, nh_item.en_name = nh_recipe.material3, nh_item.en_name = nh_recipe.material4, nh_item.en_name = nh_recipe.material5, nh_item.en_name = nh_recipe.material6
 |group by=nh_item.en_name
-|fields=nh_item.en_name=name,nh_item.image,nh_item.sell,nh_item.availability1,nh_item.availability1_note=availability1-note,nh_item.material_seasonality=material-seasonality,nh_item.availability2,nh_item.availability2_note,COUNT(SUBSTRING(1,nh_recipe.materials-1) LIKE '%nh_item.en_name%')=recipe-count,SUM(nh_recipe.materials LIKE nh_item.en_name)=recipe-total
+|fields=nh_item.en_name=name,nh_item.image,nh_item.sell,nh_item.availability1,nh_item.availability1_note=availability1-note,nh_item.material_seasonality=material-seasonality,nh_item.availability2,nh_item.availability2_note,CONCAT(nh_item.en_name)=recipe-count,CONCAT(nh_item.en_name)=recipe-total
 |where=nh_item.material_seasonality IS NOT NULL
 |order by=nh_item.material_seasonality, nh_item.material_type, nh_item.en_name

Anonymous

Search

Difference between revisions of "User:PanchamBro/Sandbox/Green"

Namespaces

More

Page actions

Revision as of 16:35, March 3, 2021

List of materials

Seasonal

Notes

Navigation

Navigation

New Horizons

Community

Contents

Maintenance

Wiki tools

Wiki tools

Anonymous

Search

Difference between revisions of "User:PanchamBro/Sandbox/Green"

Revision as of 16:35, March 3, 2021

List of materials

Seasonal

Notes

Navigation

Wiki tools

Page actions

⧼Advertisement⧽

Categories