Premium Armor: Difference between revisions

Revision as of 04:01, 4 March 2023

Premium Helmets
Name	Image	Str	Agi	Wis	Luk	WP	Misc	Slots	Source Error: No field named "Source" found for any of the specified database tables.

Retired/Unobtainable Premium Helmets
Name	Image	Str	Agi	Wis	Luk	WP	Misc	Slots	Source Error: No field named "Source" found for any of the specified database tables.

Chat Rings
Name	Image	Str	Agi	Wis	Luk	Def	WP	Misc	Slots	Source Error: No field named "Source" found for any of the specified database tables.

Chat Rings
Name	Image	Str	Agi	Wis	Luk	Def	WP	Misc	Slots	Source Error: No field named "Source" found for any of the specified database tables.

Capes
Name	Image	Str	Agi	Wis	Luk	WP	Misc	Slots	Source Error: No field named "Source" found for any of the specified database tables.

@@ Line 5: / Line 5: @@
 |fields=Items._pageName=Name, Image=Image, Type=type, STR=str, AGI=agi, WIS=wis, LUCK=luck, Reach=reach, MISC=misc, Upgrade=upgrade, Source=source, WeaponPower=weaponpower
 |named args=yes
-|where=type="Premium Helmet" AND NOT Source LIKE "%Unobtainable%" AND NOT Source LIKE "%Retired%"
+|where=type="Premium Helmet" AND NOT (Source LIKE "%Unobtainable%" OR Source LIKE "%Retired%")
 |format=template
 |template=InfoItem/Armorrow
@@ Line 34: / Line 34: @@
 |named args=yes
 |where=type="Chat Ring" AND NOT Source LIKE "%Unobtainable%"
+|format=template
+|template=InfoItem/Armorrow
+|default=
+|order by=SlabOrder.Number
+}}
+|}
+==Retired & Unobtainable Chat Rings==
+{{Armor/head|Chat Rings}}
+{{#cargo_query:tables=Items, SlabOrder
+|join on=Items._pageName=SlabOrder.Item
+|fields=Items._pageName=Name, Image=Image, Type=type, STR=str, AGI=agi, WIS=wis, LUCK=luck, Reach=reach, MISC=misc, Upgrade=upgrade, Source=source, WeaponPower=weaponpower
+|named args=yes
+|where=type="Chat Ring" AND (Source LIKE "%Unobtainable%" OR Source LIKE "%Retired%")
 |format=template
 |template=InfoItem/Armorrow