Difference between revisions of "User:SuperHamster/Sandbox/Silver"
From Nookipedia, the Animal Crossing wiki
< User:SuperHamster | Sandbox
SuperHamster (talk | contribs) |
SuperHamster (talk | contribs) |
||
Line 120: | Line 120: | ||
table=nh_clothing_variations,nh_clothing | table=nh_clothing_variations,nh_clothing | ||
|join on=nh_clothing_variations.en_name = nh_clothing.en_name | |join on=nh_clothing_variations.en_name = nh_clothing.en_name | ||
− | |fields=nh_clothing_variations.en_name=name,nh_clothing_variations.image=image,nh_clothing.buy1_wikitext | + | |fields=nh_clothing_variations.en_name=name,nh_clothing_variations.image=image,nh_clothing.buy1_wikitext,nh_clothing.availability1,nh_clothing.availability2 |
|where=nh_clothing.vill_equip=1 AND nh_clothing.style='{{{favstyle1|Simple}}}' AND nh_clothing_variations.color1='{{{favcolor1|}}}' AND nh_clothing_variations.color2='{{{favcolor2|{{{favcolor1|}}}}}}' {{#if:{{{favcolor2|}}}|OR nh_clothing.vill_equip=1 AND nh_clothing.style='{{{favstyle1|}}}' AND nh_clothing_variations.color1='{{{favcolor2|}}}' AND nh_clothing_variations.color2='{{{favcolor1|}}}'|}} {{#if:{{{favstyle2|}}}|OR nh_clothing.vill_equip=1 AND nh_clothing.style='{{{favstyle2|}}}' AND nh_clothing_variations.color1='{{{favcolor1|}}}' AND nh_clothing_variations.color2='{{{favcolor2|{{{favcolor1|}}}}}}' {{#if:{{{favcolor2|}}}|OR nh_clothing.vill_equip=1 AND nh_clothing.style='{{{favstyle2|}}}' AND nh_clothing_variations.color1='{{{favcolor2|}}}' AND nh_clothing_variations.color2='{{{favcolor1|}}}'|}}|}} | |where=nh_clothing.vill_equip=1 AND nh_clothing.style='{{{favstyle1|Simple}}}' AND nh_clothing_variations.color1='{{{favcolor1|}}}' AND nh_clothing_variations.color2='{{{favcolor2|{{{favcolor1|}}}}}}' {{#if:{{{favcolor2|}}}|OR nh_clothing.vill_equip=1 AND nh_clothing.style='{{{favstyle1|}}}' AND nh_clothing_variations.color1='{{{favcolor2|}}}' AND nh_clothing_variations.color2='{{{favcolor1|}}}'|}} {{#if:{{{favstyle2|}}}|OR nh_clothing.vill_equip=1 AND nh_clothing.style='{{{favstyle2|}}}' AND nh_clothing_variations.color1='{{{favcolor1|}}}' AND nh_clothing_variations.color2='{{{favcolor2|{{{favcolor1|}}}}}}' {{#if:{{{favcolor2|}}}|OR nh_clothing.vill_equip=1 AND nh_clothing.style='{{{favstyle2|}}}' AND nh_clothing_variations.color1='{{{favcolor2|}}}' AND nh_clothing_variations.color2='{{{favcolor1|}}}'|}}|}} | ||
|order by=nh_clothing_variations.en_name | |order by=nh_clothing_variations.en_name |
Revision as of 03:51, June 10, 2020
Ideal Gifts for SuperHamster/Sandbox/Silver – | |||||
---|---|---|---|---|---|
| |||||
|
Example
|
Ideal Gifts for SuperHamster/Sandbox/Silver – (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 = }}