Making items non-class specific, questions

Newbie Spellweaver
Joined
Aug 20, 2006
Messages
17
Reaction score
0
Hey, im just wondering what the following categories mean in the items_template table in the SQL database:

class
subclass

I think the numbers you can put there range from 1-15?
 
hi,
class: the class of the items (for example 4=armor)
subclass: the subclass of the item(for example 4=plate)

what you were searching is "AllowableClass", but i dont know the exact values for each class except that -1 means that all can wear it.
 
You use a series of binary switches to determine what class can use that item:
Code:
D  W  M  S  P  R  H  P  W
R  A  A  H  R  O  U  A  A
U  L  G  A  I  G  N  L  R

0  0  0  0  0  0  1  0  0  =  4 = HUNTER
0  0  1  0  0  0  0  0  0  = 64 = MAGE
0  0  0  0  0  0  0  1  1  =  3 = WARRIOR + PALADIN


NOTE: You can use calculator to convert from binary to decimal.
 
You use a series of binary switches to determine what class can use that item:
Code:
D  W  M  S  P  R  H  P  W
R  A  A  H  R  O  U  A  A
U  L  G  A  I  G  N  L  R

0  0  0  0  0  0  1  0  0  =  4 = HUNTER
0  0  1  0  0  0  0  0  0  = 64 = MAGE
0  0  0  0  0  0  0  1  1  =  3 = WARRIOR + PALADIN
NOTE: You can use calculator to convert from binary to decimal.

that sounds too smart for me :D

class: the class of the items (for example 4=armor)
subclass: the subclass of the item(for example 4=plate)

can you expand more on this? I mean, what are the choices, like 1-15, does 1 = sword, etc....
 
You use a series of binary switches to determine what class can use that item:
Code:
D  W  M  S  P  R  H  P  W
R  A  A  H  R  O  U  A  A
U  L  G  A  I  G  N  L  R

0  0  0  0  0  0  1  0  0  =  4 = HUNTER
0  0  1  0  0  0  0  0  0  = 64 = MAGE
0  0  0  0  0  0  0  1  1  =  3 = WARRIOR + PALADIN
NOTE: You can use calculator to convert from binary to decimal.

This is VERY easy and simple. I'l explain a bit better:
9 = Druid, 8 = Warlock, 7 = Mage, 6 = Shaman, 5 = Priest, 4 = Rogue, 3 = Hunter, 2 = Paladin, 1 = Warrior
The binary code is arranged like this:
9 8 7 6 5 4 3 2 1
All you do is, if you want a certain class to be able to wear an item, place a "1" in it's slot (in the above arrangement), then replace all others with 0. Then, open calculator, click on "View", then click "Scientific".
You'll then see 4 radio boxes (Hex, Dec, Oct, Bin). Select "Bin", type in the binary code, then click on "Dec". Then, you can use the resulting number in the "RequiredClass" column in your database.
 
Back