DB/ChrClasses

Header Info

Records....................10
Fields.....................60
Record Size...............240
String Block Size.........160

9183

Column	Field	Type	Notes
0	ID	Integer
1	Unknown	Integer	Hunter,Shaman and Rogue got 1, Deathknight 9; others 0 -- seems to be removed in cataclysm.
2	PowerType	Integer	0 = Mana, 1 = Rage, 2 = Focus, 3 = Energy, 4 = Happiness, 6 = Runes
3	DisplayPower	String	Pet type. Warlock is 101 (DEMON) while all other classes are 1 (PET).
4-20	Name	Loc
21-37	Name_female	Loc
38-54	Name_male	Loc
55	fileName	String	in CAPS, english
56	spellClassSet	Integer	See below.
57	Flags	Integer	See below.
58	Camera	iRefID	Used for the opening cinematic. Only Deathknight has 165, others got 0
59	required_expansion	Integer	0=WoW, 1=TBC, 2=Wotlk

6.0.1.18179

struct ChrClassesRec {
  int m_ID;
  int m_DisplayPower;
  stringref m_petNameToken;
  stringref m_name_lang;
  stringref m_name_female_lang;
  stringref m_name_male_lang;
  stringref m_filename;
  int m_spellClassSet;
  int m_flags;
  int m_cinematicSequenceID;
  int m_attackPowerPerStrength;
  int m_attackPowerPerAgility;
  int m_rangedAttackPowerPerAgility;
  int m_defaultSpec;
  int m_createScreenFileDataID;
  int m_selectScreenFileDataID;
  int m_lowResScreenFileDataID;
  int m_iconFileDataID;
};

Flags

0b00100000 - Can wear plate 
0b00010000 - Can wear mail 
0b00001000 - UsesRelicSlot / Can switch aura
0b00000100 - Can summon pet
0b00000010 - Can wear cloth 
0b00000001 - Can wear leather

spellClassSet

   SPELLFAMILY_GENERIC     = 0,
   SPELLFAMILY_UNK1        = 1,                            // events, holidays
   // 2 - unused
   SPELLFAMILY_MAGE        = 3,
   SPELLFAMILY_WARRIOR     = 4,
   SPELLFAMILY_WARLOCK     = 5,
   SPELLFAMILY_PRIEST      = 6,
   SPELLFAMILY_DRUID       = 7,
   SPELLFAMILY_ROGUE       = 8,
   SPELLFAMILY_HUNTER      = 9,
   SPELLFAMILY_PALADIN     = 10,
   SPELLFAMILY_SHAMAN      = 11,
   SPELLFAMILY_UNK2        = 12,                           // 2 spells (silence resistance)
   SPELLFAMILY_POTION      = 13,
   // 14 - unused
   SPELLFAMILY_DEATHKNIGHT = 15,
   // 16 - unused
   SPELLFAMILY_PET         = 17

additional fields with cataclysm

   m_attackPowerPerStrength; // +0x2C, size 0x4, type 0
   m_attackPowerPerAgility; // +0x30, size 0x4, type 0
   m_rangedAttackPowerPerAgility; // +0x34, size 0x4, type 0