Difference between revisions of "DIY recipes/Jock"

From Nookipedia, the Animal Crossing wiki
m (Text replacement - "|order by=nh_recipe.serial_id |format=" to "|format=")
(Merging tables)
Line 1: Line 1:
 
The following is a '''list of [[DIY]] recipes in {{NH}}''' that can be obtained from [[jock]] villagers, either while they are crafting in their homes or from a [[Message Bottle]].
 
The following is a '''list of [[DIY]] recipes in {{NH}}''' that can be obtained from [[jock]] 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
+
table=nh_recipe
−
|join on=nh_furniture.en_name = nh_recipe.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_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
+
|order by=nh_recipe.type
−
|group by=nh_furniture.en_name
 
−
|where=nh_recipe.diy_availability1 LIKE '%Jock%' OR nh_recipe.diy_availability2 LIKE '%Jock%'
 
−
|format=template
 
−
|template=CargoDisplayNHDIY
 
−
|named args=yes
 
−
|limit=500
 
−
}}
 
−
{{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
 
−
 
 
−
== Clothing ==
 
−
{{TableTop NH DIY}}
 
−
{{#cargo_query:
 
−
table=nh_recipe,nh_clothing
 
−
|join on=nh_clothing.en_name = nh_recipe.en_name
 
−
|group by=nh_clothing.en_name
 
−
|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 '%Jock%' OR nh_recipe.diy_availability2 LIKE '%Jock%'
 
−
|format=template
 
−
|template=CargoDisplayNHDIY
 
−
|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_interior.en_name = nh_recipe.en_name
 
−
|group by=nh_interior.en_name
 
−
|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 '%Jock%' OR nh_recipe.diy_availability2 LIKE '%Jock%'
 
|where=nh_recipe.diy_availability1 LIKE '%Jock%' OR nh_recipe.diy_availability2 LIKE '%Jock%'
 
|format=template
 
|format=template

Revision as of 22:28, December 26, 2020

The following is a list of DIY recipes in Animal Crossing: New Horizons that can be obtained from jock 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
- [[|Pear hat]] pear hat Clothing Not for sale  Jock villager
 5× Pear
- [[|Pear umbrella]] pear umbrella Clothing Not for sale  Jock villager
 7× Pear
- [[|Leaf]] leaf Clothing Not for sale  Jock villager
 5× Clump of weeds
- [[|Pear dress]] pear dress Clothing Not for sale  Jock villager
 8× Pear
- [[|Log pack]] log pack Clothing Not for sale  Jock villager
 3× Wood
5× Hardwood
- [[|Pear wardrobe]] pear wardrobe Furniture Not for sale  Tom Nook
 Jock villager
 10× Pear
5× Wood
- [[|Firewood]] firewood Furniture Not for sale  Jock villager
 8× Wood
- [[|Bamboo wall decoration]] bamboo wall decoration Furniture Not for sale  Jock villager
 1× Bamboo piece
- [[|Wooden field sign]] wooden field sign Furniture Not for sale  Jock villager
 6× Softwood
2× Hardwood
- [[|Skateboard wall rack]] skateboard wall rack Furniture Not for sale  Jock villager
 3× Skateboard
2× Hardwood
- [[|Tulip surprise box]] tulip surprise box Furniture Not for sale  Jock villager
 5× Red tulips
3× Softwood
- [[|Plain wooden shop sign]] plain wooden shop sign Furniture Not for sale  Jock villager
 6× Wood
- [[|Golden samurai suit]] golden samurai suit Furniture Not for sale  Jock villager
 2× Gold nugget
1× Samurai suit
- [[|Bamboo stopblock]] bamboo stopblock Furniture Not for sale  Jock villager
 3× Bamboo piece
- [[|Fossil doorplate]] fossil doorplate Furniture Not for sale  Jock villager
 1× Fossil
2× Stone
- [[|Stacked bottle crates]] stacked bottle crates Furniture Not for sale  Jock villager
 2× Bottle crate
1× Wood
- [[|Bamboo drum]] bamboo drum Furniture Not for sale  Jock villager
 3× Bamboo piece
2× Softwood
- [[|Barbell]] barbell Furniture Not for sale  Jock villager
 10× Iron nugget
- [[|Oil-barrel bathtub]] oil-barrel bathtub Furniture Not for sale  Jock villager
 1× Oil barrel
1× Campfire
2× Stone
- [[|Tree standee]] tree standee Furniture Not for sale  Jock villager
 5× Wood
8× Softwood
- [[|Iron frame]] iron frame Furniture Not for sale  Jock villager
 20× Iron nugget
- [[|Gold-nugget mining car]] gold-nugget mining car Furniture Not for sale  Jock villager
 3× Gold nugget
1× Mining car
- [[|Trophy case]] trophy case Furniture Not for sale  Jock villager
 24× Hardwood
3× Gold nugget
6× Iron nugget
- [[|Simple DIY workbench]] simple DIY workbench Furniture Not for sale  Jock villager
 Nintendo
 5× Hardwood
1× Iron nugget
- [[|Wild log bench]] wild log bench Furniture Not for sale  Jock villager
 8× Hardwood
- [[|Pear bed]] pear bed Furniture Not for sale  Tom Nook
 Jock villager
 10× Pear
6× Softwood
- [[|Kettlebell]] kettlebell Furniture Not for sale  Jock villager
 5× Iron nugget
- [[|Beekeeper's hive]] beekeeper's hive Furniture Not for sale  Jock villager
 3× Wasp nest
5× Wood
- [[|Mountain standee]] mountain standee Furniture Not for sale  Jock villager
 4× Wood
5× Softwood
- [[|Doghouse]] doghouse Furniture Not for sale  Jock villager
 10× Wood
7× Hardwood
- [[|Jungle wall]] jungle wall Interior Not for sale  Jock villager
 15× Clump of weeds
3× Wood
3× Hardwood
3× Softwood
- [[|Pear wall]] pear wall Interior Not for sale  Jock villager
 20× Pear
- [[|Stacked-wood wall]] stacked-wood wall Interior Not for sale  Jock villager
 15× Hardwood
- [[|Sandy-beach flooring]] sandy-beach flooring Interior Not for sale  Jock villager
 1× Sea snail
1× Venus comb
1× Sand dollar
1× Coral
1× Giant clam
1× Cowrie
- [[|Pear rug]] pear rug Interior Not for sale  Jock villager
 6× Pear
- [[|Jungle flooring]] jungle flooring Interior Not for sale  Jock villager
 10× Clump of weeds
10× Clay
- [[|Honeycomb wall]] honeycomb wall Interior Not for sale  Jock villager
 6× Wasp nest
- [[|Honeycomb flooring]] honeycomb flooring Interior Not for sale  Jock villager
 5× Wasp nest
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.
Retrieved from "https://nookipedia.com/w/index.php?title=DIY_recipes/Jock&oldid=491084"