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		Value	Flag	Name
1	0x0001	Human		2	0x0002	Orc
4	0x0004	Dwarf		16	0x0010	Undead
8	0x0008	Night Elf		32	0x0020	Tauren
64	0x0040	Gnome		128	0x0080	Troll
1024	0x0400	Draenei		512	0x0200	Blood Elf
1101	0x044D	Alliance		690	0x02B2	Horde

 

classMask

Class mask of ChrClass IDs. 0 is all classes.

Value	Flag	Name		Value	Flag	Name
1	0x0001	Warrior		32	0x0020	Death Knight
2	0x0002	Paladin		64	0x0040	Shaman
4	0x0004	Hunter		128	0x0080	Mage
8	0x0008	Rogue		256	0x0100	Warlock
16	0x0010	Priest		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.