Latest revision |
Your text |
Line 138: |
Line 138: |
| }} | | }} |
| {{Clear}} | | {{Clear}} |
− |
| |
− | ==Items==
| |
− | The following 77 items that were added in the 2.0 Free Update can only be obtained through the {{HHP|short|nolink}} DLC.
| |
− | {{TableTop Multi|game=NH|name={{HHP|short|nolink}} items|collapsed=yes}}
| |
− | {{#cargo_compound_query:
| |
− | tables=nh_furniture,nh_furniture_variation;
| |
− | join on=nh_furniture_variation.en_name = nh_furniture.en_name;
| |
− | group by=nh_furniture.en_name;
| |
− | fields=nh_furniture.en_name=name,nh_furniture_variation.image,CONCAT('Furniture')=type,nh_furniture.buy1_price=buy1-price,nh_furniture.buy1_wikitext=buy1,nh_furniture.sell,nh_furniture.availability1,nh_furniture.availability2;
| |
− | where=availability1='Lottie' OR availability1='Wardell' OR nh_furniture.en_name='Paradise Planning photo';
| |
− | limit=600
| |
− | |tables=nh_clothing,nh_clothing_variation;
| |
− | join on=nh_clothing_variation.en_name = nh_clothing.en_name;
| |
− | group by=nh_clothing.en_name;
| |
− | fields=nh_clothing.en_name=name,nh_clothing_variation.image,CONCAT('Clothing')=type,nh_clothing.buy1_price=buy1-price,nh_clothing.buy1_wikitext=buy1,nh_clothing.sell,nh_clothing.availability1,nh_clothing.availability2;
| |
− | where=availability1='Lottie' OR availability1='Wardell';
| |
− | limit=600
| |
− | |tables=nh_interior;
| |
− | group by=nh_interior.en_name;
| |
− | fields=nh_interior.en_name=name,nh_interior.image,CONCAT('Interior')=type,nh_interior.buy1_price=buy1-price,nh_interior.buy1_wikitext=buy1,nh_interior.sell,nh_interior.availability1,nh_interior.availability2;
| |
− | where=availability1='Lottie' OR availability1='Wardell';
| |
− | limit=600
| |
− | |tables=nh_photo,nh_photo_variation;
| |
− | join on=nh_photo_variation.en_name = nh_photo.en_name;
| |
− | group by=nh_photo.en_name;
| |
− | fields=nh_photo.en_name=name,nh_photo_variation.image,CONCAT('Photo')=type,nh_photo.buy1_price=buy1-price,nh_photo.buy1_wikitext=buy1,nh_photo.sell,nh_photo.availability1,nh_photo.availability2;
| |
− | where=availability1='Lottie' OR availability1='Wardell' OR availability1='Niko';
| |
− | order by=nh_photo.name_sort;
| |
− | limit=600
| |
− | |tables=nh_item,nh_item_variation;
| |
− | join on=nh_item_variation.en_name = nh_item.en_name;
| |
− | group by=nh_item.en_name;
| |
− | fields=nh_item.en_name=name,nh_item_variation.image,CONCAT('Others')=type,nh_item.buy1_price=buy1-price,nh_item.buy1_wikitext=buy1,nh_item.sell,nh_item.availability1,nh_item.availability2;
| |
− | where=availability1='Wardell' OR availability1='Paradise Planning office';
| |
− | limit=100;
| |
− | |format=template
| |
− | |template=CargoDisplayNHMulti
| |
− | |named args=yes
| |
− | }}
| |
− | {{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
| |
− |
| |
− | ===DIY recipes===
| |
− | The following 22 [[DIY recipes]] that were added in the 2.0 Free Update can only be obtained through the {{HHP|short|nolink}} DLC.
| |
− |
| |
− | {{TableTop NH DIY|name={{HHP|short|nolink}} DIY recipes|collapsed=true}}
| |
− | {{#cargo_query:
| |
− | table=nh_recipe
| |
− | |group by=nh_recipe.en_name
| |
− | |fields=nh_recipe._pageName=pagename,nh_recipe.en_name=name,nh_recipe.num=num,nh_recipe.image,nh_recipe.type,nh_recipe.diy_availability1=availability1,nh_recipe.buy1_price=buy1-price,nh_recipe.buy1_wikitext=buy1,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
| |
− | |where=diy_availability1='Niko'
| |
− | |format=template
| |
− | |order by=nh_recipe.type,nh_recipe.num,nh_recipe.en_name
| |
− | |template=CargoDisplayNHDIY
| |
− | |named args=yes
| |
− | |limit=100
| |
− | }}
| |
− | {{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
| |
− |
| |
− | ===Work-only Paradise Planning items===
| |
− | The following 10 pieces of clothing and 3 mannequins are only available when working for Paradise Planning and cannot be obtained as items.
| |
− | {{TableTop Multi|game=NH|name={{HHP|short|nolink}} work-only Paradise Planning items|collapsed=yes}}
| |
− | {{#cargo_compound_query:
| |
− | tables=nh_clothing,nh_clothing_variation;
| |
− | join on=nh_clothing_variation.en_name = nh_clothing.en_name;
| |
− | group by=nh_clothing.en_name;
| |
− | fields=nh_clothing.en_name=name,nh_clothing_variation.image,CONCAT('Clothing')=type,nh_clothing.buy1_price=buy1-price,nh_clothing.buy1_wikitext=buy1,nh_clothing.sell,nh_clothing.availability1,nh_clothing.availability2;
| |
− | where=availability1='Unobtainable';
| |
− | limit=100
| |
− | |tables=nh_item,nh_item_variation;
| |
− | join on=nh_item_variation.en_name = nh_item.en_name;
| |
− | group by=nh_item.en_name;
| |
− | fields=nh_item.en_name=name,nh_item_variation.image,CONCAT('Others')=type,nh_item.buy1_price=buy1-price,nh_item.buy1_wikitext=buy1,nh_item.sell,nh_item.availability1,nh_item.availability2;
| |
− | where=availability1='Unobtainable';
| |
− | limit=100;
| |
− | |format=template
| |
− | |template=CargoDisplayNHMulti
| |
− | |named args=yes
| |
− | }}
| |
− | {{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
| |
| | | |
| ==Characters== | | ==Characters== |