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 {
  uint32_t m_ID;
  uint32_t m_DisplayPower;
  stringref m_petNameToken;
  stringref m_name_lang;
  stringref m_name_female_lang;
  stringref m_name_male_lang;
  stringref m_filename;
  uint32_t m_spellClassSet;
  uint32_t m_flags;
  uint32_t m_cinematicSequenceID;
  uint32_t m_attackPowerPerStrength;
  uint32_t m_attackPowerPerAgility;
  uint32_t m_rangedAttackPowerPerAgility;
  uint32_t m_defaultSpec;
  uint32_t m_createScreenFileDataID;
  uint32_t m_selectScreenFileDataID;
  uint32_t m_lowResScreenFileDataID;
  uint32_t 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