Miscellaneous: SK items being GNM usable

[happyhappy]

Gnomes should never be tagged as a playable race for any Shadowknight only item.

------------------------------
March 19, 2002
------------------------------

- Halflings and Gnomes have new classes available to them: Halfling
Rangers and Paladins as well as Gnome ShadowKnights and Paladins. All
of the necessary NPCs and items should be available for these new
classes

[SamwiseRed]

this is well known, maybe you should list the items you are reporting?

[ForeverLost]

They left gnomes on the items because they are going to allow those race/class combinations in the future.

(I can hope, right??)

[happyhappy]

Blood Ember Armor
Darkforge Armor
Planar Armor
Will of Innoruuk
Head of the Valiant

There's not a million pîeces of SK only armor.

[nilbog]

Not enough coffee to fix this yet.

If

0 = None
1 = Warrior
2 = Cleric
4 = Paladin
8 = Ranger
16 = Shadow Knight
32 = Druid
64 = Monk
128 = Bard
256 = Rogue
512 = Shaman
1024 = Necromancer
2048 = Wizard
4096 = Magician
8192 = Enchanter
16384 = Beastlord
32768 = Berserker
65535 = Any/All

and

0 = None
1 = Human
2 = Barbarian
4 = Erudite
8 = ELF
16 = HIE
32 = Dark Elf
64 = HEF
128 = Dwarf
256 = Troll
512 = Ogre
1024 = HFL
2048 = Gnome
4096 = Iksar
8192 = Vah Shir
16384 = Froglok
32768 = Shroud

bitmask fun

select id,name,classes,races from items where (classes = 16) and (races = races | 2048) and (races not in (2048,65535,32767))

Record 124 of 124

