character_action

Back-to:Characters

The `character_action` table

Contains all the individual button data for each character. A button is any of the places in the GUI where you can place for example a spell, item, or macro as a shortcut.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
guid	int(10)	unsigned	PRI	NO	0
spec	tinyint(3)	unsigned	PRI	NO	0
button	tinyint(3)	unsigned	PRI	NO	0
action	int(10)	unsigned		NO	0
type	tinyint(3)	unsigned		NO	0

Description of the fields

guid

The GUID of the character. See characters.guid

spec

spec = 0 is the first spec, spec = 1 is the second spec.

button

The ID of the button on the action bar where the action icon will be placed.

Special bars are used for stances, auras, pets, stealth, and other similar special modes.

Possible values

Button IDs	Set (key)
1-11	1 (SHIFT + 1)
12-23	2 (SHIFT + 2)
24-35	3 (SHIFT + 3) h1. Right Side Bar
36-47	4 (SHIFT + 4) Right Side Bar 2
48-59	5 (SHIFT + 5) h1. Bottom Right Bar
60-71	6 (SHIFT + 6) Bottom Left Bar
72-83	1 SpecialA
84-95	1 SpecialB
96-107	1 SpecialC
108-119	1 SpecialD

action

Depending on the type value, this could be either the spell ID (Spell.dbc), the item ID or macro ID.

type

The type of action:

Possible types

0	Spell
1	Click
32	Eq set
64	Macro
65	Click macro
128	Item