Difference between revisions of "Template:Villager Info"
From Nookipedia, the Animal Crossing wiki
m (testing for vills not available in NH) |
SuperHamster (talk | contribs) m (Text replacement - "nh_clothing_variations" to "nh_clothing_variation") |
||
Line 162: | Line 162: | ||
|NL={{Ideal Gifts/{{{favclothing|}}}|{{{favcolor|}}}}} | |NL={{Ideal Gifts/{{{favclothing|}}}|{{{favcolor|}}}}} | ||
|NH={{#cargo_query: | |NH={{#cargo_query: | ||
− | table= | + | table=nh_clothing_variation,nh_clothing |
− | |join on= | + | |join on=nh_clothing_variation.en_name = nh_clothing.en_name |
− | |fields= | + | |fields=nh_clothing_variation.en_name=name,nh_clothing_variation.variation,nh_clothing_variation.image=image,nh_clothing.buy1_price=buy,nh_clothing.buy1_currency=currency,nh_clothing.availability1,nh_clothing.availability2 |
− | |where=nh_clothing.vill_equip=1 AND nh_clothing.style='{{{favstyle1|Simple}}}' AND | + | |where=nh_clothing.vill_equip=1 AND nh_clothing.style='{{{favstyle1|Simple}}}' AND nh_clothing_variation.color1='{{{favcolor1|}}}' AND nh_clothing_variation.color2='{{{favcolor2|{{{favcolor1|}}}}}}' {{#if:{{{favcolor2|}}}|OR nh_clothing.vill_equip=1 AND nh_clothing.style='{{{favstyle1|}}}' AND nh_clothing_variation.color1='{{{favcolor2|}}}' AND nh_clothing_variation.color2='{{{favcolor1|}}}'|}} {{#if:{{{favstyle2|}}}|OR nh_clothing.vill_equip=1 AND nh_clothing.style='{{{favstyle2|}}}' AND nh_clothing_variation.color1='{{{favcolor1|}}}' AND nh_clothing_variation.color2='{{{favcolor2|{{{favcolor1|}}}}}}' {{#if:{{{favcolor2|}}}|OR nh_clothing.vill_equip=1 AND nh_clothing.style='{{{favstyle2|}}}' AND nh_clothing_variation.color1='{{{favcolor2|}}}' AND nh_clothing_variation.color2='{{{favcolor1|}}}'|}}|}} |
− | |order by= | + | |order by=nh_clothing_variation.en_name |
|format=template | |format=template | ||
|template=Ideal NH Gifts Navigate | |template=Ideal NH Gifts Navigate |
Revision as of 01:43, August 6, 2020
Ideal Gifts for Villager Info – | |||||
---|---|---|---|---|---|
| |||||
|
Example
|
Ideal Gifts for Villager Info – (Favorite Color) (Favorite) | ||||
---|---|---|---|---|
| ||||
|
Usage
For Animal Crossing: Wild World
{{Villager Info |game = WW |pic = |quote = |favclothing = |leastfavclothing = }}
For Animal Crossing: City Folk
{{Villager Info |game = CF |favclothing = |leastfavclothing = |favgenre = |favseries = |favcolor = }}
For Animal Crossing: New Leaf
{{Villager Info |game = NL |pic = |quote = |siblings = |skill = |goal = |fear = |favclothing = |leastfavclothing = |favcolor = |coffeetype = |milk = |sugar = }}
For Animal Crossing: New Horizons
{{Villager Info |game = NH |pic = |quote = |favstyle1 = |favstyle2 = |favcolor1 = |favcolor2 = }}