2099    Soulfiend Lance    16    6949
2100    Grimy Lance    16    6949
2328    Belt of Flesh Hooks    16    6945
2578    Spirit Reaver    16    6949
3140    Darkforge Helm    16    2853
3141    Darkforge Breastplate    16    2853
3142    Darkforge Vambraces    16    2853
3143    Darkforge Bracer    16    2853
3144    Darkforge Gauntlets    16    2853
3145    Darkforge Greaves    16    2853
3146    Darkforge Boots    16    2853
4522    Blood Ember Helm    16    2853
4523    Blood Ember Breastplate    16    2853
4524    Blood Ember Vambraces    16    2853
4525    Blood Ember Bracer    16    2853
4526    Blood Ember Gauntlets    16    2853
4527    Blood Ember Greaves    16    2853
4528    Blood Ember Boots    16    2853
4841    Umbral Platemail Helm    16    2853
4842    Umbral Platemail Breastplate    16    2853
4843    Umbral Platemail Vambraces    16    2853
4844    Umbral Platemail Bracer    16    2853
4845    Umbral Platemail Gauntlets    16    2853
4846    Umbral Platemail Greaves    16    2853
4847    Umbral Platemail Boots    16    2853
5127    Greenmist    16    6949
5370    Broadsword of the Void    16    2085
5374    Reaper of the Dead    16    6949
5391    Blood Riven Axe    16    6949
5506    Sword of the Undead Kings    16    6949
5751    Shai`din Life Harvester    16    6949
7489    Gauntlets of the Blood Fiend    16    6949
8427    Desecrated Two Handed Sword    16    6949
9402    Ashenbone Shield    16    6181
9961    Ghoulbane of Twisted Knights    16    6949
10891    Gravebinder    16    6949
10902    Rotwood Club    16    6948
11558    Bloodmoon    16    2085
11678    Obtenebrate Mithril Guard    16    6949
12153    Rage War Maul    16    7013
12705    Crusader's Coffin    16    6949
14367    Corrupted Ghoulbane    16    6949
14369    Head of the Valiant    16    6949
14370    Will of Innoruuk    16    6949
14383    Innoruuk's Curse    16    6949
22834    Sentient Helm    16    2853
22835    Sentient Breastplate    16    2853
22836    Sentient Vambraces    16    2853
22837    Sentient Bracer    16    2853
22839    Sentient Gauntlets    16    2853
22840    Sentient Greaves    16    2853
22841    Sentient Plate Boots    16    2853
24707    Ivory Handled Falchion    16    6949
24891    Sentient Two-Handed Axe    16    6949
25064    Boots of Dark Passage    16    2853
25319    Sword of Pain    16    6949
25349    Malevolent Crown    16    6949
25350    Malevolent Breastplate    16    6949
25351    Malevolent Vambraces    16    6949
25352    Malevolent Bracer    16    6949
25353    Malevolent Gauntlets    16    7029
25354    Malevolent Greaves    16    6965
25355    Malevolent Boots    16    6949
25451    Noctivagant Crown    16    6949
25452    Noctivagant Breastplate    16    6949
25453    Noctivagant Vambraces    16    6949
25454    Noctivagant Bracer    16    6949
25455    Noctivagant Gauntlets    16    6949
25456    Noctivagant Greaves    16    6949
25457    Noctivagant Boots    16    6949
25606    Stalagterror Spine Spear    16    6949
26224    Medium Shadowknight Helm    16    6949
26246    Medium Shadowknight Mask    16    6949
26247    Medium Shadowknight Collar    16    6949
26248    Medium Shadowknight Breastplate    16    6949
26249    Medium Shadowknight Pauldron    16    6949
26250    Medium Shadowknight Cloak    16    6949
26251    Medium Shadowknight Girdle    16    6949
26252    Medium Shadowknight Vambraces    16    6949
26253    Medium Shadowknight Bracers    16    6949
26254    Medium Shadowknight Gauntlets    16    6949
26255    Medium Shadow Knight Greaves    16    6949
26256    Medium Shadow Knight Boots    16    6949
26377    Heavy Shadowknight Helm    16    6949
26378    Heavy Shadowknight Mask    16    6949
26379    Heavy Shadowknight Collar    16    6949
26380    Heavy Shadowknight Breastplate    16    6949
26381    Heavy Shadowknight Pauldron    16    6949
26382    Heavy Shadowknight Cloak    16    6949
26383    Heavy Shadowknight Girdle    16    6949
26384    Heavy Shadowknight Vambraces    16    6949
26385    Heavy Shadowknight Bracers    16    6949
26386    Heavy Shadowknight Gauntlets    16    6949
26387    Heavy Shadowknight Greaves    16    6949
26388    Heavy Shadowknight Boots    16    6949
29201    Shield of Shadows    16    6949
31000    Dark Runed Crown    16    6949
31001    Dark Runed Breastplate    16    6949
31002    Dark Runed Vambraces    16    6949
31003    Dark Runed Bracer    16    6949
31004    Dark Runed Gauntlets    16    6949
31005    Dark Runed Greaves    16    6949
31006    Dark Runed Boots    16    6965
31098    Blood Lord's Crown    16    6949
31099    Blood Lord's Breastplate    16    6949
31100    Blood Lord's Vambraces    16    6949
31101    Blood Lord's Bracer    16    6949
31102    Blood Lord's Gauntlets    16    6949
31103    Blood Lord's Greaves    16    6949
31104    Blood Lord's Boots    16    6949
31515    Custom Dark Runed Crown    16    6949
31520    Custom Malevolent Crown    16    6949
31525    Custom Blood Lord's Crown    16    6949
36221    Blade of Cazic Thule    16    6949
46091    Fabled Shield of Shadows    16    6949
48136    Innoruuk's Dark Blessing    16    6949
50003    Innoruuk's Voice    16    6949
80528    Tainted Energeiac Plate Bracer    16    6949
80529    Tainted Energeiac Plate Gauntlets    16    6949
80530    Tainted Energeiac Plate Boots    16    6949
80531    Tainted Energeiac Plate Helm    16    6949
80532    Tainted Energeiac Plate Vambraces    16    6949
80533    Tainted Energeiac Plate Greaves    16    6949
80672    Pike of the Vampire God    16    6949

?
update items set races = (races - 2048) where (classes = 16) and (races = races | 2048) and (races not in (2048,32767,65535))

More coffee needed, but this should get them all. Will need to do the same for gnome paladins, halfling paladins, halfling rangers

[happyhappy]

saw your query returned Greenmist, Greenmist needs to be IKS only.

http://web.archive.org/web/200112111...html?item=7029

[nilbog]

Coffee complete; query worked fine.

Gnomes removed from all shadowknight only items.

[nilbog]

Fixed, pending update.

-Gnome race removed from shadowknight or paladin only items.
-Halfling race removed from paladin or ranger only items.

[Xadion]

All those gnome / halfling pally rangers and sks are going to be very sad pandas... wait...umm.... ;-)