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/20011211191121/http://everquest.allakhazam.com/db/item.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.... ;-)