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

From Nookipedia, the Animal Crossing wiki
Line 11: Line 11:
 
! style="background-color:#FFFFCC; color:#444444;" | Price
 
! style="background-color:#FFFFCC; color:#444444;" | Price
 
! style="background-color:#FFFFCC; color:#444444; {{roundyright}}" | Available From
 
! style="background-color:#FFFFCC; color:#444444; {{roundyright}}" | Available From
{{#switch: {{{game|}}}
+
<noinclude>|-
 +
|</noinclude>{{#switch: {{{game|}}}
 
|WW={{Ideal Clothing|{{{favclothing|}}}}}
 
|WW={{Ideal Clothing|{{{favclothing|}}}}}
 
|CF={{Ideal Furniture/{{{favgenre|}}}|{{{favcolor|}}}}}
 
|CF={{Ideal Furniture/{{{favgenre|}}}|{{{favcolor|}}}}}
 
|NL={{Ideal Gifts/{{{favclothing|}}}|{{{favcolor|}}}}}
 
|NL={{Ideal Gifts/{{{favclothing|}}}|{{{favcolor|}}}}}
 
|NH={{#cargo_query:
 
|NH={{#cargo_query:
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{{=}}buy1,nh_clothing.availability1,nh_clothing.availability2
+
|fields=nh_clothing_variations.en_name=name,nh_clothing_variations.image=image,nh_clothing.buy1_wikitext=buy1,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|}}}'|}}|}}
+
|order by=nh_clothing_variations.en_name
|order by{{=}}nh_clothing_variations.en_name
+
|format=template
|format{{=}}template
+
|template=Ideal NH Gifts Navigate‎‎
|template{{=}}Ideal NH Gifts Navigate‎‎
+
|named args=yes
|named args{{=}}yes
+
|limit=100
|limit{{=}}100
 
 
}}
 
}}
 
}}
 
}}

Revision as of 03:44, June 10, 2020