Difference between revisions of "DIY recipes/Cranky"

From Nookipedia, the Animal Crossing wiki
m (Text replacement - "nh_recipes" to "nh_recipe")
m (Text replacement - "|order by=nh_recipe.type" to "|order by=nh_recipe.type,nh_recipe.en_name")
(18 intermediate revisions by 4 users not shown)
Line 1: Line 1:
This is the list of the recipes in {{NH}} that may be obtained from [[Cranky]] villagers while they are crafting in their homes.
+
{{DISPLAYTITLE:List of recipes obtained from cranky villager in {{NH|short|nolink}}}}
 +
This is a '''list of [[DIY]] recipes''' in {{NH}} that can be obtained from [[cranky]] villagers, either while they are crafting in their homes or from a [[Message Bottle]].
  
== Furniture ==
 
 
{{TableTop NH DIY}}
 
{{TableTop NH DIY}}
 
{{#cargo_query:
 
{{#cargo_query:
table=nh_recipe,nh_furniture,nh_furniture_variations
+
table=nh_recipe
|join on=nh_recipe.en_name = nh_furniture.en_name, nh_furniture.en_name = nh_furniture_variations.en_name
+
|fields=nh_recipe.en_name=name,nh_recipe.image,nh_recipe.type,nh_recipe.diy_availability1=availability1,nh_recipe.diy_availability2=availability2,nh_recipe.material1_num=material1n,nh_recipe.material1,nh_recipe.material2_num=material2n,nh_recipe.material2,nh_recipe.material3_num=material3n,nh_recipe.material3,nh_recipe.material4_num=material4n,nh_recipe.material4,nh_recipe.material5_num=material5n,nh_recipe.material5,nh_recipe.material6_num=material6n,nh_recipe.material6
|fields=nh_recipe.en_name=name,nh_furniture_variations.image,nh_recipe.diy_availability1=availability1,nh_recipe.diy_availability2=availability2,nh_recipe.material1_num=material1n,nh_recipe.material1,nh_recipe.material2_num=material2n,nh_recipe.material2,nh_recipe.material3_num=material3n,nh_recipe.material3,nh_recipe.material4_num=material4n,nh_recipe.material4,nh_recipe.material5_num=material5n,nh_recipe.material5,nh_recipe.material6_num=material6n,nh_recipe.material6,nh_furniture.grid_size=gridsize,nh_furniture.sell
+
|order by=nh_recipe.type,nh_recipe.en_name
|group by=nh_furniture.en_name
 
 
|where=nh_recipe.diy_availability1 LIKE '%Cranky%' OR nh_recipe.diy_availability2 LIKE '%Cranky%'
 
|where=nh_recipe.diy_availability1 LIKE '%Cranky%' OR nh_recipe.diy_availability2 LIKE '%Cranky%'
|order by=nh_recipe.serial_id
 
 
|format=template
 
|format=template
|template=BarLinkDIY
+
|template=CargoDisplayNHDIY
 
|named args=yes
 
|named args=yes
 
|limit=500
 
|limit=500
Line 17: Line 15:
 
{{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
 
{{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
  
== Clothing ==
+
[[Category:Lists of DIY recipes]]
{{TableTop NH DIY}}
 
{{#cargo_query:
 
table=nh_recipe,nh_clothing,nh_clothing_variations
 
|join on=nh_recipe.en_name = nh_clothing.en_name, nh_clothing.en_name = nh_clothing_variations.en_name
 
|group by=nh_clothing.en_name
 
|fields=nh_recipe.en_name=name,nh_clothing_variations.image,nh_recipe.diy_availability1=availability1,nh_recipe.diy_availability2=availability2,nh_recipe.material1_num=material1n,nh_recipe.material1,nh_recipe.material2_num=material2n,nh_recipe.material2,nh_recipe.material3_num=material3n,nh_recipe.material3,nh_recipe.material4_num=material4n,nh_recipe.material4,nh_recipe.material5_num=material5n,nh_recipe.material5,nh_recipe.material6_num=material6n,nh_recipe.material6,nh_clothing.sell
 
|where=nh_recipe.diy_availability1 LIKE '%Cranky%' OR nh_recipe.diy_availability2 LIKE '%Cranky%'
 
|order by=nh_recipe.serial_id
 
|format=template
 
|template=BarLinkDIY
 
|named args=yes
 
|limit=500
 
}}
 
{{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
 
 
 
== Interior ==
 
{{TableTop NH DIY}}
 
{{#cargo_query:
 
table=nh_recipe,nh_interior
 
|join on=nh_recipe.en_name = nh_interior.en_name
 
|group by=nh_interior.en_name
 
|fields=nh_recipe.en_name=name,nh_interior.image,nh_recipe.diy_availability1=availability1,nh_recipe.diy_availability2=availability2,nh_recipe.material1_num=material1n,nh_recipe.material1,nh_recipe.material2_num=material2n,nh_recipe.material2,nh_recipe.material3_num=material3n,nh_recipe.material3,nh_recipe.material4_num=material4n,nh_recipe.material4,nh_recipe.material5_num=material5n,nh_recipe.material5,nh_recipe.material6_num=material6n,nh_recipe.material6,nh_interior.grid_size=gridsize,nh_interior.sell
 
|where=nh_recipe.diy_availability1 LIKE '%Cranky%' OR nh_recipe.diy_availability2 LIKE '%Cranky%'
 
|order by=nh_recipe.serial_id
 
|format=template
 
|template=BarLinkDIY
 
|named args=yes
 
|limit=500
 
}}
 
{{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
 

Revision as of 12:05, December 15, 2021

This is a list of DIY recipes in Animal Crossing: New Horizons that can be obtained from cranky villagers, either while they are crafting in their homes or from a Message Bottle.

Recipes in Animal Crossing: New Horizons

# Item Image Type Buy price Available from Materials
- [[|Armor shoes]] armor shoes Clothing Not for sale  Cranky villager
Iron nugget
- [[|Bamboo hat]] bamboo hat Clothing Not for sale  Cranky villager
10× Clump of weeds
- [[|Iron armor]] iron armor Clothing Not for sale  Cranky villager
Iron nugget
- [[|Knight's helmet]] knight's helmet Clothing Not for sale  Cranky villager
Iron nugget
- [[|Bamboo partition]] bamboo partition Furniture Not for sale  Cranky villager
Bamboo piece
Stone
- [[|Barrel]] barrel Furniture Not for sale  Tom Nook
 Cranky villager
Wood
Iron nugget
- [[|Bonfire]] bonfire Furniture Not for sale  Tom Nook
 Cranky villager
Campfire
10× Wood
- [[|Bonsai shelf]] bonsai shelf Furniture Not for sale  Cranky villager
Cherry-blossom bonsai
Pine bonsai tree
Wood
- [[|Clothesline]] clothesline Furniture Not for sale  Tom Nook
 Cranky villager
10× Tree branch
- [[|Deer scare]] deer scare Furniture Not for sale  Cranky villager
Bamboo piece
Stone
Clump of weeds
- [[|Dharma]] dharma Furniture Not for sale  Cranky villager
Mini dharma
- [[|Fruit basket]] fruit basket Furniture Not for sale  Cranky villager
Apple
Pear
Cherry
Orange
Peach
- [[|Fruit wreath]] fruit wreath Furniture Not for sale  Cranky villager
Apple
Pear
Cherry
Orange
Peach
- [[|Golden decorative plate]] golden decorative plate Furniture Not for sale  Cranky villager
Gold nugget
Decorative plate
- [[|Golden dharma]] golden dharma Furniture Not for sale  Cranky villager
Gold nugget
Dharma
- [[|Gong]] gong Furniture Not for sale  Cranky villager
Iron nugget
Wood
- [[|Infused-water dispenser]] infused-water dispenser Furniture Not for sale  Cranky villager
Apple
Pear
Cherry
Orange
Peach
Coconut
- [[|Iron hanger stand]] iron hanger stand Furniture Not for sale  Cranky villager
Iron nugget
- [[|Ironwood DIY workbench]] ironwood DIY workbench Furniture Not for sale  Cranky villager
12× Wood
Iron nugget
Mini DIY workbench
- [[|Ironwood table]] ironwood table Furniture Not for sale  Cranky villager
12× Wood
Iron nugget
- [[|Jail bars]] jail bars Furniture Not for sale  Cranky villager
Iron nugget
- [[|Kettle bathtub]] kettle bathtub Furniture Not for sale  Cranky villager
Iron nugget
Wood
Campfire
- [[|Lily record player]] lily record player Furniture Not for sale  Cranky villager
White lilies
Iron nugget
Wood
- [[|Log dining table]] log dining table Furniture Not for sale  Tom Nook
 Cranky villager
15× Hardwood
- [[|Mini golden dharma]] mini golden dharma Furniture Not for sale  Cranky villager
Gold nugget
Mini dharma
- [[|Modeling clay]] modeling clay Furniture Not for sale  Cranky villager
Clay
- [[|Pile of zen cushions]] pile of zen cushions Furniture Not for sale  Cranky villager
Zen cushion
- [[|Pot]] pot Furniture Not for sale  Tom Nook
 Cranky villager
Clay
- [[|Raccoon figurine]] raccoon figurine Furniture Not for sale  Cranky villager
Clay
- [[|Scarecrow]] scarecrow Furniture Not for sale  Cranky villager
Tree branch
Clump of weeds
- [[|Senmaizuke barrel]] senmaizuke barrel Furniture Not for sale  Cranky villager
1× 30 turnips
- [[|Sleigh]] sleigh Furniture Not for sale  Cranky villager
Wood
- [[|Stacked senmaizuke barrels]] stacked senmaizuke barrels Furniture Not for sale  Cranky villager
Senmaizuke barrel
- [[|Standard umbrella stand]] standard umbrella stand Furniture Not for sale  Cranky villager
Iron nugget
- [[|Tea table]] tea table Furniture Not for sale  Cranky villager
12× Hardwood
- [[|Tiki torch]] tiki torch Furniture Not for sale  Tom Nook
 Cranky villager
Tree branch
Wood
- [[|Wooden-plank sign]] wooden-plank sign Furniture Not for sale  Cranky villager
Hardwood
- [[|Bamboo flooring]] bamboo flooring Interior Not for sale  Cranky villager
15× Bamboo piece
- [[|Bamboo wall]] bamboo wall Interior Not for sale  Cranky villager
15× Bamboo piece
- [[|Dark bamboo bath mat]] dark bamboo bath mat Interior Not for sale  Cranky villager
Bamboo piece
- [[|Dark bamboo rug]] dark bamboo rug Interior Not for sale  Cranky villager
Bamboo piece
- [[|Green bamboo mat]] green bamboo mat Interior Not for sale  Cranky villager
Bamboo piece
- [[|Wild-wood wall]] wild-wood wall Interior Not for sale  Cranky villager
15× Wood
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.