EQEmulator Forums - View Single Post

nosfentora · #2 04-15-2009, 09:24 AM

Code:

SELECT * FROM Items WHERE Classes=<calculate bitmask>
SELECT * FROM Items WHERE Races=<calculate bitmask>

or a combination of the above, where the bitmask to be is taken from the Wiki:

Code:

classes The class or classes can use the item. Remember to add up the results.     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

 IE, Monk (64) + Shaman (512) = 576

Code:

races What race or races can use the item. Rememeber to add up the results.     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

 These are combined values, but with special meaning:     32767 = Any/All
     65535 = Usually a container