Difference between revisions of "Template:NLUmbrellaVillagers"
From Nookipedia, the Animal Crossing wiki
PanchamBro (talk | contribs) |
SuperHamster (talk | contribs) (Checking for frogs using species column instead of umbrella_frog) |
||
Line 1: | Line 1: | ||
− | {{#vardefine: result | {{#cargo_query: table=nl_villager|fields=CONCAT( '[[File:', nl_villager.icon, '|x25px|', nl_villager.name, ']] [[', nl_villager._pageTitle, '|', nl_villager.name, ']]' )|where=nl_villager.umbrella='{{#replace:{{{item|{{#replace:{{#titleparts:{{PAGENAME}}||-1}}|<nowiki/> <nowiki/>(New Leaf)|}}}}}|'|\'}}' AND | + | {{#vardefine: result | {{#cargo_query: table=nl_villager|fields=CONCAT( '[[File:', nl_villager.icon, '|x25px|', nl_villager.name, ']] [[', nl_villager._pageTitle, '|', nl_villager.name, ']]' )|where=nl_villager.umbrella='{{#replace:{{{item|{{#replace:{{#titleparts:{{PAGENAME}}||-1}}|<nowiki/> <nowiki/>(New Leaf)|}}}}}|'|\'}}' AND nl_villager.species!='frog'|limit=300|default=}}}}{{#vardefine: result-house | {{#cargo_query: table=nl_house,nl_villager|join on=nl_villager.name = nl_house.villager|fields=CONCAT( '[[File:', nl_villager.icon, '|x25px|', nl_house.villager, ']] [[', nl_house._pageTitle, '|', nl_house.villager, ']]' )|where=nl_house.items LIKE '%"{{#replace:{{{item|{{#replace:{{#titleparts:{{PAGENAME}}||-1}}|<nowiki/> <nowiki/>(New Leaf)|}}}}}|'|\'}}"%'|limit=300|default=}}}}{{#vardefine: result-rv | {{#cargo_query: table=nlwa_rv|fields=CONCAT( '[[File:', nlwa_rv.icon, '|x25px|', nlwa_rv.name, ']] [[', nlwa_rv._pageTitle, '|', nlwa_rv.name, ']]' )|where=nlwa_rv.items LIKE '%"{{#replace:{{{item|{{#replace:{{#titleparts:{{PAGENAME}}||-1}}|<nowiki/> <nowiki/>(New Leaf)|}}}}}|'|\'}}"%'|limit=300|group by=nlwa_rv._pageTitle|default=}}}}{{#if: {{#var: result}}|This item is used by the following villagers: {{#var: result}}.|No villagers use this item as their default umbrella.}}{{#if: {{#var: result-house}}| This item appears in the homes of the following villagers: {{#var: result-house}}.{{#if: {{#var: result-rv}}| This item also appears in the [[RV]] of the following characters: {{#var: result-rv}}}}|{{#if: {{#var: result-rv}}| This item appears in the [[RV]] of the following characters: {{#var: result-rv}}|}}}}<noinclude>{{clear}}<br>{{Documentation}}[[Category:Cargo templates]]</noinclude> |
Revision as of 20:09, February 18, 2022
No villagers use this item as their default umbrella.
No documentation for Template:NLUmbrellaVillagers exists. Create it.