Difference between revisions of "DIY recipes/Cranky"

From Nookipedia, the Animal Crossing wiki
m (Text replacement - "|join on=nh_recipe.en_name = nh_interior.en_name" to "|join on=nh_interior.en_name = nh_recipe.en_name")
m (DIY icons)
Line 4: Line 4:
 
{{TableTop NH DIY}}
 
{{TableTop NH DIY}}
 
{{#cargo_query:
 
{{#cargo_query:
table=nh_recipe,nh_furniture,nh_furniture_variation
+
table=nh_recipe,nh_furniture
|join on=nh_furniture.en_name = nh_furniture_variation.en_name, nh_furniture.en_name = nh_recipe.en_name
+
|join on=nh_furniture.en_name = nh_recipe.en_name
|fields=nh_recipe.en_name=name,nh_furniture_variation.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
+
|fields=nh_recipe.en_name=name,nh_recipe.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
 
|group by=nh_furniture.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%'
Line 20: Line 20:
 
{{TableTop NH DIY}}
 
{{TableTop NH DIY}}
 
{{#cargo_query:
 
{{#cargo_query:
table=nh_recipe,nh_clothing,nh_clothing_variation
+
table=nh_recipe,nh_clothing
|join on=nh_clothing.en_name = nh_clothing_variation.en_name, nh_clothing.en_name = nh_recipe.en_name
+
|join on=nh_clothing.en_name = nh_recipe.en_name
 
|group by=nh_clothing.en_name
 
|group by=nh_clothing.en_name
|fields=nh_recipe.en_name=name,nh_clothing_variation.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
+
|fields=nh_recipe.en_name=name,nh_recipe.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%'
 
|where=nh_recipe.diy_availability1 LIKE '%Cranky%' OR nh_recipe.diy_availability2 LIKE '%Cranky%'
 
|order by=nh_recipe.serial_id
 
|order by=nh_recipe.serial_id
Line 39: Line 39:
 
|join on=nh_interior.en_name = nh_recipe.en_name
 
|join on=nh_interior.en_name = nh_recipe.en_name
 
|group by=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
+
|fields=nh_recipe.en_name=name,nh_recipe.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%'
 
|where=nh_recipe.diy_availability1 LIKE '%Cranky%' OR nh_recipe.diy_availability2 LIKE '%Cranky%'
 
|order by=nh_recipe.serial_id
 
|order by=nh_recipe.serial_id

Revision as of 10:11, September 2, 2020

This is the list of the recipes in Animal Crossing: New Horizons that may be obtained from Cranky villagers while they are crafting in their homes.

Furniture

Recipes in Animal Crossing: New Horizons

Clothing

Recipes in Animal Crossing: New Horizons

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.

Interior

Recipes in Animal Crossing: New Horizons

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.