|
|
(4 intermediate revisions by the same user not shown) |
Line 1: |
Line 1: |
− | {{DISPLAYTITLE:List of items purchasable with Poki}} | + | {{DISPLAYTITLE:List of items purchasable with Poki in {{HHP|short|nolink}}}} |
− | The following is a '''list of items purchasable with Poki'''. | + | The following is a ''' list of items purchasable with Poki''' in {{HHP}}. |
| | | |
− | {{TableTop NH Multi|name=Items purchasable with Poki}}
| + | Due to technical limitations, the page has been split into four different sections. |
− | {{#cargo_query:
| + | <gallery> |
− | |tables=nh_furniture,nh_furniture_variation | + | Paradise Planning Hammock NH Icon.png|[[Poki/Items purchasable with Poki/Furniture|Furniture]]|link=Poki/Items purchasable with Poki/Furniture |
− | |join on=nh_furniture_variation.en_name = nh_furniture.en_name | + | DJ KK Logo Tee (Neon Blue) NH Icon.png|[[Poki/Items purchasable with Poki/Clothing|Clothing]]|link=Poki/Items purchasable with Poki/Clothing |
− | |group by=nh_furniture.en_name
| + | Paradise Planning Wall NH Icon.png|[[Poki/Items purchasable with Poki/Interior|Interior]]|link=Poki/Items purchasable with Poki/Interior |
− | |fields=nh_furniture._pageName=pagename,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.buy2_wikitext=buy2,nh_furniture.sell,nh_furniture.availability1,nh_furniture.availability2
| + | Paradise Planning Case NH Icon.png|[[Poki/Items purchasable with Poki/Other items|Other items]]|link=Poki/Items purchasable with Poki/Other items |
− | |where=nh_furniture.buy1_currency="Poki" OR nh_furniture.buy2_currency="Poki" | + | </gallery> |
− | |limit=1500 | |
− | |format=template | |
− | |template=CargoDisplayNHMulti
| |
− | |named args=yes
| |
− | }}
| |
− | {{#cargo_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.buy2_wikitext=buy2,nh_clothing.sell,nh_clothing.availability1,nh_clothing.availability2
| |
− | |where=nh_clothing.buy1_currency="Poki" OR nh_clothing.buy2_currency="Poki" | |
− | |limit=1000
| |
− | |format=template
| |
− | |template=CargoDisplayNHMulti
| |
− | |named args=yes | |
− | }}
| |
− | {{#cargo_query:
| |
− | |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.buy2_wikitext=buy2,nh_interior.sell,nh_interior.availability1,nh_interior.availability2
| |
− | |where=nh_interior.buy1_currency="Poki" OR nh_interior.buy2_currency="Poki" | |
− | |limit=600
| |
− | |format=template
| |
− | |template=CargoDisplayNHMulti
| |
− | |named args=yes
| |
− | }}
| |
− | {{#cargo_query:
| |
− | |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=nh_item.buy1_currency="Poki" OR nh_item.buy2_currency="Poki" AND is_fence='0' AND is_material='0' | |
− | |limit=1000
| |
− | |format=template
| |
− | |template=CargoDisplayNHMulti
| |
− | |named args=yes
| |
− | }}
| |
− | {{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
| |
| | | |
| [[Category:Lists]] | | [[Category:Lists]] |