Difference between revisions of "Furniture customization/New Leaf"
PanchamBro (talk | contribs) (Converting New Leaf list to cargo) Tag: Replaced |
PanchamBro (talk | contribs) m |
||
| Line 8: | Line 8: | ||
|join on=nl_furniture_variation.en_name = nl_furniture.en_name | |join on=nl_furniture_variation.en_name = nl_furniture.en_name | ||
|group by=nl_furniture.en_name | |group by=nl_furniture.en_name | ||
| − | |fields=nl_furniture._pageName=pagename,nl_furniture.en_name=name,nl_furniture_variation.image | + | |fields=nl_furniture._pageName=pagename,nl_furniture.en_name=name,nl_furniture_variation.image,nl_furniture.custom_body_part=body-part,custom_pattern_part=pattern-part,nl_furniture.customizable_variation=variation,nl_furniture.customizable_pattern=pattern,nl_furniture.customization_price=price |
|order by=nl_furniture.category_sort,nl_furniture.catalog_num | |order by=nl_furniture.category_sort,nl_furniture.catalog_num | ||
|where=nl_furniture.customizable = 1 | |where=nl_furniture.customizable = 1 | ||
Revision as of 07:34, January 5, 2023
The following is a list of items that can be customized in Animal Crossing: New Leaf by Cyrus.
Customizable furniture in Animal Crossing: New Leaf
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__nl_furniture`.`_pageName` AS `pagename`,`mw_cargo__nl_furniture`.`en_name` AS `name`,`mw_cargo__nl_furniture_variation`.`image` AS `image`,`mw_cargo__nl_furniture`.`custom_body_part` AS `body-part`,`custom_pattern_part` AS `pattern-part`,`mw_cargo__nl_furniture`.`customizable_variation` AS `variation`,`mw_cargo__nl_furniture`.`customizable_pattern` AS `pattern`,`mw_cargo__nl_furniture`.`customization_price` AS `price` FROM `mw_cargo__nl_furniture` LEFT OUTER JOIN `mw_cargo__nl_furniture_variation` ON ((`mw_cargo__nl_furniture`.`en_name`=`mw_cargo__nl_furniture_variation`.`en_name`)) WHERE `mw_cargo__nl_furniture`.`customizable` = 1 GROUP BY `mw_cargo__nl_furniture`.`en_name` ORDER BY `mw_cargo__nl_furniture`.`category_sort`,`mw_cargo__nl_furniture`.`catalog_num` LIMIT 602
| Item | Image | Customization price | Body part | Pattern |
|---|
