playercreateinfo_cast_spell

This table holds information on spells a new character casts when he logs in for the first time. Each race-class combination can have a different set of spells to cast.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
raceMask	int	unsigned		NO	0
classMask	int	unsigned		NO	0
spell	int	unsigned		NO	0
note	varchar(255)			YES	NULL

Description of fields

raceMask

Race mask of ChrRace IDs. 0 is all races.

Value	Flag	Name
1	0x0001	Human
2	0x0002	Orc
4	0x0004	Dwarf
8	0x0008	Night Elf
16	0x0010	Undead
32	0x0020	Tauren
64	0x0040	Gnome
128	0x0080	Troll
512	0x0200	Blood Elf
1024	0x0400	Draenei

 

classMask

Class mask of ChrClass IDs. 0 is all classes.

Value	Flag	Name
1	0x0001	Warrior
2	0x0002	Paladin
4	0x0004	Hunter
8	0x0008	Rogue
16	0x0010	Priest
32	0x0020	Death Knight
64	0x0040	Shaman
128	0x0080	Mage
256	0x0100	Warlock
1024	0x0400	Druid

 

spell

Spell ID to cast on first log in.  

note

This field is for any comment you want to make. It is arbitrary text.