Difference between revisions of "Rockgarden Theme"

From Nookipedia, the Animal Crossing wiki
m (Text replacement - "pg_interior.en_name=" to "pg_furniture._pageName=page,pg_interior.en_name=")
Line 13: Line 13:
 
|tables=pg_interior;
 
|tables=pg_interior;
 
group by=pg_interior.en_name;
 
group by=pg_interior.en_name;
fields=pg_interior.en_name=name,pg_interior.image=image,CONCAT('Interior')=type,pg_interior.buy,pg_interior.sell,pg_interior.availability1,pg_interior.availability2;
+
fields=pg_furniture._pageName=page,pg_interior.en_name=name,pg_interior.image=image,CONCAT('Interior')=type,pg_interior.buy,pg_interior.sell,pg_interior.availability1,pg_interior.availability2;
 
where=collection='Rock Garden Theme';
 
where=collection='Rock Garden Theme';
 
limit=100
 
limit=100

Revision as of 19:58, May 12, 2021

The Rock Garden Theme is a collection of furniture modeled after a Japanese rock garden and first appears in Doubutsu no Mori. With the exception of the matching wallpaper and carpet which return in Animal Crossing: City Folk, all items from the theme are removed entirely from Animal Crossing: Wild World and all subsequent releases.

Item list

Animal Crossing

Template:TableTop PG Multi

Error 1054: Unknown column 'pg_furniture._pageName' in 'field list' (db.prod.volt.wiki)

Function: CargoSQLQuery::run Query: SELECT `pg_furniture`.`_pageName` AS `page`,`mw_cargo__pg_interior`.`en_name` AS `name`,`mw_cargo__pg_interior`.`image` AS `image`,CONCAT('Interior') AS `type`,`mw_cargo__pg_interior`.`buy` AS `buy`,`mw_cargo__pg_interior`.`sell` AS `sell`,`mw_cargo__pg_interior`.`availability1` AS `availability1`,`mw_cargo__pg_interior`.`availability2` AS `availability2` FROM `mw_cargo__pg_interior` WHERE collection='Rock Garden Theme' GROUP BY `mw_cargo__pg_interior`.`en_name` ORDER BY pg_furniture._pageName,`mw_cargo__pg_interior`.`en_name`,`mw_cargo__pg_interior`.`image`,CONCAT('Interior'),`mw_cargo__pg_interior`.`buy` LIMIT 100


|}