Difference between revisions of "User:SuperHamster/Sandbox/Pink"

From Nookipedia, the Animal Crossing wiki
(Creating test to list villagers whose houses have an item)
Line 1: Line 1:
{{#vardefine: result | {{#cargo_query: table={{{game|}}}_house|fields=CONCAT( '[[File:', {{{game|}}}_house.villager, ' {{uc:{{{game|}}}}} Villager Icon.png|25px|', {{{game|}}}_house.villager, ']] [[', {{{game|}}}_house.villager, ']]' )|where={{{game|}}}_house.items LIKE '%"{{#replace:{{#titleparts:{{PAGENAME}}||-1}}|<nowiki> </nowiki>(New Horizons)|}}"%'|limit=300|default=}}}}
+
{{#cargo_query: table={{{game|}}}_house|fields=CONCAT( '[[File:', {{{game|}}}_house.villager, ' {{uc:{{{game|}}}}} Villager Icon.png|25px|', {{{game|}}}_house.villager, ']] [[', {{{game|}}}_house.villager, ']]' )|where={{{game|}}}_house.items LIKE '%"{{#replace:{{#titleparts:{{PAGENAME}}||-1}}|<nowiki> </nowiki>(New Horizons)|}}"%'|limit=300|default=No villagers have this item in their home.}}
{{#if: {{#var: result}} | This item appears in the homes of {{#var: result}} | No villagers have this item in their homes.}}
 

Revision as of 23:47, September 10, 2020

Error: Table _house not found.