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 | + | |fields=nh_clothing_variations.en_name=name,nh_clothing_variations.image=image,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:52, 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 =
}}
