Difference between revisions of "Furniture customization/New Horizons"
PanchamBro (talk | contribs) m |
PanchamBro (talk | contribs) (adding displaytitle and changing where conditions) |
||
| Line 1: | Line 1: | ||
| + | {{DISPLAYTITLE:List of items that are customizable}} | ||
The following is a '''list of items that can be customized''' by either the player or by [[Cyrus]]. | The following is a '''list of items that can be customized''' by either the player or by [[Cyrus]]. | ||
| Line 7: | Line 8: | ||
join on=nh_furniture_variation.en_name = nh_furniture.en_name; | join on=nh_furniture_variation.en_name = nh_furniture.en_name; | ||
group by=nh_furniture.en_name; | group by=nh_furniture.en_name; | ||
| − | fields=nh_furniture._pageName=pagename,nh_furniture.en_name=name,nh_furniture_variation.image | + | fields=nh_furniture._pageName=pagename,nh_furniture.en_name=name,nh_furniture_variation.image,nh_furniture.custom_kits=kits,nh_furniture.custom_body_part=body-part,custom_pattern_part=pattern-part,nh_furniture.customizable_variation=variation,nh_furniture.customizable_pattern=pattern,nh_furniture.cyrus_price=price,nh_furniture.custom_kit_type=type; |
order by=nh_furniture.category_sort,nh_furniture.en_name; | order by=nh_furniture.category_sort,nh_furniture.en_name; | ||
| − | where= | + | where=nh_furniture.cyrus_price NOT NULL; |
| + | limit=2000; | ||
|format=template | |format=template | ||
|template=CargoDisplayNHCustomizable | |template=CargoDisplayNHCustomizable | ||
|named args=yes | |named args=yes | ||
| − | |||
}} | }} | ||
{{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}} | {{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}} | ||
[[Category:Lists]] | [[Category:Lists]] | ||
Revision as of 16:30, December 28, 2021
The following is a list of items that can be customized by either the player or by Cyrus.
Customizable furniture in Animal Crossing: New Horizons
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__nh_furniture`.`_pageName` AS `pagename`,`mw_cargo__nh_furniture`.`en_name` AS `name`,`mw_cargo__nh_furniture_variation`.`image` AS `image`,`mw_cargo__nh_furniture`.`custom_kits` AS `kits`,`mw_cargo__nh_furniture`.`custom_body_part` AS `body-part`,`custom_pattern_part` AS `pattern-part`,`mw_cargo__nh_furniture`.`customizable_variation` AS `variation`,`mw_cargo__nh_furniture`.`customizable_pattern` AS `pattern`,`mw_cargo__nh_furniture`.`cyrus_price` AS `price`,`mw_cargo__nh_furniture`.`custom_kit_type` AS `type` FROM `mw_cargo__nh_furniture` LEFT OUTER JOIN `mw_cargo__nh_furniture_variation` ON ((`mw_cargo__nh_furniture`.`en_name`=`mw_cargo__nh_furniture_variation`.`en_name`)) WHERE `mw_cargo__nh_furniture`.`cyrus_price` NOT NULL GROUP BY `mw_cargo__nh_furniture`.`en_name` ORDER BY `mw_cargo__nh_furniture`.`category_sort`,`mw_cargo__nh_furniture`.`en_name` LIMIT 2000
| Item | Image | Customization requirements | Body part | Pattern |
|---|
